8: g_schema_name VARCHAR2(30) ;
9:
10: PROCEDURE l(str VARCHAR2) IS
11: BEGIN
12: HZ_GEN_PLSQL.add_line(str);
13: END;
14:
15: PROCEDURE verify_all_procs;
16:
400: END;
401:
402: PROCEDURE generate_map_pkg_nolog IS
403: BEGIN
404: HZ_GEN_PLSQL.new('HZ_STAGE_MAP_TRANSFORM', 'PACKAGE BODY');
405: l('CREATE OR REPLACE PACKAGE BODY HZ_STAGE_MAP_TRANSFORM AS');
406:
407: generate_declarations;
408: generate_ds_proc;
431: gen_bulk_imp_sync_cpt_query;
432:
433: l('END;');
434:
435: HZ_GEN_PLSQL.compile_code;
436: END;
437:
438: PROCEDURE get_datastore_cols (
439: entity IN VARCHAR2,
624:
625: PROCEDURE generate_map_pkg IS
626: BEGIN
627: log('Generating package body for HZ_STAGE_MAP_TRANSFORM');
628: HZ_GEN_PLSQL.new('HZ_STAGE_MAP_TRANSFORM', 'PACKAGE BODY');
629: l('CREATE OR REPLACE PACKAGE BODY HZ_STAGE_MAP_TRANSFORM AS');
630:
631: generate_declarations;
632: generate_ds_proc;
656:
657: l('END;');
658:
659: log('Compiling package body .. ', false);
660: HZ_GEN_PLSQL.compile_code;
661: log('Done');
662: END;
663:
664: PROCEDURE set_misc (p_entity VARCHAR2) 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;
730: generate_party_query_upd(x_rebuild_party_idx);
733: generate_contact_pt_query_upd(x_rebuild_cpt_idx);
734:
735: l('END;');
736: log('Compiling package body .. ', false);
737: HZ_GEN_PLSQL.compile_code;
738: log('Done');
739:
740: IF NOT x_rebuild_party_idx THEN
741: set_misc('PARTY');