APPS.AHL_VISIT_TYPES_PKG dependencies on AHL_VISIT_TYPES_B

Line 37: cursor C is select ROWID from AHL_VISIT_TYPES_B

33: X_LAST_UPDATE_DATE in DATE,
34: X_LAST_UPDATED_BY in NUMBER,
35: X_LAST_UPDATE_LOGIN in NUMBER
36: ) is
37: cursor C is select ROWID from AHL_VISIT_TYPES_B
38: where VISIT_TYPE_ID = X_VISIT_TYPE_ID
39: ;
40: begin
41: insert into AHL_VISIT_TYPES_B (

Line 41: insert into AHL_VISIT_TYPES_B (

37: cursor C is select ROWID from AHL_VISIT_TYPES_B
38: where VISIT_TYPE_ID = X_VISIT_TYPE_ID
39: ;
40: begin
41: insert into AHL_VISIT_TYPES_B (
42: ATTRIBUTE12,
43: ATTRIBUTE13,
44: ATTRIBUTE14,
45: ATTRIBUTE15,

Line 196: from AHL_VISIT_TYPES_B

192: ATTRIBUTE9,
193: ATTRIBUTE5,
194: ATTRIBUTE6,
195: ATTRIBUTE7
196: from AHL_VISIT_TYPES_B
197: where VISIT_TYPE_ID = X_VISIT_TYPE_ID
198: for update of VISIT_TYPE_ID nowait;
199: recinfo c%rowtype;
200:

Line 315: update AHL_VISIT_TYPES_B set

311: X_LAST_UPDATED_BY in NUMBER,
312: X_LAST_UPDATE_LOGIN in NUMBER
313: ) is
314: begin
315: update AHL_VISIT_TYPES_B set
316: ATTRIBUTE12 = X_ATTRIBUTE12,
317: ATTRIBUTE13 = X_ATTRIBUTE13,
318: ATTRIBUTE14 = X_ATTRIBUTE14,
319: ATTRIBUTE15 = X_ATTRIBUTE15,

Line 374: delete from AHL_VISIT_TYPES_B

370: if (sql%notfound) then
371: raise no_data_found;
372: end if;
373:
374: delete from AHL_VISIT_TYPES_B
375: where VISIT_TYPE_ID = X_VISIT_TYPE_ID;
376:
377: if (sql%notfound) then
378: raise no_data_found;

Line 388: from AHL_VISIT_TYPES_B B

384: begin
385: delete from AHL_VISIT_TYPES_TL T
386: where not exists
387: (select NULL
388: from AHL_VISIT_TYPES_B B
389: where B.VISIT_TYPE_ID = T.VISIT_TYPE_ID
390: );
391:
392: update AHL_VISIT_TYPES_TL T set (