APPS.BSC_TAB_CSF_PKG dependencies on BSC_TAB_CSF_TL

Line 29: insert into BSC_TAB_CSF_TL (

25: X_CSF_TYPE,
26: X_INTERMEDIATE_FLAG
27: );
28:
29: insert into BSC_TAB_CSF_TL (
30: TAB_ID,
31: CSF_ID,
32: NAME,
33: HELP,

Line 47: from BSC_TAB_CSF_TL T

43: from FND_LANGUAGES L
44: where L.INSTALLED_FLAG in ('I', 'B')
45: and not exists
46: (select NULL
47: from BSC_TAB_CSF_TL T
48: where T.TAB_ID = X_TAB_ID
49: and T.CSF_ID = X_CSF_ID
50: and T.LANGUAGE = L.LANGUAGE_CODE);
51:

Line 83: from BSC_TAB_CSF_TL

79: cursor c1 is select
80: NAME,
81: HELP,
82: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
83: from BSC_TAB_CSF_TL
84: where TAB_ID = X_TAB_ID
85: and CSF_ID = X_CSF_ID
86: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
87: for update of TAB_ID nowait;

Line 143: update BSC_TAB_CSF_TL set

139: if (sql%notfound) then
140: raise no_data_found;
141: end if;
142:
143: update BSC_TAB_CSF_TL set
144: NAME = X_NAME,
145: HELP = X_HELP,
146: SOURCE_LANG = userenv('LANG')
147: where TAB_ID = X_TAB_ID

Line 161: delete from BSC_TAB_CSF_TL

157: X_TAB_ID in NUMBER,
158: X_CSF_ID in NUMBER
159: ) is
160: begin
161: delete from BSC_TAB_CSF_TL
162: where TAB_ID = X_TAB_ID
163: and CSF_ID = X_CSF_ID;
164:
165: if (sql%notfound) then

Line 181: delete from BSC_TAB_CSF_TL T

177:
178: procedure ADD_LANGUAGE
179: is
180: begin
181: delete from BSC_TAB_CSF_TL T
182: where not exists
183: (select NULL
184: from BSC_TAB_CSF_B B
185: where B.TAB_ID = T.TAB_ID

Line 189: update BSC_TAB_CSF_TL T set (

185: where B.TAB_ID = T.TAB_ID
186: and B.CSF_ID = T.CSF_ID
187: );
188:
189: update BSC_TAB_CSF_TL T set (
190: NAME,
191: HELP
192: ) = (select
193: B.NAME,

Line 195: from BSC_TAB_CSF_TL B

191: HELP
192: ) = (select
193: B.NAME,
194: B.HELP
195: from BSC_TAB_CSF_TL B
196: where B.TAB_ID = T.TAB_ID
197: and B.CSF_ID = T.CSF_ID
198: and B.LANGUAGE = T.SOURCE_LANG)
199: where (

Line 207: from BSC_TAB_CSF_TL SUBB, BSC_TAB_CSF_TL SUBT

203: ) in (select
204: SUBT.TAB_ID,
205: SUBT.CSF_ID,
206: SUBT.LANGUAGE
207: from BSC_TAB_CSF_TL SUBB, BSC_TAB_CSF_TL SUBT
208: where SUBB.TAB_ID = SUBT.TAB_ID
209: and SUBB.CSF_ID = SUBT.CSF_ID
210: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
211: and (SUBB.NAME <> SUBT.NAME

Line 219: insert into BSC_TAB_CSF_TL (

215: or (SUBB.HELP is null and SUBT.HELP is not null)
216: or (SUBB.HELP is not null and SUBT.HELP is null)
217: ));
218:
219: insert into BSC_TAB_CSF_TL (
220: TAB_ID,
221: CSF_ID,
222: NAME,
223: HELP,

Line 233: from BSC_TAB_CSF_TL B, FND_LANGUAGES L

229: B.NAME,
230: B.HELP,
231: L.LANGUAGE_CODE,
232: B.SOURCE_LANG
233: from BSC_TAB_CSF_TL B, FND_LANGUAGES L
234: where L.INSTALLED_FLAG in ('I', 'B')
235: and B.LANGUAGE = userenv('LANG')
236: and not exists
237: (select NULL

Line 238: from BSC_TAB_CSF_TL T

234: where L.INSTALLED_FLAG in ('I', 'B')
235: and B.LANGUAGE = userenv('LANG')
236: and not exists
237: (select NULL
238: from BSC_TAB_CSF_TL T
239: where T.TAB_ID = B.TAB_ID
240: and T.CSF_ID = B.CSF_ID
241: and T.LANGUAGE = L.LANGUAGE_CODE);
242: end ADD_LANGUAGE;