APPS.BOM_STRUCTURE_TYPES_PKG dependencies on BOM_STRUCTURE_TYPES_TL

Line 54: UPDATE BOM_STRUCTURE_TYPES_TL

50: BEGIN
51: IF (X_Upload_mode = 'NLS')
52: THEN
53:
54: UPDATE BOM_STRUCTURE_TYPES_TL
55: SET
56: DISPLAY_NAME = X_Display_Name,
57: DESCRIPTION = X_Description,
58: LAST_UPDATE_DATE = X_Last_Update_Date,

Line 165: INSERT INTO BOM_STRUCTURE_TYPES_TL

161: WHERE NOT EXISTS (SELECT 1 from BOM_STRUCTURE_TYPES_B
162: WHERE STRUCTURE_TYPE_NAME = X_Structure_Type_Name );
163:
164:
165: INSERT INTO BOM_STRUCTURE_TYPES_TL
166: ( STRUCTURE_TYPE_ID,
167: LANGUAGE,
168: SOURCE_LANG,
169: DISPLAY_NAME,

Line 191: (SELECT NULL FROM BOM_STRUCTURE_TYPES_TL TL,BOM_STRUCTURE_TYPES_B B

187: X_Last_Update_Login
188: FROM FND_LANGUAGES L
189: WHERE L.INSTALLED_FLAG IN ('I','B')
190: AND NOT EXISTS
191: (SELECT NULL FROM BOM_STRUCTURE_TYPES_TL TL,BOM_STRUCTURE_TYPES_B B
192: WHERE B.STRUCTURE_TYPE_ID = TL.STRUCTURE_TYPE_ID
193: AND B.STRUCTURE_TYPE_NAME = X_Structure_Type_Name
194: AND TL.LANGUAGE = L.LANGUAGE_CODE);
195:

Line 234: UPDATE BOM_STRUCTURE_TYPES_TL

230: WHERE
231: STRUCTURE_TYPE_NAME = X_Structure_Type_Name;
232:
233:
234: UPDATE BOM_STRUCTURE_TYPES_TL
235: SET
236: DISPLAY_NAME = X_Display_Name,
237: DESCRIPTION = X_Description,
238: LAST_UPDATE_DATE = X_Last_Update_Date,

Line 259: INSERT INTO BOM_STRUCTURE_TYPES_TL

255:
256: PROCEDURE ADD_LANGUAGE
257: IS
258: BEGIN
259: INSERT INTO BOM_STRUCTURE_TYPES_TL
260: (
261: STRUCTURE_TYPE_ID,
262: LANGUAGE,
263: SOURCE_LANG,

Line 284: BOM_STRUCTURE_TYPES_TL B

280: SYSDATE,
281: B.CREATED_BY,
282: B.LAST_UPDATE_LOGIN
283: FROM FND_LANGUAGES L,
284: BOM_STRUCTURE_TYPES_TL B
285: WHERE L.INSTALLED_FLAG IN ('I','B')
286: AND NOT EXISTS
287: (SELECT NULL FROM BOM_STRUCTURE_TYPES_TL TL
288: WHERE TL.STRUCTURE_TYPE_ID = B.STRUCTURE_TYPE_ID

Line 287: (SELECT NULL FROM BOM_STRUCTURE_TYPES_TL TL

283: FROM FND_LANGUAGES L,
284: BOM_STRUCTURE_TYPES_TL B
285: WHERE L.INSTALLED_FLAG IN ('I','B')
286: AND NOT EXISTS
287: (SELECT NULL FROM BOM_STRUCTURE_TYPES_TL TL
288: WHERE TL.STRUCTURE_TYPE_ID = B.STRUCTURE_TYPE_ID
289: AND TL.LANGUAGE = L.LANGUAGE_CODE);
290:
291: END ADD_LANGUAGE;

Line 402: insert into BOM_STRUCTURE_TYPES_TL (

398: X_ENABLE_UNIMPLEMENTED_BOMS,
399: X_ALLOW_SUBTYPES
400: );
401:
402: insert into BOM_STRUCTURE_TYPES_TL (
403: LAST_UPDATE_LOGIN,
404: STRUCTURE_TYPE_ID,
405: CREATED_BY,
406: LAST_UPDATED_BY,

Line 428: from BOM_STRUCTURE_TYPES_TL T

424: from FND_LANGUAGES L
425: where L.INSTALLED_FLAG in ('I', 'B')
426: and not exists
427: (select NULL
428: from BOM_STRUCTURE_TYPES_TL T
429: where T.STRUCTURE_TYPE_ID = X_STRUCTURE_TYPE_ID
430: and T.LANGUAGE = L.LANGUAGE_CODE);
431:
432: open c;

Line 507: from BOM_STRUCTURE_TYPES_TL

503: cursor c1 is select
504: DISPLAY_NAME,
505: DESCRIPTION,
506: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
507: from BOM_STRUCTURE_TYPES_TL
508: where STRUCTURE_TYPE_ID = X_STRUCTURE_TYPE_ID
509: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
510: for update of STRUCTURE_TYPE_ID nowait;
511: begin

Line 660: update BOM_STRUCTURE_TYPES_TL set

656: if (sql%notfound) then
657: raise no_data_found;
658: end if;
659:
660: update BOM_STRUCTURE_TYPES_TL set
661: DISPLAY_NAME = X_DISPLAY_NAME,
662: DESCRIPTION = X_DESCRIPTION,
663: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
664: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 679: delete from BOM_STRUCTURE_TYPES_TL

675: procedure DELETE_ROW (
676: X_STRUCTURE_TYPE_ID in NUMBER
677: ) is
678: begin
679: delete from BOM_STRUCTURE_TYPES_TL
680: where STRUCTURE_TYPE_ID = X_STRUCTURE_TYPE_ID;
681:
682: if (sql%notfound) then
683: raise no_data_found;

Line 697: delete from BOM_STRUCTURE_TYPES_TL T

693:
694: procedure ADD_LANGUAGE
695: is
696: begin
697: delete from BOM_STRUCTURE_TYPES_TL T
698: where not exists
699: (select NULL
700: from BOM_STRUCTURE_TYPES_B B
701: where B.STRUCTURE_TYPE_ID = T.STRUCTURE_TYPE_ID

Line 704: update BOM_STRUCTURE_TYPES_TL T set (

700: from BOM_STRUCTURE_TYPES_B B
701: where B.STRUCTURE_TYPE_ID = T.STRUCTURE_TYPE_ID
702: );
703:
704: update BOM_STRUCTURE_TYPES_TL T set (
705: DISPLAY_NAME,
706: DESCRIPTION
707: ) = (select
708: B.DISPLAY_NAME,

Line 710: from BOM_STRUCTURE_TYPES_TL B

706: DESCRIPTION
707: ) = (select
708: B.DISPLAY_NAME,
709: B.DESCRIPTION
710: from BOM_STRUCTURE_TYPES_TL B
711: where B.STRUCTURE_TYPE_ID = T.STRUCTURE_TYPE_ID
712: and B.LANGUAGE = T.SOURCE_LANG)
713: where (
714: T.STRUCTURE_TYPE_ID,

Line 719: from BOM_STRUCTURE_TYPES_TL SUBB, BOM_STRUCTURE_TYPES_TL SUBT

715: T.LANGUAGE
716: ) in (select
717: SUBT.STRUCTURE_TYPE_ID,
718: SUBT.LANGUAGE
719: from BOM_STRUCTURE_TYPES_TL SUBB, BOM_STRUCTURE_TYPES_TL SUBT
720: where SUBB.STRUCTURE_TYPE_ID = SUBT.STRUCTURE_TYPE_ID
721: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
722: and (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME
723: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 728: insert into BOM_STRUCTURE_TYPES_TL (

724: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
725: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
726: ));
727:
728: insert into BOM_STRUCTURE_TYPES_TL (
729: CREATED_BY,
730: LAST_UPDATED_BY,
731: CREATION_DATE,
732: LAST_UPDATE_DATE,

Line 750: from BOM_STRUCTURE_TYPES_TL B, FND_LANGUAGES L

746: B.LAST_UPDATE_LOGIN,
747: B.STRUCTURE_TYPE_ID,
748: L.LANGUAGE_CODE,
749: B.SOURCE_LANG
750: from BOM_STRUCTURE_TYPES_TL B, FND_LANGUAGES L
751: where L.INSTALLED_FLAG in ('I', 'B')
752: and B.LANGUAGE = userenv('LANG')
753: and not exists
754: (select NULL

Line 755: from BOM_STRUCTURE_TYPES_TL T

751: where L.INSTALLED_FLAG in ('I', 'B')
752: and B.LANGUAGE = userenv('LANG')
753: and not exists
754: (select NULL
755: from BOM_STRUCTURE_TYPES_TL T
756: where T.STRUCTURE_TYPE_ID = B.STRUCTURE_TYPE_ID
757: and T.LANGUAGE = L.LANGUAGE_CODE);
758: end ADD_LANGUAGE;
759: