PACKAGE: APPS.BOM_CSTGMSBK_XMLP_PKG

Source

1 PACKAGE BOM_CSTGMSBK_XMLP_PKG AS
2 /* $Header: CSTGMSBKS.pls 120.0 2007/12/24 09:49:08 dwkrishn noship $ */
3   P_DETAIL VARCHAR2(1);
4 
5   P_DATE_FROM VARCHAR2(25);
6 
7   P_DATE_TO VARCHAR2(25);
8 
9   P_ORG_ID NUMBER;
10 
11   P_ITEM_CODE_FROM VARCHAR2(2400);
12 
13   P_ITEM_CODE_TO VARCHAR2(2400);
14 
15   P_QUANTITY_PRECISION NUMBER;
16 
17   P_CONC_REQUEST_ID NUMBER := 0;
18 
19   P_SYSTEM_DATE VARCHAR2(50);
20 
21   P_USERID VARCHAR2(32767);
22 
23   P_DATE_FROM_FORMATTING VARCHAR2(25);
24 
25   P_DATE_TO_FORMATTING VARCHAR2(25);
26 
27   P_CATEGORY_SET_ID NUMBER;
28 
29   P_CATEGORY_FROM VARCHAR2(240);
30 
31   P_CATEGORY_TO VARCHAR2(240);
32 
33   P_SUBINV_FROM VARCHAR2(10);
34 
35   P_ABC_CLASS_ID NUMBER;
36 
37   P_INCLUDE_ITEM_COST VARCHAR2(1);
38 
39   P_ABC_GROUP_ID NUMBER;
40 
41   PTXT_TOTAL_RECEIPT VARCHAR2(17);
42 
43   PTXT_TOTAL_ISSUE VARCHAR2(17);
44 
45   PTXT_RECEIPT VARCHAR2(10);
46 
47   PTXT_ISSUE VARCHAR2(10);
48 
49   P_SUBINV_TO VARCHAR2(10);
50 
51   CP_ORGANIZATION VARCHAR2(240);
52 
53   CP_REQUEST_TIME VARCHAR2(30);
54 
55   CP_RESPONSIBILITY VARCHAR2(100);
56 
57   CP_APPLICATION VARCHAR2(240);
58 
59   CP_ABC_CLASS_NAME VARCHAR2(40);
60 
61   CP_PRECISION_VAL NUMBER;
62 
63   CP_REQUESTED_BY VARCHAR2(100);
64 
65   CP_INCLUDE_COST VARCHAR2(80);
66 
67   CP_DETAIL VARCHAR2(80);
68 
69   CP_TITLE VARCHAR2(40);
70 
71   CP_COUNT NUMBER;
72 
73   CP_ABC_GROUP_NAME VARCHAR2(40);
74 
75   CP_CATEGORY_SET_NAME VARCHAR2(30);
76 
77   CP_CURRENCY_CODE VARCHAR2(3);
78 
79   H_RPT_DATE_FROM DATE;
80 
81   H_RPT_DATE_TO DATE;
82 
83   H_MSG VARCHAR2(255);
84 
85  /* PROCEDURE FORMAT_QUANTITY(P_PRECISION IN NUMBER);*/
86 
87   FUNCTION BEFOREREPORT RETURN BOOLEAN;
88 
89   FUNCTION AFTERREPORT RETURN BOOLEAN;
90 
91   FUNCTION BEFOREPFORM RETURN BOOLEAN;
92 
93   FUNCTION AFTERPFORM RETURN BOOLEAN;
94 
95   FUNCTION CF_TYPEFORMULA(TXN_QTY IN NUMBER) RETURN CHAR;
96 
97   FUNCTION CF_DETAIL_LEVELFORMULA RETURN CHAR;
98 
99   FUNCTION P_DATE_FROM_FORMATTINGVALIDTRI RETURN BOOLEAN;
100 
101   FUNCTION CF_TITLEFORMULA RETURN CHAR;
102 
103   FUNCTION CF_COUNT_ROWSFORMULA RETURN NUMBER;
104 
105   FUNCTION P_DATE_FROMVALIDTRIGGER RETURN BOOLEAN;
106 
107   FUNCTION CF_TXN_GROUP_TYPEFORMULA(TXN_TYPE_QTY IN NUMBER) RETURN CHAR;
108 
109   FUNCTION CF_FINAL_QUANTITYFORMULA(CS_FINAL_QUANTITY IN NUMBER
110                                    ,CS_B_QTY IN VARCHAR2) RETURN NUMBER;
111 
112   FUNCTION CP_ORGANIZATION_P RETURN VARCHAR2;
113 
114   FUNCTION CP_REQUEST_TIME_P RETURN VARCHAR2;
115 
116   FUNCTION CP_RESPONSIBILITY_P RETURN VARCHAR2;
117 
118   FUNCTION CP_APPLICATION_P RETURN VARCHAR2;
119 
120   FUNCTION CP_ABC_CLASS_NAME_P RETURN VARCHAR2;
121 
122   FUNCTION CP_PRECISION_VAL_P RETURN NUMBER;
123 
124   FUNCTION CP_REQUESTED_BY_P RETURN VARCHAR2;
125 
126   FUNCTION CP_INCLUDE_COST_P RETURN VARCHAR2;
127 
128   FUNCTION CP_DETAIL_P RETURN VARCHAR2;
129 
130   FUNCTION CP_TITLE_P RETURN VARCHAR2;
131 
132   FUNCTION CP_COUNT_P RETURN NUMBER;
133 
134   FUNCTION CP_ABC_GROUP_NAME_P RETURN VARCHAR2;
135 
136   FUNCTION CP_CATEGORY_SET_NAME_P RETURN VARCHAR2;
137 
138   FUNCTION CP_CURRENCY_CODE_P RETURN VARCHAR2;
139 
140   FUNCTION H_RPT_DATE_FROM_P RETURN DATE;
141 
142   FUNCTION H_RPT_DATE_TO_P RETURN DATE;
143 
144   FUNCTION H_MSG_P RETURN VARCHAR2;
145 
146 END BOM_CSTGMSBK_XMLP_PKG;
147