1 PACKAGE ast_Invoices_PVT AUTHID CURRENT_USER AS
2 /* $Header: astvinvs.pls 115.3 2002/02/06 11:43:55 pkm ship $ */
3
4 TYPE INVOICE_ID_TBL_TYPE IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
5 TYPE INVOICE_NUMBER_TBL_TYPE IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
6 TYPE INVOICE_STATUS_TBL_TYPE IS TABLE OF VARCHAR2(80) INDEX BY BINARY_INTEGER;
7 TYPE INVOICE_CLASS_TBL_TYPE IS TABLE OF VARCHAR2(80) INDEX BY BINARY_INTEGER;
8 TYPE INV_STATUS_CODE_TBL_TYPE IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
9 TYPE INV_CLASS_CODE_TBL_TYPE IS TABLE OF VARCHAR2(20) INDEX BY BINARY_INTEGER;
10 TYPE INVOICE_DATE_TBL_TYPE IS TABLE OF DATE INDEX BY BINARY_INTEGER;
11 TYPE ORIGINAL_AMOUNT_TBL_TYPE IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
12 TYPE REMAINING_AMOUNT_TBL_TYPE IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
13 TYPE INVOICE_CURRENCY_TBL_TYPE IS TABLE OF VARCHAR2(15) INDEX BY BINARY_INTEGER;
14 TYPE FUN_REMAINING_AMOUNT_TBL_TYPE IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
15
16 PROCEDURE GET_INVOICES(
17 P_API_VERSION IN NUMBER,
18 P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
19 P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
20 P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
21 X_RETURN_STATUS OUT VARCHAR2,
22 X_MSG_COUNT OUT NUMBER,
23 X_MSG_DATA OUT VARCHAR2,
24 P_TRANSACTION_IDS IN VARCHAR2,
25 X_INVOICE_ID_T OUT INVOICE_ID_TBL_TYPE,
26 X_INVOICE_NUMBER_T OUT INVOICE_NUMBER_TBL_TYPE,
27 X_INVOICE_STATUS_T OUT INVOICE_STATUS_TBL_TYPE,
28 X_INVOICE_CLASS_T OUT INVOICE_CLASS_TBL_TYPE,
29 X_INV_STATUS_CODE_T OUT INV_STATUS_CODE_TBL_TYPE,
30 X_INV_CLASS_CODE_T OUT INV_CLASS_CODE_TBL_TYPE,
31 X_INVOICE_DATE_T OUT INVOICE_DATE_TBL_TYPE,
32 X_ORIGINAL_AMOUNT_T OUT ORIGINAL_AMOUNT_TBL_TYPE,
33 X_REMAINING_AMOUNT_T OUT REMAINING_AMOUNT_TBL_TYPE,
34 X_INVOICE_CURRENCY_T OUT INVOICE_CURRENCY_TBL_TYPE,
35 X_FUN_REMAINING_AMOUNT_T OUT FUN_REMAINING_AMOUNT_TBL_TYPE);
36 END;