PACKAGE: APPS.PAY_NO_EERR_STATUS_CONTROL

Source

1 PACKAGE  PAY_NO_EERR_STATUS_CONTROL AS
2 /* $Header: pynoeers.pkh 120.0.12000000.1 2007/05/22 06:28:24 rajesrin noship $ */
3 
4 --------------------------------------------------------------------------------
5 -- Global Variables
6 --------------------------------------------------------------------------------
7 --
8 g_public_org_flag hr_lookups.lookup_type%TYPE;
9 g_risk_cover_flag hr_lookups.lookup_type%TYPE;
10 g_contract_code_mapping hr_lookups.lookup_type%TYPE;
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 -- GET_PARAMETERS
27 --------------------------------------------------------------------------------
28 FUNCTION GET_PARAMETER(
29 		 p_parameter_string IN VARCHAR2
30 		,p_token            IN VARCHAR2
31 		,p_segment_number   IN NUMBER default NULL ) RETURN VARCHAR2;
32 --------------------------------------------------------------------------------
33 -- RANGE_CODE
34 --------------------------------------------------------------------------------
35 procedure range_code (
36       p_payroll_action_id   in              number,
37       p_sql                 out nocopy      varchar2
38    );
39  ---------------------------------------  PROCEDURE ARCHIVE_EMPLOYEE_DETAILS -----------------------------------------------------------
40 /* EMPLOYEE DETAILS REGION */
41   PROCEDURE ARCHIVE_CODE(p_assignment_action_id IN NUMBER
42 			      ,p_effective_date    IN DATE);
43  PROCEDURE INITIALIZATION_CODE(p_payroll_action_id IN NUMBER);
44  PROCEDURE ASSIGNMENT_ACTION_CODE
45 	 (p_payroll_action_id     IN NUMBER
46 	 ,p_start_person          IN NUMBER
47 	 ,p_end_person            IN NUMBER
48 	 ,p_chunk                 IN NUMBER);
49 
50 PROCEDURE sort_changes(p_detail_tab IN OUT NOCOPY pay_interpreter_pkg.t_detailed_output_table_type);
51 
52 PROCEDURE copy(p_copy_from IN OUT NOCOPY pay_interpreter_pkg.t_detailed_output_table_type
53               ,p_from      IN            NUMBER
54               ,p_copy_to   IN OUT NOCOPY pay_interpreter_pkg.t_detailed_output_table_type
55               ,p_to        IN            NUMBER);
56 
57 
58 
59  FUNCTION GET_ASSIGNMENT_ALL_HOURS
60 
61 (P_ASSIGNMENT_ID IN per_all_assignments_f.assignment_id%type,
62  P_PERSON_ID     IN per_all_people_f.person_id%type,
63  P_EFFECTIVE_DATE IN DATE,
64  P_PRIMARY_HOUR_VALUE NUMBER,
65  p_local_unit   number) RETURN number ;
66 
67 function check_national_identifier (
68    p_national_identifier   varchar2
69 ) return varchar2;
70 
71 
72    function find_total_hour (
73          p_hours       in   number,
74          p_frequency   in   varchar2
75       )
76          return number;
77 
78 /******** PROCEDURES FOR WRITING THE REPORT ********/
79 
80 TYPE xml_rec_type IS RECORD
81 (
82     TagName VARCHAR2(240),
83     TagValue VARCHAR2(240)
84 );
85 
86 TYPE xml_tab_type
87 IS TABLE OF xml_rec_type
88 INDEX BY BINARY_INTEGER;
89 
90 xml_tab xml_tab_type;
91 
92          PROCEDURE populate_details
93         (p_business_group_id     IN NUMBER,
94          p_payroll_action_id     IN VARCHAR2 ,
95          p_template_name         IN VARCHAR2,
96          p_xml                   OUT NOCOPY CLOB);
97 
98 
99 PROCEDURE WritetoCLOB
100         (p_xfdf_clob             OUT NOCOPY CLOB);
101 
102 
103 END PAY_NO_EERR_STATUS_CONTROL;