[Home] [Help]
PACKAGE: APPS.PAY_NO_PAYSLIP_REPORT
Source
1 PACKAGE pay_no_payslip_report AUTHID CURRENT_USER AS
2 /* $Header: pynopsrp.pkh 120.0.12020000.2 2013/02/26 12:27:49 smeduri ship $ */
3 --
4 level_cnt NUMBER;
5 --
6 FUNCTION get_parameter ( p_parameter_string IN VARCHAR2
7 ,p_token IN VARCHAR2
8 ,p_segment_number IN NUMBER DEFAULT NULL ) RETURN VARCHAR2;
9
10 --
11 FUNCTION get_sort_order( p_type IN VARCHAR2
12 ,p_legislation_code IN VARCHAR2 ) RETURN VARCHAR2 ;
13 --
14
15 PROCEDURE get_all_parameters(p_payroll_action_id IN NUMBER
16 ,p_payroll_id OUT NOCOPY NUMBER
17 ,p_consolidation_set_id OUT NOCOPY NUMBER
18 ,p_start_date OUT NOCOPY VARCHAR2
19 ,p_end_date OUT NOCOPY VARCHAR2
20 ,p_rep_group OUT NOCOPY VARCHAR2
21 ,p_rep_category OUT NOCOPY VARCHAR2
22 ,p_assignment_set_id OUT NOCOPY NUMBER
23 ,p_assignment_id OUT NOCOPY NUMBER
24 ,p_effective_date OUT NOCOPY DATE
25 ,p_business_group_id OUT NOCOPY NUMBER
26 ,p_legislation_code OUT NOCOPY VARCHAR2 ) ;
27 --
28 CURSOR csr_header IS
29 Select 'DUMMY=P',dummy
30 FROM DUAL;
31 --
32 /* modified cursor for bug 16342029 */
33 CURSOR csr_asg IS
34 SELECT 'TRANSFER_ACT_ID=P',ptoa.object_Action_id
35 FROM pay_temp_object_actions ptoa
36 ,per_all_assignments_f paaf
37 ,per_all_people_f papf
38 ,pay_payroll_actions ppa
39 ,hr_soft_coding_keyflex hsck
40 ,per_business_groups pbg
41 -- ,per_assignment_status_types past
42 -- ,per_person_types ppt
43 WHERE ptoa.object_id = paaf.assignment_id
44 AND paaf.person_id = papf.person_id
45 AND ptoa.payroll_action_id = TO_NUMBER(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'))
46 AND ptoa.payroll_action_id = ppa.payroll_action_id
47 -- AND paaf.effective_start_date <= TO_DATE(pay_payslip_report.get_parameter(ppa.legislative_parameters,'END_DATE'),'YYYY/MM/DD')
48 -- AND paaf.effective_end_date >= TO_DATE(pay_payslip_report.get_parameter(ppa.legislative_parameters,'START_DATE'),'YYYY/MM/DD')
49 -- AND papf.effective_start_date <= TO_DATE(pay_payslip_report.get_parameter(ppa.legislative_parameters,'END_DATE'),'YYYY/MM/DD')
50 -- AND papf.effective_end_date >= TO_DATE(pay_payslip_report.get_parameter(ppa.legislative_parameters,'START_DATE'),'YYYY/MM/DD')
51 AND to_date(pay_payslip_report.get_parameter(ppa.legislative_parameters,'END_DATE'),'YYYY/MM/DD')
52 between paaf.effective_start_date and paaf.effective_end_date
53 AND to_date(pay_payslip_report.get_parameter(ppa.legislative_parameters,'END_DATE'),'YYYY/MM/DD')
54 between papf.effective_start_date and papf.effective_end_date
55 AND papf.business_group_id = pbg.business_group_id
56 -- AND pbg.legislation_code = NVL(past.legislation_code,pbg.legislation_code)
57 -- AND past.per_system_status = 'ACTIVE_ASSIGN'
58 -- AND past.active_flag = 'Y'
59 -- AND past.assignment_status_type_id = paaf.assignment_status_type_id
60 -- AND ppt.person_type_id = papf.person_type_id
61 -- AND ppt.business_group_id = pbg.business_group_id
62 -- AND ppt.active_flag = 'Y'
63 -- AND ppt.system_person_type = 'EMP'
64 AND paaf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
65 ORDER BY DECODE(pay_payslip_report.get_sort_order('LE',pbg.legislation_code)
66 ,'SEGMENT1',hsck.segment1
67 ,'SEGMENT2',hsck.segment2
68 ,'SEGMENT3',hsck.segment3
69 ,'SEGMENT4',hsck.segment4
70 ,'SEGMENT5',hsck.segment5
71 ,'SEGMENT6',hsck.segment6
72 ,'SEGMENT7',hsck.segment7
73 ,'SEGMENT8',hsck.segment8
74 ,'SEGMENT9',hsck.segment9
75 ,'SEGMENT10',hsck.segment10
76 ,'SEGMENT11',hsck.segment11
77 ,'SEGMENT12',hsck.segment12
78 ,'SEGMENT13',hsck.segment13
79 ,'SEGMENT14',hsck.segment14
80 ,'SEGMENT15',hsck.segment15
81 ,'SEGMENT16',hsck.segment16
82 ,'SEGMENT17',hsck.segment17
83 ,'SEGMENT18',hsck.segment18
84 ,'SEGMENT19',hsck.segment19
85 ,'SEGMENT20',hsck.segment20
86 ,'SEGMENT21',hsck.segment21
87 ,'SEGMENT22',hsck.segment22
88 ,'SEGMENT23',hsck.segment23
89 ,'SEGMENT24',hsck.segment24
90 ,'SEGMENT25',hsck.segment25
91 ,'SEGMENT26',hsck.segment26
92 ,'SEGMENT27',hsck.segment27
93 ,'SEGMENT28',hsck.segment28
94 ,'SEGMENT29',hsck.segment29
95 ,'SEGMENT30',hsck.segment30)
96 ,DECODE(pay_payslip_report.get_sort_order('ORG',pbg.legislation_code)
97 ,'ORGANIZATION_ID',paaf.organization_id
98 ,'ASSIGNMENT_NUMBER',paaf.assignment_number)
99 ,DECODE(pay_payslip_report.get_sort_order('NAME',pbg.legislation_code)
100 ,'LAST_NAME',papf.last_name
101 ,'FIRST_NAME',papf.first_name
102 ,'FULL_NAME',papf.full_name
103 ,papf.last_name)
104 ,paaf.assignment_number ;
105 --
106
107 CURSOR csr_curr_act IS
108 SELECT 'TRANSFER_ACT_ID=P',
109 pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
110 FROM DUAL;
111 --
112 PROCEDURE xml_header;
113 --
114 PROCEDURE xml_footer;
115 --
116 PROCEDURE xml_asg;
117 --
118 PROCEDURE qualifying_proc(p_assignment_id IN NUMBER
119 ,p_qualifier OUT NOCOPY VARCHAR2 );
120 --
121 --
122 END pay_no_payslip_report;