APPS.AMS_FUNDS_ALL_PKG dependencies on OZF_FUNDS_ALL_TL

Line 253: insert into OZF_FUNDS_ALL_TL (

249: X_LIABLE_ACCNT_SEGMENTS,
250: X_ADJUSTMENT_ACCNT_SEGMENTS
251: );
252:
253: insert into OZF_FUNDS_ALL_TL (
254: FUND_ID,
255: LAST_UPDATE_DATE,
256: LAST_UPDATED_BY,
257: LAST_UPDATE_LOGIN,

Line 283: from OZF_FUNDS_ALL_TL T

279: from FND_LANGUAGES L
280: where L.INSTALLED_FLAG in ('I', 'B')
281: and not exists
282: (select NULL
283: from OZF_FUNDS_ALL_TL T
284: where T.FUND_ID = X_FUND_ID
285: and T.LANGUAGE = L.LANGUAGE_CODE);
286:
287: open c;

Line 458: from OZF_FUNDS_ALL_TL

454: cursor c1 is select
455: SHORT_NAME,
456: DESCRIPTION,
457: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
458: from OZF_FUNDS_ALL_TL
459: where FUND_ID = X_FUND_ID
460: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
461: for update of FUND_ID nowait;
462: begin

Line 800: update OZF_FUNDS_ALL_TL set

796: if (sql%notfound) then
797: raise no_data_found;
798: end if;
799:
800: update OZF_FUNDS_ALL_TL set
801: SHORT_NAME = X_SHORT_NAME,
802: DESCRIPTION = X_DESCRIPTION,
803: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
804: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 819: delete from OZF_FUNDS_ALL_TL

815: procedure DELETE_ROW (
816: X_FUND_ID in NUMBER
817: ) is
818: begin
819: delete from OZF_FUNDS_ALL_TL
820: where FUND_ID = X_FUND_ID;
821:
822: if (sql%notfound) then
823: raise no_data_found;

Line 837: delete from OZF_FUNDS_ALL_TL T

833:
834: procedure ADD_LANGUAGE
835: is
836: begin
837: delete from OZF_FUNDS_ALL_TL T
838: where not exists
839: (select NULL
840: from OZF_FUNDS_ALL_B B
841: where B.FUND_ID = T.FUND_ID

Line 844: update OZF_FUNDS_ALL_TL T set (

840: from OZF_FUNDS_ALL_B B
841: where B.FUND_ID = T.FUND_ID
842: );
843:
844: update OZF_FUNDS_ALL_TL T set (
845: SHORT_NAME,
846: DESCRIPTION
847: ) = (select
848: B.SHORT_NAME,

Line 850: from OZF_FUNDS_ALL_TL B

846: DESCRIPTION
847: ) = (select
848: B.SHORT_NAME,
849: B.DESCRIPTION
850: from OZF_FUNDS_ALL_TL B
851: where B.FUND_ID = T.FUND_ID
852: and B.LANGUAGE = T.SOURCE_LANG)
853: where (
854: T.FUND_ID,

Line 859: from OZF_FUNDS_ALL_TL SUBB, OZF_FUNDS_ALL_TL SUBT

855: T.LANGUAGE
856: ) in (select
857: SUBT.FUND_ID,
858: SUBT.LANGUAGE
859: from OZF_FUNDS_ALL_TL SUBB, OZF_FUNDS_ALL_TL SUBT
860: where SUBB.FUND_ID = SUBT.FUND_ID
861: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
862: and (SUBB.SHORT_NAME <> SUBT.SHORT_NAME
863: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 868: insert into OZF_FUNDS_ALL_TL (

864: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
865: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
866: ));
867:
868: insert into OZF_FUNDS_ALL_TL (
869: FUND_ID,
870: LAST_UPDATE_DATE,
871: LAST_UPDATED_BY,
872: LAST_UPDATE_LOGIN,

Line 900: from OZF_FUNDS_ALL_TL B, FND_LANGUAGES L

896: B.SHORT_NAME,
897: B.DESCRIPTION,
898: L.LANGUAGE_CODE,
899: B.SOURCE_LANG
900: from OZF_FUNDS_ALL_TL B, FND_LANGUAGES L
901: where L.INSTALLED_FLAG in ('I', 'B')
902: and B.LANGUAGE = userenv('LANG')
903: and not exists
904: (select NULL

Line 905: from OZF_FUNDS_ALL_TL T

901: where L.INSTALLED_FLAG in ('I', 'B')
902: and B.LANGUAGE = userenv('LANG')
903: and not exists
904: (select NULL
905: from OZF_FUNDS_ALL_TL T
906: where T.FUND_ID = B.FUND_ID
907: and T.LANGUAGE = L.LANGUAGE_CODE);
908: end ADD_LANGUAGE;
909:

Line 918: update OZF_FUNDS_ALL_TL set

914: X_OWNERS in VARCHAR2
915: )
916: IS
917: BEGIN
918: update OZF_FUNDS_ALL_TL set
919: short_name = nvl(x_short_name, short_name),
920: description = nvl(x_description, description),
921: source_lang = userenv('LANG'),
922: last_update_date = sysdate,