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.HXC_DEPOSIT_WRAPPER_UTILITIES dependencies on FND_DESCR_FLEX_CONTEXTS

Line 250: (p_context_code in FND_DESCR_FLEX_CONTEXTS_VL.DESCRIPTIVE_FLEX_CONTEXT_CODE%TYPE)

246:
247: END set_pref_globals;
248:
249: FUNCTION fetch_context_name
250: (p_context_code in FND_DESCR_FLEX_CONTEXTS_VL.DESCRIPTIVE_FLEX_CONTEXT_CODE%TYPE)
251: return varchar2 is
252:
253: l_context_name FND_DESCR_FLEX_CONTEXTS_VL.DESCRIPTIVE_FLEX_CONTEXT_NAME%TYPE :='UNSET';
254:

Line 253: l_context_name FND_DESCR_FLEX_CONTEXTS_VL.DESCRIPTIVE_FLEX_CONTEXT_NAME%TYPE :='UNSET';

249: FUNCTION fetch_context_name
250: (p_context_code in FND_DESCR_FLEX_CONTEXTS_VL.DESCRIPTIVE_FLEX_CONTEXT_CODE%TYPE)
251: return varchar2 is
252:
253: l_context_name FND_DESCR_FLEX_CONTEXTS_VL.DESCRIPTIVE_FLEX_CONTEXT_NAME%TYPE :='UNSET';
254:
255: begin
256:
257: -- Perf Rep Fix - SQL ID:3170183

Line 261: from fnd_descr_flex_contexts_vl

257: -- Perf Rep Fix - SQL ID:3170183
258: -- Added where clause application_id = 809
259:
260: select descriptive_flex_context_name into l_context_name
261: from fnd_descr_flex_contexts_vl
262: where descriptive_flexfield_name = 'OTC Information Types'
263: and descriptive_flex_context_code = p_context_code
264: and application_id = 809;
265:

Line 352: from fnd_descr_flex_contexts

348:
349: BEGIN
350:
351: select 'Y' into l_dummy
352: from fnd_descr_flex_contexts
353: where application_id = 809
354: and descriptive_flexfield_name = 'OTC Information Types'
355: and enabled_flag = 'Y'
356: and descriptive_flex_context_code like p_context_prefix||'%GLOBAL%';

Line 384: l_pa_context_name FND_DESCR_FLEX_CONTEXTS_VL.DESCRIPTIVE_FLEX_CONTEXT_NAME%TYPE := '';

380: and d.descriptive_flexfield_name = 'PA_EXPENDITURE_ITEMS_DESC_FLEX';
381:
382: l_reference_field FND_DESCRIPTIVE_FLEXS.DEFAULT_CONTEXT_FIELD_NAME%TYPE;
383: l_pa_context_code varchar2(100) := '';
384: l_pa_context_name FND_DESCR_FLEX_CONTEXTS_VL.DESCRIPTIVE_FLEX_CONTEXT_NAME%TYPE := '';
385:
386: l_pa_desc_flex_info varchar2(240) := '';
387:
388: BEGIN

Line 584: l_context_code FND_DESCR_FLEX_CONTEXTS_VL.DESCRIPTIVE_FLEX_CONTEXT_CODE%TYPE;

580: ,p_context_string out nocopy varchar2
581: ) is
582:
583: l_index number := 1;
584: l_context_code FND_DESCR_FLEX_CONTEXTS_VL.DESCRIPTIVE_FLEX_CONTEXT_CODE%TYPE;
585: l_context_name FND_DESCR_FLEX_CONTEXTS_VL.DESCRIPTIVE_FLEX_CONTEXT_NAME%TYPE;
586: l_pa_info VARCHAR2(240) := '';
587: l_expenditure_type HXC_TIME_ATTRIBUTES.ATTRIBUTE3%TYPE;
588: l_system_linkage_function HXC_TIME_ATTRIBUTES.ATTRIBUTE5%TYPE;

Line 585: l_context_name FND_DESCR_FLEX_CONTEXTS_VL.DESCRIPTIVE_FLEX_CONTEXT_NAME%TYPE;

581: ) is
582:
583: l_index number := 1;
584: l_context_code FND_DESCR_FLEX_CONTEXTS_VL.DESCRIPTIVE_FLEX_CONTEXT_CODE%TYPE;
585: l_context_name FND_DESCR_FLEX_CONTEXTS_VL.DESCRIPTIVE_FLEX_CONTEXT_NAME%TYPE;
586: l_pa_info VARCHAR2(240) := '';
587: l_expenditure_type HXC_TIME_ATTRIBUTES.ATTRIBUTE3%TYPE;
588: l_system_linkage_function HXC_TIME_ATTRIBUTES.ATTRIBUTE5%TYPE;
589:

Line 3124: FROM fnd_descr_flex_contexts_vl

3120: IS
3121: CURSOR get_code(p_name VARCHAR2,P_MESSAGE VARCHAR2)
3122: IS
3123: SELECT descriptive_flex_context_code
3124: FROM fnd_descr_flex_contexts_vl
3125: WHERE descriptive_flex_context_name = p_name
3126: AND descriptive_flexfield_name = 'OTC Information Types'
3127: AND application_id = 809
3128: AND substrB(DESCRIPTIVE_FLEX_CONTEXT_CODE,0,instr(DESCRIPTIVE_FLEX_CONTEXT_CODE,'-')-2)

Line 3133: l_code fnd_descr_flex_contexts_vl.descriptive_flex_context_code%TYPE;

3129: =substrB(DESCRIPTIVE_FLEX_CONTEXT_name,0,instr(DESCRIPTIVE_FLEX_CONTEXT_name,'-')-2)||'C'
3130: AND SUBSTRB(DESCRIPTION,0, LENGTH(P_MESSAGE))=P_MESSAGE;
3131:
3132: l_index NUMBER := 0;
3133: l_code fnd_descr_flex_contexts_vl.descriptive_flex_context_code%TYPE;
3134: l_table_index NUMBER;
3135: l_message varchar2(100);
3136: BEGIN
3137: l_code := NULL;

Line 3195: FROM fnd_descr_flex_contexts_vl

3191: IS
3192: CURSOR get_name (p_code VARCHAR2, p_message VARCHAR2)
3193: IS
3194: SELECT descriptive_flex_context_name
3195: FROM fnd_descr_flex_contexts_vl
3196: WHERE descriptive_flex_context_code = p_code
3197: AND descriptive_flexfield_name = 'OTC Information Types'
3198: AND application_id = 809
3199: AND SUBSTRB (

Line 3212: l_name fnd_descr_flex_contexts_vl.descriptive_flex_context_name%TYPE;

3208: || 'C'
3209: AND SUBSTRB (description, 0, LENGTH (p_message)) = p_message;
3210:
3211: l_index NUMBER := 0;
3212: l_name fnd_descr_flex_contexts_vl.descriptive_flex_context_name%TYPE;
3213: l_message VARCHAR2 (100);
3214: BEGIN
3215: l_name := NULL;
3216: