DBA Data[Home] [Help]

APPS.HXT_INTERFACE_UTILITIES dependencies on HXC_GENERIC_RETRIEVAL_PKG

Line 898: p_tbb_tbl IN hxc_generic_retrieval_pkg.t_building_blocks

894: RETURN l_isnumber;
895: END isnumber;
896:
897: FUNCTION detail_lines_retrieved (
898: p_tbb_tbl IN hxc_generic_retrieval_pkg.t_building_blocks
899: )
900: RETURN BOOLEAN
901: IS
902: l_proc proc_name;

Line 1404: p_tbb_rec IN hxc_generic_retrieval_pkg.r_building_blocks

1400: end if;
1401: END get_primary_assignment_info;
1402:
1403: FUNCTION is_assignment (
1404: p_tbb_rec IN hxc_generic_retrieval_pkg.r_building_blocks
1405: )
1406: RETURN BOOLEAN
1407: IS
1408: l_proc proc_name ;

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

1431: end if;
1432: RETURN l_is_assignment;
1433: END is_assignment;
1434:
1435: FUNCTION is_person (p_tbb_rec IN hxc_generic_retrieval_pkg.r_building_blocks)
1436: RETURN BOOLEAN
1437: IS
1438: l_proc proc_name ;
1439: l_is_person BOOLEAN := FALSE;

Line 1466: p_tbb_rec IN hxc_generic_retrieval_pkg.r_building_blocks,

1462: RETURN l_is_person;
1463: END is_person;
1464:
1465: PROCEDURE assignment_info (
1466: p_tbb_rec IN hxc_generic_retrieval_pkg.r_building_blocks,
1467: p_assignment_id OUT NOCOPY per_all_assignments_f.assignment_id%TYPE,
1468: p_assignment_number OUT NOCOPY per_all_assignments_f.assignment_number%TYPE
1469: )
1470: AS

Line 1528: p_attr_rec IN hxc_generic_retrieval_pkg.r_time_attributes,

1524: end if;
1525: END assignment_info;
1526:
1527: FUNCTION attribute_is (
1528: p_attr_rec IN hxc_generic_retrieval_pkg.r_time_attributes,
1529: p_is_what IN hxc_mapping_components.field_name%TYPE,
1530: p_case_sensitive IN BOOLEAN DEFAULT FALSE
1531: )
1532: RETURN BOOLEAN

Line 1581: p_attr_rec IN hxc_generic_retrieval_pkg.r_time_attributes

1577: RETURN l_it_is;
1578: END attribute_is;
1579:
1580: FUNCTION attribute_is_element (
1581: p_attr_rec IN hxc_generic_retrieval_pkg.r_time_attributes
1582: )
1583: RETURN BOOLEAN
1584: IS
1585: l_proc proc_name ;

Line 1607: p_attr_rec IN hxc_generic_retrieval_pkg.r_time_attributes

1603: RETURN l_element;
1604: END attribute_is_element;
1605:
1606: FUNCTION attribute_is_cost_segment (
1607: p_attr_rec IN hxc_generic_retrieval_pkg.r_time_attributes
1608: )
1609: RETURN BOOLEAN
1610: IS
1611: l_proc proc_name ;

Line 1634: p_attr_rec IN hxc_generic_retrieval_pkg.r_time_attributes

1630: RETURN l_cost_segment;
1631: END attribute_is_cost_segment;
1632:
1633: FUNCTION attribute_is_input_value (
1634: p_attr_rec IN hxc_generic_retrieval_pkg.r_time_attributes
1635: )
1636: RETURN BOOLEAN
1637: IS
1638: l_proc proc_name ;

Line 1661: p_attr_rec IN hxc_generic_retrieval_pkg.r_time_attributes

1657: RETURN l_input_value;
1658: END attribute_is_input_value;
1659:
1660: FUNCTION attribute_is_asg_id (
1661: p_attr_rec IN hxc_generic_retrieval_pkg.r_time_attributes
1662: )
1663: RETURN BOOLEAN
1664: IS
1665: l_proc proc_name ;

Line 1687: p_attr_rec IN hxc_generic_retrieval_pkg.r_time_attributes

1683: RETURN l_asg_id;
1684: END attribute_is_asg_id;
1685:
1686: FUNCTION attribute_is_asg_num (
1687: p_attr_rec IN hxc_generic_retrieval_pkg.r_time_attributes
1688: )
1689: RETURN BOOLEAN
1690: IS
1691: l_proc proc_name ;

Line 1755: p_attr_rec IN hxc_generic_retrieval_pkg.r_time_attributes

1751: RETURN l_number;
1752: END extract_number;
1753:
1754: FUNCTION cost_segment_number (
1755: p_attr_rec IN hxc_generic_retrieval_pkg.r_time_attributes
1756: )
1757: RETURN PLS_INTEGER
1758: IS
1759: l_proc proc_name;

Line 1785: p_attr_rec IN hxc_generic_retrieval_pkg.r_time_attributes

1781: RETURN l_cost_segment_number;
1782: END cost_segment_number;
1783:
1784: FUNCTION input_value_number (
1785: p_attr_rec IN hxc_generic_retrieval_pkg.r_time_attributes
1786: )
1787: RETURN PLS_INTEGER
1788: IS
1789: l_proc proc_name;

Line 1815: p_attr_rec IN hxc_generic_retrieval_pkg.r_time_attributes

1811: RETURN l_input_value_number;
1812: END input_value_number;
1813:
1814: FUNCTION element_type_id (
1815: p_attr_rec IN hxc_generic_retrieval_pkg.r_time_attributes
1816: )
1817: RETURN pay_element_types_f.element_type_id%TYPE
1818: IS
1819: l_proc proc_name ;

Line 1927: p_detail_tbb IN hxc_generic_retrieval_pkg.r_building_blocks

1923: END element_name;
1924:
1925:
1926: FUNCTION hours_worked (
1927: p_detail_tbb IN hxc_generic_retrieval_pkg.r_building_blocks
1928: )
1929: RETURN NUMBER
1930: AS
1931: l_proc proc_name ;

Line 2026: p_attr_rec IN hxc_generic_retrieval_pkg.r_time_attributes

2022: END element_type_ivs;
2023:
2024: FUNCTION ddf_input_value_name (
2025: p_element_type_id IN pay_element_types_f.element_type_id%TYPE,
2026: p_attr_rec IN hxc_generic_retrieval_pkg.r_time_attributes
2027: )
2028: RETURN fnd_descr_flex_column_usages.end_user_column_name%TYPE
2029: AS
2030: l_proc proc_name;

Line 2305: p_attr_rec IN hxc_generic_retrieval_pkg.r_time_attributes,

2301: END IF;
2302: END assign_iv;
2303:
2304: PROCEDURE convert_attr_to_ivs (
2305: p_attr_rec IN hxc_generic_retrieval_pkg.r_time_attributes,
2306: p_element_type_id IN pay_element_types_f.element_type_id%TYPE,
2307: p_effective_date IN pay_element_types_f.effective_start_date%TYPE,
2308: p_bee_rec IN OUT NOCOPY bee_rec
2309: )

Line 2376: p_attr_rec IN hxc_generic_retrieval_pkg.r_time_attributes,

2372: end if;
2373: END convert_attr_to_ivs;
2374:
2375: PROCEDURE convert_attr_to_costsegment (
2376: p_attr_rec IN hxc_generic_retrieval_pkg.r_time_attributes,
2377: p_cost_flex_id IN per_business_groups_perf.cost_allocation_structure%TYPE,
2378: p_bee_rec IN OUT NOCOPY bee_rec
2379: )
2380: AS

Line 2737: p_att_table IN hxc_generic_retrieval_pkg.t_time_attribute,

2733: END hours_iv_position;
2734:
2735:
2736: FUNCTION find_element_id_in_attr_tbl (
2737: p_att_table IN hxc_generic_retrieval_pkg.t_time_attribute,
2738: p_tbb_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
2739: p_start_position IN PLS_INTEGER
2740: )
2741: RETURN pay_element_types_f.element_type_id%TYPE

Line 2783: p_att_table IN hxc_generic_retrieval_pkg.t_time_attribute,

2779: END find_element_id_in_attr_tbl;
2780:
2781: PROCEDURE find_other_in_attr_tbl (
2782: p_bg_id IN pay_batch_headers.business_group_id%TYPE,
2783: p_att_table IN hxc_generic_retrieval_pkg.t_time_attribute,
2784: p_tbb_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
2785: p_element_type_id IN pay_element_types_f.element_type_id%TYPE,
2786: p_cost_flex_id IN per_business_groups_perf.cost_allocation_structure%TYPE,
2787: p_effective_date IN pay_element_types_f.effective_start_date%TYPE,

Line 2952: p_att_table IN hxc_generic_retrieval_pkg.t_time_attribute,

2948: end if;
2949: END find_other_in_attr_tbl;
2950:
2951: FUNCTION skip_attributes (
2952: p_att_table IN hxc_generic_retrieval_pkg.t_time_attribute,
2953: p_tbb_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
2954: p_start_position IN PLS_INTEGER
2955: )
2956: RETURN PLS_INTEGER

Line 2988: p_att_table IN hxc_generic_retrieval_pkg.t_time_attribute,

2984: RETURN l_att_idx;
2985: END skip_attributes;
2986:
2987: /* PROCEDURE find_asg_in_attr_tbl (
2988: p_att_table IN hxc_generic_retrieval_pkg.t_time_attribute,
2989: p_tbb_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
2990: p_start_position IN PLS_INTEGER,
2991: p_bee_rec IN OUT NOCOPY bee_rec
2992: )

Line 3802: p_tbb_rec IN hxc_generic_retrieval_pkg.r_building_blocks

3798: -- DELETED (never xfered) N Y
3799: -- DELETED (xfered) Y Y
3800: -- --------------------------- ------- -------
3801: FUNCTION is_changed (
3802: p_tbb_rec IN hxc_generic_retrieval_pkg.r_building_blocks
3803: )
3804: RETURN BOOLEAN
3805: AS
3806: l_proc proc_name ;

Line 3838: p_tbb_rec IN hxc_generic_retrieval_pkg.r_building_blocks

3834: RETURN l_is_changed;
3835: END is_changed;
3836:
3837: FUNCTION is_deleted (
3838: p_tbb_rec IN hxc_generic_retrieval_pkg.r_building_blocks
3839: )
3840: RETURN BOOLEAN
3841: AS
3842: l_proc proc_name ;

Line 3913: p_att_table IN hxc_generic_retrieval_pkg.t_time_attribute,

3909:
3910:
3911:
3912: FUNCTION get_geocode_from_attr_tab (
3913: p_att_table IN hxc_generic_retrieval_pkg.t_time_attribute,
3914: p_tbb_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
3915: p_start_position IN PLS_INTEGER
3916: )
3917: RETURN VARCHAR2