APPS.CSI_ML_CREATE_PVT dependencies on CSI_INSTANCE_INTERFACE

Line 63: FROM csi_instance_interface cii

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

Line 124: UPDATE CSI_INSTANCE_INTERFACE cii

120: BEGIN
121: fnd_message.set_name('CSI','CSI_INTERFACE_LOC_TYPE_CODE');
122: l_error_message := fnd_message.get;
123:
124: UPDATE CSI_INSTANCE_INTERFACE cii
125: SET error_text =l_error_message
126: ,process_status ='E'
127: WHERE nvl(parallel_worker_id,-1) = nvl(p_worker_id,nvl(parallel_worker_id,-1))
128: AND cii.process_status = 'X'

Line 141: UPDATE CSI_INSTANCE_INTERFACE cii

137:
138: fnd_message.set_name('CSI','CSI_ML_NO_ASSET_FOR_CT');
139: l_error_message := fnd_message.get;
140:
141: UPDATE CSI_INSTANCE_INTERFACE cii
142: SET error_text =l_error_message
143: ,process_status ='E'
144: WHERE nvl(parallel_worker_id,-1) = nvl(p_worker_id,nvl(parallel_worker_id,-1))
145: AND cii.process_status = 'X'

Line 165: UPDATE CSI_INSTANCE_INTERFACE cii

161:
162: fnd_message.set_name('CSI','CSI_NO_ASSET_ASSN_FOUND');
163: l_error_message := fnd_message.get;
164:
165: UPDATE CSI_INSTANCE_INTERFACE cii
166: SET error_text =l_error_message
167: ,process_status ='E'
168: WHERE nvl(parallel_worker_id,-1) = nvl(p_worker_id,nvl(parallel_worker_id,-1))
169: AND cii.process_status = 'X'

Line 188: UPDATE CSI_INSTANCE_INTERFACE cii

184:
185: fnd_message.set_name('CSI','CSI_API_ASSET_REQUIRED');
186: l_error_message := fnd_message.get;
187:
188: UPDATE CSI_INSTANCE_INTERFACE cii
189: SET error_text =l_error_message
190: ,process_status ='E'
191: WHERE nvl(parallel_worker_id,-1) = nvl(p_worker_id,nvl(parallel_worker_id,-1))
192: AND cii.process_status = 'X'

Line 740: -- in csi_instance_interface is under discussion

736: p_instance_tbl(inst_idx).config_valid_status := r_inst.config_valid_status;
737: END IF;
738:
739: -- Commenting the code as existence of instance_usage_code
740: -- in csi_instance_interface is under discussion
741: /*
742: IF r_inst.instance_usage_code IS NULL THEN
743: p_instance_tbl(inst_idx).INSTANCE_usage_code := l_fnd_g_char;
744: ELSE

Line 2558: csi_instance_interface cii1,

2554: ,cii1.transaction_identifier transaction_identifier
2555: ,cii1.instance_id subject_instance_id
2556: ,cii2.instance_id object_instance_id
2557: FROM csi_ii_relation_interface ciri,
2558: csi_instance_interface cii1,
2559: csi_instance_interface cii2
2560: WHERE trunc(cii1.source_transaction_date) between
2561: nvl(pc_txn_from_date,trunc(cii1.source_transaction_date)) and
2562: nvl(pc_txn_to_date,trunc(cii1.source_transaction_date))

Line 2559: csi_instance_interface cii2

2555: ,cii1.instance_id subject_instance_id
2556: ,cii2.instance_id object_instance_id
2557: FROM csi_ii_relation_interface ciri,
2558: csi_instance_interface cii1,
2559: csi_instance_interface cii2
2560: WHERE trunc(cii1.source_transaction_date) between
2561: nvl(pc_txn_from_date,trunc(cii1.source_transaction_date)) and
2562: nvl(pc_txn_to_date,trunc(cii1.source_transaction_date))
2563: AND cii1.process_status in ('X','E')