| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> A deadlock among DDL and parse locks is detected.
???????????????????????????*???????????????????????*????????????????????cann't able to do any DML/DDL operations, if so the system
????????????????????????????????????????????????????????????????????????
????????????????????????????????????????????????????????????????????????
????????????????????????????????????????????????????????????????????????
????????????????????????????????????????????????????????????????????????
????????????????????????????????????????????????????????????????????????
????????????????????????????????????????????????????????????????????????
????????????????????????????????????????????????????????????????????????
????????????????????????????????????????????????????????????????????????
????????????????????????????????????????????????????????????????????????
????????????????????????????????????????????????????????????????????????
????????????????????????????????????????????????????????????????????????
????????????????????????????????????????????????????????????????????????
????????????????????????????????????????????????????????????????????????
????????????????????????????????????????????????????????????????????????
????????????????????????????????????????????????????????????????????????
????????????????????????????????????????????????????????????????????????
????????????????????????????????????????????????????????????????????????
????????????????????????????????????????????????????????????????????????
????????????????????????????????????????????????????????????????????????
????????????????????????????????????????????????????????????????????????
????????????????????????????????????????????????????????????????????????
????????????????????????????????????????????????????????????????????????
????????????????????????????????????????????????????????????????????????
????????????????????'???????????????????????????????????????????????????
????????????????????????????????????????????????????????????????????????
????????'???????????????????????????????????????????????????????????????
????????????????????????????????????????????????????????????????????????
????????????????????????????????. After this process, in this schema I
Hanged up, and then I noticed the following trace file in udump folder. How I can release the dead lock which has been
Occurred during the process.
Even I tried to export the schema and imported with other name, still it's hanging up.
Pls let me know ur ideas.
REGARDS, Nirmal
TRACE FILE
Dump file E:\oracle\admin\HOSC817\udump\ORA00332.TRC
Tue Jul 08 11:59:20 2003
ORACLE V8.1.7.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 Service Pack 2, CPU type 586
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
Windows 2000 Version 5.0 Service Pack 2, CPU type 586
Instance name: hosc817
Redo thread mounted by this instance: 1
Oracle process number: 28
Windows thread id: 332, image: ORACLE.EXE
This deadlock is usually due to user errors in
the design of an application or from issuing a set
of concurrent statements which can cause a deadlock.
This should not be reported to Oracle Support.
The following information may aid in finding
the errors which cause the deadlock:
ORA-04020: deadlock detected while trying to lock object HOSCDPAYTEST.NP_PAYROLL_PROCESS
object waiting waiting blocking blocking
handle session lock mode session lock mode
9cf90e8 a8bf2ec bba1600 X a8bf2ec bbfca04 S
SO: bba1600, type: 35, owner: ba63094, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=bba1600 handle=9cf90e8 request=X
call pin=0 session pin=0
user=a8bf2ec session=a8bf2ec count=0 flags=[00] savepoint=860
LIBRARY OBJECT HANDLE: handle=9cf90e8
name=HOSCDPAYTEST.NP_PAYROLL_PROCESS
hash=e9378fe4 timestamp=07-06-2003 14:15:19
namespace=TABL/PRCD/TYPE flags=KGHP/TIM/SML/[02000000]
kkkk-dddd-llll=0000-0015-0015 lock=S pin=S latch=1
lwt=9cf9100[bba1610,bba1610] ltm=9cf9108[9cf9108,9cf9108]
pwt=9cf9118[9cf9118,9cf9118] ptm=9cf9170[9cf9170,9cf9170]
ref=9cf90f0[9cf90f0,9cf90f0] lnd=9cf917c[9cf917c,9cf917c]
LOCK OWNERS: lock user session count mode flags
bbfca04 a8bf2ec a8bf2ec 1 S PNC/[04]
LOCK WAITERS: lock user session count mode
bba1600 a8bf2ec a8bf2ec 0 X
LIBRARY OBJECT: object=4f89f14
type=PRCD flags=EXS/LOC[0005] pflags=NST [01] status=INVL load=0
DEPENDENCIES: count=41 size=48
READ ONLY DEPENDENCIES: count=58 size=64
ACCESSES: count=47 size=48
DATA BLOCKS: data# heap pointer status pins change
0 4f8cdb0 4f89ff8 I/P/A 0 NONE
2 4f89fa8 30478c8 I/P/A 1 NONE
4 9d91af8 9ca8c4c I/-/A 0 NONE
SO: bbfca04, type: 35, owner: bbee5ac, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=bbfca04 handle=9cf90e8 mode=S
call pin=bbfab08 session pin=0
user=a8bf2ec session=a8bf2ec count=1 flags=PNC/[04] savepoint=369
LIBRARY OBJECT HANDLE: handle=9cf90e8
name=HOSCDPAYTEST.NP_PAYROLL_PROCESS
hash=e9378fe4 timestamp=07-06-2003 14:15:19
namespace=TABL/PRCD/TYPE flags=KGHP/TIM/SML/[02000000]
kkkk-dddd-llll=0000-0015-0015 lock=S pin=S latch=1
lwt=9cf9100[bba1610,bba1610] ltm=9cf9108[9cf9108,9cf9108]
pwt=9cf9118[9cf9118,9cf9118] ptm=9cf9170[9cf9170,9cf9170]
ref=9cf90f0[9cf90f0,9cf90f0] lnd=9cf917c[9cf917c,9cf917c]
LOCK OWNERS: lock user session count mode flags
bbfca04 a8bf2ec a8bf2ec 1 S PNC/[04]
LOCK WAITERS: lock user session count mode
bba1600 a8bf2ec a8bf2ec 0 X
LIBRARY OBJECT: object=4f89f14
type=PRCD flags=EXS/LOC[0005] pflags=NST [01] status=INVL load=0
DEPENDENCIES: count=41 size=48
READ ONLY DEPENDENCIES: count=58 size=64
ACCESSES: count=47 size=48
DATA BLOCKS: data# heap pointer status pins change
0 4f8cdb0 4f89ff8 I/P/A 0 NONE
2 4f89fa8 30478c8 I/P/A 1 NONE
4 9d91af8 9ca8c4c I/-/A 0 NONE
This lock request was aborted.
A deadlock among DDL and parse locks is detected.
This deadlock is usually due to user errors in
the design of an application or from issuing a set
of concurrent statements which can cause a deadlock.
This should not be reported to Oracle Support.
The following information may aid in finding
the errors which cause the deadlock:
ORA-04020: deadlock detected while trying to lock object HOSCDPAYTEST.NP_PAYROLL_PROCESS
object waiting waiting blocking blocking
handle session lock mode session lock mode
9cf90e8 a8bf2ec bbf2424 X a8bf2ec bbf4c2c S
SO: bbf2424, type: 35, owner: ba63094, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=bbf2424 handle=9cf90e8 request=X
call pin=0 session pin=0
user=a8bf2ec session=a8bf2ec count=0 flags=[00] savepoint=1172
LIBRARY OBJECT HANDLE: handle=9cf90e8
name=HOSCDPAYTEST.NP_PAYROLL_PROCESS
hash=e9378fe4 timestamp=07-06-2003 14:15:19
namespace=TABL/PRCD/TYPE flags=KGHP/TIM/SML/[02000000]
kkkk-dddd-llll=0000-0015-0015 lock=S pin=S latch=1
lwt=9cf9100[bbf2434,bbf2434] ltm=9cf9108[9cf9108,9cf9108]
pwt=9cf9118[9cf9118,9cf9118] ptm=9cf9170[9cf9170,9cf9170]
ref=9cf90f0[9cf90f0,9cf90f0] lnd=9cf917c[9cf917c,9cf917c]
LOCK OWNERS: lock user session count mode flags
bbf4c2c a8bf2ec a8bf2ec 1 S PNC/[04]
LOCK WAITERS: lock user session count mode
bbf2424 a8bf2ec a8bf2ec 0 X
LIBRARY OBJECT: object=4f89f14
type=PRCD flags=EXS/LOC[0005] pflags=NST [01] status=INVL load=0
DEPENDENCIES: count=41 size=48
READ ONLY DEPENDENCIES: count=58 size=64
ACCESSES: count=47 size=48
DATA BLOCKS: data# heap pointer status pins change
0 4f8cdb0 4f89ff8 I/P/A 0 NONE
2 4f89fa8 30478c8 I/P/A 1 NONE
4 9d91af8 9ca8c4c I/-/A 0 NONE
SO: bbf4c2c, type: 35, owner: bbee5ac, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=bbf4c2c handle=9cf90e8 mode=S
call pin=bbf2f94 session pin=0
user=a8bf2ec session=a8bf2ec count=1 flags=PNC/[04] savepoint=1171
LIBRARY OBJECT HANDLE: handle=9cf90e8
name=HOSCDPAYTEST.NP_PAYROLL_PROCESS
hash=e9378fe4 timestamp=07-06-2003 14:15:19
namespace=TABL/PRCD/TYPE flags=KGHP/TIM/SML/[02000000]
kkkk-dddd-llll=0000-0015-0015 lock=S pin=S latch=1
lwt=9cf9100[bbf2434,bbf2434] ltm=9cf9108[9cf9108,9cf9108]
pwt=9cf9118[9cf9118,9cf9118] ptm=9cf9170[9cf9170,9cf9170]
ref=9cf90f0[9cf90f0,9cf90f0] lnd=9cf917c[9cf917c,9cf917c]
LOCK OWNERS: lock user session count mode flags
bbf4c2c a8bf2ec a8bf2ec 1 S PNC/[04]
LOCK WAITERS: lock user session count mode
bbf2424 a8bf2ec a8bf2ec 0 X
LIBRARY OBJECT: object=4f89f14
type=PRCD flags=EXS/LOC[0005] pflags=NST [01] status=INVL load=0
DEPENDENCIES: count=41 size=48
READ ONLY DEPENDENCIES: count=58 size=64
ACCESSES: count=47 size=48
DATA BLOCKS: data# heap pointer status pins change
0 4f8cdb0 4f89ff8 I/P/A 0 NONE
2 4f89fa8 30478c8 I/P/A 1 NONE
4 9d91af8 9ca8c4c I/-/A 0 NONE
This lock request was aborted.
Dump file E:\oracle\admin\HOSC817\udump\ORA00332.TRC
Thu Jul 10 13:48:05 2003
ORACLE V8.1.7.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 Service Pack 2, CPU type 586
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
Windows 2000 Version 5.0 Service Pack 2, CPU type 586
Instance name: hosc817
Redo thread mounted by this instance: 1
Oracle process number: 42
Windows thread id: 332, image: ORACLE.EXE
ksedmp: internal or fatal error
calling call entryargument values in hex
location type point(? means dubious value)
_ksedmp+a8 CALLrel _ksedst+0
AAE47C
_opitsk+f50 CALLrel _ksedmp+02
_opiino+50c CALLrel _opitsk+00
_opiodr+506 CALLreg 000000003C 4
EAAFBF8
_opidrv+384 CALLrel _opiodr+03C 4
EAAFBF8 0
_sou2o+19 CALLrel _opidrv+0 _opimai+10c CALLrel _sou2o+0 _OracleThreadStart_at_4+49f CALLrel _opimai+02
EAAFE74
77E87587 CALLreg 00000000
Argument/Register addr=eaae47c.
Dump of memory from 0xEAAE43C to 0xEAAE57C
EAAE430 00000003 [....]
EAAE440 00000000 65522100 00000033 00000000 [.....!Re3.......]
EAAE450 00000003 0EAAE411 00000000 00000000 [................]
EAAE460 00000000 52698CA8 00000000 0000001D [......iR........]
EAAE470 0EAAE488 0041E204 00000001 00E191B4 [......A.........]
EAAE480 00E191B4 00E191B4 00E191BC 00E191B4 [................] EAAE490 00E191B4 00E191B4 00E191B4 00E191BC [................]
EAAE4A0 00000000 00000000 00000000 52698CA8 [..............iR]
EAAE4B0 0EAAE564 0041F119 0EAAE4C8 0000001C [d.....A.........]
EAAE4C0 52698CA8 00000002 2A2A2A0A 30303220 [..iR.....*** 200]
EAAE4D0 37302D33 2030312D 343A3331 35303A38 [3-07-10 13:48:05] EAAE4E0 32332D25 2D252073 25207338 7332332D [%-32s %-8s %-32s]
EAAE4F0 0EAA0020 60B16307 00000000 0000311B [ ....c.`.....1..]
EAAE500 41414520 34374546 25207300 7332332D [ EAAFE74.s %-32s]
EAAE510 342D2520 0E000A73 0000311B 655221B4 [ %-4s....1...!Re]
EAAE520 52690033 00000000 00000000 00000000 [3.iR............]
EAAE530 00000000 00000000 00000000 0EAAFFEC [................]
EAAE540 00000000 0EAAFE74 00000000 00000001 [....t...........]
EAAE550 00000001 00000000 0EAADCC4 00000003 [................]
EAAE560 0EAAE588 00477F2D 0EAAE4A0 00000000 [....-.G.........] EAAE570 0000311B 5269B940 00000000 [.1..@.iR....]
Argument/Register addr=eaafbf8.
Dump of memory from 0xEAAFBB8 to 0xEAAFCF8
EAAFBB0 0EAAFBEC 001F0003 [........]
EAAFBC0 0EAAFBCC 0EAE4AFC 60840538 00000000 [.....J..8..`....]
EAAFBD0 00000000 0E000000 00000000 00000000 [................]
EAAFBE0 00000000 003A0038 00000000 00000628 [....8.:.....(...] EAAFBF0 0EAAFC10 77E8D7F4 0EAAFD82 FFFFFFFF [.......w........]
EAAFC00 00000000 00000001 00000000 0EAAFE88 [................]
EAAFC10 77E86AB4 0EAAFFB4 00403154 00000002 [.j.w....T1@.....]
EAAFC20 0EAAFE74 01248BFC 77D4EA27 01249088 [t.....$.'..w..$.]
EAAFC30 5269E6D8 004000C0 74FD182C 0EAAFC88 [..iR..@.,..t....]
EAAFC40 77F8ABA4 00400000 00000001 00000009 [...w..@.........]
EAAFC50 00000000 44414853 00000000 74FD0000 [....SHAD.......t]
EAAFC60 00000002 011D9748 00000000 00000CF0 [....H...........] EAAFC70 0EAAFC54 002C4004 0EAAFD0C 77FB9DA7 [T....@,........w]
EAAFC80 77F8ABE8 FFFFFFFF 0EAAFD1C 77F8AD46 [...w........F..w]
EAAFC90 00400000 00000002 7FFDF000 7FF8F000 [..@.............] EAAFCA0 77F86000 77FCF348 77F85FBA 0EAAFD30 [.`.wH..w._.w0...]
EAAFCB0 77D4EA27 01249088 00000000 00000000 ['..w..$.........]
EAAFCC0 00000000 00000000 00000000 00000000 [................]
Repeat 2 times
EAAFCF0 00000000 7FF8F000 [........]
Argument/Register addr=eaafe74.
Dump of memory from 0xEAAFE34 to 0xEAAFF74
EAAFE30 89A4C760 00000700 8044CA2E [`.........D.] EAAFE40 000679A4 89A4C760 7FFD8201 0000042A [.y..`.......*...]
EAAFE50 7FFD8201 890634E4 00000002 8042C0A4 [.....4........B.]
EAAFE60 00000001 BE130BA4 00000000 BE130B84 [................]
EAAFE70 8044D739 0EAAFD74 0EAAFD82 00000000 [9.D.t...........]
EAAFE80 C01FFF60 00000000 61726F2A 77617073 [`.......*oraspaw]
EAAFE90 65725F6E 5F796C70 63736F68 5F373138 [n_reply_hosc817_]
EAAFEA0 2A323333 7FFD8000 882C1608 889A5D01 [332*......,..]..] EAAFEB0 00000000 C01FFF60 00000002 800651C1 [....`........Q..]
EAAFEC0 00000001 BE130C04 00000000 BE130BE4 [................]
EAAFED0 8044D739 01D2F000 00000001 00000000 [9.D.............] EAAFEE0 C00074BC 00000000 01D30000 C030001C [.t............0.]
EAAFEF0 7FFD8000 8044D223 BE130C04 00000000 [....#.D.........] EAAFF00 00000000 00000000 88D72CB0 FFFFFFFF [.........,......] EAAFF10 889A5C80 00000000 8847F880 FFDFF000 [.\........G.....] EAAFF20 802C5000 00000000 80064C3F 00000008 [.P,.....?L......] EAAFF30 882AED60 8847F880 00000000 8847F8EC [`.*...G.......G.] EAAFF40 8847F880 8847FA10 8042BD4D 8847F880 [..G...G.M.B...G.] EAAFF50 8847F9E0 800654E0 00000246 80469DC9 [..G..T..F.....F.] EAAFF60 BE130C70 00000000 00000000 BE130CB0 [p...............]
EAAFF70 00000000 [....]
Files currently opened by this process:
PROCESS STATE
Process global information:
process: a87f840, call: 0, xact: 0, curses: 0, usrses: a8bd13c
SO: a87f840, type: 1, owner: 0, pt: 0, flag: INIT/-/-/0x00
(process) Oracle pid=42, calls cur/top: 0/9090878, flag: (0) -
int error: 0, call error: 0, sess error: 0, txn error 0
(post info) last post received: 0 0 18
last post received-location: ksqrcl
last process to post me: a87b920 36 0
last post sent: 0 0 131
last post sent-location: kxfprienq: slave
last process posted by me: a87b920 36 0
(latch info) wait_event=0 bits=0
Process Group: DEFAULT, pseudo proc: a8b26a4
O/S info: user: SYSTEM, term: ORA, ospid: 332
OSD pid info: 332
SO: a8bd13c, type: 3, owner: a87f840, pt: 0, flag: INIT/-/-/0x00
(session) trans: 0, creator: a87f840, flag: (41) USR/- -/-/-/-/-/-
DID: 0001-002A-00000002, short-term DID: 0000-0000-00000000
txn branch: 0
oct: 0, prv: 0, user: 53/HOSCPROD
O/S info: user: marwan, term: H-A3-31, ospid: 1532:436, machine: HALULOFFSHORE\H-A3-31 program:
client info: MARWAN MMSS055 PR Report Generation
last wait for 'SQL*Net break/reset to client' blocking sess=0x0 seq=1759 wait_time=-2
driver id=28444553, break?=1, =0
----------------------------------------
SO: bbf2bec, type: 36, owner: a8bd13c, flag: INIT/-/-/0x00
LIBRARY OBJECT PIN: pin=bbf2bec handle=0 lock=bbf5118
user=a8bd13c session=a8bd13c count=0 mask=0000 savepoint=2358
flags=[00]
SO: bbf5118, type: 35, owner: a8bd13c, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=bbf5118 handle=2fe45a8 mode=N
call pin=0 session pin=bbf2bec
user=a8bd13c session=a8bd13c count=1 flags=[00] savepoint=1820
LIBRARY OBJECT HANDLE: handle=2fe45a8
namespace=CRSR flags=RON/KGHP/PN0/[10010000]
kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch=1
lwt=2fe45c0[2fe45c0,2fe45c0] ltm=2fe45c8[2fe45c8,2fe45c8]
pwt=2fe45d8[2fe45d8,2fe45d8] ptm=2fe4630[2fe4630,2fe4630]
ref=2fe45b0[30919e0,30919e0] lnd=2fe463c[2fe463c,2fe463c]
LIBRARY OBJECT: object=9d23108
type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
DEPENDENCIES: count=1 size=16
AUTHORIZATIONS: count=1 size=16 minimum entrysize=16
ACCESSES: count=1 size=16
TRANSLATIONS: count=1 size=16
DATA BLOCKS: data# heap pointer status pins change
0 9d27e64 9c97834 I/P/A 0 NONE
6 9d2319c 9c8ea98 I/-/A 0 NONE
SO: bbfc860, type: 35, owner: a8bd13c, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=bbfc860 handle=3093030 mode=N
call pin=bbef934 session pin=0
user=a8bd13c session=a8bd13c count=1 flags=[00] savepoint=1820
LIBRARY OBJECT HANDLE: handle=3093030
name=
SELECT 1 FROM COMN_RESP_MENU_LINK_T A WHERE A.COMP_CODE = :b1 AND UPPER(A.RESP) = UPPER(RESP) AND A.MENU_SEQ IN (SELECT B.MENU_SEQ FROM COMN_RESP_MENU_LINK_T B WHERE B.COMP_CODE = :b1 AND UPPER(B.RESP) = UPPER(RESP) AND B.MENU_SEQ = TO_NUMBER(:b3) CONNECT BY PRIOR B.MENU_SEQ = B.PARENT_MENU_SEQ START WITH B.MENU_SEQ = TO_NUMBER(:b4) )
hash=72b7f05a timestamp=07-07-2003 09:26:26
namespace=CRSR flags=RON/KGHP/TIM/PN0/LRG/[10010001]
kkkk-dddd-llll=0000-0001-0001 lock=N pin=0 latch=1
lwt=3093048[3093048,3093048] ltm=3093050[3093050,3093050]
pwt=3093060[3093060,3093060] ptm=30930b8[30930b8,30930b8]
ref=3093038[3093038,3093038] lnd=30930c4[2901a10,31f26c8]
LIBRARY OBJECT: object=30929cc
type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
CHILDREN: size=16
child# table reference handle
0 3092a98 3091970 30911a8
1 3092a98 30919c0 2edd110
2 3092a98 30919e0 2fe45a8
3 3092a98 3091a00 9a9e438
DATA BLOCKS: data# heap pointer status pins change
0 3092fc0 309186c I/P/A 0 NONE
SO: bbeee6c, type: 35, owner: a8bd13c, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=bbeee6c handle=9e53e60 mode=N
call pin=bc03188 session pin=0
user=a8bd13c session=a8bd13c count=1 flags=[00] savepoint=1816
LIBRARY OBJECT HANDLE: handle=9e53e60
name=HOSCPROD.COMN_NODE_IS_CHILD
hash=1b4a9669 timestamp=03-03-2003 14:55:59
namespace=TABL/PRCD/TYPE flags=KGHP/TIM/SML/[02000000]
kkkk-dddd-llll=0000-0015-0015 lock=N pin=0 latch=2
lwt=9e53e78[9e53e78,9e53e78] ltm=9e53e80[9e53e80,9e53e80]
pwt=9e53e90[9e53e90,9e53e90] ptm=9e53ee8[9e53ee8,9e53ee8]
ref=9e53e68[9e53e68,9e53e68] lnd=9e53ef4[9e53ef4,9e53ef4]
LIBRARY OBJECT: object=8b2eb7c
type=FNCT flags=EXS/LOC[0005] pflags=NST [01] status=VALD load=0
DEPENDENCIES: count=3 size=16
READ ONLY DEPENDENCIES: count=1 size=16
ACCESSES: count=1 size=16
DATA BLOCKS: data# heap pointer status pins change
0 8b2ed84 8b2ec60 I/-/A 0 NONE
2 8b2ec10 872a54c I/-/A 0 NONE
4 85af458 85a545c I/-/A 0 NONE
SO: bba1d80, type: 36, owner: a8bd13c, flag: INIT/-/-/0x00
LIBRARY OBJECT PIN: pin=bba1d80 handle=0 lock=bc024b0
user=a8bd13c session=a8bd13c count=0 mask=0000 savepoint=1746 flags=[00]
SO: bc024b0, type: 35, owner: a8bd13c, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=bc024b0 handle=80a5da8 mode=N
call pin=0 session pin=bba1d80
user=a8bd13c session=a8bd13c count=1 flags=[00] savepoint=1745
LIBRARY OBJECT HANDLE: handle=80a5da8
namespace=CRSR flags=RON/KGHP/PN0/[10010000]
kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch=1
lwt=80a5dc0[80a5dc0,80a5dc0] ltm=80a5dc8[80a5dc8,80a5dc8]
pwt=80a5dd8[80a5dd8,80a5dd8] ptm=80a5e30[80a5e30,80a5e30]
ref=80a5db0[80a6004,80a6004] lnd=80a5e3c[80a5e3c,80a5e3c]
LIBRARY OBJECT: object=80a5cb8
type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
SCHEMA: count=7 size=16 entrysize=4
DATA BLOCKS: data# heap pointer status pins change
0 80a5b94 80ab1dc I/P/A 0 NONE
6 80ab18c 80b753c I/-/A 0 NONE
SO: 92b2a7c, type: 35, owner: a8bd13c, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=92b2a7c handle=809e0b4 mode=N
call pin=92b6430 session pin=0
user=a8bd13c session=a8bd13c count=1 flags=[00] savepoint=1745
LIBRARY OBJECT HANDLE: handle=809e0b4
name=ROLLBACK
hash=57ac3f5e timestamp=07-06-2003 19:48:29
namespace=CRSR flags=RON/KGHP/TIM/PN0/SML/[12010000]
kkkk-dddd-llll=0000-0001-0001 lock=N pin=0 latch=1
lwt=809e0cc[809e0cc,809e0cc] ltm=809e0d4[809e0d4,809e0d4]
pwt=809e0e4[809e0e4,809e0e4] ptm=809e13c[809e13c,809e13c]
ref=809e0bc[809e0bc,809e0bc] lnd=809e148[809e148,809e148]
LIBRARY OBJECT: object=80a5e7c
type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
CHILDREN: size=16
child# table reference handle
0 80a6038 80a6004 80a5da8
1 80a6038 870a4f4 870b148
DATA BLOCKS: data# heap pointer status pins change
0 80a5bf4 80a5f00 I/P/A 0 NONE
SO: bc06b0c, type: 35, owner: a8bd13c, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=bc06b0c handle=3822640 mode=N
call pin=bba7804 session pin=0
user=a8bd13c session=a8bd13c count=1 flags=[00] savepoint=910
LIBRARY OBJECT HANDLE: handle=3822640
name=SYS.DBMS_APPLICATION_INFO
hash=fcfd1282 timestamp=02-23-2003 13:31:58
namespace=BODY/TYBD flags=KGHP/TIM/SML/[02000000]
kkkk-dddd-llll=0000-0011-0011 lock=N pin=0 latch=0
lwt=3822658[3822658,3822658] ltm=3822660[3822660,3822660]
pwt=3822670[3822670,3822670] ptm=38226c8[38226c8,38226c8]
ref=3822648[3822648,3822648] lnd=38226d4[38226d4,38226d4]
LIBRARY OBJECT: object=38223c8
type=PKBD flags=EXS/LOC[0005] pflags=NST/SWR [09] status=VALD load=0
DEPENDENCIES: count=2 size=16
ACCESSES: count=1 size=16
DATA BLOCKS: data# heap pointer status pins change
0 38225d0 38224ac I/-/A 0 NONE
4 382245c 382072c I/-/A 0 NONE
SO: bbeed04, type: 35, owner: a8bd13c, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=bbeed04 handle=3828450 mode=N
call pin=bbfe720 session pin=0
user=a8bd13c session=a8bd13c count=1 flags=[00] savepoint=910
LIBRARY OBJECT HANDLE: handle=3828450
name=SYS.DBMS_APPLICATION_INFO
hash=fcfd1281 timestamp=02-23-2003 13:31:45
namespace=TABL/PRCD/TYPE flags=KGHP/TIM/SML/[02000000]
kkkk-dddd-llll=0000-021d-021d lock=N pin=0 latch=2
lwt=3828468[3828468,3828468] ltm=3828470[3828470,3828470]
pwt=3828480[3828480,3828480] ptm=38284d8[38284d8,38284d8]
ref=3828458[3828458,3828458] lnd=38284e4[3816eb8,38af934]
LIBRARY OBJECT: object=38282b8
type=PCKG flags=EXS/LOC[0005] pflags= [00] status=VALD load=0
DEPENDENCIES: count=1 size=16
DATA BLOCKS: data# heap pointer status pins change
0 38276c0 382839c I/-/A 0 NONE
2 382834c 3825d9c I/-/A 0 NONE
3 3825f88 0 -/P/- 0 NONE
4 3825ec8 3823de0 I/-/A 0 NONE
9 3825f28 3822190 I/-/A 0 NONE
SO: bc097a0, type: 36, owner: a8bd13c, flag: INIT/-/-/0x00
LIBRARY OBJECT PIN: pin=bc097a0 handle=0 lock=bbb2668
user=a8bd13c session=a8bd13c count=0 mask=0000 savepoint=1803 flags=[00]
SO: bbb2668, type: 35, owner: a8bd13c, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=bbb2668 handle=3799e8c mode=N
call pin=0 session pin=bc097a0
user=a8bd13c session=a8bd13c count=1 flags=[00] savepoint=748
LIBRARY OBJECT HANDLE: handle=3799e8c
namespace=CRSR flags=RON/KGHP/PN0/[10010000]
kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch=2
lwt=3799ea4[3799ea4,3799ea4] ltm=3799eac[3799eac,3799eac]
pwt=3799ebc[3799ebc,3799ebc] ptm=3799f14[3799f14,3799f14]
ref=3799e94[379a0e8,379a0e8] lnd=3799f20[3799f20,3799f20]
LIBRARY OBJECT: object=3799c74
type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
DEPENDENCIES: count=2 size=16
AUTHORIZATIONS: count=1 size=16 minimum entrysize=16
ACCESSES: count=1 size=16
TRANSLATIONS: count=1 size=16
DATA BLOCKS: data# heap pointer status pins change
0 37a1230 3799a34 I/P/A 0 NONE
6 3799d08 37991c4 I/-/A 0 NONE
SO: bbf6798, type: 35, owner: a8bd13c, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=bbf6798 handle=378fc58 mode=N
call pin=bc02d98 session pin=0
user=a8bd13c session=a8bd13c count=1 flags=[00] savepoint=748
LIBRARY OBJECT HANDLE: handle=378fc58
name=
SELECT MODULE_FILE FROM GEN_COMN_RESP_MENU_LINK_T WHERE COMP_CODE = :b1 AND RESP = :b2 AND MENU_SEQ = TO_NUMBER(SUBSTR(:b3,2)) AND MENU_FUNC_IND = 'F' hash=c583eaff timestamp=07-07-2003 07:18:41
namespace=CRSR flags=RON/KGHP/TIM/PN0/MED/[50010000]
kkkk-dddd-llll=0000-0001-0001 lock=N pin=0 latch=2
lwt=378fc70[378fc70,378fc70] ltm=378fc78[378fc78,378fc78]
pwt=378fc88[378fc88,378fc88] ptm=378fce0[378fce0,378fce0]
ref=378fc60[378fc60,378fc60] lnd=378fcec[378fcec,378fcec]
LIBRARY OBJECT: object=3799f60
type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
CHILDREN: size=16
child# table reference handle
0 379a11c 379a0e8 3799e8c
DATA BLOCKS: data# heap pointer status pins change
0 378fbe8 3799fe4 I/P/A 0 NONE
SO: bbaae50, type: 36, owner: a8bd13c, flag: INIT/-/-/0x00
LIBRARY OBJECT PIN: pin=bbaae50 handle=0 lock=bbad358
user=a8bd13c session=a8bd13c count=0 mask=0000 savepoint=1667 flags=[00]
SO: bbad358, type: 35, owner: a8bd13c, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=bbad358 handle=386e540 mode=N
call pin=0 session pin=bbaae50
user=a8bd13c session=a8bd13c count=1 flags=[00] savepoint=608
LIBRARY OBJECT HANDLE: handle=386e540
namespace=CRSR flags=RON/KGHP/PN0/[10010000]
kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch=0
lwt=386e558[386e558,386e558] ltm=386e560[386e560,386e560]
pwt=386e570[386e570,386e570] ptm=386e5c8[386e5c8,386e5c8]
ref=386e548[386e718,386e718] lnd=386e5d4[386e5d4,386e5d4]
LIBRARY OBJECT: object=386ddf4
type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
DEPENDENCIES: count=1 size=16
AUTHORIZATIONS: count=1 size=16 minimum entrysize=16
ACCESSES: count=1 size=16
TRANSLATIONS: count=1 size=16
DATA BLOCKS: data# heap pointer status pins change
0 387950c 386dbb4 I/P/A 0 NONE
6 386de88 386cb94 I/-/A 0 NONE
SO: 989e898, type: 35, owner: a8bd13c, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=989e898 handle=386ff9c mode=N
call pin=98828d0 session pin=0
user=a8bd13c session=a8bd13c count=1 flags=[00] savepoint=608
LIBRARY OBJECT HANDLE: handle=386ff9c
name=SELECT COM_CODE FROM DEPARTMENTS WHERE DEP_CODE = :b1
hash=ec5f4b15 timestamp=07-07-2003 07:13:37
namespace=CRSR flags=RON/KGHP/TIM/PN0/SML/[12010000]
kkkk-dddd-llll=0000-0001-0001 lock=N pin=0 latch=0
lwt=386ffb4[386ffb4,386ffb4] ltm=386ffbc[386ffbc,386ffbc]
pwt=386ffcc[386ffcc,386ffcc] ptm=3870024[3870024,3870024]
ref=386ffa4[386ffa4,386ffa4] lnd=3870030[38099ec,39a1a9c]
LIBRARY OBJECT: object=386f784
type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
CHILDREN: size=16
child# table reference handle
0 386f840 386e718 386e540
1 386f840 386e748 9c46b54
2 386f840 386e768 9dff4f4
DATA BLOCKS: data# heap pointer status pins change
0 3879570 386e614 I/P/A 0 NONE
SO: 92b28d8, type: 35, owner: a8bd13c, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=92b28d8 handle=38784b0 mode=N
call pin=92b6238 session pin=0
user=a8bd13c session=a8bd13c count=1 flags=[00] savepoint=604
LIBRARY OBJECT HANDLE: handle=38784b0
name=HOSCPROD.FETCH_USER_COMP_CODE
hash=caa50b62 timestamp=03-03-2003 14:55:10
namespace=TABL/PRCD/TYPE flags=KGHP/TIM/SML/[02000000]
kkkk-dddd-llll=0000-0015-0015 lock=N pin=0 latch=1
lwt=38784c8[38784c8,38784c8] ltm=38784d0[38784d0,38784d0]
pwt=38784e0[38784e0,38784e0] ptm=3878538[3878538,3878538]
ref=38784b8[38784b8,38784b8] lnd=3878544[3878544,3878544]
LIBRARY OBJECT: object=3878384
type=PRCD flags=EXS/LOC[0005] pflags=NST [01] status=VALD load=0
DEPENDENCIES: count=3 size=16
READ ONLY DEPENDENCIES: count=1 size=16
ACCESSES: count=1 size=16
DATA BLOCKS: data# heap pointer status pins change
0 38795d0 3877b88 I/-/A 0 NONE
2 3878418 858d1e4 I/-/A 0 NONE
4 3877cac 386f5d4 I/-/A 0 NONE
SO: bc031d0, type: 36, owner: a8bd13c, flag: INIT/-/-/0x00
LIBRARY OBJECT PIN: pin=bc031d0 handle=0 lock=bc0b4d4
user=a8bd13c session=a8bd13c count=0 mask=0000 savepoint=1661 flags=[00]
SO: bc0b4d4, type: 35, owner: a8bd13c, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=bc0b4d4 handle=8101db4 mode=N
call pin=0 session pin=bc031d0
user=a8bd13c session=a8bd13c count=1 flags=[00] savepoint=483
LIBRARY OBJECT HANDLE: handle=8101db4
namespace=CRSR flags=RON/KGHP/PN0/[10010000]
kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch=2
lwt=8101dcc[8101dcc,8101dcc] ltm=8101dd4[8101dd4,8101dd4]
pwt=8101de4[8101de4,8101de4] ptm=8101e3c[8101e3c,8101e3c]
ref=8101dbc[813503c,813503c] lnd=8101e48[8101e48,8101e48]
LIBRARY OBJECT: object=8101b3c
type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
DEPENDENCIES: count=1 size=16
AUTHORIZATIONS: count=1 size=16 minimum entrysize=16
ACCESSES: count=1 size=16
SCHEMA: count=7 size=16 entrysize=4
DATA BLOCKS: data# heap pointer status pins change
0 8101d44 810195c I/P/A 0 NONE
6 8101bd0 80fb528 I/-/A 0 NONE
SO: 88c5d68, type: 36, owner: a8bd13c, flag: INIT/-/-/0x00
LIBRARY OBJECT PIN: pin=88c5d68 handle=0 lock=92b211c
user=a8bd13c session=a8bd13c count=0 mask=0000 savepoint=1654 flags=[00]
SO: 92b211c, type: 35, owner: a8bd13c, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=92b211c handle=802496c mode=N
call pin=0 session pin=88c5d68
user=a8bd13c session=a8bd13c count=1 flags=[00] savepoint=474
LIBRARY OBJECT HANDLE: handle=802496c
namespace=CRSR flags=RON/KGHP/PN0/[10010000]
kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch=1
lwt=8024984[8024984,8024984] ltm=802498c[802498c,802498c]
pwt=802499c[802499c,802499c] ptm=80249f4[80249f4,80249f4]
ref=8024974[8024bc8,8024bc8] lnd=8024a00[8024a00,8024a00]
LIBRARY OBJECT: object=8019e44
type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
DEPENDENCIES: count=1 size=16
AUTHORIZATIONS: count=1 size=16 minimum entrysize=16
ACCESSES: count=1 size=16
TRANSLATIONS: count=1 size=16
DATA BLOCKS: data# heap pointer status pins change
0 801a04c 8019c04 I/P/A 0 NONE
6 8019ed8 8018be4 I/-/A 0 NONE
SO: 92b2194, type: 35, owner: a8bd13c, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=92b2194 handle=8028e38 mode=N
call pin=92b5980 session pin=0
user=a8bd13c session=a8bd13c count=1 flags=[00] savepoint=474
LIBRARY OBJECT HANDLE: handle=8028e38
name=SELECT LK_NVAL FROM COMN_LOOKUPS_T WHERE LK_SYS_ID = 'EMB' AND LK_TYPE = 'MXREC' AND LK_CODE = 'MXREC' hash=396975f6 timestamp=07-06-2003 19:48:50
namespace=CRSR flags=RON/KGHP/TIM/PN0/MED/[50010000]
kkkk-dddd-llll=0000-0001-0001 lock=N pin=0 latch=1
lwt=8028e50[8028e50,8028e50] ltm=8028e58[8028e58,8028e58]
pwt=8028e68[8028e68,8028e68] ptm=8028ec0[8028ec0,8028ec0]
ref=8028e40[8028e40,8028e40] lnd=8028ecc[7fa4490,80294a8]
LIBRARY OBJECT: object=8024a40
type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
CHILDREN: size=16
child# table reference handle
0 8024bfc 8024bc8 802496c
1 8024bfc 3969628 3969564
2 8024bfc 3969648 382a184
3 8024bfc 3969668 32eefe0
4 8024bfc 3969688 317b684
5 8024bfc 39696a8 bc793dc
DATA BLOCKS: data# heap pointer status pins change
0 8024c48 8024ac4 I/P/A 0 NONE
SO: bc089d8, type: 36, owner: a8bd13c, flag: INIT/-/-/0x00
LIBRARY OBJECT PIN: pin=bc089d8 handle=0 lock=bbfa8f0
user=a8bd13c session=a8bd13c count=0 mask=0000 savepoint=1649 flags=[00]
SO: bbfa8f0, type: 35, owner: a8bd13c, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=bbfa8f0 handle=801ada0 mode=N
call pin=0 session pin=bc089d8
user=a8bd13c session=a8bd13c count=1 flags=[00] savepoint=467
LIBRARY OBJECT HANDLE: handle=801ada0
namespace=CRSR flags=RON/KGHP/PN0/[10010000]
kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch=0
lwt=801adb8[801adb8,801adb8] ltm=801adc0[801adc0,801adc0]
pwt=801add0[801add0,801add0] ptm=801ae28[801ae28,801ae28]
ref=801ada8[801affc,801affc] lnd=801ae34[801ae34,801ae34]
LIBRARY OBJECT: object=801ab28
type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
DEPENDENCIES: count=1 size=16
AUTHORIZATIONS: count=1 size=16 minimum entrysize=16
ACCESSES: count=1 size=16
TRANSLATIONS: count=1 size=16
DATA BLOCKS: data# heap pointer status pins change
0 801ad30 801a8e8 I/P/A 0 NONE
6 801abbc 8023ed0 I/-/A 0 NONE
SO: bbb9340, type: 35, owner: a8bd13c, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=bbb9340 handle=802902c mode=N
call pin=bc08d38 session pin=0
user=a8bd13c session=a8bd13c count=1 flags=[00] savepoint=467
LIBRARY OBJECT HANDLE: handle=802902c
name=SELECT CC_COMP_NAME,CC_COMP_IMAGE_NAME FROM COMN_COMP_CODE_T WHERE CC_COMP_CODE = :b1 AND CC_LANG_CODE = :b2
hash=4509f02d timestamp=07-06-2003 19:48:49
namespace=CRSR flags=RON/KGHP/TIM/PN0/MED/[50010000]
kkkk-dddd-llll=0000-0001-0001 lock=N pin=0 latch=0
lwt=8029044[8029044,8029044] ltm=802904c[802904c,802904c]
pwt=802905c[802905c,802905c] ptm=80290b4[80290b4,80290b4]
ref=8029034[8029034,8029034] lnd=80290c0[8017e58,804c018]
LIBRARY OBJECT: object=801ae74
type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
CHILDREN: size=16
child# table reference handle
0 801b030 801affc 801ada0
1 801b030 801a6d4 3966290
2 801b030 801a6f4 382d688
3 801b030 801a714 32ebadc
4 801b030 801a734 317cb14
5 801b030 801a754 bc7a86c
DATA BLOCKS: data# heap pointer status pins change
0 801b07c 801aef8 I/P/A 0 NONE
SO: bb9f968, type: 36, owner: a8bd13c, flag: INIT/-/-/0x00
LIBRARY OBJECT PIN: pin=bb9f968 handle=0 lock=bbee890
user=a8bd13c session=a8bd13c count=0 mask=0000 savepoint=1644 flags=[00]
SO: bbee890, type: 35, owner: a8bd13c, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=bbee890 handle=80278ec mode=N
call pin=0 session pin=bb9f968
user=a8bd13c session=a8bd13c count=1 flags=[00] savepoint=460
LIBRARY OBJECT HANDLE: handle=80278ec
namespace=CRSR flags=RON/KGHP/PN0/[10010000]
kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch=2
lwt=8027904[8027904,8027904] ltm=802790c[802790c,802790c]
pwt=802791c[802791c,802791c] ptm=8027974[8027974,8027974]
ref=80278f4[8027b48,8027b48] lnd=8027980[8027980,8027980]
LIBRARY OBJECT: object=80276d4
type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
DEPENDENCIES: count=1 size=16
AUTHORIZATIONS: count=1 size=16 minimum entrysize=16
ACCESSES: count=1 size=16
TRANSLATIONS: count=1 size=16
DATA BLOCKS: data# heap pointer status pins change
0 8026268 8027494 I/P/A 0 NONE 6 8027768 801f570 I/-/A 0 NONE
SO: bbf67d4, type: 35, owner: a8bd13c, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=bbf67d4 handle=8029220 mode=N
call pin=bbf80a0 session pin=0
user=a8bd13c session=a8bd13c count=1 flags=[00] savepoint=460
LIBRARY OBJECT HANDLE: handle=8029220
name=SELECT PG_PROG_DESC FROM COMN_PROGRAMS_T WHERE PG_PROG_CODE = :b1 AND PG_LANG_CODE = :b2
hash=d1b38adf timestamp=07-06-2003 19:48:47
namespace=CRSR flags=RON/KGHP/TIM/PN0/MED/[50010000]
kkkk-dddd-llll=0000-0001-0001 lock=N pin=0 latch=2
lwt=8029238[8029238,8029238] ltm=8029240[8029240,8029240]
pwt=8029250[8029250,8029250] ptm=80292a8[80292a8,80292a8]
ref=8029228[8029228,8029228] lnd=80292b4[7f97078,8060290]
LIBRARY OBJECT: object=80279c0
type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
CHILDREN: size=16
child# table reference handle
0 8027b7c 8027b48 80278ec
1 8027b7c 802550c 396a7f4
2 8027b7c 802552c 382e6e8
3 8027b7c 802554c 3803400
4 8027b7c 802556c 373f6b8
5 8027b7c 802558c 32f0040
6 8027b7c 80255ac 317fe04
7 8027b7c 80255cc 2dfedc8
8 8027b7c 80255ec 2aa67ec
9 8027b7c 802560c bc811e8
10 8027b7c 802562c bc6111c
DATA BLOCKS: data# heap pointer status pins change
0 80262c8 8027a44 I/P/A 0 NONE
SO: bbf5a00, type: 35, owner: a8bd13c, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=bbf5a00 handle=9bc15f4 mode=N
call pin=bbb0ce8 session pin=0
user=a8bd13c session=a8bd13c count=1 flags=[00] savepoint=456
LIBRARY OBJECT HANDLE: handle=9bc15f4
name=SYS.STANDARD
hash=9fb5cedb timestamp=02-23-2003 13:30:03
namespace=BODY/TYBD flags=KGHP/TIM/SML/[02000000]
kkkk-dddd-llll=0000-0011-0011 lock=N pin=0 latch=2
lwt=9bc160c[9bc160c,9bc160c] ltm=9bc1614[9bc1614,9bc1614]
pwt=9bc1624[9bc1624,9bc1624] ptm=9bc167c[9bc167c,9bc167c]
ref=9bc15fc[9bc15fc,9bc15fc] lnd=9bc1688[9bc1688,9bc1688]
LIBRARY OBJECT: object=9bc13dc
type=PKBD flags=EXS/LOC[0005] pflags=NST [01] status=VALD load=0
DEPENDENCIES: count=2 size=16
READ ONLY DEPENDENCIES: count=24 size=32
ACCESSES: count=1 size=16
DATA BLOCKS: data# heap pointer status pins change
0 9bc2ca0 9bc14c0 I/-/A 0 NONE
4 9bc1470 9bc0fd0 I/-/A 0 NONE
SO: bbb12f4, type: 35, owner: a8bd13c, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=bbb12f4 handle=9ff6374 mode=N
call pin=bbb7b34 session pin=0
user=a8bd13c session=a8bd13c count=1 flags=[00] savepoint=456
LIBRARY OBJECT HANDLE: handle=9ff6374
name=SYS.STANDARD
hash=9fb5ceda timestamp=11-19-1996 00:00:00
namespace=TABL/PRCD/TYPE flags=KGHP/TIM/SML/[02000000]
kkkk-dddd-llll=0000-001d-001d lock=N pin=0 latch=1
lwt=9ff638c[9ff638c,9ff638c] ltm=9ff6394[9ff6394,9ff6394]
pwt=9ff63a4[9ff63a4,9ff63a4] ptm=9ff63fc[9ff63fc,9ff63fc]
ref=9ff637c[9ff637c,9ff637c] lnd=9ff6408[9ddd0e0,a0386bc]
LIBRARY OBJECT: object=9ff60fc
type=PCKG flags=EXS/LOC[0005] pflags=NST [01] status=VALD load=0
DATA BLOCKS: data# heap pointer status pins change
0 9ff6304 9ff62a0 I/-/A 0 NONE
2 9ff6190 9fd3494 I/-/A 0 NONE
3 9ff61f0 0 -/P/- 0 NONE
4 9ff6250 9f7f238 I/-/A 0 NONE
SO: bbefa0c, type: 36, owner: a8bd13c, flag: INIT/-/-/0x00
LIBRARY OBJECT PIN: pin=bbefa0c handle=0 lock=bba13e4
user=a8bd13c session=a8bd13c count=0 mask=0000 savepoint=1639 flags=[00]
SO: bba13e4, type: 35, owner: a8bd13c, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=bba13e4 handle=802a6ac mode=N
call pin=0 session pin=bbefa0c
user=a8bd13c session=a8bd13c count=1 flags=[00] savepoint=453
LIBRARY OBJECT HANDLE: handle=802a6ac
namespace=CRSR flags=RON/KGHP/PN0/[10010000]
kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch=1
lwt=802a6c4[802a6c4,802a6c4] ltm=802a6cc[802a6cc,802a6cc]
pwt=802a6dc[802a6dc,802a6dc] ptm=802a734[802a734,802a734]
ref=802a6b4[8029d10,8029d10] lnd=802a740[802a740,802a740]
LIBRARY OBJECT: object=802a434
type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
DEPENDENCIES: count=1 size=16
AUTHORIZATIONS: count=1 size=16 minimum entrysize=16
ACCESSES: count=1 size=16
TRANSLATIONS: count=1 size=16
DATA BLOCKS: data# heap pointer status pins change
0 802a63c 8028c10 I/P/A 0 NONE
6 802a4c8 8027bf0 I/-/A 0 NONE
SO: 92b2158, type: 35, owner: a8bd13c, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=92b2158 handle=8029414 mode=N
call pin=92b5938 session pin=0
user=a8bd13c session=a8bd13c count=1 flags=[00] savepoint=453
LIBRARY OBJECT HANDLE: handle=8029414
name=
SELECT
ORA_US_COMP_CODE,ORA_US_COMP_CODE,ORA_US_LANG_CODE,ORA_US_LANG_CODE,ORA_
US_STATUS,ORA_US_STATUS,ORA_US_QUE_NAME1,ORA_US_QUE_NAME2,ORA_US_QUE_NAM
E3,ORA_US_USER_DESC,ORA_US_DB_ROLE,ORA_US_MENU_ROLE FROM
COMN_USER_PROFILE_T WHERE ORA_USER_NAME = :b1 AND ORA_US_LANG_CODE =
:b2
hash=a6dadbef timestamp=07-06-2003 19:48:47
namespace=CRSR flags=RON/KGHP/TIM/PN0/LRG/[10010001]
kkkk-dddd-llll=0000-0001-0001 lock=N pin=0 latch=1
lwt=802942c[802942c,802942c] ltm=8029434[8029434,8029434]
pwt=8029444[8029444,8029444] ptm=802949c[802949c,802949c]
ref=802941c[802941c,802941c] lnd=80294a8[8028ecc,804dce4]
LIBRARY OBJECT: object=802ad84
type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
CHILDREN: size=16
child# table reference handle
0 8029edc 8029d10 802a6ac
1 8029edc 8029d50 396f9d4
2 8029edc 8029d70 38338c8
3 8029edc 8029d90 32f930c
4 8029edc 8029db0 3198598
5 8029edc 8029dd0 bc809b8
DATA BLOCKS: data# heap pointer status pins change
0 802af28 802ae08 I/P/A 0 NONE
SO: 92b2950, type: 35, owner: a8bd13c, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=92b2950 handle=8030a78 mode=N
call pin=92b62c8 session pin=0
user=a8bd13c session=a8bd13c count=1 flags=[00] savepoint=449
LIBRARY OBJECT HANDLE: handle=8030a78
name=HOSCPROD.COMN_INITIALIZE
hash=17f3440 timestamp=03-03-2003 14:55:09
namespace=TABL/PRCD/TYPE flags=KGHP/TIM/SML/[02000000]
kkkk-dddd-llll=0000-001d-001d lock=N pin=0 latch=1
lwt=8030a90[8030a90,8030a90] ltm=8030a98[8030a98,8030a98]
pwt=8030aa8[8030aa8,8030aa8] ptm=8030b00[8030b00,8030b00]
ref=8030a80[8030a80,8030a80] lnd=8030b0c[8030b0c,8030b0c]
LIBRARY OBJECT: object=8030800
type=PRCD flags=EXS/LOC[0005] pflags=NST [01] status=VALD load=0
DEPENDENCIES: count=6 size=16
READ ONLY DEPENDENCIES: count=4 size=16
ACCESSES: count=4 size=16
DATA BLOCKS: data# heap pointer status pins change
0 8030a08 80308e4 I/-/A 0 NONE
2 8030894 804ba4c I/-/A 0 NONE
3 2e3f5d0 0 -/P/- 0 NONE
4 802efb8 802a780 I/-/A 0 NONE
SO: 92b6310, type: 36, owner: a8bd13c, flag: INIT/-/-/0x00
LIBRARY OBJECT PIN: pin=92b6310 handle=0 lock=92b298c
user=a8bd13c session=a8bd13c count=0 mask=0000 savepoint=1625 flags=[00]
SO: 92b298c, type: 35, owner: a8bd13c, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=92b298c handle=804d964 mode=N
call pin=0 session pin=92b6310
user=a8bd13c session=a8bd13c count=1 flags=[00] savepoint=437
LIBRARY OBJECT HANDLE: handle=804d964
namespace=CRSR flags=RON/KGHP/PN0/[10010000]
kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch=1
lwt=804d97c[804d97c,804d97c] ltm=804d984[804d984,804d984]
pwt=804d994[804d994,804d994] ptm=804d9ec[804d9ec,804d9ec]
ref=804d96c[804da28,804da28] lnd=804d9f8[804d9f8,804d9f8]
LIBRARY OBJECT: object=804d6ec
type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
DEPENDENCIES: count=2 size=16
AUTHORIZATIONS: count=1 size=16 minimum entrysize=16
ACCESSES: count=2 size=16
TRANSLATIONS: count=2 size=16
DATA BLOCKS: data# heap pointer status pins change
0 804d8f4 804d4ac I/P/A 0 NONE
6 804d780 804c48c I/-/A 0 NONE
SO: bbba6b4, type: 35, owner: a8bd13c, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=bbba6b4 handle=804de44 mode=N
call pin=bbae2dc session pin=0
user=a8bd13c session=a8bd13c count=1 flags=[00] savepoint=437
LIBRARY OBJECT HANDLE: handle=804de44
name=
SELECT A.DEP_CODE_BELONG,SUBSTR(B.DEP_NAME,1,30),A.SEC_CODE FROM USER_PROFILES A,DEPARTMENTS B WHERE A.UP_NAME = :b1 AND B.DEP_CODE = A.DEP_CODE_BELONG hash=864aebed timestamp=07-06-2003 19:48:46
namespace=CRSR flags=RON/KGHP/TIM/PN0/MED/[50010000]
kkkk-dddd-llll=0000-0001-0001 lock=N pin=0 latch=1
lwt=804de5c[804de5c,804de5c] ltm=804de64[804de64,804de64]
pwt=804de74[804de74,804de74] ptm=804decc[804decc,804decc]
ref=804de4c[804de4c,804de4c] lnd=804ded8[804dce4,805265c]
LIBRARY OBJECT: object=804e6b4
type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
CHILDREN: size=16
child# table reference handle
0 804dbf4 804da28 804d964
DATA BLOCKS: data# heap pointer status pins change
0 80549e8 804e738 I/P/A 0 NONE
SO: bbfc950, type: 35, owner: a8bd13c, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=bbfc950 handle=3874b4c mode=N
call pin=bbfb648 session pin=0
user=a8bd13c session=a8bd13c count=1 flags=[00] savepoint=433
LIBRARY OBJECT HANDLE: handle=3874b4c
name=HOSCPROD.GET_DEP_SEC_ADJ
hash=bbbbcb44 timestamp=03-03-2003 14:55:53
namespace=TABL/PRCD/TYPE flags=KGHP/TIM/SML/[02000000]
kkkk-dddd-llll=0000-0015-0015 lock=N pin=0 latch=1
lwt=3874b64[3874b64,3874b64] ltm=3874b6c[3874b6c,3874b6c]
pwt=3874b7c[3874b7c,3874b7c] ptm=3874bd4[3874bd4,3874bd4]
ref=3874b54[3874b54,3874b54] lnd=3874be0[3874be0,3874be0]
LIBRARY OBJECT: object=38748d4
type=PRCD flags=EXS/LOC[0005] pflags=NST [01] status=VALD load=0
DEPENDENCIES: count=4 size=16
READ ONLY DEPENDENCIES: count=1 size=16
ACCESSES: count=2 size=16
DATA BLOCKS: data# heap pointer status pins change
0 3874adc 38749b8 I/-/A 0 NONE
2 3874968 858f950 I/-/A 0 NONE
4 3874754 387b5c8 I/-/A 0 NONE
SO: bbf549c, type: 35, owner: a8bd13c, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=bbf549c handle=80607ec mode=N
call pin=bbf2b14 session pin=0
user=a8bd13c session=a8bd13c count=1 flags=[00] savepoint=266
LIBRARY OBJECT HANDLE: handle=80607ec
name=SYS.DBMS_SESSION
hash=d2d066a timestamp=02-23-2003 13:31:52
namespace=BODY/TYBD flags=KGHP/TIM/SML/[02000000]
kkkk-dddd-llll=0000-0011-0011 lock=N pin=0 latch=1
lwt=8060804[8060804,8060804] ltm=806080c[806080c,806080c]
pwt=806081c[806081c,806081c] ptm=8060874[8060874,8060874]
ref=80607f4[80607f4,80607f4] lnd=8060880[8060880,8060880]
LIBRARY OBJECT: object=8060574
type=PKBD flags=EXS/LOC[0005] pflags=NST/SWR [09] status=VALD load=0
DEPENDENCIES: count=3 size=16
READ ONLY DEPENDENCIES: count=1 size=16
ACCESSES: count=2 size=16
DATA BLOCKS: data# heap pointer status pins change
0 806077c 8060658 I/-/A 0 NONE
4 8060608 805f8d4 I/-/A 0 NONE
SO: 989e94c, type: 35, owner: a8bd13c, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=989e94c handle=9bb0cb8 mode=N
call pin=98829a8 session pin=0
user=a8bd13c session=a8bd13c count=1 flags=[00] savepoint=266
LIBRARY OBJECT HANDLE: handle=9bb0cb8
name=SYS.DBMS_SESSION
hash=d2d0669 timestamp=02-23-2003 13:31:43
namespace=TABL/PRCD/TYPE flags=KGHP/TIM/SML/[02000000]
kkkk-dddd-llll=0000-0215-0215 lock=N pin=0 latch=0
lwt=9bb0cd0[9bb0cd0,9bb0cd0] ltm=9bb0cd8[9bb0cd8,9bb0cd8]
pwt=9bb0ce8[9bb0ce8,9bb0ce8] ptm=9bb0d40[9bb0d40,9bb0d40]
ref=9bb0cc0[9bb0cc0,9bb0cc0] lnd=9bb0d4c[9bb0c1c,9bb5404]
LIBRARY OBJECT: object=8059304
type=PCKG flags=EXS/LOC[0005] pflags=NST [01] status=VALD load=0
DEPENDENCIES: count=1 size=16
DATA BLOCKS: data# heap pointer status pins change
0 805950c 80593e8 I/-/A 0 NONE
2 8059398 805d9d0 I/-/A 0 NONE
4 805cf78 8060934 I/-/A 0 NONE
9 805cfd8 8060104 I/-/A 0 NONE
SO: bc05798, type: 36, owner: a8bd13c, flag: INIT/-/-/0x00
LIBRARY OBJECT PIN: pin=bc05798 handle=0 lock=bba0bec
user=a8bd13c session=a8bd13c count=0 mask=0000 savepoint=1569 flags=[00]
SO: bba0bec, type: 35, owner: a8bd13c, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=bba0bec handle=8070c98 mode=N
call pin=0 session pin=bc05798
user=a8bd13c session=a8bd13c count=1 flags=[00] savepoint=247
LIBRARY OBJECT HANDLE: handle=8070c98
namespace=CRSR flags=RON/KGHP/PN0/[10010000]
kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch=1
lwt=8070cb0[8070cb0,8070cb0] ltm=8070cb8[8070cb8,8070cb8]
pwt=8070cc8[8070cc8,8070cc8] ptm=8070d20[8070d20,8070d20]
ref=8070ca0[80717d4,80717d4] lnd=8070d2c[8070d2c,8070d2c]
LIBRARY OBJECT: object=8070a80
type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
DEPENDENCIES: count=2 size=16
AUTHORIZATIONS: count=1 size=16 minimum entrysize=16
ACCESSES: count=2 size=16
TRANSLATIONS: count=2 size=16
DATA BLOCKS: data# heap pointer status pins change
0 80665e0 80708b4 I/P/A 0 NONE
6 8070b14 806c624 I/-/A 0 NONE
SO: 92b2a40, type: 35, owner: a8bd13c, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=92b2a40 handle=8070d54 mode=N
call pin=92b63e8 session pin=0
user=a8bd13c session=a8bd13c count=1 flags=[00] savepoint=247
LIBRARY OBJECT HANDLE: handle=8070d54
name=
SELECT A.ORA_US_USER_PASSWORD MORA_USER_PWD,A.ORA_US_DB_ROLE MDBS_ROLE,A.ORA_US_DB_ROLE_PASSWORD MDBS_PWD,A.ORA_US_MENU_ROLE MMENU_ROLE,B.DBS_CONNECT_STRING_NAME MCONNECT_STR FROM COMN_USER_PROFILE_T A,COMN_DATABASE_T B WHERE (A.ORA_USER_NAME = :b1 AND A.ORA_US_LANG_CODE = :b2 ) AND (A.ORA_DBS_CONNECT_STRING_ID = B.DBS_CONNECT_STRING_ID AND B.DBS_LANG_CODE = :b2 )
hash=c9cc91b0 timestamp=07-06-2003 19:48:46
namespace=CRSR flags=RON/KGHP/TIM/PN0/LRG/[10010001]
kkkk-dddd-llll=0000-0001-0001 lock=N pin=0 latch=1
lwt=8070d6c[8070d6c,8070d6c] ltm=8070d74[8070d74,8070d74]
pwt=8070d84[8070d84,8070d84] ptm=8070ddc[8070ddc,8070ddc]
ref=8070d5c[8070d5c,8070d5c] lnd=8070de8[805265c,8079500]
LIBRARY OBJECT: object=8063508
type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
CHILDREN: size=16
child# table reference handle
0 80635b0 80717d4 8070c98
1 80635b0 8071814 3839470
DATA BLOCKS: data# heap pointer status pins change
0 8066640 80716d0 I/P/A 0 NONE
SO: 989e988, type: 35, owner: a8bd13c, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=989e988 handle=8067bb0 mode=N
call pin=98829f0 session pin=0
user=a8bd13c session=a8bd13c count=1 flags=[00] savepoint=243
LIBRARY OBJECT HANDLE: handle=8067bb0
name=HOSCPROD.GET_CONNECTSTR_ROLE_PWD
hash=d05f136a timestamp=03-03-2003 14:55:53
namespace=TABL/PRCD/TYPE flags=KGHP/TIM/SML/[02000000]
kkkk-dddd-llll=0000-001d-001d lock=N pin=0 latch=0
lwt=8067bc8[8067bc8,8067bc8] ltm=8067bd0[8067bd0,8067bd0]
pwt=8067be0[8067be0,8067be0] ptm=8067c38[8067c38,8067c38]
ref=8067bb8[8067bb8,8067bb8] lnd=8067c44[8067c44,8067c44]
LIBRARY OBJECT: object=8067938
type=PRCD flags=EXS/LOC[0005] pflags=NST [01] status=VALD load=0
DEPENDENCIES: count=4 size=16
READ ONLY DEPENDENCIES: count=1 size=16
ACCESSES: count=2 size=16
DATA BLOCKS: data# heap pointer status pins change
0 8067b40 8067a1c I/-/A 0 NONE
2 80679cc 806d814 I/-/A 0 NONE
3 8063d0c 0 -/P/- 0 NONE
4 8063c88 8063238 I/-/A 0 NONE
SO: 9882918, type: 36, owner: a8bd13c, flag: INIT/-/-/0x00
LIBRARY OBJECT PIN: pin=9882918 handle=0 lock=989e8d4
user=a8bd13c session=a8bd13c count=0 mask=0000 savepoint=1772 flags=[00]
SO: 989e8d4, type: 35, owner: a8bd13c, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=989e8d4 handle=808a3d8 mode=N
call pin=0 session pin=9882918
user=a8bd13c session=a8bd13c count=1 flags=[00] savepoint=152
LIBRARY OBJECT HANDLE: handle=808a3d8
namespace=CRSR flags=RON/KGHP/PN0/[10010000]
kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch=0
lwt=808a3f0[808a3f0,808a3f0] ltm=808a3f8[808a3f8,808a3f8]
pwt=808a408[808a408,808a408] ptm=808a460[808a460,808a460]
ref=808a3e0[8088c48,8088c48] lnd=808a46c[808a46c,808a46c]
LIBRARY OBJECT: object=8088890
type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
DEPENDENCIES: count=2 size=16
AUTHORIZATIONS: count=1 size=16 minimum entrysize=16
ACCESSES: count=1 size=16
TRANSLATIONS: count=1 size=16
DATA BLOCKS: data# heap pointer status pins change
0 808d408 8088650 I/P/A 0 NONE
6 8088924 8087d24 I/-/A 0 NONE
SO: bc06bc0, type: 35, owner: a8bd13c, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=bc06bc0 handle=808d4d8 mode=N
call pin=bba7774 session pin=0
user=a8bd13c session=a8bd13c count=1 flags=[00] savepoint=152
LIBRARY OBJECT HANDLE: handle=808d4d8
name=
SELECT DECODE(MENU_FUNC_IND,'M',' + ',' ') || MENU_NAME M_LABEL,MENU_FUNC_IND || TO_CHAR(MENU_SEQ) M_VALUE FROM GEN_COMN_RESP_MENU_LINK_T WHERE COMP_CODE = :b1 AND UPPER(RESP) = UPPER(:b2) AND PARENT_MENU_SEQ = TO_NUMBER(SUBSTR(:b3,2)) AND ENABLED = 'Y' ORDER BY MENU_SEQ hash=5f96eafa timestamp=07-06-2003 19:48:38
namespace=CRSR flags=RON/KGHP/TIM/PN0/LRG/[10010001]
kkkk-dddd-llll=0000-0001-0001 lock=N pin=0 latch=0
lwt=808d4f0[808d4f0,808d4f0] ltm=808d4f8[808d4f8,808d4f8]
pwt=808d508[808d508,808d508] ptm=808d560[808d560,808d560]
ref=808d4e0[808d4e0,808d4e0] lnd=808d56c[808d56c,808d56c]
LIBRARY OBJECT: object=8088ac0
type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
CHILDREN: size=16
child# table reference handle
0 8088c7c 8088c48 808a3d8
1 8088c7c 808539c 928ae98
DATA BLOCKS: data# heap pointer status pins change
0 808d468 8088b44 I/P/A 0 NONE
SO: bbfe2a0, type: 36, owner: a8bd13c, flag: INIT/-/-/0x00
LIBRARY OBJECT PIN: pin=bbfe2a0 handle=0 lock=bbf62e8
user=a8bd13c session=a8bd13c count=0 mask=0000 savepoint=137 flags=[00]
SO: bbf62e8, type: 35, owner: a8bd13c, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=bbf62e8 handle=36535c8 mode=N
call pin=0 session pin=bbfe2a0
user=a8bd13c session=a8bd13c count=1 flags=[00] savepoint=137
LIBRARY OBJECT HANDLE: handle=36535c8
namespace=CRSR flags=RON/KGHP/PN0/[10010000]
kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch=2
lwt=36535e0[36535e0,36535e0] ltm=36535e8[36535e8,36535e8]
pwt=36535f8[36535f8,36535f8] ptm=3653650[3653650,3653650]
ref=36535d0[36536fc,36536fc] lnd=365365c[365365c,365365c]
LIBRARY OBJECT: object=3653460
type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
DEPENDENCIES: count=1 size=16
AUTHORIZATIONS: count=1 size=16 minimum entrysize=16
ACCESSES: count=1 size=16
TRANSLATIONS: count=1 size=16
DATA BLOCKS: data# heap pointer status pins change
0 3653558 367a598 I/P/A 0 NONE
6 36534f4 8620d80 I/-/A 0 NONE
SO: bbb253c, type: 35, owner: a8bd13c, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=bbb253c handle=36538b4 mode=N
call pin=bc09488 session pin=0
user=a8bd13c session=a8bd13c count=1 flags=[00] savepoint=137
LIBRARY OBJECT HANDLE: handle=36538b4
name=
select DECODE(a.MENU_FUNC_IND,'M',' + ',' ')||a.menu_name , a.menu_func_ind||to_char(a.menu_seq) from comn_resp_menu_link_t a Where a.comp_code = '0' and upper(a.resp) = 'SUPER USER' and a.parent_menu_seq is null and a.enabled = 'Y' and (exists (select 1 from comn_resp_menu_link_t b where b.comp_code = '0' and b.parent_menu_seq = a.menu_seq and upper(b.resp) = 'SUPER USER' and nvl(b.enabled,'X') = 'Y') or a.menu_func_ind = 'F' ) Order By menu_seq
hash=8332f258 timestamp=07-07-2003 07:22:26
namespace=CRSR flags=RON/KGHP/TIM/PN0/LRG/[10010001]
kkkk-dddd-llll=0000-0001-0001 lock=N pin=0 latch=2
lwt=36538cc[36538cc,36538cc] ltm=36538d4[36538d4,36538d4]
pwt=36538e4[36538e4,36538e4] ptm=365393c[365393c,365393c]
ref=36538bc[36538bc,36538bc] lnd=3653948[3653948,3653948]
LIBRARY OBJECT: object=364bfe8
type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
CHILDREN: size=16
child# table reference handle
0 3653858 36536fc 36535c8
1 3653858 365371c 9b31e60
DATA BLOCKS: data# heap pointer status pins change
0 364c114 364c06c I/P/A 0 NONE
SO: bc03890, type: 36, owner: a8bd13c, flag: INIT/-/-/0x00
LIBRARY OBJECT PIN: pin=bc03890 handle=0 lock=bbb2884
user=a8bd13c session=a8bd13c count=0 mask=0000 savepoint=111 flags=[00]
SO: bbb2884, type: 35, owner: a8bd13c, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=bbb2884 handle=8134ef4 mode=N
call pin=0 session pin=bc03890
user=a8bd13c session=a8bd13c count=1 flags=[00] savepoint=111
LIBRARY OBJECT HANDLE: handle=8134ef4
namespace=CRSR flags=RON/KGHP/PN0/[10010000]
kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch=2
lwt=8134f0c[8134f0c,8134f0c] ltm=8134f14[8134f14,8134f14]
pwt=8134f24[8134f24,8134f24] ptm=8134f7c[8134f7c,8134f7c]
ref=8134efc[813501c,813501c] lnd=8134f88[8134f88,8134f88]
LIBRARY OBJECT: object=8134c7c
type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
DEPENDENCIES: count=1 size=16
AUTHORIZATIONS: count=1 size=16 minimum entrysize=16
ACCESSES: count=1 size=16
SCHEMA: count=7 size=16 entrysize=4
DATA BLOCKS: data# heap pointer status pins change
0 8134e84 8134a3c I/P/A 0 NONE
6 8134d10 8133a1c I/-/A 0 NONE
SO: 88f5558, type: 35, owner: a8bd13c, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=88f5558 handle=9bb72cc mode=N
call pin=92b0118 session pin=0
user=a8bd13c session=a8bd13c count=2 flags=[00] savepoint=111
LIBRARY OBJECT HANDLE: handle=9bb72cc
name=SELECT SYSDATE FROM SYS.DUAL
hash=8219b93f timestamp=07-06-2003 19:48:16
namespace=CRSR flags=RON/KGHP/TIM/PN0/SML/[12010000]
kkkk-dddd-llll=0000-0001-0001 lock=N pin=0 latch=2
lwt=9bb72e4[9bb72e4,9bb72e4] ltm=9bb72ec[9bb72ec,9bb72ec]
pwt=9bb72fc[9bb72fc,9bb72fc] ptm=9bb7354[9bb7354,9bb7354]
ref=9bb72d4[9bb72d4,9bb72d4] lnd=9bb7360[9bb6fd0,9bb7490]
LIBRARY OBJECT: object=8135678
type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
CHILDREN: size=16
child# table reference handle
0 81357a8 813501c 8134ef4
1 81357a8 813503c 8101db4
DATA BLOCKS: data# heap pointer status pins change
0 81357f4 81356fc I/P/A 0 NONE
SO: bc0c71c, type: 35, owner: a8bd13c, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=bc0c71c handle=a01389c mode=N
call pin=bbf7908 session pin=0
user=a8bd13c session=a8bd13c count=1 flags=CBB/[02] savepoint=74
LIBRARY OBJECT HANDLE: handle=a01389c
name=SYS.DATABASE
hash=aea96fa0 timestamp=12-31-4712 23:59:59
namespace=EVNT flags=KGHP/TIM/SML/[02000000]
kkkk-dddd-llll=0000-0009-0009 lock=N pin=0 latch=1
lwt=a0138b4[a0138b4,a0138b4] ltm=a0138bc[a0138bc,a0138bc]
pwt=a0138cc[a0138cc,a0138cc] ptm=a013924[a013924,a013924]
ref=a0138a4[a0138a4,a0138a4] lnd=a013930[a013930,a013930]
LIBRARY OBJECT: object=a013624
type=EVNT flags=EXS/LOC[0005] pflags= [00] status=VALD load=0
DATA BLOCKS: data# heap pointer status pins change
0 a01382c a013708 I/-/A 0 NONE
3 a0136b8 a0132f0 I/-/A 0 NONE
SO: bba1114, type: 35, owner: a8bd13c, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=bba1114 handle=809e1e4 mode=N
call pin=bba23b0 session pin=0
user=a8bd13c session=a8bd13c count=1 flags=CBB/[02] savepoint=74
LIBRARY OBJECT HANDLE: handle=809e1e4
name=HOSCPROD.HOSCPROD
hash=e2866ab9 timestamp=12-31-4712 23:59:59
namespace=EVNT flags=KGHP/TIM/SML/[02000000]
kkkk-dddd-llll=0000-0009-0009 lock=N pin=0 latch=1
lwt=809e1fc[809e1fc,809e1fc] ltm=809e204[809e204,809e204]
pwt=809e214[809e214,809e214] ptm=809e26c[809e26c,809e26c]
ref=809e1ec[809e1ec,809e1ec] lnd=809e278[809e278,809e278]
LIBRARY OBJECT: object=80b3b4c
type=EVNT flags=EXS/LOC[0005] pflags= [00] status=VALD load=0
DATA BLOCKS: data# heap pointer status pins change
0 80c57e4 809e00c I/-/A 0 NONE
3 809dfbc 80a5c7c I/-/A 0 NONE
SO: 7d55210, type: 34, owner: a8bd13c, pt: 0, flag: INIT/-/-/0x00
user lock: lock=7d55210 mode=S
user resource: user=bbc78ec uid=53 mode=S
SO: 2cfc0c4, type: 34, owner: a8bd13c, pt: 0, flag: INIT/-/-/0x00
user lock: lock=2cfc0c4 mode=S
user resource: user=bbc78ec uid=53 mode=S
SO: aa333e4, type: 9, owner: a87f840, pt: 0, flag: INIT/-/-/0x00
(broadcast handle) flag: (2) ACTIVE SUBSCRIBER, owner: a87f840,
event: 1605, last message event: 1605, messages
read: 0
channel: (aa35564) system events broadcast
channel
scope: 101, event: 1614, last mesage
event: 0,
publishers/subscribers: 0/49,
messages published: 0
----------------------------------------
SO: 9090878, type: 2, owner: a87f840, pt: 0, flag: INIT/-/-/0x00
(call) sess: cur a8bd13c, rec 0, usr a8bd13c; depth: 0
END OF PROCESS STATE Dump file E:\oracle\admin\HOSC817\udump\ORA00332.TRC
Mon Aug 11 08:18:47 2003
ORACLE V8.1.7.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 Service Pack 2, CPU type 586
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
Windows 2000 Version 5.0 Service Pack 2, CPU type 586
Instance name: hosc817
Redo thread mounted by this instance: 1
Oracle process number: 12
Windows thread id: 332, image: ORACLE.EXE
This deadlock is usually due to user errors in
the design of an application or from issuing a set
of concurrent statements which can cause a deadlock.
This should not be reported to Oracle Support.
The following information may aid in finding
the errors which cause the deadlock:
ORA-04020: deadlock detected while trying to lock object HOSCPROD.COMN_NODE_IS_CHILD
object waiting waiting blocking blocking
handle session lock mode session lock mode
1aa880c4 2017a718 1c7662d8 X 2017a718 1c76692c S
SO: 1c7662d8, type: 35, owner: 1c60dbfc, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=1c7662d8 handle=1aa880c4 request=X
call pin=0 session pin=0
user=2017a718 session=2017a718 count=0 flags=[00] savepoint=38640
LIBRARY OBJECT HANDLE: handle=1aa880c4
name=HOSCPROD.COMN_NODE_IS_CHILD
hash=1b4a9669 timestamp=03-03-2003 14:55:59
namespace=TABL/PRCD/TYPE flags=KGHP/TIM/SML/[02000000]
kkkk-dddd-llll=0000-0015-0015 lock=S pin=S latch=2
lwt=1aa880dc[1c7662e8,1c7662e8] ltm=1aa880e4[1aa880e4,1aa880e4]
pwt=1aa880f4[1aa880f4,1aa880f4] ptm=1aa8814c[1aa8814c,1aa8814c]
ref=1aa880cc[1aa880cc,1aa880cc] lnd=1aa88158[1aa88158,1aa88158]
LOCK OWNERS: lock user session count mode flags
1c76692c 2017a718 2017a718 1 S PNC/[04]
LOCK WAITERS: lock user session count mode
1c7662d8 2017a718 2017a718 0 X
LIBRARY OBJECT: object=1aa87e4c
type=FNCT flags=EXS/LOC[0005] pflags=NST [01] status=INVL load=0
DEPENDENCIES: count=3 size=16
READ ONLY DEPENDENCIES: count=1 size=16
ACCESSES: count=1 size=16
DATA BLOCKS: data# heap pointer status pins change
0 1aa88054 1aa87f30 I/P/A 0 NONE
2 1aa87ee0 1aa8d02c I/P/A 1 NONE
4 1aa87c8c 1aa89558 I/-/A 0 NONE
SO: 1c76692c, type: 35, owner: 20227274, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=1c76692c handle=1aa880c4 mode=S
call pin=1c760e6c session pin=0
user=2017a718 session=2017a718 count=1 flags=PNC/[04] savepoint=38302
LIBRARY OBJECT HANDLE: handle=1aa880c4
name=HOSCPROD.COMN_NODE_IS_CHILD
hash=1b4a9669 timestamp=03-03-2003 14:55:59
namespace=TABL/PRCD/TYPE flags=KGHP/TIM/SML/[02000000]
kkkk-dddd-llll=0000-0015-0015 lock=S pin=S latch=2
lwt=1aa880dc[1c7662e8,1c7662e8] ltm=1aa880e4[1aa880e4,1aa880e4]
pwt=1aa880f4[1aa880f4,1aa880f4] ptm=1aa8814c[1aa8814c,1aa8814c]
ref=1aa880cc[1aa880cc,1aa880cc] lnd=1aa88158[1aa88158,1aa88158]
LOCK OWNERS: lock user session count mode flags
1c76692c 2017a718 2017a718 1 S PNC/[04]
LOCK WAITERS: lock user session count mode
1c7662d8 2017a718 2017a718 0 X
LIBRARY OBJECT: object=1aa87e4c
type=FNCT flags=EXS/LOC[0005] pflags=NST [01] status=INVL load=0
DEPENDENCIES: count=3 size=16
READ ONLY DEPENDENCIES: count=1 size=16
ACCESSES: count=1 size=16
DATA BLOCKS: data# heap pointer status pins change
0 1aa88054 1aa87f30 I/P/A 0 NONE
2 1aa87ee0 1aa8d02c I/P/A 1 NONE
4 1aa87c8c 1aa89558 I/-/A 0 NONE
This lock request was aborted.
A deadlock among DDL and parse locks is detected.
This deadlock is usually due to user errors in
the design of an application or from issuing a set
of concurrent statements which can cause a deadlock.
This should not be reported to Oracle Support.
The following information may aid in finding
the errors which cause the deadlock:
ORA-04020: deadlock detected while trying to lock object HOSCPROD.COMN_NODE_IS_CHILD
object waiting waiting blocking blocking
handle session lock mode session lock mode
1aa880c4 2017a718 1c76683c X 2017a718 1c76692c S
SO: 1c76683c, type: 35, owner: 1c60dbfc, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=1c76683c handle=1aa880c4 request=X
call pin=0 session pin=0
user=2017a718 session=2017a718 count=0 flags=[00] savepoint=38642
LIBRARY OBJECT HANDLE: handle=1aa880c4
name=HOSCPROD.COMN_NODE_IS_CHILD
hash=1b4a9669 timestamp=03-03-2003 14:55:59
namespace=TABL/PRCD/TYPE flags=KGHP/TIM/SML/[02000000]
kkkk-dddd-llll=0000-0015-0015 lock=S pin=S latch=2
lwt=1aa880dc[1c76684c,1c76684c] ltm=1aa880e4[1aa880e4,1aa880e4]
pwt=1aa880f4[1aa880f4,1aa880f4] ptm=1aa8814c[1aa8814c,1aa8814c]
ref=1aa880cc[1aa880cc,1aa880cc] lnd=1aa88158[1aa88158,1aa88158]
LOCK OWNERS: lock user session count mode flags
1c76692c 2017a718 2017a718 1 S PNC/[04]
LOCK WAITERS: lock user session count mode
1c76683c 2017a718 2017a718 0 X
LIBRARY OBJECT: object=1aa87e4c
type=FNCT flags=EXS/LOC[0005] pflags=NST [01] status=INVL load=0
DEPENDENCIES: count=3 size=16
READ ONLY DEPENDENCIES: count=1 size=16
ACCESSES: count=1 size=16
DATA BLOCKS: data# heap pointer status pins change
0 1aa88054 1aa87f30 I/P/A 0 NONE
2 1aa87ee0 1aa8d02c I/P/A 1 NONE
4 1aa87c8c 1aa89558 I/-/A 0 NONE
SO: 1c76692c, type: 35, owner: 20227274, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=1c76692c handle=1aa880c4 mode=S
call pin=1c760e6c session pin=0
user=2017a718 session=2017a718 count=1 flags=PNC/[04] savepoint=38641
LIBRARY OBJECT HANDLE: handle=1aa880c4
name=HOSCPROD.COMN_NODE_IS_CHILD
hash=1b4a9669 timestamp=03-03-2003 14:55:59
namespace=TABL/PRCD/TYPE flags=KGHP/TIM/SML/[02000000]
kkkk-dddd-llll=0000-0015-0015 lock=S pin=S latch=2
lwt=1aa880dc[1c76684c,1c76684c] ltm=1aa880e4[1aa880e4,1aa880e4]
pwt=1aa880f4[1aa880f4,1aa880f4] ptm=1aa8814c[1aa8814c,1aa8814c]
ref=1aa880cc[1aa880cc,1aa880cc] lnd=1aa88158[1aa88158,1aa88158]
LOCK OWNERS: lock user session count mode flags
1c76692c 2017a718 2017a718 1 S PNC/[04]
LOCK WAITERS: lock user session count mode
1c76683c 2017a718 2017a718 0 X
LIBRARY OBJECT: object=1aa87e4c
type=FNCT flags=EXS/LOC[0005] pflags=NST [01] status=INVL load=0
DEPENDENCIES: count=3 size=16
READ ONLY DEPENDENCIES: count=1 size=16
ACCESSES: count=1 size=16
DATA BLOCKS: data# heap pointer status pins change
0 1aa88054 1aa87f30 I/P/A 0 NONE
2 1aa87ee0 1aa8d02c I/P/A 1 NONE
4 1aa87c8c 1aa89558 I/-/A 0 NONE
This lock request was aborted.
Dump file E:\oracle\admin\HOSC817\udump\ORA00332.TRC
Sun Aug 31 14:20:09 2003
ORACLE V8.1.7.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 Service Pack 2, CPU type 586
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
Windows 2000 Version 5.0 Service Pack 2, CPU type 586
Instance name: hosc817
Redo thread mounted by this instance: 1
Oracle process number: 13
Windows thread id: 332, image: ORACLE.EXE
FUNCTION HOSCMPAY.NP_LEAVE_DAYS_CALC: library unit=1ad2afac line=15 opcode=95 static link=0 scope=0
Current frame Registers:
FP=5ccbd46c PC=1ad12d05 Page=0 AP=5ccbd384 ST=5ccbd700
DL0=5ccb68cc GF=5ccb68e4 DL1=5ccb68d4 DPF=5ccb68e0 DS=1ad12da0
MCODE content in current Page:
Entry #0
HOSCMPAY.NP_LEAVE_DAYS_CALC: 00000: BREAK Entry #1
HOSCMPAY.NP_LEAVE_DAYS_CALC: 00001: ENTER 660, 0, 1, 1 HOSCMPAY.NP_LEAVE_DAYS_CALC: 00009: INFR DS[0]+136 Frame Desc Version = 1, Size = 164
# of locals = 20
TC_SSCALAR: FP+4, d=FP+164, n=FP+172
TC_SSCALAR: FP+12, d=FP+176, n=FP+184
TC_SSCALAR: FP+20, d=FP+188, n=FP+212
TC_SSCALAR: FP+28, d=FP+216, n=FP+240
TC_SSCALAR: FP+36, d=FP+244, n=FP+268
TC_SSCALAR: FP+44, d=FP+272, n=FP+296
TC_SSCALAR: FP+52, d=FP+300, n=FP+324
TC_SSCALAR: FP+60, d=FP+328, n=FP+352
TC_SSCALAR: FP+68, d=FP+356, n=FP+380
TC_SSCALAR: FP+76, d=FP+384, n=FP+408
TC_SSCALAR: FP+84, d=FP+412, n=FP+420
TC_SSCALAR: FP+92, d=FP+424, n=FP+448
TC_SSCALAR: FP+100, d=FP+452, n=FP+476
TC_SSCALAR: FP+108, d=FP+480, n=FP+504
TC_SSCALAR: FP+116, d=FP+508, n=FP+532
TC_SSCALAR: FP+124, d=FP+536, n=FP+560
TC_SSCALAR: FP+132, d=FP+564, n=FP+588
TC_SSCALAR: FP+140, d=FP+592, n=FP+616
TC_SSCALAR: FP+148, d=FP+620, n=FP+628
TC_SSCALAR: FP+156, d=FP+632, n=FP+656
[Line 2] l_st_date date := p_start_date;
HOSCMPAY.NP_LEAVE_DAYS_CALC: 00014: MOVD AP[4], FP+4 [Line 5] l_pay_days number := 0;
HOSCMPAY.NP_LEAVE_DAYS_CALC: 00019: CVTIN HS+0 =0=, FP+28 [Line 6] l_no_days number := 0;
HOSCMPAY.NP_LEAVE_DAYS_CALC: 00024: CVTIN HS+0 =0=, FP+36 [Line 8] l_months := months_between(p_end_date,p_start_date);
HOSCMPAY.NP_LEAVE_DAYS_CALC: 00029: MBTD AP[8], AP[4], FP+20 [Line 11]
[Line 11] l_mon_end_date := last_day(l_st_date);
HOSCMPAY.NP_LEAVE_DAYS_CALC: 00036: LSTD FP+4, FP+12 [Line 12] if l_mon_end_date > p_end_date then
HOSCMPAY.NP_LEAVE_DAYS_CALC: 00041: CMP3D FP+12, AP[8], PC+28 =00069:=
HOSCMPAY.NP_LEAVE_DAYS_CALC: 00051: BRLE PC+18 =00069:= [Line 13] exit;
HOSCMPAY.NP_LEAVE_DAYS_CALC: 00057: BRNCH PC+89 =00146:= HOSCMPAY.NP_LEAVE_DAYS_CALC: 00063: BRNCH PC+77 =00140:= [Line 15] l_no_days := l_mon_end_Date - l_st_date + 1;
HOSCMPAY.NP_LEAVE_DAYS_CALC: 00069: SUBDD FP+12, FP+4, FP+44 <-- Current [PC]
HOSCMPAY.NP_LEAVE_DAYS_CALC: 00076: CVTIN HS+8 =1=, FP+52 HOSCMPAY.NP_LEAVE_DAYS_CALC: 00081: ADDN FP+44, FP+52, FP+36 [Line 16] l_pay_days := l_pay_days + l_no_days / (l_mon_end_date ...
HOSCMPAY.NP_LEAVE_DAYS_CALC: 00088: TRNDC FP+4, HS+16='MONTH'V=, FP+84
HOSCMPAY.NP_LEAVE_DAYS_CALC: 00095: SUBDD FP+12, FP+84, FP+76 HOSCMPAY.NP_LEAVE_DAYS_CALC: 00102: CVTIN HS+8 =1=, FP+92 HOSCMPAY.NP_LEAVE_DAYS_CALC: 00107: ADDN FP+76, FP+92, FP+68 HOSCMPAY.NP_LEAVE_DAYS_CALC: 00114: DIVN FP+36, FP+68, FP+60 HOSCMPAY.NP_LEAVE_DAYS_CALC: 00121: ADDN FP+28, FP+60, FP+28 [Line 17] l_st_date := l_mon_end_date + 1;
HOSCMPAY.NP_LEAVE_DAYS_CALC: 00128: CVTIN HS+8 =1=, FP+100 HOSCMPAY.NP_LEAVE_DAYS_CALC: 00133: ADDDN FP+12, FP+100, FP+4 HOSCMPAY.NP_LEAVE_DAYS_CALC: 00140: BRNCH PC-104 =00036:= [Line 21] l_no_days := p_end_Date - l_st_date + 1;
HOSCMPAY.NP_LEAVE_DAYS_CALC: 00146: SUBDD AP[8], FP+4, FP+108 HOSCMPAY.NP_LEAVE_DAYS_CALC: 00153: CVTIN HS+8 =1=, FP+116 HOSCMPAY.NP_LEAVE_DAYS_CALC: 00158: ADDN FP+108, FP+116, FP+36 [Line 22] l_pay_days := l_pay_days + l_no_days / (l_mon_end_date - trunc...
HOSCMPAY.NP_LEAVE_DAYS_CALC: 00165: TRNDC FP+4, HS+16='MONTH'V=, FP+148
HOSCMPAY.NP_LEAVE_DAYS_CALC: 00172: SUBDD FP+12, FP+148, FP+140 HOSCMPAY.NP_LEAVE_DAYS_CALC: 00179: CVTIN HS+8 =1=, FP+156 HOSCMPAY.NP_LEAVE_DAYS_CALC: 00184: ADDN FP+140, FP+156, FP+132 HOSCMPAY.NP_LEAVE_DAYS_CALC: 00191: DIVN FP+36, FP+132, FP+124 HOSCMPAY.NP_LEAVE_DAYS_CALC: 00198: ADDN FP+28, FP+124, FP+28 [Line 24] return (l_pay_days);
HOSCMPAY.NP_LEAVE_DAYS_CALC: 00205: MOVNU FP+28, AP[12] HOSCMPAY.NP_LEAVE_DAYS_CALC: 00210: RET [Line 25] END;
HOSCMPAY.NP_LEAVE_DAYS_CALC: 00211: RASIX 6503 HOSCMPAY.NP_LEAVE_DAYS_CALC: 00216: RET Stack content between preg[FP] <--> preg[ST]
address=5CCBD46C size=660
5ccbd384 5ccbd510 5ccbd518 5ccbd51c 5ccbd524 5ccbd528 5ccbd540 5ccbd544
5ccbd55c 5ccbd560 5ccbd578 5ccbd57c 5ccbd594 5ccbd598 5ccbd5b0 5ccbd5b4
5ccbd5cc 5ccbd5d0 5ccbd5e8 5ccbd5ec 5ccbd604 5ccbd608 5ccbd610 5ccbd614
5ccbd62c 5ccbd630 5ccbd648 5ccbd64c 5ccbd664 5ccbd668 5ccbd680 5ccbd684
5ccbd69c 5ccbd6a0 5ccbd6b8 5ccbd6bc 5ccbd6d4 5ccbd6d8 5ccbd6e0 5ccbd6e4
5ccbd6fc 00000002 5ccbda48 5ccbffff 00000002 5ccbda60 6313ffff 00000004
5ccbda78 00000000 00020000 00000000 c0000af9 5ccbffff 5cc78001 5ccc2294
00000002 5ccbdc40 000002c1 00020000 0000ffff 5ccb8001 00000002 5ccbdb30
5ccb03c1 00000002 5ccbdb48 5ccbffff 00000002 5ccbdb60 5ccb02c1 00000003
5ccbdb78 5ccbdb18 0000ffff 5c02c102 5ccb0bc1 00000020 5ccbdaf0 00000000
00020000 00000000 000003c1 00020000 00000000 00000000 00020000 00000000
0038ffff 00020000 00000000 00000000 00020000 00000000 00000080 0002ffff
00000000 00000000 00020000 00000000 00000080 00020000 0000ffff 00000000
00020000 0000ffff 0002c102 00020000 00000000 00000000 00020000 00000000
00000000 0002c102 00000000 5ccbdac0 00000002 5ccbdac0 5ccbdc80 00000000
5ccbdcd0 5ccbdc58 00000001 5ccbdc58 5ccbdc80 00000001 5ccbffff 5ccbdd00
00000003 5ccbdd00 000004c1 00020000 00000000 5ccbffff 00000001 5ccbe118
1c076778 00350e0e 00000080 00000007 5ccbffff 5ccbd4f4 5ccbd6cc 5ccbd280
382b07c3 00400016 00000002 0003ffff 00000000 00000000 ffffffff 00000000
00000123 00000000 0000ffff 00000000 004098a6 0000ffff 00030000 00000001
00000000 5ccbd280 00000080 1c31c724 51faffff
Dump of static Frame info:
scope frame
1 5ccbd46c
Dump of dependent info:
DON library unit variable list instantiation
0 1ad2afac 5ccb68e4 5ccc49a8
1
INSTANTIATION OBJECT: object=5ccc49a8
type="PL/SQL"[0] lock=1c76c7fc handle=1ad2afac body=0 level=1
flags=SHR/NST/FST[65] executions=1
REST OF INSTANTIATION OBJECT: address=5ccc49f4 size=72
ffffffff 5ccc49a8 5cc7a6cc 00000000 5ccb68fc 00000000 00190000 00000019
1ad12ca8 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000
version=43123476 instantiation size=20
line pcode offset
2 14
5 19
6 24
8 29
7 36
11 36
12 41
13 57
15 69
16 88
17 128
21 146
22 165
24 205
25 211
ANONYMOUS BLOCK: library unit=1ad1781c line=1 opcode=69 static link=0 scope=0
Current frame Registers:
FP=5ccbd384 PC=1ad11b94 Page=0 AP=0 ST=5ccbd404
DL0=5ccc4e0c GF=5ccc4e34 DL1=5ccc4e1c DPF=5ccc4e30 DS=1ad16000
MCODE content in current Page:
Entry #0
00000: BREAK Entry #1
00001: ENTER 128, 0, 1, 1 00009: INFR DS[0]+32 Frame Desc Version = 1, Size = 37
# of locals = 1
TC_SSCALAR: FP+32, d=FP+72, n=FP+96
# of bind proxies = 3
TC_SSCALAR(OUT): FP+40, d=FP+100, n=FP+124
TC_SSCALAR: FP+16, d=FP+48, n=FP+56
TC_SSCALAR: FP+24, d=FP+60, n=FP+68
<source not available>
00014: GBVAR SQLT_DAT(12), 2, FP+16 00021: GBVAR SQLT_DAT(12), 3, FP+24 00028: INSTB 2, STPROC 00032: MOVA FP+16, FP+4 00037: MOVA FP+24, FP+8 00042: MOVA FP+32, FP+12 00047: XCAL 2, 1 00052: MOVNU FP+32, FP+40 <-- Current [PC]
00057: SBVAR SQLT_VNU(6), 1, FP+40 <source not available>
00064: RET Stack content between preg[FP] <--> preg[ST]
address=5CCBD384 size=128
00000000 5ccbd394 5ccbd39c 5ccbd3a4 5ccbd3b4 5ccbd3bc 5ccbd3c0 5ccbd3c8
5ccbd3cc 5ccbd3e4 5ccbd3e8 5ccbd400 1f080000 00000000 5ccbffff 1f0807d3
00000000 00000000 00000000 00000009 00000000 00000000 00000000 00000009
0000ffff 00000002 5ccbc950 00000000 00000000 1ad847a4 5ccbc950 5ccbffff
Dump of static Frame info:
scope frame
1 5ccbd384
Dump of dependent info:
DON library unit variable list instantiation
0 1ad1781c 5ccc4e34 5ccb0118
1
2 1ad2afac 0 5ccc49a8
3
INSTANTIATION OBJECT: object=5ccb0118
type="PL/SQL"[0] lock=1c76ca90 handle=1ad1781c body=0 level=1
flags=FST[60] executions=0
DEPENDENCIES: size=3
dependency# instantiation flags
0 0 [00]
1 5ccc49a8 [00]
2 0 [00]
REST OF INSTANTIATION OBJECT: address=5ccb0164 size=72
ffffffff 00000000 5cc7a6cc 00000000 5ccc4e4c 00000000 00180000 00000018
1ad16008 00000000 00000003 5cc99dc8 00000000 00000000 00000000 00000000
00000000 00000000
INSTANTIATION OBJECT: object=5ccc49a8
type="PL/SQL"[0] lock=1c76c7fc handle=1ad2afac body=0 level=1
flags=SHR/NST/FST[65] executions=1
REST OF INSTANTIATION OBJECT: address=5ccc49f4 size=72
ffffffff 5ccc49a8 5cc7a6cc 00000000 5ccb68fc 00000000 00190000 00000019
1ad12ca8 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000
version=43123476 instantiation size=36
line pcode offset
1 14
1 64
***********END PLSQL RUNTIME DUMP************ FATAL ERROR IN TWO-TASK SERVER: error = 12571
ksedmp: internal or fatal error
ORA-01089: immediate shutdown in progress - no operations are permitted
ORA-06512: at "HOSCMPAY.NP_SET_PAYCAL_PROCESS", line 222
ORA-06512: at "HOSCMPAY.NP_FOR_THE_MONTH_PROCESS", line 540
calling call entryargument values in hex
location type point(? means dubious value)
_ksedmp+a8 CALLrel _ksedst+0
CBFE47C
_opitsk+f50 CALLrel _ksedmp+02
_opiino+50c CALLrel _opitsk+00
_opiodr+506 CALLreg 000000003C 4
5CBFFBF8
_opidrv+384 CALLrel _opiodr+03C 4
5CBFFBF8 0
_sou2o+19 CALLrel _opidrv+0 _opimai+10c CALLrel _sou2o+0 _OracleThreadStart_at_4+49f CALLrel _opimai+02
5CBFFE74
77E87587 CALLreg 00000000
Argument/Register addr=5cbfe47c.
Dump of memory from 0x5CBFE43C to 0x5CBFE57C
5CBFE430 00000003 [....]
5CBFE440 00000000 65522100 00000033 00000000 [.....!Re3.......]
5CBFE450 00000003 5CBFE411 00000000 00000000 [.......\........] 5CBFE460 00000000 001A8428 00000000 0000001D [....(...........] 5CBFE470 5CBFE488 0041E204 00000001 00E191B4 [...\..A.........]
5CBFE480 00E191B4 00E191B4 00E191BC 00E191B4 [................] 5CBFE490 00E191B4 00E191B4 00E191B4 00E191BC [................]
5CBFE4A0 00000000 00000000 00000000 001A8428 [............(...] 5CBFE4B0 5CBFE564 0041F119 5CBFE4C8 0000001C [d..\..A....\....]
5CBFE4C0 001A8428 00000002 2A2A2A0A 30303220 [(........*** 200] 5CBFE4D0 38302D33 2031332D 323A3431 39303A30 [3-08-31 14:20:09] 5CBFE4E0 32332D25 2D252073 25207338 7332332D [%-32s %-8s %-32s]
5CBFE4F0 5CBF0020 60B16307 00000000 0000311B [ ..\.c.`.....1..]
5CBFE500 42433520 37454646 25200034 7332332D [ 5CBFFE74. %-32s]
5CBFE510 342D2520 5C000A73 0000311B 655221B4 [ %-4s..\.1...!Re]
5CBFE520 001A0033 00000000 00000000 00000000 [3...............] 5CBFE530 00000000 00000000 00000000 5CBFFFEC [...............\] 5CBFE540 00000000 5CBFFE74 00000000 00000001 [....t..\........]
5CBFE550 00000001 00000000 5CBFDCC4 00000003 [...........\....] 5CBFE560 5CBFE588 00477F2D 5CBFE4A0 00000000 [...\-.G....\....] 5CBFE570 0000311B 001AB0C0 00000000 [.1..........] Argument/Register addr=5cbffbf8.
Dump of memory from 0x5CBFFBB8 to 0x5CBFFCF8
5CBFFBB0 5CBFFBEC 001F0003 [...\....]
5CBFFBC0 5CBFFBCC 5CC34AFC 60840538 00000000 [...\.J.\8..`....] 5CBFFBD0 00000000 5C000000 00000000 00000000 [.......\........] 5CBFFBE0 00000000 003A0038 00000000 0000057C [....8.:.....|...] 5CBFFBF0 5CBFFC10 77E8D7F4 5CBFFD82 FFFFFFFF [...\...w...\....]
5CBFFC00 00000000 00000001 00000000 5CBFFE88 [...............\] 5CBFFC10 77E86AB4 5CBFFFB4 00403154 00000002 [.j.w...\T1@.....]
5CBFFC20 5CBFFE74 01248BFC 77D4EA27 01249088 [t..\..$.'..w..$.]
5CBFFC30 001ADE58 004000C0 74FD182C 5CBFFC88 [X.....@.,..t...\]
5CBFFC40 77F8ABA4 00400000 00000001 00000009 [...w..@.........]
5CBFFC50 00000000 44414853 00000000 74FD0000 [....SHAD.......t]
5CBFFC60 00000002 011D7B30 00000000 0000058C [....0{..........] 5CBFFC70 5CBFFC54 002C4004 5CBFFD0C 77FB9DA7 [T..\.@,....\...w]
5CBFFC80 77F8ABE8 FFFFFFFF 5CBFFD1C 77F8AD46 [...w.......\F..w]
5CBFFC90 00400000 00000002 7FFDF000 7FFAB000 [..@.............] 5CBFFCA0 77F86000 77FCF348 77F85FBA 5CBFFD30 [.`.wH..w._.w0..\]
5CBFFCB0 77D4EA27 01249088 00000000 00000000 ['..w..$.........]
5CBFFCC0 00000000 00000000 00000000 00000000 [................]
Repeat 2 times
5CBFFCF0 00000000 7FFAB000 [........]
Argument/Register addr=5cbffe74.
Dump of memory from 0x5CBFFE34 to 0x5CBFFF74
5CBFFE30 8955B108 00000700 8044CA2E [..U.......D.] 5CBFFE40 00032E0B 8955B108 7FFD8201 0000065B [......U.....[...] 5CBFFE50 7FFD8201 890634E4 00000002 8042C0A4 [.....4........B.] 5CBFFE60 00000001 BE966BA4 00000000 BE966B84 [.....k.......k..]
5CBFFE70 8044D739 5CBFFD74 5CBFFD82 00000000 [9.D.t..\...\....]
5CBFFE80 C01FFF60 00000000 61726F2A 77617073 [`.......*oraspaw]
5CBFFE90 65725F6E 5F796C70 63736F68 5F373138 [n_reply_hosc817_]
5CBFFEA0 2A323333 7FFD8000 887A7788 889A7301 [332*.....wz..s..]
5CBFFEB0 00000000 C01FFF60 00000002 800651C1 [....`........Q..] 5CBFFEC0 00000001 BE966C04 00000000 BE966BE4 [.....l.......k..]
5CBFFED0 8044D739 01A1F000 00000001 00000000 [9.D.............] 5CBFFEE0 C000687C 00000000 01A20000 C0300018 [|h............0.]
5CBFFEF0 7FFD8000 8042F6BB 00000001 00000000 [......B.........]
5CBFFF00 00000000 00000000 88EC82B0 FFFFFFFF [................]
5CBFFF10 889A72A0 00000000 888CA020 89063000 [.r...... ....0..]
5CBFFF20 89064000 00000000 80064C3F 00000008 [.@......?L......] 5CBFFF30 88A3E640 888CA020 00000000 888CA08C [@... ...........] 5CBFFF40 888CA020 888CA1B0 8042BD4D 888CA020 [ .......M.B. ...] 5CBFFF50 888CA180 800654E0 00000246 80469DC9 [.....T..F.....F.] 5CBFFF60 BE966C70 00000000 00000000 BE966CB0 [pl...........l..]
5CBFFF70 00000000 [....]
Files currently opened by this process:
PROCESS STATE
Process global information:
process: 20139cb0, call: 0, xact: 1c60e2f4, curses: 0, usrses: 2017d9a0
SO: 20139cb0, type: 1, owner: 0, pt: 0, flag: INIT/-/-/0x00
(process) Oracle pid=13, calls cur/top: 0/20227364, flag: (0) -
int error: 1089, call error: 0, sess error: 0, txn error 0
(post info) last post received: 0 0 86
last post received-location: kgllldl: post after freeing latch
last process to post me: 2013bf68 1 0
last post sent: 2147494035 136 13
last post sent-location: ksasnd
last process posted by me: 20138048 1 2
(latch info) wait_event=0 bits=0
Process Group: DEFAULT, pseudo proc: 2017269c
O/S info: user: SYSTEM, term: ORA, ospid: 332
OSD pid info: 332
SO: 2017d9a0, type: 3, owner: 20139cb0, pt: 0, flag: INIT/-/-/0x00
(session) trans: 1c60e2f4, creator: 20139cb0, flag: (41) USR/- -/-/-/-/-/-
DID: 0001-000D-00000006, short-term DID: 0000-0000-00000000
txn branch: 0
oct: 0, prv: 0, user: 100/HOSCMPAY
O/S info: user: administrator, term: H-IBMT3-26, ospid: 216:1316, machine: HALULOFFSHORE\H-IBMT3-26
program:
last wait for 'SQL*Net break/reset to client' blocking sess=0x0 seq=499 wait_time=-2
driver id=28444553, break?=1, =0
----------------------------------------
SO: 1c76c7fc, type: 35, owner: 2017d9a0, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=1c76c7fc handle=1ad2afac mode=N
call pin=1c770030 session pin=0
user=2017d9a0 session=2017d9a0 count=1 flags=[00] savepoint=11937
LIBRARY OBJECT HANDLE: handle=1ad2afac
name=HOSCMPAY.NP_LEAVE_DAYS_CALC
hash=16da61e7 timestamp=08-10-2003 20:28:19
namespace=TABL/PRCD/TYPE flags=KGHP/TIM/SML/[02000000]
kkkk-dddd-llll=0000-0017-0017 lock=N pin=0 latch=2
lwt=1ad2afc4[1ad2afc4,1ad2afc4] ltm=1ad2afcc[1ad2afcc,1ad2afcc]
pwt=1ad2afdc[1ad2afdc,1ad2afdc] ptm=1ad2b034[1ad2b034,1ad2b034]
ref=1ad2afb4[1ad2afb4,1ad2afb4] lnd=1ad2b040[1ad26fc4,1ad4e4e8]
LIBRARY OBJECT: object=1ad15490
type=FNCT flags=EXS/LOC[0005] pflags=NST [01] status=VALD load=0
DEPENDENCIES: count=1 size=16
DATA BLOCKS:
data# heap pointer status pins change
----- -------- -------- ------ ---- ------
0 1ad172ec 1ad15514 I/-/A 0 NONE
1 1ad14158 1a3c8f14 I/-/A 0 NONE
2 1ad155d8 1ad14c60 I/-/A 0 NONE
4 1ad140f8 1ad12ba0 I/-/A 0 NONE
----------------------------------------
SO: 1c7690a4, type: 36, owner: 2017d9a0, flag: INIT/-/-/0x00
LIBRARY OBJECT PIN: pin=1c7690a4 handle=0 lock=1c76ca90
user=2017d9a0 session=2017d9a0 count=0 mask=0000 savepoint=11824
flags=[00]
SO: 1c76ca90, type: 35, owner: 2017d9a0, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=1c76ca90 handle=1ad1781c mode=N
call pin=0 session pin=1c7690a4
user=2017d9a0 session=2017d9a0 count=1 flags=[00] savepoint=11603
LIBRARY OBJECT HANDLE: handle=1ad1781c
namespace=CRSR flags=RON/KGHP/PN0/[10010000]
kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch=2
lwt=1ad17834[1ad17834,1ad17834] ltm=1ad1783c[1ad1783c,1ad1783c]
pwt=1ad1784c[1ad1784c,1ad1784c] ptm=1ad178a4[1ad178a4,1ad178a4]
ref=1ad17824[1ad17a78,1ad17a78] lnd=1ad178b0[1ad178b0,1ad178b0]
LIBRARY OBJECT: object=1ad175a4
type=CRSR flags=EXS[0001] pflags=NST [01] status=VALD load=0
DEPENDENCIES: count=3 size=16
AUTHORIZATIONS: count=1 size=16 minimum entrysize=16
ACCESSES: count=2 size=16
TRANSLATIONS: count=2 size=16
DATA BLOCKS: data# heap pointer status pins change
0 1ad177ac 1ad17364 I/P/A 0 NONE
6 1ad17638 1ad196b0 I/-/A 0 NONE
SO: 1c76c9dc, type: 35, owner: 2017d9a0, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=1c76c9dc handle=1ad2623c mode=N
call pin=1c768fcc session pin=0
user=2017d9a0 session=2017d9a0 count=1 flags=[00] savepoint=11603
LIBRARY OBJECT HANDLE: handle=1ad2623c
name=INSERT INTO DEBUG_PRO VALUES ( :b1 || '-*-' || :b2 || '-*-' || NP_LEAVE_DAYS_CALC(:b1,:b2) || '--' || :b5 )
hash=132630fb timestamp=08-31-2003 13:26:31
namespace=CRSR flags=RON/KGHP/TIM/PN0/MED/[50010000]
kkkk-dddd-llll=0000-0001-0001 lock=N pin=0 latch=2
lwt=1ad26254[1ad26254,1ad26254] ltm=1ad2625c[1ad2625c,1ad2625c]
pwt=1ad2626c[1ad2626c,1ad2626c] ptm=1ad262c4[1ad262c4,1ad262c4]
ref=1ad26244[1ad26244,1ad26244] lnd=1ad262d0[1ad260dc,1ad26aa0]
LIBRARY OBJECT: object=1ad178f0
type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
CHILDREN: size=16
child# table reference handle
0 1ad17aac 1ad17a78 1ad1781c
DATA BLOCKS: data# heap pointer status pins change
0 1ad17af8 1ad17974 I/P/A 0 NONE
SO: 1c76a4bc, type: 36, owner: 2017d9a0, flag: INIT/-/-/0x00
LIBRARY OBJECT PIN: pin=1c76a4bc handle=0 lock=1c772fa0
user=2017d9a0 session=2017d9a0 count=0 mask=0000 savepoint=11597 flags=[00]
SO: 1c772fa0, type: 35, owner: 2017d9a0, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=1c772fa0 handle=1ad18f3c mode=N
call pin=0 session pin=1c76a4bc
user=2017d9a0 session=2017d9a0 count=1 flags=[00] savepoint=11565
LIBRARY OBJECT HANDLE: handle=1ad18f3c
namespace=CRSR flags=RON/KGHP/PN0/[10010000]
kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch=1
lwt=1ad18f54[1ad18f54,1ad18f54] ltm=1ad18f5c[1ad18f5c,1ad18f5c]
pwt=1ad18f6c[1ad18f6c,1ad18f6c] ptm=1ad18fc4[1ad18fc4,1ad18fc4]
ref=1ad18f44[1ad21dc0,1ad21dc0] lnd=1ad18fd0[1ad18fd0,1ad18fd0]
LIBRARY OBJECT: object=1ad18cf8
type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
DEPENDENCIES: count=1 size=16
AUTHORIZATIONS: count=1 size=16 minimum entrysize=16
ACCESSES: count=1 size=16
TRANSLATIONS: count=1 size=16
DATA BLOCKS: data# heap pointer status pins change
0 1ad18ecc 1ad1a030 I/P/A 0 NONE
6 1ad18d8c 1ad1942c I/-/A 0 NONE
SO: 1c772fdc, type: 35, owner: 2017d9a0, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=1c772fdc handle=1ad4fa0c mode=N
call pin=1c76a504 session pin=0
user=2017d9a0 session=2017d9a0 count=1 flags=[00] savepoint=11565
LIBRARY OBJECT HANDLE: handle=1ad4fa0c
name=SELECT PC_EARN_DEDN_TAG FROM NEPS_PAY_CODE_T WHERE PC_CODE = :b1 AND PC_COMPANY_CODE = :b2
hash=139642e0 timestamp=08-31-2003 13:26:31
namespace=CRSR flags=RON/KGHP/TIM/PN0/MED/[50010000]
kkkk-dddd-llll=0000-0001-0001 lock=N pin=0 latch=1
lwt=1ad4fa24[1ad4fa24,1ad4fa24] ltm=1ad4fa2c[1ad4fa2c,1ad4fa2c]
pwt=1ad4fa3c[1ad4fa3c,1ad4fa3c] ptm=1ad4fa94[1ad4fa94,1ad4fa94]
ref=1ad4fa14[1ad4fa14,1ad4fa14] lnd=1ad4faa0[1ad4eac4,1ad4fe88]
LIBRARY OBJECT: object=1ad21c38
type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
CHILDREN: size=16
child# table reference handle
0 1ad21df4 1ad21dc0 1ad18f3c
1 1ad21df4 1ad1692c 1a6891f0
DATA BLOCKS: data# heap pointer status pins change
0 1ad21e40 1ad21cbc I/P/A 0 NONE
SO: 1c76b164, type: 36, owner: 2017d9a0, flag: INIT/-/-/0x00
LIBRARY OBJECT PIN: pin=1c76b164 handle=0 lock=1c76eba8
user=2017d9a0 session=2017d9a0 count=0 mask=0000 savepoint=11559 flags=[00]
SO: 1c76eba8, type: 35, owner: 2017d9a0, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=1c76eba8 handle=1ad242b4 mode=N
call pin=0 session pin=1c76b164
user=2017d9a0 session=2017d9a0 count=1 flags=[00] savepoint=11558
LIBRARY OBJECT HANDLE: handle=1ad242b4
namespace=CRSR flags=RON/KGHP/PN0/[10010000]
kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch=0
lwt=1ad242cc[1ad242cc,1ad242cc] ltm=1ad242d4[1ad242d4,1ad242d4]
pwt=1ad242e4[1ad242e4,1ad242e4] ptm=1ad2433c[1ad2433c,1ad2433c]
ref=1ad242bc[1ad2447c,1ad2447c] lnd=1ad24348[1ad24348,1ad24348]
LIBRARY OBJECT: object=1ad24064
type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
DEPENDENCIES: count=1 size=16
AUTHORIZATIONS: count=1 size=16 minimum entrysize=16
ACCESSES: count=1 size=16
TRANSLATIONS: count=1 size=16
DATA BLOCKS: data# heap pointer status pins change
0 1ad24244 1ad21eb8 I/P/A 0 NONE
6 1ad240f8 1ad21a5c I/-/A 0 NONE
SO: 1c76ebe4, type: 35, owner: 2017d9a0, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=1c76ebe4 handle=1ad26430 mode=N
call pin=1c76b1ac session pin=0
user=2017d9a0 session=2017d9a0 count=1 flags=[00] savepoint=11558
LIBRARY OBJECT HANDLE: handle=1ad26430
name=
SELECT PD_DAILY_HOURLY_TAG,PD_PERCENT_AMOUNT_TAG FROM NEPS_PAY_CODE_DETAILS_T WHERE PD_GRADE_CODE = :b1 AND PD_PAY_CODE = :b2 AND PD_COMPANY_CODE = :b3
hash=1cb2303d timestamp=08-31-2003 13:26:31
namespace=CRSR flags=RON/KGHP/TIM/PN0/MED/[50010000]
kkkk-dddd-llll=0000-0001-0001 lock=N pin=0 latch=0
lwt=1ad26448[1ad26448,1ad26448] ltm=1ad26450[1ad26450,1ad26450]
pwt=1ad26460[1ad26460,1ad26460] ptm=1ad264b8[1ad264b8,1ad264b8]
ref=1ad26438[1ad26438,1ad26438] lnd=1ad264c4[1ac93f84,1ad268ac]
LIBRARY OBJECT: object=1ad1b7e0
type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
CHILDREN: size=16
child# table reference handle
0 1ad24544 1ad2447c 1ad242b4
1 1ad24544 1ad244cc 1a683a58
DATA BLOCKS: data# heap pointer status pins change
0 1ad1b8a8 1ad24378 I/P/A 0 NONE
SO: 1c7690ec, type: 36, owner: 2017d9a0, flag: INIT/-/-/0x00
LIBRARY OBJECT PIN: pin=1c7690ec handle=0 lock=1c76cacc
user=2017d9a0 session=2017d9a0 count=0 mask=0000 savepoint=11550 flags=[00]
SO: 1c76cacc, type: 35, owner: 2017d9a0, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=1c76cacc handle=1ad1fb64 mode=N
call pin=0 session pin=1c7690ec
user=2017d9a0 session=2017d9a0 count=1 flags=[00] savepoint=11549
LIBRARY OBJECT HANDLE: handle=1ad1fb64
namespace=CRSR flags=RON/KGHP/PN0/[10010000]
kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch=2
lwt=1ad1fb7c[1ad1fb7c,1ad1fb7c] ltm=1ad1fb84[1ad1fb84,1ad1fb84]
pwt=1ad1fb94[1ad1fb94,1ad1fb94] ptm=1ad1fbec[1ad1fbec,1ad1fbec]
ref=1ad1fb6c[1ad20fc0,1ad20fc0] lnd=1ad1fbf8[1ad1fbf8,1ad1fbf8]
LIBRARY OBJECT: object=1ad1f8ec
type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
DEPENDENCIES: count=1 size=16
AUTHORIZATIONS: count=1 size=16 minimum entrysize=16
ACCESSES: count=1 size=16
TRANSLATIONS: count=1 size=16
DATA BLOCKS: data# heap pointer status pins change
0 1ad1faf4 1ad1f75c I/P/A 0 NONE
6 1ad1f980 1ad23ea4 I/-/A 0 NONE
SO: 1c76cbbc, type: 35, owner: 2017d9a0, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=1c76cbbc handle=1ad26f30 mode=N
call pin=1c76920c session pin=0
user=2017d9a0 session=2017d9a0 count=1 flags=[00] savepoint=11549
LIBRARY OBJECT HANDLE: handle=1ad26f30
name=
SELECT PA_AMOUNT,PA_EFFECTIVE_FROM FROM NEPS_PAYABLE_T WHERE PA_NUMBER = :b1 AND PA_COMPANY_CODE = :b2 AND PA_PAY_CODE = :b3 AND PA_EFFECTIVE_UPTO IS NULL hash=a4bfd3c timestamp=08-31-2003 13:26:31
namespace=CRSR flags=RON/KGHP/TIM/PN0/MED/[50010000]
kkkk-dddd-llll=0000-0001-0001 lock=N pin=0 latch=2
lwt=1ad26f48[1ad26f48,1ad26f48] ltm=1ad26f50[1ad26f50,1ad26f50]
pwt=1ad26f60[1ad26f60,1ad26f60] ptm=1ad26fb8[1ad26fb8,1ad26fb8]
ref=1ad26f38[1ad26f38,1ad26f38] lnd=1ad26fc4[1ad26aa0,1ad2b040]
LIBRARY OBJECT: object=1ad20e38
type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
CHILDREN: size=16
child# table reference handle
0 1ad20ff4 1ad20fc0 1ad1fb64
1 1ad20ff4 1ad1a28c 1a68dbf4
DATA BLOCKS: data# heap pointer status pins change
0 1ad21040 1ad20ebc I/P/A 0 NONE
SO: 1c7700c0, type: 36, owner: 2017d9a0, flag: INIT/-/-/0x00
LIBRARY OBJECT PIN: pin=1c7700c0 handle=0 lock=1c76c874
user=2017d9a0 session=2017d9a0 count=0 mask=0000 savepoint=11541 flags=[00]
SO: 1c76c874, type: 35, owner: 2017d9a0, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=1c76c874 handle=1ad22ff4 mode=N
call pin=0 session pin=1c7700c0
user=2017d9a0 session=2017d9a0 count=1 flags=[00] savepoint=11329
LIBRARY OBJECT HANDLE: handle=1ad22ff4
namespace=CRSR flags=RON/KGHP/PN0/[10010000]
kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch=2
lwt=1ad2300c[1ad2300c,1ad2300c] ltm=1ad23014[1ad23014,1ad23014]
pwt=1ad23024[1ad23024,1ad23024] ptm=1ad2307c[1ad2307c,1ad2307c]
ref=1ad22ffc[1ad23250,1ad23250] lnd=1ad23088[1ad23088,1ad23088]
LIBRARY OBJECT: object=1ad22d7c
type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
DEPENDENCIES: count=2 size=16
AUTHORIZATIONS: count=1 size=16 minimum entrysize=16
ACCESSES: count=2 size=16
TRANSLATIONS: count=2 size=16
DATA BLOCKS: data# heap pointer status pins change
0 1ad22f84 1ad22bf4 I/P/A 0 NONE
6 1ad22e10 1ad23c50 I/-/A 0 NONE
SO: 1c76c748, type: 35, owner: 2017d9a0, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=1c76c748 handle=1ad26a0c mode=N
call pin=1c76ff58 session pin=0
user=2017d9a0 session=2017d9a0 count=1 flags=[00] savepoint=11329
LIBRARY OBJECT HANDLE: handle=1ad26a0c
name=
SELECT DISTINCT PA_PAY_CODE FROM
NEPS_PAYABLE_T,NEPS_PAY_CODE_DETAILS_T WHERE PA_NUMBER = :b1 AND
PA_COMPANY_CODE = :b2 AND PD_COMPANY_CODE = :b2 AND PA_PAY_CODE =
PD_PAY_CODE AND PD_GRADE_CODE = :b4 AND PA_EFFECTIVE_FROM <= :b5 AND
PA_PAY_CODE NOT IN ( 'BON','OT','TH' ) AND PA_EFFECTIVE_UPTO IS NULL
hash=b1e5ec43 timestamp=08-31-2003 13:26:31
namespace=CRSR flags=RON/KGHP/TIM/PN0/LRG/[10010001]
kkkk-dddd-llll=0000-0001-0001 lock=N pin=0 latch=2
lwt=1ad26a24[1ad26a24,1ad26a24] ltm=1ad26a2c[1ad26a2c,1ad26a2c]
pwt=1ad26a3c[1ad26a3c,1ad26a3c] ptm=1ad26a94[1ad26a94,1ad26a94]
ref=1ad26a14[1ad26a14,1ad26a14] lnd=1ad26aa0[1ad262d0,1ad26fc4]
LIBRARY OBJECT: object=1ad230c8
type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
CHILDREN: size=16
child# table reference handle
------ -------- --------- --------
0 1ad23284 1ad23250 1ad22ff4
1 1ad23284 1ad1fc64 1a68e170
DATA BLOCKS:
data# heap pointer status pins change
----- -------- -------- ------ ---- ------
0 1ad232d0 1ad2314c I/P/A 0 NONE
----------------------------------------
SO: 1c76a54c, type: 36, owner: 2017d9a0, flag: INIT/-/-/0x00
LIBRARY OBJECT PIN: pin=1c76a54c handle=0 lock=1c773018
user=2017d9a0 session=2017d9a0 count=0 mask=0000 savepoint=11323
flags=[00]
SO: 1c773018, type: 35, owner: 2017d9a0, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=1c773018 handle=1ad256e4 mode=N
call pin=0 session pin=1c76a54c
user=2017d9a0 session=2017d9a0 count=1 flags=[00] savepoint=11322
LIBRARY OBJECT HANDLE: handle=1ad256e4
namespace=CRSR flags=RON/KGHP/PN0/[10010000]
kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch=1
lwt=1ad256fc[1ad256fc,1ad256fc] ltm=1ad25704[1ad25704,1ad25704]
pwt=1ad25714[1ad25714,1ad25714] ptm=1ad2576c[1ad2576c,1ad2576c]
ref=1ad256ec[1ad25940,1ad25940] lnd=1ad25778[1ad25778,1ad25778]
LIBRARY OBJECT: object=1ad2546c
type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
DEPENDENCIES: count=1 size=16
AUTHORIZATIONS: count=1 size=16 minimum entrysize=16
ACCESSES: count=1 size=16
TRANSLATIONS: count=1 size=16
DATA BLOCKS: data# heap pointer status pins change
0 1ad25674 1ad252ec I/P/A 0 NONE
6 1ad25500 1ad23588 I/-/A 0 NONE
SO: 1c773054, type: 35, owner: 2017d9a0, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=1c773054 handle=1ad26624 mode=N
call pin=1c76a594 session pin=0
user=2017d9a0 session=2017d9a0 count=1 flags=[00] savepoint=11322
LIBRARY OBJECT HANDLE: handle=1ad26624
name=SELECT CO_CUT_OFF_DAY FROM NEPS_COMPANY_T WHERE CO_COMPANY_CODE = :b1
hash=5d03af76 timestamp=08-31-2003 13:26:31
namespace=CRSR flags=RON/KGHP/TIM/PN0/MED/[50010000]
kkkk-dddd-llll=0000-0001-0001 lock=N pin=0 latch=1
lwt=1ad2663c[1ad2663c,1ad2663c] ltm=1ad26644[1ad26644,1ad26644]
pwt=1ad26654[1ad26654,1ad26654] ptm=1ad266ac[1ad266ac,1ad266ac]
ref=1ad2662c[1ad2662c,1ad2662c] lnd=1ad266b8[1ad25ee8,1ad4e6dc]
LIBRARY OBJECT: object=1ad257b8
type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
CHILDREN: size=16
child# table reference handle
0 1ad25974 1ad25940 1ad256e4
1 1ad25974 1a68d210 1a68f344
DATA BLOCKS: data# heap pointer status pins change
0 1ad259c0 1ad2583c I/P/A 0 NONE
SO: 1c76b1f4, type: 36, owner: 2017d9a0, flag: INIT/-/-/0x00
LIBRARY OBJECT PIN: pin=1c76b1f4 handle=0 lock=1c76ec20
user=2017d9a0 session=2017d9a0 count=0 mask=0000 savepoint=11312 flags=[00]
SO: 1c76ec20, type: 35, owner: 2017d9a0, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=1c76ec20 handle=1ad28214 mode=N
call pin=0 session pin=1c76b1f4
user=2017d9a0 session=2017d9a0 count=1 flags=[00] savepoint=11311
LIBRARY OBJECT HANDLE: handle=1ad28214
namespace=CRSR flags=RON/KGHP/PN0/[10010000]
kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch=0
lwt=1ad2822c[1ad2822c,1ad2822c] ltm=1ad28234[1ad28234,1ad28234]
pwt=1ad28244[1ad28244,1ad28244] ptm=1ad2829c[1ad2829c,1ad2829c]
ref=1ad2821c[1ad2ac8c,1ad2ac8c] lnd=1ad282a8[1ad282a8,1ad282a8]
LIBRARY OBJECT: object=1ad27ffc
type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
DEPENDENCIES: count=1 size=16
AUTHORIZATIONS: count=1 size=16 minimum entrysize=16
ACCESSES: count=1 size=16
TRANSLATIONS: count=1 size=16
DATA BLOCKS: data# heap pointer status pins change
0 1ad2aa7c 1ad25a38 I/P/A 0 NONE
6 1ad28090 1ad24a18 I/-/A 0 NONE
SO: 1c76ec5c, type: 35, owner: 2017d9a0, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=1c76ec5c handle=1ad26818 mode=N
call pin=1c76b23c session pin=0
user=2017d9a0 session=2017d9a0 count=1 flags=[00] savepoint=11311
LIBRARY OBJECT HANDLE: handle=1ad26818
name=INSERT INTO DEBUG_PRO VALUES ( 'SET PAYCAL 1 ' || :b1 || ' ---' || :b2 )
hash=a9d06b21 timestamp=08-31-2003 13:26:31
namespace=CRSR flags=RON/KGHP/TIM/PN0/MED/[50010000]
kkkk-dddd-llll=0000-0001-0001 lock=N pin=0 latch=0
lwt=1ad26830[1ad26830,1ad26830] ltm=1ad26838[1ad26838,1ad26838]
pwt=1ad26848[1ad26848,1ad26848] ptm=1ad268a0[1ad268a0,1ad268a0]
ref=1ad26820[1ad26820,1ad26820] lnd=1ad268ac[1ad264c4,1ad4e3b8]
LIBRARY OBJECT: object=1ad2ab04
type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
CHILDREN: size=16
child# table reference handle
0 1ad2acc0 1ad2ac8c 1ad28214
DATA BLOCKS: data# heap pointer status pins change
0 1ad2ad0c 1ad2ab88 I/P/A 0 NONE
SO: 1c76c964, type: 35, owner: 2017d9a0, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=1c76c964 handle=1ad847a4 mode=N
call pin=1c768f3c session pin=0
user=2017d9a0 session=2017d9a0 count=1 flags=[00] savepoint=11029
LIBRARY OBJECT HANDLE: handle=1ad847a4
name=HOSCMPAY.NP_SET_PAYCAL_PROCESS
hash=1143320e timestamp=08-26-2003 09:37:25
namespace=TABL/PRCD/TYPE flags=KGHP/TIM/SML/[02000000]
kkkk-dddd-llll=0000-0011-0011 lock=N pin=0 latch=2
lwt=1ad847bc[1ad847bc,1ad847bc] ltm=1ad847c4[1ad847c4,1ad847c4]
pwt=1ad847d4[1ad847d4,1ad847d4] ptm=1ad8482c[1ad8482c,1ad8482c]
ref=1ad847ac[1ad847ac,1ad847ac] lnd=1ad84838[1ad52328,1ad84a98]
LIBRARY OBJECT: object=1ad2d5dc
type=PRCD flags=EXS/LOC[0005] pflags=NST [01] status=VALD load=0
DEPENDENCIES: count=10 size=16
READ ONLY DEPENDENCIES: count=10 size=16
ACCESSES: count=10 size=16
DATA BLOCKS: data# heap pointer status pins change
0 1ad2c210 1ad2d6c0 I/-/A 0 NONE
4 1ad2d670 1ad2a5d4 I/-/A 0 NONE
SO: 1c76fec8, type: 36, owner: 2017d9a0, flag: INIT/-/-/0x00
LIBRARY OBJECT PIN: pin=1c76fec8 handle=0 lock=1c76c6d0
user=2017d9a0 session=2017d9a0 count=0 mask=0000 savepoint=11023 flags=[00]
SO: 1c76c6d0, type: 35, owner: 2017d9a0, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=1c76c6d0 handle=1ad2c4b0 mode=N
call pin=0 session pin=1c76fec8
user=2017d9a0 session=2017d9a0 count=1 flags=[00] savepoint=11022
LIBRARY OBJECT HANDLE: handle=1ad2c4b0
namespace=CRSR flags=RON/KGHP/PN0/[10010000]
kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch=2
lwt=1ad2c4c8[1ad2c4c8,1ad2c4c8] ltm=1ad2c4d0[1ad2c4d0,1ad2c4d0]
pwt=1ad2c4e0[1ad2c4e0,1ad2c4e0] ptm=1ad2c538[1ad2c538,1ad2c538]
ref=1ad2c4b8[1ad2c70c,1ad2c70c] lnd=1ad2c544[1ad2c544,1ad2c544]
LIBRARY OBJECT: object=1ad2c298
type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
DEPENDENCIES: count=1 size=16
AUTHORIZATIONS: count=1 size=16 minimum entrysize=16
ACCESSES: count=1 size=16
TRANSLATIONS: count=1 size=16
DATA BLOCKS: data# heap pointer status pins change
0 1ad2fe9c 1ad2d7d4 I/P/A 0 NONE
6 1ad2c32c 1ad2d41c I/-/A 0 NONE
SO: 1c76c70c, type: 35, owner: 2017d9a0, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=1c76c70c handle=1ad4fc00 mode=N
call pin=1c76ff10 session pin=0
user=2017d9a0 session=2017d9a0 count=1 flags=[00] savepoint=11022
LIBRARY OBJECT HANDLE: handle=1ad4fc00
name=INSERT INTO DEBUG_PRO VALUES ( 'FOR THE MONTH else 1 ' || :b1 || ' ---' || :b2 )
hash=217933fc timestamp=08-31-2003 13:26:31
namespace=CRSR flags=RON/KGHP/TIM/PN0/MED/[50010000]
kkkk-dddd-llll=0000-0001-0001 lock=N pin=0 latch=2
lwt=1ad4fc18[1ad4fc18,1ad4fc18] ltm=1ad4fc20[1ad4fc20,1ad4fc20]
pwt=1ad4fc30[1ad4fc30,1ad4fc30] ptm=1ad4fc88[1ad4fc88,1ad4fc88]
ref=1ad4fc08[1ad4fc08,1ad4fc08] lnd=1ad4fc94[1ad4f6b8,1ad50270]
LIBRARY OBJECT: object=1ad2c584
type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
CHILDREN: size=16
child# table reference handle
0 1ad2c740 1ad2c70c 1ad2c4b0
DATA BLOCKS: data# heap pointer status pins change
0 1ad2ff00 1ad2c608 I/P/A 0 NONE
SO: 1c76a6fc, type: 36, owner: 2017d9a0, flag: INIT/-/-/0x00
LIBRARY OBJECT PIN: pin=1c76a6fc handle=0 lock=1c773180
user=2017d9a0 session=2017d9a0 count=0 mask=0000 savepoint=11016 flags=[00]
SO: 1c773180, type: 35, owner: 2017d9a0, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=1c773180 handle=1ad30200 mode=N
call pin=0 session pin=1c76a6fc
user=2017d9a0 session=2017d9a0 count=1 flags=[00] savepoint=11015
LIBRARY OBJECT HANDLE: handle=1ad30200
namespace=CRSR flags=RON/KGHP/PN0/[10010000]
kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch=1
lwt=1ad30218[1ad30218,1ad30218] ltm=1ad30220[1ad30220,1ad30220]
pwt=1ad30230[1ad30230,1ad30230] ptm=1ad30288[1ad30288,1ad30288]
ref=1ad30208[1ad3045c,1ad3045c] lnd=1ad30294[1ad30294,1ad30294]
LIBRARY OBJECT: object=1ad2ff88
type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
DEPENDENCIES: count=1 size=16
AUTHORIZATIONS: count=1 size=16 minimum entrysize=16
ACCESSES: count=1 size=16
TRANSLATIONS: count=1 size=16
DATA BLOCKS: data# heap pointer status pins change
0 1ad30190 1ad2da04 I/P/A 0 NONE
6 1ad3001c 1ad2d124 I/-/A 0 NONE
SO: 1c773234, type: 35, owner: 2017d9a0, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=1c773234 handle=1ad4fdf4 mode=N
call pin=1c76a7d4 session pin=0
user=2017d9a0 session=2017d9a0 count=1 flags=[00] savepoint=11015
LIBRARY OBJECT HANDLE: handle=1ad4fdf4
name=
SELECT SM_SETTLEMENT_FROM,SM_SETTLE_END_DATE FROM NEPS_SETTLEMENT_T WHERE SM_SETTLEMENT_NUMBER = :b1 AND SM_YEAR_MONTH = :b2 AND SM_COMPANY_CODE = '0' hash=d6837af5 timestamp=08-31-2003 13:26:31
namespace=CRSR flags=RON/KGHP/TIM/PN0/MED/[50010000]
kkkk-dddd-llll=0000-0001-0001 lock=N pin=0 latch=1
lwt=1ad4fe0c[1ad4fe0c,1ad4fe0c] ltm=1ad4fe14[1ad4fe14,1ad4fe14]
pwt=1ad4fe24[1ad4fe24,1ad4fe24] ptm=1ad4fe7c[1ad4fe7c,1ad4fe7c]
ref=1ad4fdfc[1ad4fdfc,1ad4fdfc] lnd=1ad4fe88[1ad4faa0,1ad5084c]
LIBRARY OBJECT: object=1ad302d4
type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
CHILDREN: size=16
child# table reference handle
0 1ad30490 1ad3045c 1ad30200
DATA BLOCKS: data# heap pointer status pins change
0 1ad304dc 1ad30358 I/P/A 0 NONE
SO: 1c76b284, type: 36, owner: 2017d9a0, flag: INIT/-/-/0x00
LIBRARY OBJECT PIN: pin=1c76b284 handle=0 lock=1c76ec98
user=2017d9a0 session=2017d9a0 count=0 mask=0000 savepoint=11005 flags=[00]
SO: 1c76ec98, type: 35, owner: 2017d9a0, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=1c76ec98 handle=1ad31060 mode=N
call pin=0 session pin=1c76b284
user=2017d9a0 session=2017d9a0 count=1 flags=[00] savepoint=11004
LIBRARY OBJECT HANDLE: handle=1ad31060
namespace=CRSR flags=RON/KGHP/PN0/[10010000]
kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch=0
lwt=1ad31078[1ad31078,1ad31078] ltm=1ad31080[1ad31080,1ad31080]
pwt=1ad31090[1ad31090,1ad31090] ptm=1ad310e8[1ad310e8,1ad310e8]
ref=1ad31068[1ad312bc,1ad312bc] lnd=1ad310f4[1ad310f4,1ad310f4]
LIBRARY OBJECT: object=1ad2eea4
type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
DEPENDENCIES: count=1 size=16
AUTHORIZATIONS: count=1 size=16 minimum entrysize=16
ACCESSES: count=1 size=16
TRANSLATIONS: count=1 size=16
DATA BLOCKS: data# heap pointer status pins change
0 1ad30ff0 1ad2ed1c I/P/A 0 NONE
6 1ad2ef38 1ad2fc58 I/-/A 0 NONE
SO: 1c76ecd4, type: 35, owner: 2017d9a0, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=1c76ecd4 handle=1ad4ffe8 mode=N
call pin=1c76b2cc session pin=0
user=2017d9a0 session=2017d9a0 count=1 flags=[00] savepoint=11004
LIBRARY OBJECT HANDLE: handle=1ad4ffe8
name=INSERT INTO DEBUG_PRO VALUES ( 'FOR THE MONTH else 12 ' || :b1 || ' ---' || :b2 )
hash=dec45b9d timestamp=08-31-2003 13:26:31
namespace=CRSR flags=RON/KGHP/TIM/PN0/MED/[50010000]
kkkk-dddd-llll=0000-0001-0001 lock=N pin=0 latch=0
lwt=1ad50000[1ad50000,1ad50000] ltm=1ad50008[1ad50008,1ad50008]
pwt=1ad50018[1ad50018,1ad50018] ptm=1ad50070[1ad50070,1ad50070]
ref=1ad4fff0[1ad4fff0,1ad4fff0] lnd=1ad5007c[1ad4f8ac,1ad50464]
LIBRARY OBJECT: object=1ad31134
type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
CHILDREN: size=16
child# table reference handle
0 1ad312f0 1ad312bc 1ad31060
DATA BLOCKS: data# heap pointer status pins change
0 1ad33440 1ad311b8 I/P/A 0 NONE
SO: 1c76a744, type: 36, owner: 2017d9a0, flag: INIT/-/-/0x00
LIBRARY OBJECT PIN: pin=1c76a744 handle=0 lock=1c7731bc
user=2017d9a0 session=2017d9a0 count=0 mask=0000 savepoint=10998 flags=[00]
SO: 1c7731bc, type: 35, owner: 2017d9a0, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=1c7731bc handle=1ad33750 mode=N
call pin=0 session pin=1c76a744
user=2017d9a0 session=2017d9a0 count=1 flags=[00] savepoint=10997
LIBRARY OBJECT HANDLE: handle=1ad33750
namespace=CRSR flags=RON/KGHP/PN0/[10010000]
kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch=1
lwt=1ad33768[1ad33768,1ad33768] ltm=1ad33770[1ad33770,1ad33770]
pwt=1ad33780[1ad33780,1ad33780] ptm=1ad337d8[1ad337d8,1ad337d8]
ref=1ad33758[1ad339ac,1ad339ac] lnd=1ad337e4[1ad337e4,1ad337e4]
LIBRARY OBJECT: object=1ad334d8
type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
DEPENDENCIES: count=1 size=16
AUTHORIZATIONS: count=1 size=16 minimum entrysize=16
ACCESSES: count=1 size=16
TRANSLATIONS: count=1 size=16
DATA BLOCKS: data# heap pointer status pins change
0 1ad336e0 1ad31354 I/P/A 0 NONE
6 1ad3356c 1ad30e1c I/-/A 0 NONE
SO: 1c7670e8, type: 35, owner: 2017d9a0, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=1c7670e8 handle=1ad507b8 mode=N
call pin=1c76ac0c session pin=0
user=2017d9a0 session=2017d9a0 count=1 flags=[00] savepoint=10997
LIBRARY OBJECT HANDLE: handle=1ad507b8
name=
SELECT COUNT(*) FROM NEPS_PAYABLE_T WHERE PA_NUMBER = :b1 AND PA_PAY_CODE = 'BAS' AND PA_EFFECTIVE_UPTO IS NULL AND PA_COMPANY_CODE = :b2
hash=d25f0946 timestamp=08-31-2003 13:26:31
namespace=CRSR flags=RON/KGHP/TIM/PN0/MED/[50010000]
kkkk-dddd-llll=0000-0001-0001 lock=N pin=0 latch=1
lwt=1ad507d0[1ad507d0,1ad507d0] ltm=1ad507d8[1ad507d8,1ad507d8]
pwt=1ad507e8[1ad507e8,1ad507e8] ptm=1ad50840[1ad50840,1ad50840]
ref=1ad507c0[1ad507c0,1ad507c0] lnd=1ad5084c[1ad4fe88,1ad51404]
LIBRARY OBJECT: object=1ad33824
type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
CHILDREN: size=16
child# table reference handle
0 1ad339e0 1ad339ac 1ad33750
DATA BLOCKS: data# heap pointer status pins change
0 1ad3253c 1ad338a8 I/P/A 0 NONE
SO: 1c76b314, type: 36, owner: 2017d9a0, flag: INIT/-/-/0x00
LIBRARY OBJECT PIN: pin=1c76b314 handle=0 lock=1c76ed10
user=2017d9a0 session=2017d9a0 count=0 mask=0000 savepoint=10989 flags=[00]
SO: 1c76ed10, type: 35, owner: 2017d9a0, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=1c76ed10 handle=1ad3ae98 mode=N
call pin=0 session pin=1c76b314
user=2017d9a0 session=2017d9a0 count=1 flags=[00] savepoint=10988
LIBRARY OBJECT HANDLE: handle=1ad3ae98
namespace=CRSR flags=RON/KGHP/PN0/[10010000]
kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch=0
lwt=1ad3aeb0[1ad3aeb0,1ad3aeb0] ltm=1ad3aeb8[1ad3aeb8,1ad3aeb8]
pwt=1ad3aec8[1ad3aec8,1ad3aec8] ptm=1ad3af20[1ad3af20,1ad3af20]
ref=1ad3aea0[1ad3b0f4,1ad3b0f4] lnd=1ad3af2c[1ad3af2c,1ad3af2c]
LIBRARY OBJECT: object=1ad327f4
type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
DEPENDENCIES: count=1 size=16
AUTHORIZATIONS: count=1 size=16 minimum entrysize=16
ACCESSES: count=1 size=16
TRANSLATIONS: count=1 size=16
DATA BLOCKS: data# heap pointer status pins change
0 1ad3ae20 1ad325b4 I/P/A 0 NONE
6 1ad32888 1ad332a8 I/-/A 0 NONE
SO: 1c76edc4, type: 35, owner: 2017d9a0, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=1c76edc4 handle=1ad50ba0 mode=N
call pin=1c76b3ec session pin=0
user=2017d9a0 session=2017d9a0 count=1 flags=[00] savepoint=10988
LIBRARY OBJECT HANDLE: handle=1ad50ba0
name=
SELECT MAX(PA_EFFECTIVE_FROM) FROM NEPS_PAYABLE_T WHERE PA_COMPANY_CODE = :b1 AND PA_NUMBER = :b2 AND PA_PAY_CODE = 'TH' AND PA_EFFECTIVE_UPTO IS NULL GROUP BY PA_EFFECTIVE_FROM hash=c14a9d2e timestamp=08-31-2003 13:26:31
namespace=CRSR flags=RON/KGHP/TIM/PN0/MED/[50010000]
kkkk-dddd-llll=0000-0001-0001 lock=N pin=0 latch=0
lwt=1ad50bb8[1ad50bb8,1ad50bb8] ltm=1ad50bc0[1ad50bc0,1ad50bc0]
pwt=1ad50bd0[1ad50bd0,1ad50bd0] ptm=1ad50c28[1ad50c28,1ad50c28]
ref=1ad50ba8[1ad50ba8,1ad50ba8] lnd=1ad50c34[1ad50a40,1ad50e28]
LIBRARY OBJECT: object=1ad3af6c
type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
CHILDREN: size=16
child# table reference handle
0 1ad3b128 1ad3b0f4 1ad3ae98
1 1ad3b128 1ad2f310 1a6b58d4
DATA BLOCKS: data# heap pointer status pins change
0 1ad3b174 1ad3aff0 I/P/A 0 NONE
SO: 1c76a5dc, type: 36, owner: 2017d9a0, flag: INIT/-/-/0x00
LIBRARY OBJECT PIN: pin=1c76a5dc handle=0 lock=1c773090
user=2017d9a0 session=2017d9a0 count=0 mask=0000 savepoint=10982 flags=[00]
SO: 1c773090, type: 35, owner: 2017d9a0, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=1c773090 handle=1ad3da48 mode=N
call pin=0 session pin=1c76a5dc
user=2017d9a0 session=2017d9a0 count=1 flags=[00] savepoint=10981
LIBRARY OBJECT HANDLE: handle=1ad3da48
namespace=CRSR flags=RON/KGHP/PN0/[10010000]
kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch=1
lwt=1ad3da60[1ad3da60,1ad3da60] ltm=1ad3da68[1ad3da68,1ad3da68]
pwt=1ad3da78[1ad3da78,1ad3da78] ptm=1ad3dad0[1ad3dad0,1ad3dad0]
ref=1ad3da50[1ad3dc10,1ad3dc10] lnd=1ad3dadc[1ad3dadc,1ad3dadc]
LIBRARY OBJECT: object=1ad3d8ac
type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
DEPENDENCIES: count=1 size=16
AUTHORIZATIONS: count=1 size=16 minimum entrysize=16
ACCESSES: count=1 size=16
TRANSLATIONS: count=1 size=16
DATA BLOCKS: data# heap pointer status pins change
0 1ad3a314 1ad3b1ec I/P/A 0 NONE
6 1ad3d940 1ad3a8fc I/-/A 0 NONE
SO: 1c7730cc, type: 35, owner: 2017d9a0, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=1c7730cc handle=1ad51370 mode=N
call pin=1c76a624 session pin=0
user=2017d9a0 session=2017d9a0 count=1 flags=[00] savepoint=10981
LIBRARY OBJECT HANDLE: handle=1ad51370
name=
SELECT
NVL(CO_NOT_RATE,0),CO_NOT_FORMULA,NVL(CO_HOT_RATE,0),CO_HOT_FORMULA,NVL(
CO_SHOT_RATE,0),CO_SHOT_FORMULA,NVL(CO_SOT_RATE,0),CO_SOT_FORMULA,CO_TRA
VEL_RATE FROM NEPS_COMPANY_T WHERE CO_COMPANY_CODE = :b1
hash=69b6a4ce timestamp=08-31-2003 13:26:31
namespace=CRSR flags=RON/KGHP/TIM/PN0/MED/[50010000]
kkkk-dddd-llll=0000-0001-0001 lock=N pin=0 latch=1
lwt=1ad51388[1ad51388,1ad51388] ltm=1ad51390[1ad51390,1ad51390]
pwt=1ad513a0[1ad513a0,1ad513a0] ptm=1ad513f8[1ad513f8,1ad513f8]
ref=1ad51378[1ad51378,1ad51378] lnd=1ad51404[1ad5084c,1ad515f8]
LIBRARY OBJECT: object=1ad36f18
type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
CHILDREN: size=16
child# table reference handle
0 1ad36fd0 1ad3dc10 1ad3da48
1 1ad36fd0 1ad3dc40 1a6b6904
DATA BLOCKS: data# heap pointer status pins change
0 1ad3a374 1ad3db0c I/P/A 0 NONE
SO: 1c76a66c, type: 36, owner: 2017d9a0, flag: INIT/-/-/0x00
LIBRARY OBJECT PIN: pin=1c76a66c handle=0 lock=1c773108
user=2017d9a0 session=2017d9a0 count=0 mask=0000 savepoint=10973 flags=[00]
SO: 1c773108, type: 35, owner: 2017d9a0, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=1c773108 handle=1ad3c788 mode=N
call pin=0 session pin=1c76a66c
user=2017d9a0 session=2017d9a0 count=1 flags=[00] savepoint=10350
LIBRARY OBJECT HANDLE: handle=1ad3c788
namespace=CRSR flags=RON/KGHP/PN0/[10010000]
kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch=1
lwt=1ad3c7a0[1ad3c7a0,1ad3c7a0] ltm=1ad3c7a8[1ad3c7a8,1ad3c7a8]
pwt=1ad3c7b8[1ad3c7b8,1ad3c7b8] ptm=1ad3c810[1ad3c810,1ad3c810]
ref=1ad3c790[1ad3c9e4,1ad3c9e4] lnd=1ad3c81c[1ad3c81c,1ad3c81c]
LIBRARY OBJECT: object=1ad3c510
type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
DEPENDENCIES: count=1 size=16
AUTHORIZATIONS: count=1 size=16 minimum entrysize=16
ACCESSES: count=1 size=16
TRANSLATIONS: count=1 size=16
DATA BLOCKS: data# heap pointer status pins change
0 1ad3c718 1ad3c2f4 I/P/A 0 NONE
6 1ad3c5a4 1ad3d274 I/-/A 0 NONE
SO: 1c773144, type: 35, owner: 2017d9a0, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=1c773144 handle=1ad51564 mode=N
call pin=1c76a6b4 session pin=0
user=2017d9a0 session=2017d9a0 count=1 flags=[00] savepoint=10350
LIBRARY OBJECT HANDLE: handle=1ad51564
name=
SELECT
DR_OT_FORMULA,NVL(DR_OT_RATE,0),DR_HOLIDAY_OT_FORMULA,NVL(DR_HOLIDAY_OT_
RATE,0),DR_SPECIAL_OT_FORMULA,NVL(DR_SPECIAL_OT_RATE,0),DR_SPECIAL_HOLI_
OT_FORMULA,NVL(DR_SPECIAL_HOLI_OT_RATE,0),DR_TRAVEL_RATE FROM
NEPS_OT_RATE_T WHERE DR_COMPANY_CODE = :b1 AND DR_GRADE_CODE = :b2
AND DR_DEPT_CODE = :b3
hash=35621555 timestamp=08-31-2003 13:26:31
namespace=CRSR flags=RON/KGHP/TIM/PN0/LRG/[10010001]
kkkk-dddd-llll=0000-0001-0001 lock=N pin=0 latch=1
lwt=1ad5157c[1ad5157c,1ad5157c] ltm=1ad51584[1ad51584,1ad51584]
pwt=1ad51594[1ad51594,1ad51594] ptm=1ad515ec[1ad515ec,1ad515ec]
ref=1ad5156c[1ad5156c,1ad5156c] lnd=1ad515f8[1ad51404,1ad521f8]
LIBRARY OBJECT: object=1ad3c85c
type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
CHILDREN: size=16
child# table reference handle
0 1ad3ca18 1ad3c9e4 1ad3c788
1 1ad3ca18 1ad374c0 1a6b8ff4
DATA BLOCKS: data# heap pointer status pins change
0 1ad3ca64 1ad3c8e0 I/P/A 0 NONE
SO: 1c76ffa0, type: 36, owner: 2017d9a0, flag: INIT/-/-/0x00
LIBRARY OBJECT PIN: pin=1c76ffa0 handle=0 lock=1c76c784
user=2017d9a0 session=2017d9a0 count=0 mask=0000 savepoint=10344 flags=[00]
SO: 1c76c784, type: 35, owner: 2017d9a0, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=1c76c784 handle=1ad3ee78 mode=N
call pin=0 session pin=1c76ffa0
user=2017d9a0 session=2017d9a0 count=1 flags=[00] savepoint=10343
LIBRARY OBJECT HANDLE: handle=1ad3ee78
namespace=CRSR flags=RON/KGHP/PN0/[10010000]
kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch=2
lwt=1ad3ee90[1ad3ee90,1ad3ee90] ltm=1ad3ee98[1ad3ee98,1ad3ee98]
pwt=1ad3eea8[1ad3eea8,1ad3eea8] ptm=1ad3ef00[1ad3ef00,1ad3ef00]
ref=1ad3ee80[1ad3f0d4,1ad3f0d4] lnd=1ad3ef0c[1ad3ef0c,1ad3ef0c]
LIBRARY OBJECT: object=1ad3ecd0
type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
DEPENDENCIES: count=1 size=16
AUTHORIZATIONS: count=1 size=16 minimum entrysize=16
ACCESSES: count=1 size=16
TRANSLATIONS: count=1 size=16
DATA BLOCKS: data# heap pointer status pins change
0 1ad3ee08 1ad4be60 I/P/A 0 NONE
6 1ad3ed64 1ad4b954 I/-/A 0 NONE
SO: 1c76c9a0, type: 35, owner: 2017d9a0, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=1c76c9a0 handle=1ad51858 mode=N
call pin=1c768f84 session pin=0
user=2017d9a0 session=2017d9a0 count=1 flags=[00] savepoint=10343
LIBRARY OBJECT HANDLE: handle=1ad51858
name=SELECT EM_GRADE_CODE,EM_DEPT_CODE FROM NEPS_EMPLOYEE_T WHERE EM_NUMBER = :b1 AND EM_COMPANY_CODE = :b2
hash=d3ea9eca timestamp=08-31-2003 13:26:31
namespace=CRSR flags=RON/KGHP/TIM/PN0/MED/[50010000]
kkkk-dddd-llll=0000-0001-0001 lock=N pin=0 latch=2
lwt=1ad51870[1ad51870,1ad51870] ltm=1ad51878[1ad51878,1ad51878]
pwt=1ad51888[1ad51888,1ad51888] ptm=1ad518e0[1ad518e0,1ad518e0]
ref=1ad51860[1ad51860,1ad51860] lnd=1ad518ec[1ad50270,1ad52328]
LIBRARY OBJECT: object=1ad3ef4c
type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
CHILDREN: size=16
child# table reference handle
0 1ad3f108 1ad3f0d4 1ad3ee78
1 1ad3f108 1ad3b668 1a6bcda4
DATA BLOCKS: data# heap pointer status pins change
0 1ad3f154 1ad3efd0 I/P/A 0 NONE
SO: 1c76b35c, type: 36, owner: 2017d9a0, flag: INIT/-/-/0x00
LIBRARY OBJECT PIN: pin=1c76b35c handle=0 lock=1c76ed4c
user=2017d9a0 session=2017d9a0 count=0 mask=0000 savepoint=10337 flags=[00]
SO: 1c76ed4c, type: 35, owner: 2017d9a0, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=1c76ed4c handle=1ad47740 mode=N
call pin=0 session pin=1c76b35c
user=2017d9a0 session=2017d9a0 count=1 flags=[00] savepoint=10336
LIBRARY OBJECT HANDLE: handle=1ad47740
namespace=CRSR flags=RON/KGHP/PN0/[10010000]
kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch=0
lwt=1ad47758[1ad47758,1ad47758] ltm=1ad47760[1ad47760,1ad47760]
pwt=1ad47770[1ad47770,1ad47770] ptm=1ad477c8[1ad477c8,1ad477c8]
ref=1ad47748[1ad4799c,1ad4799c] lnd=1ad477d4[1ad477d4,1ad477d4]
LIBRARY OBJECT: object=1ad474e8
type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
DEPENDENCIES: count=1 size=16
AUTHORIZATIONS: count=1 size=16 minimum entrysize=16
ACCESSES: count=1 size=16
TRANSLATIONS: count=1 size=16
DATA BLOCKS: data# heap pointer status pins change
0 1ad476d0 1ad4c090 I/P/A 0 NONE
6 1ad4757c 1ad4b070 I/-/A 0 NONE
SO: 1c76ed88, type: 35, owner: 2017d9a0, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=1c76ed88 handle=1ad51a4c mode=N
call pin=1c76b3a4 session pin=0
user=2017d9a0 session=2017d9a0 count=1 flags=[00] savepoint=10336
LIBRARY OBJECT HANDLE: handle=1ad51a4c
name=
SELECT
SM_NUMBER,SM_SETTLEMENT_UPTO,NVL(SM_WORKED_DAYS,0),NVL(SM_NOT_HOURS,0),N
VL(SM_NHOT_HOURS,0),NVL(SM_SOT_HOURS,0),NVL(SM_SHOT_HOURS,0),NVL(SM_NOTI
CE_MONTH,0),NVL(SM_TRAVEL_HOURS,0) FROM NEPS_SETTLEMENT_T WHERE
SM_YEAR_MONTH = :b1 AND SM_COMPANY_CODE = :b2 AND SM_SETTLEMENT_NUMBER
= :b3 AND SM_PROCESSED_TAG = 'N'
hash=90c96a2f timestamp=08-31-2003 13:26:31
namespace=CRSR flags=RON/KGHP/TIM/PN0/LRG/[10010001]
kkkk-dddd-llll=0000-0001-0001 lock=N pin=0 latch=0
lwt=1ad51a64[1ad51a64,1ad51a64] ltm=1ad51a6c[1ad51a6c,1ad51a6c]
pwt=1ad51a7c[1ad51a7c,1ad51a7c] ptm=1ad51ad4[1ad51ad4,1ad51ad4]
ref=1ad51a54[1ad51a54,1ad51a54] lnd=1ad51ae0[1ad51210,1ad51dd4]
LIBRARY OBJECT: object=1ad47814
type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
CHILDREN: size=16
child# table reference handle
0 1ad479d0 1ad4799c 1ad47740
DATA BLOCKS: data# heap pointer status pins change
0 1ad47a1c 1ad47898 I/P/A 0 NONE
SO: 1c76b434, type: 36, owner: 2017d9a0, flag: INIT/-/-/0x00
LIBRARY OBJECT PIN: pin=1c76b434 handle=0 lock=1c76ee00
user=2017d9a0 session=2017d9a0 count=0 mask=0000 savepoint=10330 flags=[00]
SO: 1c76ee00, type: 35, owner: 2017d9a0, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=1c76ee00 handle=1ad4c39c mode=N
call pin=0 session pin=1c76b434
user=2017d9a0 session=2017d9a0 count=1 flags=[00] savepoint=9474
LIBRARY OBJECT HANDLE: handle=1ad4c39c
namespace=CRSR flags=RON/KGHP/PN0/[10010000]
kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch=0
lwt=1ad4c3b4[1ad4c3b4,1ad4c3b4] ltm=1ad4c3bc[1ad4c3bc,1ad4c3bc]
pwt=1ad4c3cc[1ad4c3cc,1ad4c3cc] ptm=1ad4c424[1ad4c424,1ad4c424]
ref=1ad4c3a4[1ad4c5f8,1ad4c5f8] lnd=1ad4c430[1ad4c430,1ad4c430]
LIBRARY OBJECT: object=1ad4d960
type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
DEPENDENCIES: count=1 size=16
AUTHORIZATIONS: count=1 size=16 minimum entrysize=16
ACCESSES: count=1 size=16
TRANSLATIONS: count=1 size=16
DATA BLOCKS: data# heap pointer status pins change
0 1ad4c32c 1ad4d720 I/P/A 0 NONE
6 1ad4d9f4 1ad4d444 I/-/A 0 NONE
SO: 1c76ee3c, type: 35, owner: 2017d9a0, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=1c76ee3c handle=1ad51d40 mode=N
call pin=1c76b47c session pin=0
user=2017d9a0 session=2017d9a0 count=1 flags=[00] savepoint=9474
LIBRARY OBJECT HANDLE: handle=1ad51d40
name=SELECT CO_NORMAL_HRS,CO_CUT_OFF_DAY FROM NEPS_COMPANY_T WHERE CO_COMPANY_CODE = :b1
hash=9edf0af6 timestamp=08-31-2003 13:26:31
namespace=CRSR flags=RON/KGHP/TIM/PN0/MED/[50010000]
kkkk-dddd-llll=0000-0001-0001 lock=N pin=0 latch=0
lwt=1ad51d58[1ad51d58,1ad51d58] ltm=1ad51d60[1ad51d60,1ad51d60]
pwt=1ad51d70[1ad51d70,1ad51d70] ptm=1ad51dc8[1ad51dc8,1ad51dc8]
ref=1ad51d48[1ad51d48,1ad51d48] lnd=1ad51dd4[1ad51ae0,1ad5261c]
LIBRARY OBJECT: object=1ad4c470
type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
CHILDREN: size=16
child# table reference handle
0 1ad4c62c 1ad4c5f8 1ad4c39c
1 1ad4c62c 1a6d0e60 1a6d9738
DATA BLOCKS: data# heap pointer status pins change
0 1ad4c678 1ad4c4f4 I/P/A 0 NONE
SO: 1c76a8f4, type: 36, owner: 2017d9a0, flag: INIT/-/-/0x00
LIBRARY OBJECT PIN: pin=1c76a8f4 handle=0 lock=1c766e54
user=2017d9a0 session=2017d9a0 count=0 mask=0000 savepoint=9464 flags=[00]
SO: 1c766e54, type: 35, owner: 2017d9a0, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=1c766e54 handle=1ad4e038 mode=N
call pin=0 session pin=1c76a8f4
user=2017d9a0 session=2017d9a0 count=1 flags=[00] savepoint=9454
LIBRARY OBJECT HANDLE: handle=1ad4e038
namespace=CRSR flags=RON/KGHP/PN0/[10010000]
kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch=1
lwt=1ad4e050[1ad4e050,1ad4e050] ltm=1ad4e058[1ad4e058,1ad4e058]
pwt=1ad4e068[1ad4e068,1ad4e068] ptm=1ad4e0c0[1ad4e0c0,1ad4e0c0]
ref=1ad4e040[1ad4e294,1ad4e294] lnd=1ad4e0cc[1ad4e0cc,1ad4e0cc]
LIBRARY OBJECT: object=1ad4ddc0
type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
DEPENDENCIES: count=1 size=16
AUTHORIZATIONS: count=1 size=16 minimum entrysize=16
ACCESSES: count=1 size=16
TRANSLATIONS: count=1 size=16
DATA BLOCKS: data# heap pointer status pins change
0 1ad4dfc8 1ad4db80 I/P/A 0 NONE
6 1ad4de54 1ad4cb60 I/-/A 0 NONE
SO: 1c766f80, type: 35, owner: 2017d9a0, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=1c766f80 handle=1ad52164 mode=N
call pin=1c76aa5c session pin=0
user=2017d9a0 session=2017d9a0 count=1 flags=[00] savepoint=9454
LIBRARY OBJECT HANDLE: handle=1ad52164
name=INSERT INTO DEBUG_PRO VALUES ( :b1 || '---' || :b2 )
hash=94395ed4 timestamp=08-31-2003 13:26:31
namespace=CRSR flags=RON/KGHP/TIM/PN0/SML/[12010000]
kkkk-dddd-llll=0000-0001-0001 lock=N pin=0 latch=1
lwt=1ad5217c[1ad5217c,1ad5217c] ltm=1ad52184[1ad52184,1ad52184]
pwt=1ad52194[1ad52194,1ad52194] ptm=1ad521ec[1ad521ec,1ad521ec]
ref=1ad5216c[1ad5216c,1ad5216c] lnd=1ad521f8[1ad515f8,1ad74c88]
LIBRARY OBJECT: object=1ad4e10c
type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
CHILDREN: size=16
child# table reference handle
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: nirmal INET: nirmal_at_haluloffshore.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Sun Aug 31 2003 - 16:04:26 CDT
 |
 |