APPS.OZF_SD_REQUEST_HEADERS_ALL_PKG dependencies on OZF_SD_REQUEST_HEADERS_ALL_TL

Line 204: insert into OZF_SD_REQUEST_HEADERS_ALL_TL (

200: X_LAST_UPDATED_BY,
201: X_LAST_UPDATE_LOGIN
202: );
203:
204: insert into OZF_SD_REQUEST_HEADERS_ALL_TL (
205: REQUEST_HEADER_ID,
206: LAST_UPDATE_DATE,
207: LAST_UPDATED_BY,
208: CREATION_DATE,

Line 232: from OZF_SD_REQUEST_HEADERS_ALL_TL T

228: from FND_LANGUAGES L
229: where L.INSTALLED_FLAG in ('I', 'B')
230: and not exists
231: (select NULL
232: from OZF_SD_REQUEST_HEADERS_ALL_TL T
233: where T.REQUEST_HEADER_ID = X_REQUEST_HEADER_ID
234: and T.LANGUAGE = L.LANGUAGE_CODE);
235:
236: open c;

Line 373: from OZF_SD_REQUEST_HEADERS_ALL_TL

369:
370: cursor c1 is select
371: REQUEST_DESCRIPTION,
372: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
373: from OZF_SD_REQUEST_HEADERS_ALL_TL
374: where REQUEST_HEADER_ID = X_REQUEST_HEADER_ID
375: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
376: for update of REQUEST_HEADER_ID nowait;
377: begin

Line 650: update OZF_SD_REQUEST_HEADERS_ALL_TL set

646: if (sql%notfound) then
647: raise no_data_found;
648: end if;
649:
650: update OZF_SD_REQUEST_HEADERS_ALL_TL set
651: REQUEST_DESCRIPTION = X_REQUEST_DESCRIPTION,
652: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
653: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
654: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 668: delete from OZF_SD_REQUEST_HEADERS_ALL_TL

664: procedure DELETE_ROW (
665: X_REQUEST_HEADER_ID in NUMBER
666: ) is
667: begin
668: delete from OZF_SD_REQUEST_HEADERS_ALL_TL
669: where REQUEST_HEADER_ID = X_REQUEST_HEADER_ID;
670:
671: if (sql%notfound) then
672: raise no_data_found;

Line 686: delete from OZF_SD_REQUEST_HEADERS_ALL_TL T

682:
683: procedure ADD_LANGUAGE
684: is
685: begin
686: delete from OZF_SD_REQUEST_HEADERS_ALL_TL T
687: where not exists
688: (select NULL
689: from OZF_SD_REQUEST_HEADERS_ALL_B B
690: where B.REQUEST_HEADER_ID = T.REQUEST_HEADER_ID

Line 693: update OZF_SD_REQUEST_HEADERS_ALL_TL T set (

689: from OZF_SD_REQUEST_HEADERS_ALL_B B
690: where B.REQUEST_HEADER_ID = T.REQUEST_HEADER_ID
691: );
692:
693: update OZF_SD_REQUEST_HEADERS_ALL_TL T set (
694: REQUEST_DESCRIPTION
695: ) = (select
696: B.REQUEST_DESCRIPTION
697: from OZF_SD_REQUEST_HEADERS_ALL_TL B

Line 697: from OZF_SD_REQUEST_HEADERS_ALL_TL B

693: update OZF_SD_REQUEST_HEADERS_ALL_TL T set (
694: REQUEST_DESCRIPTION
695: ) = (select
696: B.REQUEST_DESCRIPTION
697: from OZF_SD_REQUEST_HEADERS_ALL_TL B
698: where B.REQUEST_HEADER_ID = T.REQUEST_HEADER_ID
699: and B.LANGUAGE = T.SOURCE_LANG)
700: where (
701: T.REQUEST_HEADER_ID,

Line 706: from OZF_SD_REQUEST_HEADERS_ALL_TL SUBB, OZF_SD_REQUEST_HEADERS_ALL_TL SUBT

702: T.LANGUAGE
703: ) in (select
704: SUBT.REQUEST_HEADER_ID,
705: SUBT.LANGUAGE
706: from OZF_SD_REQUEST_HEADERS_ALL_TL SUBB, OZF_SD_REQUEST_HEADERS_ALL_TL SUBT
707: where SUBB.REQUEST_HEADER_ID = SUBT.REQUEST_HEADER_ID
708: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
709: and (SUBB.REQUEST_DESCRIPTION <> SUBT.REQUEST_DESCRIPTION
710: or (SUBB.REQUEST_DESCRIPTION is null and SUBT.REQUEST_DESCRIPTION is not null)

Line 714: insert into OZF_SD_REQUEST_HEADERS_ALL_TL (

710: or (SUBB.REQUEST_DESCRIPTION is null and SUBT.REQUEST_DESCRIPTION is not null)
711: or (SUBB.REQUEST_DESCRIPTION is not null and SUBT.REQUEST_DESCRIPTION is null)
712: ));
713:
714: insert into OZF_SD_REQUEST_HEADERS_ALL_TL (
715: REQUEST_HEADER_ID,
716: LAST_UPDATE_DATE,
717: LAST_UPDATED_BY,
718: CREATION_DATE,

Line 744: from OZF_SD_REQUEST_HEADERS_ALL_TL B, FND_LANGUAGES L

740: B.PROGRAM_ID,
741: B.CREATED_FROM,
742: L.LANGUAGE_CODE,
743: B.SOURCE_LANG
744: from OZF_SD_REQUEST_HEADERS_ALL_TL B, FND_LANGUAGES L
745: where L.INSTALLED_FLAG in ('I', 'B')
746: and B.LANGUAGE = userenv('LANG')
747: and not exists
748: (select NULL

Line 749: from OZF_SD_REQUEST_HEADERS_ALL_TL T

745: where L.INSTALLED_FLAG in ('I', 'B')
746: and B.LANGUAGE = userenv('LANG')
747: and not exists
748: (select NULL
749: from OZF_SD_REQUEST_HEADERS_ALL_TL T
750: where T.REQUEST_HEADER_ID = B.REQUEST_HEADER_ID
751: and T.LANGUAGE = L.LANGUAGE_CODE);
752: end ADD_LANGUAGE;
753: