1 PACKAGE JA_JAINVAR_XMLP_PKG AS
2 /* $Header: JAINVARS.pls 120.1 2007/12/25 16:33:13 dwkrishn noship $ */
3 PF_TRX_NUMBER VARCHAR2(40);
4
5 P_CONC_REQUEST_ID NUMBER;
6
7 FUNCTION CF_1FORMULA(CUSTOMER_TRX_ID IN NUMBER
8 ,CUSTOMER_TRX_LINE_ID IN NUMBER
9 ,EXCISE_INVOICE_NO IN VARCHAR2
10 ,CF_4 IN NUMBER
11 ,AUTO_INVOICE_FLAG IN VARCHAR2
12 ,INVENTORY_ITEM_ID IN NUMBER
13 ,PAYMENT_REGISTER IN VARCHAR2) RETURN VARCHAR2;
14
15 FUNCTION CF_2FORMULA RETURN VARCHAR2;
16
17 FUNCTION CF_3FORMULA RETURN VARCHAR2;
18
19 FUNCTION CF_4FORMULA(CUSTOMER_TRX_LINE_ID IN NUMBER) RETURN NUMBER;
20
21 FUNCTION CF_5FORMULA(EXCISE_INVOICE_NO IN VARCHAR2
22 ,INVENTORY_ITEM_ID IN NUMBER
23 ,PAYMENT_REGISTER IN VARCHAR2) RETURN NUMBER;
24
25 FUNCTION CF_6FORMULA(EXCISE_INVOICE_NO IN VARCHAR2
26 ,INVENTORY_ITEM_ID IN NUMBER
27 ,PAYMENT_REGISTER IN VARCHAR2) RETURN NUMBER;
28
29 FUNCTION CF_7FORMULA(CUSTOMER_TRX_LINE_ID IN NUMBER) RETURN NUMBER;
30
31 FUNCTION CF_8FORMULA(CUSTOMER_TRX_LINE_ID IN NUMBER) RETURN NUMBER;
32
33 FUNCTION CF_9FORMULA(CUSTOMER_TRX_LINE_ID IN NUMBER) RETURN NUMBER;
34
35 FUNCTION CF_10FORMULA(CUSTOMER_TRX_LINE_ID IN NUMBER) RETURN NUMBER;
36
37 FUNCTION CF_11FORMULA(CUSTOMER_TRX_LINE_ID IN NUMBER) RETURN NUMBER;
38
39 FUNCTION CF_12FORMULA(CUSTOMER_TRX_LINE_ID IN NUMBER) RETURN NUMBER;
40
41 FUNCTION CF_13FORMULA(CUSTOMER_TRX_LINE_ID IN NUMBER) RETURN NUMBER;
42
43 FUNCTION CF_14FORMULA(CUSTOMER_TRX_LINE_ID IN NUMBER) RETURN NUMBER;
44
45 FUNCTION CF_15FORMULA(CUSTOMER_TRX_LINE_ID IN NUMBER) RETURN NUMBER;
46
47 FUNCTION CF_16FORMULA(CUSTOMER_TRX_LINE_ID IN NUMBER) RETURN NUMBER;
48
49 FUNCTION CF_17FORMULA(EXCISE_INVOICE_NO IN VARCHAR2
50 ,CF_4 IN NUMBER
51 ,CUSTOMER_TRX_ID IN NUMBER
52 ,CUSTOMER_TRX_LINE_ID IN NUMBER
53 ,AUTO_INVOICE_FLAG IN VARCHAR2
54 ,INVENTORY_ITEM_ID IN NUMBER
55 ,PAYMENT_REGISTER IN VARCHAR2) RETURN NUMBER;
56
57 FUNCTION CF_18FORMULA(CUSTOMER_TRX_ID1 IN NUMBER) RETURN VARCHAR2;
58
59 FUNCTION CF_19FORMULA(CUSTOMER_TRX_ID1 IN NUMBER) RETURN VARCHAR2;
60
61 FUNCTION CF_20FORMULA(CUSTOMER_TRX_ID IN NUMBER
62 ,CUSTOMER_TRX_LINE_ID IN NUMBER
63 ,AUTO_INVOICE_FLAG IN VARCHAR2
64 ,UNIT_SELLING_PRICE IN NUMBER) RETURN NUMBER;
65
66 FUNCTION CF_21FORMULA(AUTO_INVOICE_FLAG IN VARCHAR2
67 ,QUANTITY IN NUMBER
68 ,CF_20 IN NUMBER
69 ,LINE_AMOUNT IN NUMBER) RETURN NUMBER;
70
71 FUNCTION CF_22FORMULA(CUSTOMER_TRX_ID1 IN NUMBER
72 ,CF_20 IN NUMBER) RETURN NUMBER;
73
74 FUNCTION CF_23FORMULA(CUSTOMER_TRX_ID1 IN NUMBER
75 ,CF_21 IN NUMBER) RETURN NUMBER;
76
77 FUNCTION CONV_ASSESSABLEFORMULA(CUSTOMER_TRX_ID IN NUMBER
78 ,CUSTOMER_TRX_LINE_ID IN NUMBER
79 ,CUSTOMER_TRX_ID1 IN NUMBER
80 ,AUTO_INVOICE_FLAG IN VARCHAR2
81 ,ASSESSABLE_VALUE IN NUMBER) RETURN NUMBER;
82
83 FUNCTION TOT_ASSESSABLE_VALUEFORMULA(CONV_ASSESSABLE IN NUMBER
84 ,QUANTITY IN NUMBER) RETURN NUMBER;
85
86 FUNCTION BASIC_RATEFORMULA(CUSTOMER_TRX_LINE_ID IN NUMBER) RETURN NUMBER;
87
88 FUNCTION SPECIAL_RATEFORMULA(CUSTOMER_TRX_LINE_ID IN NUMBER) RETURN NUMBER;
89
90 FUNCTION ADDL_RATEFORMULA(CUSTOMER_TRX_LINE_ID IN NUMBER) RETURN NUMBER;
91
92 FUNCTION ITEM_CODEFORMULA(ITEM_CODE_ID IN NUMBER
93 ,ORGANIZATION_ID IN NUMBER) RETURN VARCHAR2;
94
95 FUNCTION ITEM_CODE_IDFORMULA(CUSTOMER_TRX_ID IN NUMBER
96 ,CUSTOMER_TRX_LINE_ID IN NUMBER
97 ,AUTO_INVOICE_FLAG IN VARCHAR2
98 ,INVENTORY_ITEM_ID IN NUMBER) RETURN NUMBER;
99
100 FUNCTION CF_24FORMULA(ORGANIZATION_ID IN NUMBER
101 ,LOCATION_ID IN NUMBER
102 ,CUSTOMER_TRX_LINE_ID IN NUMBER
103 ,INVENTORY_ITEM_ID IN NUMBER
104 ,EXCISE_EXEMPT_TYPE IN VARCHAR2
105 ,QUANTITY IN NUMBER
106 ,UNIT_SELLING_PRICE IN NUMBER) RETURN NUMBER;
107
108 FUNCTION BEFOREREPORT RETURN BOOLEAN;
109
110 FUNCTION AFTERREPORT RETURN BOOLEAN;
111
112 FUNCTION F_10FORMATTRIGGER(CUSTOMER_TRX_ID1 IN NUMBER) RETURN NUMBER;
113
114 END JA_JAINVAR_XMLP_PKG;
115
116