APPS.GMD_STABILITY_STUDIES_PVT dependencies on GMD_STABILITY_STUDIES_B

Line 74: cursor C is select ROWID from GMD_STABILITY_STUDIES_B

70: X_LAST_UPDATE_DATE in DATE,
71: X_LAST_UPDATED_BY in NUMBER,
72: X_LAST_UPDATE_LOGIN in NUMBER
73: ) is
74: cursor C is select ROWID from GMD_STABILITY_STUDIES_B
75: where SS_ID = X_SS_ID
76: ;
77: begin
78: insert into GMD_STABILITY_STUDIES_B (

Line 78: insert into GMD_STABILITY_STUDIES_B (

74: cursor C is select ROWID from GMD_STABILITY_STUDIES_B
75: where SS_ID = X_SS_ID
76: ;
77: begin
78: insert into GMD_STABILITY_STUDIES_B (
79: ATTRIBUTE29,
80: ATTRIBUTE30,
81: DELETE_MARK,
82: STORAGE_SPEC_ID,

Line 379: from GMD_STABILITY_STUDIES_B

375: ORGANIZATION_ID , -- INVCONV
376: INVENTORY_ITEM_ID , -- INVCONV
377: REVISION , -- INVCONV
378: LAB_ORGANIZATION_ID -- INVCONV
379: from GMD_STABILITY_STUDIES_B
380: where SS_ID = X_SS_ID
381: for update of SS_ID nowait;
382: recinfo c%rowtype;
383:

Line 596: update GMD_STABILITY_STUDIES_B set

592: X_LAST_UPDATED_BY in NUMBER,
593: X_LAST_UPDATE_LOGIN in NUMBER
594: ) is
595: begin
596: update GMD_STABILITY_STUDIES_B set
597: ATTRIBUTE29 = X_ATTRIBUTE29,
598: ATTRIBUTE30 = X_ATTRIBUTE30,
599: DELETE_MARK = X_DELETE_MARK,
600: STORAGE_SPEC_ID = X_STORAGE_SPEC_ID,

Line 692: delete from GMD_STABILITY_STUDIES_B

688: if (sql%notfound) then
689: raise no_data_found;
690: end if;
691:
692: delete from GMD_STABILITY_STUDIES_B
693: where SS_ID = X_SS_ID;
694:
695: if (sql%notfound) then
696: raise no_data_found;

Line 706: from GMD_STABILITY_STUDIES_B B

702: begin
703: delete from GMD_STABILITY_STUDIES_TL T
704: where not exists
705: (select NULL
706: from GMD_STABILITY_STUDIES_B B
707: where B.SS_ID = T.SS_ID
708: );
709:
710: update GMD_STABILITY_STUDIES_TL T set (