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 PAY_ELEMENT_TYPES_F

Line 7: g_current_element pay_element_types_f.element_type_id%TYPE

3:
4: -- Global package name
5: g_debug boolean := hr_utility.debug_enabled;
6: g_package CONSTANT package_name := 'hxt_interface_utilities.';
7: g_current_element pay_element_types_f.element_type_id%TYPE
8: := NULL;
9: -- GLOBAL SWITCHES --
10: -- Controls whether we do commits or not during the run
11: g_do_commit BOOLEAN := TRUE; -- Should always be TRUE except for testing!

Line 34: RETURN pay_element_types_f.element_type_id%TYPE

30: g_tbb_index NUMBER;
31: g_tbb NUMBER;
32:
33: FUNCTION current_element
34: RETURN pay_element_types_f.element_type_id%TYPE
35: IS
36: l_proc proc_name ;
37: BEGIN
38:

Line 55: p_current_element IN pay_element_types_f.element_type_id%TYPE

51: RETURN g_current_element;
52: END current_element;
53:
54: PROCEDURE set_current_element (
55: p_current_element IN pay_element_types_f.element_type_id%TYPE
56: )
57: IS
58: l_proc proc_name ;
59: BEGIN

Line 1817: RETURN pay_element_types_f.element_type_id%TYPE

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 ;
1820: l_char_element_type_id VARCHAR2 (30);
1821: l_element_type_id pay_element_types_f.element_type_id%TYPE;

Line 1821: l_element_type_id pay_element_types_f.element_type_id%TYPE;

1817: RETURN pay_element_types_f.element_type_id%TYPE
1818: IS
1819: l_proc proc_name ;
1820: l_char_element_type_id VARCHAR2 (30);
1821: l_element_type_id pay_element_types_f.element_type_id%TYPE;
1822: BEGIN
1823: g_debug :=hr_utility.debug_enabled;
1824: if g_debug then
1825: l_proc := g_package

Line 1850: p_element_type_id IN pay_element_types_f.element_type_id%TYPE

1846: RETURN l_element_type_id;
1847: END element_type_id;
1848:
1849: FUNCTION element_flex_context_code (
1850: p_element_type_id IN pay_element_types_f.element_type_id%TYPE
1851: )
1852: RETURN fnd_descr_flex_column_usages.descriptive_flex_context_code%TYPE
1853: IS
1854: l_proc proc_name;

Line 1886: p_ele_type_id IN pay_element_types_f.element_type_id%TYPE,

1882: RETURN l_element_flex_context_code;
1883: END element_flex_context_code;
1884:
1885: FUNCTION element_name (
1886: p_ele_type_id IN pay_element_types_f.element_type_id%TYPE,
1887: p_effective_date IN pay_element_types_f.effective_start_date%TYPE
1888: )
1889: RETURN pay_element_types_f.element_name%TYPE
1890: IS

Line 1887: p_effective_date IN pay_element_types_f.effective_start_date%TYPE

1883: END element_flex_context_code;
1884:
1885: FUNCTION element_name (
1886: p_ele_type_id IN pay_element_types_f.element_type_id%TYPE,
1887: p_effective_date IN pay_element_types_f.effective_start_date%TYPE
1888: )
1889: RETURN pay_element_types_f.element_name%TYPE
1890: IS
1891: l_proc proc_name ;

Line 1889: RETURN pay_element_types_f.element_name%TYPE

1885: FUNCTION element_name (
1886: p_ele_type_id IN pay_element_types_f.element_type_id%TYPE,
1887: p_effective_date IN pay_element_types_f.effective_start_date%TYPE
1888: )
1889: RETURN pay_element_types_f.element_name%TYPE
1890: IS
1891: l_proc proc_name ;
1892: CURSOR csr_element_name (
1893: p_ele_type_id pay_element_types_f.element_type_id%TYPE,

Line 1893: p_ele_type_id pay_element_types_f.element_type_id%TYPE,

1889: RETURN pay_element_types_f.element_name%TYPE
1890: IS
1891: l_proc proc_name ;
1892: CURSOR csr_element_name (
1893: p_ele_type_id pay_element_types_f.element_type_id%TYPE,
1894: p_effective_date pay_element_types_f.effective_start_date%TYPE
1895: )
1896: IS
1897: SELECT petft.element_name

Line 1894: p_effective_date pay_element_types_f.effective_start_date%TYPE

1890: IS
1891: l_proc proc_name ;
1892: CURSOR csr_element_name (
1893: p_ele_type_id pay_element_types_f.element_type_id%TYPE,
1894: p_effective_date pay_element_types_f.effective_start_date%TYPE
1895: )
1896: IS
1897: SELECT petft.element_name
1898: FROM pay_element_types_f petf, pay_element_types_f_tl petft

Line 1898: FROM pay_element_types_f petf, pay_element_types_f_tl petft

1894: p_effective_date pay_element_types_f.effective_start_date%TYPE
1895: )
1896: IS
1897: SELECT petft.element_name
1898: FROM pay_element_types_f petf, pay_element_types_f_tl petft
1899: WHERE petf.element_type_id = p_ele_type_id
1900: AND petft.element_type_id = petf.element_type_id
1901: AND USERENV ('LANG') = petft.LANGUAGE
1902: AND p_effective_date BETWEEN petf.effective_start_date

Line 1904: l_element_name pay_element_types_f.element_name%TYPE;

1900: AND petft.element_type_id = petf.element_type_id
1901: AND USERENV ('LANG') = petft.LANGUAGE
1902: AND p_effective_date BETWEEN petf.effective_start_date
1903: AND petf.effective_end_date;
1904: l_element_name pay_element_types_f.element_name%TYPE;
1905: BEGIN
1906: g_debug :=hr_utility.debug_enabled;
1907: if g_debug then
1908: l_proc := g_package

Line 1962: p_element_type_id IN pay_element_types_f.element_type_id%TYPE,

1958: RETURN l_hours_worked;
1959: END hours_worked;
1960:
1961: FUNCTION element_type_ivs (
1962: p_element_type_id IN pay_element_types_f.element_type_id%TYPE,
1963: p_effective_date IN pay_element_types_f.effective_start_date%TYPE
1964: )
1965: RETURN input_value_name_table
1966: AS

Line 1963: p_effective_date IN pay_element_types_f.effective_start_date%TYPE

1959: END hours_worked;
1960:
1961: FUNCTION element_type_ivs (
1962: p_element_type_id IN pay_element_types_f.element_type_id%TYPE,
1963: p_effective_date IN pay_element_types_f.effective_start_date%TYPE
1964: )
1965: RETURN input_value_name_table
1966: AS
1967: l_proc proc_name ;

Line 1970: p_element_type_id pay_element_types_f.element_type_id%TYPE,

1966: AS
1967: l_proc proc_name ;
1968:
1969: CURSOR csr_element_type_ivs (
1970: p_element_type_id pay_element_types_f.element_type_id%TYPE,
1971: p_effective_date pay_element_types_f.effective_start_date%TYPE
1972: )
1973: IS
1974: SELECT piv.NAME

Line 1971: p_effective_date pay_element_types_f.effective_start_date%TYPE

1967: l_proc proc_name ;
1968:
1969: CURSOR csr_element_type_ivs (
1970: p_element_type_id pay_element_types_f.element_type_id%TYPE,
1971: p_effective_date pay_element_types_f.effective_start_date%TYPE
1972: )
1973: IS
1974: SELECT piv.NAME
1975: FROM pay_input_values_f piv

Line 2025: p_element_type_id IN pay_element_types_f.element_type_id%TYPE,

2021: RETURN l_element_type_ivs;
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

Line 2086: p_element_type_id IN pay_element_types_f.element_type_id%TYPE,

2082: END ddf_input_value_name;
2083:
2084: FUNCTION accr_plan_added_date_ivs (
2085: p_accrual_plan_id IN pay_accrual_plans.accrual_plan_id%TYPE,
2086: p_element_type_id IN pay_element_types_f.element_type_id%TYPE,
2087: p_effective_date IN pay_element_types_f.effective_start_date%TYPE
2088: )
2089: RETURN input_value_name_table
2090: AS

Line 2087: p_effective_date IN pay_element_types_f.effective_start_date%TYPE

2083:
2084: FUNCTION accr_plan_added_date_ivs (
2085: p_accrual_plan_id IN pay_accrual_plans.accrual_plan_id%TYPE,
2086: p_element_type_id IN pay_element_types_f.element_type_id%TYPE,
2087: p_effective_date IN pay_element_types_f.effective_start_date%TYPE
2088: )
2089: RETURN input_value_name_table
2090: AS
2091: l_proc proc_name ;

Line 2105: p_effective_date pay_element_types_f.effective_start_date%TYPE,

2101: -- pncr.date_input_value_id = piv.input_value_id, but I will leave it for
2102: -- now.
2103: CURSOR csr_accrual_plan_ivs (
2104: p_accrual_plan_id pay_accrual_plans.accrual_plan_id%TYPE,
2105: p_effective_date pay_element_types_f.effective_start_date%TYPE,
2106: p_element_type_id pay_element_types_f.element_type_id%TYPE
2107: )
2108: IS
2109: SELECT DISTINCT piv.NAME

Line 2106: p_element_type_id pay_element_types_f.element_type_id%TYPE

2102: -- now.
2103: CURSOR csr_accrual_plan_ivs (
2104: p_accrual_plan_id pay_accrual_plans.accrual_plan_id%TYPE,
2105: p_effective_date pay_element_types_f.effective_start_date%TYPE,
2106: p_element_type_id pay_element_types_f.element_type_id%TYPE
2107: )
2108: IS
2109: SELECT DISTINCT piv.NAME
2110: FROM pay_input_values_f piv,

Line 2151: p_effective_date IN pay_element_types_f.effective_start_date%TYPE

2147: END accr_plan_added_date_ivs;
2148:
2149: FUNCTION accrual_plan_ids (
2150: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
2151: p_effective_date IN pay_element_types_f.effective_start_date%TYPE
2152: )
2153: RETURN accrual_plan_id_table
2154: AS
2155: l_proc proc_name ;

Line 2159: p_effective_date pay_element_types_f.effective_start_date%TYPE

2155: l_proc proc_name ;
2156:
2157: CURSOR csr_accrual_plan_ids (
2158: p_assignment_id per_all_assignments_f.assignment_id%TYPE,
2159: p_effective_date pay_element_types_f.effective_start_date%TYPE
2160: )
2161: IS
2162: SELECT pap.accrual_plan_id
2163: FROM pay_accrual_plans pap,

Line 2201: p_effective_date IN pay_element_types_f.effective_start_date%TYPE,

2197: END accrual_plan_ids;
2198:
2199: FUNCTION accrual_plan_exists (
2200: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
2201: p_effective_date IN pay_element_types_f.effective_start_date%TYPE,
2202: p_accrual_plan_id IN pay_accrual_plans.accrual_plan_id%TYPE
2203: )
2204: RETURN BOOLEAN
2205: AS

Line 2306: p_element_type_id IN pay_element_types_f.element_type_id%TYPE,

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: )
2310: AS

Line 2307: p_effective_date IN pay_element_types_f.effective_start_date%TYPE,

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: )
2310: AS
2311: l_proc proc_name ;

Line 2667: p_element_type_id IN pay_element_types_f.element_type_id%TYPE,

2663:
2664:
2665:
2666: PROCEDURE hours_iv_position (
2667: p_element_type_id IN pay_element_types_f.element_type_id%TYPE,
2668: p_effective_date IN pay_element_types_f.effective_start_date%TYPE,
2669: p_hours_iv_position OUT NOCOPY PLS_INTEGER,
2670: p_jurisdiction_iv_position OUT NOCOPY PLS_INTEGER,
2671: p_iv_type IN VARCHAR2

Line 2668: p_effective_date IN pay_element_types_f.effective_start_date%TYPE,

2664:
2665:
2666: PROCEDURE hours_iv_position (
2667: p_element_type_id IN pay_element_types_f.element_type_id%TYPE,
2668: p_effective_date IN pay_element_types_f.effective_start_date%TYPE,
2669: p_hours_iv_position OUT NOCOPY PLS_INTEGER,
2670: p_jurisdiction_iv_position OUT NOCOPY PLS_INTEGER,
2671: p_iv_type IN VARCHAR2
2672: )

Line 2812: RETURN pay_element_types_f.element_type_id%TYPE

2808: p_att_table IN hxc_generic_retrieval_pkg.t_time_attribute,
2809: p_tbb_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
2810: p_start_position IN PLS_INTEGER
2811: )
2812: RETURN pay_element_types_f.element_type_id%TYPE
2813: AS
2814: l_proc proc_name;
2815:
2816: l_att_idx PLS_INTEGER

Line 2819: l_element_type_id pay_element_types_f.element_type_id%TYPE := NULL;

2815:
2816: l_att_idx PLS_INTEGER
2817: := NVL (p_start_position, p_att_table.FIRST);
2818: l_element_id_found BOOLEAN := FALSE;
2819: l_element_type_id pay_element_types_f.element_type_id%TYPE := NULL;
2820: BEGIN
2821: g_debug :=hr_utility.debug_enabled;
2822: if g_debug then
2823: l_proc := g_package

Line 2856: p_element_type_id IN pay_element_types_f.element_type_id%TYPE,

2852: PROCEDURE find_other_in_attr_tbl (
2853: p_bg_id IN pay_batch_headers.business_group_id%TYPE,
2854: p_att_table IN hxc_generic_retrieval_pkg.t_time_attribute,
2855: p_tbb_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
2856: p_element_type_id IN pay_element_types_f.element_type_id%TYPE,
2857: p_cost_flex_id IN per_business_groups_perf.cost_allocation_structure%TYPE,
2858: p_effective_date IN pay_element_types_f.effective_start_date%TYPE,
2859: p_start_position IN PLS_INTEGER,
2860: p_ending_position OUT NOCOPY PLS_INTEGER, -- will return NULL if end-of-table was reached

Line 2858: p_effective_date IN pay_element_types_f.effective_start_date%TYPE,

2854: p_att_table IN hxc_generic_retrieval_pkg.t_time_attribute,
2855: p_tbb_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
2856: p_element_type_id IN pay_element_types_f.element_type_id%TYPE,
2857: p_cost_flex_id IN per_business_groups_perf.cost_allocation_structure%TYPE,
2858: p_effective_date IN pay_element_types_f.effective_start_date%TYPE,
2859: p_start_position IN PLS_INTEGER,
2860: p_ending_position OUT NOCOPY PLS_INTEGER, -- will return NULL if end-of-table was reached
2861: p_bee_rec IN OUT NOCOPY bee_rec
2862: )