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

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

Line 1031: FROM csi_item_instance_locks

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

Line 1138: FROM csi_item_instance_locks

1134: l_root_rec.lock_status,
1135: l_root_rec.source_txn_header_ref,
1136: l_root_rec.source_txn_line_ref1,
1137: l_root_rec.source_application_id
1138: FROM csi_item_instance_locks
1139: WHERE config_inst_hdr_id = root_config_inst_hdr_id
1140: AND config_inst_rev_num = root_config_inst_rev_num
1141: AND config_inst_item_id = root_config_inst_item_id;
1142:

Line 1257: From csi_item_instance_locks

1253: l_lock_config_rec.config_inst_rev_num,
1254: l_lock_config_rec.lock_id,
1255: l_lock_config_rec.source_application_id,
1256: l_lock_config_rec.source_txn_header_ref
1257: From csi_item_instance_locks
1258: Where config_inst_hdr_id = p_config_tbl(1).config_inst_hdr_id
1259: And config_inst_item_id = p_config_tbl(1).config_inst_item_id
1260: And config_inst_rev_num = p_config_tbl(1).config_inst_rev_num;
1261:

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

1301: IF p_config_tbl(1).source_application_id <> 542
1302: THEN
1303: -- This call is made for Cancellation. Suppose we re-configure an existing configuration and cancelling the same,
1304: -- OM unlocks the configuration. When the same order is re-configured again CZ puts the same revision number
1305: -- for the new lines. This creates multiple records in CSI_ITEM_INSTANCE_LOCKS for the config keys.
1306: -- To avoid this, we are deleting the rows upon cancellation.
1307: --
1308: DELETE FROM CSI_ITEM_INSTANCE_LOCKS
1309: WHERE lock_id = l_lock_config_rec.lock_id;

Line 1308: DELETE FROM CSI_ITEM_INSTANCE_LOCKS

1304: -- OM unlocks the configuration. When the same order is re-configured again CZ puts the same revision number
1305: -- for the new lines. This creates multiple records in CSI_ITEM_INSTANCE_LOCKS for the config keys.
1306: -- To avoid this, we are deleting the rows upon cancellation.
1307: --
1308: DELETE FROM CSI_ITEM_INSTANCE_LOCKS
1309: WHERE lock_id = l_lock_config_rec.lock_id;
1310: --
1311: /********* COMMENTED
1312: l_from_cz := 'YES';