1 PACKAGE pa_tax_client_extn_drv AS
2 /* $Header: PAXVDTXS.pls 120.5 2007/10/24 15:07:13 arbandyo ship $ */
3
4 -- G_Draft_Invoice_Num is used to keep the draft invoice number
5 -- for invoice distribution warning.
6
7 G_Draft_Invoice_Num Number;
8
9 -- G_Prv_Draft_Invoice_Num and G_Project_Id are used to improve
10 -- performance of the package and used to store previous value.
11 G_Prv_Draft_Invoice_Num Number;
12 G_Project_Id Number;
13
14 -- Error Code returned from the client extension driver
15 G_error_Code PA_LOOKUPS.LOOKUP_CODE%TYPE;
16
17 /* Added global variable G_Invoice_Date to store invoice date
18 Added for Bug 6521026 */
19 G_Invoice_Date DATE;
20
21 -- get_tax_code calls the client extension and validate the value
22 -- returned by client written code and set the invoice distribution
23 -- warning if client supplied tax id is invalid.
24
25 PROCEDURE get_tax_code
26 ( P_project_id IN NUMBER,
27 P_customer_id IN NUMBER DEFAULT NULL,
28 P_bill_to_site_use_id IN NUMBER DEFAULT NULL,
29 P_ship_to_site_use_id IN NUMBER DEFAULT NULL,
30 P_set_of_books_id IN NUMBER DEFAULT NULL,
31 P_expenditure_item_id IN NUMBER DEFAULT NULL,
32 P_event_id IN NUMBER DEFAULT NULL,
33 P_line_type IN VARCHAR2 DEFAULT NULL,
34 P_request_id IN NUMBER DEFAULT NULL,
35 P_user_id IN NUMBER DEFAULT NULL,
36 X_output_Tax_code OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
37
38 end pa_tax_client_extn_drv;