APPS.CSP_LOOP_CALC_RULES_B_PKG dependencies on CSP_LOOP_CALC_RULES_TL

Line 148: insert into CSP_LOOP_CALC_RULES_TL (

144: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
145: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
146: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15));
147:
148: insert into CSP_LOOP_CALC_RULES_TL (
149: CALCULATION_RULE_ID,
150: CREATED_BY,
151: CREATION_DATE,
152: LAST_UPDATED_BY,

Line 172: from CSP_LOOP_CALC_RULES_TL T

168: from FND_LANGUAGES L
169: where L.INSTALLED_FLAG in ('I', 'B')
170: and not exists
171: (select NULL
172: from CSP_LOOP_CALC_RULES_TL T
173: where T.CALCULATION_RULE_ID = px_CALCULATION_RULE_ID
174: and T.LANGUAGE = L.LANGUAGE_CODE);
175:
176: open c3;

Line 276: update CSP_LOOP_CALC_RULES_TL set

272: If (SQL%NOTFOUND) then
273: RAISE NO_DATA_FOUND;
274: End If;
275:
276: update CSP_LOOP_CALC_RULES_TL set
277: DESCRIPTION = p_DESCRIPTION,
278: LAST_UPDATE_DATE = p_LAST_UPDATE_DATE,
279: LAST_UPDATED_BY = p_LAST_UPDATED_BY,
280: LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN,

Line 296: delete from CSP_LOOP_CALC_RULES_TL

292: p_CALCULATION_RULE_ID NUMBER)
293: IS
294: BEGIN
295:
296: delete from CSP_LOOP_CALC_RULES_TL
297: where CALCULATION_RULE_ID = p_CALCULATION_RULE_ID;
298:
299: if (sql%notfound) then
300: raise no_data_found;

Line 362: from CSP_LOOP_CALC_RULES_TL

358:
359: cursor c1 is select
360: DESCRIPTION,
361: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
362: from CSP_LOOP_CALC_RULES_TL
363: where CALCULATION_RULE_ID = p_CALCULATION_RULE_ID
364: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
365: for update of CALCULATION_RULE_ID nowait;
366:

Line 518: delete from CSP_LOOP_CALC_RULES_TL T

514:
515: procedure ADD_LANGUAGE
516: is
517: begin
518: delete from CSP_LOOP_CALC_RULES_TL T
519: where not exists
520: (select NULL
521: from CSP_LOOP_CALC_RULES_B B
522: where B.CALCULATION_RULE_ID = T.CALCULATION_RULE_ID

Line 525: update CSP_LOOP_CALC_RULES_TL T set (

521: from CSP_LOOP_CALC_RULES_B B
522: where B.CALCULATION_RULE_ID = T.CALCULATION_RULE_ID
523: );
524:
525: update CSP_LOOP_CALC_RULES_TL T set (
526: DESCRIPTION
527: ) = (select
528: B.DESCRIPTION
529: from CSP_LOOP_CALC_RULES_TL B

Line 529: from CSP_LOOP_CALC_RULES_TL B

525: update CSP_LOOP_CALC_RULES_TL T set (
526: DESCRIPTION
527: ) = (select
528: B.DESCRIPTION
529: from CSP_LOOP_CALC_RULES_TL B
530: where B.calculation_rule_id = T.calculation_rule_id
531: and B.LANGUAGE = T.SOURCE_LANG)
532: where (
533: T.calculation_rule_id,

Line 538: from CSP_LOOP_CALC_RULES_TL SUBB, CSP_LOOP_CALC_RULES_TL SUBT

534: T.LANGUAGE
535: ) in (select
536: SUBT.calculation_rule_id,
537: SUBT.LANGUAGE
538: from CSP_LOOP_CALC_RULES_TL SUBB, CSP_LOOP_CALC_RULES_TL SUBT
539: where SUBB.calculation_rule_id = SUBT.calculation_rule_id
540: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
541: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
542: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)

Line 546: insert into CSP_LOOP_CALC_RULES_TL (

542: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
543: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
544: ));
545:
546: insert into CSP_LOOP_CALC_RULES_TL (
547: calculation_rule_id,
548: CREATED_BY,
549: CREATION_DATE,
550: LAST_UPDATED_BY,

Line 566: from CSP_LOOP_CALC_RULES_TL B, FND_LANGUAGES L

562: B.LAST_UPDATE_LOGIN,
563: B.DESCRIPTION,
564: L.LANGUAGE_CODE,
565: B.SOURCE_LANG
566: from CSP_LOOP_CALC_RULES_TL B, FND_LANGUAGES L
567: where L.INSTALLED_FLAG in ('I', 'B')
568: and B.LANGUAGE = userenv('LANG')
569: and not exists
570: (select NULL

Line 571: from CSP_LOOP_CALC_RULES_TL T

567: where L.INSTALLED_FLAG in ('I', 'B')
568: and B.LANGUAGE = userenv('LANG')
569: and not exists
570: (select NULL
571: from CSP_LOOP_CALC_RULES_TL T
572: where T.calculation_rule_id = B.calculation_rule_id
573: and T.LANGUAGE = L.LANGUAGE_CODE);
574: end ADD_LANGUAGE;
575:

Line 589: UPDATE csp_loop_calc_rules_tl

585: if p_owner = 'SEED' then
586: l_user_id := 1;
587: end if;
588:
589: UPDATE csp_loop_calc_rules_tl
590: SET description = p_description
591: , last_update_date = SYSDATE
592: , last_updated_by = l_user_id
593: , last_update_login = 0