APPS.GMD_SAMPLING_PLANS_PVT dependencies on GMD_SAMPLING_PLANS_B

Line 57: cursor C is select ROWID from GMD_SAMPLING_PLANS_B

53: X_LAST_UPDATE_DATE in DATE,
54: X_LAST_UPDATED_BY in NUMBER,
55: X_LAST_UPDATE_LOGIN in NUMBER
56: ) is
57: cursor C is select ROWID from GMD_SAMPLING_PLANS_B
58: where SAMPLING_PLAN_ID = X_SAMPLING_PLAN_ID
59: ;
60: begin
61: insert into GMD_SAMPLING_PLANS_B (

Line 61: insert into GMD_SAMPLING_PLANS_B (

57: cursor C is select ROWID from GMD_SAMPLING_PLANS_B
58: where SAMPLING_PLAN_ID = X_SAMPLING_PLAN_ID
59: ;
60: begin
61: insert into GMD_SAMPLING_PLANS_B (
62: ATTRIBUTE28,
63: ATTRIBUTE29,
64: ATTRIBUTE30,
65: ATTRIBUTE7,

Line 296: from GMD_SAMPLING_PLANS_B

292: ATTRIBUTE3,
293: ATTRIBUTE4,
294: ATTRIBUTE5,
295: ATTRIBUTE6
296: from GMD_SAMPLING_PLANS_B
297: where SAMPLING_PLAN_ID = X_SAMPLING_PLAN_ID
298: for update of SAMPLING_PLAN_ID nowait;
299: recinfo c%rowtype;
300:

Line 476: update GMD_SAMPLING_PLANS_B set

472: X_LAST_UPDATED_BY in NUMBER,
473: X_LAST_UPDATE_LOGIN in NUMBER
474: ) is
475: begin
476: update GMD_SAMPLING_PLANS_B set
477: ATTRIBUTE28 = X_ATTRIBUTE28,
478: ATTRIBUTE29 = X_ATTRIBUTE29,
479: ATTRIBUTE30 = X_ATTRIBUTE30,
480: ATTRIBUTE7 = X_ATTRIBUTE7,

Line 555: delete from GMD_SAMPLING_PLANS_B

551: if (sql%notfound) then
552: raise no_data_found;
553: end if;
554:
555: delete from GMD_SAMPLING_PLANS_B
556: where SAMPLING_PLAN_ID = X_SAMPLING_PLAN_ID;
557:
558: if (sql%notfound) then
559: raise no_data_found;

Line 569: from GMD_SAMPLING_PLANS_B B

565: begin
566: delete from GMD_SAMPLING_PLANS_TL T
567: where not exists
568: (select NULL
569: from GMD_SAMPLING_PLANS_B B
570: where B.SAMPLING_PLAN_ID = T.SAMPLING_PLAN_ID
571: );
572:
573: update GMD_SAMPLING_PLANS_TL T set (