[Home] [Help]
PACKAGE: APPS.PAY_NO_PAYSLIP_REPORT
Source
1 PACKAGE pay_no_payslip_report AS
2 /* $Header: pynopsrp.pkh 120.0 2007/11/20 05:48:34 namgoyal noship $ */
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 CURSOR csr_asg IS
33 SELECT 'TRANSFER_ACT_ID=P',ptoa.object_Action_id
34 FROM pay_temp_object_actions ptoa
35 ,per_all_assignments_f paaf
36 ,per_all_people_f papf
37 ,pay_payroll_actions ppa
38 ,hr_soft_coding_keyflex hsck
39 ,per_business_groups pbg
40 ,per_assignment_status_types past
41 ,per_person_types ppt
42 WHERE ptoa.object_id = paaf.assignment_id
43 AND paaf.person_id = papf.person_id
44 AND ptoa.payroll_action_id = TO_NUMBER(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'))
45 AND ptoa.payroll_action_id = ppa.payroll_action_id
46 AND paaf.effective_start_date <= TO_DATE(pay_payslip_report.get_parameter(ppa.legislative_parameters,'END_DATE'),'YYYY/MM/DD')
47 AND paaf.effective_end_date >= TO_DATE(pay_payslip_report.get_parameter(ppa.legislative_parameters,'START_DATE'),'YYYY/MM/DD')
48 AND papf.effective_start_date <= TO_DATE(pay_payslip_report.get_parameter(ppa.legislative_parameters,'END_DATE'),'YYYY/MM/DD')
49 AND papf.effective_end_date >= TO_DATE(pay_payslip_report.get_parameter(ppa.legislative_parameters,'START_DATE'),'YYYY/MM/DD')
50 AND papf.business_group_id = pbg.business_group_id
51 AND pbg.legislation_code = NVL(past.legislation_code,pbg.legislation_code)
52 AND past.per_system_status = 'ACTIVE_ASSIGN'
53 AND past.active_flag = 'Y'
54 AND past.assignment_status_type_id = paaf.assignment_status_type_id
55 AND ppt.person_type_id = papf.person_type_id
56 AND ppt.business_group_id = pbg.business_group_id
57 AND ppt.active_flag = 'Y'
58 AND ppt.system_person_type = 'EMP'
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
102 CURSOR csr_curr_act IS
103 SELECT 'TRANSFER_ACT_ID=P',
104 pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
105 FROM DUAL;
106 --
107 PROCEDURE xml_header;
108 --
109 PROCEDURE xml_footer;
110 --
111 PROCEDURE xml_asg;
112 --
113 PROCEDURE qualifying_proc(p_assignment_id IN NUMBER
114 ,p_qualifier OUT NOCOPY VARCHAR2 );
115 --
116 --
117 END pay_no_payslip_report;