DBA Data[Home] [Help]

APPS.HXT_HXC_RETRIEVAL_PROCESS dependencies on HXT_OTC_RETRIEVAL_INTERFACE

Line 600: l_field_name hxt_otc_retrieval_interface.t_field_name;

596: -- local tables
597: TYPE t_tim_sum_id_tab IS TABLE OF NUMBER
598: INDEX BY BINARY_INTEGER;
599:
600: l_field_name hxt_otc_retrieval_interface.t_field_name;
601: l_value hxt_otc_retrieval_interface.t_value;
602: l_context hxt_otc_retrieval_interface.t_field_name;
603: l_category hxt_otc_retrieval_interface.t_field_name;
604: l_segment hxt_otc_retrieval_interface.t_segment;

Line 601: l_value hxt_otc_retrieval_interface.t_value;

597: TYPE t_tim_sum_id_tab IS TABLE OF NUMBER
598: INDEX BY BINARY_INTEGER;
599:
600: l_field_name hxt_otc_retrieval_interface.t_field_name;
601: l_value hxt_otc_retrieval_interface.t_value;
602: l_context hxt_otc_retrieval_interface.t_field_name;
603: l_category hxt_otc_retrieval_interface.t_field_name;
604: l_segment hxt_otc_retrieval_interface.t_segment;
605: l_bb_id NUMBER (15);

Line 602: l_context hxt_otc_retrieval_interface.t_field_name;

598: INDEX BY BINARY_INTEGER;
599:
600: l_field_name hxt_otc_retrieval_interface.t_field_name;
601: l_value hxt_otc_retrieval_interface.t_value;
602: l_context hxt_otc_retrieval_interface.t_field_name;
603: l_category hxt_otc_retrieval_interface.t_field_name;
604: l_segment hxt_otc_retrieval_interface.t_segment;
605: l_bb_id NUMBER (15);
606: l_ovn NUMBER (9);

Line 603: l_category hxt_otc_retrieval_interface.t_field_name;

599:
600: l_field_name hxt_otc_retrieval_interface.t_field_name;
601: l_value hxt_otc_retrieval_interface.t_value;
602: l_context hxt_otc_retrieval_interface.t_field_name;
603: l_category hxt_otc_retrieval_interface.t_field_name;
604: l_segment hxt_otc_retrieval_interface.t_segment;
605: l_bb_id NUMBER (15);
606: l_ovn NUMBER (9);
607: l_type VARCHAR2 (30);

Line 604: l_segment hxt_otc_retrieval_interface.t_segment;

600: l_field_name hxt_otc_retrieval_interface.t_field_name;
601: l_value hxt_otc_retrieval_interface.t_value;
602: l_context hxt_otc_retrieval_interface.t_field_name;
603: l_category hxt_otc_retrieval_interface.t_field_name;
604: l_segment hxt_otc_retrieval_interface.t_segment;
605: l_bb_id NUMBER (15);
606: l_ovn NUMBER (9);
607: l_type VARCHAR2 (30);
608: l_measure hxc_time_building_blocks.measure%TYPE;

Line 1074: INTO hxt_otc_retrieval_interface.g_full_name, l_bg_id

1070: hr_utility.set_location (l_proc, 37);
1071: END IF;
1072:
1073: SELECT full_name, business_group_id
1074: INTO hxt_otc_retrieval_interface.g_full_name, l_bg_id
1075: FROM per_all_people_f
1076: WHERE person_id = l_person_id
1077: AND l_effective_date BETWEEN effective_start_date
1078: AND effective_end_date;

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

1100: END;
1101:
1102: -- Get Employee Number
1103: --
1104: -- l_employee_number := hxt_otc_retrieval_interface.get_employee_number(
1105: -- l_person_id,
1106: -- l_effective_date);
1107: IF g_debug
1108: THEN

Line 1112: hxt_otc_retrieval_interface.get_assignment_id

1108: THEN
1109: hr_utility.set_location (l_proc, 39);
1110: END IF;
1111:
1112: hxt_otc_retrieval_interface.get_assignment_id
1113: (p_person_id => l_person_id,
1114: p_payroll_id => l_payroll_id,
1115: p_bg_id => l_bg_id,
1116: p_assignment_id => l_assignment_id,

Line 1211: hxt_otc_retrieval_interface.parse_attributes

1207: hr_utility.TRACE ('l_att is ' || TO_CHAR (l_att));
1208: hr_utility.set_location (l_proc, 60);
1209: END IF;
1210:
1211: hxt_otc_retrieval_interface.parse_attributes
1212: (p_category => l_category,
1213: p_field_name => l_field_name,
1214: p_value => l_value,
1215: p_context => l_context,

Line 1258: hxt_otc_retrieval_interface.find_existing_timecard

1254: END IF;
1255:
1256: -- Bug 7415291
1257: -- Added new parameter l_tim_id
1258: hxt_otc_retrieval_interface.find_existing_timecard
1259: (p_payroll_id => l_payroll_id,
1260: p_date_worked => l_date_worked,
1261: p_person_id => l_person_id,
1262: p_old_ovn => l_ovn,

Line 1887: l_field_name hxt_otc_retrieval_interface.t_field_name;

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

Line 1888: l_value hxt_otc_retrieval_interface.t_value;

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

Line 1889: l_context hxt_otc_retrieval_interface.t_field_name;

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;
1891: l_segment hxt_otc_retrieval_interface.t_segment;
1892: l_bb_id NUMBER (15);
1893: l_bb_ovn NUMBER (15);

Line 1890: l_category hxt_otc_retrieval_interface.t_field_name;

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;
1891: l_segment hxt_otc_retrieval_interface.t_segment;
1892: l_bb_id NUMBER (15);
1893: l_bb_ovn NUMBER (15);
1894: l_type VARCHAR2 (30);

Line 1891: l_segment hxt_otc_retrieval_interface.t_segment;

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;
1891: l_segment hxt_otc_retrieval_interface.t_segment;
1892: l_bb_id NUMBER (15);
1893: l_bb_ovn NUMBER (15);
1894: l_type VARCHAR2 (30);
1895: l_measure hxc_time_building_blocks.measure%TYPE;

Line 2420: hxt_otc_retrieval_interface.get_assignment_id

2416: --RAISE e_error;
2417: l_error_flag := 'Y';
2418: END;
2419:
2420: hxt_otc_retrieval_interface.get_assignment_id
2421: (p_person_id => l_person_id,
2422: p_payroll_id => l_payroll_id,
2423: p_bg_id => l_bg_id,
2424: p_assignment_id => l_assignment_id,

Line 2624: hxt_otc_retrieval_interface.parse_attributes

2620: THEN
2621: hr_utility.set_location (l_proc, 62);
2622: END IF;
2623:
2624: hxt_otc_retrieval_interface.parse_attributes
2625: (p_category => l_category,
2626: p_field_name => l_field_name,
2627: p_value => l_value,
2628: p_context => l_context,

Line 2686: hxt_otc_retrieval_interface.find_existing_timecard

2682: END IF;
2683:
2684: -- Bug 7415291
2685: -- Added new parameter l_tim_id
2686: hxt_otc_retrieval_interface.find_existing_timecard
2687: (p_payroll_id => l_payroll_id,
2688: p_date_worked => l_date_worked,
2689: p_person_id => l_person_id,
2690: p_old_ovn => l_bb_ovn,