APPS.GMD_FORMULATION_SPECS_PKG dependencies on GMD_TECHNICAL_REQS

Line 636: FROM GMD_TECHNICAL_REQS

632: ) IS
633:
634: CURSOR C IS
635: SELECT ROWID
636: FROM GMD_TECHNICAL_REQS
637: WHERE TECH_REQ_ID = X_TECH_REQ_ID;
638:
639: BEGIN
640:

Line 641: INSERT INTO GMD_TECHNICAL_REQS (

637: WHERE TECH_REQ_ID = X_TECH_REQ_ID;
638:
639: BEGIN
640:
641: INSERT INTO GMD_TECHNICAL_REQS (
642: FORMULATION_SPEC_ID,
643: SPEC_ATTRIBUTE_ID,
644: TECH_PARM_ID,
645: TECH_REQ_ID,

Line 692: FROM GMD_TECHNICAL_REQS

688: SPEC_ATTRIBUTE_ID,
689: TECH_PARM_ID,
690: MIN_VALUE,
691: MAX_VALUE
692: FROM GMD_TECHNICAL_REQS
693: WHERE TECH_REQ_ID = X_TECH_REQ_ID
694: FOR UPDATE OF TECH_REQ_ID NOWAIT;
695: RECINFO C%ROWTYPE;
696:

Line 737: UPDATE GMD_TECHNICAL_REQS

733: ) IS
734:
735: BEGIN
736:
737: UPDATE GMD_TECHNICAL_REQS
738: SET
739: FORMULATION_SPEC_ID = X_FORMULATION_SPEC_ID ,
740: SPEC_ATTRIBUTE_ID = X_SPEC_ATTRIBUTE_ID ,
741: TECH_PARM_ID = X_TECH_PARM_ID ,

Line 760: DELETE FROM GMD_TECHNICAL_REQS

756: X_TECH_REQ_ID IN NUMBER
757: ) IS
758: BEGIN
759:
760: DELETE FROM GMD_TECHNICAL_REQS
761: WHERE TECH_REQ_ID = X_TECH_REQ_ID;
762:
763: IF (SQL%NOTFOUND) THEN
764: RAISE NO_DATA_FOUND;