APPS.OZF_FUND_UTILIZED_ALL_PKG dependencies on OZF_FUNDS_UTILIZED_ALL_TL

Line 146: insert into OZF_FUNDS_UTILIZED_ALL_TL (

142: P_ATTRIBUTE14,
143: P_ATTRIBUTE15
144: );
145:
146: insert into OZF_FUNDS_UTILIZED_ALL_TL (
147: UTILIZATION_ID,
148: LAST_UPDATE_DATE,
149: LAST_UPDATED_BY,
150: LAST_UPDATE_LOGIN,

Line 174: from OZF_FUNDS_UTILIZED_ALL_TL T

170: from FND_LANGUAGES L
171: where L.INSTALLED_FLAG in ('I', 'B')
172: and not exists(
173: select NULL
174: from OZF_FUNDS_UTILIZED_ALL_TL T
175: where T.UTILIZATION_ID = P_UTILIZATION_ID
176: and T.LANGUAGE = L.LANGUAGE_CODE
177: );
178:

Line 278: from OZF_FUNDS_UTILIZED_ALL_TL

274:
275: cursor c1 is
276: select ADJUSTMENT_DESC,
277: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
278: from OZF_FUNDS_UTILIZED_ALL_TL
279: where UTILIZATION_ID = P_UTILIZATION_ID
280: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
281: for update of UTILIZATION_ID nowait;
282:

Line 481: update OZF_FUNDS_UTILIZED_ALL_TL set

477: if (sql%notfound) then
478: raise no_data_found;
479: end if;
480:
481: update OZF_FUNDS_UTILIZED_ALL_TL set
482: LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,
483: LAST_UPDATED_BY = P_LAST_UPDATED_BY,
484: LAST_UPDATE_LOGIN = P_LAST_UPDATE_LOGIN,
485: ADJUSTMENT_DESC = P_ADJUSTMENT_DESC,

Line 501: delete from OZF_FUNDS_UTILIZED_ALL_TL

497: procedure DELETE_ROW (
498: P_UTILIZATION_ID IN NUMBER
499: ) is
500: begin
501: delete from OZF_FUNDS_UTILIZED_ALL_TL
502: where UTILIZATION_ID = P_UTILIZATION_ID;
503:
504: if (sql%notfound) then
505: raise no_data_found;

Line 521: delete from OZF_FUNDS_UTILIZED_ALL_TL T

517:
518: procedure ADD_LANGUAGE
519: is
520: begin
521: delete from OZF_FUNDS_UTILIZED_ALL_TL T
522: where not exists
523: (select NULL
524: from OZF_FUNDS_UTILIZED_ALL_B B
525: where B.UTILIZATION_ID = T.UTILIZATION_ID

Line 528: update OZF_FUNDS_UTILIZED_ALL_TL T

524: from OZF_FUNDS_UTILIZED_ALL_B B
525: where B.UTILIZATION_ID = T.UTILIZATION_ID
526: );
527:
528: update OZF_FUNDS_UTILIZED_ALL_TL T
529: set ADJUSTMENT_DESC = (select B.ADJUSTMENT_DESC
530: from OZF_FUNDS_UTILIZED_ALL_TL B
531: where B.UTILIZATION_ID = T.UTILIZATION_ID
532: and B.LANGUAGE = T.SOURCE_LANG)

Line 530: from OZF_FUNDS_UTILIZED_ALL_TL B

526: );
527:
528: update OZF_FUNDS_UTILIZED_ALL_TL T
529: set ADJUSTMENT_DESC = (select B.ADJUSTMENT_DESC
530: from OZF_FUNDS_UTILIZED_ALL_TL B
531: where B.UTILIZATION_ID = T.UTILIZATION_ID
532: and B.LANGUAGE = T.SOURCE_LANG)
533: where ( T.UTILIZATION_ID,
534: T.LANGUAGE )

Line 537: from OZF_FUNDS_UTILIZED_ALL_TL SUBB, OZF_FUNDS_UTILIZED_ALL_TL SUBT

533: where ( T.UTILIZATION_ID,
534: T.LANGUAGE )
535: in (select SUBT.UTILIZATION_ID,
536: SUBT.LANGUAGE
537: from OZF_FUNDS_UTILIZED_ALL_TL SUBB, OZF_FUNDS_UTILIZED_ALL_TL SUBT
538: where SUBB.UTILIZATION_ID = SUBT.UTILIZATION_ID
539: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
540: and (SUBB.ADJUSTMENT_DESC <> SUBT.ADJUSTMENT_DESC
541: or (SUBB.ADJUSTMENT_DESC is null and SUBT.ADJUSTMENT_DESC is not null)

Line 544: insert into OZF_FUNDS_UTILIZED_ALL_TL (

540: and (SUBB.ADJUSTMENT_DESC <> SUBT.ADJUSTMENT_DESC
541: or (SUBB.ADJUSTMENT_DESC is null and SUBT.ADJUSTMENT_DESC is not null)
542: or (SUBB.ADJUSTMENT_DESC is not null and SUBT.ADJUSTMENT_DESC is null)));
543:
544: insert into OZF_FUNDS_UTILIZED_ALL_TL (
545: UTILIZATION_ID,
546: LAST_UPDATE_DATE,
547: LAST_UPDATED_BY,
548: LAST_UPDATE_LOGIN,

Line 576: from OZF_FUNDS_UTILIZED_ALL_TL B, FND_LANGUAGES L

572: B.ADJUSTMENT_DESC,
573: L.LANGUAGE_CODE,
574: B.SOURCE_LANG,
575: B.ORG_ID
576: from OZF_FUNDS_UTILIZED_ALL_TL B, FND_LANGUAGES L
577: where L.INSTALLED_FLAG in ('I', 'B')
578: and B.LANGUAGE = userenv('LANG')
579: and not exists
580: (select NULL

Line 581: from OZF_FUNDS_UTILIZED_ALL_TL T

577: where L.INSTALLED_FLAG in ('I', 'B')
578: and B.LANGUAGE = userenv('LANG')
579: and not exists
580: (select NULL
581: from OZF_FUNDS_UTILIZED_ALL_TL T
582: where T.UTILIZATION_ID = B.UTILIZATION_ID
583: and T.LANGUAGE = L.LANGUAGE_CODE);
584:
585: end ADD_LANGUAGE;

Line 595: update OZF_FUNDS_UTILIZED_ALL_TL set

591: P_OWNERS IN VARCHAR2
592: )
593: is
594: begin
595: update OZF_FUNDS_UTILIZED_ALL_TL set
596: ADJUSTMENT_DESC = nvl(P_ADJUSTMENT_DESC, ADJUSTMENT_DESC),
597: SOURCE_LANG = userenv('LANG'),
598: LAST_UPDATE_DATE = sysdate,
599: LAST_UPDATED_BY = decode(P_OWNERS, 'SEED', 1, 0),