APPS.IEX_UWQ_STRAT_ENUMS_PVT dependencies on IEX_UTILITIES

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

95: is select lookup_code
96: from iex_lookups_v
97: where lookup_type='IEX_RUNNING_LEVEL'
98: and lookup_code= p_multi_level
99: and iex_utilities.validate_running_level(LOOKUP_CODE)='Y';
100: --end bug#6717849 schekuri 31-Jul-2009
101:
102: BEGIN
103:

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

108:
109: FOR I_ORG IN C_ORG_ID LOOP
110: MO_GLOBAL.SET_POLICY_CONTEXT('S',I_ORG.ORGANIZATION_ID);
111:
112: L := IEX_UTILITIES.get_cache_value('GL_CURRENCY'||I_ORG.ORGANIZATION_ID,
113: 'SELECT GLSOB.CURRENCY_CODE CURRENCY from GL_SETS_OF_BOOKS GLSOB, AR_SYSTEM_PARAMETERS ARSYS WHERE ARSYS.SET_OF_BOOKS_ID ' ||
114: ' = GLSOB.SET_OF_BOOKS_ID');
115: L := IEX_UTILITIES.get_cache_value('DEFAULT_EXCHANGE_RATE_TYPE'||I_ORG.ORGANIZATION_ID, 'SELECT DEFAULT_EXCHANGE_RATE_TYPE FROM AR_CMGT_SETUP_OPTIONS');
116: END LOOP;

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

111:
112: L := IEX_UTILITIES.get_cache_value('GL_CURRENCY'||I_ORG.ORGANIZATION_ID,
113: 'SELECT GLSOB.CURRENCY_CODE CURRENCY from GL_SETS_OF_BOOKS GLSOB, AR_SYSTEM_PARAMETERS ARSYS WHERE ARSYS.SET_OF_BOOKS_ID ' ||
114: ' = GLSOB.SET_OF_BOOKS_ID');
115: L := IEX_UTILITIES.get_cache_value('DEFAULT_EXCHANGE_RATE_TYPE'||I_ORG.ORGANIZATION_ID, 'SELECT DEFAULT_EXCHANGE_RATE_TYPE FROM AR_CMGT_SETUP_OPTIONS');
116: END LOOP;
117:
118: MO_GLOBAL.SET_POLICY_CONTEXT('M',NULL);
119:

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

139: select count(1)
140: into l_level_count
141: from iex_lookups_v
142: where lookup_type='IEX_RUNNING_LEVEL'
143: and iex_utilities.validate_running_level(LOOKUP_CODE)='Y';
144: --end bug#6717849 schekuri 31-Jul-2009
145:
146: OPEN c_sel_enum(p_sel_enum_id);
147: FETCH c_sel_enum INTO l_sel_enum_rec;