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

Line 405: HZ_GEN_PLSQL.new('HZ_STAGE_MAP_TRANSFORM', 'PACKAGE BODY');

401:
402: PROCEDURE generate_map_pkg_nolog IS
403: BEGIN
404: g_batch_size := nvl( FND_PROFILE.value('HZ_DQM_STAGE_BATCH_SIZE'), 200 );--Bug 10030313
405: HZ_GEN_PLSQL.new('HZ_STAGE_MAP_TRANSFORM', 'PACKAGE BODY');
406: l('CREATE OR REPLACE PACKAGE BODY HZ_STAGE_MAP_TRANSFORM AS');
407:
408: generate_declarations;
409: generate_ds_proc;

Line 406: l('CREATE OR REPLACE PACKAGE BODY HZ_STAGE_MAP_TRANSFORM AS');

402: PROCEDURE generate_map_pkg_nolog IS
403: BEGIN
404: g_batch_size := nvl( FND_PROFILE.value('HZ_DQM_STAGE_BATCH_SIZE'), 200 );--Bug 10030313
405: HZ_GEN_PLSQL.new('HZ_STAGE_MAP_TRANSFORM', 'PACKAGE BODY');
406: l('CREATE OR REPLACE PACKAGE BODY HZ_STAGE_MAP_TRANSFORM AS');
407:
408: generate_declarations;
409: generate_ds_proc;
410: generate_log;

Line 638: log('Generating package body for HZ_STAGE_MAP_TRANSFORM');

634:
635:
636: PROCEDURE generate_map_pkg IS
637: BEGIN
638: log('Generating package body for HZ_STAGE_MAP_TRANSFORM');
639: g_batch_size := nvl( FND_PROFILE.value('HZ_DQM_STAGE_BATCH_SIZE'), 200 );--Bug 10030313
640: HZ_GEN_PLSQL.new('HZ_STAGE_MAP_TRANSFORM', 'PACKAGE BODY');
641: l('CREATE OR REPLACE PACKAGE BODY HZ_STAGE_MAP_TRANSFORM AS');
642:

Line 640: HZ_GEN_PLSQL.new('HZ_STAGE_MAP_TRANSFORM', 'PACKAGE BODY');

636: PROCEDURE generate_map_pkg IS
637: BEGIN
638: log('Generating package body for HZ_STAGE_MAP_TRANSFORM');
639: g_batch_size := nvl( FND_PROFILE.value('HZ_DQM_STAGE_BATCH_SIZE'), 200 );--Bug 10030313
640: HZ_GEN_PLSQL.new('HZ_STAGE_MAP_TRANSFORM', 'PACKAGE BODY');
641: l('CREATE OR REPLACE PACKAGE BODY HZ_STAGE_MAP_TRANSFORM AS');
642:
643: generate_declarations;
644: generate_ds_proc;

Line 641: l('CREATE OR REPLACE PACKAGE BODY HZ_STAGE_MAP_TRANSFORM AS');

637: BEGIN
638: log('Generating package body for HZ_STAGE_MAP_TRANSFORM');
639: g_batch_size := nvl( FND_PROFILE.value('HZ_DQM_STAGE_BATCH_SIZE'), 200 );--Bug 10030313
640: HZ_GEN_PLSQL.new('HZ_STAGE_MAP_TRANSFORM', 'PACKAGE BODY');
641: l('CREATE OR REPLACE PACKAGE BODY HZ_STAGE_MAP_TRANSFORM AS');
642:
643: generate_declarations;
644: generate_ds_proc;
645: generate_log;

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 2640: HZ_STAGE_MAP_TRANSFORM.open_party_cursor(

2636: --COMMIT;
2637:
2638:
2639: HZ_TRANS_PKG.set_party_type('ORGANIZATION');
2640: HZ_STAGE_MAP_TRANSFORM.open_party_cursor(
2641: 'ALL_PARTIES', 'ORGANIZATION',l_worker_number, l_num_workers, NULL,'N', l_start_rowid,l_end_rowid,l_party_cur);
2642: HZ_STAGE_MAP_TRANSFORM.insert_stage_parties('N',l_party_cur);
2643:
2644: l_log_step := 'STEP2';

Line 2642: HZ_STAGE_MAP_TRANSFORM.insert_stage_parties('N',l_party_cur);

2638:
2639: HZ_TRANS_PKG.set_party_type('ORGANIZATION');
2640: HZ_STAGE_MAP_TRANSFORM.open_party_cursor(
2641: 'ALL_PARTIES', 'ORGANIZATION',l_worker_number, l_num_workers, NULL,'N', l_start_rowid,l_end_rowid,l_party_cur);
2642: HZ_STAGE_MAP_TRANSFORM.insert_stage_parties('N',l_party_cur);
2643:
2644: l_log_step := 'STEP2';
2645: UPDATE HZ_DQM_STAGE_LOG set start_flag='Y', start_time = SYSDATE
2646: WHERE OPERATION = p_command

Line 2651: HZ_STAGE_MAP_TRANSFORM.open_party_cursor(

2647: AND WORKER_NUMBER = l_worker_number AND step = l_log_step;
2648: COMMIT;
2649:
2650: HZ_TRANS_PKG.set_party_type('PERSON');
2651: HZ_STAGE_MAP_TRANSFORM.open_party_cursor(
2652: 'ALL_PARTIES', 'PERSON',l_worker_number, l_num_workers, NULL,'N', l_start_rowid,l_end_rowid,l_party_cur);
2653: HZ_STAGE_MAP_TRANSFORM.insert_stage_parties('N',l_party_cur);
2654:
2655: l_log_step := 'STEP3';

Line 2653: HZ_STAGE_MAP_TRANSFORM.insert_stage_parties('N',l_party_cur);

2649:
2650: HZ_TRANS_PKG.set_party_type('PERSON');
2651: HZ_STAGE_MAP_TRANSFORM.open_party_cursor(
2652: 'ALL_PARTIES', 'PERSON',l_worker_number, l_num_workers, NULL,'N', l_start_rowid,l_end_rowid,l_party_cur);
2653: HZ_STAGE_MAP_TRANSFORM.insert_stage_parties('N',l_party_cur);
2654:
2655: l_log_step := 'STEP3';
2656: UPDATE HZ_DQM_STAGE_LOG set start_flag='Y', start_time = SYSDATE
2657: WHERE OPERATION = p_command

Line 2662: HZ_STAGE_MAP_TRANSFORM.open_party_cursor(

2658: AND WORKER_NUMBER = l_worker_number AND step = l_log_step;
2659: COMMIT;
2660:
2661: HZ_TRANS_PKG.set_party_type('OTHER');
2662: HZ_STAGE_MAP_TRANSFORM.open_party_cursor(
2663: 'ALL_PARTIES', 'OTHER',l_worker_number, l_num_workers, NULL,'N',l_start_rowid,l_end_rowid, l_party_cur);
2664: HZ_STAGE_MAP_TRANSFORM.insert_stage_parties('N',l_party_cur);
2665:
2666: ELSE

Line 2664: HZ_STAGE_MAP_TRANSFORM.insert_stage_parties('N',l_party_cur);

2660:
2661: HZ_TRANS_PKG.set_party_type('OTHER');
2662: HZ_STAGE_MAP_TRANSFORM.open_party_cursor(
2663: 'ALL_PARTIES', 'OTHER',l_worker_number, l_num_workers, NULL,'N',l_start_rowid,l_end_rowid, l_party_cur);
2664: HZ_STAGE_MAP_TRANSFORM.insert_stage_parties('N',l_party_cur);
2665:
2666: ELSE
2667: HZ_TRANS_PKG.set_party_type('ORGANIZATION');
2668: log(' Continue for Org cursor');

Line 2669: HZ_STAGE_MAP_TRANSFORM.open_party_cursor(

2665:
2666: ELSE
2667: HZ_TRANS_PKG.set_party_type('ORGANIZATION');
2668: log(' Continue for Org cursor');
2669: HZ_STAGE_MAP_TRANSFORM.open_party_cursor(
2670: 'ALL_PARTIES', 'ORGANIZATION',l_worker_number, l_num_workers, NULL,'Y',l_start_rowid,l_end_rowid,l_party_cur);
2671: HZ_STAGE_MAP_TRANSFORM.insert_stage_parties('Y',l_party_cur);
2672:
2673: log(' Continue for Per cursor');

Line 2671: HZ_STAGE_MAP_TRANSFORM.insert_stage_parties('Y',l_party_cur);

2667: HZ_TRANS_PKG.set_party_type('ORGANIZATION');
2668: log(' Continue for Org cursor');
2669: HZ_STAGE_MAP_TRANSFORM.open_party_cursor(
2670: 'ALL_PARTIES', 'ORGANIZATION',l_worker_number, l_num_workers, NULL,'Y',l_start_rowid,l_end_rowid,l_party_cur);
2671: HZ_STAGE_MAP_TRANSFORM.insert_stage_parties('Y',l_party_cur);
2672:
2673: log(' Continue for Per cursor');
2674: HZ_TRANS_PKG.set_party_type('PERSON');
2675: HZ_STAGE_MAP_TRANSFORM.open_party_cursor(

Line 2675: HZ_STAGE_MAP_TRANSFORM.open_party_cursor(

2671: HZ_STAGE_MAP_TRANSFORM.insert_stage_parties('Y',l_party_cur);
2672:
2673: log(' Continue for Per cursor');
2674: HZ_TRANS_PKG.set_party_type('PERSON');
2675: HZ_STAGE_MAP_TRANSFORM.open_party_cursor(
2676: 'ALL_PARTIES', 'PERSON',l_worker_number, l_num_workers, NULL,'Y', l_start_rowid,l_end_rowid,l_party_cur);
2677: HZ_STAGE_MAP_TRANSFORM.insert_stage_parties('Y',l_party_cur);
2678:
2679: log(' Continue for Oth cursor');

Line 2677: HZ_STAGE_MAP_TRANSFORM.insert_stage_parties('Y',l_party_cur);

2673: log(' Continue for Per cursor');
2674: HZ_TRANS_PKG.set_party_type('PERSON');
2675: HZ_STAGE_MAP_TRANSFORM.open_party_cursor(
2676: 'ALL_PARTIES', 'PERSON',l_worker_number, l_num_workers, NULL,'Y', l_start_rowid,l_end_rowid,l_party_cur);
2677: HZ_STAGE_MAP_TRANSFORM.insert_stage_parties('Y',l_party_cur);
2678:
2679: log(' Continue for Oth cursor');
2680:
2681: HZ_TRANS_PKG.set_party_type('OTHER');

Line 2682: HZ_STAGE_MAP_TRANSFORM.open_party_cursor(

2678:
2679: log(' Continue for Oth cursor');
2680:
2681: HZ_TRANS_PKG.set_party_type('OTHER');
2682: HZ_STAGE_MAP_TRANSFORM.open_party_cursor(
2683: 'ALL_PARTIES', 'OTHER',l_worker_number, l_num_workers, NULL,'Y',l_start_rowid,l_end_rowid, l_party_cur);
2684: HZ_STAGE_MAP_TRANSFORM.insert_stage_parties('Y',l_party_cur);
2685:
2686: END IF;

Line 2684: HZ_STAGE_MAP_TRANSFORM.insert_stage_parties('Y',l_party_cur);

2680:
2681: HZ_TRANS_PKG.set_party_type('OTHER');
2682: HZ_STAGE_MAP_TRANSFORM.open_party_cursor(
2683: 'ALL_PARTIES', 'OTHER',l_worker_number, l_num_workers, NULL,'Y',l_start_rowid,l_end_rowid, l_party_cur);
2684: HZ_STAGE_MAP_TRANSFORM.insert_stage_parties('Y',l_party_cur);
2685:
2686: END IF;
2687:
2688:

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

Line 4823: -- REPURI. Proccedure to generate the code (into HZ_STAGE_MAP_TRANSFORM)

4819: l('');
4820:
4821: END;
4822:
4823: -- REPURI. Proccedure to generate the code (into HZ_STAGE_MAP_TRANSFORM)
4824: -- for OPEN_BULK_IMP_SYNC_PARTY_CUR procedure. Bug 4884735.
4825:
4826: PROCEDURE gen_bulk_imp_sync_party_query IS
4827:

Line 5050: -- REPURI. Proccedure to generate the code (into HZ_STAGE_MAP_TRANSFORM)

5046: l(' END open_bulk_imp_sync_party_cur;');
5047: l('');
5048: END gen_bulk_imp_sync_party_query;
5049:
5050: -- REPURI. Proccedure to generate the code (into HZ_STAGE_MAP_TRANSFORM)
5051: -- for OPEN_SYNC_PARTY_CURSOR and SYNC_ALL_PARTIES Procedures.
5052:
5053: PROCEDURE generate_sync_party_query_proc IS
5054:

Line 6349: -- REPURI. Proccedure to generate the code (into HZ_STAGE_MAP_TRANSFORM)

6345: l(' END;');
6346:
6347: END;
6348:
6349: -- REPURI. Proccedure to generate the code (into HZ_STAGE_MAP_TRANSFORM)
6350: -- for OPEN_BULK_IMP_SYNC_PSITE_CUR Procedure. Bug 4884735.
6351:
6352: PROCEDURE gen_bulk_imp_sync_psite_query IS
6353: cur_col_num NUMBER := 1;

Line 6507: -- REPURI. Proccedure to generate the code (into HZ_STAGE_MAP_TRANSFORM)

6503: l('');
6504: END gen_bulk_imp_sync_psite_query;
6505:
6506:
6507: -- REPURI. Proccedure to generate the code (into HZ_STAGE_MAP_TRANSFORM)
6508: -- for OPEN_SYNC_PARTY_SITE_CURSOR and SYNC_ALL_PARTY_SITES Procedures.
6509:
6510: PROCEDURE generate_sync_psite_query_proc IS
6511: cur_col_num NUMBER := 1;

Line 7605: -- REPURI. Proccedure to generate the code (into HZ_STAGE_MAP_TRANSFORM)

7601: l(' END;');
7602:
7603: END;
7604:
7605: -- REPURI. Proccedure to generate the code (into HZ_STAGE_MAP_TRANSFORM)
7606: -- for OPEN_BULK_IMP_SYNC_CT_CUR query procedure. Bug 4884735.
7607:
7608: PROCEDURE gen_bulk_imp_sync_ct_query IS
7609: cur_col_num NUMBER := 1;

Line 7808: -- REPURI. Proccedure to generate the code (into HZ_STAGE_MAP_TRANSFORM)

7804: END gen_bulk_imp_sync_ct_query;
7805:
7806:
7807:
7808: -- REPURI. Proccedure to generate the code (into HZ_STAGE_MAP_TRANSFORM)
7809: -- for OPEN_SYNC_CONTACT_CURSOR and SYNC_ALL_CONTACTS Procedures.
7810:
7811: PROCEDURE generate_sync_ct_query_proc IS
7812: cur_col_num NUMBER := 1;

Line 8898: -- REPURI. Proccedure to generate the code (into HZ_STAGE_MAP_TRANSFORM)

8894:
8895: END;
8896:
8897:
8898: -- REPURI. Proccedure to generate the code (into HZ_STAGE_MAP_TRANSFORM)
8899: -- for OPEN_BULK_IMP_SYNC_CPT_CUR query procedure. Bug 4884735.
8900:
8901:
8902: PROCEDURE gen_bulk_imp_sync_cpt_query IS

Line 9071: -- REPURI. Proccedure to generate the code (into HZ_STAGE_MAP_TRANSFORM)

9067:
9068: END gen_bulk_imp_sync_cpt_query;
9069:
9070:
9071: -- REPURI. Proccedure to generate the code (into HZ_STAGE_MAP_TRANSFORM)
9072: -- for OPEN_SYNC_CPT_CURSOR and SYNC_ALL_CONTACT_POINTS Procedures.
9073:
9074: PROCEDURE generate_sync_cpt_query_proc IS
9075: