APPS.AHL_UNIT_DEFERRALS_PKG dependencies on AHL_UNIT_DEFERRALS_TL

Line 115: insert into AHL_UNIT_DEFERRALS_TL (

111: X_LAST_UPDATED_BY,
112: X_LAST_UPDATE_LOGIN
113: ) RETURNING UNIT_DEFERRAL_ID INTO X_UNIT_DEFERRAL_ID;
114:
115: insert into AHL_UNIT_DEFERRALS_TL (
116: UNIT_DEFERRAL_ID,
117: LAST_UPDATE_DATE,
118: LAST_UPDATED_BY,
119: CREATION_DATE,

Line 141: from AHL_UNIT_DEFERRALS_TL T

137: from FND_LANGUAGES L
138: where L.INSTALLED_FLAG in ('I', 'B')
139: and not exists
140: (select NULL
141: from AHL_UNIT_DEFERRALS_TL T
142: where T.UNIT_DEFERRAL_ID = X_UNIT_DEFERRAL_ID
143: and T.LANGUAGE = L.LANGUAGE_CODE);
144:
145: open c;

Line 224: from AHL_UNIT_DEFERRALS_TL

220: cursor c1 is select
221: REMARKS,
222: APPROVER_NOTES,
223: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
224: from AHL_UNIT_DEFERRALS_TL
225: where UNIT_DEFERRAL_ID = X_UNIT_DEFERRAL_ID
226: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
227: for update of UNIT_DEFERRAL_ID nowait;
228: begin

Line 385: update AHL_UNIT_DEFERRALS_TL set

381: if (sql%notfound) then
382: raise no_data_found;
383: end if;
384:
385: update AHL_UNIT_DEFERRALS_TL set
386: REMARKS = X_REMARKS,
387: APPROVER_NOTES = X_APPROVER_NOTES,
388: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
389: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 404: delete from AHL_UNIT_DEFERRALS_TL

400: procedure DELETE_ROW (
401: X_UNIT_DEFERRAL_ID in NUMBER
402: ) is
403: begin
404: delete from AHL_UNIT_DEFERRALS_TL
405: where UNIT_DEFERRAL_ID = X_UNIT_DEFERRAL_ID;
406:
407: if (sql%notfound) then
408: raise no_data_found;

Line 422: delete from AHL_UNIT_DEFERRALS_TL T

418:
419: procedure ADD_LANGUAGE
420: is
421: begin
422: delete from AHL_UNIT_DEFERRALS_TL T
423: where not exists
424: (select NULL
425: from AHL_UNIT_DEFERRALS_B B
426: where B.UNIT_DEFERRAL_ID = T.UNIT_DEFERRAL_ID

Line 429: update AHL_UNIT_DEFERRALS_TL T set (

425: from AHL_UNIT_DEFERRALS_B B
426: where B.UNIT_DEFERRAL_ID = T.UNIT_DEFERRAL_ID
427: );
428:
429: update AHL_UNIT_DEFERRALS_TL T set (
430: REMARKS,
431: APPROVER_NOTES
432: ) = (select
433: B.REMARKS,

Line 435: from AHL_UNIT_DEFERRALS_TL B

431: APPROVER_NOTES
432: ) = (select
433: B.REMARKS,
434: B.APPROVER_NOTES
435: from AHL_UNIT_DEFERRALS_TL B
436: where B.UNIT_DEFERRAL_ID = T.UNIT_DEFERRAL_ID
437: and B.LANGUAGE = T.SOURCE_LANG)
438: where (
439: T.UNIT_DEFERRAL_ID,

Line 444: from AHL_UNIT_DEFERRALS_TL SUBB, AHL_UNIT_DEFERRALS_TL SUBT

440: T.LANGUAGE
441: ) in (select
442: SUBT.UNIT_DEFERRAL_ID,
443: SUBT.LANGUAGE
444: from AHL_UNIT_DEFERRALS_TL SUBB, AHL_UNIT_DEFERRALS_TL SUBT
445: where SUBB.UNIT_DEFERRAL_ID = SUBT.UNIT_DEFERRAL_ID
446: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
447: and (SUBB.REMARKS <> SUBT.REMARKS
448: or (SUBB.REMARKS is null and SUBT.REMARKS is not null)

Line 455: insert into AHL_UNIT_DEFERRALS_TL (

451: or (SUBB.APPROVER_NOTES is null and SUBT.APPROVER_NOTES is not null)
452: or (SUBB.APPROVER_NOTES is not null and SUBT.APPROVER_NOTES is null)
453: ));
454:
455: insert into AHL_UNIT_DEFERRALS_TL (
456: UNIT_DEFERRAL_ID,
457: LAST_UPDATE_DATE,
458: LAST_UPDATED_BY,
459: CREATION_DATE,

Line 477: from AHL_UNIT_DEFERRALS_TL B, FND_LANGUAGES L

473: B.REMARKS,
474: B.APPROVER_NOTES,
475: L.LANGUAGE_CODE,
476: B.SOURCE_LANG
477: from AHL_UNIT_DEFERRALS_TL B, FND_LANGUAGES L
478: where L.INSTALLED_FLAG in ('I', 'B')
479: and B.LANGUAGE = userenv('LANG')
480: and not exists
481: (select NULL

Line 482: from AHL_UNIT_DEFERRALS_TL T

478: where L.INSTALLED_FLAG in ('I', 'B')
479: and B.LANGUAGE = userenv('LANG')
480: and not exists
481: (select NULL
482: from AHL_UNIT_DEFERRALS_TL T
483: where T.UNIT_DEFERRAL_ID = B.UNIT_DEFERRAL_ID
484: and T.LANGUAGE = L.LANGUAGE_CODE);
485: end ADD_LANGUAGE;
486: