1 PACKAGE pay_hk_payslip_archive AS
2 /* $Header: pyhkparc.pkh 120.1.12000000.1 2007/01/17 20:40:06 appldev noship $ */
3
4
5 --------------------------------------------------------------------
6 -- Bug 3134158 - public variables
7 --------------------------------------------------------------------
8 g_sn_populated boolean := FALSE;
9
10 type r_scheme_name_store is record
11 (scheme_name hr_organization_information.org_information2%TYPE);
12
13 type t_scheme_name_tab is table of r_scheme_name_store
14 index by binary_integer;
15
16 g_scheme_name_table t_scheme_name_tab;
17
18 --------------------------------------------------------------------
19 -- These are PUBLIC procedures are required by the Archive process.
20 -- There names are stored in PAY_REPORT_FORMAT_MAPPINGS_F so that
21 -- the archive process knows what code to execute for each step of
22 -- the archive.
23 --------------------------------------------------------------------
24
25 --------------------------------------------------------------------
26 -- This procedure returns a sql string to select a range
27 -- of assignments eligible for archival.
28 --------------------------------------------------------------------
29
30 procedure range_code
31 (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
32 p_sql out nocopy varchar2);
33
34
35
36 --------------------------------------------------------------------
37 -- This procedure is used to set global contexts
38 -- Here It is used to archive the data at payroll action level.
39 --------------------------------------------------------------------
40
41 procedure initialization_code
42 (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type);
43
44
45 --------------------------------------------------------------------
46 -- This procedure further restricts the assignment_id's
47 -- returned by range_code
48 --------------------------------------------------------------------
49
50 procedure assignment_action_code
51 (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
52 p_start_person in per_all_people_f.person_id%type,
53 p_end_person in per_all_people_f.person_id%type,
54 p_chunk in number);
55
56
57 --------------------------------------------------------------------
58 -- This procedure is actually used to archive data . It
59 -- internally calls private procedures to archive balances ,
60 -- employee details, employer details ,elements,absences and accruals etc.
61 --------------------------------------------------------------------
62
63 procedure archive_code
64 (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
65 p_effective_date in date);
66
67
68 --------------------------------------------------------------------
69 -- This function returns the valid scheme names and is used by the
70 -- view pay_hk_asg_element_payments_v - Bug 3134158
71 --------------------------------------------------------------------
72 function get_scheme_name
73 (p_run_result_id in pay_run_results.run_result_id%TYPE,
74 p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE,
75 p_business_group_id in hr_organization_units.business_group_id%TYPE)
76 return varchar2;
77
78 --------------------------------------------------------------------
79 -- This function returns the assessed ri and is used by the
80 -- view pay_hk_asg_mpf_data_v - Bug 4260143
81 --------------------------------------------------------------------
82
83 function get_assessed_ri
84 (p_run_result_id in pay_run_results.run_result_id%TYPE)
85 return VARCHAR2;
86 --------------------------------------------------------------------
87
88
89 END pay_hk_payslip_archive;