eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMD_FORMULATION_SPECS_PKG dependencies on GMD_MATERIAL_REQS

Line 287: FROM GMD_MATERIAL_REQS

283: ) IS
284:
285: CURSOR C IS
286: SELECT ROWID
287: FROM GMD_MATERIAL_REQS
288: WHERE MATL_REQ_ID = X_MATL_REQ_ID;
289:
290: BEGIN
291:

Line 292: INSERT INTO GMD_MATERIAL_REQS (

288: WHERE MATL_REQ_ID = X_MATL_REQ_ID;
289:
290: BEGIN
291:
292: INSERT INTO GMD_MATERIAL_REQS (
293: FORMULATION_SPEC_ID,
294: MATL_REQ_ID,
295: SPEC_ATTRIBUTE_ID,
296: LINE_NO,

Line 355: FROM GMD_MATERIAL_REQS

351: INVENTORY_ITEM_ID,
352: ITEM_UOM,
353: MIN_QTY,
354: MAX_QTY
355: FROM GMD_MATERIAL_REQS
356: WHERE MATL_REQ_ID = X_MATL_REQ_ID
357: FOR UPDATE OF MATL_REQ_ID NOWAIT;
358: RECINFO C%ROWTYPE;
359:

Line 407: UPDATE GMD_MATERIAL_REQS

403: ) IS
404:
405: BEGIN
406:
407: UPDATE GMD_MATERIAL_REQS
408: SET
409: FORMULATION_SPEC_ID = X_FORMULATION_SPEC_ID ,
410: SPEC_ATTRIBUTE_ID = X_SPEC_ATTRIBUTE_ID ,
411: LINE_NO = X_LINE_NO ,

Line 432: DELETE FROM GMD_MATERIAL_REQS

428: X_MATL_REQ_ID IN NUMBER
429: ) IS
430: BEGIN
431:
432: DELETE FROM GMD_MATERIAL_REQS
433: WHERE MATL_REQ_ID = X_MATL_REQ_ID;
434:
435: IF (SQL%NOTFOUND) THEN
436: RAISE NO_DATA_FOUND;