DBA Data[Home] [Help]

APPS.HXT_HXC_RETRIEVAL_PROCESS dependencies on HXT_OTC_RETRIEVAL_INTERFACE

Line 589: l_field_name hxt_otc_retrieval_interface.t_field_name;

585: -- local tables
586: TYPE t_tim_sum_id_tab IS TABLE OF NUMBER
587: INDEX BY BINARY_INTEGER;
588:
589: l_field_name hxt_otc_retrieval_interface.t_field_name;
590: l_value hxt_otc_retrieval_interface.t_value;
591: l_context hxt_otc_retrieval_interface.t_field_name;
592: l_category hxt_otc_retrieval_interface.t_field_name;
593: l_segment hxt_otc_retrieval_interface.t_segment;

Line 590: l_value hxt_otc_retrieval_interface.t_value;

586: TYPE t_tim_sum_id_tab IS TABLE OF NUMBER
587: INDEX BY BINARY_INTEGER;
588:
589: l_field_name hxt_otc_retrieval_interface.t_field_name;
590: l_value hxt_otc_retrieval_interface.t_value;
591: l_context hxt_otc_retrieval_interface.t_field_name;
592: l_category hxt_otc_retrieval_interface.t_field_name;
593: l_segment hxt_otc_retrieval_interface.t_segment;
594: l_bb_id NUMBER (15);

Line 591: l_context hxt_otc_retrieval_interface.t_field_name;

587: INDEX BY BINARY_INTEGER;
588:
589: l_field_name hxt_otc_retrieval_interface.t_field_name;
590: l_value hxt_otc_retrieval_interface.t_value;
591: l_context hxt_otc_retrieval_interface.t_field_name;
592: l_category hxt_otc_retrieval_interface.t_field_name;
593: l_segment hxt_otc_retrieval_interface.t_segment;
594: l_bb_id NUMBER (15);
595: l_ovn NUMBER (9);

Line 592: l_category hxt_otc_retrieval_interface.t_field_name;

588:
589: l_field_name hxt_otc_retrieval_interface.t_field_name;
590: l_value hxt_otc_retrieval_interface.t_value;
591: l_context hxt_otc_retrieval_interface.t_field_name;
592: l_category hxt_otc_retrieval_interface.t_field_name;
593: l_segment hxt_otc_retrieval_interface.t_segment;
594: l_bb_id NUMBER (15);
595: l_ovn NUMBER (9);
596: l_type VARCHAR2 (30);

Line 593: l_segment hxt_otc_retrieval_interface.t_segment;

589: l_field_name hxt_otc_retrieval_interface.t_field_name;
590: l_value hxt_otc_retrieval_interface.t_value;
591: l_context hxt_otc_retrieval_interface.t_field_name;
592: l_category hxt_otc_retrieval_interface.t_field_name;
593: l_segment hxt_otc_retrieval_interface.t_segment;
594: l_bb_id NUMBER (15);
595: l_ovn NUMBER (9);
596: l_type VARCHAR2 (30);
597: l_measure hxc_time_building_blocks.measure%TYPE;

Line 1048: INTO hxt_otc_retrieval_interface.g_full_name, l_bg_id

1044: hr_utility.set_location (l_proc, 37);
1045: END IF;
1046:
1047: SELECT full_name, business_group_id
1048: INTO hxt_otc_retrieval_interface.g_full_name, l_bg_id
1049: FROM per_all_people_f
1050: WHERE person_id = l_person_id
1051: AND l_effective_date BETWEEN effective_start_date
1052: AND effective_end_date;

Line 1078: -- l_employee_number := hxt_otc_retrieval_interface.get_employee_number(

1074: END;
1075:
1076: -- Get Employee Number
1077: --
1078: -- l_employee_number := hxt_otc_retrieval_interface.get_employee_number(
1079: -- l_person_id,
1080: -- l_effective_date);
1081: IF g_debug
1082: THEN

Line 1086: hxt_otc_retrieval_interface.get_assignment_id

1082: THEN
1083: hr_utility.set_location (l_proc, 39);
1084: END IF;
1085:
1086: hxt_otc_retrieval_interface.get_assignment_id
1087: (p_person_id => l_person_id,
1088: p_payroll_id => l_payroll_id,
1089: p_bg_id => l_bg_id,
1090: p_assignment_id => l_assignment_id,

Line 1185: hxt_otc_retrieval_interface.parse_attributes

1181: hr_utility.TRACE ('l_att is ' || TO_CHAR (l_att));
1182: hr_utility.set_location (l_proc, 60);
1183: END IF;
1184:
1185: hxt_otc_retrieval_interface.parse_attributes
1186: (p_category => l_category,
1187: p_field_name => l_field_name,
1188: p_value => l_value,
1189: p_context => l_context,

Line 1231: hxt_otc_retrieval_interface.find_existing_timecard

1227: END IF;
1228:
1229: -- Bug 7415291
1230: -- Added new parameter l_tim_id
1231: hxt_otc_retrieval_interface.find_existing_timecard
1232: (p_payroll_id => l_payroll_id,
1233: p_date_worked => l_date_worked,
1234: p_person_id => l_person_id,
1235: p_old_ovn => l_ovn,

Line 1847: l_field_name hxt_otc_retrieval_interface.t_field_name;

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;
1851: l_segment hxt_otc_retrieval_interface.t_segment;

Line 1848: l_value hxt_otc_retrieval_interface.t_value;

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;
1851: l_segment hxt_otc_retrieval_interface.t_segment;
1852: l_bb_id NUMBER (15);

Line 1849: l_context hxt_otc_retrieval_interface.t_field_name;

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;
1851: l_segment hxt_otc_retrieval_interface.t_segment;
1852: l_bb_id NUMBER (15);
1853: l_bb_ovn NUMBER (15);

Line 1850: l_category hxt_otc_retrieval_interface.t_field_name;

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;
1851: l_segment hxt_otc_retrieval_interface.t_segment;
1852: l_bb_id NUMBER (15);
1853: l_bb_ovn NUMBER (15);
1854: l_type VARCHAR2 (30);

Line 1851: l_segment hxt_otc_retrieval_interface.t_segment;

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;
1851: l_segment hxt_otc_retrieval_interface.t_segment;
1852: l_bb_id NUMBER (15);
1853: l_bb_ovn NUMBER (15);
1854: l_type VARCHAR2 (30);
1855: l_measure hxc_time_building_blocks.measure%TYPE;

Line 2346: hxt_otc_retrieval_interface.get_assignment_id

2342: --RAISE e_error;
2343: l_error_flag := 'Y';
2344: END;
2345:
2346: hxt_otc_retrieval_interface.get_assignment_id
2347: (p_person_id => l_person_id,
2348: p_payroll_id => l_payroll_id,
2349: p_bg_id => l_bg_id,
2350: p_assignment_id => l_assignment_id,

Line 2550: hxt_otc_retrieval_interface.parse_attributes

2546: THEN
2547: hr_utility.set_location (l_proc, 62);
2548: END IF;
2549:
2550: hxt_otc_retrieval_interface.parse_attributes
2551: (p_category => l_category,
2552: p_field_name => l_field_name,
2553: p_value => l_value,
2554: p_context => l_context,

Line 2611: hxt_otc_retrieval_interface.find_existing_timecard

2607: END IF;
2608:
2609: -- Bug 7415291
2610: -- Added new parameter l_tim_id
2611: hxt_otc_retrieval_interface.find_existing_timecard
2612: (p_payroll_id => l_payroll_id,
2613: p_date_worked => l_date_worked,
2614: p_person_id => l_person_id,
2615: p_old_ovn => l_bb_ovn,