PACKAGE: APPS.BEN_DM_UTILITY

Source

1 PACKAGE ben_dm_utility AUTHID CURRENT_USER AS
2 /* $Header: benfdmutil.pkh 120.0 2006/05/11 05:02:46 nkkrishn noship $ */
3 
4 --
5 -- Declare records
6 --
7 TYPE r_migration_rec IS RECORD (migration_id NUMBER,
8                                 migration_name VARCHAR2(80),
9                                 input_parameter_file_name VARCHAR2(30),
10                                 input_parameter_file_path VARCHAR2(60),
11                                 data_file_name VARCHAR2(30),
12                                 data_file_path VARCHAR2(60),
13                                 database_location VARCHAR2(2),
14                                 last_migration_date DATE);
15 
16 
17 g_out_file_handle utl_file.file_type;
18 
19 PROCEDURE rollback (p_phase IN VARCHAR2,
20                     p_masterslave IN VARCHAR2 DEFAULT NULL,
21                     p_migration_id IN NUMBER DEFAULT NULL,
22                     p_phase_item_id IN NUMBER DEFAULT NULL);
23 PROCEDURE rollback_download_master (p_migration_id IN NUMBER);
24 PROCEDURE rollback_init (p_migration_id IN NUMBER);
25 PROCEDURE rollback_generator (p_migration_id IN NUMBER);
26 PROCEDURE rollback_upload (p_migration_id IN NUMBER);
27 
28 FUNCTION number_of_threads(p_business_group_id IN NUMBER) RETURN NUMBER;
29 FUNCTION get_phase_status(p_phase IN VARCHAR2, p_migration_id IN NUMBER)
30          RETURN VARCHAR2;
31 FUNCTION get_phase_id(p_phase IN VARCHAR2, p_migration_id IN NUMBER)
32          RETURN NUMBER;
33 
34 PROCEDURE error (p_sqlcode IN NUMBER, p_procedure IN VARCHAR2,
35                  p_extra IN VARCHAR2, p_rollback IN VARCHAR2 DEFAULT 'R');
36 
37 PROCEDURE message (p_type IN VARCHAR2, p_message IN VARCHAR2,
38                    p_position IN NUMBER);
39 
40 PROCEDURE message_init;
41 -- update status procedures
42 -- start
43 
44 PROCEDURE update_migrations (p_new_status IN VARCHAR2, p_id IN NUMBER);
45 PROCEDURE update_phase_items (p_new_status IN VARCHAR2, p_id IN NUMBER);
46 PROCEDURE update_phases (p_new_status IN VARCHAR2, p_id IN NUMBER);
47 
48 FUNCTION get_table_id(p_table_name IN VARCHAR2) RETURN NUMBER;
49 PROCEDURE seed_column_mapping (p_table_name IN VARCHAR2);
50 PROCEDURE seed_table_order (p_table_name IN VARCHAR2, p_order_no IN NUMBER);
51 PROCEDURE ins_hir (p_table_name                   varchar2,
52                     p_parent_table_name            varchar2 default null,
53                     p_column_name                  varchar2 default null,
54                     p_parent_column_name           varchar2 default null,
55                     p_parent_id_column_name        varchar2 default null,
56                     p_hierarchy_type               varchar2 default 'PC');
57 --
58 end ben_dm_utility;