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 527: l_blocks hxc_self_service_time_deposit.timecard_info;

523: p_time_attributes IN OUT NOCOPY VARCHAR2,
524: p_messages IN OUT NOCOPY VARCHAR2
525: )
526: IS
527: l_blocks hxc_self_service_time_deposit.timecard_info;
528: l_attributes hxc_self_service_time_deposit.app_attributes_info;
529: l_messages hxc_self_service_time_deposit.message_table;
530: l_proc VARCHAR2 (100);
531: BEGIN

Line 528: l_attributes hxc_self_service_time_deposit.app_attributes_info;

524: p_messages IN OUT NOCOPY VARCHAR2
525: )
526: IS
527: l_blocks hxc_self_service_time_deposit.timecard_info;
528: l_attributes hxc_self_service_time_deposit.app_attributes_info;
529: l_messages hxc_self_service_time_deposit.message_table;
530: l_proc VARCHAR2 (100);
531: BEGIN
532: g_debug := hr_utility.debug_enabled;

Line 529: l_messages hxc_self_service_time_deposit.message_table;

525: )
526: IS
527: l_blocks hxc_self_service_time_deposit.timecard_info;
528: l_attributes hxc_self_service_time_deposit.app_attributes_info;
529: l_messages hxc_self_service_time_deposit.message_table;
530: l_proc VARCHAR2 (100);
531: BEGIN
532: g_debug := hr_utility.debug_enabled;
533:

Line 578: p_time_building_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,

574:
575: --------------------------- validate_timecard ------------------------------
576: PROCEDURE validate_timecard (
577: p_operation IN VARCHAR2,
578: p_time_building_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
579: p_time_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
580: p_messages IN OUT NOCOPY hxc_self_service_time_deposit.message_table
581: )
582: IS

Line 579: p_time_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,

575: --------------------------- validate_timecard ------------------------------
576: PROCEDURE validate_timecard (
577: p_operation IN VARCHAR2,
578: p_time_building_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
579: p_time_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
580: p_messages IN OUT NOCOPY hxc_self_service_time_deposit.message_table
581: )
582: IS
583: CURSOR get_timecard_id (p_tim_sum_id NUMBER)

Line 580: p_messages IN OUT NOCOPY hxc_self_service_time_deposit.message_table

576: PROCEDURE validate_timecard (
577: p_operation IN VARCHAR2,
578: p_time_building_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
579: p_time_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info,
580: p_messages IN OUT NOCOPY hxc_self_service_time_deposit.message_table
581: )
582: IS
583: CURSOR get_timecard_id (p_tim_sum_id NUMBER)
584: IS

Line 1700: p_time_building_blocks IN hxc_self_service_time_deposit.timecard_info,

1696: p_otm_rtr_id IN NUMBER,
1697: p_app_set_id IN NUMBER,
1698: p_timecard_id IN NUMBER,
1699: p_timecard_ovn IN NUMBER,
1700: p_time_building_blocks IN hxc_self_service_time_deposit.timecard_info,
1701: p_time_att_info IN hxc_self_service_time_deposit.app_attributes_info,
1702: p_messages IN OUT NOCOPY hxc_self_service_time_deposit.message_table
1703: )
1704: IS

Line 1701: p_time_att_info IN hxc_self_service_time_deposit.app_attributes_info,

1697: p_app_set_id IN NUMBER,
1698: p_timecard_id IN NUMBER,
1699: p_timecard_ovn IN NUMBER,
1700: p_time_building_blocks IN hxc_self_service_time_deposit.timecard_info,
1701: p_time_att_info IN hxc_self_service_time_deposit.app_attributes_info,
1702: p_messages IN OUT NOCOPY hxc_self_service_time_deposit.message_table
1703: )
1704: IS
1705: -- retrieves list of time recipients in retrieval rule group

Line 1702: p_messages IN OUT NOCOPY hxc_self_service_time_deposit.message_table

1698: p_timecard_id IN NUMBER,
1699: p_timecard_ovn IN NUMBER,
1700: p_time_building_blocks IN hxc_self_service_time_deposit.timecard_info,
1701: p_time_att_info IN hxc_self_service_time_deposit.app_attributes_info,
1702: p_messages IN OUT NOCOPY hxc_self_service_time_deposit.message_table
1703: )
1704: IS
1705: -- retrieves list of time recipients in retrieval rule group
1706: CURSOR csr_get_rtr (p_rtr_id NUMBER)

Line 1727: l_time_building_blocks hxc_self_service_time_deposit.timecard_info

1723: t_aps_tr t_time_recipient;
1724: t_rtr_tr t_time_recipient;
1725: l_rtr_tr_id hxc_time_recipients.time_recipient_id%TYPE;
1726: l_aps_tr_id hxc_time_recipients.time_recipient_id%TYPE;
1727: l_time_building_blocks hxc_self_service_time_deposit.timecard_info
1728: := p_time_building_blocks;
1729: l_time_att_info hxc_self_service_time_deposit.app_attributes_info
1730: := p_time_att_info;
1731: l_proc VARCHAR2 (250);

Line 1729: l_time_att_info hxc_self_service_time_deposit.app_attributes_info

1725: l_rtr_tr_id hxc_time_recipients.time_recipient_id%TYPE;
1726: l_aps_tr_id hxc_time_recipients.time_recipient_id%TYPE;
1727: l_time_building_blocks hxc_self_service_time_deposit.timecard_info
1728: := p_time_building_blocks;
1729: l_time_att_info hxc_self_service_time_deposit.app_attributes_info
1730: := p_time_att_info;
1731: l_proc VARCHAR2 (250);
1732: BEGIN
1733: g_debug := hr_utility.debug_enabled;

Line 1856: p_time_building_blocks IN hxc_self_service_time_deposit.timecard_info,

1852: --
1853: ------------------------------ otlr_review_details -----------------------------
1854: --
1855: PROCEDURE otlr_review_details (
1856: p_time_building_blocks IN hxc_self_service_time_deposit.timecard_info,
1857: p_time_attributes IN hxc_self_service_time_deposit.app_attributes_info,
1858: p_messages IN OUT NOCOPY hxc_self_service_time_deposit.message_table,
1859: p_detail_build_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
1860: p_detail_attributes IN OUT NOCOPY hxc_self_service_time_deposit.building_block_attribute_info

Line 1857: p_time_attributes IN hxc_self_service_time_deposit.app_attributes_info,

1853: ------------------------------ otlr_review_details -----------------------------
1854: --
1855: PROCEDURE otlr_review_details (
1856: p_time_building_blocks IN hxc_self_service_time_deposit.timecard_info,
1857: p_time_attributes IN hxc_self_service_time_deposit.app_attributes_info,
1858: p_messages IN OUT NOCOPY hxc_self_service_time_deposit.message_table,
1859: p_detail_build_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
1860: p_detail_attributes IN OUT NOCOPY hxc_self_service_time_deposit.building_block_attribute_info
1861: )

Line 1858: p_messages IN OUT NOCOPY hxc_self_service_time_deposit.message_table,

1854: --
1855: PROCEDURE otlr_review_details (
1856: p_time_building_blocks IN hxc_self_service_time_deposit.timecard_info,
1857: p_time_attributes IN hxc_self_service_time_deposit.app_attributes_info,
1858: p_messages IN OUT NOCOPY hxc_self_service_time_deposit.message_table,
1859: p_detail_build_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
1860: p_detail_attributes IN OUT NOCOPY hxc_self_service_time_deposit.building_block_attribute_info
1861: )
1862: IS

Line 1859: p_detail_build_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,

1855: PROCEDURE otlr_review_details (
1856: p_time_building_blocks IN hxc_self_service_time_deposit.timecard_info,
1857: p_time_attributes IN hxc_self_service_time_deposit.app_attributes_info,
1858: p_messages IN OUT NOCOPY hxc_self_service_time_deposit.message_table,
1859: p_detail_build_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
1860: p_detail_attributes IN OUT NOCOPY hxc_self_service_time_deposit.building_block_attribute_info
1861: )
1862: IS
1863: CURSOR get_otm_records (p_tim_sum_id NUMBER)

Line 1860: p_detail_attributes IN OUT NOCOPY hxc_self_service_time_deposit.building_block_attribute_info

1856: p_time_building_blocks IN hxc_self_service_time_deposit.timecard_info,
1857: p_time_attributes IN hxc_self_service_time_deposit.app_attributes_info,
1858: p_messages IN OUT NOCOPY hxc_self_service_time_deposit.message_table,
1859: p_detail_build_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
1860: p_detail_attributes IN OUT NOCOPY hxc_self_service_time_deposit.building_block_attribute_info
1861: )
1862: IS
1863: CURSOR get_otm_records (p_tim_sum_id NUMBER)
1864: IS

Line 1885: l_timecard_detail hxc_self_service_time_deposit.timecard_info;

1881:
1882: TYPE t_tim_sum_id_tab IS TABLE OF NUMBER
1883: INDEX BY BINARY_INTEGER;
1884:
1885: l_timecard_detail hxc_self_service_time_deposit.timecard_info;
1886: l_detail_attributes hxc_self_service_time_deposit.app_attributes_info;
1887: l_field_name hxt_otc_retrieval_interface.t_field_name;
1888: l_value hxt_otc_retrieval_interface.t_value;
1889: l_context hxt_otc_retrieval_interface.t_field_name;

Line 1886: l_detail_attributes hxc_self_service_time_deposit.app_attributes_info;

1882: TYPE t_tim_sum_id_tab IS TABLE OF NUMBER
1883: INDEX BY BINARY_INTEGER;
1884:
1885: l_timecard_detail hxc_self_service_time_deposit.timecard_info;
1886: l_detail_attributes hxc_self_service_time_deposit.app_attributes_info;
1887: l_field_name hxt_otc_retrieval_interface.t_field_name;
1888: l_value hxt_otc_retrieval_interface.t_value;
1889: l_context hxt_otc_retrieval_interface.t_field_name;
1890: l_category hxt_otc_retrieval_interface.t_field_name;

Line 1963: l_time_building_blocks hxc_self_service_time_deposit.timecard_info

1959: l_state_name hxt_sum_hours_worked_f.state_name%TYPE;
1960: l_county_name hxt_sum_hours_worked_f.county_name%TYPE;
1961: l_city_name hxt_sum_hours_worked_f.city_name%TYPE;
1962: l_zip_code hxt_sum_hours_worked_f.zip_code%TYPE;
1963: l_time_building_blocks hxc_self_service_time_deposit.timecard_info
1964: := p_time_building_blocks;
1965: l_time_attributes hxc_self_service_time_deposit.app_attributes_info
1966: := p_time_attributes;
1967: l_tim_id NUMBER;

Line 1965: l_time_attributes hxc_self_service_time_deposit.app_attributes_info

1961: l_city_name hxt_sum_hours_worked_f.city_name%TYPE;
1962: l_zip_code hxt_sum_hours_worked_f.zip_code%TYPE;
1963: l_time_building_blocks hxc_self_service_time_deposit.timecard_info
1964: := p_time_building_blocks;
1965: l_time_attributes hxc_self_service_time_deposit.app_attributes_info
1966: := p_time_attributes;
1967: l_tim_id NUMBER;
1968:
1969: l_error_exists BOOLEAN := FALSE;

Line 3584: p_detail_attributes IN hxc_self_service_time_deposit.app_attributes_info

3580: END otlr_review_details;
3581:
3582: --------------------------- build_attributes ---------------------------
3583: FUNCTION build_attributes (
3584: p_detail_attributes IN hxc_self_service_time_deposit.app_attributes_info
3585: )
3586: RETURN hxc_self_service_time_deposit.building_block_attribute_info
3587: IS
3588: CURSOR csr_wtd_components (

Line 3586: RETURN hxc_self_service_time_deposit.building_block_attribute_info

3582: --------------------------- build_attributes ---------------------------
3583: FUNCTION build_attributes (
3584: p_detail_attributes IN hxc_self_service_time_deposit.app_attributes_info
3585: )
3586: RETURN hxc_self_service_time_deposit.building_block_attribute_info
3587: IS
3588: CURSOR csr_wtd_components (
3589: p_deposit_process_id NUMBER,
3590: p_attribute_category VARCHAR2,

Line 3610: l_attributes hxc_self_service_time_deposit.building_block_attribute_info;

3606: AND mc.field_name = p_field_name
3607: AND bbit.bld_blk_info_type_id = bbui.bld_blk_info_type_id
3608: AND bbit.bld_blk_info_type = p_attribute_category;
3609:
3610: l_attributes hxc_self_service_time_deposit.building_block_attribute_info;
3611: l_attribute BINARY_INTEGER;
3612: l_attribute_index BINARY_INTEGER := 0;
3613: l_proc VARCHAR2 (70) := 'BUILD_ATTRIBUTES';
3614: l_exception EXCEPTION;

Line 3882: PROCEDURE check_restrict_edit( p_time_building_blocks IN HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info,

3878:
3879: -- Bug 7557568
3880: -- Added this new function to check if a deletion was done on
3881: -- the building blocks after a SAVE was done.
3882: PROCEDURE check_restrict_edit( p_time_building_blocks IN HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info,
3883: p_messages IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.message_table )
3884:
3885: IS
3886:

Line 3883: p_messages IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.message_table )

3879: -- Bug 7557568
3880: -- Added this new function to check if a deletion was done on
3881: -- the building blocks after a SAVE was done.
3882: PROCEDURE check_restrict_edit( p_time_building_blocks IN HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info,
3883: p_messages IN OUT NOCOPY HXC_SELF_SERVICE_TIME_DEPOSIT.message_table )
3884:
3885: IS
3886:
3887: