PACKAGE: APPS.JA_JAIN23C1_XMLP_PKG

Source

1 PACKAGE JA_JAIN23C1_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: JAIN23C1S.pls 120.1 2007/12/25 16:07:18 dwkrishn noship $ */
3   P_ORGANIZATION_ID NUMBER;
4   P_LOCATION_ID NUMBER;
5   P_TRN_FROM_DATE DATE;
6   P_TRN_FROM_DATE_1 DATE;
7   P_TRN_TO_DATE DATE;
8    P_TRN_TO_DATE_1 DATE;
9   P_FISCAL_YEAR DATE;
10   P_MONTH VARCHAR2(3);
11   P_START_PAGE_NO NUMBER;
12   P_CONC_REQUEST_ID NUMBER;
13   CP_PAGE_NO NUMBER;
14   CP_PAGE NUMBER;
15   FUNCTION CF_1FORMULA(REGISTER_ID IN NUMBER
16                       ,OPENING_BALANCE_QTY IN NUMBER
17                       ,CLOSING_BALANCE_QTY IN NUMBER
18                       ,INVENTORY_ITEM_ID IN NUMBER
19                       ,SLNO IN NUMBER) RETURN VARCHAR2;
20   FUNCTION AFTERREPORT RETURN BOOLEAN;
21   FUNCTION AFTERPFORM RETURN BOOLEAN;
22   FUNCTION CF_QTY_RECEIVEDFORMULA(SLNO_1 IN NUMBER
23                                  ,INVENTORY_ITEM_ID_1 IN NUMBER
24                                  ,TRANSACTION_DATE_1 IN DATE
25                                  ,TRANSACTION_TYPE IN VARCHAR2) RETURN NUMBER;
26   FUNCTION CF_INV_IDFORMULA(SLNO_1 IN NUMBER
27                            ,INVENTORY_ITEM_ID_1 IN NUMBER
28                            ,TRANSACTION_DATE_1 IN DATE) RETURN CHAR;
29   FUNCTION CF_INV_DTFORMULA(SLNO_1 IN NUMBER
30                            ,INVENTORY_ITEM_ID_1 IN NUMBER
31                            ,TRANSACTION_DATE_1 IN DATE) RETURN DATE;
32   FUNCTION CF_SALES_INV_IDFORMULA(SLNO_1 IN NUMBER
33                                  ,INVENTORY_ITEM_ID_1 IN NUMBER
34                                  ,TRANSACTION_DATE_1 IN DATE) RETURN CHAR;
35   FUNCTION CF_SALES_INV_DTFORMULA(SLNO_1 IN NUMBER
36                                  ,INVENTORY_ITEM_ID_1 IN NUMBER
37                                  ,TRANSACTION_DATE_1 IN DATE) RETURN DATE;
38   FUNCTION CF_SALES_INV_QTYFORMULA(SLNO_1 IN NUMBER
39                                   ,INVENTORY_ITEM_ID_1 IN NUMBER
40                                   ,TRANSACTION_DATE_1 IN DATE
41                                   ,TRANSACTION_TYPE IN VARCHAR2) RETURN NUMBER;
42   FUNCTION CF_FOLIO_A2FORMULA(A2FOLIONO2 IN VARCHAR2) RETURN CHAR;
43   FUNCTION CF_ITEM_TARRIFFORMULA(INVENTORY_ITEM_ID_1 IN NUMBER) RETURN CHAR;
44   FUNCTION CF_ITEM_FOLIOFORMULA(INVENTORY_ITEM_ID_1 IN NUMBER) RETURN CHAR;
45   FUNCTION BEFOREREPORT RETURN BOOLEAN;
46   FUNCTION CF_VEND_DTLSFORMULA(VENDOR_ID IN NUMBER
47                               ,VENDOR_SITE_ID IN NUMBER
48                               ,RECEIPT_ID IN VARCHAR2
49                               ,VEND_DTLS IN VARCHAR2) RETURN CHAR;
50   FUNCTION CF_RANGE1FORMULA(VENDOR_ID IN NUMBER
51                            ,VENDOR_SITE_ID IN NUMBER
52                            ,RECEIPT_ID IN VARCHAR2
53                            ,RANGE1 IN VARCHAR2) RETURN CHAR;
54   FUNCTION CF_DIVISION1FORMULA(VENDOR_ID IN NUMBER
55                               ,VENDOR_SITE_ID IN NUMBER
56                               ,RECEIPT_ID IN VARCHAR2
57                               ,DIVISION1 IN VARCHAR2) RETURN CHAR;
58   FUNCTION CP_PAGE_NO_P RETURN NUMBER;
59   FUNCTION CP_PAGE_P RETURN NUMBER;
60   V_LAST_PAGE VARCHAR2(1) := 'F';
61   LAST_PAGE NUMBER := 0;
62   VALIDATION_FLAG VARCHAR2(1) := 'N';
63   PREV_PAGE NUMBER := 0;
64 END JA_JAIN23C1_XMLP_PKG;
65 
66