PACKAGE: APPS.JA_JAINARE1_XMLP_PKG

Source

1 PACKAGE JA_JAINARE1_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: JAINARE1S.pls 120.1 2007/12/25 16:12:59 dwkrishn noship $ */
3   P_CUSTOMER_TRX_ID NUMBER;
4 
5   P_BOND_DATE DATE;
6 
7   P_BOND_NO VARCHAR2(25);
8 
9   P_EX_AUTH_ADDRESS VARCHAR2(100);
10 
11   P_EX_POSTAL_ADDRESS VARCHAR2(100);
12 
13   P_LOCATION_ID NUMBER;
14 
15   P_ORGANIZATION_ID NUMBER;
16 
17   P_ORG_ID NUMBER;
18 
19   P_SUP_EX_ADDRESS VARCHAR2(100);
20 
21   P_CUSTOMER_TRX_ID1 NUMBER;
22 
23   P_CONC_REQUEST_ID NUMBER;
24 
25   CP_CLOSING_BAL NUMBER;
26 
27   CP_DEBIT_AMOUNT NUMBER;
28 
29   CP_OPENING_BAL NUMBER;
30 
31   CP_NULL VARCHAR2(1);
32 
33   CP_EXCISE_CESS_AMOUNT NUMBER;
34 
35   CP_EXCISE_SH_CESS_AMOUNT NUMBER;
36 
37   FUNCTION CF_CITYFORMULA RETURN CHAR;
38 
39   FUNCTION CF_LEGAL_ENTITYFORMULA RETURN CHAR;
40 
41   FUNCTION CF_DESTINATION_COUNTRYFORMULA(SHIP_TO_SITE_USE_ID IN NUMBER) RETURN CHAR;
42 
43   FUNCTION CP_NULLFORMULA RETURN CHAR;
44 
45   FUNCTION CF_QTY_OF_GOODSFORMULA(QUANTITY IN NUMBER
46                                  ,REQUESTED_QUANTITY_UOM IN VARCHAR2) RETURN CHAR;
47 
48   FUNCTION CF_TAX_RATEFORMULA(DELIVERY_ID IN NUMBER
49                              ,INVENTORY_ITEM_ID IN NUMBER) RETURN NUMBER;
50 
51   FUNCTION CF_VALUEFORMULA(DELIVERY_ID IN NUMBER
52                           ,ORDER_HEADER_ID IN NUMBER
53                           ,ORDER_LINE_ID IN NUMBER
54                           ,QUANTITY IN NUMBER
55                           ,CF_SET_OF_BOOKS_ID IN NUMBER
56                           ,CF_FUN_CURR IN VARCHAR2) RETURN CHAR;
57 
58   FUNCTION CF_SET_OF_BOOKS_IDFORMULA RETURN NUMBER;
59 
60   FUNCTION CF_FUN_CURRFORMULA(CF_SET_OF_BOOKS_ID IN NUMBER) RETURN CHAR;
61 
62   FUNCTION CF_PACKINGFORMULA RETURN CHAR;
63 
64   FUNCTION CF_FUNC_TAX_AMOUNTFORMULA(DELIVERY_ID IN NUMBER
65                                     ,INVENTORY_ITEM_ID IN NUMBER) RETURN NUMBER;
66 
67   FUNCTION BEFOREREPORT RETURN BOOLEAN;
68 
69   FUNCTION AFTERREPORT RETURN BOOLEAN;
70 
71   FUNCTION CF_BALANCESFORMULA(ORDER_HEADER_ID IN NUMBER
72                              ,REGISTER_ID IN NUMBER
73                              ,ORDER_LINE_ID IN NUMBER
74                              ,CUSTOMER_TRX_ID IN NUMBER
75                              ,DELIVERY_ID IN NUMBER
76                              ,TRX_NUMBER IN VARCHAR2) RETURN NUMBER;
77 
78   FUNCTION CP_CLOSING_BAL_P RETURN NUMBER;
79 
80   FUNCTION CP_DEBIT_AMOUNT_P RETURN NUMBER;
81 
82   FUNCTION CP_OPENING_BAL_P RETURN NUMBER;
83 
84   FUNCTION CP_NULL_P RETURN VARCHAR2;
85 
86   FUNCTION CP_EXCISE_CESS_AMOUNT_P RETURN NUMBER;
87 
88   FUNCTION CP_EXCISE_SH_CESS_AMOUNT_P RETURN NUMBER;
89 
90 END JA_JAINARE1_XMLP_PKG;
91 
92