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_CONFIGURATION_VALUES

Line 510: p_event_code IN pqp_configuration_values.pcv_information1%TYPE

506: -- ----------------------------------------------------------------------------
507: -- |---------------------< chk_event_in_collection >--------------------------|
508: -- ----------------------------------------------------------------------------
509: FUNCTION chk_event_in_collection(
510: p_event_code IN pqp_configuration_values.pcv_information1%TYPE
511: )
512: RETURN VARCHAR2
513: IS
514: --

Line 588: p_leave_reason IN pqp_configuration_values.pcv_information1%TYPE

584: -- ----------------------------------------------------------------------------
585: -- |---------------------< chk_lvrsn_in_collection >--------------------------|
586: -- ----------------------------------------------------------------------------
587: FUNCTION chk_lvrsn_in_collection(
588: p_leave_reason IN pqp_configuration_values.pcv_information1%TYPE
589: ,p_index OUT NOCOPY NUMBER
590: )
591: RETURN VARCHAR2
592: IS

Line 2006: l_pension_category pqp_configuration_values.pcv_information1%TYPE;

2002:
2003: l_proc_name VARCHAR2(80)
2004: := g_proc_name || 'get_pen_scheme_memb';
2005: l_proc_step PLS_INTEGER;
2006: l_pension_category pqp_configuration_values.pcv_information1%TYPE;
2007: l_rec_ele_ent_details r_ele_ent_details;
2008: l_element_type_id NUMBER;
2009: i NUMBER;
2010: l_eff_start_date DATE := TO_DATE('01-01-0001', 'DD-MM-YYYY');

Line 2657: l_psi_emp_type pqp_configuration_values.pcv_information1%TYPE;

2653: --
2654: l_proc_name VARCHAR2(80) := g_proc_name || 'get_psi_emp_type';
2655: l_proc_step PLS_INTEGER;
2656: i NUMBER;
2657: l_psi_emp_type pqp_configuration_values.pcv_information1%TYPE;
2658: --
2659: BEGIN
2660: --
2661: IF g_debug

Line 2903: l_start_reason pqp_configuration_values.pcv_information1%TYPE;

2899: --
2900: l_proc_name VARCHAR2(80)
2901: := g_proc_name || 'get_service_history_code';
2902: l_proc_step PLS_INTEGER;
2903: l_start_reason pqp_configuration_values.pcv_information1%TYPE;
2904: l_scheme_category pqp_configuration_values.pcv_information1%TYPE;
2905: l_scheme_status pqp_configuration_values.pcv_information1%TYPE;
2906: l_match VARCHAR2(10);
2907: i NUMBER;

Line 2904: l_scheme_category pqp_configuration_values.pcv_information1%TYPE;

2900: l_proc_name VARCHAR2(80)
2901: := g_proc_name || 'get_service_history_code';
2902: l_proc_step PLS_INTEGER;
2903: l_start_reason pqp_configuration_values.pcv_information1%TYPE;
2904: l_scheme_category pqp_configuration_values.pcv_information1%TYPE;
2905: l_scheme_status pqp_configuration_values.pcv_information1%TYPE;
2906: l_match VARCHAR2(10);
2907: i NUMBER;
2908: l_source_pension_scheme pqp_configuration_values.pcv_information1%TYPE;

Line 2905: l_scheme_status pqp_configuration_values.pcv_information1%TYPE;

2901: := g_proc_name || 'get_service_history_code';
2902: l_proc_step PLS_INTEGER;
2903: l_start_reason pqp_configuration_values.pcv_information1%TYPE;
2904: l_scheme_category pqp_configuration_values.pcv_information1%TYPE;
2905: l_scheme_status pqp_configuration_values.pcv_information1%TYPE;
2906: l_match VARCHAR2(10);
2907: i NUMBER;
2908: l_source_pension_scheme pqp_configuration_values.pcv_information1%TYPE;
2909: l_event_description pqp_configuration_values.pcv_information1%TYPE;

Line 2908: l_source_pension_scheme pqp_configuration_values.pcv_information1%TYPE;

2904: l_scheme_category pqp_configuration_values.pcv_information1%TYPE;
2905: l_scheme_status pqp_configuration_values.pcv_information1%TYPE;
2906: l_match VARCHAR2(10);
2907: i NUMBER;
2908: l_source_pension_scheme pqp_configuration_values.pcv_information1%TYPE;
2909: l_event_description pqp_configuration_values.pcv_information1%TYPE;
2910: l_pension_scheme pqp_configuration_values.pcv_information1%TYPE;
2911: l_employment_type pqp_configuration_values.pcv_information1%TYPE;
2912: --

Line 2909: l_event_description pqp_configuration_values.pcv_information1%TYPE;

2905: l_scheme_status pqp_configuration_values.pcv_information1%TYPE;
2906: l_match VARCHAR2(10);
2907: i NUMBER;
2908: l_source_pension_scheme pqp_configuration_values.pcv_information1%TYPE;
2909: l_event_description pqp_configuration_values.pcv_information1%TYPE;
2910: l_pension_scheme pqp_configuration_values.pcv_information1%TYPE;
2911: l_employment_type pqp_configuration_values.pcv_information1%TYPE;
2912: --
2913: BEGIN

Line 2910: l_pension_scheme pqp_configuration_values.pcv_information1%TYPE;

2906: l_match VARCHAR2(10);
2907: i NUMBER;
2908: l_source_pension_scheme pqp_configuration_values.pcv_information1%TYPE;
2909: l_event_description pqp_configuration_values.pcv_information1%TYPE;
2910: l_pension_scheme pqp_configuration_values.pcv_information1%TYPE;
2911: l_employment_type pqp_configuration_values.pcv_information1%TYPE;
2912: --
2913: BEGIN
2914: --

Line 2911: l_employment_type pqp_configuration_values.pcv_information1%TYPE;

2907: i NUMBER;
2908: l_source_pension_scheme pqp_configuration_values.pcv_information1%TYPE;
2909: l_event_description pqp_configuration_values.pcv_information1%TYPE;
2910: l_pension_scheme pqp_configuration_values.pcv_information1%TYPE;
2911: l_employment_type pqp_configuration_values.pcv_information1%TYPE;
2912: --
2913: BEGIN
2914: --
2915: IF g_debug

Line 3397: l_psi_emp_type pqp_configuration_values.pcv_information1%TYPE;

3393: l_psi_code VARCHAR2(10);
3394: l_element_type_id NUMBER;
3395: l_input_value_id NUMBER;
3396: l_char VARCHAR2(100);
3397: l_psi_emp_type pqp_configuration_values.pcv_information1%TYPE;
3398: l_opt_out_date DATE;
3399: l_asg_status_type_id NUMBER;
3400: l_prev_asg_status_type_id NUMBER;
3401: l_absence_type_id NUMBER;

Line 3402: l_pension_category pqp_configuration_values.pcv_information1%TYPE;

3398: l_opt_out_date DATE;
3399: l_asg_status_type_id NUMBER;
3400: l_prev_asg_status_type_id NUMBER;
3401: l_absence_type_id NUMBER;
3402: l_pension_category pqp_configuration_values.pcv_information1%TYPE;
3403: i NUMBER;
3404: j NUMBER;
3405: l_absence_event_code VARCHAR2(10);
3406: l_effective_date DATE;

Line 4391: ,p_start_reason OUT NOCOPY pqp_configuration_values.pcv_information1%TYPE

4387: FUNCTION eval_asg_status_event(
4388: p_assignment_id IN NUMBER
4389: ,p_curr_status_type_id IN NUMBER
4390: ,p_prev_status_type_id IN NUMBER
4391: ,p_start_reason OUT NOCOPY pqp_configuration_values.pcv_information1%TYPE
4392: ,p_event_source OUT NOCOPY VARCHAR2
4393: )
4394: RETURN VARCHAR2
4395: IS

Line 4401: l_start_reason pqp_configuration_values.pcv_information1%TYPE;

4397: l_proc_name VARCHAR2(80)
4398: := g_proc_name || 'eval_asg_status_event';
4399: l_proc_step PLS_INTEGER;
4400: l_return VARCHAR2(10);
4401: l_start_reason pqp_configuration_values.pcv_information1%TYPE;
4402: l_ser_start_date DATE;
4403: l_event_source VARCHAR2(100);
4404: l_index NUMBER;
4405: --

Line 4533: ,p_start_reason OUT NOCOPY pqp_configuration_values.pcv_information1%TYPE

4529: p_assignment_id IN NUMBER
4530: ,p_absence_attendance_id IN NUMBER
4531: ,p_event_group_name IN pay_event_groups.event_group_name%TYPE
4532: ,p_absence_type_id OUT NOCOPY NUMBER
4533: ,p_start_reason OUT NOCOPY pqp_configuration_values.pcv_information1%TYPE
4534: ,p_ser_start_date OUT NOCOPY DATE
4535: ,p_event_source OUT NOCOPY VARCHAR2
4536: )
4537: RETURN VARCHAR2

Line 4565: l_start_reason pqp_configuration_values.pcv_information1%TYPE;

4561: l_rec_abs_dtls csr_get_abs_dtls%ROWTYPE;
4562: l_rec_gap_details csr_chk_pay_trans%ROWTYPE;
4563: l_return VARCHAR2(10);
4564: l_value_in_collection VARCHAR2(10);
4565: l_start_reason pqp_configuration_values.pcv_information1%TYPE;
4566: l_ser_start_date DATE;
4567: l_event_source VARCHAR2(100);
4568: l_index NUMBER;
4569: l_absence_event_code VARCHAR2(10);

Line 4772: ,p_start_reason OUT NOCOPY pqp_configuration_values.pcv_information1%TYPE

4768: FUNCTION eval_gap_transition_event(
4769: p_assignment_id IN NUMBER
4770: ,p_gap_duration_summary_id IN NUMBER
4771: ,p_absence_type_id OUT NOCOPY NUMBER
4772: ,p_start_reason OUT NOCOPY pqp_configuration_values.pcv_information1%TYPE
4773: ,p_ser_start_date OUT NOCOPY DATE
4774: ,p_event_source OUT NOCOPY VARCHAR2
4775: )
4776: RETURN VARCHAR2

Line 4812: l_start_reason pqp_configuration_values.pcv_information1%TYPE;

4808: l_proc_step PLS_INTEGER;
4809: l_rec_abs_dtls csr_get_abs_dtls%ROWTYPE;
4810: l_rec_gap_details csr_get_gap_summary_dtls%ROWTYPE;
4811: l_return VARCHAR2(10);
4812: l_start_reason pqp_configuration_values.pcv_information1%TYPE;
4813: l_ser_start_date DATE;
4814: l_event_source VARCHAR2(100);
4815: l_index NUMBER;
4816: l_absence_code VARCHAR2(10);

Line 5222: l_start_reason pqp_configuration_values.pcv_information1%TYPE;

5218: l_proc_step PLS_INTEGER;
5219: l_rec_ele_ent_info csr_get_ele_ent_info%ROWTYPE;
5220: l_rec_ele_ent_val csr_get_ele_ent_val%ROWTYPE;
5221: l_return VARCHAR2(10);
5222: l_start_reason pqp_configuration_values.pcv_information1%TYPE;
5223: l_ser_start_date DATE;
5224: l_event_source VARCHAR2(100);
5225: l_opt_out_date DATE;
5226: l_asg_start_date DATE;

Line 5228: l_psi_emp_type pqp_configuration_values.pcv_information1%TYPE;

5224: l_event_source VARCHAR2(100);
5225: l_opt_out_date DATE;
5226: l_asg_start_date DATE;
5227: l_leaver_date DATE;
5228: l_psi_emp_type pqp_configuration_values.pcv_information1%TYPE;
5229: l_input_value_id NUMBER;
5230: l_char pay_element_entry_values_f.screen_entry_value%TYPE;
5231: l_pension_category pqp_configuration_values.pcv_information1%TYPE;
5232: l_partnership_scheme VARCHAR2(30);

Line 5231: l_pension_category pqp_configuration_values.pcv_information1%TYPE;

5227: l_leaver_date DATE;
5228: l_psi_emp_type pqp_configuration_values.pcv_information1%TYPE;
5229: l_input_value_id NUMBER;
5230: l_char pay_element_entry_values_f.screen_entry_value%TYPE;
5231: l_pension_category pqp_configuration_values.pcv_information1%TYPE;
5232: l_partnership_scheme VARCHAR2(30);
5233: i NUMBER;
5234: l_effective_end_date DATE;
5235: l_next_effective_end_date DATE;

Line 5910: l_psi_emp_type pqp_configuration_values.pcv_information1%TYPE;

5906: l_start_reason VARCHAR2(10);
5907: l_event_source VARCHAR2(20);
5908: l_asg_start_date DATE;
5909: l_psi_code VARCHAR2(10);
5910: l_psi_emp_type pqp_configuration_values.pcv_information1%TYPE;
5911: l_absence_type_id NUMBER;
5912: l_pension_category pqp_configuration_values.pcv_information1%TYPE;
5913: l_rec_ele_ent_details r_ele_ent_details;
5914: l_asg_status_type_id NUMBER;

Line 5912: l_pension_category pqp_configuration_values.pcv_information1%TYPE;

5908: l_asg_start_date DATE;
5909: l_psi_code VARCHAR2(10);
5910: l_psi_emp_type pqp_configuration_values.pcv_information1%TYPE;
5911: l_absence_type_id NUMBER;
5912: l_pension_category pqp_configuration_values.pcv_information1%TYPE;
5913: l_rec_ele_ent_details r_ele_ent_details;
5914: l_asg_status_type_id NUMBER;
5915: l_event_group_id NUMBER;
5916: l_event_group_name pay_event_groups.event_group_name%TYPE;

Line 6934: l_pension_category pqp_configuration_values.pcv_information1%TYPE;

6930: l_proc_step PLS_INTEGER;
6931: l_include_flag VARCHAR2(10);
6932: l_debug VARCHAR2(10);
6933: i NUMBER;
6934: l_pension_category pqp_configuration_values.pcv_information1%TYPE;
6935: --
6936: BEGIN
6937: --
6938: