APPS.AHL_DOC_FILE_ASSOC_PKG dependencies on AHL_DOC_FILE_ASSOC_B

Line 35: cursor C is select ROWID from AHL_DOC_FILE_ASSOC_B

31: X_LAST_UPDATE_DATE in DATE,
32: X_LAST_UPDATED_BY in NUMBER,
33: X_LAST_UPDATE_LOGIN in NUMBER
34: ) is
35: cursor C is select ROWID from AHL_DOC_FILE_ASSOC_B
36: where ASSOCIATION_ID = X_ASSOCIATION_ID
37: ;
38: begin
39: insert into AHL_DOC_FILE_ASSOC_B (

Line 39: insert into AHL_DOC_FILE_ASSOC_B (

35: cursor C is select ROWID from AHL_DOC_FILE_ASSOC_B
36: where ASSOCIATION_ID = X_ASSOCIATION_ID
37: ;
38: begin
39: insert into AHL_DOC_FILE_ASSOC_B (
40: ASSOCIATION_ID,
41: OBJECT_VERSION_NUMBER,
42: FILE_ID,
43: FILE_NAME,

Line 188: from AHL_DOC_FILE_ASSOC_B

184: ATTRIBUTE12,
185: ATTRIBUTE13,
186: ATTRIBUTE14,
187: ATTRIBUTE15
188: from AHL_DOC_FILE_ASSOC_B
189: where ASSOCIATION_ID = X_ASSOCIATION_ID
190: for update of ASSOCIATION_ID nowait;
191: recinfo c%rowtype;
192:

Line 303: update AHL_DOC_FILE_ASSOC_B set

299: X_LAST_UPDATED_BY in NUMBER,
300: X_LAST_UPDATE_LOGIN in NUMBER
301: ) is
302: begin
303: update AHL_DOC_FILE_ASSOC_B set
304: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
305: FILE_ID = X_FILE_ID,
306: FILE_NAME = X_FILE_NAME,
307: REVISION_ID = X_REVISION_ID,

Line 360: delete from AHL_DOC_FILE_ASSOC_B

356: if (sql%notfound) then
357: raise no_data_found;
358: end if;
359:
360: delete from AHL_DOC_FILE_ASSOC_B
361: where ASSOCIATION_ID = X_ASSOCIATION_ID;
362:
363: if (sql%notfound) then
364: raise no_data_found;

Line 374: from AHL_DOC_FILE_ASSOC_B B

370: begin
371: delete from AHL_DOC_FILE_ASSOC_TL T
372: where not exists
373: (select NULL
374: from AHL_DOC_FILE_ASSOC_B B
375: where B.ASSOCIATION_ID = T.ASSOCIATION_ID
376: );
377:
378: update AHL_DOC_FILE_ASSOC_TL T set (