APPS.CSD_RETURN_RULES_PKG dependencies on CSD_RETURN_RULES_TL

Line 49: insert into CSD_RETURN_RULES_TL (

45: X_LAST_UPDATED_BY,
46: X_LAST_UPDATE_LOGIN
47: );
48:
49: insert into CSD_RETURN_RULES_TL (
50: NAME,
51: DESCRIPTION,
52: CREATION_DATE,
53: CREATED_BY,

Line 75: from CSD_RETURN_RULES_TL T

71: from FND_LANGUAGES L
72: where L.INSTALLED_FLAG in ('I', 'B')
73: and not exists
74: (select NULL
75: from CSD_RETURN_RULES_TL T
76: where T.RULE_ID = X_RULE_ID
77: and T.LANGUAGE = L.LANGUAGE_CODE);
78:
79: open c;

Line 114: from CSD_RETURN_RULES_TL

110: cursor c1 is select
111: NAME,
112: DESCRIPTION,
113: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
114: from CSD_RETURN_RULES_TL
115: where RULE_ID = X_RULE_ID
116: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
117: for update of RULE_ID nowait;
118: begin

Line 186: update CSD_RETURN_RULES_TL set

182: if (sql%notfound) then
183: raise no_data_found;
184: end if;
185:
186: update CSD_RETURN_RULES_TL set
187: NAME = X_NAME,
188: DESCRIPTION = X_DESCRIPTION,
189: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
190: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 205: delete from CSD_RETURN_RULES_TL

201: procedure DELETE_ROW (
202: X_RULE_ID in NUMBER
203: ) is
204: begin
205: delete from CSD_RETURN_RULES_TL
206: where RULE_ID = X_RULE_ID;
207:
208: if (sql%notfound) then
209: raise no_data_found;

Line 223: delete from CSD_RETURN_RULES_TL T

219:
220: procedure ADD_LANGUAGE
221: is
222: begin
223: delete from CSD_RETURN_RULES_TL T
224: where not exists
225: (select NULL
226: from CSD_RETURN_RULES_B B
227: where B.RULE_ID = T.RULE_ID

Line 230: update CSD_RETURN_RULES_TL T set (

226: from CSD_RETURN_RULES_B B
227: where B.RULE_ID = T.RULE_ID
228: );
229:
230: update CSD_RETURN_RULES_TL T set (
231: NAME,
232: DESCRIPTION
233: ) = (select
234: B.NAME,

Line 236: from CSD_RETURN_RULES_TL B

232: DESCRIPTION
233: ) = (select
234: B.NAME,
235: B.DESCRIPTION
236: from CSD_RETURN_RULES_TL B
237: where B.RULE_ID = T.RULE_ID
238: and B.LANGUAGE = T.SOURCE_LANG)
239: where (
240: T.RULE_ID,

Line 245: from CSD_RETURN_RULES_TL SUBB, CSD_RETURN_RULES_TL SUBT

241: T.LANGUAGE
242: ) in (select
243: SUBT.RULE_ID,
244: SUBT.LANGUAGE
245: from CSD_RETURN_RULES_TL SUBB, CSD_RETURN_RULES_TL SUBT
246: where SUBB.RULE_ID = SUBT.RULE_ID
247: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
248: and (SUBB.NAME <> SUBT.NAME
249: or (SUBB.NAME is null and SUBT.NAME is not null)

Line 256: insert into CSD_RETURN_RULES_TL (

252: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
253: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
254: ));
255:
256: insert into CSD_RETURN_RULES_TL (
257: NAME,
258: DESCRIPTION,
259: CREATION_DATE,
260: CREATED_BY,

Line 278: from CSD_RETURN_RULES_TL B, FND_LANGUAGES L

274: B.LAST_UPDATE_LOGIN,
275: B.RULE_ID,
276: L.LANGUAGE_CODE,
277: B.SOURCE_LANG
278: from CSD_RETURN_RULES_TL B, FND_LANGUAGES L
279: where L.INSTALLED_FLAG in ('I', 'B')
280: and B.LANGUAGE = userenv('LANG')
281: and not exists
282: (select NULL

Line 283: from CSD_RETURN_RULES_TL T

279: where L.INSTALLED_FLAG in ('I', 'B')
280: and B.LANGUAGE = userenv('LANG')
281: and not exists
282: (select NULL
283: from CSD_RETURN_RULES_TL T
284: where T.RULE_ID = B.RULE_ID
285: and T.LANGUAGE = L.LANGUAGE_CODE);
286: end ADD_LANGUAGE;
287: