DBA Data[Home] [Help]

PACKAGE: APPS.PAY_ZA_TYE_ARCHIVE_PKG

Source


1 package pay_za_tye_archive_pkg authid current_user as
2 /* $Header: pyzatyea.pkh 120.0.12010000.1 2009/11/26 08:48:43 parusia noship $ */
3 /*+======================================================================+
4   |       Copyright (c) 1998 Oracle Corporation South Africa Ltd         |
5   |                Cape Town, Western Cape, South Africa                 |
6   |                           All rights reserved.                       |
7   +======================================================================+
8   SQL Script File name : pyzatyea.pkh
9   Description          : This sql script seeds the Package that creates
10                          the Tax Year End Archive code
11 
12   Change List:
13   ------------
14 
15   Name           Date        Version Bug     Text
16   -------------- ----------- ------- ------  ------------------------------
17   P.Arusia       17-Nov-2009 115.1   9117260 Initial Version as per TYE2010
18  ==========================================================================
19 */
20 
21 procedure range_cursor     (pactid  in number,
22                             sqlstr  out nocopy varchar2);
23 
24 procedure action_creation(pactid in number,
25                           stperson in number,
26                           endperson in number,
27                           chunk in number) ;
28 --
29 procedure archive_data (p_assactid         in   number,
30                         p_effective_date   in   date);
31 
32 procedure archinit(p_payroll_action_id in number);
33 
34 procedure archdinit(pactid in number);
35 
36 function get_parameter
37 (
38    name        in varchar2,
39    parameter_list varchar2
40 )  return varchar2;
41 
42 function sub_type(p_code number, user_name varchar2, p_balance_sequence number) return varchar2;
43 
44 end pay_za_tye_archive_pkg;