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_INTERFACE_UTILITIES dependencies on PER_ALL_ASSIGNMENTS_F

Line 14: asg_type per_all_assignments_f.assignment_type%TYPE

10:
11: SUBTYPE package_name IS VARCHAR2 (32);
12:
13: TYPE asg_type_rec IS RECORD (
14: asg_type per_all_assignments_f.assignment_type%TYPE
15: );
16:
17: TYPE asg_system_status_rec IS RECORD (
18: asg_system_status per_assignment_status_types.per_system_status%TYPE

Line 57: assignment_id per_all_assignments_f.assignment_id%TYPE,

53: TYPE iv_translation_table IS TABLE OF iv_translation_rec
54: INDEX BY BINARY_INTEGER;
55:
56: TYPE primary_assignment_rec IS RECORD (
57: assignment_id per_all_assignments_f.assignment_id%TYPE,
58: effective_start_date per_all_assignments_f.effective_start_date%TYPE,
59: effective_end_date per_all_assignments_f.effective_end_date%TYPE,
60: assignment_type per_all_assignments_f.assignment_type%TYPE,
61: per_system_status per_assignment_status_types.per_system_status%TYPE

Line 58: effective_start_date per_all_assignments_f.effective_start_date%TYPE,

54: INDEX BY BINARY_INTEGER;
55:
56: TYPE primary_assignment_rec IS RECORD (
57: assignment_id per_all_assignments_f.assignment_id%TYPE,
58: effective_start_date per_all_assignments_f.effective_start_date%TYPE,
59: effective_end_date per_all_assignments_f.effective_end_date%TYPE,
60: assignment_type per_all_assignments_f.assignment_type%TYPE,
61: per_system_status per_assignment_status_types.per_system_status%TYPE
62: );

Line 59: effective_end_date per_all_assignments_f.effective_end_date%TYPE,

55:
56: TYPE primary_assignment_rec IS RECORD (
57: assignment_id per_all_assignments_f.assignment_id%TYPE,
58: effective_start_date per_all_assignments_f.effective_start_date%TYPE,
59: effective_end_date per_all_assignments_f.effective_end_date%TYPE,
60: assignment_type per_all_assignments_f.assignment_type%TYPE,
61: per_system_status per_assignment_status_types.per_system_status%TYPE
62: );
63:

Line 60: assignment_type per_all_assignments_f.assignment_type%TYPE,

56: TYPE primary_assignment_rec IS RECORD (
57: assignment_id per_all_assignments_f.assignment_id%TYPE,
58: effective_start_date per_all_assignments_f.effective_start_date%TYPE,
59: effective_end_date per_all_assignments_f.effective_end_date%TYPE,
60: assignment_type per_all_assignments_f.assignment_type%TYPE,
61: per_system_status per_assignment_status_types.per_system_status%TYPE
62: );
63:
64: TYPE primary_assignment_table IS TABLE OF primary_assignment_rec

Line 78: effective_start_date per_all_assignments_f.effective_start_date%TYPE,

74: TYPE flex_value_table IS TABLE OF flex_value_rec
75: INDEX BY VARCHAR2(255);
76:
77: TYPE assignment_info_rec IS RECORD (
78: effective_start_date per_all_assignments_f.effective_start_date%TYPE,
79: effective_end_date per_all_assignments_f.effective_end_date%TYPE,
80: assignment_number per_all_assignments_f.assignment_number%TYPE,
81: payroll_id per_all_assignments_f.payroll_id%TYPE,
82: organization_id per_all_assignments_f.organization_id%TYPE,

Line 79: effective_end_date per_all_assignments_f.effective_end_date%TYPE,

75: INDEX BY VARCHAR2(255);
76:
77: TYPE assignment_info_rec IS RECORD (
78: effective_start_date per_all_assignments_f.effective_start_date%TYPE,
79: effective_end_date per_all_assignments_f.effective_end_date%TYPE,
80: assignment_number per_all_assignments_f.assignment_number%TYPE,
81: payroll_id per_all_assignments_f.payroll_id%TYPE,
82: organization_id per_all_assignments_f.organization_id%TYPE,
83: location_id per_all_assignments_f.location_id%TYPE,

Line 80: assignment_number per_all_assignments_f.assignment_number%TYPE,

76:
77: TYPE assignment_info_rec IS RECORD (
78: effective_start_date per_all_assignments_f.effective_start_date%TYPE,
79: effective_end_date per_all_assignments_f.effective_end_date%TYPE,
80: assignment_number per_all_assignments_f.assignment_number%TYPE,
81: payroll_id per_all_assignments_f.payroll_id%TYPE,
82: organization_id per_all_assignments_f.organization_id%TYPE,
83: location_id per_all_assignments_f.location_id%TYPE,
84: business_group_id per_all_assignments_f.business_group_id%TYPE,

Line 81: payroll_id per_all_assignments_f.payroll_id%TYPE,

77: TYPE assignment_info_rec IS RECORD (
78: effective_start_date per_all_assignments_f.effective_start_date%TYPE,
79: effective_end_date per_all_assignments_f.effective_end_date%TYPE,
80: assignment_number per_all_assignments_f.assignment_number%TYPE,
81: payroll_id per_all_assignments_f.payroll_id%TYPE,
82: organization_id per_all_assignments_f.organization_id%TYPE,
83: location_id per_all_assignments_f.location_id%TYPE,
84: business_group_id per_all_assignments_f.business_group_id%TYPE,
85: assignment_type per_all_assignments_f.assignment_type%TYPE

Line 82: organization_id per_all_assignments_f.organization_id%TYPE,

78: effective_start_date per_all_assignments_f.effective_start_date%TYPE,
79: effective_end_date per_all_assignments_f.effective_end_date%TYPE,
80: assignment_number per_all_assignments_f.assignment_number%TYPE,
81: payroll_id per_all_assignments_f.payroll_id%TYPE,
82: organization_id per_all_assignments_f.organization_id%TYPE,
83: location_id per_all_assignments_f.location_id%TYPE,
84: business_group_id per_all_assignments_f.business_group_id%TYPE,
85: assignment_type per_all_assignments_f.assignment_type%TYPE
86: );

Line 83: location_id per_all_assignments_f.location_id%TYPE,

79: effective_end_date per_all_assignments_f.effective_end_date%TYPE,
80: assignment_number per_all_assignments_f.assignment_number%TYPE,
81: payroll_id per_all_assignments_f.payroll_id%TYPE,
82: organization_id per_all_assignments_f.organization_id%TYPE,
83: location_id per_all_assignments_f.location_id%TYPE,
84: business_group_id per_all_assignments_f.business_group_id%TYPE,
85: assignment_type per_all_assignments_f.assignment_type%TYPE
86: );
87:

Line 84: business_group_id per_all_assignments_f.business_group_id%TYPE,

80: assignment_number per_all_assignments_f.assignment_number%TYPE,
81: payroll_id per_all_assignments_f.payroll_id%TYPE,
82: organization_id per_all_assignments_f.organization_id%TYPE,
83: location_id per_all_assignments_f.location_id%TYPE,
84: business_group_id per_all_assignments_f.business_group_id%TYPE,
85: assignment_type per_all_assignments_f.assignment_type%TYPE
86: );
87:
88: TYPE assignment_info_table IS TABLE OF assignment_info_rec

Line 85: assignment_type per_all_assignments_f.assignment_type%TYPE

81: payroll_id per_all_assignments_f.payroll_id%TYPE,
82: organization_id per_all_assignments_f.organization_id%TYPE,
83: location_id per_all_assignments_f.location_id%TYPE,
84: business_group_id per_all_assignments_f.business_group_id%TYPE,
85: assignment_type per_all_assignments_f.assignment_type%TYPE
86: );
87:
88: TYPE assignment_info_table IS TABLE OF assignment_info_rec
89: INDEX BY BINARY_INTEGER;

Line 113: g_asg_type_employed CONSTANT per_all_assignments_f.assignment_type%TYPE

109: g_cost_flex_code CONSTANT fnd_id_flex_segments.id_flex_code%TYPE
110: := 'COST';
111: g_batch_status_transferred CONSTANT pay_batch_headers.batch_status%TYPE
112: := 'T';
113: g_asg_type_employed CONSTANT per_all_assignments_f.assignment_type%TYPE
114: := 'E';
115: g_element_attribute CONSTANT hxc_mapping_components.field_name%TYPE
116: := 'DUMMY ELEMENT CONTEXT';
117: g_cost_attribute CONSTANT hxc_mapping_components.field_name%TYPE

Line 230: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,

226: )
227: RETURN BOOLEAN;
228:
229: FUNCTION gre (
230: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
231: p_effective_date IN per_all_assignments_f.effective_start_date%TYPE
232: )
233: RETURN hr_soft_coding_keyflex.segment1%TYPE;
234:

Line 231: p_effective_date IN per_all_assignments_f.effective_start_date%TYPE

227: RETURN BOOLEAN;
228:
229: FUNCTION gre (
230: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
231: p_effective_date IN per_all_assignments_f.effective_start_date%TYPE
232: )
233: RETURN hr_soft_coding_keyflex.segment1%TYPE;
234:
235: FUNCTION valid_assignment_type (

Line 236: p_asg_type IN per_all_assignments_f.assignment_type%TYPE,

232: )
233: RETURN hr_soft_coding_keyflex.segment1%TYPE;
234:
235: FUNCTION valid_assignment_type (
236: p_asg_type IN per_all_assignments_f.assignment_type%TYPE,
237: p_validation_tbl IN asg_type_table
238: )
239: RETURN BOOLEAN;
240:

Line 253: RETURN per_all_assignments_f.assignment_id%TYPE;

249: p_effective_date IN DATE,
250: p_valid_asg_types IN asg_type_table,
251: p_valid_asg_status_types IN asg_system_status_table
252: )
253: RETURN per_all_assignments_f.assignment_id%TYPE;
254:
255: PROCEDURE get_assignment_info (
256: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
257: p_effective_date IN per_all_assignments_f.effective_end_date%TYPE,

Line 256: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,

252: )
253: RETURN per_all_assignments_f.assignment_id%TYPE;
254:
255: PROCEDURE get_assignment_info (
256: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
257: p_effective_date IN per_all_assignments_f.effective_end_date%TYPE,
258: p_assignment_number OUT NOCOPY per_all_assignments_f.assignment_number%TYPE,
259: p_payroll_id OUT NOCOPY per_all_assignments_f.payroll_id%TYPE,
260: p_org_id OUT NOCOPY per_all_assignments_f.organization_id%TYPE,

Line 257: p_effective_date IN per_all_assignments_f.effective_end_date%TYPE,

253: RETURN per_all_assignments_f.assignment_id%TYPE;
254:
255: PROCEDURE get_assignment_info (
256: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
257: p_effective_date IN per_all_assignments_f.effective_end_date%TYPE,
258: p_assignment_number OUT NOCOPY per_all_assignments_f.assignment_number%TYPE,
259: p_payroll_id OUT NOCOPY per_all_assignments_f.payroll_id%TYPE,
260: p_org_id OUT NOCOPY per_all_assignments_f.organization_id%TYPE,
261: p_location_id OUT NOCOPY per_all_assignments_f.location_id%TYPE,

Line 258: p_assignment_number OUT NOCOPY per_all_assignments_f.assignment_number%TYPE,

254:
255: PROCEDURE get_assignment_info (
256: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
257: p_effective_date IN per_all_assignments_f.effective_end_date%TYPE,
258: p_assignment_number OUT NOCOPY per_all_assignments_f.assignment_number%TYPE,
259: p_payroll_id OUT NOCOPY per_all_assignments_f.payroll_id%TYPE,
260: p_org_id OUT NOCOPY per_all_assignments_f.organization_id%TYPE,
261: p_location_id OUT NOCOPY per_all_assignments_f.location_id%TYPE,
262: p_bg_id OUT NOCOPY per_all_assignments_f.business_group_id%TYPE

Line 259: p_payroll_id OUT NOCOPY per_all_assignments_f.payroll_id%TYPE,

255: PROCEDURE get_assignment_info (
256: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
257: p_effective_date IN per_all_assignments_f.effective_end_date%TYPE,
258: p_assignment_number OUT NOCOPY per_all_assignments_f.assignment_number%TYPE,
259: p_payroll_id OUT NOCOPY per_all_assignments_f.payroll_id%TYPE,
260: p_org_id OUT NOCOPY per_all_assignments_f.organization_id%TYPE,
261: p_location_id OUT NOCOPY per_all_assignments_f.location_id%TYPE,
262: p_bg_id OUT NOCOPY per_all_assignments_f.business_group_id%TYPE
263: );

Line 260: p_org_id OUT NOCOPY per_all_assignments_f.organization_id%TYPE,

256: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
257: p_effective_date IN per_all_assignments_f.effective_end_date%TYPE,
258: p_assignment_number OUT NOCOPY per_all_assignments_f.assignment_number%TYPE,
259: p_payroll_id OUT NOCOPY per_all_assignments_f.payroll_id%TYPE,
260: p_org_id OUT NOCOPY per_all_assignments_f.organization_id%TYPE,
261: p_location_id OUT NOCOPY per_all_assignments_f.location_id%TYPE,
262: p_bg_id OUT NOCOPY per_all_assignments_f.business_group_id%TYPE
263: );
264:

Line 261: p_location_id OUT NOCOPY per_all_assignments_f.location_id%TYPE,

257: p_effective_date IN per_all_assignments_f.effective_end_date%TYPE,
258: p_assignment_number OUT NOCOPY per_all_assignments_f.assignment_number%TYPE,
259: p_payroll_id OUT NOCOPY per_all_assignments_f.payroll_id%TYPE,
260: p_org_id OUT NOCOPY per_all_assignments_f.organization_id%TYPE,
261: p_location_id OUT NOCOPY per_all_assignments_f.location_id%TYPE,
262: p_bg_id OUT NOCOPY per_all_assignments_f.business_group_id%TYPE
263: );
264:
265: PROCEDURE get_primary_assignment_info (

Line 262: p_bg_id OUT NOCOPY per_all_assignments_f.business_group_id%TYPE

258: p_assignment_number OUT NOCOPY per_all_assignments_f.assignment_number%TYPE,
259: p_payroll_id OUT NOCOPY per_all_assignments_f.payroll_id%TYPE,
260: p_org_id OUT NOCOPY per_all_assignments_f.organization_id%TYPE,
261: p_location_id OUT NOCOPY per_all_assignments_f.location_id%TYPE,
262: p_bg_id OUT NOCOPY per_all_assignments_f.business_group_id%TYPE
263: );
264:
265: PROCEDURE get_primary_assignment_info (
266: p_person_id IN per_all_assignments_f.person_id%TYPE,

Line 266: p_person_id IN per_all_assignments_f.person_id%TYPE,

262: p_bg_id OUT NOCOPY per_all_assignments_f.business_group_id%TYPE
263: );
264:
265: PROCEDURE get_primary_assignment_info (
266: p_person_id IN per_all_assignments_f.person_id%TYPE,
267: p_effective_date IN per_all_assignments_f.effective_end_date%TYPE,
268: p_assignment_id OUT NOCOPY per_all_assignments_f.assignment_id%TYPE,
269: p_assignment_number OUT NOCOPY per_all_assignments_f.assignment_number%TYPE,
270: p_payroll_id OUT NOCOPY per_all_assignments_f.payroll_id%TYPE,

Line 267: p_effective_date IN per_all_assignments_f.effective_end_date%TYPE,

263: );
264:
265: PROCEDURE get_primary_assignment_info (
266: p_person_id IN per_all_assignments_f.person_id%TYPE,
267: p_effective_date IN per_all_assignments_f.effective_end_date%TYPE,
268: p_assignment_id OUT NOCOPY per_all_assignments_f.assignment_id%TYPE,
269: p_assignment_number OUT NOCOPY per_all_assignments_f.assignment_number%TYPE,
270: p_payroll_id OUT NOCOPY per_all_assignments_f.payroll_id%TYPE,
271: p_org_id OUT NOCOPY per_all_assignments_f.organization_id%TYPE,

Line 268: p_assignment_id OUT NOCOPY per_all_assignments_f.assignment_id%TYPE,

264:
265: PROCEDURE get_primary_assignment_info (
266: p_person_id IN per_all_assignments_f.person_id%TYPE,
267: p_effective_date IN per_all_assignments_f.effective_end_date%TYPE,
268: p_assignment_id OUT NOCOPY per_all_assignments_f.assignment_id%TYPE,
269: p_assignment_number OUT NOCOPY per_all_assignments_f.assignment_number%TYPE,
270: p_payroll_id OUT NOCOPY per_all_assignments_f.payroll_id%TYPE,
271: p_org_id OUT NOCOPY per_all_assignments_f.organization_id%TYPE,
272: p_location_id OUT NOCOPY per_all_assignments_f.location_id%TYPE,

Line 269: p_assignment_number OUT NOCOPY per_all_assignments_f.assignment_number%TYPE,

265: PROCEDURE get_primary_assignment_info (
266: p_person_id IN per_all_assignments_f.person_id%TYPE,
267: p_effective_date IN per_all_assignments_f.effective_end_date%TYPE,
268: p_assignment_id OUT NOCOPY per_all_assignments_f.assignment_id%TYPE,
269: p_assignment_number OUT NOCOPY per_all_assignments_f.assignment_number%TYPE,
270: p_payroll_id OUT NOCOPY per_all_assignments_f.payroll_id%TYPE,
271: p_org_id OUT NOCOPY per_all_assignments_f.organization_id%TYPE,
272: p_location_id OUT NOCOPY per_all_assignments_f.location_id%TYPE,
273: p_bg_id OUT NOCOPY per_all_assignments_f.business_group_id%TYPE

Line 270: p_payroll_id OUT NOCOPY per_all_assignments_f.payroll_id%TYPE,

266: p_person_id IN per_all_assignments_f.person_id%TYPE,
267: p_effective_date IN per_all_assignments_f.effective_end_date%TYPE,
268: p_assignment_id OUT NOCOPY per_all_assignments_f.assignment_id%TYPE,
269: p_assignment_number OUT NOCOPY per_all_assignments_f.assignment_number%TYPE,
270: p_payroll_id OUT NOCOPY per_all_assignments_f.payroll_id%TYPE,
271: p_org_id OUT NOCOPY per_all_assignments_f.organization_id%TYPE,
272: p_location_id OUT NOCOPY per_all_assignments_f.location_id%TYPE,
273: p_bg_id OUT NOCOPY per_all_assignments_f.business_group_id%TYPE
274: );

Line 271: p_org_id OUT NOCOPY per_all_assignments_f.organization_id%TYPE,

267: p_effective_date IN per_all_assignments_f.effective_end_date%TYPE,
268: p_assignment_id OUT NOCOPY per_all_assignments_f.assignment_id%TYPE,
269: p_assignment_number OUT NOCOPY per_all_assignments_f.assignment_number%TYPE,
270: p_payroll_id OUT NOCOPY per_all_assignments_f.payroll_id%TYPE,
271: p_org_id OUT NOCOPY per_all_assignments_f.organization_id%TYPE,
272: p_location_id OUT NOCOPY per_all_assignments_f.location_id%TYPE,
273: p_bg_id OUT NOCOPY per_all_assignments_f.business_group_id%TYPE
274: );
275:

Line 272: p_location_id OUT NOCOPY per_all_assignments_f.location_id%TYPE,

268: p_assignment_id OUT NOCOPY per_all_assignments_f.assignment_id%TYPE,
269: p_assignment_number OUT NOCOPY per_all_assignments_f.assignment_number%TYPE,
270: p_payroll_id OUT NOCOPY per_all_assignments_f.payroll_id%TYPE,
271: p_org_id OUT NOCOPY per_all_assignments_f.organization_id%TYPE,
272: p_location_id OUT NOCOPY per_all_assignments_f.location_id%TYPE,
273: p_bg_id OUT NOCOPY per_all_assignments_f.business_group_id%TYPE
274: );
275:
276: FUNCTION is_person (p_tbb_rec IN hxc_generic_retrieval_pkg.r_building_blocks)

Line 273: p_bg_id OUT NOCOPY per_all_assignments_f.business_group_id%TYPE

269: p_assignment_number OUT NOCOPY per_all_assignments_f.assignment_number%TYPE,
270: p_payroll_id OUT NOCOPY per_all_assignments_f.payroll_id%TYPE,
271: p_org_id OUT NOCOPY per_all_assignments_f.organization_id%TYPE,
272: p_location_id OUT NOCOPY per_all_assignments_f.location_id%TYPE,
273: p_bg_id OUT NOCOPY per_all_assignments_f.business_group_id%TYPE
274: );
275:
276: FUNCTION is_person (p_tbb_rec IN hxc_generic_retrieval_pkg.r_building_blocks)
277: RETURN BOOLEAN;

Line 286: p_assignment_id OUT NOCOPY per_all_assignments_f.assignment_id%TYPE,

282: RETURN BOOLEAN;
283:
284: PROCEDURE assignment_info (
285: p_tbb_rec IN hxc_generic_retrieval_pkg.r_building_blocks,
286: p_assignment_id OUT NOCOPY per_all_assignments_f.assignment_id%TYPE,
287: p_assignment_number OUT NOCOPY per_all_assignments_f.assignment_number%TYPE
288: );
289:
290: FUNCTION attribute_is (

Line 287: p_assignment_number OUT NOCOPY per_all_assignments_f.assignment_number%TYPE

283:
284: PROCEDURE assignment_info (
285: p_tbb_rec IN hxc_generic_retrieval_pkg.r_building_blocks,
286: p_assignment_id OUT NOCOPY per_all_assignments_f.assignment_id%TYPE,
287: p_assignment_number OUT NOCOPY per_all_assignments_f.assignment_number%TYPE
288: );
289:
290: FUNCTION attribute_is (
291: p_attr_rec IN hxc_generic_retrieval_pkg.r_time_attributes,

Line 373: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,

369: )
370: RETURN fnd_descr_flex_column_usages.end_user_column_name%TYPE;
371:
372: FUNCTION accrual_plan_ids (
373: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
374: p_effective_date IN pay_element_types_f.effective_start_date%TYPE
375: )
376: RETURN accrual_plan_id_table;
377: