APPS.WMS_WP_WAVE_HEADERS_PKG dependencies on WMS_WP_WAVE_HEADERS_TL

Line 289: insert into WMS_WP_WAVE_HEADERS_TL (

285: X_LAST_UPDATED_BY,
286: X_LAST_UPDATE_LOGIN
287: );
288:
289: insert into WMS_WP_WAVE_HEADERS_TL (
290: WAVE_HEADER_ID,
291: WAVE_NAME,
292: WAVE_DESCRIPTION,
293: CREATED_BY,

Line 315: from WMS_WP_WAVE_HEADERS_TL T

311: from FND_LANGUAGES L
312: where L.INSTALLED_FLAG in ('I', 'B')
313: and not exists
314: (select NULL
315: from WMS_WP_WAVE_HEADERS_TL T
316: where T.WAVE_HEADER_ID = X_WAVE_HEADER_ID
317: and T.LANGUAGE = L.LANGUAGE_CODE);
318:
319: open c;

Line 511: from WMS_WP_WAVE_HEADERS_TL

507: cursor c1 is select
508: WAVE_NAME,
509: WAVE_DESCRIPTION,
510: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
511: from WMS_WP_WAVE_HEADERS_TL
512: where WAVE_HEADER_ID = X_WAVE_HEADER_ID
513: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
514: for update of WAVE_HEADER_ID nowait;
515: begin

Line 903: update WMS_WP_WAVE_HEADERS_TL set

899: if (sql%notfound) then
900: raise no_data_found;
901: end if;
902:
903: update WMS_WP_WAVE_HEADERS_TL set
904: WAVE_NAME = X_WAVE_NAME,
905: WAVE_DESCRIPTION = X_WAVE_DESCRIPTION,
906: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
907: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 922: delete from WMS_WP_WAVE_HEADERS_TL

918: procedure DELETE_ROW (
919: X_WAVE_HEADER_ID in NUMBER
920: ) is
921: begin
922: delete from WMS_WP_WAVE_HEADERS_TL
923: where WAVE_HEADER_ID = X_WAVE_HEADER_ID;
924:
925: if (sql%notfound) then
926: raise no_data_found;

Line 940: delete from WMS_WP_WAVE_HEADERS_TL T

936:
937: procedure ADD_LANGUAGE
938: is
939: begin
940: delete from WMS_WP_WAVE_HEADERS_TL T
941: where not exists
942: (select NULL
943: from WMS_WP_WAVE_HEADERS_B B
944: where B.WAVE_HEADER_ID = T.WAVE_HEADER_ID

Line 947: update WMS_WP_WAVE_HEADERS_TL T set (

943: from WMS_WP_WAVE_HEADERS_B B
944: where B.WAVE_HEADER_ID = T.WAVE_HEADER_ID
945: );
946:
947: update WMS_WP_WAVE_HEADERS_TL T set (
948: WAVE_NAME,
949: WAVE_DESCRIPTION
950: ) = (select
951: B.WAVE_NAME,

Line 953: from WMS_WP_WAVE_HEADERS_TL B

949: WAVE_DESCRIPTION
950: ) = (select
951: B.WAVE_NAME,
952: B.WAVE_DESCRIPTION
953: from WMS_WP_WAVE_HEADERS_TL B
954: where B.WAVE_HEADER_ID = T.WAVE_HEADER_ID
955: and B.LANGUAGE = T.SOURCE_LANG)
956: where (
957: T.WAVE_HEADER_ID,

Line 962: from WMS_WP_WAVE_HEADERS_TL SUBB, WMS_WP_WAVE_HEADERS_TL SUBT

958: T.LANGUAGE
959: ) in (select
960: SUBT.WAVE_HEADER_ID,
961: SUBT.LANGUAGE
962: from WMS_WP_WAVE_HEADERS_TL SUBB, WMS_WP_WAVE_HEADERS_TL SUBT
963: where SUBB.WAVE_HEADER_ID = SUBT.WAVE_HEADER_ID
964: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
965: and (SUBB.WAVE_NAME <> SUBT.WAVE_NAME
966: or (SUBB.WAVE_NAME is null and SUBT.WAVE_NAME is not null)

Line 973: insert into WMS_WP_WAVE_HEADERS_TL (

969: or (SUBB.WAVE_DESCRIPTION is null and SUBT.WAVE_DESCRIPTION is not null)
970: or (SUBB.WAVE_DESCRIPTION is not null and SUBT.WAVE_DESCRIPTION is null)
971: ));
972:
973: insert into WMS_WP_WAVE_HEADERS_TL (
974: WAVE_HEADER_ID,
975: WAVE_NAME,
976: WAVE_DESCRIPTION,
977: CREATED_BY,

Line 995: from WMS_WP_WAVE_HEADERS_TL B, FND_LANGUAGES L

991: B.LAST_UPDATE_DATE,
992: B.LAST_UPDATE_LOGIN,
993: L.LANGUAGE_CODE,
994: B.SOURCE_LANG
995: from WMS_WP_WAVE_HEADERS_TL B, FND_LANGUAGES L
996: where L.INSTALLED_FLAG in ('I', 'B')
997: and B.LANGUAGE = userenv('LANG')
998: and not exists
999: (select NULL

Line 1000: from WMS_WP_WAVE_HEADERS_TL T

996: where L.INSTALLED_FLAG in ('I', 'B')
997: and B.LANGUAGE = userenv('LANG')
998: and not exists
999: (select NULL
1000: from WMS_WP_WAVE_HEADERS_TL T
1001: where T.WAVE_HEADER_ID = B.WAVE_HEADER_ID
1002: and T.LANGUAGE = L.LANGUAGE_CODE);
1003: end ADD_LANGUAGE;
1004: