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

432: gen_bulk_imp_sync_cpt_query;
433:
434: l('END;');
435:
436: HZ_GEN_PLSQL.compile_code;
437: END;
438:
439: PROCEDURE get_datastore_cols (
440: entity IN VARCHAR2,

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

668:
669: l('END;');
670:
671: log('Compiling package body .. ', false);
672: HZ_GEN_PLSQL.compile_code;
673: log('Done');
674: END;
675:
676: PROCEDURE set_misc (p_entity VARCHAR2) IS

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

745: generate_contact_pt_query_upd(x_rebuild_cpt_idx);
746:
747: l('END;');
748: log('Compiling package body .. ', false);
749: HZ_GEN_PLSQL.compile_code;
750: log('Done');
751:
752: IF NOT x_rebuild_party_idx THEN
753: set_misc('PARTY');