PACKAGE: APPS.JA_JAINRECI_XMLP_PKG

Source

1 PACKAGE JA_JAINRECI_XMLP_PKG AS
2 /* $Header: JAINRECIS.pls 120.1 2007/12/25 16:27:22 dwkrishn noship $ */
3   P_RMA_REFERENCE VARCHAR2(30);
4 
5   P_CONC_REQUEST_ID NUMBER := 0;
6 
7   P_TRANSACTION_ID VARCHAR2(40);
8 
9   CP_ROUND_BASIC_ED NUMBER;
10 
11   CP_ROUND_ADDITIONAL_ED NUMBER;
12 
13   CP_ROUND_ADDITIONAL_CVD NUMBER;
14 
15   CP_ROUND_OTHER_ED NUMBER;
16 
17   CP_ROUND_CESS NUMBER;
18 
19   CP_VAT_TAX NUMBER;
20 
21   CP_SH_ROUND_CESS NUMBER;
22 
23   CP_VAT_INVOICE_NUMBER NUMBER;
24 
25   CP_VAT_INVOICE_DATE DATE;
26 
27   FUNCTION CF_TRANSACTIONAL_CURRFORMULA(PARENT_TRANSACTION_ID IN NUMBER) RETURN VARCHAR2;
28 
29   FUNCTION CF_2FORMULA(PARENT_TRANSACTION_ID IN NUMBER
30                       ,SHIPMENT_LINE_ID IN NUMBER
31                       ,CF_CURRENCY_CODE IN VARCHAR2
32                       ,PRIMARY_QUANTITY IN NUMBER) RETURN NUMBER;
33 
34   FUNCTION CF_3FORMULA(LOCATION_ID IN NUMBER) RETURN VARCHAR2;
35 
36   FUNCTION CF_4FORMULA(LOCATION_ID IN NUMBER) RETURN VARCHAR2;
37 
38   FUNCTION CF_5FORMULA(LOCATION_ID IN NUMBER) RETURN VARCHAR2;
39 
40   FUNCTION CF_6FORMULA(LOCATION_ID IN NUMBER) RETURN VARCHAR2;
41 
42   FUNCTION CF_7FORMULA(LOCATION_ID IN NUMBER) RETURN VARCHAR2;
43 
44   FUNCTION CF_8FORMULA(ORGANIZATION_ID1 IN NUMBER
45                       ,INVENTORY_ITEM_ID IN NUMBER) RETURN VARCHAR2;
46 
47   FUNCTION CF_CURRENCY_CODEFORMULA(ORGANIZATION_ID1 IN NUMBER) RETURN CHAR;
48 
49   FUNCTION CF_ORGANIZATION_NAMEFORMULA(ORGANIZATION_ID1 IN NUMBER) RETURN CHAR;
50 
51   FUNCTION BEFOREREPORT RETURN BOOLEAN;
52 
53   FUNCTION CF_CESS_AMOUNTFORMULA(TRANSACTION_ID IN NUMBER
54                                 ,ORGANIZATION_ID1 IN NUMBER
55                                 ,LOCATION_ID IN NUMBER
56                                 ,REGISTER_TYPE IN VARCHAR2
57                                 ,DR_BASIC_ED IN NUMBER
58                                 ,DR_ADDITIONAL_ED IN NUMBER
59                                 ,DR_OTHER_ED IN NUMBER) RETURN NUMBER;
60 
61   FUNCTION CF_ROUNDING_AMTSFORMULA(ROUNDING_ID IN NUMBER
62                                   ,REGISTER_TYPE IN VARCHAR2
63                                   ,DR_BASIC_ED IN NUMBER
64                                   ,DR_ADDITIONAL_ED IN NUMBER
65                                   ,DR_OTHER_ED IN NUMBER) RETURN NUMBER;
66 
67   FUNCTION CF_BASIC_EDFORMULA(DR_BASIC_ED IN NUMBER) RETURN NUMBER;
68 
69   FUNCTION CF_ADDITIONAL_EDFORMULA(DR_ADDITIONAL_ED IN NUMBER) RETURN NUMBER;
70 
71   FUNCTION CF_OTHER_EDFORMULA(DR_OTHER_ED IN NUMBER) RETURN NUMBER;
72 
73   FUNCTION AFTERREPORT RETURN BOOLEAN;
74 
75   FUNCTION CF_ADDITIONAL_CVDFORMULA(DR_ADDITIONAL_CVD IN NUMBER) RETURN NUMBER;
76 
77   FUNCTION CF_CALC_VAT_INVNUM_DATEFORMULA(TRANSACTION_ID IN NUMBER) RETURN NUMBER;
78 
79   FUNCTION CF_SH_CESS_AMOUNTFORMULA(TRANSACTION_ID IN NUMBER
80                                    ,ORGANIZATION_ID1 IN NUMBER
81                                    ,LOCATION_ID IN NUMBER
82                                    ,REGISTER_TYPE IN VARCHAR2
83                                    ,DR_BASIC_ED IN NUMBER
84                                    ,DR_ADDITIONAL_ED IN NUMBER
85                                    ,DR_OTHER_ED IN NUMBER) RETURN NUMBER;
86 
87   FUNCTION CP_ROUND_BASIC_ED_P RETURN NUMBER;
88 
89   FUNCTION CP_ROUND_ADDITIONAL_ED_P RETURN NUMBER;
90 
91   FUNCTION CP_ROUND_ADDITIONAL_CVD_P RETURN NUMBER;
92 
93   FUNCTION CP_ROUND_OTHER_ED_P RETURN NUMBER;
94 
95   FUNCTION CP_ROUND_CESS_P RETURN NUMBER;
96 
97   FUNCTION CP_VAT_TAX_P RETURN NUMBER;
98 
99   FUNCTION CP_SH_ROUND_CESS_P RETURN NUMBER;
100 
101   FUNCTION CP_VAT_INVOICE_NUMBER_P RETURN NUMBER;
102 
103   FUNCTION CP_VAT_INVOICE_DATE_P RETURN DATE;
104 
105 END JA_JAINRECI_XMLP_PKG;
106 
107 
108