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

Line 42: l_config_value pqp_utilities.t_config_values;

38:
39: l_proc_name VARCHAR2(61):=
40: g_proc_name||'check_debug';
41:
42: l_config_value pqp_utilities.t_config_values;
43: l_return VARCHAR2(20);
44: l_debug_enable_mode fnd_concurrent_requests.argument3%type;
45: l_process_parameters csr_debug_enable_mode%rowtype;
46: l_parent_process_parameters csr_debug_enable_mode%rowtype;

Line 104: pqp_utilities.get_config_type_values

100:
101: IF g_debug = TRUE THEN
102: -- fetch configuration value for paypoint
103: -- debug('Fetching configuration value for debug flag ...', 20);
104: pqp_utilities.get_config_type_values
105: ( p_configuration_type => 'PQP_GB_PENSERVER_DEFINITION'
106: ,p_business_group_id => p_business_group_id
107: ,p_legislation_code => NULL
108: ,p_tab_config_values => l_config_value

Line 145: pqp_utilities.DEBUG (

141: --
142: BEGIN
143: --
144:
145: pqp_utilities.DEBUG (
146: p_trace_message => p_trace_message
147: ,p_trace_location => p_trace_location
148: );
149: --

Line 165: IF pqp_utilities.g_nested_level = 0 THEN

161: IS
162: BEGIN
163: --
164: IF g_debug THEN
165: IF pqp_utilities.g_nested_level = 0 THEN
166: hr_utility.trace_on(NULL, 'REQID'); -- Pipe name REQIDnnnnn
167: END IF;
168: pqp_utilities.debug_enter (
169: p_proc_name => p_proc_name

Line 168: pqp_utilities.debug_enter (

164: IF g_debug THEN
165: IF pqp_utilities.g_nested_level = 0 THEN
166: hr_utility.trace_on(NULL, 'REQID'); -- Pipe name REQIDnnnnn
167: END IF;
168: pqp_utilities.debug_enter (
169: p_proc_name => p_proc_name
170: ,p_trace_on => p_trace_on
171: );
172: END IF;

Line 189: pqp_utilities.debug_exit (

185: IS
186: BEGIN
187: --
188: IF g_debug THEN
189: pqp_utilities.debug_exit (
190: p_proc_name => p_proc_name
191: ,p_trace_off => p_trace_off
192: );
193:

Line 194: IF pqp_utilities.g_nested_level = 0 THEN

190: p_proc_name => p_proc_name
191: ,p_trace_off => p_trace_off
192: );
193:
194: IF pqp_utilities.g_nested_level = 0 THEN
195: hr_utility.trace_off;
196: END IF;
197: END IF;
198: --

Line 212: pqp_utilities.debug_others (

208: PROCEDURE debug_others (p_proc_name IN VARCHAR2, p_proc_step IN NUMBER)
209: IS
210: BEGIN
211: --
212: pqp_utilities.debug_others (
213: p_proc_name => p_proc_name
214: ,p_proc_step => p_proc_step
215: );
216: --

Line 883: l_config_value pqp_utilities.t_config_values;

879: l_effective_date DATE;
880: l_cutover_date DATE;
881: l_rolling_window_length NUMBER;
882:
883: l_config_value pqp_utilities.t_config_values;
884:
885: -- Concurrent program
886: l_phase VARCHAR2(80);
887: l_status VARCHAR2(80);

Line 1454: pqp_utilities.get_config_type_values

1450:
1451: --***************************
1452: -- fetch configuration value for cutover date
1453: debug('Fetching configuration value for cutover date ...', 40);
1454: pqp_utilities.get_config_type_values
1455: ( p_configuration_type => 'PQP_GB_PENSERVER_PAYPOINT_INFO' --'PQP_GB_PENSERVER_CUTOVER_DATE'
1456: ,p_business_group_id => p_business_group_id
1457: ,p_legislation_code => NULL
1458: ,p_tab_config_values => l_config_value

Line 1470: pqp_utilities.get_config_type_values

1466: END IF;
1467:
1468: -- fetch Effective rolling date window length
1469: debug('Fetching Effective rolling date window length ...', 40);
1470: pqp_utilities.get_config_type_values
1471: ( p_configuration_type => 'PQP_GB_PENSERVER_DEFINITION'
1472: ,p_business_group_id => p_business_group_id
1473: ,p_legislation_code => NULL
1474: ,p_tab_config_values => l_config_value

Line 2898: l_config_value pqp_utilities.t_config_values;

2894: IS
2895: l_proc_name VARCHAR2(61):=
2896: g_proc_name||'paypoint';
2897:
2898: l_config_value pqp_utilities.t_config_values;
2899: l_return VARCHAR2(20);
2900:
2901: BEGIN
2902: --

Line 2910: pqp_utilities.get_config_type_values

2906: IF g_paypoint IS NULL -- 115.58 (4)
2907: THEN
2908: -- fetch configuration value for paypoint
2909: debug('Fetching configuration value for paypoint ...', 20);
2910: pqp_utilities.get_config_type_values
2911: ( p_configuration_type => 'PQP_GB_PENSERVER_PAYPOINT_INFO'
2912: ,p_business_group_id => p_business_group_id
2913: ,p_legislation_code => NULL
2914: ,p_tab_config_values => l_config_value

Line 3992: l_config_value pqp_utilities.t_config_values;

3988:
3989: l_paypoint VARCHAR2(5) := NULL;
3990: l_cutover_date DATE;
3991: l_ext_dfn_id NUMBER;
3992: l_config_value pqp_utilities.t_config_values;
3993: --
3994: BEGIN
3995:
3996:

Line 4032: pqp_utilities.get_config_type_values

4028: END IF;
4029:
4030: -- fetch configuration value for cutover date
4031: debug('Fetching configuration value for cutover date ...', 40);
4032: pqp_utilities.get_config_type_values
4033: ( p_configuration_type => 'PQP_GB_PENSERVER_PAYPOINT_INFO' --'PQP_GB_PENSERVER_CUTOVER_DATE'
4034: ,p_business_group_id => p_business_group_id
4035: ,p_legislation_code => NULL
4036: ,p_tab_config_values => l_config_value

Line 4059: pqp_utilities.get_config_type_values

4055:
4056: -- fetch configuration value for employment type mapping
4057: debug('Fetching configuration value for employment type mapping ...', 65);
4058:
4059: pqp_utilities.get_config_type_values
4060: ( p_configuration_type => 'PQP_GB_PENSERVER_EMPLYMT_TYPE'
4061: ,p_business_group_id => p_business_group_id
4062: ,p_legislation_code => NULL
4063: ,p_tab_config_values => g_assign_category_mapping --caching in global

Line 4072: pqp_utilities.get_config_type_values

4068:
4069: -- fetch configuration value for pension scheme mapping
4070: debug('Fetching configuration value for pension scheme mapping ...', 65);
4071:
4072: pqp_utilities.get_config_type_values
4073: ( p_configuration_type => 'PQP_GB_PENSERV_SCHEME_MAP_INFO'
4074: ,p_business_group_id => p_business_group_id
4075: ,p_legislation_code => NULL
4076: ,p_tab_config_values => g_pension_scheme_mapping --caching in global

Line 4123: l_config_value pqp_utilities.t_config_values;

4119: l_proc_name VARCHAR2(61):=
4120: g_proc_name||'check_employee_pension_scheme';
4121:
4122: l_return VARCHAR2(1) := 'N';
4123: l_config_value pqp_utilities.t_config_values;
4124: l_index NUMBER;
4125: l_element_type_id NUMBER := NULL;
4126:
4127: BEGIN

Line 4229: l_config_values PQP_UTILITIES.t_config_values;

4225: IS
4226: --
4227: l_proc_name VARCHAR2(61):= g_proc_name||'check_employee_eligibility';
4228: l_return VARCHAR2(1) := 'Y';
4229: l_config_values PQP_UTILITIES.t_config_values;
4230:
4231: l_query VARCHAR2(1000);
4232: TYPE base_table_ref_csr_typ IS REF CURSOR;
4233: c_base_table base_table_ref_csr_typ;

Line 4244: PQP_UTILITIES.get_config_type_values(

4240:
4241: IF g_asg_membership_col IS NULL THEN
4242: -- fetch the value if g_asg_membership_col is null
4243: debug('Fetch the column name for the first time.',30);
4244: PQP_UTILITIES.get_config_type_values(
4245: p_configuration_type => 'PQP_GB_PENSERVER_ELIGBLTY_CONF'
4246: ,p_business_group_id => g_business_group_id
4247: ,p_legislation_code => g_legislation_code
4248: ,p_tab_config_values => l_config_values

Line 4803: l_config_value PQP_UTILITIES.t_config_values;

4799:
4800: l_proc_name VARCHAR2(80) := g_proc_name || 'get_last_run_date';
4801: l_proc_step PLS_INTEGER;
4802: l_run_date DATE;
4803: l_config_value PQP_UTILITIES.t_config_values;
4804:
4805: l_reference_extract VARCHAr2(30);
4806: l_ext_dfn_id NUMBER;
4807: --

Line 4819: pqp_utilities.get_config_type_values

4815:
4816: /*
4817: -- fetch reference extract name
4818: debug('Fetching Effective rolling date window length ...', 40);
4819: pqp_utilities.get_config_type_values
4820: ( p_configuration_type => 'PQP_GB_PENSERVER_DEFINITION'
4821: ,p_business_group_id => g_business_group_id
4822: ,p_legislation_code => NULL
4823: ,p_tab_config_values => l_config_value

Line 7649: l_err_no := pqp_utilities.pqp_gb_get_table_value(

7645: ,p_token1 => to_char(g_effective_date,'dd-MON-yyyy')
7646: );
7647: ELSE
7648: debug('l_contract_type: '||l_contract_type,20);
7649: l_err_no := pqp_utilities.pqp_gb_get_table_value(
7650: p_business_group_id => p_business_group_id
7651: ,p_effective_date => p_effective_date
7652: ,p_table_name => 'PQP_CONTRACT_TYPES'
7653: ,p_column_name => 'PenServer Contract Type'

Line 8061: l_config_value PQP_UTILITIES.t_config_values;

8057: c_seeded_basic_sal_rate_name CONSTANT VARCHAR2(80) := 'PenServer Pensionable Salary';
8058: c_seeded_basic_sal_rate_code CONSTANT VARCHAR2(80) := 'PEN_SALARY';
8059: l_rate_code VARCHAR2(80);
8060: l_rate_name VARCHAR2(80);
8061: l_config_value PQP_UTILITIES.t_config_values;
8062: l_proc varchar2(72) := g_proc_name||'get_rate_usr_func_name';
8063: l_itr NUMBER;
8064: BEGIN
8065: debug_enter(l_proc);

Line 8072: PQP_UTILITIES.get_config_type_values(

8068: debug('p_legislation_code: '||p_legislation_code,10);
8069: debug('p_interface_name: '||p_interface_name,10);
8070:
8071:
8072: PQP_UTILITIES.get_config_type_values(
8073: p_configuration_type => 'PQP_GB_PENSERVER_RATE_TYPES'
8074: ,p_business_group_id => p_business_group_id
8075: ,p_legislation_code => p_legislation_code
8076: ,p_tab_config_values => l_config_value