APPS.CSP_EXCESS_RULES_B_PKG dependencies on CSP_EXCESS_RULES_TL

Line 117: insert into CSP_EXCESS_RULES_TL (

113: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
114: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
115: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
116: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15));
117: insert into CSP_EXCESS_RULES_TL (
118: EXCESS_RULE_ID,
119: CREATED_BY,
120: CREATION_DATE,
121: LAST_UPDATED_BY,

Line 141: from CSP_EXCESS_RULES_TL T

137: from FND_LANGUAGES L
138: where L.INSTALLED_FLAG in ('I', 'B')
139: and not exists
140: (select NULL
141: from CSP_EXCESS_RULES_TL T
142: where T.EXCESS_RULE_ID = pX_EXCESS_RULE_ID
143: and T.LANGUAGE = L.LANGUAGE_CODE);
144:
145: End Insert_Row;

Line 218: update CSP_EXCESS_RULES_TL set

214: If (SQL%NOTFOUND) then
215: RAISE NO_DATA_FOUND;
216: End If;
217:
218: update CSP_EXCESS_RULES_TL set
219: DESCRIPTION = p_DESCRIPTION,
220: LAST_UPDATE_DATE = p_last_update_DATE,
221: LAST_UPDATED_BY = p_LAST_UPDATED_BY,
222: LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN,

Line 241: DELETE FROM CSP_EXCESS_RULES_TL

237: WHERE EXCESS_RULE_ID = p_EXCESS_RULE_ID;
238: If (SQL%NOTFOUND) then
239: RAISE NO_DATA_FOUND;
240: End If;
241: DELETE FROM CSP_EXCESS_RULES_TL
242: WHERE EXCESS_RULE_ID = p_EXCESS_RULE_ID;
243: If (SQL%NOTFOUND) then
244: RAISE NO_DATA_FOUND;
245: End If;

Line 289: from CSP_EXCESS_RULES_TL

285: FOR UPDATE of EXCESS_RULE_ID NOWAIT;
286: CURSOR c1 is select
287: DESCRIPTION,
288: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
289: from CSP_EXCESS_RULES_TL
290: where EXCESS_RULE_ID = p_EXCESS_RULE_ID
291: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
292: for update of EXCESS_RULE_ID nowait;
293:

Line 416: delete from CSP_EXCESS_RULES_TL T

412: END Lock_Row;
413: procedure ADD_LANGUAGE
414: is
415: begin
416: delete from CSP_EXCESS_RULES_TL T
417: where not exists
418: (select NULL
419: from CSP_EXCESS_RULES_B B
420: where B.EXCESS_RULE_ID = T.EXCESS_RULE_ID

Line 423: update CSP_EXCESS_RULES_TL T set (

419: from CSP_EXCESS_RULES_B B
420: where B.EXCESS_RULE_ID = T.EXCESS_RULE_ID
421: );
422:
423: update CSP_EXCESS_RULES_TL T set (
424: DESCRIPTION
425: ) = (select
426: B.DESCRIPTION
427: from CSP_EXCESS_RULES_TL B

Line 427: from CSP_EXCESS_RULES_TL B

423: update CSP_EXCESS_RULES_TL T set (
424: DESCRIPTION
425: ) = (select
426: B.DESCRIPTION
427: from CSP_EXCESS_RULES_TL B
428: where B.EXCESS_RULE_ID = T.EXCESS_RULE_ID
429: and B.LANGUAGE = T.SOURCE_LANG)
430: where (
431: T.EXCESS_RULE_ID,

Line 436: from CSP_EXCESS_RULES_TL SUBB, CSP_EXCESS_RULES_TL SUBT

432: T.LANGUAGE
433: ) in (select
434: SUBT.EXCESS_RULE_ID,
435: SUBT.LANGUAGE
436: from CSP_EXCESS_RULES_TL SUBB, CSP_EXCESS_RULES_TL SUBT
437: where SUBB.EXCESS_RULE_ID = SUBT.EXCESS_RULE_ID
438: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
439: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
440: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)

Line 444: insert into CSP_EXCESS_RULES_TL (

440: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
441: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
442: ));
443:
444: insert into CSP_EXCESS_RULES_TL (
445: EXCESS_RULE_ID,
446: CREATED_BY,
447: CREATION_DATE,
448: LAST_UPDATED_BY,

Line 464: from CSP_EXCESS_RULES_TL B, FND_LANGUAGES L

460: B.LAST_UPDATE_LOGIN,
461: B.DESCRIPTION,
462: L.LANGUAGE_CODE,
463: B.SOURCE_LANG
464: from CSP_EXCESS_RULES_TL B, FND_LANGUAGES L
465: where L.INSTALLED_FLAG in ('I', 'B')
466: and B.LANGUAGE = userenv('LANG')
467: and not exists
468: (select NULL

Line 469: from CSP_EXCESS_RULES_TL T

465: where L.INSTALLED_FLAG in ('I', 'B')
466: and B.LANGUAGE = userenv('LANG')
467: and not exists
468: (select NULL
469: from CSP_EXCESS_RULES_TL T
470: where T.EXCESS_RULE_ID = B.EXCESS_RULE_ID
471: and T.LANGUAGE = L.LANGUAGE_CODE);
472: end ADD_LANGUAGE;
473:

Line 487: UPDATE csp_excess_rules_tl

483: if p_owner = 'SEED' then
484: l_user_id := 1;
485: end if;
486:
487: UPDATE csp_excess_rules_tl
488: SET description = p_description
489: , last_update_date = SYSDATE
490: , last_updated_by = l_user_id
491: , last_update_login = 0