1 PACKAGE JA_JAIN23D_XMLP_PKG AS
2 /* $Header: JAIN23DS.pls 120.1 2007/12/25 16:07:48 dwkrishn noship $ */
3 P_ORGANIZATION_ID NUMBER;
4
5 P_LOCATION_ID NUMBER;
6
7 P_TRN_FROM_DATE DATE;
8
9 CP_TRN_FROM_DATE VARCHAR2(20);
10
11 CP_TRN_TO_DATE VARCHAR2(20);
12
13 P_TRN_TO_DATE DATE;
14
15 P_INVENTORY_ITEM_ID NUMBER;
16
17 P_CONC_REQUEST_ID NUMBER;
18
19 CP_SUPPLIER_TYPE VARCHAR2(50);
20
21 CP_MANU_ADDRESS VARCHAR2(255);
22
23 CP_QTY_RECEIVED_FROM_MANU NUMBER;
24
25 CP_MANU_RATE_AMT_PER_UNIT VARCHAR2(100);
26
27 CP_TOT_AMT_PAID_TO_MANU NUMBER;
28
29 FUNCTION CF_COL9FORMULA(REGISTER_ID IN NUMBER
30 ,TRANSACTION_TYPE IN VARCHAR2
31 ,COL3 IN VARCHAR2
32 ,QUERY IN VARCHAR2) RETURN VARCHAR2;
33
34 FUNCTION CF_COL10FORMULA(REGISTER_ID IN NUMBER
35 ,TRANSACTION_TYPE IN VARCHAR2
36 ,COL3 IN VARCHAR2) RETURN VARCHAR2;
37
38 FUNCTION CF_SOB_NAMEFORMULA(ORGANIZATION_ID IN NUMBER) RETURN VARCHAR2;
39
40 FUNCTION CF_P_NAMEFORMULA RETURN VARCHAR2;
41
42 FUNCTION CF_P_LOCFORMULA RETURN VARCHAR2;
43
44 FUNCTION CF_P_ITEMFORMULA RETURN VARCHAR2;
45
46 FUNCTION BEFOREREPORT RETURN BOOLEAN;
47
48 FUNCTION CF_2FORMULA(TRANSACTION_TYPE IN VARCHAR2
49 ,REGISTER_ID IN NUMBER
50 ,RECEIPT_REMAINING_QTY IN NUMBER
51 ,QUERY IN VARCHAR2
52 ,COL3 IN VARCHAR2) RETURN CHAR;
53
54 FUNCTION CF_MATCHED_SHIPPED_QTYFORMULA(QUERY IN VARCHAR2
55 ,REGISTER_ID IN NUMBER
56 ,RECEIPT_REMAINING_QTY IN NUMBER
57 ,TRANSACTION_TYPE IN VARCHAR2) RETURN CHAR;
58
59 FUNCTION CF_MANU_NAMEFORMULA(REGISTER_ID IN NUMBER
60 ,CF_2 IN VARCHAR2
61 ,QTY IN NUMBER
62 ,EXCISE_DUTY_RATE IN NUMBER
63 ,COL6 IN NUMBER
64 ,COL7 IN NUMBER
65 ,COL2 IN VARCHAR2
66 ,MANUFACTURER_ADDRESS IN VARCHAR2
67 ,QTY_RECEIVED_FROM_MANUFACTURER IN NUMBER
68 ,MANUFACTURER_RATE_AMT_PER_UNIT IN VARCHAR2
69 ,TOT_AMT_PAID_TO_MANUFACTURER IN NUMBER
70 ,MANUFACTURER_NAME IN VARCHAR2) RETURN CHAR;
71
72 FUNCTION CF_ISSUE_CESS_AMTFORMULA(REGISTER_ID IN NUMBER) RETURN NUMBER;
73
74 FUNCTION CF_ISSUE_CESS_AMT_PER_UNITFORM(COL11 IN NUMBER
75 ,CF_ISSUE_CESS_AMT IN NUMBER) RETURN NUMBER;
76
77 FUNCTION CF_RECEIPT_CESS_AMTFORMULA(REGISTER_ID IN NUMBER) RETURN NUMBER;
78
79 FUNCTION CF_RECEIPT_CESS_AMT_PER_UNIT(QTY IN NUMBER
80 ,CF_RECEIPT_CESS_AMT IN NUMBER) RETURN NUMBER;
81
82 FUNCTION AFTERREPORT RETURN BOOLEAN;
83
84 FUNCTION CF_ISSUE_SH_CESS_AMTFORMULA(REGISTER_ID IN NUMBER) RETURN NUMBER;
85
86 FUNCTION CF_ISSUE_SH_CESS_AMT_PER_UNITF(COL11 IN NUMBER
87 ,CF_ISSUE_SH_CESS_AMT IN NUMBER) RETURN NUMBER;
88
89 FUNCTION CF_RECEIPT_SH_CESS_AMTFORMULA(REGISTER_ID IN NUMBER) RETURN NUMBER;
90
91 FUNCTION CF_RECEIPT_SH_CESS_AMT_PER_UNT(QTY IN NUMBER
92 ,CF_RECEIPT_SH_CESS_AMT IN NUMBER) RETURN NUMBER;
93
94 FUNCTION CP_SUPPLIER_TYPE_P RETURN VARCHAR2;
95
96 FUNCTION CP_MANU_ADDRESS_P RETURN VARCHAR2;
97
98 FUNCTION CP_QTY_RECEIVED_FROM_MANU_P RETURN NUMBER;
99
100 FUNCTION CP_MANU_RATE_AMT_PER_UNIT_P RETURN VARCHAR2;
101
102 FUNCTION CP_TOT_AMT_PAID_TO_MANU_P RETURN NUMBER;
103
104 V_LAST_PAGE VARCHAR2(1) := 'F';
105
106 LAST_PAGE NUMBER := 0;
107
108 VALIDATION_FLAG VARCHAR2(1) := 'N';
109
110 PREV_PAGE NUMBER := 0;
111
112 END JA_JAIN23D_XMLP_PKG;
113
114
115