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 947: l_config_value pqp_utilities.t_config_values;

943: l_effective_date DATE;
944: l_cutover_date DATE;
945: l_rolling_window_length NUMBER;
946:
947: l_config_value pqp_utilities.t_config_values;
948:
949: -- Concurrent program
950: l_phase VARCHAR2(80);
951: l_status VARCHAR2(80);

Line 1518: pqp_utilities.get_config_type_values

1514:
1515: --***************************
1516: -- fetch configuration value for cutover date
1517: debug('Fetching configuration value for cutover date ...', 40);
1518: pqp_utilities.get_config_type_values
1519: ( p_configuration_type => 'PQP_GB_PENSERVER_PAYPOINT_INFO' --'PQP_GB_PENSERVER_CUTOVER_DATE'
1520: ,p_business_group_id => p_business_group_id
1521: ,p_legislation_code => NULL
1522: ,p_tab_config_values => l_config_value

Line 1534: pqp_utilities.get_config_type_values

1530: END IF;
1531:
1532: -- fetch Effective rolling date window length
1533: debug('Fetching Effective rolling date window length ...', 40);
1534: pqp_utilities.get_config_type_values
1535: ( p_configuration_type => 'PQP_GB_PENSERVER_DEFINITION'
1536: ,p_business_group_id => p_business_group_id
1537: ,p_legislation_code => NULL
1538: ,p_tab_config_values => l_config_value

Line 2962: l_config_value pqp_utilities.t_config_values;

2958: IS
2959: l_proc_name VARCHAR2(61):=
2960: g_proc_name||'paypoint';
2961:
2962: l_config_value pqp_utilities.t_config_values;
2963: l_return VARCHAR2(20);
2964:
2965: BEGIN
2966: --

Line 2974: pqp_utilities.get_config_type_values

2970: IF g_paypoint IS NULL -- 115.58 (4)
2971: THEN
2972: -- fetch configuration value for paypoint
2973: debug('Fetching configuration value for paypoint ...', 20);
2974: pqp_utilities.get_config_type_values
2975: ( p_configuration_type => 'PQP_GB_PENSERVER_PAYPOINT_INFO'
2976: ,p_business_group_id => p_business_group_id
2977: ,p_legislation_code => NULL
2978: ,p_tab_config_values => l_config_value

Line 4056: l_config_value pqp_utilities.t_config_values;

4052:
4053: l_paypoint VARCHAR2(5) := NULL;
4054: l_cutover_date DATE;
4055: l_ext_dfn_id NUMBER;
4056: l_config_value pqp_utilities.t_config_values;
4057: --
4058: BEGIN
4059:
4060:

Line 4104: pqp_utilities.get_config_type_values

4100: END IF;
4101:
4102: -- fetch configuration value for cutover date
4103: debug('Fetching configuration value for cutover date ...', 40);
4104: pqp_utilities.get_config_type_values
4105: ( p_configuration_type => 'PQP_GB_PENSERVER_PAYPOINT_INFO' --'PQP_GB_PENSERVER_CUTOVER_DATE'
4106: ,p_business_group_id => p_business_group_id
4107: ,p_legislation_code => NULL
4108: ,p_tab_config_values => l_config_value

Line 4131: pqp_utilities.get_config_type_values

4127:
4128: -- fetch configuration value for employment type mapping
4129: debug('Fetching configuration value for employment type mapping ...', 65);
4130:
4131: pqp_utilities.get_config_type_values
4132: ( p_configuration_type => 'PQP_GB_PENSERVER_EMPLYMT_TYPE'
4133: ,p_business_group_id => p_business_group_id
4134: ,p_legislation_code => NULL
4135: ,p_tab_config_values => g_assign_category_mapping --caching in global

Line 4144: pqp_utilities.get_config_type_values

4140:
4141: -- fetch configuration value for pension scheme mapping
4142: debug('Fetching configuration value for pension scheme mapping ...', 65);
4143:
4144: pqp_utilities.get_config_type_values
4145: ( p_configuration_type => 'PQP_GB_PENSERV_SCHEME_MAP_INFO'
4146: ,p_business_group_id => p_business_group_id
4147: ,p_legislation_code => NULL
4148: ,p_tab_config_values => g_pension_scheme_mapping --caching in global

Line 4195: l_config_value pqp_utilities.t_config_values;

4191: l_proc_name VARCHAR2(61):=
4192: g_proc_name||'check_employee_pension_scheme';
4193:
4194: l_return VARCHAR2(1) := 'N';
4195: l_config_value pqp_utilities.t_config_values;
4196: l_index NUMBER;
4197: l_element_type_id NUMBER := NULL;
4198:
4199: BEGIN

Line 4301: l_config_values PQP_UTILITIES.t_config_values;

4297: IS
4298: --
4299: l_proc_name VARCHAR2(61):= g_proc_name||'check_employee_eligibility';
4300: l_return VARCHAR2(1) := 'Y';
4301: l_config_values PQP_UTILITIES.t_config_values;
4302:
4303: l_query VARCHAR2(1000);
4304: TYPE base_table_ref_csr_typ IS REF CURSOR;
4305: c_base_table base_table_ref_csr_typ;

Line 4316: PQP_UTILITIES.get_config_type_values(

4312:
4313: IF g_asg_membership_col IS NULL THEN
4314: -- fetch the value if g_asg_membership_col is null
4315: debug('Fetch the column name for the first time.',30);
4316: PQP_UTILITIES.get_config_type_values(
4317: p_configuration_type => 'PQP_GB_PENSERVER_ELIGBLTY_CONF'
4318: ,p_business_group_id => g_business_group_id
4319: ,p_legislation_code => g_legislation_code
4320: ,p_tab_config_values => l_config_values

Line 4875: l_config_value PQP_UTILITIES.t_config_values;

4871:
4872: l_proc_name VARCHAR2(80) := g_proc_name || 'get_last_run_date';
4873: l_proc_step PLS_INTEGER;
4874: l_run_date DATE;
4875: l_config_value PQP_UTILITIES.t_config_values;
4876:
4877: l_reference_extract VARCHAr2(30);
4878: l_ext_dfn_id NUMBER;
4879: --

Line 4891: pqp_utilities.get_config_type_values

4887:
4888: /*
4889: -- fetch reference extract name
4890: debug('Fetching Effective rolling date window length ...', 40);
4891: pqp_utilities.get_config_type_values
4892: ( p_configuration_type => 'PQP_GB_PENSERVER_DEFINITION'
4893: ,p_business_group_id => g_business_group_id
4894: ,p_legislation_code => NULL
4895: ,p_tab_config_values => l_config_value

Line 8114: l_err_no := pqp_utilities.pqp_gb_get_table_value(

8110: ,p_token1 => to_char(g_effective_date,'dd-MON-yyyy')
8111: );
8112: ELSE
8113: debug('l_contract_type: '||l_contract_type,20);
8114: l_err_no := pqp_utilities.pqp_gb_get_table_value(
8115: p_business_group_id => p_business_group_id
8116: ,p_effective_date => p_effective_date
8117: ,p_table_name => 'PQP_CONTRACT_TYPES'
8118: ,p_column_name => 'PenServer Contract Type'

Line 8526: l_config_value PQP_UTILITIES.t_config_values;

8522: c_seeded_basic_sal_rate_name CONSTANT VARCHAR2(80) := 'PenServer Pensionable Salary';
8523: c_seeded_basic_sal_rate_code CONSTANT VARCHAR2(80) := 'PEN_SALARY';
8524: l_rate_code VARCHAR2(80);
8525: l_rate_name VARCHAR2(80);
8526: l_config_value PQP_UTILITIES.t_config_values;
8527: l_proc varchar2(72) := g_proc_name||'get_rate_usr_func_name';
8528: l_itr NUMBER;
8529: BEGIN
8530: debug_enter(l_proc);

Line 8537: PQP_UTILITIES.get_config_type_values(

8533: debug('p_legislation_code: '||p_legislation_code,10);
8534: debug('p_interface_name: '||p_interface_name,10);
8535:
8536:
8537: PQP_UTILITIES.get_config_type_values(
8538: p_configuration_type => 'PQP_GB_PENSERVER_RATE_TYPES'
8539: ,p_business_group_id => p_business_group_id
8540: ,p_legislation_code => p_legislation_code
8541: ,p_tab_config_values => l_config_value