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 1542: ,p_tab_pen_sch_map_cv OUT NOCOPY pqp_utilities.t_config_values

1538: -- |----------------------------< fetch_pension_scheme_map_cv >---------------|
1539: -- ----------------------------------------------------------------------------
1540: PROCEDURE fetch_pension_scheme_map_cv(
1541: p_business_group_id IN NUMBER
1542: ,p_tab_pen_sch_map_cv OUT NOCOPY pqp_utilities.t_config_values
1543: )
1544: IS
1545: --
1546: l_proc_name VARCHAR2(80)

Line 1551: l_tab_config_values pqp_utilities.t_config_values;

1547: := g_proc_name || 'fetch_pension_scheme_map_cv';
1548: l_proc_step PLS_INTEGER;
1549: l_element_type_id NUMBER;
1550: l_configuration_type pqp_configuration_types.configuration_type%TYPE;
1551: l_tab_config_values pqp_utilities.t_config_values;
1552: i NUMBER;
1553: --
1554: BEGIN
1555: --

Line 1577: pqp_utilities.get_config_type_values(

1573: l_configuration_type := 'PQP_GB_PENSERV_SCHEME_MAP_INFO';
1574:
1575: IF pqp_gb_psi_functions.g_pension_scheme_mapping.COUNT = 0
1576: THEN
1577: pqp_utilities.get_config_type_values(
1578: p_configuration_type => l_configuration_type
1579: ,p_business_group_id => p_business_group_id
1580: ,p_legislation_code => g_legislation_code
1581: ,p_tab_config_values => l_tab_config_values

Line 1660: ,p_tab_lvrsn_map_cv OUT NOCOPY pqp_utilities.t_config_values

1656: -- |----------------------------< fetch_leaving_reason_map_cv >---------------|
1657: -- ----------------------------------------------------------------------------
1658: PROCEDURE fetch_leaving_reason_map_cv(
1659: p_business_group_id IN NUMBER
1660: ,p_tab_lvrsn_map_cv OUT NOCOPY pqp_utilities.t_config_values
1661: )
1662: IS
1663: --
1664: l_proc_name VARCHAR2(80)

Line 1669: l_tab_config_values pqp_utilities.t_config_values;

1665: := g_proc_name || 'fetch_leaving_reason_map_cv';
1666: l_proc_step PLS_INTEGER;
1667: l_element_type_id NUMBER;
1668: l_configuration_type pqp_configuration_types.configuration_type%TYPE;
1669: l_tab_config_values pqp_utilities.t_config_values;
1670: i NUMBER;
1671: l_configuration_desc fnd_descr_flex_contexts_vl.descriptive_flex_context_name%TYPE;
1672: --
1673: BEGIN

Line 1696: pqp_utilities.get_config_type_values(

1692: l_configuration_type := 'PQP_GB_PENSERVER_SER_LVRSN_MAP';
1693: l_configuration_desc :=
1694: get_config_type_desc(p_config_type => l_configuration_type);
1695:
1696: pqp_utilities.get_config_type_values(
1697: p_configuration_type => l_configuration_type
1698: ,p_business_group_id => p_business_group_id
1699: ,p_legislation_code => g_legislation_code
1700: ,p_tab_config_values => l_tab_config_values

Line 1795: l_tab_config_values pqp_utilities.t_config_values;

1791: := g_proc_name || 'fetch_empl_type_map_cv';
1792: l_proc_step PLS_INTEGER;
1793: l_configuration_type pqp_configuration_types.configuration_type%TYPE;
1794: i NUMBER;
1795: l_tab_config_values pqp_utilities.t_config_values;
1796: --
1797: BEGIN
1798: --
1799: IF g_debug

Line 1824: pqp_utilities.get_config_type_values(

1820: -- available from cache
1821: l_tab_config_values :=
1822: pqp_gb_psi_functions.g_assign_category_mapping;
1823: ELSE -- not available so fetch it
1824: pqp_utilities.get_config_type_values(
1825: p_configuration_type => l_configuration_type
1826: ,p_business_group_id => g_business_group_id
1827: ,p_legislation_code => g_legislation_code
1828: ,p_tab_config_values => l_tab_config_values

Line 1961: ,p_tab_pen_sch_map_cv IN pqp_utilities.t_config_values

1957: -- ----------------------------------------------------------------------------
1958: FUNCTION get_pen_scheme_memb(
1959: p_assignment_id IN NUMBER
1960: ,p_effective_date IN DATE
1961: ,p_tab_pen_sch_map_cv IN pqp_utilities.t_config_values
1962: ,p_rec_ele_ent_details OUT NOCOPY r_ele_ent_details
1963: ,p_partnership_scheme OUT NOCOPY Varchar2
1964: )
1965: RETURN VARCHAR2

Line 2415: l_tab_config_values pqp_utilities.t_config_values;

2411: l_proc_step PLS_INTEGER;
2412: l_input_value_name pay_input_values_f.NAME%TYPE;
2413: l_input_value_id NUMBER;
2414: l_element_type_id NUMBER;
2415: l_tab_config_values pqp_utilities.t_config_values;
2416: i NUMBER;
2417: l_rec_asg_sts_dtls csr_get_asg_sts_dtls%ROWTYPE;
2418: --
2419: BEGIN