APPS.HXC_TIMESTORE_DEPOSIT_UTIL dependencies on HXC_BLD_BLK_INFO_TYPES

Line 1703: p_attribute_category IN OUT NOCOPY hxc_bld_blk_info_types.bld_blk_info_type%TYPE)

1699: -----------------------------------------------------------------------------
1700:
1701: PROCEDURE get_dff_attribute_category (
1702: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
1703: p_attribute_category IN OUT NOCOPY hxc_bld_blk_info_types.bld_blk_info_type%TYPE)
1704: IS
1705: CURSOR c_reference_field IS
1706: SELECT d.default_context_field_name
1707: FROM fnd_descriptive_flexs d, fnd_application a, fnd_product_installations z

Line 1794: l_attribute_category hxc_bld_blk_info_types.bld_blk_info_type%TYPE;

1790: IS
1791: l_new_time_attribute_id NUMBER;
1792: l_new_attribute hxc_attribute_type;
1793: l_index NUMBER;
1794: l_attribute_category hxc_bld_blk_info_types.bld_blk_info_type%TYPE;
1795: l_new VARCHAR2 (1);
1796: BEGIN
1797: IF (INSTR (p_app_attributes (p_app_index).bld_blk_info_type, 'Dummy') <
1798: 1

Line 3023: -- Returns: hxc_bld_blk_info_types.bld_blk_info_type%TYPE

3019: -----------------------------------------------------------------------------
3020: -- Type: Procedure
3021: -- Scope: Public
3022: -- Name: get_bld_blk_info_type
3023: -- Returns: hxc_bld_blk_info_types.bld_blk_info_type%TYPE
3024: -- IN Parameters: p_attribute_name -> Name of the attribute
3025: -- p_deposit_process -> Name of the deposit process which we will
3026: -- use the mapping of
3027: -- OUT Parameters: p_bld_blk_info_type -> BB Info Type for the attribute name

Line 3042: p_bld_blk_info_type OUT NOCOPY hxc_bld_blk_info_types.bld_blk_info_type%TYPE,

3038: -----------------------------------------------------------------------------
3039: PROCEDURE get_bld_blk_info_type (
3040: p_attribute_name IN hxc_mapping_components.field_name%TYPE,
3041: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
3042: p_bld_blk_info_type OUT NOCOPY hxc_bld_blk_info_types.bld_blk_info_type%TYPE,
3043: p_segment OUT NOCOPY hxc_mapping_components.SEGMENT%TYPE
3044: )
3045: IS
3046: l_proc VARCHAR2 (72);

Line 3058: hxc_bld_blk_info_types bbit,

3054: FROM hxc_mapping_components mc,
3055: hxc_mapping_comp_usages mcu,
3056: hxc_mappings m,
3057: hxc_deposit_processes dp,
3058: hxc_bld_blk_info_types bbit,
3059: hxc_bld_blk_info_type_usages bbui
3060: WHERE dp.mapping_id = m.mapping_id
3061: AND m.mapping_id = mcu.mapping_id
3062: AND mcu.mapping_component_id = mc.mapping_component_id