1 PACKAGE AP_ETAX_PKG AS
2 /* $Header: apetaxps.pls 120.4 2006/10/12 19:05:19 schitlap noship $ */
3
4 FUNCTION Calling_eTax(
5 P_Invoice_id IN NUMBER,
6 P_Line_Number IN NUMBER DEFAULT NULL,
7 P_Calling_Mode IN VARCHAR2,
8 P_Override_Status IN VARCHAR2 DEFAULT NULL,
9 P_Line_Number_To_Delete IN NUMBER DEFAULT NULL,
10 P_Interface_Invoice_Id IN NUMBER DEFAULT NULL,
11 P_Event_Id IN NUMBER DEFAULT NULL,
12 P_All_Error_Messages IN VARCHAR2,
13 P_error_code OUT NOCOPY VARCHAR2,
14 P_Calling_Sequence IN VARCHAR2) RETURN BOOLEAN;
15
16 FUNCTION Calculate_Quote(
17 P_Calling_Mode IN VARCHAR2,
18 P_All_Error_Messages IN VARCHAR2,
19 P_Invoice_Header_Rec IN ap_invoices_all%ROWTYPE DEFAULT NULL,
20 P_Invoice_Lines_Rec IN ap_invoice_lines_all%ROWTYPE DEFAULT NULL,
21 P_Tax_Amount OUT NOCOPY NUMBER,
22 P_Tax_Amt_Included OUT NOCOPY VARCHAR2,
23 P_error_code OUT NOCOPY VARCHAR2,
24 P_Calling_Sequence IN VARCHAR2) RETURN BOOLEAN;
25
26 -- this is a wrapper of calling_etax() used by JDBC call
27 FUNCTION callETax(
28 x_Invoice_id IN NUMBER,
29 x_Line_Number IN NUMBER DEFAULT NULL,
30 x_Calling_Mode IN VARCHAR2,
31 x_Override_Status IN VARCHAR2 DEFAULT NULL,
32 x_Line_Number_To_Delete IN NUMBER DEFAULT NULL,
33 x_Interface_Invoice_Id IN NUMBER DEFAULT NULL,
34 x_Event_Id IN NUMBER DEFAULT NULL,
35 x_All_Error_Messages IN VARCHAR2,
36 x_error_code OUT NOCOPY VARCHAR2,
37 x_Calling_Sequence IN VARCHAR2) RETURN NUMBER;
38
39 AP_APPLICATION_ID
40 CONSTANT NUMBER
41 := 200;
42
43 AP_ENTITY_CODE
44 CONSTANT VARCHAR2(30)
45 := 'AP_INVOICES';
46
47 AP_INV_EVENT_CLASS_CODE
48 CONSTANT VARCHAR2(30)
49 := 'STANDARD INVOICES';
50
51 AP_PP_EVENT_CLASS_CODE
52 CONSTANT VARCHAR2(30)
53 := 'PREPAYMENT INVOICES';
54
55 AP_ER_EVENT_CLASS_CODE
56 CONSTANT VARCHAR2(30)
57 := 'EXPENSE REPORTS';
58
59 G_BATCH_LIMIT
60 CONSTANT NUMBER
61 := 1000;
62
63 TYPE g_inv_id_type IS TABLE OF AP_INVOICES_ALL.INVOICE_ID%TYPE INDEX BY PLS_INTEGER;
64 TYPE g_evnt_cls_type IS TABLE OF ZX_TRX_HEADERS_GT.EVENT_CLASS_CODE%TYPE INDEX BY PLS_INTEGER;
65
66 g_inv_id_list g_inv_id_type;
67 g_evnt_cls_list g_evnt_cls_type;
68
69
70 END AP_ETAX_PKG;
71