APPS.GMD_FORMULATION_SPECS_PKG dependencies on GMD_SPECIFICATION_ATTRIBUTES

Line 788: FROM GMD_SPECIFICATION_ATTRIBUTES

784: X_LAST_UPDATE_LOGIN IN NUMBER) IS
785:
786: CURSOR C IS
787: SELECT ROWID
788: FROM GMD_SPECIFICATION_ATTRIBUTES
789: WHERE SPEC_ATTRIBUTE_ID = X_SPEC_ATTRIBUTE_ID;
790:
791: BEGIN
792:

Line 793: INSERT INTO GMD_SPECIFICATION_ATTRIBUTES (

789: WHERE SPEC_ATTRIBUTE_ID = X_SPEC_ATTRIBUTE_ID;
790:
791: BEGIN
792:
793: INSERT INTO GMD_SPECIFICATION_ATTRIBUTES (
794: FORMULATION_SPEC_ID,
795: SPEC_ATTRIBUTE_ID,
796: LOOKUP_TYPE,
797: LOOKUP_CODE,

Line 831: DELETE FROM GMD_SPECIFICATION_ATTRIBUTES

827: ) IS
828:
829: BEGIN
830:
831: DELETE FROM GMD_SPECIFICATION_ATTRIBUTES
832: WHERE SPEC_ATTRIBUTE_ID = X_SPEC_ATTRIBUTE_ID;
833:
834: IF (SQL%NOTFOUND) THEN
835: RAISE NO_DATA_FOUND;