APPS.CSP_FORECAST_RULES_B_PKG dependencies on CSP_FORECAST_RULES_TL

Line 158: insert into CSP_FORECAST_RULES_TL (

154: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
155: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
156: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15));
157:
158: insert into CSP_FORECAST_RULES_TL (
159: FORECAST_RULE_ID,
160: CREATED_BY,
161: CREATION_DATE,
162: LAST_UPDATED_BY,

Line 182: from CSP_FORECAST_RULES_TL T

178: from FND_LANGUAGES L
179: where L.INSTALLED_FLAG in ('I', 'B')
180: and not exists
181: (select NULL
182: from CSP_FORECAST_RULES_TL T
183: where T.FORECAST_RULE_ID = pX_FORECAST_RULE_ID
184: and T.LANGUAGE = L.LANGUAGE_CODE);
185:
186: End Insert_Row;

Line 286: update CSP_FORECAST_RULES_TL set

282: if (sql%notfound) then
283: raise no_data_found;
284: end if;
285:
286: update CSP_FORECAST_RULES_TL set
287: DESCRIPTION = p_DESCRIPTION,
288: LAST_UPDATE_DATE = p_last_update_DATE,
289: LAST_UPDATED_BY = p_LAST_UPDATED_BY,
290: LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN,

Line 306: delete from CSP_FORECAST_RULES_TL

302: PROCEDURE Delete_Row(
303: p_FORECAST_RULE_ID NUMBER)
304: IS
305: BEGIN
306: delete from CSP_FORECAST_RULES_TL
307: where FORECAST_RULE_ID = p_FORECAST_RULE_ID;
308:
309: if (sql%notfound) then
310: raise no_data_found;

Line 376: from CSP_FORECAST_RULES_TL

372:
373: cursor c1 is select
374: DESCRIPTION,
375: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
376: from CSP_FORECAST_RULES_TL
377: where FORECAST_RULE_ID = p_FORECAST_RULE_ID
378: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
379: for update of FORECAST_RULE_ID nowait;
380:

Line 547: delete from CSP_FORECAST_RULES_TL T

543:
544: procedure ADD_LANGUAGE
545: is
546: begin
547: delete from CSP_FORECAST_RULES_TL T
548: where not exists
549: (select NULL
550: from CSP_FORECAST_RULES_B B
551: where B.FORECAST_RULE_ID = T.FORECAST_RULE_ID

Line 554: update CSP_FORECAST_RULES_TL T set (

550: from CSP_FORECAST_RULES_B B
551: where B.FORECAST_RULE_ID = T.FORECAST_RULE_ID
552: );
553:
554: update CSP_FORECAST_RULES_TL T set (
555: DESCRIPTION
556: ) = (select
557: B.DESCRIPTION
558: from CSP_FORECAST_RULES_TL B

Line 558: from CSP_FORECAST_RULES_TL B

554: update CSP_FORECAST_RULES_TL T set (
555: DESCRIPTION
556: ) = (select
557: B.DESCRIPTION
558: from CSP_FORECAST_RULES_TL B
559: where B.FORECAST_RULE_ID = T.FORECAST_RULE_ID
560: and B.LANGUAGE = T.SOURCE_LANG)
561: where (
562: T.FORECAST_RULE_ID,

Line 567: from CSP_FORECAST_RULES_TL SUBB, CSP_FORECAST_RULES_TL SUBT

563: T.LANGUAGE
564: ) in (select
565: SUBT.FORECAST_RULE_ID,
566: SUBT.LANGUAGE
567: from CSP_FORECAST_RULES_TL SUBB, CSP_FORECAST_RULES_TL SUBT
568: where SUBB.FORECAST_RULE_ID = SUBT.FORECAST_RULE_ID
569: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
570: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
571: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)

Line 575: insert into CSP_FORECAST_RULES_TL (

571: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
572: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
573: ));
574:
575: insert into CSP_FORECAST_RULES_TL (
576: FORECAST_RULE_ID,
577: CREATED_BY,
578: CREATION_DATE,
579: LAST_UPDATED_BY,

Line 595: from CSP_FORECAST_RULES_TL B, FND_LANGUAGES L

591: B.LAST_UPDATE_LOGIN,
592: B.DESCRIPTION,
593: L.LANGUAGE_CODE,
594: B.SOURCE_LANG
595: from CSP_FORECAST_RULES_TL B, FND_LANGUAGES L
596: where L.INSTALLED_FLAG in ('I', 'B')
597: and B.LANGUAGE = userenv('LANG')
598: and not exists
599: (select NULL

Line 600: from CSP_FORECAST_RULES_TL T

596: where L.INSTALLED_FLAG in ('I', 'B')
597: and B.LANGUAGE = userenv('LANG')
598: and not exists
599: (select NULL
600: from CSP_FORECAST_RULES_TL T
601: where T.FORECAST_RULE_ID = B.FORECAST_RULE_ID
602: and T.LANGUAGE = L.LANGUAGE_CODE);
603: end ADD_LANGUAGE;
604:

Line 618: UPDATE csp_forecast_rules_tl

614: if p_owner = 'SEED' then
615: l_user_id := 1;
616: end if;
617:
618: UPDATE csp_forecast_rules_tl
619: SET description = p_description
620: , last_update_date = SYSDATE
621: , last_updated_by = l_user_id
622: , last_update_login = 0