APPS.AMS_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 574: from OZF_FUNDS_UTILIZED_ALL_TL B, FND_LANGUAGES L

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

Line 579: from OZF_FUNDS_UTILIZED_ALL_TL T

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

Line 593: update OZF_FUNDS_UTILIZED_ALL_TL set

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