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 BEN_EXT_PERSON

Line 2812: debug('ben_ext_person.g_effective_date: '|| ben_ext_person.g_effective_date);

2808: OPEN csr_get_max_asg_end_date;
2809: FETCH csr_get_max_asg_end_date INTO l_max_asg_end_date;
2810: CLOSE csr_get_max_asg_end_date;
2811:
2812: debug('ben_ext_person.g_effective_date: '|| ben_ext_person.g_effective_date);
2813:
2814: IF l_max_asg_end_date < ben_ext_person.g_effective_date
2815: THEN
2816: l_basic_date := l_max_asg_end_date;

Line 2814: IF l_max_asg_end_date < ben_ext_person.g_effective_date

2810: CLOSE csr_get_max_asg_end_date;
2811:
2812: debug('ben_ext_person.g_effective_date: '|| ben_ext_person.g_effective_date);
2813:
2814: IF l_max_asg_end_date < ben_ext_person.g_effective_date
2815: THEN
2816: l_basic_date := l_max_asg_end_date;
2817: ELSE
2818: l_basic_date := ben_ext_person.g_effective_date;

Line 2818: l_basic_date := ben_ext_person.g_effective_date;

2814: IF l_max_asg_end_date < ben_ext_person.g_effective_date
2815: THEN
2816: l_basic_date := l_max_asg_end_date;
2817: ELSE
2818: l_basic_date := ben_ext_person.g_effective_date;
2819: END IF;
2820: --115.87:Bug 7291713: Stop
2821:
2822: ELSE --g_dfn_name <> 'BDI'

Line 3495: ,ben_ext_person.g_person_id);

3491: --l_person_id := -1; --p_assignment_id ; -- independent of person
3492: l_person_id := p_assignment_id ; -- independent of person
3493: ELSE -- DE related warning
3494: l_person_id:= NVL(get_current_extract_person(p_assignment_id)
3495: ,ben_ext_person.g_person_id);
3496: END IF;
3497: debug('l_person_id : '||l_person_id, 99);
3498:
3499: IF l_person_id IS NOT NULL THEN

Line 3585: NVL(ben_ext_person.g_elmt_name,ben_ext_fmt.g_elmt_name)||'. '||

3581:
3582: If p_error_number is null Then
3583:
3584: l_error_text:= 'Error raised in data element '||
3585: NVL(ben_ext_person.g_elmt_name,ben_ext_fmt.g_elmt_name)||'. '||
3586: p_error_text;
3587:
3588:
3589: Elsif p_token1 is null Then

Line 3638: ,ben_ext_person.g_person_id);

3634: -- 115.10
3635: l_err_typ_cd := 'F'; -- all setup errors are fatal
3636: ELSE -- DE related error
3637: l_person_id := NVL(get_current_extract_person(p_assignment_id)
3638: ,ben_ext_person.g_person_id);
3639: -- 115.10
3640: l_err_typ_cd := 'E'; -- all data element related errors are 'E'
3641: END IF;
3642: debug('l_person_id : '||l_person_id, 99);

Line 4784: l_prev_event_dtl_rec ben_ext_person.t_detailed_output_tab_rec;

4780: ----
4781: FUNCTION is_curr_last_event RETURN BOOLEAN
4782: IS
4783: l_proc varchar2(72) := g_proc_name||'.is_curr_last_event';
4784: l_prev_event_dtl_rec ben_ext_person.t_detailed_output_tab_rec;
4785: l_flag VARCHAR2(1);
4786: l_curr_idx NUMBER;
4787: l_next_event_dtl_rec ben_ext_person.t_detailed_output_tab_rec;
4788: l_curr_event_dtl_rec ben_ext_person.t_detailed_output_tab_rec;

Line 4787: l_next_event_dtl_rec ben_ext_person.t_detailed_output_tab_rec;

4783: l_proc varchar2(72) := g_proc_name||'.is_curr_last_event';
4784: l_prev_event_dtl_rec ben_ext_person.t_detailed_output_tab_rec;
4785: l_flag VARCHAR2(1);
4786: l_curr_idx NUMBER;
4787: l_next_event_dtl_rec ben_ext_person.t_detailed_output_tab_rec;
4788: l_curr_event_dtl_rec ben_ext_person.t_detailed_output_tab_rec;
4789: l_return BOOLEAN;
4790: BEGIN
4791: debug_enter(l_proc);

Line 4788: l_curr_event_dtl_rec ben_ext_person.t_detailed_output_tab_rec;

4784: l_prev_event_dtl_rec ben_ext_person.t_detailed_output_tab_rec;
4785: l_flag VARCHAR2(1);
4786: l_curr_idx NUMBER;
4787: l_next_event_dtl_rec ben_ext_person.t_detailed_output_tab_rec;
4788: l_curr_event_dtl_rec ben_ext_person.t_detailed_output_tab_rec;
4789: l_return BOOLEAN;
4790: BEGIN
4791: debug_enter(l_proc);
4792: l_curr_idx := ben_ext_person.g_chg_pay_evt_index;

Line 4792: l_curr_idx := ben_ext_person.g_chg_pay_evt_index;

4788: l_curr_event_dtl_rec ben_ext_person.t_detailed_output_tab_rec;
4789: l_return BOOLEAN;
4790: BEGIN
4791: debug_enter(l_proc);
4792: l_curr_idx := ben_ext_person.g_chg_pay_evt_index;
4793:
4794: IF l_curr_idx = ben_ext_person.g_pay_proc_evt_tab.COUNT
4795: OR l_curr_idx = ben_ext_person.g_pay_proc_evt_tab.COUNT - 1 THEN
4796: IF l_curr_idx = ben_ext_person.g_pay_proc_evt_tab.COUNT - 1 THEN

Line 4794: IF l_curr_idx = ben_ext_person.g_pay_proc_evt_tab.COUNT

4790: BEGIN
4791: debug_enter(l_proc);
4792: l_curr_idx := ben_ext_person.g_chg_pay_evt_index;
4793:
4794: IF l_curr_idx = ben_ext_person.g_pay_proc_evt_tab.COUNT
4795: OR l_curr_idx = ben_ext_person.g_pay_proc_evt_tab.COUNT - 1 THEN
4796: IF l_curr_idx = ben_ext_person.g_pay_proc_evt_tab.COUNT - 1 THEN
4797: -- if the current is last-1 event. check for duplicate row.
4798: debug('the current is last-1 event.',30);

Line 4795: OR l_curr_idx = ben_ext_person.g_pay_proc_evt_tab.COUNT - 1 THEN

4791: debug_enter(l_proc);
4792: l_curr_idx := ben_ext_person.g_chg_pay_evt_index;
4793:
4794: IF l_curr_idx = ben_ext_person.g_pay_proc_evt_tab.COUNT
4795: OR l_curr_idx = ben_ext_person.g_pay_proc_evt_tab.COUNT - 1 THEN
4796: IF l_curr_idx = ben_ext_person.g_pay_proc_evt_tab.COUNT - 1 THEN
4797: -- if the current is last-1 event. check for duplicate row.
4798: debug('the current is last-1 event.',30);
4799: l_curr_event_dtl_rec := ben_ext_person.g_pay_proc_evt_tab(l_curr_idx);

Line 4796: IF l_curr_idx = ben_ext_person.g_pay_proc_evt_tab.COUNT - 1 THEN

4792: l_curr_idx := ben_ext_person.g_chg_pay_evt_index;
4793:
4794: IF l_curr_idx = ben_ext_person.g_pay_proc_evt_tab.COUNT
4795: OR l_curr_idx = ben_ext_person.g_pay_proc_evt_tab.COUNT - 1 THEN
4796: IF l_curr_idx = ben_ext_person.g_pay_proc_evt_tab.COUNT - 1 THEN
4797: -- if the current is last-1 event. check for duplicate row.
4798: debug('the current is last-1 event.',30);
4799: l_curr_event_dtl_rec := ben_ext_person.g_pay_proc_evt_tab(l_curr_idx);
4800: l_next_event_dtl_rec := ben_ext_person.g_pay_proc_evt_tab(l_curr_idx+1);

Line 4799: l_curr_event_dtl_rec := ben_ext_person.g_pay_proc_evt_tab(l_curr_idx);

4795: OR l_curr_idx = ben_ext_person.g_pay_proc_evt_tab.COUNT - 1 THEN
4796: IF l_curr_idx = ben_ext_person.g_pay_proc_evt_tab.COUNT - 1 THEN
4797: -- if the current is last-1 event. check for duplicate row.
4798: debug('the current is last-1 event.',30);
4799: l_curr_event_dtl_rec := ben_ext_person.g_pay_proc_evt_tab(l_curr_idx);
4800: l_next_event_dtl_rec := ben_ext_person.g_pay_proc_evt_tab(l_curr_idx+1);
4801: l_next_event_dtl_rec.change_mode := l_curr_event_dtl_rec.change_mode;
4802: l_flag := 'Y';
4803: IF l_curr_event_dtl_rec.dated_table_id <> l_next_event_dtl_rec.dated_table_id THEN

Line 4800: l_next_event_dtl_rec := ben_ext_person.g_pay_proc_evt_tab(l_curr_idx+1);

4796: IF l_curr_idx = ben_ext_person.g_pay_proc_evt_tab.COUNT - 1 THEN
4797: -- if the current is last-1 event. check for duplicate row.
4798: debug('the current is last-1 event.',30);
4799: l_curr_event_dtl_rec := ben_ext_person.g_pay_proc_evt_tab(l_curr_idx);
4800: l_next_event_dtl_rec := ben_ext_person.g_pay_proc_evt_tab(l_curr_idx+1);
4801: l_next_event_dtl_rec.change_mode := l_curr_event_dtl_rec.change_mode;
4802: l_flag := 'Y';
4803: IF l_curr_event_dtl_rec.dated_table_id <> l_next_event_dtl_rec.dated_table_id THEN
4804: l_flag := 'N';

Line 4961: '01-04-' || TO_CHAR(ben_ext_person.g_effective_date, 'YYYY')

4957: IF l_run_date IS NULL
4958: THEN
4959: l_run_date :=
4960: TO_DATE(
4961: '01-04-' || TO_CHAR(ben_ext_person.g_effective_date, 'YYYY')
4962: ,'DD-MM-YYYY'
4963: );
4964: IF l_run_date > ben_ext_person.g_effective_date
4965: THEN

Line 4964: IF l_run_date > ben_ext_person.g_effective_date

4960: TO_DATE(
4961: '01-04-' || TO_CHAR(ben_ext_person.g_effective_date, 'YYYY')
4962: ,'DD-MM-YYYY'
4963: );
4964: IF l_run_date > ben_ext_person.g_effective_date
4965: THEN
4966: l_run_date := ADD_MONTHS(l_run_date, -12);
4967: END IF;
4968: -- Bugfix 4969368: Moving this logic of run_date +1 above

Line 5005: l_prev_event_dtl_rec ben_ext_person.t_detailed_output_tab_rec;

5001: -- ----------------------------------------------------------------------------
5002: FUNCTION is_curr_evt_processed RETURN BOOLEAN
5003: IS
5004: l_proc varchar2(72) := g_proc_name||'is_curr_evt_processed';
5005: l_prev_event_dtl_rec ben_ext_person.t_detailed_output_tab_rec;
5006: l_flag VARCHAR2(1);
5007: BEGIN
5008: debug_enter(l_proc);
5009:

Line 5011: l_prev_event_dtl_rec := ben_ext_person.g_pay_proc_evt_tab(ben_ext_person.g_chg_pay_evt_index);

5007: BEGIN
5008: debug_enter(l_proc);
5009:
5010: IF g_prev_event_dtl_rec.dated_table_id IS NOT NULL THEN
5011: l_prev_event_dtl_rec := ben_ext_person.g_pay_proc_evt_tab(ben_ext_person.g_chg_pay_evt_index);
5012: l_prev_event_dtl_rec.change_mode := g_prev_event_dtl_rec.change_mode;
5013: l_flag := 'Y';
5014: IF l_prev_event_dtl_rec.dated_table_id <> g_prev_event_dtl_rec.dated_table_id THEN
5015: l_flag := 'N';

Line 5045: g_prev_event_dtl_rec := ben_ext_person.g_pay_proc_evt_tab(ben_ext_person.g_chg_pay_evt_index);

5041: debug('Event already processed',30);
5042: debug_exit(l_proc);
5043: RETURN TRUE;
5044: ELSE
5045: g_prev_event_dtl_rec := ben_ext_person.g_pay_proc_evt_tab(ben_ext_person.g_chg_pay_evt_index);
5046: END IF;
5047: ELSE
5048: debug('First event');
5049: g_prev_event_dtl_rec := ben_ext_person.g_pay_proc_evt_tab(ben_ext_person.g_chg_pay_evt_index);

Line 5049: g_prev_event_dtl_rec := ben_ext_person.g_pay_proc_evt_tab(ben_ext_person.g_chg_pay_evt_index);

5045: g_prev_event_dtl_rec := ben_ext_person.g_pay_proc_evt_tab(ben_ext_person.g_chg_pay_evt_index);
5046: END IF;
5047: ELSE
5048: debug('First event');
5049: g_prev_event_dtl_rec := ben_ext_person.g_pay_proc_evt_tab(ben_ext_person.g_chg_pay_evt_index);
5050: END IF;
5051:
5052: debug_exit(l_proc);
5053: RETURN FALSE;

Line 5095: g_effective_end_date := ben_ext_person.g_effective_date;

5091: -- populate the effective dates
5092: g_effective_start_date :=
5093: get_last_run_date(p_run_from_cutover_date => p_run_from_cutover_date -- Bugfix 4969368
5094: );
5095: g_effective_end_date := ben_ext_person.g_effective_date;
5096: END IF;
5097:
5098: IF g_debug
5099: THEN

Line 5106: IF NVL(g_person_id, hr_api.g_number) <> ben_ext_person.g_person_id

5102: debug('g_effective_start_date: '||TO_CHAR(g_effective_start_date, 'DD/MON/YYYY'));
5103: debug('g_effective_end_date: '||TO_CHAR(g_effective_end_date, 'DD/MON/YYYY'));
5104: END IF;
5105:
5106: IF NVL(g_person_id, hr_api.g_number) <> ben_ext_person.g_person_id
5107: THEN
5108: g_person_id := ben_ext_person.g_person_id;
5109: g_min_eff_date_exists := 'N';
5110: debug('NVL(g_person_id, hr_api.g_number) <> ben_ext_person.g_person_id',20);

Line 5108: g_person_id := ben_ext_person.g_person_id;

5104: END IF;
5105:
5106: IF NVL(g_person_id, hr_api.g_number) <> ben_ext_person.g_person_id
5107: THEN
5108: g_person_id := ben_ext_person.g_person_id;
5109: g_min_eff_date_exists := 'N';
5110: debug('NVL(g_person_id, hr_api.g_number) <> ben_ext_person.g_person_id',20);
5111: END IF;
5112:

Line 5110: debug('NVL(g_person_id, hr_api.g_number) <> ben_ext_person.g_person_id',20);

5106: IF NVL(g_person_id, hr_api.g_number) <> ben_ext_person.g_person_id
5107: THEN
5108: g_person_id := ben_ext_person.g_person_id;
5109: g_min_eff_date_exists := 'N';
5110: debug('NVL(g_person_id, hr_api.g_number) <> ben_ext_person.g_person_id',20);
5111: END IF;
5112:
5113: -- set the start date of the range to '00:00:00'
5114: -- and set the end date of the range to '23:59:59'

Line 5139: if (ben_ext_person.g_pay_proc_evt_tab.COUNT > 0 AND

5135: --
5136: l_return := 'N';
5137: /* Bug Fix 9370749 Start */
5138: debug('Min Eff Date exists check',28);
5139: if (ben_ext_person.g_pay_proc_evt_tab.COUNT > 0 AND
5140: g_min_eff_date_exists = 'N' AND
5141: nvl(g_dfn_name,'~') = 'SVI') then
5142: for i in 1..ben_ext_person.g_pay_proc_evt_tab.COUNT
5143: loop

Line 5142: for i in 1..ben_ext_person.g_pay_proc_evt_tab.COUNT

5138: debug('Min Eff Date exists check',28);
5139: if (ben_ext_person.g_pay_proc_evt_tab.COUNT > 0 AND
5140: g_min_eff_date_exists = 'N' AND
5141: nvl(g_dfn_name,'~') = 'SVI') then
5142: for i in 1..ben_ext_person.g_pay_proc_evt_tab.COUNT
5143: loop
5144: debug('eff_date('||i||'):'||ben_ext_person.g_pay_proc_evt_tab(i).effective_date,28);
5145: debug('act_date('||i||'):'||ben_ext_person.g_pay_proc_evt_tab(i).actual_date,28);
5146: event_effec_date := ben_ext_person.g_pay_proc_evt_tab(i).effective_date;

Line 5144: debug('eff_date('||i||'):'||ben_ext_person.g_pay_proc_evt_tab(i).effective_date,28);

5140: g_min_eff_date_exists = 'N' AND
5141: nvl(g_dfn_name,'~') = 'SVI') then
5142: for i in 1..ben_ext_person.g_pay_proc_evt_tab.COUNT
5143: loop
5144: debug('eff_date('||i||'):'||ben_ext_person.g_pay_proc_evt_tab(i).effective_date,28);
5145: debug('act_date('||i||'):'||ben_ext_person.g_pay_proc_evt_tab(i).actual_date,28);
5146: event_effec_date := ben_ext_person.g_pay_proc_evt_tab(i).effective_date;
5147: event_act_date := ben_ext_person.g_pay_proc_evt_tab(i).actual_date;
5148: if( g_min_eff_date_exists = 'N' AND

Line 5145: debug('act_date('||i||'):'||ben_ext_person.g_pay_proc_evt_tab(i).actual_date,28);

5141: nvl(g_dfn_name,'~') = 'SVI') then
5142: for i in 1..ben_ext_person.g_pay_proc_evt_tab.COUNT
5143: loop
5144: debug('eff_date('||i||'):'||ben_ext_person.g_pay_proc_evt_tab(i).effective_date,28);
5145: debug('act_date('||i||'):'||ben_ext_person.g_pay_proc_evt_tab(i).actual_date,28);
5146: event_effec_date := ben_ext_person.g_pay_proc_evt_tab(i).effective_date;
5147: event_act_date := ben_ext_person.g_pay_proc_evt_tab(i).actual_date;
5148: if( g_min_eff_date_exists = 'N' AND
5149: (( (event_effec_date between g_effective_start_date AND g_effective_end_date) AND

Line 5146: event_effec_date := ben_ext_person.g_pay_proc_evt_tab(i).effective_date;

5142: for i in 1..ben_ext_person.g_pay_proc_evt_tab.COUNT
5143: loop
5144: debug('eff_date('||i||'):'||ben_ext_person.g_pay_proc_evt_tab(i).effective_date,28);
5145: debug('act_date('||i||'):'||ben_ext_person.g_pay_proc_evt_tab(i).actual_date,28);
5146: event_effec_date := ben_ext_person.g_pay_proc_evt_tab(i).effective_date;
5147: event_act_date := ben_ext_person.g_pay_proc_evt_tab(i).actual_date;
5148: if( g_min_eff_date_exists = 'N' AND
5149: (( (event_effec_date between g_effective_start_date AND g_effective_end_date) AND
5150: event_act_date <= g_effective_end_date

Line 5147: event_act_date := ben_ext_person.g_pay_proc_evt_tab(i).actual_date;

5143: loop
5144: debug('eff_date('||i||'):'||ben_ext_person.g_pay_proc_evt_tab(i).effective_date,28);
5145: debug('act_date('||i||'):'||ben_ext_person.g_pay_proc_evt_tab(i).actual_date,28);
5146: event_effec_date := ben_ext_person.g_pay_proc_evt_tab(i).effective_date;
5147: event_act_date := ben_ext_person.g_pay_proc_evt_tab(i).actual_date;
5148: if( g_min_eff_date_exists = 'N' AND
5149: (( (event_effec_date between g_effective_start_date AND g_effective_end_date) AND
5150: event_act_date <= g_effective_end_date
5151: ) OR

Line 5223: l_chg_type := ben_ext_person.g_chg_update_type;

5219: l_return := 'N';
5220: END IF;
5221:
5222: -- reject all purge events on element entries
5223: l_chg_type := ben_ext_person.g_chg_update_type;
5224: l_chg_table := ben_ext_person.g_chg_pay_table;
5225: l_chg_date := ben_ext_person.g_chg_eff_dt;
5226:
5227: IF l_chg_table = 'PAY_ELEMENT_ENTRIES_F'

Line 5224: l_chg_table := ben_ext_person.g_chg_pay_table;

5220: END IF;
5221:
5222: -- reject all purge events on element entries
5223: l_chg_type := ben_ext_person.g_chg_update_type;
5224: l_chg_table := ben_ext_person.g_chg_pay_table;
5225: l_chg_date := ben_ext_person.g_chg_eff_dt;
5226:
5227: IF l_chg_table = 'PAY_ELEMENT_ENTRIES_F'
5228: AND l_chg_type = 'P'

Line 5225: l_chg_date := ben_ext_person.g_chg_eff_dt;

5221:
5222: -- reject all purge events on element entries
5223: l_chg_type := ben_ext_person.g_chg_update_type;
5224: l_chg_table := ben_ext_person.g_chg_pay_table;
5225: l_chg_date := ben_ext_person.g_chg_eff_dt;
5226:
5227: IF l_chg_table = 'PAY_ELEMENT_ENTRIES_F'
5228: AND l_chg_type = 'P'
5229: THEN

Line 5567: debug('ERROR: Future Claim Date: '||ben_ext_person.g_chg_surrogate_key);

5563:
5564:
5565: IF p_claim_date < p_assg_start_date THEN
5566: -- claim date is before the start date of the person
5567: debug('ERROR: Future Claim Date: '||ben_ext_person.g_chg_surrogate_key);
5568: l_temp := PQP_GB_PSI_FUNCTIONS.raise_extract_error
5569: (p_error_number => 94513
5570: ,p_error_text => 'BEN_94513_EARLY_CLAIM_DATE'
5571: ,p_token1 => p_claim_date

Line 5584: debug('ERROR: Future Claim Date: '||ben_ext_person.g_chg_surrogate_key);

5580: END IF; --IF p_claim_date > PQP_GB_PSI_FUNCTIONS.g_effective_end_date THEN
5581:
5582: IF p_claim_date > PQP_GB_PSI_FUNCTIONS.g_effective_end_date THEN
5583:
5584: debug('ERROR: Future Claim Date: '||ben_ext_person.g_chg_surrogate_key);
5585: l_temp := PQP_GB_PSI_FUNCTIONS.raise_extract_error
5586: (p_error_number => 94512
5587: ,p_error_text => 'BEN_94512_FUTURE_CLAIM_DATE'
5588: ,p_token1 => p_claim_date

Line 6017: ,p_effective_date => ben_ext_person.g_effective_date

6013:
6014: -- 3) now find and add retro payments which were earned in this month
6015: FOR l_retro_run_results IN csr_get_retro_run_value
6016: (p_assignment_action_id => l_retro_asg_act_id
6017: ,p_effective_date => ben_ext_person.g_effective_date
6018: )
6019: LOOP
6020: debug('input_value_id : '|| l_retro_run_results.input_value_id,60);
6021: debug('result_value : '|| l_retro_run_results.result_value);

Line 6339: debug('ben_ext_person.g_effective_date : ' || ben_ext_person.g_effective_date );

6335: debug('ELEMENT_ENTRY_ID : '||l_run_results_dtls.element_entry_id, 30);
6336:
6337: debug('l_run_results_dtls.run_result_id : ' || l_run_results_dtls.run_result_id);
6338: debug('l_retro_asg_act_id : ' || l_retro_asg_act_id );
6339: debug('ben_ext_person.g_effective_date : ' || ben_ext_person.g_effective_date );
6340:
6341: -- fetch retro elements using this main elements run_result_id
6342: -- For bug 8652303, Added paramater p_ele_enry_id
6343: OPEN csr_retro_ele

Line 6347: ,p_effective_date => ben_ext_person.g_effective_date -- p_date_earned

6343: OPEN csr_retro_ele
6344: (p_assignment_id => p_assignment_id
6345: ,p_source_id => l_run_results_dtls.run_result_id
6346: ,p_source_asg_action_id => l_retro_asg_act_id
6347: ,p_effective_date => ben_ext_person.g_effective_date -- p_date_earned
6348: ,p_ele_entry_id => l_run_results_dtls.element_entry_id
6349: );
6350: LOOP -- loop thru all the retro elements returned
6351: FETCH csr_retro_ele INTO l_retro_ele;

Line 6397: ,p_effective_end_date => ben_ext_person.g_effective_date -- End date

6393: debug('Entered in ELSE PART IF l_asg_act_id IS NOT NULL');
6394: debug('p_element_entry_id : '||p_element_entry_id, 40);
6395:
6396: OPEN csr_retro_ele_check(p_assignment_id => p_assignment_id
6397: ,p_effective_end_date => ben_ext_person.g_effective_date -- End date
6398: ,p_effective_start_date => p_date_earned -- p_date_earned
6399: ,p_ele_entry_id => p_element_entry_id
6400: );
6401:

Line 6696: l_index := ben_ext_person.g_chg_pay_evt_index;

6692: PQP_GB_PSI_ALL_ELEMENT_ENTRIES
6693: -- PQP_GB_PSI_SAL_GRADE
6694: PQP_GB_PSI_EMP_TERMINATIONS - yes
6695: */
6696: l_index := ben_ext_person.g_chg_pay_evt_index;
6697:
6698: debug('l_index :'|| l_index,20);
6699:
6700: l_chg_type := g_pay_proc_evt_tab(l_index).update_type;

Line 6710: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;

6706: l_chg_date := g_pay_proc_evt_tab(l_index).effective_date;
6707: debug('l_chg_date : ' || l_chg_date);
6708: l_chg_column_name := g_pay_proc_evt_tab(l_index).column_name;
6709: debug('l_chg_column_name : ' || l_chg_column_name);
6710: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;
6711: debug('l_chg_surrogate_key : ' || l_chg_surrogate_key);
6712:
6713:
6714:

Line 6985: l_index := ben_ext_person.g_chg_pay_evt_index;

6981: debug_exit(l_proc);
6982: RETURN 'Y';
6983: END IF;
6984:
6985: l_index := ben_ext_person.g_chg_pay_evt_index;
6986: LOOP
6987: l_chg_column_name := g_pay_proc_evt_tab(l_index).column_name;
6988: l_chg_table_id := g_pay_proc_evt_tab(l_index).dated_table_id;
6989: l_chg_date := g_pay_proc_evt_tab(l_index).effective_date;

Line 7069: l_chg_column_name := ben_ext_person.g_chg_pay_column;

7065: l_chg_table VARCHAR2(30);
7066: l_assignment_status_type_id NUMBER;
7067: BEGIN
7068: debug_enter(l_proc);
7069: l_chg_column_name := ben_ext_person.g_chg_pay_column;
7070: l_chg_table := ben_ext_person.g_chg_pay_table;
7071:
7072: -- check for changes on assignment status
7073: IF (l_chg_table = 'PER_ALL_ASSIGNMENTS_F'

Line 7070: l_chg_table := ben_ext_person.g_chg_pay_table;

7066: l_assignment_status_type_id NUMBER;
7067: BEGIN
7068: debug_enter(l_proc);
7069: l_chg_column_name := ben_ext_person.g_chg_pay_column;
7070: l_chg_table := ben_ext_person.g_chg_pay_table;
7071:
7072: -- check for changes on assignment status
7073: IF (l_chg_table = 'PER_ALL_ASSIGNMENTS_F'
7074: AND l_chg_column_name = 'ASSIGNMENT_STATUS_TYPE_ID') THEN

Line 7107: l_index := ben_ext_person.g_chg_pay_evt_index;

7103:
7104: BEGIN
7105: debug_enter(l_proc);
7106:
7107: l_index := ben_ext_person.g_chg_pay_evt_index;
7108: LOOP
7109: l_chg_column_name := g_pay_proc_evt_tab(l_index).column_name;
7110: l_chg_table_id := g_pay_proc_evt_tab(l_index).dated_table_id;
7111: l_chg_table := get_dated_table_name(l_chg_table_id);

Line 7218: l_index := ben_ext_person.g_chg_pay_evt_index;

7214:
7215: -- reset g_sal_chg_event_exists
7216: g_sal_chg_event_exists := 'N';
7217:
7218: l_index := ben_ext_person.g_chg_pay_evt_index;
7219: LOOP
7220: l_chg_type := g_pay_proc_evt_tab(l_index).update_type;
7221: l_chg_table_id := g_pay_proc_evt_tab(l_index).dated_table_id;
7222: l_chg_table := get_dated_table_name(l_chg_table_id);

Line 7324: l_chg_type := ben_ext_person.g_chg_update_type;

7320: l_ele_end_date DATE;
7321:
7322: BEGIN
7323: debug_enter(l_proc);
7324: l_chg_type := ben_ext_person.g_chg_update_type;
7325: l_chg_table := ben_ext_person.g_chg_pay_table;
7326: debug('l_chg_table: '||l_chg_table||' l_chg_type: '||l_chg_type);
7327:
7328: IF l_chg_table = 'PAY_ELEMENT_ENTRIES_F'

Line 7325: l_chg_table := ben_ext_person.g_chg_pay_table;

7321:
7322: BEGIN
7323: debug_enter(l_proc);
7324: l_chg_type := ben_ext_person.g_chg_update_type;
7325: l_chg_table := ben_ext_person.g_chg_pay_table;
7326: debug('l_chg_table: '||l_chg_table||' l_chg_type: '||l_chg_type);
7327:
7328: IF l_chg_table = 'PAY_ELEMENT_ENTRIES_F'
7329: AND l_chg_type = 'E'

Line 7332: OPEN csr_get_ele_end_date(ben_ext_person.g_chg_surrogate_key);

7328: IF l_chg_table = 'PAY_ELEMENT_ENTRIES_F'
7329: AND l_chg_type = 'E'
7330: THEN
7331: --Bug 7611963: Chk is ele end date is still valid
7332: OPEN csr_get_ele_end_date(ben_ext_person.g_chg_surrogate_key);
7333: FETCH csr_get_ele_end_date INTO l_ele_end_date;
7334: CLOSE csr_get_ele_end_date;
7335:
7336: debug('l_ele_end_date:'||l_ele_end_date);

Line 7504: l_index := ben_ext_person.g_chg_pay_evt_index;

7500: BEGIN
7501: debug_enter(l_proc);
7502: p_end_date := NULL;
7503: -- loop till the next event date
7504: l_index := ben_ext_person.g_chg_pay_evt_index;
7505: LOOP
7506: l_update_type := g_pay_proc_evt_tab(l_index).update_type;
7507: l_chg_table_id := g_pay_proc_evt_tab(l_index).dated_table_id;
7508: l_chg_table := get_dated_table_name(l_chg_table_id);

Line 7623: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;

7619:
7620: ELSIF (l_chg_table = 'PER_ASSIGNMENT_BUDGET_VALUES_F'
7621: AND (l_chg_column_name = 'VALUE' OR l_update_type = 'I' )) THEN
7622:
7623: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;
7624: debug('l_chg_surrogate_key: '||l_chg_surrogate_key);
7625: OPEN csr_is_fte_abv
7626: (
7627: p_assignment_budget_value_id => l_chg_surrogate_key

Line 7745: l_next_pay_event_rec ben_ext_person.t_detailed_output_tab_rec;

7741:
7742:
7743: l_proc varchar2(72) := g_proc_name||'.is_curr_sal_change_event';
7744: l_next_event_date DATE;
7745: l_next_pay_event_rec ben_ext_person.t_detailed_output_tab_rec;
7746: l_chg_column_name VARCHAR2(30);
7747: l_chg_table VARCHAR2(30);
7748: l_chg_type VARCHAR2(10);
7749: l_chg_date DATE;

Line 7774: l_chg_type := ben_ext_person.g_chg_update_type;

7770:
7771: BEGIN
7772: debug_enter(l_proc);
7773:
7774: l_chg_type := ben_ext_person.g_chg_update_type;
7775: l_chg_table := ben_ext_person.g_chg_pay_table;
7776: l_chg_date := ben_ext_person.g_chg_eff_dt;
7777: l_chg_column_name := ben_ext_person.g_chg_pay_column;
7778:

Line 7775: l_chg_table := ben_ext_person.g_chg_pay_table;

7771: BEGIN
7772: debug_enter(l_proc);
7773:
7774: l_chg_type := ben_ext_person.g_chg_update_type;
7775: l_chg_table := ben_ext_person.g_chg_pay_table;
7776: l_chg_date := ben_ext_person.g_chg_eff_dt;
7777: l_chg_column_name := ben_ext_person.g_chg_pay_column;
7778:
7779: debug('l_chg_table: '||l_chg_table);

Line 7776: l_chg_date := ben_ext_person.g_chg_eff_dt;

7772: debug_enter(l_proc);
7773:
7774: l_chg_type := ben_ext_person.g_chg_update_type;
7775: l_chg_table := ben_ext_person.g_chg_pay_table;
7776: l_chg_date := ben_ext_person.g_chg_eff_dt;
7777: l_chg_column_name := ben_ext_person.g_chg_pay_column;
7778:
7779: debug('l_chg_table: '||l_chg_table);
7780: debug('l_chg_date: '||l_chg_date);

Line 7777: l_chg_column_name := ben_ext_person.g_chg_pay_column;

7773:
7774: l_chg_type := ben_ext_person.g_chg_update_type;
7775: l_chg_table := ben_ext_person.g_chg_pay_table;
7776: l_chg_date := ben_ext_person.g_chg_eff_dt;
7777: l_chg_column_name := ben_ext_person.g_chg_pay_column;
7778:
7779: debug('l_chg_table: '||l_chg_table);
7780: debug('l_chg_date: '||l_chg_date);
7781: debug('l_chg_type: '||l_chg_type);

Line 7819: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;

7815:
7816: IF (l_chg_table = 'PER_ASSIGNMENT_BUDGET_VALUES_F'
7817: AND (l_chg_column_name = 'VALUE' OR l_chg_type = 'I' )) THEN
7818:
7819: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;
7820: debug('l_chg_surrogate_key: '||l_chg_surrogate_key);
7821: OPEN csr_is_fte_abv
7822: (
7823: p_assignment_budget_value_id => l_chg_surrogate_key

Line 7856: l_change_value := ben_ext_person.g_pay_proc_evt_tab(ben_ext_person.g_chg_pay_evt_index).change_values;

7852: IF(l_chg_table= 'PER_ALL_ASSIGNMENTS_F'
7853: AND l_chg_column_name= 'PEOPLE_GROUP_ID')
7854: THEN
7855: --Compare the new and old value of uni grade segment
7856: l_change_value := ben_ext_person.g_pay_proc_evt_tab(ben_ext_person.g_chg_pay_evt_index).change_values;
7857: l_old_value := ben_ext_person.g_pay_proc_evt_tab(ben_ext_person.g_chg_pay_evt_index).old_value;
7858: l_new_value := ben_ext_person.g_pay_proc_evt_tab(ben_ext_person.g_chg_pay_evt_index).new_value;
7859:
7860: debug('l_chg_type: '||l_chg_type);

Line 7857: l_old_value := ben_ext_person.g_pay_proc_evt_tab(ben_ext_person.g_chg_pay_evt_index).old_value;

7853: AND l_chg_column_name= 'PEOPLE_GROUP_ID')
7854: THEN
7855: --Compare the new and old value of uni grade segment
7856: l_change_value := ben_ext_person.g_pay_proc_evt_tab(ben_ext_person.g_chg_pay_evt_index).change_values;
7857: l_old_value := ben_ext_person.g_pay_proc_evt_tab(ben_ext_person.g_chg_pay_evt_index).old_value;
7858: l_new_value := ben_ext_person.g_pay_proc_evt_tab(ben_ext_person.g_chg_pay_evt_index).new_value;
7859:
7860: debug('l_chg_type: '||l_chg_type);
7861: debug('l_change_value: '||l_change_value);

Line 7858: l_new_value := ben_ext_person.g_pay_proc_evt_tab(ben_ext_person.g_chg_pay_evt_index).new_value;

7854: THEN
7855: --Compare the new and old value of uni grade segment
7856: l_change_value := ben_ext_person.g_pay_proc_evt_tab(ben_ext_person.g_chg_pay_evt_index).change_values;
7857: l_old_value := ben_ext_person.g_pay_proc_evt_tab(ben_ext_person.g_chg_pay_evt_index).old_value;
7858: l_new_value := ben_ext_person.g_pay_proc_evt_tab(ben_ext_person.g_chg_pay_evt_index).new_value;
7859:
7860: debug('l_chg_type: '||l_chg_type);
7861: debug('l_change_value: '||l_change_value);
7862: debug('l_old_value: '||l_old_value);

Line 8464: g_pay_proc_evt_tab := ben_ext_person.g_pay_proc_evt_tab;

8460: BEGIN
8461: debug_enter(l_proc);
8462:
8463: -- reset assignment level globals
8464: g_pay_proc_evt_tab := ben_ext_person.g_pay_proc_evt_tab;
8465: g_salary_ended := 'N';
8466: g_salary_started := 'Y';
8467: g_salary_ele_end_date := c_highest_date;
8468: g_non_salary_ele_end_date := c_highest_date;