[Home] [Help]
1127: -- populate absence type collection
1128: IF g_tab_event_map_cv(i).pcv_information7 IS NOT NULL
1129: THEN
1130: g_tab_abs_types(i) :=
1131: fnd_number.canonical_to_number(g_tab_event_map_cv(i).pcv_information7);
1132: ELSE
1133: l_meaning :=
1134: hr_general.decode_lookup(
1135: p_lookup_type => 'PQP_PENSERVER_EVENT_DESC'
1157: -- populate assignment status collection
1158: IF g_tab_event_map_cv(i).pcv_information8 IS NOT NULL
1159: THEN
1160: g_tab_asg_status(i) :=
1161: fnd_number.canonical_to_number(g_tab_event_map_cv(i).pcv_information8);
1162: ELSE
1163: l_meaning :=
1164: hr_general.decode_lookup(
1165: p_lookup_type => 'PQP_PENSERVER_EVENT_DESC'
2025:
2026: WHILE i IS NOT NULL
2027: LOOP
2028: l_element_type_id :=
2029: fnd_number.canonical_to_number(p_tab_pen_sch_map_cv(i).pcv_information1);
2030:
2031: IF g_debug
2032: THEN
2033: l_proc_step := 20;
2547:
2548: WHILE i IS NOT NULL
2549: LOOP
2550: l_element_type_id :=
2551: fnd_number.canonical_to_number(g_tab_pen_sch_map_cv(i).pcv_information1);
2552: l_input_value_id :=
2553: get_input_value_id(
2554: p_element_type_id => l_element_type_id
2555: ,p_effective_date => g_effective_date
3575:
3576: WHILE i IS NOT NULL AND(g_opt_in = 'Y' OR g_opt_out = 'Y')
3577: LOOP
3578: l_element_type_id :=
3579: fnd_number.canonical_to_number(g_tab_pen_sch_map_cv(i).pcv_information1);
3580: l_input_value_id :=
3581: g_tab_pen_ele_ids(l_element_type_id).input_value_id;
3582:
3583: IF g_debug
4068:
4069: WHILE i IS NOT NULL
4070: LOOP
4071: l_asg_status_type_id :=
4072: fnd_number.canonical_to_number(g_tab_asg_status(i));
4073:
4074: IF l_rec_asg_status.curr_status_type_id = l_asg_status_type_id
4075: THEN
4076: IF g_debug
4100:
4101: WHILE j IS NOT NULL
4102: LOOP
4103: l_prev_asg_status_type_id :=
4104: fnd_number.canonical_to_number(g_tab_asg_status(j));
4105:
4106: IF l_rec_asg_status.prev_status_type_id =
4107: l_prev_asg_status_type_id
4108: THEN
5543: -- Get pension category
5544: i := g_tab_pen_sch_map_cv.FIRST;
5545: WHILE i IS NOT NULL
5546: LOOP
5547: IF fnd_number.canonical_to_number(g_tab_pen_sch_map_cv(i).pcv_information1) =
5548: l_rec_ele_ent_info.element_type_id
5549: THEN
5550: l_pension_category :=
5551: g_tab_pen_sch_map_cv(i).pcv_information2;
5656: i := g_tab_pen_sch_map_cv.FIRST;
5657:
5658: WHILE i IS NOT NULL
5659: LOOP
5660: IF fnd_number.canonical_to_number(g_tab_pen_sch_map_cv(i).pcv_information1) =
5661: l_rec_ele_ent_info.element_type_id
5662: THEN
5663: l_pension_category :=
5664: g_tab_pen_sch_map_cv(i).pcv_information2;
5767: i := g_tab_pen_sch_map_cv.FIRST;
5768:
5769: WHILE i IS NOT NULL
5770: LOOP
5771: IF fnd_number.canonical_to_number(g_tab_pen_sch_map_cv(i).pcv_information1) =
5772: l_rec_ele_ent_info.element_type_id
5773: THEN
5774: l_pension_category :=
5775: g_tab_pen_sch_map_cv(i).pcv_information2;
6157: THEN
6158: --For Bug 7034476: End
6159:
6160: l_absence_attendance_id :=
6161: fnd_number.canonical_to_number(l_tab_pay_proc_evnts(g_event_counter).surrogate_key);
6162:
6163: IF g_debug
6164: THEN
6165: l_proc_step := 50;
6181: ELSIF l_table_name = 'PQP_GAP_DURATION_SUMMARY'
6182: THEN
6183: -- This should be a sickness/maternity transition
6184: l_gap_duration_summary_id :=
6185: fnd_number.canonical_to_number(l_tab_pay_proc_evnts(g_event_counter).surrogate_key);
6186:
6187: IF g_debug
6188: THEN
6189: l_proc_step := 60;
6205: ELSIF l_event_group_name = 'PQP_GB_PSI_SER_GAP_TRANSITION'
6206: THEN
6207: -- This should be a sickness/maternity transition
6208: l_gap_duration_summary_id :=
6209: fnd_number.canonical_to_number(l_tab_pay_proc_evnts(g_event_counter).surrogate_key);
6210:
6211: IF g_debug
6212: THEN
6213: l_proc_step := 60;
6237: -- This is a new hire event (includes rehires)
6238: -- Evaluate new joiners
6239: -- We are only interested in primary assignments
6240: l_assignment_id :=
6241: fnd_number.canonical_to_number(l_tab_pay_proc_evnts(g_event_counter).surrogate_key);
6242:
6243: IF g_debug
6244: THEN
6245: l_proc_step := 60;
6302: IF l_table_name = 'PER_PERIODS_OF_SERVICE'
6303: THEN
6304: --115.21 5945283
6305: /* l_period_of_service_id :=
6306: fnd_number.canonical_to_number(
6307: l_tab_pay_proc_evnts(g_event_counter).surrogate_key
6308: );*/
6309:
6310: IF g_debug
6447: DEBUG(l_proc_name, l_proc_step);
6448: END IF;
6449:
6450: l_curr_status_type_id :=
6451: fnd_number.canonical_to_number(l_tab_pay_proc_evnts(g_event_counter).new_value);
6452: l_prev_status_type_id :=
6453: fnd_number.canonical_to_number(l_tab_pay_proc_evnts(g_event_counter).old_value);
6454: l_include_flag := eval_asg_status_event(
6455: p_assignment_id => p_assignment_id
6449:
6450: l_curr_status_type_id :=
6451: fnd_number.canonical_to_number(l_tab_pay_proc_evnts(g_event_counter).new_value);
6452: l_prev_status_type_id :=
6453: fnd_number.canonical_to_number(l_tab_pay_proc_evnts(g_event_counter).old_value);
6454: l_include_flag := eval_asg_status_event(
6455: p_assignment_id => p_assignment_id
6456: ,p_curr_status_type_id => l_curr_status_type_id
6457: ,p_prev_status_type_id => l_prev_status_type_id
6552: DEBUG(l_proc_name, l_proc_step);
6553: END IF;
6554:
6555: l_curr_status_type_id :=
6556: fnd_number.canonical_to_number(l_tab_pay_proc_evnts(g_event_counter).new_value);
6557: l_prev_status_type_id :=
6558: fnd_number.canonical_to_number(l_tab_pay_proc_evnts(g_event_counter).old_value);
6559: l_include_flag :=
6560: eval_asg_status_event(
6554:
6555: l_curr_status_type_id :=
6556: fnd_number.canonical_to_number(l_tab_pay_proc_evnts(g_event_counter).new_value);
6557: l_prev_status_type_id :=
6558: fnd_number.canonical_to_number(l_tab_pay_proc_evnts(g_event_counter).old_value);
6559: l_include_flag :=
6560: eval_asg_status_event(
6561: p_assignment_id => p_assignment_id
6562: ,p_curr_status_type_id => l_curr_status_type_id
6580: DEBUG(l_proc_name, l_proc_step);
6581: END IF;
6582:
6583: l_surrogate_key :=
6584: fnd_number.canonical_to_number(l_tab_pay_proc_evnts(g_event_counter).surrogate_key);
6585: l_include_flag :=
6586: eval_pension_event(
6587: p_assignment_id => p_assignment_id
6588: ,p_table_name => l_table_name