APPS.CS_SR_STATUS_GROUPS_PKG dependencies on CS_SR_STATUS_GROUPS_TL

Line 71: INSERT INTO CS_SR_STATUS_GROUPS_TL (

67: X_LAST_UPDATE_LOGIN,
68: X_OBJECT_VERSION_NUMBER );
69:
70:
71: INSERT INTO CS_SR_STATUS_GROUPS_TL (
72: STATUS_GROUP_ID,
73: GROUP_NAME,
74: DESCRIPTION,
75: LANGUAGE,

Line 96: FROM CS_SR_STATUS_GROUPS_TL T

92: X_LAST_UPDATE_LOGIN
93: FROM FND_LANGUAGES L
94: WHERE L.INSTALLED_FLAG in ('I', 'B')
95: AND NOT EXISTS ( SELECT NULL
96: FROM CS_SR_STATUS_GROUPS_TL T
97: WHERE T.STATUS_GROUP_ID = X_STATUS_GROUP_ID
98: AND T.LANGUAGE = L.LANGUAGE_CODE);
99:
100: open c;

Line 144: from CS_SR_STATUS_GROUPS_TL

140: DESCRIPTION,
141: LANGUAGE,
142: SOURCE_LANG,
143: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
144: from CS_SR_STATUS_GROUPS_TL
145: where STATUS_GROUP_ID = X_STATUS_GROUP_ID
146: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
147: for update of STATUS_GROUP_ID nowait;
148: begin

Line 232: UPDATE CS_SR_STATUS_GROUPS_TL set

228: if (sql%notfound) then
229: raise no_data_found;
230: end if;
231:
232: UPDATE CS_SR_STATUS_GROUPS_TL set
233: GROUP_NAME = X_GROUP_NAME,
234: DESCRIPTION = X_DESCRIPTION,
235: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
236: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 253: delete from CS_SR_STATUS_GROUPS_TL

249: X_STATUS_GROUP_ID IN NUMBER )
250: IS
251: BEGIN
252:
253: delete from CS_SR_STATUS_GROUPS_TL
254: where STATUS_GROUP_ID = X_STATUS_GROUP_ID;
255:
256: if (sql%notfound) then
257: raise no_data_found;

Line 273: delete from CS_SR_STATUS_GROUPS_TL T

269: PROCEDURE ADD_LANGUAGE
270: IS
271: BEGIN
272:
273: delete from CS_SR_STATUS_GROUPS_TL T
274: where not exists ( select NULL
275: from CS_SR_STATUS_GROUPS_B B
276: where B.STATUS_GROUP_ID = T.STATUS_GROUP_ID );
277:

Line 278: update CS_SR_STATUS_GROUPS_TL T

274: where not exists ( select NULL
275: from CS_SR_STATUS_GROUPS_B B
276: where B.STATUS_GROUP_ID = T.STATUS_GROUP_ID );
277:
278: update CS_SR_STATUS_GROUPS_TL T
279: set ( GROUP_NAME,
280: DESCRIPTION
281: ) = ( select B.GROUP_NAME,
282: B.DESCRIPTION

Line 283: from CS_SR_STATUS_GROUPS_TL B

279: set ( GROUP_NAME,
280: DESCRIPTION
281: ) = ( select B.GROUP_NAME,
282: B.DESCRIPTION
283: from CS_SR_STATUS_GROUPS_TL B
284: where B.STATUS_GROUP_ID = T.STATUS_GROUP_ID
285: and B.LANGUAGE = T.SOURCE_LANG)
286: where ( T.STATUS_GROUP_ID, T.LANGUAGE) in ( select SUBT.STATUS_GROUP_ID, SUBT.LANGUAGE
287: from CS_SR_STATUS_GROUPS_TL SUBB,

Line 287: from CS_SR_STATUS_GROUPS_TL SUBB,

283: from CS_SR_STATUS_GROUPS_TL B
284: where B.STATUS_GROUP_ID = T.STATUS_GROUP_ID
285: and B.LANGUAGE = T.SOURCE_LANG)
286: where ( T.STATUS_GROUP_ID, T.LANGUAGE) in ( select SUBT.STATUS_GROUP_ID, SUBT.LANGUAGE
287: from CS_SR_STATUS_GROUPS_TL SUBB,
288: CS_SR_STATUS_GROUPS_TL SUBT
289: where SUBB.STATUS_GROUP_ID = SUBT.STATUS_GROUP_ID
290: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
291: and (SUBB.GROUP_NAME <> SUBT.GROUP_NAME

Line 288: CS_SR_STATUS_GROUPS_TL SUBT

284: where B.STATUS_GROUP_ID = T.STATUS_GROUP_ID
285: and B.LANGUAGE = T.SOURCE_LANG)
286: where ( T.STATUS_GROUP_ID, T.LANGUAGE) in ( select SUBT.STATUS_GROUP_ID, SUBT.LANGUAGE
287: from CS_SR_STATUS_GROUPS_TL SUBB,
288: CS_SR_STATUS_GROUPS_TL SUBT
289: where SUBB.STATUS_GROUP_ID = SUBT.STATUS_GROUP_ID
290: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
291: and (SUBB.GROUP_NAME <> SUBT.GROUP_NAME
292: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 300: INSERT INTO CS_SR_STATUS_GROUPS_TL (

296: or SUBB.SOURCE_LANG <> SUBT.SOURCE_LANG
297: ));
298:
299:
300: INSERT INTO CS_SR_STATUS_GROUPS_TL (
301: STATUS_GROUP_ID,
302: GROUP_NAME,
303: DESCRIPTION,
304: LANGUAGE,

Line 322: FROM CS_SR_STATUS_GROUPS_TL B,

318: B.CREATED_BY,
319: B.LAST_UPDATE_DATE,
320: B.LAST_UPDATED_BY,
321: B.LAST_UPDATE_LOGIN
322: FROM CS_SR_STATUS_GROUPS_TL B,
323: FND_LANGUAGES L
324: WHERE L.INSTALLED_FLAG in ('I', 'B')
325: AND B.LANGUAGE = userenv('LANG')
326: AND NOT EXISTS ( select NULL

Line 327: from CS_SR_STATUS_GROUPS_TL T

323: FND_LANGUAGES L
324: WHERE L.INSTALLED_FLAG in ('I', 'B')
325: AND B.LANGUAGE = userenv('LANG')
326: AND NOT EXISTS ( select NULL
327: from CS_SR_STATUS_GROUPS_TL T
328: where T.STATUS_GROUP_ID = B.STATUS_GROUP_ID
329: and T.LANGUAGE = L.LANGUAGE_CODE);
330: END ADD_LANGUAGE;
331:

Line 406: UPDATE cs_sr_status_groups_tl

402: P_DESCRIPTION IN VARCHAR2,
403: P_OWNER IN VARCHAR2 )
404: IS
405: BEGIN
406: UPDATE cs_sr_status_groups_tl
407: SET group_name = p_group_name,
408: description = NVL(p_description,description),
409: last_update_date = sysdate,
410: last_updated_by = DECODE(p_owner, 'SEED', 1, 0),