APPS.GMD_STORAGE_PLANS_PKG dependencies on GMD_STORAGE_PLANS_B

Line 48: cursor C is select ROWID from GMD_STORAGE_PLANS_B

44: X_LAST_UPDATE_DATE in DATE,
45: X_LAST_UPDATED_BY in NUMBER,
46: X_LAST_UPDATE_LOGIN in NUMBER
47: ) is
48: cursor C is select ROWID from GMD_STORAGE_PLANS_B
49: where STORAGE_PLAN_ID = X_STORAGE_PLAN_ID
50: ;
51: begin
52: insert into GMD_STORAGE_PLANS_B (

Line 52: insert into GMD_STORAGE_PLANS_B (

48: cursor C is select ROWID from GMD_STORAGE_PLANS_B
49: where STORAGE_PLAN_ID = X_STORAGE_PLAN_ID
50: ;
51: begin
52: insert into GMD_STORAGE_PLANS_B (
53: STORAGE_PLAN_ID,
54: STORAGE_PLAN_NAME,
55: BASE_TEST_INTERVAL_PLAN_ID,
56: TEXT_CODE,

Line 251: from GMD_STORAGE_PLANS_B

247: ATTRIBUTE28,
248: ATTRIBUTE29,
249: ATTRIBUTE30,
250: DELETE_MARK
251: from GMD_STORAGE_PLANS_B
252: where STORAGE_PLAN_ID = X_STORAGE_PLAN_ID
253: for update of STORAGE_PLAN_ID nowait;
254: recinfo c%rowtype;
255:

Line 403: update GMD_STORAGE_PLANS_B set

399: X_LAST_UPDATED_BY in NUMBER,
400: X_LAST_UPDATE_LOGIN in NUMBER
401: ) is
402: begin
403: update GMD_STORAGE_PLANS_B set
404: STORAGE_PLAN_NAME = X_STORAGE_PLAN_NAME,
405: BASE_TEST_INTERVAL_PLAN_ID = X_BASE_TEST_INTERVAL_PLAN_ID,
406: TEXT_CODE = X_TEXT_CODE,
407: ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,

Line 473: delete from GMD_STORAGE_PLANS_B

469: if (sql%notfound) then
470: raise no_data_found;
471: end if;
472:
473: delete from GMD_STORAGE_PLANS_B
474: where STORAGE_PLAN_ID = X_STORAGE_PLAN_ID;
475:
476: if (sql%notfound) then
477: raise no_data_found;

Line 487: from GMD_STORAGE_PLANS_B B

483: begin
484: delete from GMD_STORAGE_PLANS_TL T
485: where not exists
486: (select NULL
487: from GMD_STORAGE_PLANS_B B
488: where B.STORAGE_PLAN_ID = T.STORAGE_PLAN_ID
489: );
490:
491: update GMD_STORAGE_PLANS_TL T set (