APPS.CS_SR_ACTION_CODES_PKG dependencies on CS_SR_ACTION_CODES_TL

Line 59: insert into CS_SR_ACTION_CODES_TL (

55: P_LAST_UPDATED_BY,
56: P_LAST_UPDATE_LOGIN
57: ) ;
58:
59: insert into CS_SR_ACTION_CODES_TL (
60: NAME,
61: DESCRIPTION,
62: CREATION_DATE,
63: CREATED_BY,

Line 85: from CS_SR_ACTION_CODES_TL T

81: from FND_LANGUAGES L
82: where L.INSTALLED_FLAG in ('I', 'B')
83: and not exists
84: (select NULL
85: from CS_SR_ACTION_CODES_TL T
86: where T.ACTION_CODE = PX_ACTION_CODE
87: and T.LANGUAGE = L.LANGUAGE_CODE);
88:
89: X_OBJECT_VERSION_NUMBER := l_object_Version_number;

Line 165: update CS_SR_ACTION_CODES_TL set

161: if (sql%notfound) then
162: raise no_data_found;
163: end if;
164:
165: update CS_SR_ACTION_CODES_TL set
166: NAME = P_NAME,
167: DESCRIPTION = P_DESCRIPTION,
168: LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,
169: LAST_UPDATED_BY = P_LAST_UPDATED_BY,

Line 184: delete from CS_SR_ACTION_CODES_TL

180: procedure DELETE_ROW (
181: P_ACTION_CODE in VARCHAR2
182: ) is
183: begin
184: delete from CS_SR_ACTION_CODES_TL
185: where ACTION_CODE = P_ACTION_CODE;
186:
187: if (sql%notfound) then
188: raise no_data_found;

Line 202: delete from CS_SR_ACTION_CODES_TL T

198:
199: procedure ADD_LANGUAGE
200: is
201: begin
202: delete from CS_SR_ACTION_CODES_TL T
203: where not exists
204: (select NULL
205: from CS_SR_ACTION_CODES_B B
206: where B.ACTION_CODE = T.ACTION_CODE

Line 209: update CS_SR_ACTION_CODES_TL T set (

205: from CS_SR_ACTION_CODES_B B
206: where B.ACTION_CODE = T.ACTION_CODE
207: );
208:
209: update CS_SR_ACTION_CODES_TL T set (
210: NAME,
211: DESCRIPTION
212: ) = (select
213: B.NAME,

Line 215: from CS_SR_ACTION_CODES_TL B

211: DESCRIPTION
212: ) = (select
213: B.NAME,
214: B.DESCRIPTION
215: from CS_SR_ACTION_CODES_TL B
216: where B.ACTION_CODE = T.ACTION_CODE
217: and B.LANGUAGE = T.SOURCE_LANG)
218: where (
219: T.ACTION_CODE,

Line 224: from CS_SR_ACTION_CODES_TL SUBB, CS_SR_ACTION_CODES_TL SUBT

220: T.LANGUAGE
221: ) in (select
222: SUBT.ACTION_CODE,
223: SUBT.LANGUAGE
224: from CS_SR_ACTION_CODES_TL SUBB, CS_SR_ACTION_CODES_TL SUBT
225: where SUBB.ACTION_CODE = SUBT.ACTION_CODE
226: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
227: and (SUBB.NAME <> SUBT.NAME
228: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 233: insert into CS_SR_ACTION_CODES_TL (

229: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
230: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
231: ));
232:
233: insert into CS_SR_ACTION_CODES_TL (
234: NAME,
235: DESCRIPTION,
236: CREATION_DATE,
237: CREATED_BY,

Line 255: from CS_SR_ACTION_CODES_TL B, FND_LANGUAGES L

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

Line 260: from CS_SR_ACTION_CODES_TL T

256: where L.INSTALLED_FLAG in ('I', 'B')
257: and B.LANGUAGE = userenv('LANG')
258: and not exists
259: (select NULL
260: from CS_SR_ACTION_CODES_TL T
261: where T.ACTION_CODE = B.ACTION_CODE
262: and T.LANGUAGE = L.LANGUAGE_CODE);
263: end ADD_LANGUAGE;
264:

Line 365: update CS_SR_ACTION_CODES_TL set

361: else
362: l_user_id := 0;
363: end if;
364:
365: update CS_SR_ACTION_CODES_TL set
366: name = nvl(x_name,name),
367: description = nvl(x_description,name),
368: last_update_date = nvl(x_last_update_date,sysdate),
369: last_updated_by = l_user_id,