APPS.HZ_BATCH_ACTION_PUB dependencies on HZ_IMP_CONTACTROLES_INT

Line 678: UPDATE HZ_IMP_CONTACTROLES_INT

674: END IF;
675:
676: --//Update contact roles
677: FORALL i in l_record_osr.FIRST..l_record_osr.LAST
678: UPDATE HZ_IMP_CONTACTROLES_INT
679: SET interface_status = 'R'
680: WHERE batch_id = p_batch_id
681: AND contact_orig_system = l_record_os(i)
682: AND contact_orig_system_reference = l_record_osr(i);

Line 1331: UPDATE HZ_IMP_CONTACTROLES_INT

1327: EXIT;
1328: END IF;
1329:
1330: FORALL i in l_int_rowid.FIRST..l_int_rowid.LAST
1331: UPDATE HZ_IMP_CONTACTROLES_INT
1332: SET interface_status = 'R'
1333: WHERE rowid = l_int_rowid(i) ;
1334:
1335: IF l_last_fetch = TRUE THEN

Line 1828: UPDATE HZ_IMP_CONTACTROLES_INT

1824: AND ( interface_status = 'R' OR dqm_action_flag is not NULL );
1825:
1826: --Contact Roles
1827: FORALL i in l_dup_osr_cont.FIRST..l_dup_osr_cont.LAST
1828: UPDATE HZ_IMP_CONTACTROLES_INT
1829: SET interface_status = NULL
1830: WHERE batch_id = p_batch_id
1831: AND contact_orig_system = l_dup_os_cont(i)
1832: AND contact_orig_system_reference = l_dup_osr_cont(i)

Line 2464: UPDATE HZ_IMP_CONTACTROLES_INT

2460: RETURNING contact_orig_system,contact_orig_system_reference BULK COLLECT into l_cont_orig_os,l_cont_orig_osr;
2461:
2462: --Child entities for Contact
2463: FORALL i in l_cont_orig_osr.FIRST..l_cont_orig_osr.LAST
2464: UPDATE HZ_IMP_CONTACTROLES_INT
2465: SET INTERFACE_STATUS = 'R'
2466: WHERE batch_id = p_batch_id
2467: AND contact_orig_system = l_cont_orig_os(i)
2468: AND contact_orig_system_reference = l_cont_orig_osr(i) ;

Line 2663: UPDATE HZ_IMP_CONTACTROLES_INT

2659: AND contact_orig_system_reference = l_cont_orig_osr(i) ;
2660:
2661: --Child entities for Contact
2662: FORALL i in l_cont_orig_osr.FIRST..l_cont_orig_osr.LAST
2663: UPDATE HZ_IMP_CONTACTROLES_INT
2664: SET INTERFACE_STATUS = 'R'
2665: WHERE batch_id = p_batch_id
2666: AND contact_orig_system = l_cont_orig_os(i)
2667: AND contact_orig_system_reference = l_cont_orig_osr(i) ;