[Home] [Help]
PACKAGE: APPS.APRX_WT
Source
1 PACKAGE APRX_WT AS
2 /* $Header: aprxwts.pls 120.1 2003/06/13 19:47:06 isartawi noship $ */
3
4 --
5 -- Main Core Report
6 PROCEDURE GET_WITHOLDING_TAX(
7 request_id in number,
8 section_name in varchar2,
9 retcode out NOCOPY number,
10 errbuf out NOCOPY varchar2);
11
12 -- (AP Witholding Tax/Report ), which is a plug-in
13 PROCEDURE ap_wht_tax_report (
14 p_date_from in varchar2,
15 p_date_to in varchar2,
16 p_supplier_from in varchar2,
17 p_supplier_to in varchar2,
18 p_supplier_type in varchar2,
19 request_id in number,
20 retcode out NOCOPY number,
21 errbuf out NOCOPY varchar2);
22
23 --
24 -- All event trigger procedures must be defined as public procedures
25 -- Procedure written for the Main/Core Report.
26 procedure before_report;
27 --procedure after_fetch;
28
29 -- Procedures written for the plug-in --( AP Witholding Tax/Letter) Report.
30 procedure awt_before_report;
31 procedure awt_bind(c in integer);
32
33 --
34 -- This is the structre to hold the placeholder values
35
36 type var_t is record(
37 BOOKS_ID NUMBER,
38 ORGANIZATION_NAME VARCHAR2(240),
39 FUNCTIONAL_CURRENCY_CODE VARCHAR2(15),
40 ADDRESS_LINE1 VARCHAR2(240),
41 ADDRESS_LINE2 VARCHAR2(240),
42 ADDRESS_LINE3 VARCHAR2(240),
43 CITY VARCHAR2(30),
44 ZIP VARCHAR2(30),
45 PROVINCE VARCHAR2(30),
46 STATE VARCHAR2(150),
47 COUNTRY VARCHAR2(60),
48 TAX_AUTHORITY VARCHAR2(80),
49 SUPPLIER_TYPE VARCHAR2(25),
50 SET_OF_BOOKS_ID NUMBER,
51 SUPPLIER_NAME VARCHAR2(240),
52 TAXPAYER_ID VARCHAR2(30),
53 SUPPLIER_NUMBER VARCHAR2(30),
54 VAT_REGISTRATION_NUMBER VARCHAR2(20),
55 SUPPLIER_ADDRESS_LINE1 VARCHAR2(240),
56 SUPPLIER_ADDRESS_LINE2 VARCHAR2(240),
57 SUPPLIER_ADDRESS_LINE3 VARCHAR2(240),
58 SUPPLIER_CITY VARCHAR2(25),
59 SUPPLIER_STATE VARCHAR2(150),
60 SUPPLIER_ZIP VARCHAR2(20),
61 SUPPLIER_PROVINCE VARCHAR2(150),
62 SUPPLIER_COUNTRY VARCHAR2(25),
63 SUPPLIER_SITE_CODE VARCHAR2(15),
64 INVOICE_NUM VARCHAR2(50),
65 INVOICE_AMOUNT NUMBER,
66 INVOICE_CURRENCY_CODE VARCHAR2(15),
67 INVOICE_DATE DATE,
68 INV_GLOBAL_ATTRIBUTE1 VARCHAR2(150),
69 INV_GLOBAL_ATTRIBUTE2 VARCHAR2(150),
70 INV_GLOBAL_ATTRIBUTE3 VARCHAR2(150),
71 INV_GLOBAL_ATTRIBUTE4 VARCHAR2(150),
72 INV_GLOBAL_ATTRIBUTE5 VARCHAR2(150),
73 INV_GLOBAL_ATTRIBUTE6 VARCHAR2(150),
74 INV_GLOBAL_ATTRIBUTE7 VARCHAR2(150),
75 INV_GLOBAL_ATTRIBUTE8 VARCHAR2(150),
76 INV_GLOBAL_ATTRIBUTE9 VARCHAR2(150),
77 INV_GLOBAL_ATTRIBUTE10 VARCHAR2(150),
78 INV_GLOBAL_ATTRIBUTE11 VARCHAR2(150),
79 INV_GLOBAL_ATTRIBUTE12 VARCHAR2(150),
80 INV_GLOBAL_ATTRIBUTE13 VARCHAR2(150),
81 INV_GLOBAL_ATTRIBUTE14 VARCHAR2(150),
82 INV_GLOBAL_ATTRIBUTE15 VARCHAR2(150),
83 INV_GLOBAL_ATTRIBUTE16 VARCHAR2(150),
84 INV_GLOBAL_ATTRIBUTE17 VARCHAR2(150),
85 INV_GLOBAL_ATTRIBUTE18 VARCHAR2(150),
86 INV_GLOBAL_ATTRIBUTE19 VARCHAR2(150),
87 INV_GLOBAL_ATTRIBUTE20 VARCHAR2(150),
88 PV_GLOBAL_ATTRIBUTE1 VARCHAR2(150),
89 PV_GLOBAL_ATTRIBUTE2 VARCHAR2(150),
90 PV_GLOBAL_ATTRIBUTE3 VARCHAR2(150),
91 PV_GLOBAL_ATTRIBUTE4 VARCHAR2(150),
92 PV_GLOBAL_ATTRIBUTE5 VARCHAR2(150),
93 PV_GLOBAL_ATTRIBUTE6 VARCHAR2(150),
94 PV_GLOBAL_ATTRIBUTE7 VARCHAR2(150),
95 PV_GLOBAL_ATTRIBUTE8 VARCHAR2(150),
96 PV_GLOBAL_ATTRIBUTE9 VARCHAR2(150),
97 PV_GLOBAL_ATTRIBUTE10 VARCHAR2(150),
98 PV_GLOBAL_ATTRIBUTE11 VARCHAR2(150),
99 PV_GLOBAL_ATTRIBUTE12 VARCHAR2(150),
100 PV_GLOBAL_ATTRIBUTE13 VARCHAR2(150),
101 PV_GLOBAL_ATTRIBUTE14 VARCHAR2(150),
102 PV_GLOBAL_ATTRIBUTE15 VARCHAR2(150),
103 PV_GLOBAL_ATTRIBUTE16 VARCHAR2(150),
104 PV_GLOBAL_ATTRIBUTE17 VARCHAR2(150),
105 PV_GLOBAL_ATTRIBUTE18 VARCHAR2(150),
106 PV_GLOBAL_ATTRIBUTE19 VARCHAR2(150),
107 PV_GLOBAL_ATTRIBUTE20 VARCHAR2(150),
108 AWT_CODE VARCHAR2(15),
109 AWT_RATE NUMBER,
110 AWT_AMOUNT NUMBER,
111 AWT_BASE_AMOUNT NUMBER,
112 AWT_GROUP_NAME VARCHAR2(25),
113 AWT_GL_DATE DATE,
114 AWT_GROSS_AMOUNT NUMBER
115 );
116
117 var var_t;
118
119 END APRX_WT;