APPS.CSI_CZ_INT dependencies on CSI_ITEM_INSTANCE_LOCKS

Line 118: FROM CSI_ITEM_INSTANCE_LOCKS

114: x_install_config_rec.source_txn_line_ref2,
115: x_install_config_rec.source_txn_line_ref3,
116: x_install_config_rec.lock_id,
117: x_install_config_rec.lock_status
118: FROM CSI_ITEM_INSTANCE_LOCKS
119: WHERE CONFIG_INST_HDR_ID = p_config_header_id
120: AND CONFIG_INST_ITEM_ID = x_install_config_rec.config_inst_item_id
121: AND LOCK_STATUS <> 0;
122:

Line 467: FROM CSI_ITEM_INSTANCE_LOCKS

463: x_config_pair_table(l_o_ind).source_txn_line_ref2,
464: x_config_pair_table(l_o_ind).source_txn_line_ref3,
465: x_config_pair_table(l_o_ind).lock_id,
466: x_config_pair_table(l_o_ind).lock_status
467: FROM CSI_ITEM_INSTANCE_LOCKS
468: WHERE config_inst_hdr_id = l_root_hdr_id
469: AND config_inst_item_id = l_root_item_id
470: AND LOCK_STATUS <> 0;
471:

Line 832: FROM csi_item_instance_locks

828: SELECT lock_status,
829: lock_id
830: INTO x_lock_status,
831: x_lock_id
832: FROM csi_item_instance_locks
833: WHERE config_inst_hdr_id = p_config_inst_header_id
834: AND config_inst_rev_num = p_config_inst_rev_num
835: AND config_inst_item_id = p_config_inst_item_id;
836:

Line 966: FROM csi_item_instance_locks

962: CURSOR comp_cur(l_root_inst_hdr_id IN number, l_root_inst_rev_num IN number,
963: l_config_inst_hdr_id IN NUMBER,l_config_inst_rev_num IN NUMBER,
964: l_config_inst_item_id IN NUMBER) IS
965: SELECT *
966: FROM csi_item_instance_locks
967: WHERE root_config_inst_hdr_id = l_root_inst_hdr_id
968: AND root_config_inst_rev_num = l_root_inst_rev_num
969: AND NOT( config_inst_hdr_id = l_config_inst_hdr_id
970: AND config_inst_rev_num = l_config_inst_rev_num

Line 1029: FROM csi_item_instance_locks

1025: root_config_inst_item_id
1026: INTO l_root_inst_hdr_id,
1027: l_root_inst_rev_num,
1028: l_root_inst_item_id
1029: FROM csi_item_instance_locks
1030: WHERE config_inst_hdr_id = p_config_rec.config_inst_hdr_id
1031: AND config_inst_rev_num = p_config_rec.config_inst_rev_num
1032: AND config_inst_item_id = p_config_rec.config_inst_item_id;
1033: --

Line 1216: From csi_item_instance_locks

1212: l_lock_config_rec.config_inst_rev_num,
1213: l_lock_config_rec.lock_id,
1214: l_lock_config_rec.source_application_id,
1215: l_lock_config_rec.source_txn_header_ref
1216: From csi_item_instance_locks
1217: Where config_inst_hdr_id = p_config_tbl(1).config_inst_hdr_id
1218: And config_inst_item_id = p_config_tbl(1).config_inst_item_id
1219: And config_inst_rev_num = p_config_tbl(1).config_inst_rev_num;
1220:

Line 1264: -- for the new lines. This creates multiple records in CSI_ITEM_INSTANCE_LOCKS for the config keys.

1260: IF p_config_tbl(1).source_application_id <> 542
1261: THEN
1262: -- This call is made for Cancellation. Suppose we re-configure an existing configuration and cancelling the same,
1263: -- OM unlocks the configuration. When the same order is re-configured again CZ puts the same revision number
1264: -- for the new lines. This creates multiple records in CSI_ITEM_INSTANCE_LOCKS for the config keys.
1265: -- To avoid this, we are deleting the rows upon cancellation.
1266: --
1267: DELETE FROM CSI_ITEM_INSTANCE_LOCKS
1268: WHERE lock_id = l_lock_config_rec.lock_id;

Line 1267: DELETE FROM CSI_ITEM_INSTANCE_LOCKS

1263: -- OM unlocks the configuration. When the same order is re-configured again CZ puts the same revision number
1264: -- for the new lines. This creates multiple records in CSI_ITEM_INSTANCE_LOCKS for the config keys.
1265: -- To avoid this, we are deleting the rows upon cancellation.
1266: --
1267: DELETE FROM CSI_ITEM_INSTANCE_LOCKS
1268: WHERE lock_id = l_lock_config_rec.lock_id;
1269: --
1270: /********* COMMENTED
1271: l_from_cz := 'YES';