APPS.AHL_VWP_STAGES_PKG dependencies on AHL_VWP_STAGES_B

Line 39: cursor C is select ROWID from AHL_VWP_STAGES_B

35: X_PLANNED_END_DATE in DATE,
36: X_PREV_STAGE_NUM in NUMBER,
37: X_EARLIEST_START_DATE in DATE
38: ) is
39: cursor C is select ROWID from AHL_VWP_STAGES_B
40: where STAGE_ID = X_STAGE_ID
41: ;
42: begin
43: insert into AHL_VWP_STAGES_B (

Line 43: insert into AHL_VWP_STAGES_B (

39: cursor C is select ROWID from AHL_VWP_STAGES_B
40: where STAGE_ID = X_STAGE_ID
41: ;
42: begin
43: insert into AHL_VWP_STAGES_B (
44: ATTRIBUTE3,
45: ATTRIBUTE4,
46: ATTRIBUTE5,
47: ATTRIBUTE6,

Line 194: from AHL_VWP_STAGES_B

190: OBJECT_VERSION_NUMBER,
191: ATTRIBUTE_CATEGORY,
192: ATTRIBUTE1,
193: ATTRIBUTE2
194: from AHL_VWP_STAGES_B
195: where STAGE_ID = X_STAGE_ID
196: for update of STAGE_ID nowait;
197: recinfo c%rowtype;
198:

Line 309: update AHL_VWP_STAGES_B set

305: X_EARLIEST_START_DATE in DATE
306: --PRAKKUM :: 15/03/2011 :: VWPE :: ER 12424063 :: END
307: ) is
308: begin
309: update AHL_VWP_STAGES_B set
310: ATTRIBUTE3 = X_ATTRIBUTE3,
311: ATTRIBUTE4 = X_ATTRIBUTE4,
312: ATTRIBUTE5 = X_ATTRIBUTE5,
313: ATTRIBUTE6 = X_ATTRIBUTE6,

Line 371: delete from AHL_VWP_STAGES_B

367: if (sql%notfound) then
368: raise no_data_found;
369: end if;
370:
371: delete from AHL_VWP_STAGES_B
372: where STAGE_ID = X_STAGE_ID;
373:
374: if (sql%notfound) then
375: raise no_data_found;

Line 385: from AHL_VWP_STAGES_B B

381: begin
382: delete from AHL_VWP_STAGES_TL T
383: where not exists
384: (select NULL
385: from AHL_VWP_STAGES_B B
386: where B.STAGE_ID = T.STAGE_ID
387: );
388:
389: update AHL_VWP_STAGES_TL T set (