APPS.CSC_PROF_GROUPS_PKG dependencies on CSC_PROF_GROUPS_TL

Line 100: INSERT INTO CSC_PROF_GROUPS_TL(

96:
97: -- assign the object version number to the out parameter
98: x_object_version_number := l_object_version_number;
99:
100: INSERT INTO CSC_PROF_GROUPS_TL(
101: GROUP_ID,
102: GROUP_NAME,
103: DESCRIPTION,
104: CREATED_BY,

Line 126: from CSC_PROF_GROUPS_TL T

122: from FND_LANGUAGES L
123: where L.INSTALLED_FLAG in ('I', 'B')
124: and not exists
125: (select NULL
126: from CSC_PROF_GROUPS_TL T
127: where T.GROUP_ID = Px_GROUP_ID
128: and T.LANGUAGE = L.LANGUAGE_CODE);
129:
130: End Insert_Row;

Line 165: Update CSC_PROF_GROUPS_TL

161: APPLICATION_ID = p_APPLICATION_ID
162: where GROUP_ID = p_GROUP_ID
163: RETURNING OBJECT_VERSION_NUMBER INTO px_OBJECT_VERSION_NUMBER;
164:
165: Update CSC_PROF_GROUPS_TL
166: SET
167: GROUP_NAME = p_GROUP_NAME,
168: DESCRIPTION = p_DESCRIPTION,
169: LAST_UPDATED_BY = p_LAST_UPDATED_BY,

Line 195: DELETE FROM CSC_PROF_GROUPS_TL

191: RAISE NO_DATA_FOUND;
192: End If;
193:
194:
195: DELETE FROM CSC_PROF_GROUPS_TL
196: WHERE GROUP_ID = p_GROUP_ID;
197: If (SQL%NOTFOUND) then
198: RAISE NO_DATA_FOUND;
199: End If;

Line 224: from CSC_PROF_GROUPS_TL

220:
221: cursor c1 is select
222: GROUP_NAME,
223: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
224: from CSC_PROF_GROUPS_TL
225: where GROUP_ID = P_GROUP_ID
226: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
227: for update of GROUP_ID nowait;
228: begin

Line 243: delete from CSC_PROF_GROUPS_TL T

239:
240: procedure ADD_LANGUAGE
241: is
242: begin
243: delete from CSC_PROF_GROUPS_TL T
244: where not exists
245: (select NULL
246: from CSC_PROF_GROUPS_B B
247: where B.GROUP_ID = T.GROUP_ID

Line 250: update CSC_PROF_GROUPS_TL T set (

246: from CSC_PROF_GROUPS_B B
247: where B.GROUP_ID = T.GROUP_ID
248: );
249:
250: update CSC_PROF_GROUPS_TL T set (
251: GROUP_NAME,
252: DESCRIPTION
253: ) = (select
254: B.GROUP_NAME,

Line 256: from CSC_PROF_GROUPS_TL B

252: DESCRIPTION
253: ) = (select
254: B.GROUP_NAME,
255: B.DESCRIPTION
256: from CSC_PROF_GROUPS_TL B
257: where B.GROUP_ID = T.GROUP_ID
258: and B.LANGUAGE = T.SOURCE_LANG)
259: where (
260: T.GROUP_ID,

Line 265: from CSC_PROF_GROUPS_TL SUBB, CSC_PROF_GROUPS_TL SUBT

261: T.LANGUAGE
262: ) in (select
263: SUBT.GROUP_ID,
264: SUBT.LANGUAGE
265: from CSC_PROF_GROUPS_TL SUBB, CSC_PROF_GROUPS_TL SUBT
266: where SUBB.GROUP_ID = SUBT.GROUP_ID
267: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
268: and (SUBB.GROUP_NAME <> SUBT.GROUP_NAME
269: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 274: insert into CSC_PROF_GROUPS_TL (

270: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
271: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
272: ));
273:
274: insert into CSC_PROF_GROUPS_TL (
275: GROUP_ID,
276: GROUP_NAME,
277: DESCRIPTION,
278: CREATED_BY,

Line 296: from CSC_PROF_GROUPS_TL B, FND_LANGUAGES L

292: B.LAST_UPDATE_DATE,
293: B.LAST_UPDATE_LOGIN,
294: L.LANGUAGE_CODE,
295: B.SOURCE_LANG
296: from CSC_PROF_GROUPS_TL B, FND_LANGUAGES L
297: where L.INSTALLED_FLAG in ('I', 'B')
298: and B.LANGUAGE = userenv('LANG')
299: and not exists
300: (select NULL

Line 301: from CSC_PROF_GROUPS_TL T

297: where L.INSTALLED_FLAG in ('I', 'B')
298: and B.LANGUAGE = userenv('LANG')
299: and not exists
300: (select NULL
301: from CSC_PROF_GROUPS_TL T
302: where T.GROUP_ID = B.GROUP_ID
303: and T.LANGUAGE = L.LANGUAGE_CODE);
304: end ADD_LANGUAGE;
305:

Line 314: update csc_prof_groups_tl

310: p_description IN VARCHAR2,
311: p_owner IN VARCHAR2 )
312: IS
313: BEGIN
314: update csc_prof_groups_tl
315: set group_name = p_group_name,
316: description = nvl(p_description, description),
317: last_update_date = sysdate,
318: last_updated_by = fnd_load_util.owner_id(p_owner),