DBA Data[Home] [Help]

APPS.HXC_TIMESTORE_DEPOSIT dependencies on HXC_TIME_ATTRIBUTES

Line 1559: p_attribute_value IN hxc_time_attributes.attribute1%TYPE,

1555: -----------------------------------------------------------------------------
1556: PROCEDURE create_attribute (
1557: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
1558: p_attribute_name IN hxc_mapping_components.field_name%TYPE,
1559: p_attribute_value IN hxc_time_attributes.attribute1%TYPE,
1560: -- p_category IN hxc_bld_blk_info_type_usages.building_block_category%TYPE,
1561: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1562: p_attribute_id IN hxc_time_attributes.time_attribute_id%TYPE,
1563: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info

Line 1562: p_attribute_id IN hxc_time_attributes.time_attribute_id%TYPE,

1558: p_attribute_name IN hxc_mapping_components.field_name%TYPE,
1559: p_attribute_value IN hxc_time_attributes.attribute1%TYPE,
1560: -- p_category IN hxc_bld_blk_info_type_usages.building_block_category%TYPE,
1561: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
1562: p_attribute_id IN hxc_time_attributes.time_attribute_id%TYPE,
1563: p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info
1564: )
1565: IS
1566: l_proc VARCHAR2 (72);

Line 1569: l_attribute_id hxc_time_attributes.time_attribute_id%TYPE

1565: IS
1566: l_proc VARCHAR2 (72);
1567: l_attribute_count PLS_INTEGER;
1568: l_bld_blk_info_type hxc_bld_blk_info_types.bld_blk_info_type%TYPE;
1569: l_attribute_id hxc_time_attributes.time_attribute_id%TYPE
1570: := NULL;
1571: l_segment hxc_mapping_components.SEGMENT%TYPE;
1572: attr_index PLS_INTEGER;
1573: BEGIN

Line 2100: p_time_attribute_id IN hxc_time_attributes.time_attribute_id%TYPE,

2096: -- of another timecard, please clear it first and start afresh.
2097: --
2098: -----------------------------------------------------------------------------
2099: PROCEDURE update_attribute (
2100: p_time_attribute_id IN hxc_time_attributes.time_attribute_id%TYPE,
2101: -- p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
2102: p_attribute_name IN hxc_mapping_components.field_name%TYPE,
2103: p_attribute_value IN hxc_time_attributes.attribute1%TYPE,
2104: -- p_category IN hxc_bld_blk_info_type_usages.building_block_category%TYPE,

Line 2103: p_attribute_value IN hxc_time_attributes.attribute1%TYPE,

2099: PROCEDURE update_attribute (
2100: p_time_attribute_id IN hxc_time_attributes.time_attribute_id%TYPE,
2101: -- p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
2102: p_attribute_name IN hxc_mapping_components.field_name%TYPE,
2103: p_attribute_value IN hxc_time_attributes.attribute1%TYPE,
2104: -- p_category IN hxc_bld_blk_info_type_usages.building_block_category%TYPE,
2105: -- p_time_recipient_id IN NUMBER,
2106: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
2107: p_app_blocks IN OUT NOCOPY hxc_block_table_type,

Line 2117: v_time_attribute_id hxc_time_attributes.time_attribute_id%TYPE

2113: -- l_app_blocks hxc_self_service_time_deposit.timecard_info;
2114: l_load_new_timecard BOOLEAN;
2115:
2116: CURSOR csr_tbb_id (
2117: v_time_attribute_id hxc_time_attributes.time_attribute_id%TYPE
2118: )
2119: IS
2120: SELECT time_building_block_id
2121: FROM hxc_time_attribute_usages

Line 2269: p_time_attribute_id IN hxc_time_attributes.time_attribute_id%TYPE,

2265: -- the new TYPE and then convert it back to the old PL/SQL table.
2266: --
2267: -----------------------------------------------------------------------------
2268: PROCEDURE update_attribute (
2269: p_time_attribute_id IN hxc_time_attributes.time_attribute_id%TYPE,
2270: -- p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
2271: p_attribute_name IN hxc_mapping_components.field_name%TYPE,
2272: p_attribute_value IN hxc_time_attributes.attribute1%TYPE,
2273: -- p_category IN hxc_bld_blk_info_type_usages.building_block_category%TYPE,

Line 2272: p_attribute_value IN hxc_time_attributes.attribute1%TYPE,

2268: PROCEDURE update_attribute (
2269: p_time_attribute_id IN hxc_time_attributes.time_attribute_id%TYPE,
2270: -- p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
2271: p_attribute_name IN hxc_mapping_components.field_name%TYPE,
2272: p_attribute_value IN hxc_time_attributes.attribute1%TYPE,
2273: -- p_category IN hxc_bld_blk_info_type_usages.building_block_category%TYPE,
2274: -- p_time_recipient_id IN NUMBER,
2275: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
2276: p_app_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,