[Home] [Help]
PACKAGE: APPS.PAY_PAYSLIP_REPORT
Source
1 PACKAGE pay_payslip_report AS
2 /* $Header: pygpsrep.pkh 120.0.12010000.6 2008/10/03 08:41:41 ankagarw ship $ */
3 --
4 level_cnt NUMBER;
5 g_pa_token VARCHAR2(50);
6 g_cs_token VARCHAR2(50);
7 --
8 FUNCTION get_parameter ( p_parameter_string IN VARCHAR2
9 ,p_token IN VARCHAR2
10 ,p_segment_number IN NUMBER DEFAULT NULL ) RETURN VARCHAR2;
11 --
12 FUNCTION get_sort_order( p_type IN VARCHAR2
13 ,p_legislation_code IN VARCHAR2 ) RETURN VARCHAR2 ;
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_asg IS
29 SELECT 'TRANSFER_ACT_ID=P',ptoa.object_Action_id
30 FROM pay_temp_object_actions ptoa
31 ,per_all_assignments_f paaf
32 ,per_all_people_f papf
33 ,pay_payroll_actions ppa
34 ,hr_soft_coding_keyflex hsck
35 ,per_business_groups pbg
36 ,per_assignment_status_types past
37 ,per_person_types ppt
38 WHERE ptoa.object_id = paaf.assignment_id
39 AND paaf.person_id = papf.person_id
40 AND ptoa.payroll_action_id = TO_NUMBER(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'))
41 AND ptoa.payroll_action_id = ppa.payroll_action_id
42 AND paaf.effective_start_date = (SELECT MAX(paf_inner.effective_start_date)
43 FROM per_all_assignments_f paf_inner
44 WHERE paf_inner.assignment_id = paaf.assignment_id
45 AND paf_inner.effective_start_date <=
46 TO_DATE(pay_payslip_report.get_parameter(ppa.legislative_parameters,'END_DATE'),'YYYY/MM/DD')
47 )
48 AND paaf.effective_start_date between papf.effective_start_date and papf.effective_end_date
49 AND papf.business_group_id = pbg.business_group_id
50 AND pbg.legislation_code = NVL(past.legislation_code,pbg.legislation_code)
51 /* 7195040 - Condition to be Added to Prevent Duplicates for Benefit,
52 Applicant, or Contractor Assignments*/
53 AND paaf.assignment_type = 'E'
54 AND past.active_flag = 'Y'
55 AND past.assignment_status_type_id = paaf.assignment_status_type_id
56 AND ppt.person_type_id = papf.person_type_id
57 AND ppt.business_group_id = pbg.business_group_id
58 AND ppt.active_flag = 'Y'
59 AND paaf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
60 ORDER BY DECODE(pay_payslip_report.get_sort_order('LE',pbg.legislation_code)
61 ,'SEGMENT1',hsck.segment1
62 ,'SEGMENT2',hsck.segment2
63 ,'SEGMENT3',hsck.segment3
64 ,'SEGMENT4',hsck.segment4
65 ,'SEGMENT5',hsck.segment5
66 ,'SEGMENT6',hsck.segment6
67 ,'SEGMENT7',hsck.segment7
68 ,'SEGMENT8',hsck.segment8
69 ,'SEGMENT9',hsck.segment9
70 ,'SEGMENT10',hsck.segment10
71 ,'SEGMENT11',hsck.segment11
72 ,'SEGMENT12',hsck.segment12
73 ,'SEGMENT13',hsck.segment13
74 ,'SEGMENT14',hsck.segment14
75 ,'SEGMENT15',hsck.segment15
76 ,'SEGMENT16',hsck.segment16
77 ,'SEGMENT17',hsck.segment17
78 ,'SEGMENT18',hsck.segment18
79 ,'SEGMENT19',hsck.segment19
80 ,'SEGMENT20',hsck.segment20
81 ,'SEGMENT21',hsck.segment21
82 ,'SEGMENT22',hsck.segment22
83 ,'SEGMENT23',hsck.segment23
84 ,'SEGMENT24',hsck.segment24
85 ,'SEGMENT25',hsck.segment25
86 ,'SEGMENT26',hsck.segment26
87 ,'SEGMENT27',hsck.segment27
88 ,'SEGMENT28',hsck.segment28
89 ,'SEGMENT29',hsck.segment29
90 ,'SEGMENT30',hsck.segment30)
91 ,DECODE(pay_payslip_report.get_sort_order('ORG',pbg.legislation_code)
92 ,'ORGANIZATION_ID',paaf.organization_id
93 ,'ASSIGNMENT_NUMBER',paaf.assignment_number)
94 ,DECODE(pay_payslip_report.get_sort_order('NAME',pbg.legislation_code)
95 ,'LAST_NAME',papf.last_name
96 ,'FIRST_NAME',papf.first_name
97 ,'FULL_NAME',papf.full_name
98 ,papf.last_name)
99 ,paaf.assignment_number ;
100 --
101 CURSOR csr_curr_act IS
102 SELECT 'TRANSFER_ACT_ID=P',
103 pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
104 FROM DUAL;
105 --
106 PROCEDURE xml_asg;
107 --
108 PROCEDURE qualifying_proc(p_assignment_id IN NUMBER
109 ,p_qualifier OUT NOCOPY VARCHAR2 );
110
111 --
112 END pay_payslip_report;