1 PACKAGE JA_JAINRG1_XMLP_PKG AS
2 /* $Header: JAINRG1S.pls 120.1 2007/12/25 16:27:52 dwkrishn noship $ */
3 P_ORGANIZATION_ID NUMBER;
4 P_LOCATION_ID NUMBER;
5 P_TRN_FROM_DATE DATE;
6 P_OPEN_BAL NUMBER;
7 P_INVENTORY_ITEM_ID NUMBER;
8 P_TRN_TO_DATE DATE;
9 P_FIRST_REC VARCHAR2(1) := 'T';
10 P_PREV_CLOSE_BAL NUMBER := 0;
11 P_OPEN NUMBER;
12 P_FISCAL_YEAR DATE;
13 P_MONTH VARCHAR2(3);
14 P_START_PAGE_NO NUMBER;
15 P_QUERY_CONCAT VARCHAR2(1000);
16 P_CONC_REQUEST_ID NUMBER;
17 P_SHOW_ALL_ITEMS VARCHAR2(1) := 'N';
18 CP_CESS_RATE NUMBER;
19 CP_SH_CESS_RATE NUMBER;
20 CP_1 NUMBER;
21 FUNCTION AFTERPFORM RETURN BOOLEAN;
22 FUNCTION CF_OPEN_BALFORMULA RETURN NUMBER;
23 FUNCTION CF_TOT_CR_BALFORMULA(TRANSACTION_TYPE IN VARCHAR2
24 ,CF_OPENBAL_PACKED IN NUMBER
25 ,MANUFACTURED_PACKED_QTY IN NUMBER) RETURN NUMBER;
26 FUNCTION CF_PREV_BALFORMULA(CF_TOT_CR_BAL_PACKED IN NUMBER
27 ,CF_TOT_CR_BAL_LOOSE IN NUMBER
28 ,HOMEQTY IN NUMBER
29 ,EXPTQTY IN NUMBER
30 ,OTHERFACTQTY IN NUMBER
31 ,OTHERPURQTY IN NUMBER) RETURN NUMBER;
32 FUNCTION CF_1FORMULA(FIN_YEAR_1 IN NUMBER
33 ,INVENTORY_ITEM_ID_1 IN NUMBER
34 ,SLNO_1 IN NUMBER
35 ,QUERY_NO IN VARCHAR2
36 ,BALANCE_PACKED IN NUMBER) RETURN NUMBER;
37 FUNCTION G_2GROUPFILTER RETURN BOOLEAN;
38 FUNCTION CF_2FORMULA(MANUFACTURED_QTY IN NUMBER
39 ,HOMEQTY IN NUMBER
40 ,EXPTQTY2 IN NUMBER
41 ,EXPTQTY IN NUMBER
42 ,OTHERFACTQTY IN NUMBER
43 ,OTHERPURQTY IN NUMBER) RETURN NUMBER;
44 FUNCTION CF_OPENSECONDFORMULA(CS_CALC IN NUMBER) RETURN NUMBER;
45 FUNCTION CF_1FORMULA0109(INVENTORY_ITEM_ID IN NUMBER
46 ,SLNO IN NUMBER) RETURN VARCHAR2;
47 FUNCTION AFTERREPORT RETURN BOOLEAN;
48 FUNCTION CF_OPENBAL_PACKEDFORMULA(FIN_YEAR_1 IN NUMBER
49 ,INVENTORY_ITEM_ID_1 IN NUMBER
50 ,SLNO_1 IN NUMBER
51 ,QUERY_NO IN VARCHAR2
52 ,BALANCE_LOOSE IN NUMBER) RETURN NUMBER;
53 FUNCTION CF_1FORMULA0035(TRANSACTION_TYPE IN VARCHAR2
54 ,CF_OPENBAL_LOOSE IN NUMBER
55 ,MANUFACTURED_LOOSE_QTY IN NUMBER) RETURN NUMBER;
56 FUNCTION BEFOREREPORT RETURN BOOLEAN;
57 FUNCTION P_SHOW_ALL_ITEMSVALIDTRIGGER RETURN BOOLEAN;
58 FUNCTION CF_REMARKSFORMULA(REGISTER_ID_PART_II IN NUMBER
59 ,PAYMENT_REGISTER IN VARCHAR2
60 ,REMARKS IN VARCHAR2) RETURN CHAR;
61 FUNCTION CF_CESS_AMTFORMULA(PAYMENT_REGISTER IN VARCHAR2
62 ,REGISTER_ID_PART_II IN NUMBER
63 ,REF_DOC_NO IN VARCHAR2
64 ,SOURCE IN VARCHAR2
65 ,CESS_AMT IN NUMBER
66 ,TRANSACTION_TYPE IN VARCHAR2) RETURN NUMBER;
67 FUNCTION CF_SH_CESS_AMTFORMULA(PAYMENT_REGISTER IN VARCHAR2
68 ,REGISTER_ID_PART_II IN NUMBER
69 ,REGISTER_ID_1 IN NUMBER
70 ,REF_DOC_NO IN VARCHAR2
71 ,SOURCE IN VARCHAR2
72 ,SH_CESS_AMT IN NUMBER
73 ,TRANSACTION_TYPE IN VARCHAR2) RETURN NUMBER;
74 FUNCTION CF_EAMOUNTFORMULA(TRANSACTION_TYPE IN VARCHAR2
75 ,EAMOUNT IN NUMBER) RETURN NUMBER;
76 FUNCTION CP_CESS_RATE_P RETURN NUMBER;
77 FUNCTION CP_SH_CESS_RATE_P RETURN NUMBER;
78 FUNCTION CP_1_P RETURN NUMBER;
79 LAST_PAGEVALUE VARCHAR(1) := 'T';
80 LAST_PAGE NUMBER := 0;
81 VALIDATION_FLAG VARCHAR2(1) := 'N';
82 PREV_PAGE NUMBER := 0;
83 END JA_JAINRG1_XMLP_PKG;
84
85