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 2394: display_value hxc_alias_values.alias_value_name%TYPE

2390:
2391: TYPE t_hours_type_list_row is RECORD (
2392: element_id NUMBER,
2393: alias_value_id NUMBER,
2394: display_value hxc_alias_values.alias_value_name%TYPE
2395: );
2396:
2397: TYPE t_hours_type_list is table of
2398: t_hours_type_list_row

Line 2417: l_display_value_ins_alg hxc_alias_values.alias_value_name%TYPE;

2413: -- Adding new variables used for Insertion Sorting implementation.
2414: i NUMBER;
2415: j NUMBER;
2416: l_hours_type_list_ins_alg t_hours_type_list;
2417: l_display_value_ins_alg hxc_alias_values.alias_value_name%TYPE;
2418:
2419: --Added for bug 10006152
2420: l_temp1_hours_type_list t_hours_type_list;
2421: l_temp2_hours_type_list t_hours_type_list;

Line 2423: l_display_value hxc_alias_values.alias_value_name%TYPE;

2419: --Added for bug 10006152
2420: l_temp1_hours_type_list t_hours_type_list;
2421: l_temp2_hours_type_list t_hours_type_list;
2422: l_element_id NUMBER;
2423: l_display_value hxc_alias_values.alias_value_name%TYPE;
2424: l_dup_alias_value VARCHAR2(1) := 'N';
2425:
2426: cursor csr_hours_type (p_alias_definition_id number,
2427: p_start_date date,

Line 2434: from hxc_alias_values hav,

2430: is
2431: select havt.alias_value_name Display_Value,
2432: hav.attribute1 element_id,
2433: hav.alias_value_id alias_value_id
2434: from hxc_alias_values hav,
2435: hxc_alias_values_tl havt,
2436: hxc_alias_definitions had
2437: where
2438: --hav.attribute_category='PAYROLL_ELEMENTS'

Line 2435: hxc_alias_values_tl havt,

2431: select havt.alias_value_name Display_Value,
2432: hav.attribute1 element_id,
2433: hav.alias_value_id alias_value_id
2434: from hxc_alias_values hav,
2435: hxc_alias_values_tl havt,
2436: hxc_alias_definitions had
2437: where
2438: --hav.attribute_category='PAYROLL_ELEMENTS'
2439: hav.enabled_flag='Y'

Line 3519: hxc_alias_values hav,

3515: havt.alias_value_name Display_Value,
3516: hav.attribute1 element_id,
3517: hav.alias_value_id alias_value_id
3518: FROM
3519: hxc_alias_values hav,
3520: hxc_alias_values_tl havt,
3521: hxc_alias_definitions had,
3522: PAY_ELEMENT_TYPES_F ELEMENT
3523: WHERE

Line 3520: hxc_alias_values_tl havt,

3516: hav.attribute1 element_id,
3517: hav.alias_value_id alias_value_id
3518: FROM
3519: hxc_alias_values hav,
3520: hxc_alias_values_tl havt,
3521: hxc_alias_definitions had,
3522: PAY_ELEMENT_TYPES_F ELEMENT
3523: WHERE
3524: hav.attribute1 = ELEMENT.element_type_id and