APPS.GMD_FORMULATION_SPECS_PKG dependencies on GMD_COMPOSITIONAL_REQS

Line 465: FROM GMD_COMPOSITIONAL_REQS

461: ) IS
462:
463: CURSOR C IS
464: SELECT ROWID
465: FROM GMD_COMPOSITIONAL_REQS
466: WHERE COMP_REQ_ID = X_COMP_REQ_ID;
467:
468: BEGIN
469: INSERT INTO GMD_COMPOSITIONAL_REQS (

Line 469: INSERT INTO GMD_COMPOSITIONAL_REQS (

465: FROM GMD_COMPOSITIONAL_REQS
466: WHERE COMP_REQ_ID = X_COMP_REQ_ID;
467:
468: BEGIN
469: INSERT INTO GMD_COMPOSITIONAL_REQS (
470: FORMULATION_SPEC_ID,
471: COMP_REQ_ID,
472: SPEC_ATTRIBUTE_ID,
473: ORDER_NO,

Line 530: FROM GMD_COMPOSITIONAL_REQS

526: MAX_PCT,
527: CATEGORY_SET_ID,
528: CATEGORY_ID,
529: PLANNED_PCT
530: FROM GMD_COMPOSITIONAL_REQS
531: WHERE COMP_REQ_ID = X_COMP_REQ_ID
532: FOR UPDATE OF COMP_REQ_ID NOWAIT;
533: RECINFO C%ROWTYPE;
534:

Line 581: UPDATE GMD_COMPOSITIONAL_REQS SET

577: ) IS
578:
579: BEGIN
580:
581: UPDATE GMD_COMPOSITIONAL_REQS SET
582: FORMULATION_SPEC_ID = X_FORMULATION_SPEC_ID ,
583: SPEC_ATTRIBUTE_ID = X_SPEC_ATTRIBUTE_ID ,
584: MIN_PCT = X_MIN_PCT ,
585: MAX_PCT = X_MAX_PCT ,

Line 605: DELETE FROM GMD_COMPOSITIONAL_REQS

601: X_COMP_REQ_ID IN NUMBER
602: ) IS
603: BEGIN
604:
605: DELETE FROM GMD_COMPOSITIONAL_REQS
606: WHERE COMP_REQ_ID = X_COMP_REQ_ID;
607:
608: IF (SQL%NOTFOUND) THEN
609: RAISE NO_DATA_FOUND;