eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEX_UWQ_DELIN_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 283: l_security_where := l_security_where || ' AND iex_utilities.get_party_running_level (iex_delinquencies_uwq_v.customer_id , iex_delinquencies_uwq_v.org_id ) = ''DELINQUENCY'' ';

279:
280: if l_del_level = 'Y' then -- added if statement by a bug 16494272
281: if l_party_override = 'Y' then
282: if l_org_override = 'Y' then
283: l_security_where := l_security_where || ' AND iex_utilities.get_party_running_level (iex_delinquencies_uwq_v.customer_id , iex_delinquencies_uwq_v.org_id ) = ''DELINQUENCY'' ';
284: else
285: l_security_where := l_security_where || ' and exists ( select 1 from hz_party_preferences hzprf where hzprf.value_varchar2= ''DELINQUENCY'' '
286: ||' and hzprf.module= ''COLLECTIONS''and hzprf.category = ''COLLECTIONS LEVEL'' '
287: ||' and hzprf.preference_code = ''PARTY_ID'' and hzprf.party_id= iex_delinquencies_uwq_v.customer_id) ';

Line 324: l_security_where := l_security_where || ' AND iex_utilities.get_party_running_level (iex_delinquencies_uwq_v.customer_id , iex_delinquencies_uwq_v.org_id ) = ''DELINQUENCY'' ';

320:
321: if l_del_level = 'Y' then -- added if statement by a bug 16494272
322: if l_party_override = 'Y' then
323: if l_org_override = 'Y' then
324: l_security_where := l_security_where || ' AND iex_utilities.get_party_running_level (iex_delinquencies_uwq_v.customer_id , iex_delinquencies_uwq_v.org_id ) = ''DELINQUENCY'' ';
325: else
326: l_security_where := l_security_where || ' and exists ( select 1 from hz_party_preferences hzprf where hzprf.value_varchar2= ''DELINQUENCY'' '
327: ||' and hzprf.module=''COLLECTIONS'' and hzprf.category = ''COLLECTIONS LEVEL'' '
328: ||' and hzprf.preference_code = ''PARTY_ID'' and hzprf.party_id = iex_delinquencies_uwq_v.customer_id) ';

Line 482: l_security_where := l_security_where || ' AND iex_utilities.get_party_running_level (iex_delinquencies_uwq_v.customer_id , iex_delinquencies_uwq_v.org_id ) = ''DELINQUENCY'' ';

478: --Start Added to fix 10275372 12/13/2010 SNUTHALA
479: if l_del_level = 'Y' then -- added if statement by a bug 16494272
480: if l_party_override = 'Y' then
481: if l_org_override = 'Y' then
482: l_security_where := l_security_where || ' AND iex_utilities.get_party_running_level (iex_delinquencies_uwq_v.customer_id , iex_delinquencies_uwq_v.org_id ) = ''DELINQUENCY'' ';
483: else
484: l_security_where := l_security_where || ' and exists ( select 1 from hz_party_preferences hzprf where hzprf.value_varchar2= ''DELINQUENCY'' '
485: ||' and hzprf.module=''COLLECTIONS'' and hzprf.category = ''COLLECTIONS LEVEL'' '
486: ||' and hzprf.preference_code = ''PARTY_ID'' and hzprf.party_id = iex_delinquencies_uwq_v.customer_id) ';

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

652: is select lookup_code
653: from iex_lookups_v
654: where lookup_type='IEX_RUNNING_LEVEL'
655: and lookup_code= 'CUSTOMER'
656: and iex_utilities.validate_running_level(LOOKUP_CODE)='Y';
657: --end bug#6717849 schekuri 31-Jul-2009
658:
659: BEGIN
660: -- SAVEPOINT start_delin_enumeration;

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

704: select count(1)
705: into l_level_count
706: from iex_lookups_v
707: where lookup_type='IEX_RUNNING_LEVEL'
708: and iex_utilities.validate_running_level(LOOKUP_CODE)='Y';
709:
710: if l_level_count>1 then
711: open c_multi_level;
712: fetch c_multi_level into l_strategy_level;

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

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

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

1247: select count(1)
1248: into l_level_count
1249: from iex_lookups_v
1250: where lookup_type='IEX_RUNNING_LEVEL'
1251: and iex_utilities.validate_running_level(LOOKUP_CODE)='Y';
1252:
1253: if l_level_count>1 then
1254: open c_multi_level;
1255: fetch c_multi_level into l_strategy_level;

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

1893: is select lookup_code
1894: from iex_lookups_v
1895: where lookup_type='IEX_RUNNING_LEVEL'
1896: and lookup_code= 'BILL_TO'
1897: and iex_utilities.validate_running_level(LOOKUP_CODE)='Y';
1898: --end bug#6717849 schekuri 31-Jul-2009
1899:
1900: BEGIN
1901:

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

1928: select count(1)
1929: into l_level_count
1930: from iex_lookups_v
1931: where lookup_type='IEX_RUNNING_LEVEL'
1932: and iex_utilities.validate_running_level(LOOKUP_CODE)='Y';
1933:
1934: if l_level_count>1 then
1935: open c_multi_level;
1936: fetch c_multi_level into l_strategy_level;