APPS.CSI_ML_INTERFACE_TXN_PVT dependencies on CSI_II_RELATION_INTERFACE

Line 264: FROM csi_ii_relation_interface ciri,

260: cii1.instance_id new_subject_id,
261: cii2.instance_id new_object_id,
262: cii1.source_transaction_date source_transaction_date,
263: cii1.transaction_identifier transaction_identifier
264: FROM csi_ii_relation_interface ciri,
265: csi_instance_interface cii1,
266: csi_instance_interface cii2
267: WHERE ciri.subject_interface_id = cii1.inst_interface_id
268: AND cii1.transaction_identifier = p_txn_ident

Line 306: FROM csi_ii_relation_interface ciri

302: ciri.relationship_direction,
303: ciri.created_by created_by,
304: ciri.subject_id subject_id,
305: ciri.object_id object_id
306: FROM csi_ii_relation_interface ciri
307: WHERE ciri.process_status IN ('R')
308: AND (nvl(ciri.source_system_name, '$CSI_NULL_VALUE$') = nvl(p_source_system_name, '$CSI_NULL_VALUE$')
309: or nvl(ciri.source_system_name, '$CSI_NULL_VALUE$') = nvl(p_source_system_name, ciri.source_system_name)
310: )/*Added for 6443959*/;

Line 3090: FROM csi_ii_relation_interface

3086: BEGIN
3087: -- Added for releationships
3088: SELECT count(*)
3089: INTO l_found
3090: FROM csi_ii_relation_interface
3091: WHERE process_status='R';
3092:
3093: IF l_found>0
3094: THEN

Line 3161: UPDATE csi_ii_relation_interface

3157: l_msg_index := l_msg_index + 1;
3158: l_Msg_Count := l_Msg_Count - 1;
3159: END LOOP;
3160: --RAISE g_exc_error;
3161: UPDATE csi_ii_relation_interface
3162: SET process_status ='E'
3163: ,error_text = l_Error_Message
3164: WHERE rel_interface_id = irel_det_rec.rel_interface_id;
3165: l_rel_failure_count := l_rel_failure_count +1;

Line 3167: UPDATE csi_ii_relation_interface

3163: ,error_text = l_Error_Message
3164: WHERE rel_interface_id = irel_det_rec.rel_interface_id;
3165: l_rel_failure_count := l_rel_failure_count +1;
3166: ELSE
3167: UPDATE csi_ii_relation_interface
3168: SET process_status ='P'
3169: WHERE rel_interface_id = irel_det_rec.rel_interface_id;
3170: l_rel_success_count := l_rel_success_count + 1;
3171: END IF;

Line 3302: UPDATE csi_ii_relation_interface

3298: l_msg_index := l_msg_index + 1;
3299: l_Msg_Count := l_Msg_Count - 1;
3300: END LOOP;
3301: --RAISE g_exc_error;
3302: UPDATE csi_ii_relation_interface
3303: SET process_status ='E'
3304: ,error_text = l_Error_Message
3305: WHERE rel_interface_id = irel_det_rec.rel_interface_id;
3306: l_rel_failure_count := l_rel_failure_count +1;

Line 3308: UPDATE csi_ii_relation_interface

3304: ,error_text = l_Error_Message
3305: WHERE rel_interface_id = irel_det_rec.rel_interface_id;
3306: l_rel_failure_count := l_rel_failure_count +1;
3307: ELSE
3308: UPDATE csi_ii_relation_interface
3309: SET process_status ='P'
3310: WHERE rel_interface_id = irel_det_rec.rel_interface_id;
3311: l_rel_success_count := l_rel_success_count + 1;
3312: END IF;