DBA Data[Home] [Help]

APPS.PAY_HR_OTC_RETRIEVAL_INTERFACE dependencies on HR_ALL_ORGANIZATION_UNITS

Line 23: p_bg_id IN hr_all_organization_units.business_group_id%TYPE

19: p_element_type_id IN pay_batch_lines.element_type_id%TYPE,
20: p_internal_input_value IN pay_batch_lines.value_1%TYPE,
21: p_iv_number IN PLS_INTEGER,
22: p_session_date IN DATE,
23: p_bg_id IN hr_all_organization_units.business_group_id%TYPE
24: )
25: RETURN VARCHAR2
26: IS
27: l_proc CONSTANT proc_name := g_package || 'display_value';

Line 324: p_bg_id IN hr_all_organization_units.business_group_id%TYPE,

320: hr_utility.set_location ('Leaving:' || l_proc, 100);
321: END process_bee_batches;
322:
323: FUNCTION where_clause (
324: p_bg_id IN hr_all_organization_units.business_group_id%TYPE,
325: p_location_id IN per_all_assignments_f.location_id%TYPE,
326: p_payroll_id IN per_all_assignments_f.payroll_id%TYPE,
327: p_organization_id IN per_all_assignments_f.organization_id%TYPE,
328: p_person_id IN per_all_people_f.person_id%TYPE,

Line 514: p_bg_id IN hr_all_organization_units.business_group_id%TYPE,

510: hr_utility.set_location ('Leaving ' || l_proc, 100);
511: END set_sqlerror_trx;
512:
513: PROCEDURE process_otlr_employees (
514: p_bg_id IN hr_all_organization_units.business_group_id%TYPE,
515: p_session_date IN DATE, -- Bug 6121705, need date for reversal batch creation
516: p_start_date IN VARCHAR2,
517: --hxc_time_building_blocks.start_time%TYPE,
518: p_end_date IN VARCHAR2,

Line 590: p_bg_id IN hr_all_organization_units.business_group_id%TYPE,

586: hr_utility.set_location ('Leaving ' || l_proc, 100);
587: END process_otlr_employees;
588:
589: PROCEDURE extract_data_from_attr_tbl (
590: p_bg_id IN hr_all_organization_units.business_group_id%TYPE,
591: p_attr_tbl IN hxc_generic_retrieval_pkg.t_time_attribute,
592: p_tbb_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
593: p_det_tbb_idx IN PLS_INTEGER,
594: p_cost_flex_id IN per_business_groups_perf.cost_allocation_structure%TYPE,

Line 1397: p_bg_id IN hr_all_organization_units.business_group_id%TYPE,

1393: hr_utility.set_location ('Leaving ' || l_proc, 100);
1394: END add_lines_to_bee_batch;
1395:
1396: PROCEDURE process_non_otlr_employees (
1397: p_bg_id IN hr_all_organization_units.business_group_id%TYPE,
1398: p_start_date IN hxc_time_building_blocks.start_time%TYPE,
1399: p_end_date IN hxc_time_building_blocks.stop_time%TYPE,
1400: p_session_date IN DATE,
1401: p_where_clause IN hxt_interface_utilities.max_varchar,

Line 2027: PROCEDURE make_adjustments_otm( p_bg_id IN hr_all_organization_units.business_group_id%TYPE,

2023: -- records for which there is a history of a different preference for rules
2024: -- evaluation.
2025:
2026:
2027: PROCEDURE make_adjustments_otm( p_bg_id IN hr_all_organization_units.business_group_id%TYPE,
2028: p_batch_ref IN VARCHAR2)
2029: IS
2030:
2031: l_new_batch NUMBER;