DBA Data[Home] [Help]

APPS.HZ_PARTY_STAGE dependencies on HZ_GEN_PLSQL

Line 12: HZ_GEN_PLSQL.add_line(str);

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:

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

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;

Line 435: HZ_GEN_PLSQL.compile_code;

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,

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

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;

Line 660: HZ_GEN_PLSQL.compile_code;

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

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 737: HZ_GEN_PLSQL.compile_code;

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');