APPS.GME_GMEBCHYV_XMLP_PKG dependencies on GME_SCALE_DETAIL

Line 187: GME_SCALE_DETAIL

183: WHERE EXISTS (
184: SELECT
185: FORMULALINE_ID
186: FROM
187: GME_SCALE_DETAIL
188: WHERE FORMULALINE_ID = cf_plan_qty_itemumformula.FORMULALINE_ID );
189: CURSOR CUR_MATL_QTY IS
190: SELECT
191: QTY

Line 193: GME_SCALE_DETAIL

189: CURSOR CUR_MATL_QTY IS
190: SELECT
191: QTY
192: FROM
193: GME_SCALE_DETAIL
194: WHERE FORMULALINE_ID = cf_plan_qty_itemumformula.FORMULALINE_ID;
195: CURSOR CUR_PRIMARY_PROD IS
196: SELECT
197: INVENTORY_ITEM_ID

Line 231: GME_SCALE_DETAIL

227: CURSOR CUR_PLAN_QTY IS
228: SELECT
229: QTY
230: FROM
231: GME_SCALE_DETAIL
232: WHERE FORMULALINE_ID = cf_plan_qty_itemumformula.FORMULALINE_ID;
233: CURSOR CUR_SCRAP_FACTOR IS
234: SELECT
235: SCRAP_FACTOR

Line 360: INSERT INTO GME_SCALE_DETAIL(FORMULALINE_ID,LINE_TYPE,ITEM_ID,QTY,ITEM_UM,SCALE_TYPE,CONV_QTY)

356: ,X_SCALE_TAB
357: ,X_RETURN_STATUS);
358: IF X_RETURN_STATUS = 'S' THEN
359: FOR i IN 1 .. X_SCALE_TAB.COUNT LOOP
360: INSERT INTO GME_SCALE_DETAIL(FORMULALINE_ID,LINE_TYPE,ITEM_ID,QTY,ITEM_UM,SCALE_TYPE,CONV_QTY)
361: VALUES (X_SCALE_TAB(I).LINE_NO
362: , X_SCALE_TAB(I).LINE_TYPE
363: ,X_SCALE_TAB(I).INVENTORY_ITEM_ID
364: , X_SCALE_TAB(I).QTY

Line 424: DELETE FROM GME_SCALE_DETAIL;

420: CO_CODE VARCHAR2(4);
421: BEGIN
422: P_CONC_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
423: /*SRW.USER_EXIT('FND SRWINIT')*/NULL;
424: DELETE FROM GME_SCALE_DETAIL;
425: RETURN (TRUE);
426: RETURN NULL;
427: EXCEPTION
428: WHEN OTHERS THEN

Line 516: DELETE FROM GME_SCALE_DETAIL;

512:
513: FUNCTION CF_DELETE_TRANSFORMULA RETURN NUMBER IS
514: pragma autonomous_transaction;
515: BEGIN
516: DELETE FROM GME_SCALE_DETAIL;
517: commit;
518: RETURN (1);
519: END CF_DELETE_TRANSFORMULA;
520:

Line 523: DELETE FROM GME_SCALE_DETAIL;

519: END CF_DELETE_TRANSFORMULA;
520:
521: FUNCTION AFTERREPORT RETURN BOOLEAN IS
522: BEGIN
523: DELETE FROM GME_SCALE_DETAIL;
524: /*SRW.USER_EXIT('FND SRWEXIT')*/NULL;
525: RETURN (TRUE);
526: END AFTERREPORT;
527: