APPS.GME_GMEMUSBV_XMLP_PKG dependencies on GME_SCALE_DETAIL

Line 300: GME_SCALE_DETAIL

296: WHERE EXISTS (
297: SELECT
298: FORMULALINE_ID
299: FROM
300: GME_SCALE_DETAIL
301: WHERE FORMULALINE_ID = trans_qtyformula_005.FORMULALINE_ID );
302: CURSOR CUR_MATL_QTY IS
303: SELECT
304: QTY

Line 306: GME_SCALE_DETAIL

302: CURSOR CUR_MATL_QTY IS
303: SELECT
304: QTY
305: FROM
306: GME_SCALE_DETAIL
307: WHERE FORMULALINE_ID = trans_qtyformula_005.FORMULALINE_ID;
308: CURSOR CUR_PRIMARY_PROD IS
309: SELECT
310: INVENTORY_ITEM_ID

Line 344: GME_SCALE_DETAIL

340: CURSOR CUR_PLAN_QTY IS
341: SELECT
342: QTY
343: FROM
344: GME_SCALE_DETAIL
345: WHERE FORMULALINE_ID = trans_qtyformula_005.FORMULALINE_ID;
346: CURSOR CUR_SCRAP_FACTOR IS
347: SELECT
348: SCRAP_FACTOR

Line 382: GME_SCALE_DETAIL

378: CURSOR CUR_MTL_DETAILS IS
379: SELECT
380: *
381: FROM
382: GME_SCALE_DETAIL
383: WHERE LINE_TYPE in ( 1 , 2 );
384: CURSOR CUR_MTL_DTLS IS
385: SELECT
386: *

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

555: END IF;
556: IF X_RETURN_STATUS = 'S' THEN
557: FOR i IN 1 .. X_SCALE_TAB.COUNT LOOP
558:
559: INSERT INTO GME_SCALE_DETAIL ( FORMULALINE_ID,LINE_TYPE,ITEM_ID,QTY,ITEM_UM,SCALE_TYPE,CONV_QTY)
560: VALUES (X_SCALE_TAB(I).LINE_NO
561: ,X_SCALE_TAB(I).LINE_TYPE
562: ,X_SCALE_TAB(I).INVENTORY_ITEM_ID
563: ,X_SCALE_TAB(I).QTY

Line 602: DELETE FROM GME_SCALE_DETAIL;

598: CO_CODE VARCHAR2(4);
599: BEGIN
600: P_CONC_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
601: /*SRW.USER_EXIT('FND SRWINIT')*/NULL;
602: DELETE FROM GME_SCALE_DETAIL;
603: FND_MSG_PUB.INITIALIZE;
604: RETURN (TRUE);
605: RETURN NULL;
606: EXCEPTION

Line 643: DELETE FROM GME_SCALE_DETAIL;

639: END CF_TOTAL_VARIANCEFORMULA;
640:
641: FUNCTION AFTERREPORT RETURN BOOLEAN IS
642: BEGIN
643: DELETE FROM GME_SCALE_DETAIL;
644: /*SRW.USER_EXIT('FND SRWEXIT')*/NULL;
645: RETURN (TRUE);
646: END AFTERREPORT;
647:

Line 651: DELETE FROM GME_SCALE_DETAIL;

647:
648: FUNCTION CF_DELETE_TRANSFORMULA RETURN NUMBER IS
649: PRAGMA AUTONOMOUS_TRANSACTION;
650: BEGIN
651: DELETE FROM GME_SCALE_DETAIL;
652: commit;
653: RETURN (1);
654: END CF_DELETE_TRANSFORMULA;
655: