DBA Data[Home] [Help]

APPS.PAY_HR_OTC_RETRIEVAL_INTERFACE dependencies on HR_ALL_ORGANIZATION_UNITS

Line 100: p_bg_id IN hr_all_organization_units.business_group_id%TYPE,

96: FUNCTION batches_created
97: RETURN batches_type_table;
98:
99: FUNCTION where_clause (
100: p_bg_id IN hr_all_organization_units.business_group_id%TYPE,
101: p_location_id IN per_all_assignments_f.location_id%TYPE,
102: p_payroll_id IN per_all_assignments_f.payroll_id%TYPE,
103: p_organization_id IN per_all_assignments_f.organization_id%TYPE,
104: p_person_id IN per_all_people_f.person_id%TYPE,

Line 110: p_bg_id IN hr_all_organization_units.business_group_id%TYPE,

106: )
107: RETURN VARCHAR2;
108:
109: PROCEDURE process_otlr_employees (
110: p_bg_id IN hr_all_organization_units.business_group_id%TYPE,
111: p_session_date IN DATE,
112: p_start_date IN VARCHAR2, --hxc_time_building_blocks.start_time%TYPE,
113: p_end_date IN VARCHAR2, --hxc_time_building_blocks.stop_time%TYPE,
114: p_where_clause IN hxt_interface_utilities.max_varchar,

Line 126: p_bg_id IN hr_all_organization_units.business_group_id%TYPE,

122: p_no_otm IN OUT NOCOPY hxt_interface_utilities.flag_varchar
123: );
124:
125: PROCEDURE extract_data_from_attr_tbl (
126: p_bg_id IN hr_all_organization_units.business_group_id%TYPE,
127: p_attr_tbl IN hxc_generic_retrieval_pkg.t_time_attribute,
128: p_tbb_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
129: p_det_tbb_idx IN PLS_INTEGER,
130: p_cost_flex_id IN per_business_groups_perf.cost_allocation_structure%TYPE,

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

217: p_session_date IN DATE
218: ) ;
219:
220:
221: PROCEDURE make_adjustments_otm( p_bg_id IN hr_all_organization_units.business_group_id%TYPE,
222: p_batch_ref IN VARCHAR2) ;
223:
224: TYPE r_bb_details IS
225: RECORD (