PACKAGE: APPS.PAY_SE_PAYSLIP_REPORT

Source

1 PACKAGE pay_se_payslip_report AS
2 /* $Header: pysepsrp.pkh 120.0.12010000.1 2008/07/27 23:38:01 appldev 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     PROCEDURE get_all_parameters(p_payroll_action_id                 IN          NUMBER
11                                 ,p_payroll_id                        OUT  NOCOPY NUMBER
12                                 ,p_consolidation_set_id              OUT  NOCOPY NUMBER
13                                 ,p_start_date                        OUT  NOCOPY VARCHAR2
14                                 ,p_end_date                          OUT  NOCOPY VARCHAR2
15                                 ,p_rep_group                         OUT  NOCOPY VARCHAR2
16                                 ,p_rep_category                      OUT  NOCOPY VARCHAR2
17                                 ,p_assignment_set_id                 OUT  NOCOPY NUMBER
18                                 ,p_assignment_id                     OUT  NOCOPY NUMBER
19                                 ,p_effective_date                    OUT  NOCOPY DATE
20                                 ,p_business_group_id                 OUT  NOCOPY NUMBER
21                                 ,p_legislation_code                  OUT  NOCOPY VARCHAR2 ) ;
22     --
23     CURSOR  csr_header IS
24     Select 'DUMMY=P',dummy
25     FROM    DUAL;
26     --
27     CURSOR  csr_asg IS
28     SELECT 'TRANSFER_ACT_ID=P',ptoa.object_Action_id
29     FROM    pay_temp_object_actions ptoa
30     WHERE 	ptoa.payroll_action_id = to_number(pay_magtape_generic.get_parameter_value
31                                                 ('TRANSFER_PAYROLL_ACTION_ID'));
32     --
33     CURSOR csr_curr_act IS
34     SELECT 'TRANSFER_ACT_ID=P',
35            pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
36     FROM DUAL;
37     --
38     PROCEDURE xml_header;
39     --
40     PROCEDURE xml_footer;
41     --
42     PROCEDURE xml_asg;
43     --
44     PROCEDURE qualifying_proc(p_assignment_id    IN         NUMBER
45                              ,p_qualifier        OUT NOCOPY VARCHAR2 );
46     --
47 --
48 END pay_se_payslip_report;