APPS.BSC_SYS_LABELS_PKG dependencies on BSC_SYS_LABELS_TL

Line 38: insert into BSC_SYS_LABELS_TL (

34: X_FONT_SIZE,
35: X_FONT_STYLE
36: );
37:
38: insert into BSC_SYS_LABELS_TL (
39: SOURCE_TYPE,
40: SOURCE_CODE,
41: LABEL_ID,
42: NAME,

Line 56: from BSC_SYS_LABELS_TL T

52: from FND_LANGUAGES L
53: where L.INSTALLED_FLAG in ('I', 'B')
54: and not exists
55: (select NULL
56: from BSC_SYS_LABELS_TL T
57: where T.SOURCE_TYPE = X_SOURCE_TYPE
58: and T.SOURCE_CODE = X_SOURCE_CODE
59: and T.LABEL_ID = X_LABEL_ID
60: and T.LANGUAGE = L.LANGUAGE_CODE);

Line 97: from BSC_SYS_LABELS_TL

93:
94: cursor c1 is select
95: NAME,
96: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
97: from BSC_SYS_LABELS_TL
98: where SOURCE_TYPE = X_SOURCE_TYPE
99: and SOURCE_CODE = X_SOURCE_CODE
100: and LABEL_ID = X_LABEL_ID
101: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)

Line 165: update BSC_SYS_LABELS_TL set

161: if (sql%notfound) then
162: raise no_data_found;
163: end if;
164:
165: update BSC_SYS_LABELS_TL set
166: NAME = X_NAME,
167: SOURCE_LANG = userenv('LANG')
168: where SOURCE_TYPE = X_SOURCE_TYPE
169: and SOURCE_CODE = X_SOURCE_CODE

Line 184: delete from BSC_SYS_LABELS_TL

180: X_SOURCE_CODE in NUMBER,
181: X_LABEL_ID in NUMBER
182: ) is
183: begin
184: delete from BSC_SYS_LABELS_TL
185: where SOURCE_TYPE = X_SOURCE_TYPE
186: and SOURCE_CODE = X_SOURCE_CODE
187: and LABEL_ID = X_LABEL_ID;
188:

Line 206: delete from BSC_SYS_LABELS_TL T

202:
203: procedure ADD_LANGUAGE
204: is
205: begin
206: delete from BSC_SYS_LABELS_TL T
207: where not exists
208: (select NULL
209: from BSC_SYS_LABELS_B B
210: where B.SOURCE_TYPE = T.SOURCE_TYPE

Line 215: update BSC_SYS_LABELS_TL T set (

211: and B.SOURCE_CODE = T.SOURCE_CODE
212: and B.LABEL_ID = T.LABEL_ID
213: );
214:
215: update BSC_SYS_LABELS_TL T set (
216: NAME
217: ) = (select
218: B.NAME
219: from BSC_SYS_LABELS_TL B

Line 219: from BSC_SYS_LABELS_TL B

215: update BSC_SYS_LABELS_TL T set (
216: NAME
217: ) = (select
218: B.NAME
219: from BSC_SYS_LABELS_TL B
220: where B.SOURCE_TYPE = T.SOURCE_TYPE
221: and B.SOURCE_CODE = T.SOURCE_CODE
222: and B.LABEL_ID = T.LABEL_ID
223: and B.LANGUAGE = T.SOURCE_LANG)

Line 234: from BSC_SYS_LABELS_TL SUBB, BSC_SYS_LABELS_TL SUBT

230: SUBT.SOURCE_TYPE,
231: SUBT.SOURCE_CODE,
232: SUBT.LABEL_ID,
233: SUBT.LANGUAGE
234: from BSC_SYS_LABELS_TL SUBB, BSC_SYS_LABELS_TL SUBT
235: where SUBB.SOURCE_TYPE = SUBT.SOURCE_TYPE
236: and SUBB.SOURCE_CODE = SUBT.SOURCE_CODE
237: and SUBB.LABEL_ID = SUBT.LABEL_ID
238: and SUBB.LANGUAGE = SUBT.SOURCE_LANG

Line 242: insert into BSC_SYS_LABELS_TL (

238: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
239: and (SUBB.NAME <> SUBT.NAME
240: ));
241:
242: insert into BSC_SYS_LABELS_TL (
243: SOURCE_TYPE,
244: SOURCE_CODE,
245: LABEL_ID,
246: NAME,

Line 256: from BSC_SYS_LABELS_TL B, FND_LANGUAGES L

252: B.LABEL_ID,
253: B.NAME,
254: L.LANGUAGE_CODE,
255: B.SOURCE_LANG
256: from BSC_SYS_LABELS_TL B, FND_LANGUAGES L
257: where L.INSTALLED_FLAG in ('I', 'B')
258: and B.LANGUAGE = userenv('LANG')
259: and not exists
260: (select NULL

Line 261: from BSC_SYS_LABELS_TL T

257: where L.INSTALLED_FLAG in ('I', 'B')
258: and B.LANGUAGE = userenv('LANG')
259: and not exists
260: (select NULL
261: from BSC_SYS_LABELS_TL T
262: where T.SOURCE_TYPE = B.SOURCE_TYPE
263: and T.SOURCE_CODE = B.SOURCE_CODE
264: and T.LABEL_ID = B.LABEL_ID
265: and T.LANGUAGE = L.LANGUAGE_CODE);