[Home] [Help]
PACKAGE: APPS.HR_JP_DATA_MIGRATION_PKG
Source
1 PACKAGE HR_JP_DATA_MIGRATION_PKG AUTHID CURRENT_USER AS
2 /* $Header: hrjpdtmg.pkh 120.4 2010/11/01 12:44:20 keyazawa ship $ */
3 --
4 g_legislation_code varchar2(2);
5 --
6 g_skip_qualify varchar2(1);
7 --
8 g_sql_run varchar2(1);
9 --
10 g_mig_date date;
11 g_skip_manual_upd varchar2(1) := 'Y';
12 g_skip_out_range_upd varchar2(1) := 'Y';
13 g_upd_mode varchar2(30); /* UPDATE, OVERRIDE */
14 g_exc_match_exp_smr varchar2(1) := 'N';
15 --
16 g_expire_cei_dep_oe varchar2(1) := 'Y';
17 --
18 type t_ass_hi_smr_rec is record(
19 bg_id per_business_groups.business_group_id%type,
20 bg_name per_business_groups.name%type,
21 ass_id per_all_assignments_f.assignment_id%type,
22 ass_num per_all_assignments_f.assignment_number%type,
23 del_done varchar2(1),
24 hi_mr pay_element_entry_values_f.screen_entry_value%type);
25 --
26 type t_ass_hi_smr_tbl is table of t_ass_hi_smr_rec index by binary_integer;
27 --
28 type t_ass_dep_rec is record(
29 bg_id per_business_groups.business_group_id%type,
30 bg_name per_business_groups.name%type,
31 ass_id per_all_assignments_f.assignment_id%type,
32 ass_num per_all_assignments_f.assignment_number%type,
33 upd_done varchar2(1));
34 --
35 type t_ass_dep_tbl is table of t_ass_dep_rec index by binary_integer;
36 --
37 g_range_ass_hi_smr_tbl t_ass_hi_smr_tbl;
38 --
39 g_range_ass_dep_tbl t_ass_dep_tbl;
40 --
41 g_valid varchar2(1) := 'N';
42 g_log varchar2(1) := 'Y';
43 --
44 g_detail_debug boolean := false;
45 g_debug boolean := hr_utility.debug_enabled;
46 --
47 --
48 PROCEDURE ELEMENT_RUN_RESULT_COPY(
49 P_MODE IN VARCHAR2,
50 P_PARAMETER_NAME IN VARCHAR2,
51 P_PARAMETER_VALUE IN NUMBER);
52 --
53 PROCEDURE ADD_NEW_INPUT_VALUE(
54 P_MODE IN VARCHAR2,
55 P_PARAMETER_NAME IN VARCHAR2,
56 P_PARAMETER_VALUE IN NUMBER);
57 --
58 PROCEDURE END_ELEMENT_ENTRY(
59 P_MODE IN VARCHAR2,
60 P_PARAMETER_NAME IN VARCHAR2,
61 P_PARAMETER_VALUE IN NUMBER,
62 P_SESSION_DATE IN DATE);
63 --
64 function get_ass_info(
65 p_assignment_id in number,
66 p_effective_date in date)
67 return t_ass_hi_smr_rec;
68 --
69 function get_mig_date
70 return date;
71 --
72 procedure insert_session(
73 p_effective_date in date);
74 --
75 procedure delete_session;
76 --
77 procedure qualify_hi_smr_hd(
78 p_assignment_id in number);
79 --
80 procedure migrate_hi_smr_hd(
81 p_assignment_id in number);
82 --
83 procedure init_def_hi_smr_data;
84 --
85 procedure val_mig_smr_assact(
86 p_business_group_id in number,
87 p_business_group_name in varchar2,
88 p_assignment_id in number,
89 p_assignment_number in varchar2,
90 p_session_date in date,
91 p_valid_delete in out nocopy varchar2);
92 --
93 procedure mig_smr_assact(
94 p_business_group_id in number,
95 p_business_group_name in varchar2,
96 p_assignment_id in number,
97 p_assignment_number in varchar2,
98 p_session_date in date,
99 p_hi_mr in varchar2);
100 --
101 -- this is for manual run by script, recommend to use generic upgrade instead of this.
102 procedure run_mig_smr;
103 --
104 procedure qualify_dep_hd(
105 p_assignment_id in number);
106 --
107 procedure migrate_dep_hd(
108 p_assignment_id in number);
109 --
110 procedure init_def_dep_data;
111
112 procedure val_mig_dep_assact(
113 p_business_group_id in number,
114 p_business_group_name in varchar2,
115 p_assignment_id in number,
116 p_assignment_number in varchar2,
117 p_session_date in date,
118 p_valid_update in out nocopy varchar2);
119 --
120 procedure mig_dep_assact(
121 p_business_group_id in number,
122 p_business_group_name in varchar2,
123 p_assignment_id in number,
124 p_assignment_number in varchar2,
125 p_session_date in date);
126 --
127 -- this is for manual run by script, recommend to use generic upgrade instead of this.
128 procedure run_mig_dep;
129 --
130 END HR_JP_DATA_MIGRATION_PKG;