APPS.HZ_IMP_LOAD_BATCH_COUNTS_PKG dependencies on HZ_IMP_CONTACTROLES_INT

Line 52: FROM HZ_IMP_CONTACTROLES_INT INT

48: FROM HZ_IMP_RELSHIPS_INT INT
49: WHERE INT.BATCH_ID = P_BATCH_ID AND
50: INT.SUB_ORIG_SYSTEM = P_ORIGINAL_SYSTEM ;
51: SELECT count(INT.BATCH_ID) into l_CONTACTROLES_IN_BATCH
52: FROM HZ_IMP_CONTACTROLES_INT INT
53: WHERE INT.BATCH_ID = P_BATCH_ID AND
54: INT.CONTACT_ORIG_SYSTEM = P_ORIGINAL_SYSTEM ;
55: SELECT count(INT.BATCH_ID) into l_CONTACTS_IN_BATCH
56: FROM HZ_IMP_CONTACTS_INT INT

Line 381: from hz_imp_tmp_errors e, hz_imp_contactroles_sg sg,hz_org_contact_roles hocr, HZ_IMP_CONTACTROLES_INT hzint

377: and hzint.interface_status(+) = 'D'
378: union all
379: select /*+ full(sg) parallel(sg) */ nvl2(e.int_row_id,
380: 1, nvl2(NVL(hocr.org_contact_role_id,hzint.BATCH_ID),decode(sg.action_flag, 'I', 14, 15),24)) a
381: from hz_imp_tmp_errors e, hz_imp_contactroles_sg sg,hz_org_contact_roles hocr, HZ_IMP_CONTACTROLES_INT hzint
382: where sg.batch_mode_flag = p_batch_mode_flag
383: and sg.batch_id = p_batch_id
384: and sg.sub_orig_system = p_original_system
385: and e.int_row_id (+) = sg.int_row_id

Line 387: and e.interface_table_name (+) = 'HZ_IMP_CONTACTROLES_INT'

383: and sg.batch_id = p_batch_id
384: and sg.sub_orig_system = p_original_system
385: and e.int_row_id (+) = sg.int_row_id
386: and e.request_id (+) = p_request_id
387: and e.interface_table_name (+) = 'HZ_IMP_CONTACTROLES_INT'
388: and hocr.org_contact_role_id (+) = sg.contact_role_id
389: -- and hocr.request_id (+) = p_request_id
390: and sg.int_row_id = hzint.rowid (+)
391: and hzint.interface_status(+) = 'D'

Line 829: FROM HZ_IMP_CONTACTROLES_INT INT

825: WHERE INT.BATCH_ID = P_BATCH_ID AND
826: INT.SUB_ORIG_SYSTEM = P_ORIGINAL_SYSTEM
827: AND INT.INTERFACE_STATUS = 'R' ;
828: SELECT count(INT.BATCH_ID) into l_REMOVED_CONTACTROLES
829: FROM HZ_IMP_CONTACTROLES_INT INT
830: WHERE INT.BATCH_ID = P_BATCH_ID AND
831: INT.CONTACT_ORIG_SYSTEM = P_ORIGINAL_SYSTEM
832: AND INT.INTERFACE_STATUS = 'R' ;
833: SELECT count(INT.BATCH_ID) into l_REMOVED_CONTACTS