APPS.GMD_TEST_INTERVAL_PLANS_PVT dependencies on GMD_TEST_INTERVAL_PLANS_B

Line 49: cursor C is select ROWID from GMD_TEST_INTERVAL_PLANS_B

45: X_LAST_UPDATE_DATE in DATE,
46: X_LAST_UPDATED_BY in NUMBER,
47: X_LAST_UPDATE_LOGIN in NUMBER
48: ) is
49: cursor C is select ROWID from GMD_TEST_INTERVAL_PLANS_B
50: where TEST_INTERVAL_PLAN_ID = X_TEST_INTERVAL_PLAN_ID
51: ;
52: begin
53: insert into GMD_TEST_INTERVAL_PLANS_B (

Line 53: insert into GMD_TEST_INTERVAL_PLANS_B (

49: cursor C is select ROWID from GMD_TEST_INTERVAL_PLANS_B
50: where TEST_INTERVAL_PLAN_ID = X_TEST_INTERVAL_PLAN_ID
51: ;
52: begin
53: insert into GMD_TEST_INTERVAL_PLANS_B (
54: TEST_INTERVAL_PLAN_ID,
55: NAME,
56: BASE_TEST_INTERVAL_PLAN_ID,
57: SIMULATION_START_DATE,

Line 256: from GMD_TEST_INTERVAL_PLANS_B

252: ATTRIBUTE27,
253: ATTRIBUTE28,
254: ATTRIBUTE29,
255: ATTRIBUTE30
256: from GMD_TEST_INTERVAL_PLANS_B
257: where TEST_INTERVAL_PLAN_ID = X_TEST_INTERVAL_PLAN_ID
258: for update of TEST_INTERVAL_PLAN_ID nowait;
259: recinfo c%rowtype;
260:

Line 412: update GMD_TEST_INTERVAL_PLANS_B set

408: X_LAST_UPDATED_BY in NUMBER,
409: X_LAST_UPDATE_LOGIN in NUMBER
410: ) is
411: begin
412: update GMD_TEST_INTERVAL_PLANS_B set
413: NAME = X_NAME,
414: BASE_TEST_INTERVAL_PLAN_ID = X_BASE_TEST_INTERVAL_PLAN_ID,
415: SIMULATION_START_DATE = X_SIMULATION_START_DATE,
416: DELETE_MARK = X_DELETE_MARK,

Line 483: delete from GMD_TEST_INTERVAL_PLANS_B

479: if (sql%notfound) then
480: raise no_data_found;
481: end if;
482:
483: delete from GMD_TEST_INTERVAL_PLANS_B
484: where TEST_INTERVAL_PLAN_ID = X_TEST_INTERVAL_PLAN_ID;
485:
486: if (sql%notfound) then
487: raise no_data_found;

Line 497: from GMD_TEST_INTERVAL_PLANS_B B

493: begin
494: delete from GMD_TEST_INTERVAL_PLANS_TL T
495: where not exists
496: (select NULL
497: from GMD_TEST_INTERVAL_PLANS_B B
498: where B.TEST_INTERVAL_PLAN_ID = T.TEST_INTERVAL_PLAN_ID
499: );
500:
501: update GMD_TEST_INTERVAL_PLANS_TL T set (