APPS.AHL_VISIT_TYPE_STAGES_PKG dependencies on AHL_VISIT_TYPE_STAGES_B

Line 33: cursor C is select ROWID from AHL_VISIT_TYPE_STAGES_B

29: X_LAST_UPDATE_DATE in DATE,
30: X_LAST_UPDATED_BY in NUMBER,
31: X_LAST_UPDATE_LOGIN in NUMBER
32: ) is
33: cursor C is select ROWID from AHL_VISIT_TYPE_STAGES_B
34: where VISIT_TYPE_STAGE_ID = X_VISIT_TYPE_STAGE_ID
35: ;
36: begin
37: insert into AHL_VISIT_TYPE_STAGES_B (

Line 37: insert into AHL_VISIT_TYPE_STAGES_B (

33: cursor C is select ROWID from AHL_VISIT_TYPE_STAGES_B
34: where VISIT_TYPE_STAGE_ID = X_VISIT_TYPE_STAGE_ID
35: ;
36: begin
37: insert into AHL_VISIT_TYPE_STAGES_B (
38: VISIT_TYPE_STAGE_ID,
39: VISIT_TYPE_ID,
40: DURATION,
41: STAGE_NUMBER,

Line 176: from AHL_VISIT_TYPE_STAGES_B

172: ATTRIBUTE12,
173: ATTRIBUTE13,
174: ATTRIBUTE14,
175: ATTRIBUTE15
176: from AHL_VISIT_TYPE_STAGES_B
177: where VISIT_TYPE_STAGE_ID = X_VISIT_TYPE_STAGE_ID
178: for update of VISIT_TYPE_STAGE_ID nowait;
179: recinfo c%rowtype;
180:

Line 284: update AHL_VISIT_TYPE_STAGES_B set

280: X_LAST_UPDATED_BY in NUMBER,
281: X_LAST_UPDATE_LOGIN in NUMBER
282: ) is
283: begin
284: update AHL_VISIT_TYPE_STAGES_B set
285: VISIT_TYPE_ID = X_VISIT_TYPE_ID,
286: DURATION = X_DURATION,
287: STAGE_NUMBER = X_STAGE_NUMBER,
288: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,

Line 339: delete from AHL_VISIT_TYPE_STAGES_B

335: if (sql%notfound) then
336: raise no_data_found;
337: end if;
338:
339: delete from AHL_VISIT_TYPE_STAGES_B
340: where VISIT_TYPE_STAGE_ID = X_VISIT_TYPE_STAGE_ID;
341:
342: if (sql%notfound) then
343: raise no_data_found;

Line 353: from AHL_VISIT_TYPE_STAGES_B B

349: begin
350: delete from AHL_VISIT_TYPE_STAGES_TL T
351: where not exists
352: (select NULL
353: from AHL_VISIT_TYPE_STAGES_B B
354: where B.VISIT_TYPE_STAGE_ID = T.VISIT_TYPE_STAGE_ID
355: );
356:
357: update AHL_VISIT_TYPE_STAGES_TL T set (