PACKAGE: APPS.HR_DM_UTILITY

Source

1 PACKAGE hr_dm_utility AUTHID CURRENT_USER AS
2 /* $Header: perdmutl.pkh 120.0 2005/05/31 17:15:42 appldev noship $ */
3 
4 --
5 -- Declare records
6 --
7 
8 TYPE r_migration_rec IS RECORD (migration_type VARCHAR2(30),
9                                 database_location VARCHAR2(30),
10                                 source_database_instance VARCHAR2(30),
11                                 destination_database_instance VARCHAR2(30),
12                                 migration_id NUMBER,
13                                 application_id NUMBER,
14                                 last_migration_date DATE,
15                                 business_group_id NUMBER);
16 
17 
18 
19 -- general purpose procedures
20 -- start
21 
22 FUNCTION get_phase_status(p_phase IN VARCHAR2, p_migration_id IN NUMBER)
23          RETURN VARCHAR2;
24 FUNCTION get_phase_id(p_phase IN VARCHAR2, p_migration_id IN NUMBER)
25          RETURN NUMBER;
26 FUNCTION number_of_threads(p_business_group_id IN NUMBER) RETURN NUMBER;
27 FUNCTION chunk_size(p_business_group_id IN NUMBER) RETURN NUMBER;
28 PROCEDURE set_process(p_process_text IN VARCHAR2,
29                       p_phase IN VARCHAR2,
30                       p_migration_id IN NUMBER);
31 
32 
33 -- general purpose procedures
34 -- end
35 
36 
37 -- error procedures
38 -- start
39 
40 PROCEDURE error (p_sqlcode IN NUMBER, p_procedure IN VARCHAR2,
41                  p_extra IN VARCHAR2, p_rollback IN VARCHAR2 DEFAULT 'R');
42 
43 -- error procedures
44 -- end
45 
46 
47 -- message procedures
48 -- start
49 
50 PROCEDURE message (p_type IN VARCHAR2, p_message IN VARCHAR2,
51                    p_position IN NUMBER);
52 PROCEDURE message_init;
53 
54 -- message procedures
55 -- end
56 
57 
58 
59 -- rollback procedures
60 -- start
61 
62 PROCEDURE rollback (p_phase IN VARCHAR2,
63                     p_masterslave IN VARCHAR2 DEFAULT NULL,
64                     p_migration_id IN NUMBER DEFAULT NULL,
65                     p_phase_item_id IN NUMBER DEFAULT NULL);
66 PROCEDURE rollback_range_master (p_migration_id IN NUMBER);
67 PROCEDURE rollback_down_aol_master (p_migration_id IN NUMBER);
68 PROCEDURE rollback_up_aol_master (p_migration_id IN NUMBER);
69 PROCEDURE rollback_download_master (p_migration_id IN NUMBER);
70 PROCEDURE rollback_init (p_migration_id IN NUMBER);
71 PROCEDURE rollback_generator (p_migration_id IN NUMBER);
72 PROCEDURE rollback_cleanup (p_migration_id IN NUMBER);
73 PROCEDURE rollback_delete (p_migration_id IN NUMBER);
74 PROCEDURE rollback_upload (p_migration_id IN NUMBER);
75 
76 -- rollback procedures
77 -- end
78 
79 
80 
81 -- update status procedures
82 -- start
83 
84 PROCEDURE update_migrations (p_new_status IN VARCHAR2, p_id IN NUMBER);
85 PROCEDURE update_migration_ranges (p_new_status IN VARCHAR2,
86                                    p_id IN NUMBER);
87 PROCEDURE update_phase_items (p_new_status IN VARCHAR2, p_id IN NUMBER);
88 PROCEDURE update_phases (p_new_status IN VARCHAR2, p_id IN NUMBER);
89 
90 -- update status procedures
91 -- end
92 
93 
94 --
95 end hr_dm_utility;