DBA Data[Home] [Help]

APPS.HXC_TIMESTORE_DEPOSIT_UTIL dependencies on HXC_BLD_BLK_INFO_TYPES

Line 1158: l_attribute_category hxc_bld_blk_info_types.bld_blk_info_type%TYPE;

1154: IS
1155: l_new_time_attribute_id NUMBER;
1156: l_new_attribute hxc_attribute_type;
1157: l_index NUMBER;
1158: l_attribute_category hxc_bld_blk_info_types.bld_blk_info_type%TYPE;
1159: l_new VARCHAR2 (1);
1160: BEGIN
1161: IF (INSTR (p_app_attributes (p_app_index).bld_blk_info_type, 'Dummy') <
1162: 1

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

2377: -----------------------------------------------------------------------------
2378: -- Type: Procedure
2379: -- Scope: Public
2380: -- Name: get_bld_blk_info_type
2381: -- Returns: hxc_bld_blk_info_types.bld_blk_info_type%TYPE
2382: -- IN Parameters: p_attribute_name -> Name of the attribute
2383: -- p_deposit_process -> Name of the deposit process which we will
2384: -- use the mapping of
2385: -- OUT Parameters: p_bld_blk_info_type -> BB Info Type for the attribute name

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

2396: -----------------------------------------------------------------------------
2397: PROCEDURE get_bld_blk_info_type (
2398: p_attribute_name IN hxc_mapping_components.field_name%TYPE,
2399: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
2400: p_bld_blk_info_type OUT NOCOPY hxc_bld_blk_info_types.bld_blk_info_type%TYPE,
2401: p_segment OUT NOCOPY hxc_mapping_components.SEGMENT%TYPE
2402: )
2403: IS
2404: l_proc VARCHAR2 (72);

Line 2416: hxc_bld_blk_info_types bbit,

2412: FROM hxc_mapping_components mc,
2413: hxc_mapping_comp_usages mcu,
2414: hxc_mappings m,
2415: hxc_deposit_processes dp,
2416: hxc_bld_blk_info_types bbit,
2417: hxc_bld_blk_info_type_usages bbui
2418: WHERE dp.mapping_id = m.mapping_id
2419: AND m.mapping_id = mcu.mapping_id
2420: AND mcu.mapping_component_id = mc.mapping_component_id