eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_PARTY_STAGE dependencies on HZ_STAGE_MAP_TRANSFORM_UPD

Line 737: log('Generating package body for HZ_STAGE_MAP_TRANSFORM_UPD');

733: x_rebuild_cpt_idx OUT NOCOPY BOOLEAN) IS
734:
735: BEGIN
736:
737: log('Generating package body for HZ_STAGE_MAP_TRANSFORM_UPD');
738: HZ_GEN_PLSQL.new('HZ_STAGE_MAP_TRANSFORM_UPD', 'PACKAGE BODY');
739: l('CREATE OR REPLACE PACKAGE BODY HZ_STAGE_MAP_TRANSFORM_UPD AS');
740:
741: generate_declarations;

Line 738: HZ_GEN_PLSQL.new('HZ_STAGE_MAP_TRANSFORM_UPD', 'PACKAGE BODY');

734:
735: BEGIN
736:
737: log('Generating package body for HZ_STAGE_MAP_TRANSFORM_UPD');
738: HZ_GEN_PLSQL.new('HZ_STAGE_MAP_TRANSFORM_UPD', 'PACKAGE BODY');
739: l('CREATE OR REPLACE PACKAGE BODY HZ_STAGE_MAP_TRANSFORM_UPD AS');
740:
741: generate_declarations;
742: generate_party_query_upd(x_rebuild_party_idx);

Line 739: l('CREATE OR REPLACE PACKAGE BODY HZ_STAGE_MAP_TRANSFORM_UPD AS');

735: BEGIN
736:
737: log('Generating package body for HZ_STAGE_MAP_TRANSFORM_UPD');
738: HZ_GEN_PLSQL.new('HZ_STAGE_MAP_TRANSFORM_UPD', 'PACKAGE BODY');
739: l('CREATE OR REPLACE PACKAGE BODY HZ_STAGE_MAP_TRANSFORM_UPD AS');
740:
741: generate_declarations;
742: generate_party_query_upd(x_rebuild_party_idx);
743: generate_party_site_query_upd(x_rebuild_psite_idx);

Line 2797: HZ_STAGE_MAP_TRANSFORM_UPD.open_party_cursor(

2793:
2794: END IF;
2795:
2796: HZ_TRANS_PKG.set_party_type('ORGANIZATION');
2797: HZ_STAGE_MAP_TRANSFORM_UPD.open_party_cursor(
2798: 'ORGANIZATION',l_worker_number, l_num_workers, l_party_cur);
2799: IF l_party_cur IS NOT NULL THEN
2800: HZ_STAGE_MAP_TRANSFORM_UPD.update_stage_parties(l_party_cur);
2801: CLOSE l_party_cur;

Line 2800: HZ_STAGE_MAP_TRANSFORM_UPD.update_stage_parties(l_party_cur);

2796: HZ_TRANS_PKG.set_party_type('ORGANIZATION');
2797: HZ_STAGE_MAP_TRANSFORM_UPD.open_party_cursor(
2798: 'ORGANIZATION',l_worker_number, l_num_workers, l_party_cur);
2799: IF l_party_cur IS NOT NULL THEN
2800: HZ_STAGE_MAP_TRANSFORM_UPD.update_stage_parties(l_party_cur);
2801: CLOSE l_party_cur;
2802: END IF;
2803:
2804: l_log_step := 'STEP1';

Line 2831: HZ_STAGE_MAP_TRANSFORM_UPD.open_party_cursor(

2827:
2828: END IF;
2829:
2830: HZ_TRANS_PKG.set_party_type('PERSON');
2831: HZ_STAGE_MAP_TRANSFORM_UPD.open_party_cursor(
2832: 'PERSON',l_worker_number, l_num_workers, l_party_cur);
2833:
2834: IF l_party_cur IS NOT NULL THEN
2835: HZ_STAGE_MAP_TRANSFORM_UPD.update_stage_parties(l_party_cur);

Line 2835: HZ_STAGE_MAP_TRANSFORM_UPD.update_stage_parties(l_party_cur);

2831: HZ_STAGE_MAP_TRANSFORM_UPD.open_party_cursor(
2832: 'PERSON',l_worker_number, l_num_workers, l_party_cur);
2833:
2834: IF l_party_cur IS NOT NULL THEN
2835: HZ_STAGE_MAP_TRANSFORM_UPD.update_stage_parties(l_party_cur);
2836: CLOSE l_party_cur;
2837: END IF;
2838: l_log_step := 'STEP2';
2839: UPDATE HZ_DQM_STAGE_LOG set end_flag='Y', end_time = SYSDATE

Line 2865: HZ_STAGE_MAP_TRANSFORM_UPD.open_party_cursor(

2861: AND WORKER_NUMBER = l_worker_number AND step = l_log_step;
2862: END IF;
2863:
2864: HZ_TRANS_PKG.set_party_type('OTHER');
2865: HZ_STAGE_MAP_TRANSFORM_UPD.open_party_cursor(
2866: 'OTHER',l_worker_number, l_num_workers, l_party_cur);
2867:
2868: IF l_party_cur IS NOT NULL THEN
2869: HZ_STAGE_MAP_TRANSFORM_UPD.update_stage_parties(l_party_cur);

Line 2869: HZ_STAGE_MAP_TRANSFORM_UPD.update_stage_parties(l_party_cur);

2865: HZ_STAGE_MAP_TRANSFORM_UPD.open_party_cursor(
2866: 'OTHER',l_worker_number, l_num_workers, l_party_cur);
2867:
2868: IF l_party_cur IS NOT NULL THEN
2869: HZ_STAGE_MAP_TRANSFORM_UPD.update_stage_parties(l_party_cur);
2870: CLOSE l_party_cur;
2871: END IF;
2872:
2873: l_log_step := 'STEP3';

Line 2900: HZ_STAGE_MAP_TRANSFORM_UPD.open_contact_cursor(

2896: AND WORKER_NUMBER = l_worker_number AND step = l_log_step;
2897:
2898: END IF;
2899:
2900: HZ_STAGE_MAP_TRANSFORM_UPD.open_contact_cursor(
2901: l_worker_number, l_num_workers, l_contact_cur);
2902: IF l_contact_cur IS NOT NULL THEN
2903: HZ_STAGE_MAP_TRANSFORM_UPD.update_stage_contacts(l_contact_cur);
2904: CLOSE l_contact_cur;

Line 2903: HZ_STAGE_MAP_TRANSFORM_UPD.update_stage_contacts(l_contact_cur);

2899:
2900: HZ_STAGE_MAP_TRANSFORM_UPD.open_contact_cursor(
2901: l_worker_number, l_num_workers, l_contact_cur);
2902: IF l_contact_cur IS NOT NULL THEN
2903: HZ_STAGE_MAP_TRANSFORM_UPD.update_stage_contacts(l_contact_cur);
2904: CLOSE l_contact_cur;
2905: END IF;
2906: l_log_step := 'STEP4';
2907: UPDATE HZ_DQM_STAGE_LOG set end_flag='Y', end_time = SYSDATE

Line 2933: HZ_STAGE_MAP_TRANSFORM_UPD.open_party_site_cursor(

2929: AND WORKER_NUMBER = l_worker_number AND step = l_log_step;
2930:
2931: END IF;
2932:
2933: HZ_STAGE_MAP_TRANSFORM_UPD.open_party_site_cursor(
2934: l_worker_number, l_num_workers, l_party_site_cur);
2935: IF l_party_site_cur IS NOT NULL THEN
2936: HZ_STAGE_MAP_TRANSFORM_UPD.update_stage_party_sites(l_party_site_cur);
2937: CLOSE l_party_site_cur;

Line 2936: HZ_STAGE_MAP_TRANSFORM_UPD.update_stage_party_sites(l_party_site_cur);

2932:
2933: HZ_STAGE_MAP_TRANSFORM_UPD.open_party_site_cursor(
2934: l_worker_number, l_num_workers, l_party_site_cur);
2935: IF l_party_site_cur IS NOT NULL THEN
2936: HZ_STAGE_MAP_TRANSFORM_UPD.update_stage_party_sites(l_party_site_cur);
2937: CLOSE l_party_site_cur;
2938: END IF;
2939:
2940: l_log_step := 'STEP5';

Line 2966: HZ_STAGE_MAP_TRANSFORM_UPD.open_contact_pt_cursor(

2962: AND WORKER_NUMBER = l_worker_number AND step = l_log_step;
2963:
2964: END IF;
2965:
2966: HZ_STAGE_MAP_TRANSFORM_UPD.open_contact_pt_cursor(
2967: l_worker_number, l_num_workers, l_cpt_cur);
2968: IF l_cpt_cur IS NOT NULL THEN
2969: HZ_STAGE_MAP_TRANSFORM_UPD.update_stage_contact_pts(l_cpt_cur);
2970: CLOSE l_cpt_cur;

Line 2969: HZ_STAGE_MAP_TRANSFORM_UPD.update_stage_contact_pts(l_cpt_cur);

2965:
2966: HZ_STAGE_MAP_TRANSFORM_UPD.open_contact_pt_cursor(
2967: l_worker_number, l_num_workers, l_cpt_cur);
2968: IF l_cpt_cur IS NOT NULL THEN
2969: HZ_STAGE_MAP_TRANSFORM_UPD.update_stage_contact_pts(l_cpt_cur);
2970: CLOSE l_cpt_cur;
2971: END IF;
2972: l_log_step := 'STEP6';
2973: UPDATE HZ_DQM_STAGE_LOG set end_flag='Y', end_time = SYSDATE