1 PACKAGE pay_ca_eoy_rl1_cancelled_pkg AUTHID CURRENT_USER AS
2 /* $Header: pycarl1clcr.pkh 120.1.12020000.2 2012/12/31 12:50:52 rgottipa ship $ */
3 /*
4 ******************************************************************
5 * *
6 * Copyright (C) 1993 Oracle Corporation. *
7 * All rights reserved. *
8 * *
9 * This material has been provided pursuant to an agreement *
10 * containing restrictions on its use. The material is also *
11 * protected by copyright law. No part of this material may *
12 * be copied or distributed, transmitted or transcribed, in *
13 * any form or by any means, electronic, mechanical, magnetic, *
14 * manual, or otherwise, or disclosed to third parties without *
15 * the express written permission of Oracle Corporation, *
16 * 500 Oracle Parkway, Redwood City, CA, 94065. *
17 * *
18 ******************************************************************
19
20 Name : pay_ca_eoy_rl1_cancelled_pkg
21
22 Description : This Package is used by RL1 Cancelled Report
23
24 Change List
25 -----------
26 Date Name Vers Bug No Description
27 ----------- ---------- ----- ------- -----------------------------------
28 28-DEC-2010 rgottipa 115.1 10324374 Created.
29 06-SEP-2011 rgottipa 115.2 10399514 Overloaded the PROCEDURE
30 get_payroll_action_info to get
31 report_qualifier and report_category
32 31-Dec-2012 rgottipa 115.2 15886428 Modified the defination of procedure
33 'get_payroll_action_info' by adding extra
34 parameter 'p_print_term'
35 */
36
37 PROCEDURE get_payroll_action_info(p_payroll_action_id in number
38 ,p_end_date out nocopy date
39 ,p_start_date out nocopy date
40 ,p_business_group_id out nocopy number
41 ,p_tax_unit_id out nocopy number
42 ,p_person_id out nocopy number
43 ,p_asg_set out nocopy number
44 ,p_print out nocopy varchar2
45 ,p_prov_cd out nocopy varchar2
46 ,p_report_type out nocopy varchar2
47 );
48 -- Added for Bug# 10399514
49 PROCEDURE get_payroll_action_info(p_payroll_action_id in number
50 ,p_end_date out nocopy date
51 ,p_start_date out nocopy date
52 ,p_business_group_id out nocopy number
53 ,p_tax_unit_id out nocopy number
54 ,p_person_id out nocopy number
55 ,p_asg_set out nocopy number
56 ,p_print out nocopy varchar2
57 ,p_prov_cd out nocopy varchar2
58 ,p_report_type out nocopy varchar2
59 ,p_report_qualifier out nocopy varchar2
60 ,p_report_category out nocopy varchar2
61 ,p_print_term out nocopy varchar2
62 );
63
64
65 PROCEDURE range_cursor(p_payroll_action_id in number
66 ,p_sqlstr out nocopy varchar2);
67
68 PROCEDURE action_creation(p_payroll_action_id in number
69 ,p_start_person_id in number
70 ,p_end_person_id in number
71 ,p_chunk in number);
72
73
74 FUNCTION get_parameter(parameter_name varchar2,
75 parameter_list varchar2) return varchar2;
76
77 PROCEDURE sort_action (payactid in varchar2,
78 sqlstr in out nocopy varchar2,
79 len out nocopy number);
80
81 g_min_chunk number:= -1;
82 g_archive_flag varchar2(1) := 'N';
83 g_bal_act_id number:= -1;
84
85 END pay_ca_eoy_rl1_cancelled_pkg;
[Home] [Help]