DBA Data[Home] [Help]

PACKAGE: APPS.PAY_ZA_MTC_PKG

Source


1 package pay_za_mtc_pkg AUTHID CURRENT_USER as
2 /* $Header: pyzamtc.pkh 120.4 2010/07/08 13:41:48 vijranga ship $ */
3 
4 ------------------------------------------------------------------------------
5 -- NAME
6 --   update_certificate_number
7 -- PURPOSE
8 --   Issues manual Tax Certificate Numbers
9 -- ARGUMENTS
10 --   p_errmsg         - returned error message
11 --   p_errcode        - returned error code
12 --   p_asg_action_id  - the assignment action id to process
13 --   p_tax_cert_no    - the tax certificate number used in update
14 --   p_asg_id         - the assignment id to process
15 -- NOTES
16 --
17 ------------------------------------------------------------------------------
18 
19 Procedure update_certificate_number
20           (
21            p_errmsg        out nocopy varchar2,
22            p_errcode       out nocopy varchar2,
23            p_bgid          in  number,
24            p_payroll_id    in  number,
25            p_tax_year      in  varchar2,
26            p_pay_action_id in  varchar2,
27            p_asg_id        in  number,
28            p_asg_action_id in  number,
29            p_tax_cert_no   in  varchar2
30           );
31 
32 Procedure upd_certificate_num_EOY2010
33           (
34            p_errmsg            out nocopy varchar2,
35            p_errcode           out nocopy varchar2,
36            p_bgid              in  number,
37            p_legal_entity_id   in  number,
38            p_tax_year          in  varchar2,
39 	   p_period_recon      in  varchar2, -- 9877034 fix
40            p_payroll           in  number,
41            p_pay_action_id     in  number,
42            p_asg_id            in  number,
43            p_temp_cert_no      in  varchar2,
44            p_tax_cert_no       in  varchar2
45           );
46 
47 End pay_za_mtc_pkg;