APPS.AHL_OPERATIONS_PKG dependencies on AHL_OPERATIONS_TL

Line 185: insert into AHL_OPERATIONS_TL (

181: X_LAST_UPDATED_BY,
182: X_LAST_UPDATE_LOGIN
183: );
184:
185: insert into AHL_OPERATIONS_TL (
186: DESCRIPTION,
187: REVISION_NOTES,
188: OPERATION_ID,
189: LAST_UPDATE_DATE,

Line 213: from AHL_OPERATIONS_TL T

209: from FND_LANGUAGES L
210: where L.INSTALLED_FLAG in ('I', 'B')
211: and not exists
212: (select NULL
213: from AHL_OPERATIONS_TL T
214: where T.OPERATION_ID = X_OPERATION_ID
215: and T.LANGUAGE = L.LANGUAGE_CODE);
216:
217: open c;

Line 344: from AHL_OPERATIONS_TL

340: DESCRIPTION,
341: REMARKS,
342: REVISION_NOTES,
343: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
344: from AHL_OPERATIONS_TL
345: where OPERATION_ID = X_OPERATION_ID
346: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
347: for update of OPERATION_ID nowait;
348: begin

Line 592: update AHL_OPERATIONS_TL set

588: if (sql%notfound) then
589: raise no_data_found;
590: end if;
591:
592: update AHL_OPERATIONS_TL set
593: DESCRIPTION = X_DESCRIPTION,
594: REMARKS = X_REMARKS,
595: REVISION_NOTES = X_REVISION_NOTES,
596: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 612: delete from AHL_OPERATIONS_TL

608: procedure DELETE_ROW (
609: X_OPERATION_ID in NUMBER
610: ) is
611: begin
612: delete from AHL_OPERATIONS_TL
613: where OPERATION_ID = X_OPERATION_ID;
614:
615: if (sql%notfound) then
616: raise no_data_found;

Line 630: delete from AHL_OPERATIONS_TL T

626:
627: procedure ADD_LANGUAGE
628: is
629: begin
630: delete from AHL_OPERATIONS_TL T
631: where not exists
632: (select NULL
633: from AHL_OPERATIONS_B B
634: where B.OPERATION_ID = T.OPERATION_ID

Line 637: update AHL_OPERATIONS_TL T set (

633: from AHL_OPERATIONS_B B
634: where B.OPERATION_ID = T.OPERATION_ID
635: );
636:
637: update AHL_OPERATIONS_TL T set (
638: DESCRIPTION,
639: REMARKS,
640: REVISION_NOTES
641: ) = (select

Line 645: from AHL_OPERATIONS_TL B

641: ) = (select
642: B.DESCRIPTION,
643: B.REMARKS,
644: B.REVISION_NOTES
645: from AHL_OPERATIONS_TL B
646: where B.OPERATION_ID = T.OPERATION_ID
647: and B.LANGUAGE = T.SOURCE_LANG)
648: where (
649: T.OPERATION_ID,

Line 654: from AHL_OPERATIONS_TL SUBB, AHL_OPERATIONS_TL SUBT

650: T.LANGUAGE
651: ) in (select
652: SUBT.OPERATION_ID,
653: SUBT.LANGUAGE
654: from AHL_OPERATIONS_TL SUBB, AHL_OPERATIONS_TL SUBT
655: where SUBB.OPERATION_ID = SUBT.OPERATION_ID
656: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
657: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
658: or SUBB.REMARKS <> SUBT.REMARKS

Line 666: insert into AHL_OPERATIONS_TL (

662: or (SUBB.REVISION_NOTES is null and SUBT.REVISION_NOTES is not null)
663: or (SUBB.REVISION_NOTES is not null and SUBT.REVISION_NOTES is null)
664: ));
665:
666: insert into AHL_OPERATIONS_TL (
667: DESCRIPTION,
668: REVISION_NOTES,
669: OPERATION_ID,
670: LAST_UPDATE_DATE,

Line 690: from AHL_OPERATIONS_TL B, FND_LANGUAGES L

686: B.LAST_UPDATE_LOGIN,
687: B.REMARKS,
688: L.LANGUAGE_CODE,
689: B.SOURCE_LANG
690: from AHL_OPERATIONS_TL B, FND_LANGUAGES L
691: where L.INSTALLED_FLAG in ('I', 'B')
692: and B.LANGUAGE = userenv('LANG')
693: and not exists
694: (select NULL

Line 695: from AHL_OPERATIONS_TL T

691: where L.INSTALLED_FLAG in ('I', 'B')
692: and B.LANGUAGE = userenv('LANG')
693: and not exists
694: (select NULL
695: from AHL_OPERATIONS_TL T
696: where T.OPERATION_ID = B.OPERATION_ID
697: and T.LANGUAGE = L.LANGUAGE_CODE);
698: end ADD_LANGUAGE;
699: