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.PQP_UTILITIES dependencies on PQP_UTILITIES

Line 1: PACKAGE BODY pqp_utilities AS

1: PACKAGE BODY pqp_utilities AS
2: /* $Header: pqputifn.pkb 120.19.12000000.2 2007/07/04 13:32:35 apmishra noship $ */
3: --
4: --
5: --

Line 8: g_package_name VARCHAR2(31) := 'pqp_utilities.';

4: --
5: --
6: -- Debug Variables.
7: --
8: g_package_name VARCHAR2(31) := 'pqp_utilities.';
9:
10: -- Hash Function Variable
11: g_hash_key NUMBER(15) := NULL;
12: g_hash_base NUMBER(15) := NULL;

Line 417: pqp_utilities.pqp_get_legislation_code(p_business_group_id => p_business_group_id);

413: IF p_legislation_code IS NULL THEN
414: IF p_business_group_id IS NOT NULL THEN
415: -- Get legislation code
416: l_legislation_code :=
417: pqp_utilities.pqp_get_legislation_code(p_business_group_id => p_business_group_id);
418: END IF;
419: ELSE
420: l_legislation_code := p_legislation_code;
421: END IF;

Line 927: pqp_utilities.get_segment_name(

923: IF g_debug THEN
924: debug(l_proc_name, 10);
925: END IF;
926: l_col_name :=
927: pqp_utilities.get_segment_name(
928: p_flex_name => p_flex_name
929: ,p_flex_field_title => p_flex_field_title
930: ,p_flex_context => p_flex_context
931: ,p_tab_nam => l_tabname

Line 993: pqp_utilities.get_col_value(

989: IF g_debug THEN
990: debug(l_proc_name, 70);
991: END IF;
992: l_val :=
993: pqp_utilities.get_col_value(
994: p_col_nam => l_col_name
995: ,p_key_val => p_key_val
996: ,p_table => l_tabname
997: ,p_key_col => p_key_col

Line 1113: pqp_utilities.get_ddf_value(

1109: IF g_debug THEN
1110: debug(l_proc_name, 50);
1111: END IF;
1112: l_val :=
1113: pqp_utilities.get_ddf_value(
1114: p_flex_name => p_flex_name
1115: ,p_flex_context => l_context
1116: ,p_flex_field_title => p_flex_field_title
1117: ,p_key_col => p_key_col

Line 1314: pqp_utilities.get_segment_name(

1310: IF g_debug THEN
1311: debug_enter(l_proc_name);
1312: END IF;
1313: l_col_name :=
1314: pqp_utilities.get_segment_name(
1315: p_flex_name => p_flex_name
1316: ,p_flex_field_title => p_segment_name
1317: ,p_flex_context => p_flex_context
1318: ,p_tab_nam => l_tab_name

Line 1439: pqp_utilities.get_ddf_value(

1435: FETCH csr_get_extra_info_id INTO l_element_type_extra_info_id;
1436: CLOSE csr_get_extra_info_id;
1437:
1438: p_value :=
1439: pqp_utilities.get_ddf_value(
1440: p_flex_name => 'Extra Element Info DDF'
1441: ,p_flex_context => p_information_type
1442: ,p_flex_field_title => p_segment_name
1443: ,p_key_col => 'ELEMENT_TYPE_EXTRA_INFO_ID'

Line 1478: pqp_utilities.pqp_get_extra_element_mult(

1474: --
1475: ELSE
1476: --
1477: l_rowcount :=
1478: pqp_utilities.pqp_get_extra_element_mult(
1479: p_flex_name => 'Extra Element Info DDF'
1480: ,p_segment_name => p_segment_name
1481: ,p_flex_context => p_information_type
1482: ,p_element_type_id => p_element_type_id

Line 1558: pqp_utilities.get_df_value(

1554: IF g_debug THEN
1555: debug(l_proc_name, 20);
1556: END IF;
1557: p_value :=
1558: pqp_utilities.get_df_value(
1559: p_flex_name => 'Extra Element Info Details DF'
1560: ,p_flex_context => 'PQP_LEG_CODE'
1561: , --p_information_type,
1562: p_flex_field_title => p_segment_name

Line 1604: pqp_utilities.pqp_get_extra_element_mult(

1600: IF g_debug THEN
1601: debug(l_proc_name, 30);
1602: END IF;
1603: l_rowcount :=
1604: pqp_utilities.pqp_get_extra_element_mult(
1605: p_flex_name => 'Extra Element Info Details DF'
1606: ,p_segment_name => p_segment_name
1607: ,p_flex_context => p_information_type
1608: ,p_element_type_id => p_element_type_id

Line 1737: pqp_utilities.pqp_get_legislation_code(p_business_group_id => p_business_group_id);

1733: IF g_debug THEN
1734: debug(l_proc_name, 10);
1735: END IF;
1736: l_legislation_code :=
1737: pqp_utilities.pqp_get_legislation_code(p_business_group_id => p_business_group_id);
1738: IF g_debug THEN
1739: debug('l_legislation_code:' || l_legislation_code);
1740: END IF;
1741: IF g_debug THEN

Line 1745: pqp_utilities.pqp_get_element_type_id(

1741: IF g_debug THEN
1742: debug('p_element_type_name:' || p_element_type_name);
1743: END IF;
1744: l_element_type_id :=
1745: pqp_utilities.pqp_get_element_type_id(
1746: p_business_group_id => p_business_group_id
1747: ,p_legislation_code => l_legislation_code
1748: ,p_effective_date => p_effective_date
1749: ,p_element_type_name => p_element_type_name

Line 1825: pqp_utilities.pqp_get_legislation_code(p_business_group_id => p_business_group_id);

1821: IF g_debug THEN
1822: debug(l_proc_name, 10);
1823: END IF;
1824: l_legislation_code :=
1825: pqp_utilities.pqp_get_legislation_code(p_business_group_id => p_business_group_id);
1826: IF g_debug THEN
1827: debug(' Legislation Code :' || l_legislation_code, 20);
1828: END IF;
1829: --

Line 1830: debug(' pqp_utilities.pqp_get_element_type_id ' || p_element_type_name

1826: IF g_debug THEN
1827: debug(' Legislation Code :' || l_legislation_code, 20);
1828: END IF;
1829: --
1830: debug(' pqp_utilities.pqp_get_element_type_id ' || p_element_type_name
1831: ,30);
1832: l_element_type_id :=
1833: pqp_utilities.pqp_get_element_type_id(
1834: p_business_group_id => p_business_group_id

Line 1833: pqp_utilities.pqp_get_element_type_id(

1829: --
1830: debug(' pqp_utilities.pqp_get_element_type_id ' || p_element_type_name
1831: ,30);
1832: l_element_type_id :=
1833: pqp_utilities.pqp_get_element_type_id(
1834: p_business_group_id => p_business_group_id
1835: ,p_legislation_code => l_legislation_code
1836: ,p_effective_date => p_effective_date
1837: ,p_element_type_name => p_element_type_name

Line 1845: debug(' Calling pqp_utilities.pqp_get_extra_element_info_det');

1841: IF g_debug THEN
1842: debug(' The Element type Id is ' || l_element_type_id, 40);
1843: END IF;
1844: IF g_debug THEN
1845: debug(' Calling pqp_utilities.pqp_get_extra_element_info_det');
1846: END IF;
1847: l_retval :=
1848: pqp_get_extra_element_info_det(
1849: p_element_type_id => l_element_type_id

Line 1949: pqp_utilities.get_udt_data

1945: THEN
1946: IF g_debug THEN
1947: debug(l_proc_name, 20);
1948: END IF;
1949: pqp_utilities.get_udt_data
1950: (p_business_group_id => p_business_group_id
1951: ,p_udt_name => p_table_name
1952: ,p_effective_date => p_effective_date
1953: ,p_column_name => p_column_name

Line 1968: pqp_utilities.get_udt_value(

1964: debug(l_proc_name, 30);
1965: END IF;
1966:
1967: p_value :=
1968: pqp_utilities.get_udt_value(
1969: p_table_name => p_table_name
1970: ,p_column_name => p_column_name
1971: ,p_row_name => p_row_name
1972: ,p_effective_date => p_effective_date

Line 2087: pqp_utilities.pqp_gb_get_table_value(

2083: CLOSE csr_table_id;
2084: --
2085: --
2086: l_retval :=
2087: pqp_utilities.pqp_gb_get_table_value(
2088: p_business_group_id => p_business_group_id
2089: ,p_effective_date => p_effective_date
2090: ,p_table_name => l_table_name
2091: ,p_column_name => p_column_name

Line 2672: ,t_event_details OUT NOCOPY pqp_utilities.t_event_details_table_type

2668: DEFAULT 'ENTRY_EFFECTIVE_DATE'
2669: ,p_event_group_name IN VARCHAR2
2670: ,p_start_date IN DATE
2671: ,p_end_date IN DATE
2672: ,t_event_details OUT NOCOPY pqp_utilities.t_event_details_table_type
2673: )
2674: RETURN NUMBER
2675: IS
2676: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;

Line 2680: l_event_details pqp_utilities.t_event_details_table_type;

2676: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
2677: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;
2678: l_detail_tab pay_interpreter_pkg.t_detailed_output_table_type;
2679: l_pro_type_tab pay_interpreter_pkg.t_proration_type_table_type;
2680: l_event_details pqp_utilities.t_event_details_table_type;
2681: l_event_group_id pay_event_groups.event_group_id%TYPE;
2682: l_dt_event_found VARCHAR2(20) := 'N'; -- Default NOTFOUND
2683: l_itr NUMBER;
2684: l_proc_name VARCHAR2(61)

Line 2692: pqp_utilities.get_event_group_id(

2688: IF g_debug THEN
2689: debug_enter(l_proc_name);
2690: END IF;
2691: l_event_group_id :=
2692: pqp_utilities.get_event_group_id(
2693: p_event_group_name => p_event_group_name
2694: ,p_business_group_id => p_business_group_id
2695: );
2696: IF g_debug THEN

Line 2800: l_event_details pqp_utilities.t_event_details_table_type;

2796: l_proration_dates pay_interpreter_pkg.t_proration_dates_table_type;
2797: l_proration_changes pay_interpreter_pkg.t_proration_type_table_type;
2798: l_detail_tab pay_interpreter_pkg.t_detailed_output_table_type;
2799: l_pro_type_tab pay_interpreter_pkg.t_proration_type_table_type;
2800: l_event_details pqp_utilities.t_event_details_table_type;
2801: l_event_group_id pay_event_groups.event_group_id%TYPE;
2802: l_dt_event_found VARCHAR2(20) := 'N'; -- Default NOTFOUND
2803: l_itr NUMBER;
2804: l_proc_name VARCHAR2(61)

Line 2812: pqp_utilities.get_event_group_id(

2808: IF g_debug THEN
2809: debug_enter(l_proc_name);
2810: END IF;
2811: l_event_group_id :=
2812: pqp_utilities.get_event_group_id(
2813: p_event_group_name => p_event_group_name
2814: ,p_business_group_id => p_business_group_id
2815: );
2816: IF g_debug THEN

Line 3731: END pqp_utilities;

3727: END IF;
3728: hr_utility.trace('Leaving: '||l_proc);
3729: END entries_affected;
3730: --
3731: END pqp_utilities;