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 35376: FROM csi_item_instance_locks

35372: l_lock_status NUMBER :=0;
35373: BEGIN
35374: SELECT lock_status
35375: INTO p_lock_status
35376: FROM csi_item_instance_locks
35377: WHERE lock_status <> l_lock_status
35378: AND instance_id=p_instance_id;
35379: EXCEPTION
35380: WHEN NO_DATA_FOUND THEN

Line 35404: FROM csi_item_instance_locks

35400: THEN
35401: BEGIN
35402: SELECT lock_id
35403: INTO l_lock_id
35404: FROM csi_item_instance_locks
35405: WHERE lock_status IS NOT NULL
35406: AND lock_status <> l_lock_status
35407: AND instance_id=p_instance_id;
35408: l_return_value := TRUE;

Line 35425: FROM csi_item_instance_locks

35421: THEN
35422: BEGIN
35423: SELECT lock_id
35424: INTO l_lock_id
35425: FROM csi_item_instance_locks
35426: WHERE lock_status IS NOT NULL
35427: AND lock_status <> l_lock_status
35428: AND config_inst_hdr_id = p_config_inst_hdr_id
35429: AND config_inst_rev_num = p_config_inst_rev_num

Line 35818: SELECT csi_item_instance_locks_s.NEXTVAL

35814: END IF;
35815:
35816:
35817:
35818: SELECT csi_item_instance_locks_s.NEXTVAL
35819: INTO l_lock_id
35820: FROM SYS.dual;
35821:
35822: IF px_config_tbl.COUNT > 0

Line 35904: INSERT INTO csi_item_instance_locks

35900: FOR l_insert_csr IN l_lock_tbl.FIRST .. l_lock_tbl.LAST
35901: LOOP
35902: IF l_lock_tbl.EXISTS(l_insert_csr)
35903: THEN
35904: INSERT INTO csi_item_instance_locks
35905: ( lock_id
35906: ,lock_status
35907: ,instance_id
35908: ,config_inst_hdr_id

Line 36045: FROM csi_item_instance_locks

36041: SELECT lock_status
36042: ,root_instance_id
36043: INTO l_lock_status
36044: ,l_root_instance_id
36045: FROM csi_item_instance_locks
36046: WHERE instance_id=p_instance_id
36047: AND lock_id = p_lock_id;
36048: IF p_instance_id = l_root_instance_id
36049: THEN

Line 36074: FROM csi_item_instance_locks

36070: INTO l_lock_status
36071: ,l_root_config_hdr_id
36072: ,l_root_config_item_id
36073: ,l_root_config_rev_num
36074: FROM csi_item_instance_locks
36075: WHERE config_inst_hdr_id = p_config_inst_hdr_id
36076: AND config_inst_rev_num = p_config_inst_rev_num
36077: AND config_inst_item_id = p_config_inst_item_id
36078: AND lock_id = p_lock_id;

Line 36112: FROM csi_item_instance_locks

36108: SELECT config_inst_hdr_id,
36109: config_inst_item_id,
36110: config_inst_rev_num,
36111: lock_status
36112: FROM csi_item_instance_locks
36113: WHERE root_config_inst_hdr_id = p_root_hdr
36114: AND root_config_inst_rev_num = p_root_rev
36115: AND lock_id = p_lock_id
36116: AND lock_status <> p_lock_status;

Line 36127: FROM csi_item_instance_locks

36123: SELECT root_config_inst_hdr_id,
36124: root_config_inst_rev_num
36125: INTO l_root_hdr_id,
36126: l_root_rev_num
36127: FROM csi_item_instance_locks
36128: WHERE lock_id = p_lock_id
36129: AND config_inst_hdr_id = p_config_inst_hdr_id
36130: AND config_inst_rev_num = p_config_inst_rev_num
36131: AND config_inst_item_id = p_config_inst_item_id;

Line 36171: UPDATE csi_item_instance_locks

36167: FOR i IN p_unlock_tbl.FIRST .. p_unlock_tbl.LAST
36168: LOOP
36169: IF p_unlock_tbl.EXISTS(i)
36170: THEN
36171: UPDATE csi_item_instance_locks
36172: SET lock_status= p_unlock_tbl(i).lock_status
36173: ,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)
36174: ,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)
36175: ,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 36196: UPDATE csi_item_instance_locks

36192: FOR i IN p_unlock_tbl.FIRST .. p_unlock_tbl.LAST
36193: LOOP
36194: IF p_unlock_tbl.EXISTS(i)
36195: THEN
36196: UPDATE csi_item_instance_locks
36197: SET lock_status= p_unlock_tbl(i).lock_status
36198: ,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)
36199: ,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)
36200: ,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 36659: FROM csi_item_instance_locks

36655: IF l_unlock_ins_tbl(i).lock_status=0
36656: THEN
36657: SELECT COUNT(*)
36658: INTO l_instance_ctr
36659: FROM csi_item_instance_locks
36660: WHERE root_instance_id =l_unlock_ins_tbl(i).instance_id
36661: AND lock_id = l_unlock_ins_tbl(i).lock_id
36662: AND lock_status IN (1,2);
36663: IF l_instance_ctr >1 -- this includes root

Line 36688: FROM csi_item_instance_locks

36684: IF l_unlock_root(i).lock_status=0
36685: THEN
36686: SELECT COUNT(*)
36687: INTO l_config_ctr
36688: FROM csi_item_instance_locks
36689: WHERE root_config_inst_hdr_id =l_unlock_root(i).config_inst_hdr_id
36690: AND root_config_inst_item_id = l_unlock_root(i).config_inst_item_id
36691: AND root_config_inst_rev_num = l_unlock_root(i).config_inst_rev_num
36692: AND lock_id = l_unlock_root(i).lock_id