eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSI_ITEM_INSTANCE_PVT dependencies on CSI_ITEM_INSTANCE_LOCKS

Line 34719: FROM csi_item_instance_locks

34715: l_lock_status NUMBER :=0;
34716: BEGIN
34717: SELECT lock_status
34718: INTO p_lock_status
34719: FROM csi_item_instance_locks
34720: WHERE lock_status <> l_lock_status
34721: AND instance_id=p_instance_id;
34722: EXCEPTION
34723: WHEN NO_DATA_FOUND THEN

Line 34747: FROM csi_item_instance_locks

34743: THEN
34744: BEGIN
34745: SELECT lock_id
34746: INTO l_lock_id
34747: FROM csi_item_instance_locks
34748: WHERE lock_status IS NOT NULL
34749: AND lock_status <> l_lock_status
34750: AND instance_id=p_instance_id;
34751: l_return_value := TRUE;

Line 34768: FROM csi_item_instance_locks

34764: THEN
34765: BEGIN
34766: SELECT lock_id
34767: INTO l_lock_id
34768: FROM csi_item_instance_locks
34769: WHERE lock_status IS NOT NULL
34770: AND lock_status <> l_lock_status
34771: AND config_inst_hdr_id = p_config_inst_hdr_id
34772: AND config_inst_rev_num = p_config_inst_rev_num

Line 35161: SELECT csi_item_instance_locks_s.NEXTVAL

35157: END IF;
35158:
35159:
35160:
35161: SELECT csi_item_instance_locks_s.NEXTVAL
35162: INTO l_lock_id
35163: FROM SYS.dual;
35164:
35165: IF px_config_tbl.COUNT > 0

Line 35247: INSERT INTO csi_item_instance_locks

35243: FOR l_insert_csr IN l_lock_tbl.FIRST .. l_lock_tbl.LAST
35244: LOOP
35245: IF l_lock_tbl.EXISTS(l_insert_csr)
35246: THEN
35247: INSERT INTO csi_item_instance_locks
35248: ( lock_id
35249: ,lock_status
35250: ,instance_id
35251: ,config_inst_hdr_id

Line 35384: FROM csi_item_instance_locks

35380: SELECT lock_status
35381: ,root_instance_id
35382: INTO l_lock_status
35383: ,l_root_instance_id
35384: FROM csi_item_instance_locks
35385: WHERE instance_id=p_instance_id
35386: AND lock_id = p_lock_id;
35387: IF p_instance_id = l_root_instance_id
35388: THEN

Line 35413: FROM csi_item_instance_locks

35409: INTO l_lock_status
35410: ,l_root_config_hdr_id
35411: ,l_root_config_item_id
35412: ,l_root_config_rev_num
35413: FROM csi_item_instance_locks
35414: WHERE config_inst_hdr_id = p_config_inst_hdr_id
35415: AND config_inst_rev_num = p_config_inst_rev_num
35416: AND config_inst_item_id = p_config_inst_item_id
35417: AND lock_id = p_lock_id;

Line 35451: FROM csi_item_instance_locks

35447: SELECT config_inst_hdr_id,
35448: config_inst_item_id,
35449: config_inst_rev_num,
35450: lock_status
35451: FROM csi_item_instance_locks
35452: WHERE root_config_inst_hdr_id = p_root_hdr
35453: AND root_config_inst_rev_num = p_root_rev
35454: AND lock_id = p_lock_id
35455: AND lock_status <> p_lock_status;

Line 35466: FROM csi_item_instance_locks

35462: SELECT root_config_inst_hdr_id,
35463: root_config_inst_rev_num
35464: INTO l_root_hdr_id,
35465: l_root_rev_num
35466: FROM csi_item_instance_locks
35467: WHERE lock_id = p_lock_id
35468: AND config_inst_hdr_id = p_config_inst_hdr_id
35469: AND config_inst_rev_num = p_config_inst_rev_num
35470: AND config_inst_item_id = p_config_inst_item_id;

Line 35510: UPDATE csi_item_instance_locks

35506: FOR i IN p_unlock_tbl.FIRST .. p_unlock_tbl.LAST
35507: LOOP
35508: IF p_unlock_tbl.EXISTS(i)
35509: THEN
35510: UPDATE csi_item_instance_locks
35511: SET lock_status= p_unlock_tbl(i).lock_status
35512: ,unlock_source_appln_id = decode (p_unlock_tbl(i).source_application_id,fnd_api.g_miss_num,unlock_source_appln_id,p_unlock_tbl(i).source_application_id)
35513: ,unlock_source_header_ref = decode (p_unlock_tbl(i).source_txn_header_ref,fnd_api.g_miss_char,unlock_source_header_ref,p_unlock_tbl(i).source_txn_header_ref)
35514: ,unlock_source_line_ref1 = decode (p_unlock_tbl(i).source_txn_line_ref1,fnd_api.g_miss_char,unlock_source_line_ref1,p_unlock_tbl(i).source_txn_line_ref1)

Line 35535: UPDATE csi_item_instance_locks

35531: FOR i IN p_unlock_tbl.FIRST .. p_unlock_tbl.LAST
35532: LOOP
35533: IF p_unlock_tbl.EXISTS(i)
35534: THEN
35535: UPDATE csi_item_instance_locks
35536: SET lock_status= p_unlock_tbl(i).lock_status
35537: ,unlock_source_appln_id = decode (p_unlock_tbl(i).source_application_id,fnd_api.g_miss_num,unlock_source_appln_id,p_unlock_tbl(i).source_application_id)
35538: ,unlock_source_header_ref = decode (p_unlock_tbl(i).source_txn_header_ref,fnd_api.g_miss_char,unlock_source_header_ref,p_unlock_tbl(i).source_txn_header_ref)
35539: ,unlock_source_line_ref1 = decode (p_unlock_tbl(i).source_txn_line_ref1,fnd_api.g_miss_char,unlock_source_line_ref1,p_unlock_tbl(i).source_txn_line_ref1)

Line 35998: FROM csi_item_instance_locks

35994: IF l_unlock_ins_tbl(i).lock_status=0
35995: THEN
35996: SELECT COUNT(*)
35997: INTO l_instance_ctr
35998: FROM csi_item_instance_locks
35999: WHERE root_instance_id =l_unlock_ins_tbl(i).instance_id
36000: AND lock_id = l_unlock_ins_tbl(i).lock_id
36001: AND lock_status IN (1,2);
36002: IF l_instance_ctr >1 -- this includes root

Line 36027: FROM csi_item_instance_locks

36023: IF l_unlock_root(i).lock_status=0
36024: THEN
36025: SELECT COUNT(*)
36026: INTO l_config_ctr
36027: FROM csi_item_instance_locks
36028: WHERE root_config_inst_hdr_id =l_unlock_root(i).config_inst_hdr_id
36029: AND root_config_inst_item_id = l_unlock_root(i).config_inst_item_id
36030: AND root_config_inst_rev_num = l_unlock_root(i).config_inst_rev_num
36031: AND lock_id = l_unlock_root(i).lock_id