APPS.CSI_ML_INTERFACE_TXN_PVT dependencies on CSI_II_RELATION_INTERFACE

Line 270: FROM csi_ii_relation_interface ciri,

266: cii1.instance_id new_subject_id,
267: cii2.instance_id new_object_id,
268: cii1.source_transaction_date source_transaction_date,
269: cii1.transaction_identifier transaction_identifier
270: FROM csi_ii_relation_interface ciri,
271: csi_instance_interface cii1,
272: csi_instance_interface cii2
273: WHERE ciri.subject_interface_id = cii1.inst_interface_id
274: AND cii1.transaction_identifier = p_txn_ident

Line 312: FROM csi_ii_relation_interface ciri

308: ciri.relationship_direction,
309: ciri.created_by created_by,
310: ciri.subject_id subject_id,
311: ciri.object_id object_id
312: FROM csi_ii_relation_interface ciri
313: WHERE ciri.process_status IN ('R')
314: AND (nvl(ciri.source_system_name, '$CSI_NULL_VALUE$') = nvl(p_source_system_name, '$CSI_NULL_VALUE$')
315: or nvl(ciri.source_system_name, '$CSI_NULL_VALUE$') = nvl(p_source_system_name, ciri.source_system_name)
316: )/*Added for 6443959*/;

Line 3213: FROM csi_ii_relation_interface

3209: BEGIN
3210: -- Added for releationships
3211: SELECT count(*)
3212: INTO l_found
3213: FROM csi_ii_relation_interface
3214: WHERE process_status='R';
3215:
3216: IF l_found>0
3217: THEN

Line 3284: UPDATE csi_ii_relation_interface

3280: l_msg_index := l_msg_index + 1;
3281: l_Msg_Count := l_Msg_Count - 1;
3282: END LOOP;
3283: --RAISE g_exc_error;
3284: UPDATE csi_ii_relation_interface
3285: SET process_status ='E'
3286: ,error_text = l_Error_Message
3287: WHERE rel_interface_id = irel_det_rec.rel_interface_id;
3288: l_rel_failure_count := l_rel_failure_count +1;

Line 3290: UPDATE csi_ii_relation_interface

3286: ,error_text = l_Error_Message
3287: WHERE rel_interface_id = irel_det_rec.rel_interface_id;
3288: l_rel_failure_count := l_rel_failure_count +1;
3289: ELSE
3290: UPDATE csi_ii_relation_interface
3291: SET process_status ='P'
3292: WHERE rel_interface_id = irel_det_rec.rel_interface_id;
3293: l_rel_success_count := l_rel_success_count + 1;
3294: END IF;

Line 3425: UPDATE csi_ii_relation_interface

3421: l_msg_index := l_msg_index + 1;
3422: l_Msg_Count := l_Msg_Count - 1;
3423: END LOOP;
3424: --RAISE g_exc_error;
3425: UPDATE csi_ii_relation_interface
3426: SET process_status ='E'
3427: ,error_text = l_Error_Message
3428: WHERE rel_interface_id = irel_det_rec.rel_interface_id;
3429: l_rel_failure_count := l_rel_failure_count +1;

Line 3431: UPDATE csi_ii_relation_interface

3427: ,error_text = l_Error_Message
3428: WHERE rel_interface_id = irel_det_rec.rel_interface_id;
3429: l_rel_failure_count := l_rel_failure_count +1;
3430: ELSE
3431: UPDATE csi_ii_relation_interface
3432: SET process_status ='P'
3433: WHERE rel_interface_id = irel_det_rec.rel_interface_id;
3434: l_rel_success_count := l_rel_success_count + 1;
3435: END IF;