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 725: log('Generating package body for HZ_STAGE_MAP_TRANSFORM_UPD');

721: x_rebuild_cpt_idx OUT NOCOPY BOOLEAN) IS
722:
723: BEGIN
724:
725: log('Generating package body for HZ_STAGE_MAP_TRANSFORM_UPD');
726: HZ_GEN_PLSQL.new('HZ_STAGE_MAP_TRANSFORM_UPD', 'PACKAGE BODY');
727: l('CREATE OR REPLACE PACKAGE BODY HZ_STAGE_MAP_TRANSFORM_UPD AS');
728:
729: generate_declarations;

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

722:
723: BEGIN
724:
725: log('Generating package body for HZ_STAGE_MAP_TRANSFORM_UPD');
726: HZ_GEN_PLSQL.new('HZ_STAGE_MAP_TRANSFORM_UPD', 'PACKAGE BODY');
727: l('CREATE OR REPLACE PACKAGE BODY HZ_STAGE_MAP_TRANSFORM_UPD AS');
728:
729: generate_declarations;
730: generate_party_query_upd(x_rebuild_party_idx);

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

723: BEGIN
724:
725: log('Generating package body for HZ_STAGE_MAP_TRANSFORM_UPD');
726: HZ_GEN_PLSQL.new('HZ_STAGE_MAP_TRANSFORM_UPD', 'PACKAGE BODY');
727: l('CREATE OR REPLACE PACKAGE BODY HZ_STAGE_MAP_TRANSFORM_UPD AS');
728:
729: generate_declarations;
730: generate_party_query_upd(x_rebuild_party_idx);
731: generate_contact_query_upd(x_rebuild_psite_idx);

Line 2682: HZ_STAGE_MAP_TRANSFORM_UPD.open_party_cursor(

2678:
2679: END IF;
2680:
2681: HZ_TRANS_PKG.set_party_type('ORGANIZATION');
2682: HZ_STAGE_MAP_TRANSFORM_UPD.open_party_cursor(
2683: 'ORGANIZATION',l_worker_number, l_num_workers, l_party_cur);
2684: IF l_party_cur IS NOT NULL THEN
2685: HZ_STAGE_MAP_TRANSFORM_UPD.update_stage_parties(l_party_cur);
2686: CLOSE l_party_cur;

Line 2685: HZ_STAGE_MAP_TRANSFORM_UPD.update_stage_parties(l_party_cur);

2681: HZ_TRANS_PKG.set_party_type('ORGANIZATION');
2682: HZ_STAGE_MAP_TRANSFORM_UPD.open_party_cursor(
2683: 'ORGANIZATION',l_worker_number, l_num_workers, l_party_cur);
2684: IF l_party_cur IS NOT NULL THEN
2685: HZ_STAGE_MAP_TRANSFORM_UPD.update_stage_parties(l_party_cur);
2686: CLOSE l_party_cur;
2687: END IF;
2688:
2689: l_log_step := 'STEP1';

Line 2716: HZ_STAGE_MAP_TRANSFORM_UPD.open_party_cursor(

2712:
2713: END IF;
2714:
2715: HZ_TRANS_PKG.set_party_type('PERSON');
2716: HZ_STAGE_MAP_TRANSFORM_UPD.open_party_cursor(
2717: 'PERSON',l_worker_number, l_num_workers, l_party_cur);
2718:
2719: IF l_party_cur IS NOT NULL THEN
2720: HZ_STAGE_MAP_TRANSFORM_UPD.update_stage_parties(l_party_cur);

Line 2720: HZ_STAGE_MAP_TRANSFORM_UPD.update_stage_parties(l_party_cur);

2716: HZ_STAGE_MAP_TRANSFORM_UPD.open_party_cursor(
2717: 'PERSON',l_worker_number, l_num_workers, l_party_cur);
2718:
2719: IF l_party_cur IS NOT NULL THEN
2720: HZ_STAGE_MAP_TRANSFORM_UPD.update_stage_parties(l_party_cur);
2721: CLOSE l_party_cur;
2722: END IF;
2723: l_log_step := 'STEP2';
2724: UPDATE HZ_DQM_STAGE_LOG set end_flag='Y', end_time = SYSDATE

Line 2750: HZ_STAGE_MAP_TRANSFORM_UPD.open_party_cursor(

2746: AND WORKER_NUMBER = l_worker_number AND step = l_log_step;
2747: END IF;
2748:
2749: HZ_TRANS_PKG.set_party_type('OTHER');
2750: HZ_STAGE_MAP_TRANSFORM_UPD.open_party_cursor(
2751: 'OTHER',l_worker_number, l_num_workers, l_party_cur);
2752:
2753: IF l_party_cur IS NOT NULL THEN
2754: HZ_STAGE_MAP_TRANSFORM_UPD.update_stage_parties(l_party_cur);

Line 2754: HZ_STAGE_MAP_TRANSFORM_UPD.update_stage_parties(l_party_cur);

2750: HZ_STAGE_MAP_TRANSFORM_UPD.open_party_cursor(
2751: 'OTHER',l_worker_number, l_num_workers, l_party_cur);
2752:
2753: IF l_party_cur IS NOT NULL THEN
2754: HZ_STAGE_MAP_TRANSFORM_UPD.update_stage_parties(l_party_cur);
2755: CLOSE l_party_cur;
2756: END IF;
2757:
2758: l_log_step := 'STEP3';

Line 2785: HZ_STAGE_MAP_TRANSFORM_UPD.open_contact_cursor(

2781: AND WORKER_NUMBER = l_worker_number AND step = l_log_step;
2782:
2783: END IF;
2784:
2785: HZ_STAGE_MAP_TRANSFORM_UPD.open_contact_cursor(
2786: l_worker_number, l_num_workers, l_contact_cur);
2787: IF l_contact_cur IS NOT NULL THEN
2788: HZ_STAGE_MAP_TRANSFORM_UPD.update_stage_contacts(l_contact_cur);
2789: CLOSE l_contact_cur;

Line 2788: HZ_STAGE_MAP_TRANSFORM_UPD.update_stage_contacts(l_contact_cur);

2784:
2785: HZ_STAGE_MAP_TRANSFORM_UPD.open_contact_cursor(
2786: l_worker_number, l_num_workers, l_contact_cur);
2787: IF l_contact_cur IS NOT NULL THEN
2788: HZ_STAGE_MAP_TRANSFORM_UPD.update_stage_contacts(l_contact_cur);
2789: CLOSE l_contact_cur;
2790: END IF;
2791: l_log_step := 'STEP4';
2792: UPDATE HZ_DQM_STAGE_LOG set end_flag='Y', end_time = SYSDATE

Line 2818: HZ_STAGE_MAP_TRANSFORM_UPD.open_party_site_cursor(

2814: AND WORKER_NUMBER = l_worker_number AND step = l_log_step;
2815:
2816: END IF;
2817:
2818: HZ_STAGE_MAP_TRANSFORM_UPD.open_party_site_cursor(
2819: l_worker_number, l_num_workers, l_party_site_cur);
2820: IF l_party_site_cur IS NOT NULL THEN
2821: HZ_STAGE_MAP_TRANSFORM_UPD.update_stage_party_sites(l_party_site_cur);
2822: CLOSE l_party_site_cur;

Line 2821: HZ_STAGE_MAP_TRANSFORM_UPD.update_stage_party_sites(l_party_site_cur);

2817:
2818: HZ_STAGE_MAP_TRANSFORM_UPD.open_party_site_cursor(
2819: l_worker_number, l_num_workers, l_party_site_cur);
2820: IF l_party_site_cur IS NOT NULL THEN
2821: HZ_STAGE_MAP_TRANSFORM_UPD.update_stage_party_sites(l_party_site_cur);
2822: CLOSE l_party_site_cur;
2823: END IF;
2824:
2825: l_log_step := 'STEP5';

Line 2851: HZ_STAGE_MAP_TRANSFORM_UPD.open_contact_pt_cursor(

2847: AND WORKER_NUMBER = l_worker_number AND step = l_log_step;
2848:
2849: END IF;
2850:
2851: HZ_STAGE_MAP_TRANSFORM_UPD.open_contact_pt_cursor(
2852: l_worker_number, l_num_workers, l_cpt_cur);
2853: IF l_cpt_cur IS NOT NULL THEN
2854: HZ_STAGE_MAP_TRANSFORM_UPD.update_stage_contact_pts(l_cpt_cur);
2855: CLOSE l_cpt_cur;

Line 2854: HZ_STAGE_MAP_TRANSFORM_UPD.update_stage_contact_pts(l_cpt_cur);

2850:
2851: HZ_STAGE_MAP_TRANSFORM_UPD.open_contact_pt_cursor(
2852: l_worker_number, l_num_workers, l_cpt_cur);
2853: IF l_cpt_cur IS NOT NULL THEN
2854: HZ_STAGE_MAP_TRANSFORM_UPD.update_stage_contact_pts(l_cpt_cur);
2855: CLOSE l_cpt_cur;
2856: END IF;
2857: l_log_step := 'STEP6';
2858: UPDATE HZ_DQM_STAGE_LOG set end_flag='Y', end_time = SYSDATE