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

Line 14: pqp_utilities.DEBUG(

10: --
11: BEGIN
12: --
13:
14: pqp_utilities.DEBUG(
15: p_trace_message => p_trace_message
16: ,p_trace_location => p_trace_location
17: );
18: --

Line 32: IF pqp_utilities.g_nested_level = 0

28: PROCEDURE debug_enter(p_proc_name IN VARCHAR2, p_trace_on IN VARCHAR2)
29: IS
30: BEGIN
31: --
32: IF pqp_utilities.g_nested_level = 0
33: THEN
34: hr_utility.trace_on(NULL, 'REQID'); -- Pipe name REQIDnnnnn
35: END IF;
36:

Line 41: pqp_utilities.debug_enter(p_proc_name => p_proc_name

37: -- g_nested_level := g_nested_level + 1;
38: -- debug('Entering: ' || NVL(p_proc_name, g_proc_name)
39: -- ,g_nested_level * 100);
40:
41: pqp_utilities.debug_enter(p_proc_name => p_proc_name
42: ,p_trace_on => p_trace_on);
43: --
44: END debug_enter;
45:

Line 63: pqp_utilities.debug_exit(p_proc_name => p_proc_name

59: -- -g_nested_level * 100
60: -- );
61: -- g_nested_level := g_nested_level
62: -- - 1;
63: pqp_utilities.debug_exit(p_proc_name => p_proc_name
64: ,p_trace_off => p_trace_off);
65:
66: -- debug enter sets trace ON when g_trace = 'Y' and nested level = 0
67: -- so we must turn it off for the same condition

Line 69: IF pqp_utilities.g_nested_level = 0

65:
66: -- debug enter sets trace ON when g_trace = 'Y' and nested level = 0
67: -- so we must turn it off for the same condition
68: -- Also turn off tracing when the override flag of p_trace_off has been passed as Y
69: IF pqp_utilities.g_nested_level = 0
70: THEN
71: hr_utility.trace_off;
72: END IF; -- (g_nested_level = 0
73:

Line 87: pqp_utilities.debug_others(p_proc_name => p_proc_name

83: PROCEDURE debug_others(p_proc_name IN VARCHAR2, p_proc_step IN NUMBER)
84: IS
85: BEGIN
86: --
87: pqp_utilities.debug_others(p_proc_name => p_proc_name
88: ,p_proc_step => p_proc_step);
89: --
90: END debug_others;
91:

Line 884: l_tab_config_values pqp_utilities.t_config_values;

880: l_proc_name VARCHAR2(80)
881: := g_proc_name || 'fetch_process_defn_cv';
882: l_proc_step PLS_INTEGER;
883: l_configuration_type pqp_configuration_types.configuration_type%TYPE;
884: l_tab_config_values pqp_utilities.t_config_values;
885: i NUMBER;
886: --
887: BEGIN
888: --

Line 905: pqp_utilities.get_config_type_values(

901: DEBUG('p_business_group_id: ' || p_business_group_id);
902: END IF;
903:
904: l_configuration_type := 'PQP_GB_PENSERVER_DEFINITION';
905: pqp_utilities.get_config_type_values(
906: p_configuration_type => l_configuration_type
907: ,p_business_group_id => p_business_group_id
908: ,p_legislation_code => g_legislation_code
909: ,p_tab_config_values => l_tab_config_values

Line 995: l_tab_config_values pqp_utilities.t_config_values;

991: l_proc_name VARCHAR2(80)
992: := g_proc_name || 'fetch_event_map_cv';
993: l_proc_step PLS_INTEGER;
994: l_configuration_type pqp_configuration_types.configuration_type%TYPE;
995: l_tab_config_values pqp_utilities.t_config_values;
996: i NUMBER;
997: j NUMBER;
998: l_event_code hr_lookups.lookup_code%TYPE;
999: l_event_desc hr_lookups.meaning%TYPE;

Line 1031: pqp_utilities.get_config_type_values(

1027:
1028: l_configuration_type := 'PQP_GB_PENSERVER_SEREVENT_INFO';
1029: l_configuration_desc :=
1030: get_config_type_desc(p_config_type => l_configuration_type);
1031: pqp_utilities.get_config_type_values(
1032: p_configuration_type => l_configuration_type
1033: ,p_business_group_id => g_business_group_id
1034: ,p_legislation_code => g_legislation_code
1035: ,p_tab_config_values => l_tab_config_values

Line 1560: ,p_tab_pen_sch_map_cv OUT NOCOPY pqp_utilities.t_config_values

1556: -- |----------------------------< fetch_pension_scheme_map_cv >---------------|
1557: -- ----------------------------------------------------------------------------
1558: PROCEDURE fetch_pension_scheme_map_cv(
1559: p_business_group_id IN NUMBER
1560: ,p_tab_pen_sch_map_cv OUT NOCOPY pqp_utilities.t_config_values
1561: )
1562: IS
1563: --
1564: l_proc_name VARCHAR2(80)

Line 1569: l_tab_config_values pqp_utilities.t_config_values;

1565: := g_proc_name || 'fetch_pension_scheme_map_cv';
1566: l_proc_step PLS_INTEGER;
1567: l_element_type_id NUMBER;
1568: l_configuration_type pqp_configuration_types.configuration_type%TYPE;
1569: l_tab_config_values pqp_utilities.t_config_values;
1570: i NUMBER;
1571: --
1572: BEGIN
1573: --

Line 1595: pqp_utilities.get_config_type_values(

1591: l_configuration_type := 'PQP_GB_PENSERV_SCHEME_MAP_INFO';
1592:
1593: IF pqp_gb_psi_functions.g_pension_scheme_mapping.COUNT = 0
1594: THEN
1595: pqp_utilities.get_config_type_values(
1596: p_configuration_type => l_configuration_type
1597: ,p_business_group_id => p_business_group_id
1598: ,p_legislation_code => g_legislation_code
1599: ,p_tab_config_values => l_tab_config_values

Line 1678: ,p_tab_lvrsn_map_cv OUT NOCOPY pqp_utilities.t_config_values

1674: -- |----------------------------< fetch_leaving_reason_map_cv >---------------|
1675: -- ----------------------------------------------------------------------------
1676: PROCEDURE fetch_leaving_reason_map_cv(
1677: p_business_group_id IN NUMBER
1678: ,p_tab_lvrsn_map_cv OUT NOCOPY pqp_utilities.t_config_values
1679: )
1680: IS
1681: --
1682: l_proc_name VARCHAR2(80)

Line 1687: l_tab_config_values pqp_utilities.t_config_values;

1683: := g_proc_name || 'fetch_leaving_reason_map_cv';
1684: l_proc_step PLS_INTEGER;
1685: l_element_type_id NUMBER;
1686: l_configuration_type pqp_configuration_types.configuration_type%TYPE;
1687: l_tab_config_values pqp_utilities.t_config_values;
1688: i NUMBER;
1689: l_configuration_desc fnd_descr_flex_contexts_vl.descriptive_flex_context_name%TYPE;
1690: --
1691: BEGIN

Line 1714: pqp_utilities.get_config_type_values(

1710: l_configuration_type := 'PQP_GB_PENSERVER_SER_LVRSN_MAP';
1711: l_configuration_desc :=
1712: get_config_type_desc(p_config_type => l_configuration_type);
1713:
1714: pqp_utilities.get_config_type_values(
1715: p_configuration_type => l_configuration_type
1716: ,p_business_group_id => p_business_group_id
1717: ,p_legislation_code => g_legislation_code
1718: ,p_tab_config_values => l_tab_config_values

Line 1813: l_tab_config_values pqp_utilities.t_config_values;

1809: := g_proc_name || 'fetch_empl_type_map_cv';
1810: l_proc_step PLS_INTEGER;
1811: l_configuration_type pqp_configuration_types.configuration_type%TYPE;
1812: i NUMBER;
1813: l_tab_config_values pqp_utilities.t_config_values;
1814: --
1815: BEGIN
1816: --
1817: IF g_debug

Line 1842: pqp_utilities.get_config_type_values(

1838: -- available from cache
1839: l_tab_config_values :=
1840: pqp_gb_psi_functions.g_assign_category_mapping;
1841: ELSE -- not available so fetch it
1842: pqp_utilities.get_config_type_values(
1843: p_configuration_type => l_configuration_type
1844: ,p_business_group_id => g_business_group_id
1845: ,p_legislation_code => g_legislation_code
1846: ,p_tab_config_values => l_tab_config_values

Line 1979: ,p_tab_pen_sch_map_cv IN pqp_utilities.t_config_values

1975: -- ----------------------------------------------------------------------------
1976: FUNCTION get_pen_scheme_memb(
1977: p_assignment_id IN NUMBER
1978: ,p_effective_date IN DATE
1979: ,p_tab_pen_sch_map_cv IN pqp_utilities.t_config_values
1980: ,p_rec_ele_ent_details OUT NOCOPY r_ele_ent_details
1981: ,p_partnership_scheme OUT NOCOPY Varchar2
1982: )
1983: RETURN VARCHAR2

Line 2433: l_tab_config_values pqp_utilities.t_config_values;

2429: l_proc_step PLS_INTEGER;
2430: l_input_value_name pay_input_values_f.NAME%TYPE;
2431: l_input_value_id NUMBER;
2432: l_element_type_id NUMBER;
2433: l_tab_config_values pqp_utilities.t_config_values;
2434: i NUMBER;
2435: l_rec_asg_sts_dtls csr_get_asg_sts_dtls%ROWTYPE;
2436: --
2437: BEGIN