[Home] [Help]
PACKAGE: APPS.HR_JP_DATA_MIGRATION_PKG
Source
1 PACKAGE HR_JP_DATA_MIGRATION_PKG AS
2 /* $Header: hrjpdtmg.pkh 120.0.12000000.3 2007/03/05 05:49:34 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 type t_ass_hi_smr_rec is record(
17 bg_id per_business_groups.business_group_id%type,
18 bg_name per_business_groups.name%type,
19 ass_id per_all_assignments_f.assignment_id%type,
20 ass_num per_all_assignments_f.assignment_number%type,
21 del_done varchar2(1),
22 hi_mr pay_element_entry_values_f.screen_entry_value%type);
23 --
24 type t_ass_hi_smr_tbl is table of t_ass_hi_smr_rec index by binary_integer;
25 --
26 g_range_ass_hi_smr_tbl t_ass_hi_smr_tbl;
27 --
28 g_valid varchar2(1) := 'N';
29 g_log varchar2(1) := 'Y';
30 --
31 g_detail_debug boolean := false;
32 g_debug boolean := hr_utility.debug_enabled;
33 --
34 --
35 PROCEDURE ELEMENT_RUN_RESULT_COPY(
36 P_MODE IN VARCHAR2,
37 P_PARAMETER_NAME IN VARCHAR2,
38 P_PARAMETER_VALUE IN NUMBER);
39 --
40 PROCEDURE ADD_NEW_INPUT_VALUE(
41 P_MODE IN VARCHAR2,
42 P_PARAMETER_NAME IN VARCHAR2,
43 P_PARAMETER_VALUE IN NUMBER);
44 --
45 PROCEDURE END_ELEMENT_ENTRY(
46 P_MODE IN VARCHAR2,
47 P_PARAMETER_NAME IN VARCHAR2,
48 P_PARAMETER_VALUE IN NUMBER,
49 P_SESSION_DATE IN DATE);
50 --
51 --
52 function get_ass_info(
53 p_assignment_id in number,
54 p_effective_date in date)
55 return t_ass_hi_smr_rec;
56 --
57 function get_mig_date
58 return date;
59 --
60 procedure insert_session(
61 p_effective_date in date);
62 --
63 procedure delete_session;
64 --
65 procedure qualify_hi_smr_hd(
66 p_assignment_id in number);
67 --
68 procedure migrate_hi_smr_hd(
69 p_assignment_id in number);
70 --
71 procedure init_def_hi_smr_data;
72 --
73 procedure val_mig_smr_assact(
74 p_business_group_id in number,
75 p_business_group_name in varchar2,
76 p_assignment_id in number,
77 p_assignment_number in varchar2,
78 p_session_date in date,
79 p_valid_delete in out nocopy varchar2);
80 --
81 procedure mig_smr_assact(
82 p_business_group_id in number,
83 p_business_group_name in varchar2,
84 p_assignment_id in number,
85 p_assignment_number in varchar2,
86 p_session_date in date,
87 p_hi_mr in varchar2);
88 --
89 -- this is for manual run by script, recommend to use generic upgrade instead of this.
90 procedure run_mig_smr;
91 --
92 END HR_JP_DATA_MIGRATION_PKG;