[Home] [Help]
PACKAGE: APPS.PAY_NO_EERR_CONTINUOUS
Source
1 PACKAGE pay_no_eerr_continuous as
2 /* $Header: pynoeerc.pkh 120.0.12000000.1 2007/05/22 06:24:12 rajesrin noship $ */
3 --------------------------------------------------------------------------------
4 -- Global Variables
5 --------------------------------------------------------------------------------
6 --
7 g_public_org_flag hr_lookups.lookup_type%type;
8 g_risk_cover_flag hr_lookups.lookup_type%type;
9 g_contract_code_mapping hr_lookups.lookup_type%type;
10
11 --
12 --------------------------------------------------------------------------------
13 -- GET_ALL_PARAMETERS
14 --------------------------------------------------------------------------------
15 procedure get_all_parameters (
16 p_payroll_action_id in number,
17 p_business_group_id out nocopy number,
18 p_legal_employer_id out nocopy number,
19 p_archive out nocopy varchar2,
20 p_start_date out nocopy date,
21 p_end_date out nocopy date,
22 p_effective_date out nocopy date
23 -- p_report_mode out nocopy varchar2
24 );
25
26 --------------------------------------------------------------------------------
27 -- GET_PARAMETERS
28 --------------------------------------------------------------------------------
29 function get_parameter (
30 p_parameter_string in varchar2,
31 p_token in varchar2,
32 p_segment_number in number default null
33 )
34 return varchar2;
35
36 --------------------------------------------------------------------------------
37 -- RANGE_CODE
38 --------------------------------------------------------------------------------
39 procedure range_code (
40 p_payroll_action_id in number,
41 p_sql out nocopy varchar2
42 );
43 --------------------------------------- PROCEDURE ARCHIVE_EMPLOYEE_DETAILS -----------------------------------------------------------
44 /* EMPLOYEE DETAILS REGION */
45 procedure archive_code (
46 p_assignment_action_id in number,
47 p_effective_date in date
48 );
49
50 procedure initialization_code (
51 p_payroll_action_id in number
52 );
53
54 procedure assignment_action_code (
55 p_payroll_action_id in number,
56 p_start_person in number,
57 p_end_person in number,
58 p_chunk in number
59 );
60
61 function find_total_hour (
62 p_hours in number,
63 p_frequency in varchar2
64 )
65 return number;
66
67 procedure sort_changes (
68 p_detail_tab in out nocopy pay_interpreter_pkg.t_detailed_output_table_type
69 );
70
71 procedure copy (
72 p_copy_from in out nocopy pay_interpreter_pkg.t_detailed_output_table_type,
73 p_from in number,
74 p_copy_to in out nocopy pay_interpreter_pkg.t_detailed_output_table_type,
75 p_to in number
76 );
77
78 function get_assignment_all_hours (
79 p_assignment_id in per_all_assignments_f.assignment_id%type,
80 p_person_id in per_all_people_f.person_id%type,
81 p_effective_date in date,
82 p_primary_hour_value number,
83 p_local_unit number
84 )
85 return number;
86
87
88 function check_national_identifier (
89 p_national_identifier varchar2
90 ) return varchar2;
91
92
93 /******** PROCEDURES FOR WRITING THE REPORT ********/
94 type xml_rec_type is record (
95 tagname varchar2 (240),
96 tagvalue varchar2 (240)
97 );
98
99 type xml_tab_type is table of xml_rec_type
100 index by binary_integer;
101
102 xml_tab xml_tab_type;
103
104 procedure populate_details (
105 p_business_group_id in number,
106 p_payroll_action_id in varchar2,
107 p_template_name in varchar2,
108 p_xml out nocopy clob
109 );
110
111 procedure writetoclob (
112 p_xfdf_clob out nocopy clob
113 );
114 end pay_no_eerr_continuous;
115