APPS.CSP_BUSINESS_RULES_PKG dependencies on CSP_BUSINESS_RULES_TL

Line 161: insert into CSP_BUSINESS_RULES_TL (

157: p_ATTRIBUTE13,
158: p_ATTRIBUTE14,
159: p_ATTRIBUTE15);
160:
161: insert into CSP_BUSINESS_RULES_TL (
162: BUSINESS_RULE_ID,
163: CREATED_BY,
164: CREATION_DATE,
165: LAST_UPDATED_BY,

Line 185: from CSP_BUSINESS_RULES_TL T

181: from FND_LANGUAGES L
182: where L.INSTALLED_FLAG in ('I', 'B')
183: and not exists
184: (select NULL
185: from CSP_BUSINESS_RULES_TL T
186: where T.BUSINESS_RULE_ID = pX_BUSINESS_RULE_ID
187: and T.LANGUAGE = L.LANGUAGE_CODE);
188:
189: End Insert_Row;

Line 290: update CSP_BUSINESS_RULES_TL set

286: if (sql%notfound) then
287: raise no_data_found;
288: end if;
289:
290: update CSP_BUSINESS_RULES_TL set
291: DESCRIPTION = p_DESCRIPTION,
292: LAST_UPDATE_DATE = p_last_update_DATE,
293: LAST_UPDATED_BY = p_LAST_UPDATED_BY,
294: LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN,

Line 310: delete from CSP_BUSINESS_RULES_TL

306: PROCEDURE Delete_Row(
307: p_BUSINESS_RULE_ID NUMBER)
308: IS
309: BEGIN
310: delete from CSP_BUSINESS_RULES_TL
311: where BUSINESS_RULE_ID = p_BUSINESS_RULE_ID;
312:
313: if (sql%notfound) then
314: raise no_data_found;

Line 380: from CSP_BUSINESS_RULES_TL

376:
377: cursor c1 is select
378: DESCRIPTION,
379: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
380: from CSP_BUSINESS_RULES_TL
381: where BUSINESS_RULE_ID = p_BUSINESS_RULE_ID
382: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
383: for update of BUSINESS_RULE_ID nowait;
384:

Line 554: delete from CSP_BUSINESS_RULES_TL T

550:
551: procedure ADD_LANGUAGE
552: is
553: begin
554: delete from CSP_BUSINESS_RULES_TL T
555: where not exists
556: (select NULL
557: from CSP_BUSINESS_RULES_B B
558: where B.BUSINESS_RULE_ID = T.BUSINESS_RULE_ID

Line 561: update CSP_BUSINESS_RULES_TL T set (

557: from CSP_BUSINESS_RULES_B B
558: where B.BUSINESS_RULE_ID = T.BUSINESS_RULE_ID
559: );
560:
561: update CSP_BUSINESS_RULES_TL T set (
562: DESCRIPTION
563: ) = (select
564: B.DESCRIPTION
565: from CSP_BUSINESS_RULES_TL B

Line 565: from CSP_BUSINESS_RULES_TL B

561: update CSP_BUSINESS_RULES_TL T set (
562: DESCRIPTION
563: ) = (select
564: B.DESCRIPTION
565: from CSP_BUSINESS_RULES_TL B
566: where B.BUSINESS_RULE_ID = T.BUSINESS_RULE_ID
567: and B.LANGUAGE = T.SOURCE_LANG)
568: where (
569: T.BUSINESS_RULE_ID,

Line 574: from CSP_BUSINESS_RULES_TL SUBB, CSP_BUSINESS_RULES_TL SUBT

570: T.LANGUAGE
571: ) in (select
572: SUBT.BUSINESS_RULE_ID,
573: SUBT.LANGUAGE
574: from CSP_BUSINESS_RULES_TL SUBB, CSP_BUSINESS_RULES_TL SUBT
575: where SUBB.BUSINESS_RULE_ID = SUBT.BUSINESS_RULE_ID
576: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
577: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
578: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)

Line 582: insert into CSP_BUSINESS_RULES_TL (

578: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
579: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
580: ));
581:
582: insert into CSP_BUSINESS_RULES_TL (
583: BUSINESS_RULE_ID,
584: CREATED_BY,
585: CREATION_DATE,
586: LAST_UPDATED_BY,

Line 602: from CSP_BUSINESS_RULES_TL B, FND_LANGUAGES L

598: B.LAST_UPDATE_LOGIN,
599: B.DESCRIPTION,
600: L.LANGUAGE_CODE,
601: B.SOURCE_LANG
602: from CSP_BUSINESS_RULES_TL B, FND_LANGUAGES L
603: where L.INSTALLED_FLAG in ('I', 'B')
604: and B.LANGUAGE = userenv('LANG')
605: and not exists
606: (select NULL

Line 607: from CSP_BUSINESS_RULES_TL T

603: where L.INSTALLED_FLAG in ('I', 'B')
604: and B.LANGUAGE = userenv('LANG')
605: and not exists
606: (select NULL
607: from CSP_BUSINESS_RULES_TL T
608: where T.BUSINESS_RULE_ID = B.BUSINESS_RULE_ID
609: and T.LANGUAGE = L.LANGUAGE_CODE);
610: end ADD_LANGUAGE;
611:

Line 625: UPDATE csp_business_rules_tl

621: if p_owner = 'SEED' then
622: l_user_id := 1;
623: end if;
624:
625: UPDATE csp_business_rules_tl
626: SET description = p_description
627: , last_update_date = SYSDATE
628: , last_updated_by = l_user_id
629: , last_update_login = 0