PACKAGE: APPS.GMI_GMILTGEN_XMLP_PKG

Source

1 PACKAGE GMI_GMILTGEN_XMLP_PKG AS
2 /* $Header: GMILTGENS.pls 120.0 2007/12/21 11:43:34 krreddy noship $ */
3   P_ITEM_ID NUMBER := 734;
4 
5   P_LOT_ID NUMBER := 617;
6 
7   P_QC_FLG VARCHAR2(32767);
8 
9   P_EVENT_FLG VARCHAR2(32767);
10 
11   P_TRACE_ID NUMBER;
12 
13   P_REP_TITLE VARCHAR2(40);
14 
15   P_SOURCE_FLG NUMBER;
16 
17   P_LOCT_FLG VARCHAR2(40);
18 
19   P_VIEW_BY NUMBER;
20 
21   P_LOT_COMP_TITLE VARCHAR2(30);
22 
23   P_DELIMIT VARCHAR2(1) := '.';
24 
25   P_ITEM_NO VARCHAR2(32);
26 
27   P_LOT_NO VARCHAR2(32);
28 
29   P_SUBLOT_NO VARCHAR2(32);
30 
31   P_CONC_REQUEST_ID NUMBER;
32 
33   ITEM_DESC VARCHAR2(70);
34 
35   LOT_NO VARCHAR2(32);
36 
37   SUBLOT_NO VARCHAR2(32);
38 
39   INV_TYPE VARCHAR2(4);
40 
41   SHELF_LIFE NUMBER;
42 
43   INV_CLASS VARCHAR2(32767);
44 
45   GRADE VARCHAR2(20);
46 
47   RETEST_INTERVAL NUMBER;
48 
49   LOT_CREATION_TYPE VARCHAR2(4);
50 
51   LOT_CREATION_TYPE_DESC VARCHAR2(40);
52 
53   BEGINING_QTY NUMBER;
54 
55   CREATION_DATE DATE;
56 
57   EXPIRE_DATE DATE;
58 
59   RETEST_DATE DATE;
60 
61   PLANT_CODE VARCHAR2(4);
62 
63   BATCH_NO VARCHAR2(32);
64 
65   VEND_NO VARCHAR2(46);
66 
67   VEND_NAME VARCHAR2(80);
68 
69   TRANS_UM VARCHAR2(4);
70 
71   VEND_LOT_NO VARCHAR2(32);
72 
73   PO_ORGN_CODE VARCHAR2(4);
74 
75   PO_NO VARCHAR2(32);
76 
77   RECV_ORGN_CODE VARCHAR2(4);
78 
79   RECV_NO VARCHAR2(32);
80 
81   JRNL_ORGN_CODE VARCHAR2(4);
82 
83   JOURNAL_NO VARCHAR2(32);
84 
85   MIN_SPEC NUMBER;
86 
87   MAX_SPEC NUMBER;
88 
89   RESULT VARCHAR2(20);
90 
91   ACCEPT_FLG VARCHAR2(4);
92 
93   DISP_ORGN_CODE VARCHAR2(60);
94 
95   I_ITEM_DESC VARCHAR2(70);
96 
97   I_LOT_NO VARCHAR2(32);
98 
99   I_SUBLOT_NO VARCHAR2(32);
100 
101   IND_KEY VARCHAR2(80);
102 
103   UOM2 VARCHAR2(4);
104 
105   FUNCTION AFTERPFORM RETURN BOOLEAN;
106 
107   FUNCTION AFTERREPORT RETURN BOOLEAN;
108 
109   FUNCTION ITEM_NOFORMULA(ITEM_ID IN NUMBER
110                          ,LOT_ID IN NUMBER) RETURN CHAR;
111 
112   FUNCTION CF_1FORMULA(TRANS_DATE IN DATE) RETURN DATE;
113 
114   FUNCTION I_ITEM_NOFORMULA(ITEM_ID2 IN NUMBER
115                            ,LOT_ID3 IN NUMBER
116                            ,CIR_FLG1 IN VARCHAR2
117                            ,LEVEL_NO1 IN NUMBER) RETURN CHAR;
118 
119   FUNCTION DOC_NOFORMULA(DOC_ID IN NUMBER
120                         ,LINE_ID IN NUMBER
121                         ,ORGN_CODE IN VARCHAR2
122                         ,DOC_TYPE IN VARCHAR2) RETURN CHAR;
123 
124   FUNCTION QC_SPECFORMULA(QCASSY_TYP_ID IN NUMBER
125                          ,QC_SPEC_ID IN NUMBER
126                          ,TEXT_RESULT IN VARCHAR2
127                          ,NUM_RESULT IN NUMBER
128                          ,ACCEPT_ANYWAY IN VARCHAR2) RETURN CHAR;
129 
130   FUNCTION UOMFORMULA(ITEM_ID1 IN NUMBER) RETURN CHAR;
131 
132   FUNCTION IND_KEY2FORMULA(SUBLOT_NO2 IN VARCHAR2
133                           ,ITEM_NO2 IN VARCHAR2
134                           ,LOT_NO2 IN VARCHAR2) RETURN CHAR;
135 
136   PROCEDURE HEADER;
137 
138   FUNCTION ITEM_DESC_P RETURN VARCHAR2;
139 
140   FUNCTION LOT_NO_P RETURN VARCHAR2;
141 
142   FUNCTION SUBLOT_NO_P RETURN VARCHAR2;
143 
144   FUNCTION INV_TYPE_P RETURN VARCHAR2;
145 
146   FUNCTION SHELF_LIFE_P RETURN NUMBER;
147 
148   FUNCTION INV_CLASS_P RETURN VARCHAR2;
149 
150   FUNCTION GRADE_P RETURN VARCHAR2;
151 
152   FUNCTION RETEST_INTERVAL_P RETURN NUMBER;
153 
154   FUNCTION LOT_CREATION_TYPE_P RETURN VARCHAR2;
155 
156   FUNCTION LOT_CREATION_TYPE_DESC_P RETURN VARCHAR2;
157 
158   FUNCTION BEGINING_QTY_P RETURN NUMBER;
159 
160   FUNCTION CREATION_DATE_P RETURN DATE;
161 
162   FUNCTION EXPIRE_DATE_P RETURN DATE;
163 
164   FUNCTION RETEST_DATE_P RETURN DATE;
165 
166   FUNCTION PLANT_CODE_P RETURN VARCHAR2;
167 
168   FUNCTION BATCH_NO_P RETURN VARCHAR2;
169 
170   FUNCTION VEND_NO_P RETURN VARCHAR2;
171 
172   FUNCTION VEND_NAME_P RETURN VARCHAR2;
173 
174   FUNCTION TRANS_UM_P RETURN VARCHAR2;
175 
176   FUNCTION VEND_LOT_NO_P RETURN VARCHAR2;
177 
178   FUNCTION PO_ORGN_CODE_P RETURN VARCHAR2;
179 
180   FUNCTION PO_NO_P RETURN VARCHAR2;
181 
182   FUNCTION RECV_ORGN_CODE_P RETURN VARCHAR2;
183 
184   FUNCTION RECV_NO_P RETURN VARCHAR2;
185 
186   FUNCTION JRNL_ORGN_CODE_P RETURN VARCHAR2;
187 
188   FUNCTION JOURNAL_NO_P RETURN VARCHAR2;
189 
190   FUNCTION MIN_SPEC_P RETURN NUMBER;
191 
192   FUNCTION MAX_SPEC_P RETURN NUMBER;
193 
194   FUNCTION RESULT_P RETURN VARCHAR2;
195 
196   FUNCTION ACCEPT_FLG_P RETURN VARCHAR2;
197 
198   FUNCTION DISP_ORGN_CODE_P RETURN VARCHAR2;
199 
200   FUNCTION I_ITEM_DESC_P RETURN VARCHAR2;
201 
202   FUNCTION I_LOT_NO_P RETURN VARCHAR2;
203 
204   FUNCTION I_SUBLOT_NO_P RETURN VARCHAR2;
205 
206   FUNCTION IND_KEY_P RETURN VARCHAR2;
207 
208   FUNCTION UOM2_P RETURN VARCHAR2;
209 
210 function M_6FormatTrigger(item_id number, lot_id number) return varchar2;
211 function M_5FormatTrigger(item_id number, lot_id number) return varchar2;
212 END GMI_GMILTGEN_XMLP_PKG;
213