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 HXC_GENERIC_RETRIEVAL_PKG

Line 225: p_tbb_tbl IN hxc_generic_retrieval_pkg.t_building_blocks

221: FUNCTION isnumber (p_value VARCHAR2)
222: RETURN BOOLEAN;
223:
224: FUNCTION detail_lines_retrieved (
225: p_tbb_tbl IN hxc_generic_retrieval_pkg.t_building_blocks
226: )
227: RETURN BOOLEAN;
228:
229: FUNCTION gre (

Line 276: FUNCTION is_person (p_tbb_rec IN hxc_generic_retrieval_pkg.r_building_blocks)

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;
278:
279: FUNCTION is_assignment (
280: p_tbb_rec IN hxc_generic_retrieval_pkg.r_building_blocks

Line 280: p_tbb_rec IN hxc_generic_retrieval_pkg.r_building_blocks

276: FUNCTION is_person (p_tbb_rec IN hxc_generic_retrieval_pkg.r_building_blocks)
277: RETURN BOOLEAN;
278:
279: FUNCTION is_assignment (
280: p_tbb_rec IN hxc_generic_retrieval_pkg.r_building_blocks
281: )
282: RETURN BOOLEAN;
283:
284: PROCEDURE assignment_info (

Line 285: p_tbb_rec IN hxc_generic_retrieval_pkg.r_building_blocks,

281: )
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:

Line 291: p_attr_rec IN hxc_generic_retrieval_pkg.r_time_attributes,

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,
292: p_is_what IN hxc_mapping_components.field_name%TYPE,
293: p_case_sensitive IN BOOLEAN DEFAULT FALSE
294: )
295: RETURN BOOLEAN;

Line 298: p_attr_rec IN hxc_generic_retrieval_pkg.r_time_attributes

294: )
295: RETURN BOOLEAN;
296:
297: FUNCTION attribute_is_element (
298: p_attr_rec IN hxc_generic_retrieval_pkg.r_time_attributes
299: )
300: RETURN BOOLEAN;
301:
302: FUNCTION attribute_is_cost_segment (

Line 303: p_attr_rec IN hxc_generic_retrieval_pkg.r_time_attributes

299: )
300: RETURN BOOLEAN;
301:
302: FUNCTION attribute_is_cost_segment (
303: p_attr_rec IN hxc_generic_retrieval_pkg.r_time_attributes
304: )
305: RETURN BOOLEAN;
306:
307: FUNCTION attribute_is_input_value (

Line 308: p_attr_rec IN hxc_generic_retrieval_pkg.r_time_attributes

304: )
305: RETURN BOOLEAN;
306:
307: FUNCTION attribute_is_input_value (
308: p_attr_rec IN hxc_generic_retrieval_pkg.r_time_attributes
309: )
310: RETURN BOOLEAN;
311:
312: FUNCTION attribute_is_asg_id (

Line 313: p_attr_rec IN hxc_generic_retrieval_pkg.r_time_attributes

309: )
310: RETURN BOOLEAN;
311:
312: FUNCTION attribute_is_asg_id (
313: p_attr_rec IN hxc_generic_retrieval_pkg.r_time_attributes
314: )
315: RETURN BOOLEAN;
316:
317: FUNCTION attribute_is_asg_num (

Line 318: p_attr_rec IN hxc_generic_retrieval_pkg.r_time_attributes

314: )
315: RETURN BOOLEAN;
316:
317: FUNCTION attribute_is_asg_num (
318: p_attr_rec IN hxc_generic_retrieval_pkg.r_time_attributes
319: )
320: RETURN BOOLEAN;
321:
322: FUNCTION extract_number (

Line 330: p_attr_rec IN hxc_generic_retrieval_pkg.r_time_attributes

326: )
327: RETURN PLS_INTEGER;
328:
329: FUNCTION input_value_number (
330: p_attr_rec IN hxc_generic_retrieval_pkg.r_time_attributes
331: )
332: RETURN PLS_INTEGER;
333:
334: FUNCTION cost_segment_number (

Line 335: p_attr_rec IN hxc_generic_retrieval_pkg.r_time_attributes

331: )
332: RETURN PLS_INTEGER;
333:
334: FUNCTION cost_segment_number (
335: p_attr_rec IN hxc_generic_retrieval_pkg.r_time_attributes
336: )
337: RETURN PLS_INTEGER;
338:
339: FUNCTION element_flex_context_code (

Line 345: p_attr_rec IN hxc_generic_retrieval_pkg.r_time_attributes

341: )
342: RETURN fnd_descr_flex_column_usages.descriptive_flex_context_code%TYPE;
343:
344: FUNCTION element_type_id (
345: p_attr_rec IN hxc_generic_retrieval_pkg.r_time_attributes
346: )
347: RETURN pay_element_types_f.element_type_id%TYPE;
348:
349: FUNCTION element_name (

Line 356: p_detail_tbb IN hxc_generic_retrieval_pkg.r_building_blocks

352: )
353: RETURN pay_element_types_f.element_name%TYPE;
354:
355: FUNCTION hours_worked (
356: p_detail_tbb IN hxc_generic_retrieval_pkg.r_building_blocks
357: )
358: RETURN NUMBER;
359:
360: FUNCTION element_type_ivs (

Line 368: p_attr_rec IN hxc_generic_retrieval_pkg.r_time_attributes

364: RETURN input_value_name_table;
365:
366: FUNCTION ddf_input_value_name (
367: p_element_type_id IN pay_element_types_f.element_type_id%TYPE,
368: p_attr_rec IN hxc_generic_retrieval_pkg.r_time_attributes
369: )
370: RETURN fnd_descr_flex_column_usages.end_user_column_name%TYPE;
371:
372: FUNCTION accrual_plan_ids (

Line 385: p_attr_rec IN hxc_generic_retrieval_pkg.r_time_attributes,

381: p_bee_rec IN OUT NOCOPY bee_rec
382: );
383:
384: PROCEDURE convert_attr_to_ivs (
385: p_attr_rec IN hxc_generic_retrieval_pkg.r_time_attributes,
386: p_element_type_id IN pay_element_types_f.element_type_id%TYPE,
387: p_effective_date IN pay_element_types_f.effective_start_date%TYPE,
388: p_bee_rec IN OUT NOCOPY bee_rec
389: );

Line 392: p_attr_rec IN hxc_generic_retrieval_pkg.r_time_attributes,

388: p_bee_rec IN OUT NOCOPY bee_rec
389: );
390:
391: PROCEDURE convert_attr_to_costsegment (
392: p_attr_rec IN hxc_generic_retrieval_pkg.r_time_attributes,
393: p_cost_flex_id IN per_business_groups_perf.cost_allocation_structure%TYPE,
394: p_bee_rec IN OUT NOCOPY bee_rec
395: );
396:

Line 412: p_att_table IN hxc_generic_retrieval_pkg.t_time_attribute,

408: p_iv_type IN VARCHAR2
409: );
410:
411: FUNCTION find_element_id_in_attr_tbl (
412: p_att_table IN hxc_generic_retrieval_pkg.t_time_attribute,
413: p_tbb_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
414: p_start_position IN PLS_INTEGER
415: )
416: RETURN pay_element_types_f.element_type_id%TYPE;

Line 420: p_att_table IN hxc_generic_retrieval_pkg.t_time_attribute,

416: RETURN pay_element_types_f.element_type_id%TYPE;
417:
418: PROCEDURE find_other_in_attr_tbl (
419: p_bg_id IN pay_batch_headers.business_group_id%TYPE,
420: p_att_table IN hxc_generic_retrieval_pkg.t_time_attribute,
421: p_tbb_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
422: p_element_type_id IN pay_element_types_f.element_type_id%TYPE,
423: p_cost_flex_id IN per_business_groups_perf.cost_allocation_structure%TYPE,
424: p_effective_date IN pay_element_types_f.effective_start_date%TYPE,

Line 431: p_att_table IN hxc_generic_retrieval_pkg.t_time_attribute,

427: p_bee_rec IN OUT NOCOPY bee_rec
428: );
429:
430: FUNCTION skip_attributes (
431: p_att_table IN hxc_generic_retrieval_pkg.t_time_attribute,
432: p_tbb_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
433: p_start_position IN PLS_INTEGER
434: )
435: RETURN PLS_INTEGER;

Line 438: p_att_table IN hxc_generic_retrieval_pkg.t_time_attribute,

434: )
435: RETURN PLS_INTEGER;
436:
437: /* PROCEDURE find_asg_in_attr_tbl (
438: p_att_table IN hxc_generic_retrieval_pkg.t_time_attribute,
439: p_tbb_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
440: p_start_position IN PLS_INTEGER,
441: p_bee_rec IN OUT NOCOPY bee_rec
442: ); */

Line 542: p_tbb_rec IN hxc_generic_retrieval_pkg.r_building_blocks

538: p_bg_id IN pay_batch_headers.business_group_id%TYPE
539: )
540: RETURN BOOLEAN; */
541: FUNCTION is_changed (
542: p_tbb_rec IN hxc_generic_retrieval_pkg.r_building_blocks
543: )
544: RETURN BOOLEAN;
545:
546: FUNCTION is_deleted (

Line 547: p_tbb_rec IN hxc_generic_retrieval_pkg.r_building_blocks

543: )
544: RETURN BOOLEAN;
545:
546: FUNCTION is_deleted (
547: p_tbb_rec IN hxc_generic_retrieval_pkg.r_building_blocks
548: )
549: RETURN BOOLEAN;
550:
551: FUNCTION is_in_sync (

Line 558: p_attr_tbl IN hxc_generic_retrieval_pkg.t_time_attribute,

554: )
555: RETURN BOOLEAN;
556: /* FUNCTION is_in_sync (
557: p_tbb_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
558: p_attr_tbl IN hxc_generic_retrieval_pkg.t_time_attribute,
559: p_attr_tbl_idx IN PLS_INTEGER
560: )
561: RETURN BOOLEAN; */
562:

Line 564: p_att_table IN hxc_generic_retrieval_pkg.t_time_attribute,

560: )
561: RETURN BOOLEAN; */
562:
563: FUNCTION get_geocode_from_attr_tab (
564: p_att_table IN hxc_generic_retrieval_pkg.t_time_attribute,
565: p_tbb_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
566: p_start_position IN PLS_INTEGER
567: )
568: RETURN VARCHAR2;