eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HXT_HXC_RETRIEVAL_PROCESS dependencies on HXC_SELF_SERVICE_TIME_DEPOSIT

Line 16: p_time_building_blocks IN hxc_self_service_time_deposit.timecard_info,

12: e_error EXCEPTION;
13:
14: --------------------------- syncronize_deletes_in_otlr ----------------------
15: PROCEDURE synchronize_deletes_in_otlr (
16: p_time_building_blocks IN hxc_self_service_time_deposit.timecard_info,
17: p_time_att_info IN hxc_self_service_time_deposit.app_attributes_info,
18: p_messages IN OUT NOCOPY hxc_self_service_time_deposit.message_table,
19: p_timecard_source IN VARCHAR -- added for 5137310
20: )

Line 17: p_time_att_info IN hxc_self_service_time_deposit.app_attributes_info,

13:
14: --------------------------- syncronize_deletes_in_otlr ----------------------
15: PROCEDURE synchronize_deletes_in_otlr (
16: p_time_building_blocks IN hxc_self_service_time_deposit.timecard_info,
17: p_time_att_info IN hxc_self_service_time_deposit.app_attributes_info,
18: p_messages IN OUT NOCOPY hxc_self_service_time_deposit.message_table,
19: p_timecard_source IN VARCHAR -- added for 5137310
20: )
21: IS

Line 18: p_messages IN OUT NOCOPY hxc_self_service_time_deposit.message_table,

14: --------------------------- syncronize_deletes_in_otlr ----------------------
15: PROCEDURE synchronize_deletes_in_otlr (
16: p_time_building_blocks IN hxc_self_service_time_deposit.timecard_info,
17: p_time_att_info IN hxc_self_service_time_deposit.app_attributes_info,
18: p_messages IN OUT NOCOPY hxc_self_service_time_deposit.message_table,
19: p_timecard_source IN VARCHAR -- added for 5137310
20: )
21: IS
22: l_time_building_blocks hxc_self_service_time_deposit.timecard_info

Line 22: l_time_building_blocks hxc_self_service_time_deposit.timecard_info

18: p_messages IN OUT NOCOPY hxc_self_service_time_deposit.message_table,
19: p_timecard_source IN VARCHAR -- added for 5137310
20: )
21: IS
22: l_time_building_blocks hxc_self_service_time_deposit.timecard_info
23: := p_time_building_blocks;
24: l_time_att_info hxc_self_service_time_deposit.app_attributes_info
25: := p_time_att_info;
26:

Line 24: l_time_att_info hxc_self_service_time_deposit.app_attributes_info

20: )
21: IS
22: l_time_building_blocks hxc_self_service_time_deposit.timecard_info
23: := p_time_building_blocks;
24: l_time_att_info hxc_self_service_time_deposit.app_attributes_info
25: := p_time_att_info;
26:
27: CURSOR c_get_sum_id (day_bb_id NUMBER)
28: IS

Line 516: l_blocks hxc_self_service_time_deposit.timecard_info;

512: p_time_attributes IN OUT NOCOPY VARCHAR2,
513: p_messages IN OUT NOCOPY VARCHAR2
514: )
515: IS
516: l_blocks hxc_self_service_time_deposit.timecard_info;
517: l_attributes hxc_self_service_time_deposit.app_attributes_info;
518: l_messages hxc_self_service_time_deposit.message_table;
519: l_proc VARCHAR2 (100);
520: BEGIN

Line 517: l_attributes hxc_self_service_time_deposit.app_attributes_info;

513: p_messages IN OUT NOCOPY VARCHAR2
514: )
515: IS
516: l_blocks hxc_self_service_time_deposit.timecard_info;
517: l_attributes hxc_self_service_time_deposit.app_attributes_info;
518: l_messages hxc_self_service_time_deposit.message_table;
519: l_proc VARCHAR2 (100);
520: BEGIN
521: g_debug := hr_utility.debug_enabled;

Line 518: l_messages hxc_self_service_time_deposit.message_table;

514: )
515: IS
516: l_blocks hxc_self_service_time_deposit.timecard_info;
517: l_attributes hxc_self_service_time_deposit.app_attributes_info;
518: l_messages hxc_self_service_time_deposit.message_table;
519: l_proc VARCHAR2 (100);
520: BEGIN
521: g_debug := hr_utility.debug_enabled;
522:

Line 567: p_time_building_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,

563:
564: --------------------------- validate_timecard ------------------------------
565: PROCEDURE validate_timecard (
566: p_operation IN VARCHAR2,
567: p_time_building_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
568: p_time_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
569: p_messages IN OUT NOCOPY hxc_self_service_time_deposit.message_table
570: )
571: IS

Line 568: p_time_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,

564: --------------------------- validate_timecard ------------------------------
565: PROCEDURE validate_timecard (
566: p_operation IN VARCHAR2,
567: p_time_building_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
568: p_time_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
569: p_messages IN OUT NOCOPY hxc_self_service_time_deposit.message_table
570: )
571: IS
572: CURSOR get_timecard_id (p_tim_sum_id NUMBER)

Line 569: p_messages IN OUT NOCOPY hxc_self_service_time_deposit.message_table

565: PROCEDURE validate_timecard (
566: p_operation IN VARCHAR2,
567: p_time_building_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
568: p_time_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
569: p_messages IN OUT NOCOPY hxc_self_service_time_deposit.message_table
570: )
571: IS
572: CURSOR get_timecard_id (p_tim_sum_id NUMBER)
573: IS

Line 1673: p_time_building_blocks IN hxc_self_service_time_deposit.timecard_info,

1669: p_otm_rtr_id IN NUMBER,
1670: p_app_set_id IN NUMBER,
1671: p_timecard_id IN NUMBER,
1672: p_timecard_ovn IN NUMBER,
1673: p_time_building_blocks IN hxc_self_service_time_deposit.timecard_info,
1674: p_time_att_info IN hxc_self_service_time_deposit.app_attributes_info,
1675: p_messages IN OUT NOCOPY hxc_self_service_time_deposit.message_table
1676: )
1677: IS

Line 1674: p_time_att_info IN hxc_self_service_time_deposit.app_attributes_info,

1670: p_app_set_id IN NUMBER,
1671: p_timecard_id IN NUMBER,
1672: p_timecard_ovn IN NUMBER,
1673: p_time_building_blocks IN hxc_self_service_time_deposit.timecard_info,
1674: p_time_att_info IN hxc_self_service_time_deposit.app_attributes_info,
1675: p_messages IN OUT NOCOPY hxc_self_service_time_deposit.message_table
1676: )
1677: IS
1678: -- retrieves list of time recipients in retrieval rule group

Line 1675: p_messages IN OUT NOCOPY hxc_self_service_time_deposit.message_table

1671: p_timecard_id IN NUMBER,
1672: p_timecard_ovn IN NUMBER,
1673: p_time_building_blocks IN hxc_self_service_time_deposit.timecard_info,
1674: p_time_att_info IN hxc_self_service_time_deposit.app_attributes_info,
1675: p_messages IN OUT NOCOPY hxc_self_service_time_deposit.message_table
1676: )
1677: IS
1678: -- retrieves list of time recipients in retrieval rule group
1679: CURSOR csr_get_rtr (p_rtr_id NUMBER)

Line 1700: l_time_building_blocks hxc_self_service_time_deposit.timecard_info

1696: t_aps_tr t_time_recipient;
1697: t_rtr_tr t_time_recipient;
1698: l_rtr_tr_id hxc_time_recipients.time_recipient_id%TYPE;
1699: l_aps_tr_id hxc_time_recipients.time_recipient_id%TYPE;
1700: l_time_building_blocks hxc_self_service_time_deposit.timecard_info
1701: := p_time_building_blocks;
1702: l_time_att_info hxc_self_service_time_deposit.app_attributes_info
1703: := p_time_att_info;
1704: l_proc VARCHAR2 (250);

Line 1702: l_time_att_info hxc_self_service_time_deposit.app_attributes_info

1698: l_rtr_tr_id hxc_time_recipients.time_recipient_id%TYPE;
1699: l_aps_tr_id hxc_time_recipients.time_recipient_id%TYPE;
1700: l_time_building_blocks hxc_self_service_time_deposit.timecard_info
1701: := p_time_building_blocks;
1702: l_time_att_info hxc_self_service_time_deposit.app_attributes_info
1703: := p_time_att_info;
1704: l_proc VARCHAR2 (250);
1705: BEGIN
1706: g_debug := hr_utility.debug_enabled;

Line 1816: p_time_building_blocks IN hxc_self_service_time_deposit.timecard_info,

1812: --
1813: ------------------------------ otlr_review_details -----------------------------
1814: --
1815: PROCEDURE otlr_review_details (
1816: p_time_building_blocks IN hxc_self_service_time_deposit.timecard_info,
1817: p_time_attributes IN hxc_self_service_time_deposit.app_attributes_info,
1818: p_messages IN OUT NOCOPY hxc_self_service_time_deposit.message_table,
1819: p_detail_build_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
1820: p_detail_attributes IN OUT NOCOPY hxc_self_service_time_deposit.building_block_attribute_info

Line 1817: p_time_attributes IN hxc_self_service_time_deposit.app_attributes_info,

1813: ------------------------------ otlr_review_details -----------------------------
1814: --
1815: PROCEDURE otlr_review_details (
1816: p_time_building_blocks IN hxc_self_service_time_deposit.timecard_info,
1817: p_time_attributes IN hxc_self_service_time_deposit.app_attributes_info,
1818: p_messages IN OUT NOCOPY hxc_self_service_time_deposit.message_table,
1819: p_detail_build_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
1820: p_detail_attributes IN OUT NOCOPY hxc_self_service_time_deposit.building_block_attribute_info
1821: )

Line 1818: p_messages IN OUT NOCOPY hxc_self_service_time_deposit.message_table,

1814: --
1815: PROCEDURE otlr_review_details (
1816: p_time_building_blocks IN hxc_self_service_time_deposit.timecard_info,
1817: p_time_attributes IN hxc_self_service_time_deposit.app_attributes_info,
1818: p_messages IN OUT NOCOPY hxc_self_service_time_deposit.message_table,
1819: p_detail_build_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
1820: p_detail_attributes IN OUT NOCOPY hxc_self_service_time_deposit.building_block_attribute_info
1821: )
1822: IS

Line 1819: p_detail_build_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,

1815: PROCEDURE otlr_review_details (
1816: p_time_building_blocks IN hxc_self_service_time_deposit.timecard_info,
1817: p_time_attributes IN hxc_self_service_time_deposit.app_attributes_info,
1818: p_messages IN OUT NOCOPY hxc_self_service_time_deposit.message_table,
1819: p_detail_build_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
1820: p_detail_attributes IN OUT NOCOPY hxc_self_service_time_deposit.building_block_attribute_info
1821: )
1822: IS
1823: CURSOR get_otm_records (p_tim_sum_id NUMBER)

Line 1820: p_detail_attributes IN OUT NOCOPY hxc_self_service_time_deposit.building_block_attribute_info

1816: p_time_building_blocks IN hxc_self_service_time_deposit.timecard_info,
1817: p_time_attributes IN hxc_self_service_time_deposit.app_attributes_info,
1818: p_messages IN OUT NOCOPY hxc_self_service_time_deposit.message_table,
1819: p_detail_build_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
1820: p_detail_attributes IN OUT NOCOPY hxc_self_service_time_deposit.building_block_attribute_info
1821: )
1822: IS
1823: CURSOR get_otm_records (p_tim_sum_id NUMBER)
1824: IS

Line 1845: l_timecard_detail hxc_self_service_time_deposit.timecard_info;

1841:
1842: TYPE t_tim_sum_id_tab IS TABLE OF NUMBER
1843: INDEX BY BINARY_INTEGER;
1844:
1845: l_timecard_detail hxc_self_service_time_deposit.timecard_info;
1846: l_detail_attributes hxc_self_service_time_deposit.app_attributes_info;
1847: l_field_name hxt_otc_retrieval_interface.t_field_name;
1848: l_value hxt_otc_retrieval_interface.t_value;
1849: l_context hxt_otc_retrieval_interface.t_field_name;

Line 1846: l_detail_attributes hxc_self_service_time_deposit.app_attributes_info;

1842: TYPE t_tim_sum_id_tab IS TABLE OF NUMBER
1843: INDEX BY BINARY_INTEGER;
1844:
1845: l_timecard_detail hxc_self_service_time_deposit.timecard_info;
1846: l_detail_attributes hxc_self_service_time_deposit.app_attributes_info;
1847: l_field_name hxt_otc_retrieval_interface.t_field_name;
1848: l_value hxt_otc_retrieval_interface.t_value;
1849: l_context hxt_otc_retrieval_interface.t_field_name;
1850: l_category hxt_otc_retrieval_interface.t_field_name;

Line 1923: l_time_building_blocks hxc_self_service_time_deposit.timecard_info

1919: l_state_name hxt_sum_hours_worked_f.state_name%TYPE;
1920: l_county_name hxt_sum_hours_worked_f.county_name%TYPE;
1921: l_city_name hxt_sum_hours_worked_f.city_name%TYPE;
1922: l_zip_code hxt_sum_hours_worked_f.zip_code%TYPE;
1923: l_time_building_blocks hxc_self_service_time_deposit.timecard_info
1924: := p_time_building_blocks;
1925: l_time_attributes hxc_self_service_time_deposit.app_attributes_info
1926: := p_time_attributes;
1927: l_tim_id NUMBER;

Line 1925: l_time_attributes hxc_self_service_time_deposit.app_attributes_info

1921: l_city_name hxt_sum_hours_worked_f.city_name%TYPE;
1922: l_zip_code hxt_sum_hours_worked_f.zip_code%TYPE;
1923: l_time_building_blocks hxc_self_service_time_deposit.timecard_info
1924: := p_time_building_blocks;
1925: l_time_attributes hxc_self_service_time_deposit.app_attributes_info
1926: := p_time_attributes;
1927: l_tim_id NUMBER;
1928: BEGIN
1929: g_debug := hr_utility.debug_enabled;

Line 3508: p_detail_attributes IN hxc_self_service_time_deposit.app_attributes_info

3504: END otlr_review_details;
3505:
3506: --------------------------- build_attributes ---------------------------
3507: FUNCTION build_attributes (
3508: p_detail_attributes IN hxc_self_service_time_deposit.app_attributes_info
3509: )
3510: RETURN hxc_self_service_time_deposit.building_block_attribute_info
3511: IS
3512: CURSOR csr_wtd_components (

Line 3510: RETURN hxc_self_service_time_deposit.building_block_attribute_info

3506: --------------------------- build_attributes ---------------------------
3507: FUNCTION build_attributes (
3508: p_detail_attributes IN hxc_self_service_time_deposit.app_attributes_info
3509: )
3510: RETURN hxc_self_service_time_deposit.building_block_attribute_info
3511: IS
3512: CURSOR csr_wtd_components (
3513: p_deposit_process_id NUMBER,
3514: p_attribute_category VARCHAR2,

Line 3534: l_attributes hxc_self_service_time_deposit.building_block_attribute_info;

3530: AND mc.field_name = p_field_name
3531: AND bbit.bld_blk_info_type_id = bbui.bld_blk_info_type_id
3532: AND bbit.bld_blk_info_type = p_attribute_category;
3533:
3534: l_attributes hxc_self_service_time_deposit.building_block_attribute_info;
3535: l_attribute BINARY_INTEGER;
3536: l_attribute_index BINARY_INTEGER := 0;
3537: l_proc VARCHAR2 (70) := 'BUILD_ATTRIBUTES';
3538: l_exception EXCEPTION;