[Home] [Help]
1121: -- populate absence type collection
1122: IF g_tab_event_map_cv(i).pcv_information7 IS NOT NULL
1123: THEN
1124: g_tab_abs_types(i) :=
1125: fnd_number.canonical_to_number(g_tab_event_map_cv(i).pcv_information7);
1126: ELSE
1127: l_meaning :=
1128: hr_general.decode_lookup(
1129: p_lookup_type => 'PQP_PENSERVER_EVENT_DESC'
1151: -- populate assignment status collection
1152: IF g_tab_event_map_cv(i).pcv_information8 IS NOT NULL
1153: THEN
1154: g_tab_asg_status(i) :=
1155: fnd_number.canonical_to_number(g_tab_event_map_cv(i).pcv_information8);
1156: ELSE
1157: l_meaning :=
1158: hr_general.decode_lookup(
1159: p_lookup_type => 'PQP_PENSERVER_EVENT_DESC'
2007:
2008: WHILE i IS NOT NULL
2009: LOOP
2010: l_element_type_id :=
2011: fnd_number.canonical_to_number(p_tab_pen_sch_map_cv(i).pcv_information1);
2012:
2013: IF g_debug
2014: THEN
2015: l_proc_step := 20;
2529:
2530: WHILE i IS NOT NULL
2531: LOOP
2532: l_element_type_id :=
2533: fnd_number.canonical_to_number(g_tab_pen_sch_map_cv(i).pcv_information1);
2534: l_input_value_id :=
2535: get_input_value_id(
2536: p_element_type_id => l_element_type_id
2537: ,p_effective_date => g_effective_date
3521:
3522: WHILE i IS NOT NULL AND(g_opt_in = 'Y' OR g_opt_out = 'Y')
3523: LOOP
3524: l_element_type_id :=
3525: fnd_number.canonical_to_number(g_tab_pen_sch_map_cv(i).pcv_information1);
3526: l_input_value_id :=
3527: g_tab_pen_ele_ids(l_element_type_id).input_value_id;
3528:
3529: IF g_debug
4014:
4015: WHILE i IS NOT NULL
4016: LOOP
4017: l_asg_status_type_id :=
4018: fnd_number.canonical_to_number(g_tab_asg_status(i));
4019:
4020: IF l_rec_asg_status.curr_status_type_id = l_asg_status_type_id
4021: THEN
4022: IF g_debug
4046:
4047: WHILE j IS NOT NULL
4048: LOOP
4049: l_prev_asg_status_type_id :=
4050: fnd_number.canonical_to_number(g_tab_asg_status(j));
4051:
4052: IF l_rec_asg_status.prev_status_type_id =
4053: l_prev_asg_status_type_id
4054: THEN
5481: -- Get pension category
5482: i := g_tab_pen_sch_map_cv.FIRST;
5483: WHILE i IS NOT NULL
5484: LOOP
5485: IF fnd_number.canonical_to_number(g_tab_pen_sch_map_cv(i).pcv_information1) =
5486: l_rec_ele_ent_info.element_type_id
5487: THEN
5488: l_pension_category :=
5489: g_tab_pen_sch_map_cv(i).pcv_information2;
5594: i := g_tab_pen_sch_map_cv.FIRST;
5595:
5596: WHILE i IS NOT NULL
5597: LOOP
5598: IF fnd_number.canonical_to_number(g_tab_pen_sch_map_cv(i).pcv_information1) =
5599: l_rec_ele_ent_info.element_type_id
5600: THEN
5601: l_pension_category :=
5602: g_tab_pen_sch_map_cv(i).pcv_information2;
5705: i := g_tab_pen_sch_map_cv.FIRST;
5706:
5707: WHILE i IS NOT NULL
5708: LOOP
5709: IF fnd_number.canonical_to_number(g_tab_pen_sch_map_cv(i).pcv_information1) =
5710: l_rec_ele_ent_info.element_type_id
5711: THEN
5712: l_pension_category :=
5713: g_tab_pen_sch_map_cv(i).pcv_information2;
6095: THEN
6096: --For Bug 7034476: End
6097:
6098: l_absence_attendance_id :=
6099: fnd_number.canonical_to_number(l_tab_pay_proc_evnts(g_event_counter).surrogate_key);
6100:
6101: IF g_debug
6102: THEN
6103: l_proc_step := 50;
6119: ELSIF l_table_name = 'PQP_GAP_DURATION_SUMMARY'
6120: THEN
6121: -- This should be a sickness/maternity transition
6122: l_gap_duration_summary_id :=
6123: fnd_number.canonical_to_number(l_tab_pay_proc_evnts(g_event_counter).surrogate_key);
6124:
6125: IF g_debug
6126: THEN
6127: l_proc_step := 60;
6143: ELSIF l_event_group_name = 'PQP_GB_PSI_SER_GAP_TRANSITION'
6144: THEN
6145: -- This should be a sickness/maternity transition
6146: l_gap_duration_summary_id :=
6147: fnd_number.canonical_to_number(l_tab_pay_proc_evnts(g_event_counter).surrogate_key);
6148:
6149: IF g_debug
6150: THEN
6151: l_proc_step := 60;
6175: -- This is a new hire event (includes rehires)
6176: -- Evaluate new joiners
6177: -- We are only interested in primary assignments
6178: l_assignment_id :=
6179: fnd_number.canonical_to_number(l_tab_pay_proc_evnts(g_event_counter).surrogate_key);
6180:
6181: IF g_debug
6182: THEN
6183: l_proc_step := 60;
6240: IF l_table_name = 'PER_PERIODS_OF_SERVICE'
6241: THEN
6242: --115.21 5945283
6243: /* l_period_of_service_id :=
6244: fnd_number.canonical_to_number(
6245: l_tab_pay_proc_evnts(g_event_counter).surrogate_key
6246: );*/
6247:
6248: IF g_debug
6367: DEBUG(l_proc_name, l_proc_step);
6368: END IF;
6369:
6370: l_curr_status_type_id :=
6371: fnd_number.canonical_to_number(l_tab_pay_proc_evnts(g_event_counter).new_value);
6372: l_prev_status_type_id :=
6373: fnd_number.canonical_to_number(l_tab_pay_proc_evnts(g_event_counter).old_value);
6374: l_include_flag := eval_asg_status_event(
6375: p_assignment_id => p_assignment_id
6369:
6370: l_curr_status_type_id :=
6371: fnd_number.canonical_to_number(l_tab_pay_proc_evnts(g_event_counter).new_value);
6372: l_prev_status_type_id :=
6373: fnd_number.canonical_to_number(l_tab_pay_proc_evnts(g_event_counter).old_value);
6374: l_include_flag := eval_asg_status_event(
6375: p_assignment_id => p_assignment_id
6376: ,p_curr_status_type_id => l_curr_status_type_id
6377: ,p_prev_status_type_id => l_prev_status_type_id
6472: DEBUG(l_proc_name, l_proc_step);
6473: END IF;
6474:
6475: l_curr_status_type_id :=
6476: fnd_number.canonical_to_number(l_tab_pay_proc_evnts(g_event_counter).new_value);
6477: l_prev_status_type_id :=
6478: fnd_number.canonical_to_number(l_tab_pay_proc_evnts(g_event_counter).old_value);
6479: l_include_flag :=
6480: eval_asg_status_event(
6474:
6475: l_curr_status_type_id :=
6476: fnd_number.canonical_to_number(l_tab_pay_proc_evnts(g_event_counter).new_value);
6477: l_prev_status_type_id :=
6478: fnd_number.canonical_to_number(l_tab_pay_proc_evnts(g_event_counter).old_value);
6479: l_include_flag :=
6480: eval_asg_status_event(
6481: p_assignment_id => p_assignment_id
6482: ,p_curr_status_type_id => l_curr_status_type_id
6500: DEBUG(l_proc_name, l_proc_step);
6501: END IF;
6502:
6503: l_surrogate_key :=
6504: fnd_number.canonical_to_number(l_tab_pay_proc_evnts(g_event_counter).surrogate_key);
6505: l_include_flag :=
6506: eval_pension_event(
6507: p_assignment_id => p_assignment_id
6508: ,p_table_name => l_table_name