[Home] [Help]
29: call_to_proc varchar2(32767),
30: proc_parameters varchar2(32767)
31: );
32:
33: g_table_info hr_dm_gen_main.t_table_info;
34: g_columns_tbl hr_dm_library.t_varchar2_tbl;
35: g_parameters_tbl hr_dm_library.t_varchar2_tbl;
36: g_hier_columns_tbl hr_dm_library.t_varchar2_tbl;
37: g_hier_parameters_tbl hr_dm_library.t_varchar2_tbl;
38: g_aol_columns_tbl hr_dm_library.t_varchar2_tbl;
39: g_aol_parameters_tbl hr_dm_library.t_varchar2_tbl;
40: g_pk_columns_tbl hr_dm_library.t_varchar2_tbl;
41: g_pk_parameters_tbl hr_dm_library.t_varchar2_tbl;
42: g_fk_to_aol_columns_tbl hr_dm_gen_main.t_fk_to_aol_columns_tbl;
43: g_resolve_pk_columns_tbl hr_dm_gen_main.t_fk_to_aol_columns_tbl;
44: g_surrogate_pk_col_param varchar2(30);
45: g_no_of_pk_columns number;
46: g_chk_row_exists t_chk_row_exists;
39: g_aol_parameters_tbl hr_dm_library.t_varchar2_tbl;
40: g_pk_columns_tbl hr_dm_library.t_varchar2_tbl;
41: g_pk_parameters_tbl hr_dm_library.t_varchar2_tbl;
42: g_fk_to_aol_columns_tbl hr_dm_gen_main.t_fk_to_aol_columns_tbl;
43: g_resolve_pk_columns_tbl hr_dm_gen_main.t_fk_to_aol_columns_tbl;
44: g_surrogate_pk_col_param varchar2(30);
45: g_no_of_pk_columns number;
46: g_chk_row_exists t_chk_row_exists;
47: g_delete_dml t_delete_dml;
90: --------------------- migrate_table_data----------------------------------------
91: -- This function will decide if the table is on the exception list
92: -- Exception list is maintained here for now
93: -------------------------------------------------------------------------------
94: function migrate_table_data (p_table_info in hr_dm_gen_main.t_table_info )
95: return boolean is
96:
97: l_migrate boolean := true;
98: begin
327: -- ------------------------------------------------------------------------
328: procedure prepare_code_for_resolving_pk
329: (
330: p_pk_columns_tbl in hr_dm_library.t_varchar2_tbl,
331: p_table_info in hr_dm_gen_main.t_table_info,
332: p_call_to_proc_body in out nocopy varchar2,
333: p_local_var_body in out nocopy varchar2
334: )
335: is
427: -- p_dev_key_local_var_body - returns the string defining local variable
428: -- ------------------------------------------------------------------------
429: procedure prepare_code_for_resolving_pk
430: (
431: p_resolve_pk_columns_tbl in hr_dm_gen_main.t_fk_to_aol_columns_tbl,
432: p_table_info in hr_dm_gen_main.t_table_info,
433: p_call_to_proc_body in out nocopy varchar2,
434: p_local_var_body in out nocopy varchar2
435: )
428: -- ------------------------------------------------------------------------
429: procedure prepare_code_for_resolving_pk
430: (
431: p_resolve_pk_columns_tbl in hr_dm_gen_main.t_fk_to_aol_columns_tbl,
432: p_table_info in hr_dm_gen_main.t_table_info,
433: p_call_to_proc_body in out nocopy varchar2,
434: p_local_var_body in out nocopy varchar2
435: )
436: is
553: -- developer key
554: -- ------------------------------------------------------------------------
555: procedure generate_get_id_frm_dev_key
556: (
557: p_fk_to_aol_columns_tbl in hr_dm_gen_main.t_fk_to_aol_columns_tbl,
558: p_table_info in hr_dm_gen_main.t_table_info,
559: p_body in out nocopy varchar2,
560: p_call_to_proc_body in out nocopy varchar2,
561: p_dev_key_local_var_body in out nocopy varchar2
554: -- ------------------------------------------------------------------------
555: procedure generate_get_id_frm_dev_key
556: (
557: p_fk_to_aol_columns_tbl in hr_dm_gen_main.t_fk_to_aol_columns_tbl,
558: p_table_info in hr_dm_gen_main.t_table_info,
559: p_body in out nocopy varchar2,
560: p_call_to_proc_body in out nocopy varchar2,
561: p_dev_key_local_var_body in out nocopy varchar2
562: )
715: -- use instr function in conjunction with substr to get the data type.
716: -- ------------------------------------------------------------------------
717: procedure prepare_glob_var_def_for_dt
718: (
719: p_table_info in hr_dm_gen_main.t_table_info,
720: p_body in out nocopy varchar2
721: ) is
722: l_list_index number;
723: l_count number;
760: -- of primary key columns and whether table has surrogate id or not.
761: -- ------------------------------------------------------------------------
762: procedure prepare_ins_dt_delete_stmt
763: (
764: p_table_info in hr_dm_gen_main.t_table_info,
765: p_proc_body in out nocopy varchar2 ,
766: p_ins_type in varchar2 default 'P',
767: p_indent in number
768: )
834: -- 4 column primary key chk_row_in_dt_delete_4_pkcol
835: -- ------------------------------------------------------------------------
836: procedure prepare_chk_dt_delete_stmt
837: (
838: p_table_info in hr_dm_gen_main.t_table_info,
839: p_proc_body in out nocopy varchar2 ,
840: p_indent in number
841: )
842: is
906: -- Prepare the procedure body of upload procedure for date tracked table.
907: -- ------------------------------------------------------------------------
908: procedure prepare_dt_upload_body
909: (
910: p_table_info in hr_dm_gen_main.t_table_info,
911: p_proc_body out nocopy varchar2
912: )
913: is
914: l_proc_comment varchar2(4000);
1259: -- Prepare the procedure body of upload proxcedure for non date tracked table.
1260: -- ------------------------------------------------------------------------
1261: procedure prepare_non_dt_upload_body
1262: (
1263: p_table_info in hr_dm_gen_main.t_table_info,
1264: p_proc_body out nocopy varchar2
1265: )
1266: is
1267: l_proc_comment varchar2(4000);
1433: -- Generates the upload procedure of the TUPS
1434: -- ------------------------------------------------------------------------
1435: procedure generate_upload
1436: (
1437: p_table_info in hr_dm_gen_main.t_table_info,
1438: p_header in out nocopy varchar2,
1439: p_body in out nocopy varchar2,
1440: p_call_to_proc_body in varchar2,
1441: p_dev_key_local_var_body in varchar2,
1438: p_header in out nocopy varchar2,
1439: p_body in out nocopy varchar2,
1440: p_call_to_proc_body in varchar2,
1441: p_dev_key_local_var_body in varchar2,
1442: p_fk_to_aol_columns_tbl in hr_dm_gen_main.t_fk_to_aol_columns_tbl
1443: )
1444: is
1445: l_interface varchar2(32767);
1446: l_locals varchar2(32767) := null;
1724: --
1725: -- ------------------------------------------------------------------------------
1726: procedure get_derive_from_clause
1727: (
1728: p_table_info in hr_dm_gen_main.t_table_info,
1729: p_derive_from in varchar2,
1730: p_from_clause in out nocopy varchar2,
1731: p_lpad_spaces in number default 2
1732: ) is
1803: --
1804: -- ------------------------------------------------------------------------------
1805: procedure get_derive_where_clause
1806: (
1807: p_table_info in hr_dm_gen_main.t_table_info,
1808: p_derive_sql in varchar2,
1809: p_where_clause in out nocopy varchar2,
1810: p_lpad_spaces in number default 2
1811: ) is
1862: -- Preapre the cursor for chk_row_exists procedure
1863: -- ------------------------------------------------------------------------
1864: procedure prepare_chk_row_exists_cursor
1865: (
1866: p_table_info in hr_dm_gen_main.t_table_info,
1867: p_cursor out nocopy varchar2
1868: )
1869: is
1870: l_cursor_comment varchar2(2000);
1958: -- Generates the chk_row_exists procedure of the TUPS
1959: -- ------------------------------------------------------------------------
1960: procedure generate_chk_row_exists
1961: (
1962: p_table_info in hr_dm_gen_main.t_table_info
1963: )
1964: is
1965: l_interface varchar2(32767);
1966: l_locals varchar2(32767) := null;
2328: -- Generates the insert_dml procedure of the TUPS
2329: -- ------------------------------------------------------------------------
2330: procedure generate_insert_dml
2331: (
2332: p_table_info in hr_dm_gen_main.t_table_info
2333: )
2334: is
2335: l_interface varchar2(32767);
2336: l_locals varchar2(32767) := null;
2591: -- Generates the update_dml procedure of the TUPS
2592: -- ------------------------------------------------------------------------
2593: procedure generate_update_dml
2594: (
2595: p_table_info in hr_dm_gen_main.t_table_info
2596: )
2597: is
2598: l_interface varchar2(32767);
2599: l_locals varchar2(32767) := null;
2733: -- have an A hierarchy.
2734: -- ------------------------------------------------------------------------
2735: procedure generate_upload_hierarchy
2736: (
2737: p_table_info in hr_dm_gen_main.t_table_info,
2738: p_header in out nocopy varchar2
2739: )
2740: is
2741: l_interface varchar2(32767);
2884: -- Generates the delete_dml procedure of the TUPS
2885: -- ------------------------------------------------------------------------
2886: procedure generate_delete_dml
2887: (
2888: p_table_info in hr_dm_gen_main.t_table_info
2889: )
2890: is
2891: l_interface varchar2(32767);
2892: l_locals varchar2(32767) := null;
3017: -- table.
3018: -- ------------------------------------------------------------------------
3019: procedure create_tups_pacakge
3020: (
3021: p_table_info in hr_dm_gen_main.t_table_info ,
3022: p_columns_tbl in hr_dm_library.t_varchar2_tbl,
3023: p_parameters_tbl in hr_dm_library.t_varchar2_tbl,
3024: p_aol_columns_tbl in hr_dm_library.t_varchar2_tbl,
3025: p_aol_parameters_tbl in hr_dm_library.t_varchar2_tbl,
3022: p_columns_tbl in hr_dm_library.t_varchar2_tbl,
3023: p_parameters_tbl in hr_dm_library.t_varchar2_tbl,
3024: p_aol_columns_tbl in hr_dm_library.t_varchar2_tbl,
3025: p_aol_parameters_tbl in hr_dm_library.t_varchar2_tbl,
3026: p_fk_to_aol_columns_tbl in hr_dm_gen_main.t_fk_to_aol_columns_tbl
3027: )
3028: is
3029: l_header varchar2(32767);
3030: l_body varchar2(32767);