DBA Data[Home] [Help]

APPS.HZ_IMP_LOAD_BATCH_COUNTS_PKG dependencies on HZ_IMP_CONTACTROLES_SG

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 691: FROM HZ_IMP_CONTACTROLES_SG INT

687: INT.SUB_ORIG_SYSTEM = P_ORIGINAL_SYSTEM
688: AND INT.ACTION_FLAG = 'I' ;
689: -- for l_NEW_UNIQUE_CONTACTROLES
690: SELECT count(INT.BATCH_ID) into l_NEW_UNIQUE_CONTACTROLES
691: FROM HZ_IMP_CONTACTROLES_SG INT
692: WHERE INT.BATCH_ID = P_BATCH_ID AND
693: INT.SUB_ORIG_SYSTEM = P_ORIGINAL_SYSTEM
694: AND INT.ACTION_FLAG = 'I' ;
695: -- for l_NEW_UNIQUE_CONTACTS

Line 767: FROM HZ_IMP_CONTACTROLES_SG INT

763: INT.SUB_ORIG_SYSTEM = P_ORIGINAL_SYSTEM
764: AND INT.ACTION_FLAG = 'U' ;
765: -- for l_EXISTING_CONTACTROLES
766: SELECT count(INT.BATCH_ID) into l_EXISTING_CONTACTROLES
767: FROM HZ_IMP_CONTACTROLES_SG INT
768: WHERE INT.BATCH_ID = P_BATCH_ID AND
769: INT.SUB_ORIG_SYSTEM = P_ORIGINAL_SYSTEM
770: AND INT.ACTION_FLAG = 'U' ;
771: -- for l_EXISTING_CONTACTS