APPS.HXC_DEPOSIT_WRAPPER_UTILITIES dependencies on HXC_ALIAS_VALUES

Line 455: (p_alias_value_id in hxc_alias_values.alias_value_id%type,

451:
452: END return_projects_context;
453:
454: Procedure find_pa_information_from_alias
455: (p_alias_value_id in hxc_alias_values.alias_value_id%type,
456: p_expenditure_type out nocopy hxc_time_attributes.attribute3%type,
457: p_system_linkage_function out nocopy hxc_time_attributes.attribute5%type
458: ) is
459:

Line 460: cursor c_segments(p_value_id in hxc_alias_values.alias_value_id%type) is

456: p_expenditure_type out nocopy hxc_time_attributes.attribute3%type,
457: p_system_linkage_function out nocopy hxc_time_attributes.attribute5%type
458: ) is
459:
460: cursor c_segments(p_value_id in hxc_alias_values.alias_value_id%type) is
461: select atc.component_name,
462: fdfcu.application_column_name
463: from fnd_descr_flex_column_usages fdfcu,
464: hxc_alias_type_components atc,

Line 467: hxc_alias_values av

463: from fnd_descr_flex_column_usages fdfcu,
464: hxc_alias_type_components atc,
465: hxc_alias_types aty,
466: hxc_alias_definitions ad,
467: hxc_alias_values av
468: where av.alias_value_id = p_value_id
469: and av.alias_definition_id = ad.alias_definition_id
470: and ad.alias_type_id = aty.alias_type_id
471: and aty.alias_type_id = atc.alias_type_id

Line 479: cursor c_value_row(p_value_id in hxc_alias_values.alias_value_id%type) is

475: and fdfcu.descriptive_flexfield_name = 'OTC Aliases'
476: and fdfcu.descriptive_flex_context_code = aty.reference_object
477: and aty.alias_type = 'OTL_ALT_DDF';
478:
479: cursor c_value_row(p_value_id in hxc_alias_values.alias_value_id%type) is
480: select *
481: from hxc_alias_values av
482: where av.alias_value_id = p_value_id;
483:

Line 481: from hxc_alias_values av

477: and aty.alias_type = 'OTL_ALT_DDF';
478:
479: cursor c_value_row(p_value_id in hxc_alias_values.alias_value_id%type) is
480: select *
481: from hxc_alias_values av
482: where av.alias_value_id = p_value_id;
483:
484: l_alias_value_row c_value_row%rowtype;
485: l_row_value hxc_alias_values.attribute1%type;

Line 485: l_row_value hxc_alias_values.attribute1%type;

481: from hxc_alias_values av
482: where av.alias_value_id = p_value_id;
483:
484: l_alias_value_row c_value_row%rowtype;
485: l_row_value hxc_alias_values.attribute1%type;
486:
487: Begin
488: /*
489: We do this in something of strange way to avaid dynamic SQL,

Line 2336: display_value hxc_alias_values.alias_value_name%TYPE

2332:
2333: TYPE t_hours_type_list_row is RECORD (
2334: element_id NUMBER,
2335: alias_value_id NUMBER,
2336: display_value hxc_alias_values.alias_value_name%TYPE
2337: );
2338:
2339: TYPE t_hours_type_list is table of
2340: t_hours_type_list_row

Line 2359: l_display_value_ins_alg hxc_alias_values.alias_value_name%TYPE;

2355: -- Adding new variables used for Insertion Sorting implementation.
2356: i NUMBER;
2357: j NUMBER;
2358: l_hours_type_list_ins_alg t_hours_type_list;
2359: l_display_value_ins_alg hxc_alias_values.alias_value_name%TYPE;
2360:
2361:
2362: cursor csr_hours_type (p_alias_definition_id number,
2363: p_start_date date,

Line 2370: from hxc_alias_values hav,

2366: is
2367: select havt.alias_value_name Display_Value,
2368: hav.attribute1 element_id,
2369: hav.alias_value_id alias_value_id
2370: from hxc_alias_values hav,
2371: hxc_alias_values_tl havt,
2372: hxc_alias_definitions had
2373: where
2374: --hav.attribute_category='PAYROLL_ELEMENTS'

Line 2371: hxc_alias_values_tl havt,

2367: select havt.alias_value_name Display_Value,
2368: hav.attribute1 element_id,
2369: hav.alias_value_id alias_value_id
2370: from hxc_alias_values hav,
2371: hxc_alias_values_tl havt,
2372: hxc_alias_definitions had
2373: where
2374: --hav.attribute_category='PAYROLL_ELEMENTS'
2375: hav.enabled_flag='Y'

Line 3261: hxc_alias_values hav,

3257: havt.alias_value_name Display_Value,
3258: hav.attribute1 element_id,
3259: hav.alias_value_id alias_value_id
3260: FROM
3261: hxc_alias_values hav,
3262: hxc_alias_values_tl havt,
3263: hxc_alias_definitions had,
3264: PAY_ELEMENT_TYPES_F ELEMENT
3265: WHERE

Line 3262: hxc_alias_values_tl havt,

3258: hav.attribute1 element_id,
3259: hav.alias_value_id alias_value_id
3260: FROM
3261: hxc_alias_values hav,
3262: hxc_alias_values_tl havt,
3263: hxc_alias_definitions had,
3264: PAY_ELEMENT_TYPES_F ELEMENT
3265: WHERE
3266: hav.attribute1 = ELEMENT.element_type_id and