APPS.OZF_FUNDTHRESHOLDS_ALL_B_PKG dependencies on OZF_THRESHOLDS_ALL_TL

Line 170: -- insert to ozf_thresholds_all_tl table

166: p_security_group_id,
167: px_object_version_number,
168: p_threshold_type);
169:
170: -- insert to ozf_thresholds_all_tl table
171:
172:
173: INSERT INTO OZF_THRESHOLDS_ALL_TL(
174: threshold_id,

Line 173: INSERT INTO OZF_THRESHOLDS_ALL_TL(

169:
170: -- insert to ozf_thresholds_all_tl table
171:
172:
173: INSERT INTO OZF_THRESHOLDS_ALL_TL(
174: threshold_id,
175: last_update_date,
176: last_updated_by,
177: last_update_login,

Line 210: INSERT INTO ozf_thresholds_all_tl

206: USERENV('LANG'),
207: p_org_id,
208: p_security_group_id);
209: /*
210: INSERT INTO ozf_thresholds_all_tl
211: (threshold_id,
212: last_update_date,
213: last_updated_by,
214: last_update_login,

Line 248: FROM ozf_thresholds_all_tl t

244: ,p_security_group_id
245: FROM fnd_languages l
246: WHERE l.installed_flag IN('I', 'B')
247: AND NOT EXISTS(SELECT NULL
248: FROM ozf_thresholds_all_tl t
249: WHERE t.threshold_id = px_threshold_id
250: AND t.language = l.language_code);
251: */
252: END Insert_Row;

Line 362: -- update ozf_thresholds_all_tl table

358: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
359: END IF;
360:
361: px_object_version_number := px_object_version_number +1;
362: -- update ozf_thresholds_all_tl table
363: Update OZF_THRESHOLDS_ALL_TL
364: SET
365: threshold_id = p_threshold_id,
366: last_update_date = p_last_update_date,

Line 363: Update OZF_THRESHOLDS_ALL_TL

359: END IF;
360:
361: px_object_version_number := px_object_version_number +1;
362: -- update ozf_thresholds_all_tl table
363: Update OZF_THRESHOLDS_ALL_TL
364: SET
365: threshold_id = p_threshold_id,
366: last_update_date = p_last_update_date,
367: last_updated_by = p_last_updated_by,

Line 412: DELETE FROM OZF_THRESHOLDS_ALL_TL

408: BEGIN
409: DELETE FROM OZF_THRESHOLDS_ALL_B
410: WHERE THRESHOLD_ID = p_THRESHOLD_ID;
411:
412: DELETE FROM OZF_THRESHOLDS_ALL_TL
413: WHERE THRESHOLD_ID = p_THRESHOLD_ID;
414:
415: If (SQL%NOTFOUND) then
416: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 611: delete from OZF_THRESHOLDS_ALL_TL T

607:
608: procedure ADD_LANGUAGE
609: is
610: begin
611: delete from OZF_THRESHOLDS_ALL_TL T
612: where not exists
613: (select NULL
614: from OZF_THRESHOLDS_ALL_B B
615: where B.THRESHOLD_ID = T.THRESHOLD_ID

Line 618: update OZF_THRESHOLDS_ALL_TL T set (

614: from OZF_THRESHOLDS_ALL_B B
615: where B.THRESHOLD_ID = T.THRESHOLD_ID
616: );
617:
618: update OZF_THRESHOLDS_ALL_TL T set (
619: NAME,
620: DESCRIPTION
621: ) = (select
622: B.NAME,

Line 624: from OZF_THRESHOLDS_ALL_TL B

620: DESCRIPTION
621: ) = (select
622: B.NAME,
623: B.DESCRIPTION
624: from OZF_THRESHOLDS_ALL_TL B
625: where B.THRESHOLD_ID = T.THRESHOLD_ID
626: and B.LANGUAGE = T.SOURCE_LANG)
627: where (
628: T.THRESHOLD_ID,

Line 633: from OZF_THRESHOLDS_ALL_TL SUBB, OZF_THRESHOLDS_ALL_TL SUBT

629: T.LANGUAGE
630: ) in (select
631: SUBT.THRESHOLD_ID,
632: SUBT.LANGUAGE
633: from OZF_THRESHOLDS_ALL_TL SUBB, OZF_THRESHOLDS_ALL_TL SUBT
634: where SUBB.THRESHOLD_ID = SUBT.THRESHOLD_ID
635: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
636: and (SUBB.NAME <> SUBT.NAME
637: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 642: insert into OZF_THRESHOLDS_ALL_TL (

638: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
639: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
640: ));
641:
642: insert into OZF_THRESHOLDS_ALL_TL (
643: THRESHOLD_ID,
644: LAST_UPDATE_DATE,
645: LAST_UPDATED_BY,
646: LAST_UPDATE_LOGIN,

Line 674: from OZF_THRESHOLDS_ALL_TL B, FND_LANGUAGES L

670: B.NAME,
671: B.DESCRIPTION,
672: L.LANGUAGE_CODE,
673: B.SOURCE_LANG
674: from OZF_THRESHOLDS_ALL_TL B, FND_LANGUAGES L
675: where L.INSTALLED_FLAG in ('I', 'B')
676: and B.LANGUAGE = userenv('LANG')
677: and not exists
678: (select NULL

Line 679: from OZF_THRESHOLDS_ALL_TL T

675: where L.INSTALLED_FLAG in ('I', 'B')
676: and B.LANGUAGE = userenv('LANG')
677: and not exists
678: (select NULL
679: from OZF_THRESHOLDS_ALL_TL T
680: where T.THRESHOLD_ID = B.THRESHOLD_ID
681: and T.LANGUAGE = L.LANGUAGE_CODE);
682: end ADD_LANGUAGE;
683:

Line 692: update OZF_THRESHOLDS_ALL_TL set

688: X_OWNERS in VARCHAR2
689: )
690: IS
691: BEGIN
692: update OZF_THRESHOLDS_ALL_TL set
693: name = nvl(x_name, name),
694: description = nvl(x_description, description),
695: source_lang = userenv('LANG'),
696: last_update_date = sysdate,