APPS.CSI_ML_CREATE_PVT dependencies on CSI_INSTANCE_INTERFACE

Line 65: FROM csi_instance_interface cii

61: pc_source_system_name IN VARCHAR2,
62: pc_worker_id IN NUMBER DEFAULT NULL,
63: pc_commit_recs IN NUMBER) IS
64: SELECT cii.*
65: FROM csi_instance_interface cii
66: WHERE trunc(cii.source_transaction_date) between
67: nvl(pc_txn_from_date,trunc(cii.source_transaction_date)) and
68: nvl(pc_txn_to_date,trunc(cii.source_transaction_date))
69: AND cii.process_status = 'X'

Line 132: UPDATE CSI_INSTANCE_INTERFACE cii

128: BEGIN
129: fnd_message.set_name('CSI','CSI_INTERFACE_LOC_TYPE_CODE');
130: l_error_message := fnd_message.get;
131:
132: UPDATE CSI_INSTANCE_INTERFACE cii
133: SET error_text =l_error_message
134: ,process_status ='E'
135: WHERE nvl(parallel_worker_id,-1) = nvl(p_worker_id,nvl(parallel_worker_id,-1))
136: AND cii.process_status = 'X'

Line 149: UPDATE CSI_INSTANCE_INTERFACE cii

145:
146: fnd_message.set_name('CSI','CSI_ML_NO_ASSET_FOR_CT');
147: l_error_message := fnd_message.get;
148:
149: UPDATE CSI_INSTANCE_INTERFACE cii
150: SET error_text =l_error_message
151: ,process_status ='E'
152: WHERE nvl(parallel_worker_id,-1) = nvl(p_worker_id,nvl(parallel_worker_id,-1))
153: AND cii.process_status = 'X'

Line 173: UPDATE CSI_INSTANCE_INTERFACE cii

169:
170: fnd_message.set_name('CSI','CSI_NO_ASSET_ASSN_FOUND');
171: l_error_message := fnd_message.get;
172:
173: UPDATE CSI_INSTANCE_INTERFACE cii
174: SET error_text =l_error_message
175: ,process_status ='E'
176: WHERE nvl(parallel_worker_id,-1) = nvl(p_worker_id,nvl(parallel_worker_id,-1))
177: AND cii.process_status = 'X'

Line 198: UPDATE CSI_INSTANCE_INTERFACE cii

194: /* IB UI allows us to create an internally owned instance without an asset association.
195: fnd_message.set_name('CSI','CSI_API_ASSET_REQUIRED');
196: l_error_message := fnd_message.get;
197:
198: UPDATE CSI_INSTANCE_INTERFACE cii
199: SET error_text =l_error_message
200: ,process_status ='E'
201: WHERE nvl(parallel_worker_id,-1) = nvl(p_worker_id,nvl(parallel_worker_id,-1))
202: AND cii.process_status = 'X'

Line 750: -- in csi_instance_interface is under discussion

746: p_instance_tbl(inst_idx).config_valid_status := r_inst.config_valid_status;
747: END IF;
748:
749: -- Commenting the code as existence of instance_usage_code
750: -- in csi_instance_interface is under discussion
751: /*
752: IF r_inst.instance_usage_code IS NULL THEN
753: p_instance_tbl(inst_idx).INSTANCE_usage_code := l_fnd_g_char;
754: ELSE

Line 2576: csi_instance_interface cii1,

2572: ,cii1.transaction_identifier transaction_identifier
2573: ,cii1.instance_id subject_instance_id
2574: ,cii2.instance_id object_instance_id
2575: FROM csi_ii_relation_interface ciri,
2576: csi_instance_interface cii1,
2577: csi_instance_interface cii2
2578: WHERE trunc(cii1.source_transaction_date) between
2579: nvl(pc_txn_from_date,trunc(cii1.source_transaction_date)) and
2580: nvl(pc_txn_to_date,trunc(cii1.source_transaction_date))

Line 2577: csi_instance_interface cii2

2573: ,cii1.instance_id subject_instance_id
2574: ,cii2.instance_id object_instance_id
2575: FROM csi_ii_relation_interface ciri,
2576: csi_instance_interface cii1,
2577: csi_instance_interface cii2
2578: WHERE trunc(cii1.source_transaction_date) between
2579: nvl(pc_txn_from_date,trunc(cii1.source_transaction_date)) and
2580: nvl(pc_txn_to_date,trunc(cii1.source_transaction_date))
2581: AND cii1.process_status in ('X','E')