APPS.IEX_UWQ_PROM_ENUMS_PVT dependencies on IEX_UTILITIES

Line 21: L := IEX_UTILITIES.get_cache_value('GL_CURRENCY'||I_ORG.ORGANIZATION_ID,

17:
18: FOR I_ORG IN C_ORG_ID LOOP
19: MO_GLOBAL.SET_POLICY_CONTEXT('S',I_ORG.ORGANIZATION_ID);
20:
21: L := IEX_UTILITIES.get_cache_value('GL_CURRENCY'||I_ORG.ORGANIZATION_ID,
22: 'SELECT GLSOB.CURRENCY_CODE CURRENCY from GL_SETS_OF_BOOKS GLSOB, AR_SYSTEM_PARAMETERS ARSYS WHERE ARSYS.SET_OF_BOOKS_ID ' ||
23: ' = GLSOB.SET_OF_BOOKS_ID');
24: L := IEX_UTILITIES.get_cache_value('DEFAULT_EXCHANGE_RATE_TYPE'||I_ORG.ORGANIZATION_ID, 'SELECT DEFAULT_EXCHANGE_RATE_TYPE FROM AR_CMGT_SETUP_OPTIONS');
25: END LOOP;

Line 24: L := IEX_UTILITIES.get_cache_value('DEFAULT_EXCHANGE_RATE_TYPE'||I_ORG.ORGANIZATION_ID, 'SELECT DEFAULT_EXCHANGE_RATE_TYPE FROM AR_CMGT_SETUP_OPTIONS');

20:
21: L := IEX_UTILITIES.get_cache_value('GL_CURRENCY'||I_ORG.ORGANIZATION_ID,
22: 'SELECT GLSOB.CURRENCY_CODE CURRENCY from GL_SETS_OF_BOOKS GLSOB, AR_SYSTEM_PARAMETERS ARSYS WHERE ARSYS.SET_OF_BOOKS_ID ' ||
23: ' = GLSOB.SET_OF_BOOKS_ID');
24: L := IEX_UTILITIES.get_cache_value('DEFAULT_EXCHANGE_RATE_TYPE'||I_ORG.ORGANIZATION_ID, 'SELECT DEFAULT_EXCHANGE_RATE_TYPE FROM AR_CMGT_SETUP_OPTIONS');
25: END LOOP;
26:
27: MO_GLOBAL.SET_POLICY_CONTEXT('M',NULL);
28:

Line 235: l_default_where := l_default_where || ' AND iex_utilities.get_party_running_level (party_id , org_id ) = ''DELINQUENCY'' ';

231: --Bug4775893. Fix by LKKUMAR on 14-Dec-2005. End.
232: -- Start for bug 8708271 PNAVEENK
233: if l_party_override = 'Y' or l_org_override ='Y' then
234:
235: l_default_where := l_default_where || ' AND iex_utilities.get_party_running_level (party_id , org_id ) = ''DELINQUENCY'' ';
236: else
237: null;
238: end if;
239: -- End for bug 8708271

Line 463: and iex_utilities.validate_running_level(LOOKUP_CODE)='Y';

459: is select lookup_code
460: from iex_lookups_v
461: where lookup_type='IEX_RUNNING_LEVEL'
462: and lookup_code= 'CUSTOMER'
463: and iex_utilities.validate_running_level(LOOKUP_CODE)='Y';
464: --end bug#6717849 schekuri 31-Jul-2009
465:
466: BEGIN
467:

Line 568: and iex_utilities.validate_running_level(LOOKUP_CODE)='Y';

564: select count(1)
565: into l_level_count
566: from iex_lookups_v
567: where lookup_type='IEX_RUNNING_LEVEL'
568: and iex_utilities.validate_running_level(LOOKUP_CODE)='Y';
569:
570: if l_level_count>1 then
571: open c_multi_level;
572: fetch c_multi_level into l_strategy_level;

Line 824: and iex_utilities.validate_running_level(LOOKUP_CODE)='Y';

820: is select lookup_code
821: from iex_lookups_v
822: where lookup_type='IEX_RUNNING_LEVEL'
823: and lookup_code= 'ACCOUNT'
824: and iex_utilities.validate_running_level(LOOKUP_CODE)='Y';
825: --end bug#6717849 schekuri 31-Jul-2009
826:
827: BEGIN
828:

Line 945: and iex_utilities.validate_running_level(LOOKUP_CODE)='Y';

941: select count(1)
942: into l_level_count
943: from iex_lookups_v
944: where lookup_type='IEX_RUNNING_LEVEL'
945: and iex_utilities.validate_running_level(LOOKUP_CODE)='Y';
946:
947: if l_level_count>1 then
948: open c_multi_level;
949: fetch c_multi_level into l_strategy_level;

Line 1219: and iex_utilities.validate_running_level(LOOKUP_CODE)='Y';

1215: is select lookup_code
1216: from iex_lookups_v
1217: where lookup_type='IEX_RUNNING_LEVEL'
1218: and lookup_code= 'BILL_TO'
1219: and iex_utilities.validate_running_level(LOOKUP_CODE)='Y';
1220: --end bug#6717849 schekuri 31-Jul-2009
1221:
1222: BEGIN
1223:

Line 1336: and iex_utilities.validate_running_level(LOOKUP_CODE)='Y';

1332: select count(1)
1333: into l_level_count
1334: from iex_lookups_v
1335: where lookup_type='IEX_RUNNING_LEVEL'
1336: and iex_utilities.validate_running_level(LOOKUP_CODE)='Y';
1337:
1338: if l_level_count>1 then
1339: open c_multi_level;
1340: fetch c_multi_level into l_strategy_level;