APPS.GMD_SPECIFICATIONS_PVT dependencies on GMD_SPECIFICATIONS_B

Line 58: CURSOR C IS SELECT ROWID FROM GMD_SPECIFICATIONS_B

54: X_LAST_UPDATE_DATE IN DATE,
55: X_LAST_UPDATED_BY IN NUMBER,
56: X_LAST_UPDATE_LOGIN IN NUMBER
57: ) IS
58: CURSOR C IS SELECT ROWID FROM GMD_SPECIFICATIONS_B
59: WHERE SPEC_ID = X_SPEC_ID
60: ;
61: BEGIN
62:

Line 67: INSERT INTO GMD_SPECIFICATIONS_B (

63: IF X_SPEC_ID IS NULL THEN
64: SELECT GMD_QC_SPEC_ID_S.NEXTVAL INTO X_SPEC_ID FROM DUAL;
65: END IF;
66:
67: INSERT INTO GMD_SPECIFICATIONS_B (
68: SPEC_ID,
69: SPEC_NAME,
70: SPEC_VERS,
71: INVENTORY_ITEM_ID,

Line 306: FROM GMD_SPECIFICATIONS_B

302: ATTRIBUTE27,
303: ATTRIBUTE28,
304: ATTRIBUTE29,
305: ATTRIBUTE30
306: FROM GMD_SPECIFICATIONS_B
307: WHERE SPEC_ID = X_SPEC_ID
308: FOR UPDATE OF SPEC_ID NOWAIT;
309: recinfo c%ROWTYPE;
310:

Line 484: UPDATE GMD_SPECIFICATIONS_B SET

480: X_LAST_UPDATED_BY IN NUMBER,
481: X_LAST_UPDATE_LOGIN IN NUMBER
482: ) IS
483: BEGIN
484: UPDATE GMD_SPECIFICATIONS_B SET
485: SPEC_NAME = X_SPEC_NAME,
486: SPEC_VERS = X_SPEC_VERS,
487: INVENTORY_ITEM_ID = X_INVENTORY_ITEM_ID,
488: REVISION = X_REVISION,

Line 559: FROM GMD_SPECIFICATIONS_B B

555: BEGIN
556: DELETE FROM GMD_SPECIFICATIONS_TL T
557: WHERE NOT EXISTS
558: (SELECT NULL
559: FROM GMD_SPECIFICATIONS_B B
560: WHERE B.SPEC_ID = T.SPEC_ID
561: );
562:
563: UPDATE GMD_SPECIFICATIONS_TL T SET (

Line 666: FROM gmd_specifications_b

662:
663: IF (p_spec_id IS NOT NULL) THEN
664: SELECT spec_id
665: INTO dummy
666: FROM gmd_specifications_b
667: WHERE spec_id = p_spec_id
668: FOR UPDATE OF spec_id NOWAIT ;
669: ELSIF (p_spec_name IS NOT NULL and p_spec_vers IS NOT NULL) THEN
670: SELECT spec_id

Line 672: FROM gmd_specifications_b

668: FOR UPDATE OF spec_id NOWAIT ;
669: ELSIF (p_spec_name IS NOT NULL and p_spec_vers IS NOT NULL) THEN
670: SELECT spec_id
671: INTO dummy
672: FROM gmd_specifications_b
673: WHERE spec_name = p_spec_name and spec_vers = p_spec_vers
674: FOR UPDATE OF spec_id NOWAIT ;
675: ELSE
676: gmd_api_pub.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_SPECIFICATIONS');

Line 707: UPDATE gmd_specifications_b

703:
704: BEGIN
705:
706: IF (p_spec_id IS NOT NULL) THEN
707: UPDATE gmd_specifications_b
708: SET delete_mark = 1,
709: last_update_date = NVL(p_last_update_date,SYSDATE),
710: last_updated_by = NVL(p_last_updated_by,FND_GLOBAL.USER_ID),
711: last_update_login = NVL(p_last_update_login,FND_GLOBAL.LOGIN_ID)

Line 717: UPDATE gmd_specifications_b

713: IF SQL%NOTFOUND THEN
714: RAISE NO_DATA_FOUND ;
715: END IF;
716: ELSIF (p_spec_name IS NOT NULL and p_spec_vers IS NOT NULL) THEN
717: UPDATE gmd_specifications_b
718: SET delete_mark = 1,
719: last_update_date = NVL(p_last_update_date,SYSDATE),
720: last_updated_by = NVL(p_last_updated_by,FND_GLOBAL.USER_ID),
721: last_update_login = NVL(p_last_update_login,FND_GLOBAL.LOGIN_ID)