APPS.AHL_OPERATIONS_PKG dependencies on AHL_OPERATIONS_TL

Line 173: insert into AHL_OPERATIONS_TL (

169: X_LAST_UPDATED_BY,
170: X_LAST_UPDATE_LOGIN
171: );
172:
173: insert into AHL_OPERATIONS_TL (
174: DESCRIPTION,
175: REVISION_NOTES,
176: OPERATION_ID,
177: LAST_UPDATE_DATE,

Line 201: from AHL_OPERATIONS_TL T

197: from FND_LANGUAGES L
198: where L.INSTALLED_FLAG in ('I', 'B')
199: and not exists
200: (select NULL
201: from AHL_OPERATIONS_TL T
202: where T.OPERATION_ID = X_OPERATION_ID
203: and T.LANGUAGE = L.LANGUAGE_CODE);
204:
205: open c;

Line 324: from AHL_OPERATIONS_TL

320: DESCRIPTION,
321: REMARKS,
322: REVISION_NOTES,
323: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
324: from AHL_OPERATIONS_TL
325: where OPERATION_ID = X_OPERATION_ID
326: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
327: for update of OPERATION_ID nowait;
328: begin

Line 558: update AHL_OPERATIONS_TL set

554: if (sql%notfound) then
555: raise no_data_found;
556: end if;
557:
558: update AHL_OPERATIONS_TL set
559: DESCRIPTION = X_DESCRIPTION,
560: REMARKS = X_REMARKS,
561: REVISION_NOTES = X_REVISION_NOTES,
562: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 578: delete from AHL_OPERATIONS_TL

574: procedure DELETE_ROW (
575: X_OPERATION_ID in NUMBER
576: ) is
577: begin
578: delete from AHL_OPERATIONS_TL
579: where OPERATION_ID = X_OPERATION_ID;
580:
581: if (sql%notfound) then
582: raise no_data_found;

Line 596: delete from AHL_OPERATIONS_TL T

592:
593: procedure ADD_LANGUAGE
594: is
595: begin
596: delete from AHL_OPERATIONS_TL T
597: where not exists
598: (select NULL
599: from AHL_OPERATIONS_B B
600: where B.OPERATION_ID = T.OPERATION_ID

Line 603: update AHL_OPERATIONS_TL T set (

599: from AHL_OPERATIONS_B B
600: where B.OPERATION_ID = T.OPERATION_ID
601: );
602:
603: update AHL_OPERATIONS_TL T set (
604: DESCRIPTION,
605: REMARKS,
606: REVISION_NOTES
607: ) = (select

Line 611: from AHL_OPERATIONS_TL B

607: ) = (select
608: B.DESCRIPTION,
609: B.REMARKS,
610: B.REVISION_NOTES
611: from AHL_OPERATIONS_TL B
612: where B.OPERATION_ID = T.OPERATION_ID
613: and B.LANGUAGE = T.SOURCE_LANG)
614: where (
615: T.OPERATION_ID,

Line 620: from AHL_OPERATIONS_TL SUBB, AHL_OPERATIONS_TL SUBT

616: T.LANGUAGE
617: ) in (select
618: SUBT.OPERATION_ID,
619: SUBT.LANGUAGE
620: from AHL_OPERATIONS_TL SUBB, AHL_OPERATIONS_TL SUBT
621: where SUBB.OPERATION_ID = SUBT.OPERATION_ID
622: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
623: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
624: or SUBB.REMARKS <> SUBT.REMARKS

Line 632: insert into AHL_OPERATIONS_TL (

628: or (SUBB.REVISION_NOTES is null and SUBT.REVISION_NOTES is not null)
629: or (SUBB.REVISION_NOTES is not null and SUBT.REVISION_NOTES is null)
630: ));
631:
632: insert into AHL_OPERATIONS_TL (
633: DESCRIPTION,
634: REVISION_NOTES,
635: OPERATION_ID,
636: LAST_UPDATE_DATE,

Line 656: from AHL_OPERATIONS_TL B, FND_LANGUAGES L

652: B.LAST_UPDATE_LOGIN,
653: B.REMARKS,
654: L.LANGUAGE_CODE,
655: B.SOURCE_LANG
656: from AHL_OPERATIONS_TL B, FND_LANGUAGES L
657: where L.INSTALLED_FLAG in ('I', 'B')
658: and B.LANGUAGE = userenv('LANG')
659: and not exists
660: (select NULL

Line 661: from AHL_OPERATIONS_TL T

657: where L.INSTALLED_FLAG in ('I', 'B')
658: and B.LANGUAGE = userenv('LANG')
659: and not exists
660: (select NULL
661: from AHL_OPERATIONS_TL T
662: where T.OPERATION_ID = B.OPERATION_ID
663: and T.LANGUAGE = L.LANGUAGE_CODE);
664: end ADD_LANGUAGE;
665: