[Home] [Help]
184: l_cannot_cancel_sevpay boolean;
185: l_interv_on_table boolean;
186: l_interv_on_eff_date boolean;
187: l_hist_data_as_of_date ghr_pa_history%rowtype;
188: l_session_var ghr_history_api.g_session_var_type;
189: l_agency_ei_data ghr_pa_request_extra_info%rowtype;
190: l_imm_asg_sf52 ghr_api.asg_sf52_type;
191: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
192: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
283: l_sf52_data_rec := p_sf52_data;
284: --
285: --
286: -- reinitialise session variables
287: ghr_history_api.reinit_g_session_var;
288: -- set values of session variables
289:
290: l_session_var.pa_request_id := p_sf52_data.pa_request_id;
291: l_session_var.noa_id := p_sf52_data.second_noa_id;
297: l_session_var.program_name := 'sf50';
298: l_session_var.assignment_id := p_sf52_data.employee_assignment_id;
299: l_session_var.altered_pa_request_id := p_sf52_data.altered_pa_request_id;
300: l_session_var.noa_id_correct := p_sf52_data.second_noa_id;
301: ghr_history_api.set_g_session_var(l_session_var);
302:
303: ghr_process_Sf52.Fetch_extra_info(
304: p_pa_request_id => p_sf52_data.pa_request_id,
305: p_noa_id => p_sf52_data.second_noa_id,
502: INTO l_hist_rec
503: FROM ghr_pa_history
504: WHERE pa_request_id = p_sf52_data.altered_pa_request_id
505: AND information5 = 'GHR_US_PER_SEPARATE_RETIRE'
506: AND table_name = ghr_history_api.g_peopei_table
507: AND nature_of_action_id = (select nature_of_action_id from ghr_nature_of_actions where
508: code = '352');
509:
510:
508: code = '352');
509:
510:
511:
512: ghr_history_api.fetch_history_info(
513: p_table_name => ghr_history_api.g_peopei_table,
514: p_hist_data => l_hist_pre,
515: p_pa_history_id => l_hist_rec.pa_history_id,
516: p_table_pk_id => l_hist_rec.information1,
509:
510:
511:
512: ghr_history_api.fetch_history_info(
513: p_table_name => ghr_history_api.g_peopei_table,
514: p_hist_data => l_hist_pre,
515: p_pa_history_id => l_hist_rec.pa_history_id,
516: p_table_pk_id => l_hist_rec.information1,
517: p_person_id => p_sf52_data.person_id,
527: fetch c_follow_rec into l_buf;
528: if c_follow_rec%NOTFOUND then
529: hr_utility.set_location('no following records. Deleting appl table. '|| l_proc,915);
530: delete_appl_row(
531: p_table_name => ghr_history_api.g_peopei_table,
532: p_table_pk_id => l_hist_rec.information1,
533: p_dt_mode => null,
534: p_date_effective => l_hist_rec.effective_date);
535: end if;
564:
565: end if;
566:
567: -- Bug#2082535
568: Open c_hist_sevpay(p_sf52_data.altered_pa_request_id,ghr_history_api.g_eleent_table);
569: fetch c_hist_sevpay into l_hist_sevpay;
570: if c_hist_sevpay%notfound then
571: -- raise error;
572: close c_hist_sevpay;
602: exit when c_hist%notfound;
603: -- Bug#3780671 Added the Assignment Extra Info condition as
604: -- the EIT "GHR_US_ASG_NTE_DATES" requires the process similar to
605: -- Address table.
606: IF (l_hist.table_name = ghr_history_api.g_addres_table) OR
607: (l_hist.table_name = 'PER_ASSIGNMENT_EXTRA_INFO' and
608: l_hist.information5 = 'GHR_US_ASG_NTE_DATES') THEN
609:
610: SELECT *
614:
615: hr_utility.set_location('Non 352 and Address '||l_hist.table_name,26);
616: -- Bug#3780671 Passed the parameter l_hist.table_name instead of Address table
617: -- to handle PER_ASSIGNMENT_EXTRA_INFO table.
618: ghr_history_api.fetch_history_info(
619: p_table_name => l_hist.table_name,
620: p_hist_data => l_hist_pre,
621: p_pa_history_id => l_hist_rec.pa_history_id,
622: p_table_pk_id => l_hist_rec.information1,
805: -- ---------------------------------------------------------------------------
806:
807: Procedure Cancel_Appt_SF52( p_sf52_data in out nocopy ghr_pa_requests%rowtype) is
808:
809: l_session_var ghr_history_api.g_session_var_type;
810: l_hist_post ghr_pa_history%rowtype;
811: l_business_group_id number;
812: l_u_prh_object_version_number number;
813: l_i_pa_routing_history_id number;
923: from ghr_pa_history pah
924: where person_id = c_person_id and
925: (effective_date > c_eff_date or
926: (effective_date = c_eff_date and pa_request_id is not NULL))
927: and upper(pah.table_name) not in (upper(ghr_history_api.g_addres_table))
928: for update of person_id
929: order by dml_operation desc;
930:
931: --8259229 for address order by information1 and then on dml operation
937: from ghr_pa_history pah
938: where person_id = c_person_id and
939: (effective_date > c_eff_date or
940: (effective_date = c_eff_date and pa_request_id is not NULL))
941: and upper(pah.table_name) in (upper(ghr_history_api.g_addres_table))
942: for update of person_id
943: order by information1 desc,dml_operation desc;
944: --8259229
945:
994: l_sf52_data_rec := p_sf52_data;
995:
996:
997: -- reinitialise session variables
998: ghr_history_api.reinit_g_session_var;
999:
1000: -- set values of session variables
1001: l_session_var.pa_request_id := p_sf52_data.pa_request_id;
1002: l_session_var.noa_id := p_sf52_data.second_noa_id;
1009: l_session_var.altered_pa_request_id := p_sf52_data.altered_pa_request_id;
1010: l_session_var.noa_id_correct := p_sf52_data.second_noa_id;
1011: l_session_var.assignment_id := p_sf52_data.employee_assignment_id;
1012:
1013: ghr_history_api.set_g_session_var(l_session_var);
1014:
1015: ghr_process_Sf52.Fetch_extra_info(
1016: p_pa_request_id => p_sf52_data.pa_request_id,
1017: p_noa_id => p_sf52_data.second_noa_id,
1183: exit when c_hist%notfound;
1184: delete_hist_row( l_hist.row_id);
1185: hr_utility.set_location( 'checking if table needs deleting: ' || l_hist.table_name|| l_proc, 58);
1186: -- Delete all extraInfo table records which were created by the SF52.
1187: if upper(l_hist.table_name) in (upper(ghr_history_api.g_peopei_table),
1188: upper(ghr_history_api.g_posnei_table),
1189: upper(ghr_history_api.g_asgnei_table),
1190: upper(ghr_history_api.g_addres_table),
1191: upper(ghr_history_api.g_perana_table)) then
1184: delete_hist_row( l_hist.row_id);
1185: hr_utility.set_location( 'checking if table needs deleting: ' || l_hist.table_name|| l_proc, 58);
1186: -- Delete all extraInfo table records which were created by the SF52.
1187: if upper(l_hist.table_name) in (upper(ghr_history_api.g_peopei_table),
1188: upper(ghr_history_api.g_posnei_table),
1189: upper(ghr_history_api.g_asgnei_table),
1190: upper(ghr_history_api.g_addres_table),
1191: upper(ghr_history_api.g_perana_table)) then
1192: hr_utility.set_location( 'table_name qualifies: ' || l_hist.table_name|| l_proc, 57);
1185: hr_utility.set_location( 'checking if table needs deleting: ' || l_hist.table_name|| l_proc, 58);
1186: -- Delete all extraInfo table records which were created by the SF52.
1187: if upper(l_hist.table_name) in (upper(ghr_history_api.g_peopei_table),
1188: upper(ghr_history_api.g_posnei_table),
1189: upper(ghr_history_api.g_asgnei_table),
1190: upper(ghr_history_api.g_addres_table),
1191: upper(ghr_history_api.g_perana_table)) then
1192: hr_utility.set_location( 'table_name qualifies: ' || l_hist.table_name|| l_proc, 57);
1193: if l_hist.DML_operation = ghr_history_api.g_ins_operation then
1186: -- Delete all extraInfo table records which were created by the SF52.
1187: if upper(l_hist.table_name) in (upper(ghr_history_api.g_peopei_table),
1188: upper(ghr_history_api.g_posnei_table),
1189: upper(ghr_history_api.g_asgnei_table),
1190: upper(ghr_history_api.g_addres_table),
1191: upper(ghr_history_api.g_perana_table)) then
1192: hr_utility.set_location( 'table_name qualifies: ' || l_hist.table_name|| l_proc, 57);
1193: if l_hist.DML_operation = ghr_history_api.g_ins_operation then
1194: hr_utility.set_location( 'delete appl row table_name: ' || l_hist.table_name|| l_proc, 51);
1187: if upper(l_hist.table_name) in (upper(ghr_history_api.g_peopei_table),
1188: upper(ghr_history_api.g_posnei_table),
1189: upper(ghr_history_api.g_asgnei_table),
1190: upper(ghr_history_api.g_addres_table),
1191: upper(ghr_history_api.g_perana_table)) then
1192: hr_utility.set_location( 'table_name qualifies: ' || l_hist.table_name|| l_proc, 57);
1193: if l_hist.DML_operation = ghr_history_api.g_ins_operation then
1194: hr_utility.set_location( 'delete appl row table_name: ' || l_hist.table_name|| l_proc, 51);
1195: hr_utility.set_location( 'delete appl row information1: ' || l_hist.information1|| l_proc, 52);
1189: upper(ghr_history_api.g_asgnei_table),
1190: upper(ghr_history_api.g_addres_table),
1191: upper(ghr_history_api.g_perana_table)) then
1192: hr_utility.set_location( 'table_name qualifies: ' || l_hist.table_name|| l_proc, 57);
1193: if l_hist.DML_operation = ghr_history_api.g_ins_operation then
1194: hr_utility.set_location( 'delete appl row table_name: ' || l_hist.table_name|| l_proc, 51);
1195: hr_utility.set_location( 'delete appl row information1: ' || l_hist.information1|| l_proc, 52);
1196: hr_utility.set_location( 'delete appl row effective_date: ' || l_hist.effective_date|| l_proc, 53);
1197: delete_appl_row(
1208: delete_hist_row( l_upd_hist.row_id);
1209: END LOOP;
1210: --End BUG # 13334984
1211:
1212: elsif l_hist.DML_operation = ghr_history_api.g_upd_operation then
1213: l_hist_post.information1 := l_hist.information1;
1214: l_hist_post.person_id := l_hist.person_id;
1215: hr_utility.set_location(l_proc || 'l_hist.information1: ' || l_hist.information1, 1200);
1216: hr_utility.set_location(l_proc || 'l_hist.table_name: ' || l_hist.table_name, 1210);
1255: delete_hist_row( l_add_hist.row_id);
1256: hr_utility.set_location( 'checking if table needs deleting: ' || l_add_hist.table_name|| l_proc, 58);
1257: -- Delete all extraInfo table records which were created by the SF52.
1258: hr_utility.set_location( 'table_name qualifies: ' || l_add_hist.table_name|| l_proc, 57);
1259: if l_add_hist.DML_operation = ghr_history_api.g_ins_operation then
1260: hr_utility.set_location( 'delete appl row table_name: ' || l_add_hist.table_name|| l_proc, 51);
1261: hr_utility.set_location( 'delete appl row information1: ' || l_add_hist.information1|| l_proc, 52);
1262: hr_utility.set_location( 'delete appl row effective_date: ' || l_add_hist.effective_date|| l_proc, 53);
1263: delete_appl_row(
1264: p_table_name => l_add_hist.table_name,
1265: p_table_pk_id => l_add_hist.information1,
1266: p_dt_mode => null,
1267: p_date_effective => l_add_hist.effective_date);
1268: elsif l_add_hist.DML_operation = ghr_history_api.g_upd_operation then
1269: l_hist_post.information1 := l_add_hist.information1;
1270: l_hist_post.person_id := l_add_hist.person_id;
1271: hr_utility.set_location(l_proc || 'l_add_hist.information1: ' || l_add_hist.information1, 1200);
1272: hr_utility.set_location(l_proc || 'l_add_hist.table_name: ' || l_add_hist.table_name, 1210);
1465: -- is processed through MTO and it is not yet cancelled
1466: -- Moved the code up as cancelled need not to be considered
1467:
1468: if (l_par.first_noa_code = '352') and (UPPER(SUBSTR(NVL(l_par.request_number,'***'),1,3)) = 'MTO')
1469: and l_par.first_noa_cancel_or_correct <> ghr_history_api.g_cancel then
1470: -- null out end_date for position
1471:
1472:
1473: SELECT name, object_version_number
1498: -- NVL(l_par.first_noa_cancel_or_correct, '***') = 'CORRECT' then"
1499: if l_par.first_noa_cancel_or_correct is null or
1500: NVL(l_par.first_noa_cancel_or_correct, '***') = 'CORRECT'
1501: then
1502: l_par.first_noa_cancel_or_correct := ghr_history_api.g_cancel;
1503: end if;
1504: end if;
1505:
1506: if l_par.second_noa_code is not NULL then
1505:
1506: if l_par.second_noa_code is not NULL then
1507: -- handle dual actions
1508: if l_par.second_noa_cancel_or_correct is null then
1509: l_par.second_noa_cancel_or_correct := ghr_history_api.g_cancel;
1510: end if;
1511:
1512: --6850492 added the condition for dual action correction
1513: -- added for the bug 8250185
1513: -- added for the bug 8250185
1514: if l_par.first_noa_code not in ('001' , '002') and
1515: l_par.second_noa_code is not NULL and
1516: NVL(l_par.second_noa_cancel_or_correct, '***') = 'CORRECT' then
1517: l_par.second_noa_cancel_or_correct := ghr_history_api.g_cancel;
1518: end if;
1519: --8250185
1520: end if;
1521:
1636: l_last_row boolean;
1637: l_cannot_cancel boolean;
1638: l_datetrack_table boolean;
1639: l_datetrack_mode varchar2(30);
1640: l_session_var ghr_history_api.g_session_var_type;
1641: l_result_code varchar2(30);
1642: l_rec_created_flag boolean;
1643: l_del_mode varchar2(30);
1644: l_agency_ei_data ghr_pa_request_extra_info%rowtype;
1800: rowid row_id, table_name,pa_history_id,information5
1801: ,information9, information10
1802: from ghr_pa_history
1803: where pa_request_id = c_pa_request_id
1804: and table_name = ghr_history_api.g_addres_table
1805: and nature_of_action_id = c_noa_id
1806: for update of person_id
1807: order by pa_history_id desc;
1808: --
1904: hr_utility.set_location('Cancel of Ex_EMP conversion',1);
1905: ghr_corr_canc_sf52.cancel_appt_sf52(p_sf52_data);
1906: Else
1907: -- reinitialise session variables
1908: ghr_history_api.reinit_g_session_var;
1909: -- set values of session variables
1910: l_session_var.pa_request_id := p_sf52_data.pa_request_id;
1911: l_session_var.noa_id := p_sf52_data.second_noa_id;
1912: l_session_var.fire_trigger := 'Y';
1916: l_session_var.altered_pa_request_id := p_sf52_data.altered_pa_request_id;
1917: l_session_var.noa_id_correct := p_sf52_data.second_noa_id;
1918: l_session_var.assignment_id := p_sf52_data.employee_assignment_id;
1919:
1920: ghr_history_api.set_g_session_var(l_session_var);
1921:
1922: ghr_process_Sf52.Fetch_extra_info(
1923: p_pa_request_id => p_sf52_data.pa_request_id,
1924: p_noa_id => p_sf52_data.second_noa_id,
2088: INTO l_hist_address_rec
2089: FROM ghr_pa_history
2090: WHERE pa_history_id = l_hist.pa_history_id;
2091:
2092: ghr_history_api.fetch_history_info(
2093: p_table_name => ghr_history_api.g_addres_table,
2094: p_hist_data => l_hist_pre,
2095: p_pa_history_id => l_hist_address_rec.pa_history_id,
2096: p_table_pk_id => l_hist_address_rec.information1,
2089: FROM ghr_pa_history
2090: WHERE pa_history_id = l_hist.pa_history_id;
2091:
2092: ghr_history_api.fetch_history_info(
2093: p_table_name => ghr_history_api.g_addres_table,
2094: p_hist_data => l_hist_pre,
2095: p_pa_history_id => l_hist_address_rec.pa_history_id,
2096: p_table_pk_id => l_hist_address_rec.information1,
2097: p_person_id => p_sf52_data.person_id,
2105: c_pa_history_id => l_hist_address_rec.pa_history_id);
2106: fetch c_follow_rec into l_buf;
2107: if c_follow_rec%NOTFOUND then
2108: delete_appl_row(
2109: p_table_name => ghr_history_api.g_addres_table,
2110: p_table_pk_id => l_hist_address_rec.information1,
2111: p_dt_mode => null,
2112: p_date_effective => l_hist_address_rec.effective_date);
2113: end if;
2145: l_datetrack_table := TRUE;
2146: -- initialize pre-record to all nulls
2147: l_hist_pre := l_hist_dummy;
2148: -- get pre-record for the record fetched
2149: ghr_history_api.fetch_history_info(
2150: p_table_name => l_hist_rec.table_name,
2151: p_hist_data => l_hist_pre,
2152: p_pa_history_id => l_hist_rec.pa_history_id,
2153: p_table_pk_id => l_hist_rec.information1,
2179: hr_utility.set_location('datetrack table'|| l_proc,20);
2180: l_datetrack_table := FALSE;
2181: end if;
2182: -- PAY_ELEMENT_ENTRY needs to be handled differently
2183: if lower(l_hist_rec.table_name) = lower(ghr_history_api.g_eleent_table) then
2184: hr_utility.set_location('Processing element entry record'|| l_proc,25);
2185: if l_hist_rec.DML_operation = ghr_history_api.g_ins_operation then
2186: --6850492
2187: if to_date(l_hist_pre.information2, ghr_history_api.g_hist_date_format) = to_date(l_hist_rec.information2, ghr_history_api.g_hist_date_format) then
2181: end if;
2182: -- PAY_ELEMENT_ENTRY needs to be handled differently
2183: if lower(l_hist_rec.table_name) = lower(ghr_history_api.g_eleent_table) then
2184: hr_utility.set_location('Processing element entry record'|| l_proc,25);
2185: if l_hist_rec.DML_operation = ghr_history_api.g_ins_operation then
2186: --6850492
2187: if to_date(l_hist_pre.information2, ghr_history_api.g_hist_date_format) = to_date(l_hist_rec.information2, ghr_history_api.g_hist_date_format) then
2188: ghr_history_api.fetch_history_info(
2189: p_table_name => l_hist_rec.table_name,
2183: if lower(l_hist_rec.table_name) = lower(ghr_history_api.g_eleent_table) then
2184: hr_utility.set_location('Processing element entry record'|| l_proc,25);
2185: if l_hist_rec.DML_operation = ghr_history_api.g_ins_operation then
2186: --6850492
2187: if to_date(l_hist_pre.information2, ghr_history_api.g_hist_date_format) = to_date(l_hist_rec.information2, ghr_history_api.g_hist_date_format) then
2188: ghr_history_api.fetch_history_info(
2189: p_table_name => l_hist_rec.table_name,
2190: p_hist_data => l_hist_pre,
2191: p_pa_history_id => l_hist_rec.pa_history_id,
2184: hr_utility.set_location('Processing element entry record'|| l_proc,25);
2185: if l_hist_rec.DML_operation = ghr_history_api.g_ins_operation then
2186: --6850492
2187: if to_date(l_hist_pre.information2, ghr_history_api.g_hist_date_format) = to_date(l_hist_rec.information2, ghr_history_api.g_hist_date_format) then
2188: ghr_history_api.fetch_history_info(
2189: p_table_name => l_hist_rec.table_name,
2190: p_hist_data => l_hist_pre,
2191: p_pa_history_id => l_hist_rec.pa_history_id,
2192: p_table_pk_id => l_hist_rec.information1,
2281: delete_hist_row ( l_hist_rec.pa_history_id);
2282:
2283:
2284: -- PAY_ELEMENT_ENTRY_VALUE needs to be handled differently
2285: elsif lower(l_hist_rec.table_name) = lower (ghr_history_api.g_eleevl_table) then
2286: hr_utility.set_location('Processing element entry value record'|| l_proc,47);
2287: if l_hist_rec.DML_operation = ghr_history_api.g_upd_operation then
2288: hr_utility.set_location('Record was updated' || l_proc,48);
2289: if (l_pre_record = FALSE) then
2283:
2284: -- PAY_ELEMENT_ENTRY_VALUE needs to be handled differently
2285: elsif lower(l_hist_rec.table_name) = lower (ghr_history_api.g_eleevl_table) then
2286: hr_utility.set_location('Processing element entry value record'|| l_proc,47);
2287: if l_hist_rec.DML_operation = ghr_history_api.g_upd_operation then
2288: hr_utility.set_location('Record was updated' || l_proc,48);
2289: if (l_pre_record = FALSE) then
2290: -- Bug#2521744 Added if condition
2291: for element_name_rec1 in c_element_name1(l_hist_rec.information5)
2354:
2355: -- Determine if this record was created or updated.
2356: if l_datetrack_table then
2357: hr_utility.set_location('In Cancel - Date track table' ,1);
2358: if l_hist_rec.DML_operation = ghr_history_api.g_ins_operation then
2359: hr_utility.set_location('in Cancel - DML - Ins' ,1);
2360: l_rec_created_flag := TRUE;
2361:
2362: -- if this sf50 updated the row, then the pre must have the same date.
2366: -- a cancellation. In this case, the current row becomes the row that was created
2367: -- by the sf52. So, we must set the rec_created_flag to true for this row. Note
2368: -- this stands true with date tracked tables only as with non-date tracked tables there
2369: -- is only one row in a record, so this case will never occur.
2370: elsif l_hist_rec.DML_operation = ghr_history_api.g_upd_operation then
2371: hr_utility.set_location('in Cancel - DML - Upd' ,1);
2372: if l_hist_rec.effective_date <> l_hist_pre.effective_date then
2373: l_rec_created_flag := TRUE;
2374: hr_utility.set_location('in Cancel - Created' ,1);
2378: end if;
2379: end if;
2380: else
2381: hr_utility.set_location('In Cancel - Not a Date track table' ,1);
2382: l_rec_created_flag := (l_hist_rec.DML_operation = ghr_history_api.g_ins_operation);
2383: end if;
2384:
2385: what_to_do(
2386: p_datetrack_table => l_datetrack_table,
2473:
2474: IF l_rec_exists THEN
2475: --- Bug # 6127620 need to set the FND Session Date before calling extra info
2476: /* If p_sf52_data.second_noa_code = '800' then
2477: GHR_HISTORY_API.get_session_date(l_curr_sess_date);
2478: ghr_session.set_fnd_session_date(p_sf52_data.effective_date);
2479: end if;
2480: Begin */
2481: ----Bug #6127620
2643: l_root_sf52 ghr_pa_requests%rowtype;
2644:
2645: l_pa_request_id number;
2646: l_today date :=sysdate;
2647: l_session_var ghr_history_api.g_session_var_type;
2648: l_sf52_ei_data ghr_pa_request_extra_info%rowtype;
2649: l_agency_ei_data ghr_pa_request_extra_info%rowtype;
2650: l_sf52_data ghr_pa_requests%rowtype;
2651: l_sf52_data1 ghr_pa_requests%rowtype;
2790: begin
2791:
2792: hr_utility.set_location('Entering:'|| l_proc, 5);
2793: -- reinitialise session variables
2794: ghr_history_api.reinit_g_session_var;
2795:
2796: -- set values of session variables
2797: l_session_var.pa_request_id := p_sf52_data.pa_request_id;
2798: l_session_var.noa_id := p_sf52_data.second_noa_id;
2802: l_session_var.program_name := 'sf50';
2803: l_session_var.altered_pa_request_id := p_sf52_data.altered_pa_request_id;
2804: l_session_var.noa_id_correct := p_sf52_data.second_noa_id;
2805: l_session_var.assignment_id := p_sf52_data.employee_assignment_id;
2806: ghr_history_api.set_g_session_var(l_session_var);
2807:
2808:
2809: -- .47
2810:
2853: -- We are setting pa_history_id in session var to be able to fetch
2854: -- Pre-record values of the root SF52 for refresh purpose.
2855: -- It'll be reset after refresh has been done
2856:
2857: ghr_history_api.set_g_session_var(l_session_var);
2858: ghr_process_sf52.refresh_req_shadow(p_sf52_data => l_root_sf52,
2859: p_shadow_data => l_shadow_data);
2860: ghr_process_sf52.redo_pay_calc( p_sf52_rec => l_root_sf52);
2861: ghr_process_sf52.update_rfrs_values(p_sf52_data => l_root_sf52,
2862: p_shadow_data => l_shadow_data);
2863:
2864: -- reset pa_history_id in session variable.
2865: l_session_var.pa_history_id := null;
2866: ghr_history_api.set_g_session_var(l_session_var);
2867:
2868: -- .47
2869: */
2870:
2925: hr_utility.set_location('national_identifier right before update sf52: '|| l_sf52_data_result.employee_national_identifier || l_proc, 915);
2926: hr_utility.set_location('from_step_or_rate right before update sf52: '|| l_sf52_data_result.from_step_or_rate || l_proc, 915);
2927: hr_utility.set_location('to_step_or_rate right before update sf52: '|| l_sf52_data_result.to_step_or_rate || l_proc, 915);
2928:
2929: ghr_history_api.display_g_session_var;
2930: -- Check if atleast the min. required items exist in the pa_request
2931: ghr_sf52_validn_pkg.prelim_req_chk_for_update_hr(p_pa_request_rec => l_sf52_data_result);
2932: if (l_session_var.date_Effective > l_today) then
2933: -- issue savepoint
3477: l_sf52_data_step ghr_pa_requests%rowtype;
3478: l_sf52_ia_rec ghr_pa_requests%rowtype;
3479: l_sf52_dummy ghr_pa_requests%rowtype;
3480: l_sf52_cursor_step_indx number;
3481: l_session_var ghr_history_api.g_session_var_type;
3482: -- Bug#5435374 added l_session_var1.
3483: l_session_var1 ghr_history_api.g_session_var_type;
3484: l_capped_other_pay number := hr_api.g_number;
3485: l_retro_eff_date ghr_pa_requests.effective_date%type;
3479: l_sf52_dummy ghr_pa_requests%rowtype;
3480: l_sf52_cursor_step_indx number;
3481: l_session_var ghr_history_api.g_session_var_type;
3482: -- Bug#5435374 added l_session_var1.
3483: l_session_var1 ghr_history_api.g_session_var_type;
3484: l_capped_other_pay number := hr_api.g_number;
3485: l_retro_eff_date ghr_pa_requests.effective_date%type;
3486: l_retro_pa_request_id ghr_pa_requests.pa_request_id%type;
3487: l_retro_first_noa ghr_nature_of_actions.code%type;
3552: l_proc varchar2(30):='apply_noa_corrections';
3553: begin
3554: hr_utility.set_location('Entering:'|| l_proc, 5);
3555: l_sf52_data_result := p_sf52_data_result;
3556: ghr_history_api.get_g_session_var(l_session_var);
3557: -- loop through all corrections in the correction chain, incrementally applying them by
3558: -- calling apply_corrections procedure.
3559: open l_sf52_cursor ;
3560: l_sf52_cursor_step_indx := 0;
3591: -- We are setting pa_history_id in session var to be able to fetch
3592: -- Pre-record values of the root SF52 for refresh purpose.
3593: -- It'll be reset after refresh has been done
3594:
3595: ghr_history_api.set_g_session_var(l_session_var);
3596: ghr_process_sf52.refresh_req_shadow(p_sf52_data => p_sf52_data_result,
3597: p_shadow_data => l_shadow_data);
3598: ghr_process_sf52.redo_pay_calc( p_sf52_rec => p_sf52_data_result,
3599: p_capped_other_pay => l_capped_other_pay);
3599: p_capped_other_pay => l_capped_other_pay);
3600:
3601: -- reset pa_history_id in session variable.
3602: l_session_var.pa_history_id := null;
3603: ghr_history_api.set_g_session_var(l_session_var);
3604: -- .47
3605: -- Bug#3543213 For PRD U,V and NOA 894(Pay Adjustment) get the PRD Value from assignment
3606: IF p_sf52_data_result.first_noa_code = '894' AND
3607: p_sf52_data_result.pay_rate_determinant IN ('U','V') THEN
3732: open core_chg_check( p_sf52_data_result.to_position_id,
3733: c_orig_det_rec.effective_date);
3734: fetch core_chg_check into l_core_chg_avbl;
3735: if core_chg_check%found then
3736: ghr_history_api.get_g_session_var(l_session_var);
3737: ghr_history_api.reinit_g_session_var;
3738: l_session_var1.date_Effective := l_session_var.date_Effective;
3739: l_session_var1.person_id := l_session_var.person_id;
3740: l_session_var1.assignment_id := l_session_var.assignment_id;
3733: c_orig_det_rec.effective_date);
3734: fetch core_chg_check into l_core_chg_avbl;
3735: if core_chg_check%found then
3736: ghr_history_api.get_g_session_var(l_session_var);
3737: ghr_history_api.reinit_g_session_var;
3738: l_session_var1.date_Effective := l_session_var.date_Effective;
3739: l_session_var1.person_id := l_session_var.person_id;
3740: l_session_var1.assignment_id := l_session_var.assignment_id;
3741: l_session_var1.fire_trigger := 'N';
3739: l_session_var1.person_id := l_session_var.person_id;
3740: l_session_var1.assignment_id := l_session_var.assignment_id;
3741: l_session_var1.fire_trigger := 'N';
3742: l_session_var1.program_name := 'sf50';
3743: ghr_history_api.set_g_session_var(l_session_var1);
3744: ghr_history_fetch.fetch_positionei(
3745: p_position_id => p_sf52_data_result.to_position_id,
3746: p_information_type => 'GHR_US_POS_GRP1',
3747: p_date_effective => p_sf52_data_result.effective_date,
3747: p_date_effective => p_sf52_data_result.effective_date,
3748: p_pos_ei_data => l_pos_ei_grp1_data);
3749: p_sf52_data_result.supervisory_status := l_pos_ei_grp1_data.poei_information16;
3750: p_sf52_data_result.part_time_hours := l_pos_ei_grp1_data.poei_information23;
3751: ghr_history_api.reinit_g_session_var;
3752: ghr_history_api.set_g_session_var(l_session_var);
3753: end if;
3754: close core_chg_check;
3755: END IF;
3748: p_pos_ei_data => l_pos_ei_grp1_data);
3749: p_sf52_data_result.supervisory_status := l_pos_ei_grp1_data.poei_information16;
3750: p_sf52_data_result.part_time_hours := l_pos_ei_grp1_data.poei_information23;
3751: ghr_history_api.reinit_g_session_var;
3752: ghr_history_api.set_g_session_var(l_session_var);
3753: end if;
3754: close core_chg_check;
3755: END IF;
3756: --bug #6356058 end
3801: IF p_sf52_data_result.from_position_id = p_sf52_data_result.to_position_id THEN
3802:
3803: -- Reinitializing the session variables to get the valid grade as on the
3804: -- effective date.
3805: ghr_history_api.get_g_session_var(l_session_var);
3806: ghr_history_api.reinit_g_session_var;
3807: l_session_var1.date_Effective := l_session_var.date_Effective;
3808: l_session_var1.person_id := l_session_var.person_id;
3809: l_session_var1.assignment_id := l_session_var.assignment_id;
3802:
3803: -- Reinitializing the session variables to get the valid grade as on the
3804: -- effective date.
3805: ghr_history_api.get_g_session_var(l_session_var);
3806: ghr_history_api.reinit_g_session_var;
3807: l_session_var1.date_Effective := l_session_var.date_Effective;
3808: l_session_var1.person_id := l_session_var.person_id;
3809: l_session_var1.assignment_id := l_session_var.assignment_id;
3810: l_session_var1.fire_trigger := 'N';
3808: l_session_var1.person_id := l_session_var.person_id;
3809: l_session_var1.assignment_id := l_session_var.assignment_id;
3810: l_session_var1.fire_trigger := 'N';
3811: l_session_var1.program_name := 'sf50';
3812: ghr_history_api.set_g_session_var(l_session_var1);
3813:
3814: -- Retrieve the Grade info from the POI history table
3815: ghr_history_fetch.fetch_positionei(
3816: p_position_id => p_sf52_data_result.to_position_id,
3819: p_pos_ei_data => l_pos_ei_grade_data);
3820:
3821: -- Reset the session variables after getting the date effective valid grade
3822: -- to continue with the correction process.
3823: ghr_history_api.reinit_g_session_var;
3824: ghr_history_api.set_g_session_var(l_session_var);
3825:
3826: IF l_pos_ei_grade_data.position_extra_info_id IS NOT NULL THEN
3827: hr_utility.set_location('GL: to grd id:'||p_sf52_data_result.to_grade_id,30);
3820:
3821: -- Reset the session variables after getting the date effective valid grade
3822: -- to continue with the correction process.
3823: ghr_history_api.reinit_g_session_var;
3824: ghr_history_api.set_g_session_var(l_session_var);
3825:
3826: IF l_pos_ei_grade_data.position_extra_info_id IS NOT NULL THEN
3827: hr_utility.set_location('GL: to grd id:'||p_sf52_data_result.to_grade_id,30);
3828: hr_utility.set_location('GL: pos ei grd:'||l_pos_ei_grade_data.poei_information3,40);
4212: hr_utility.set_location( 'information4 : ' || p_hist_pre.information4 || l_proc, 11);
4213: hr_utility.set_location( 'Effective Date : ' || p_hist_pre.information2 || l_proc, 12);
4214: hr_utility.set_location( 'Business Group id : ' || ll_bg_id, 100000002);
4215:
4216: l_eff_date := to_date(p_hist_pre.information2, ghr_history_api.g_hist_date_format);
4217: hr_utility.set_location('Converted eff Date: ' || l_eff_date || l_proc,18);
4218: -- get input value name.
4219: open c_input_value( cp_input_value_id => p_hist_pre.information4,
4220: cp_eff_date => l_eff_date,
4247: -- get assignment id.
4248: open c_asgmt_id (cp_information1 => p_hist_pre.information1,
4249: cp_information2 => p_hist_pre.information2,
4250: cp_information3 => p_hist_pre.information3,
4251: cp_table_name => ghr_history_api.g_eleevl_table);
4252: fetch c_asgmt_id into l_asg_id;
4253: if c_asgmt_id%NOTFOUND then
4254: hr_utility.set_location( 'assignment_id notfound : ' || l_proc, 41);
4255: close c_asgmt_id;
4340: -- to us.
4341: cursor c_hist is
4342: select rowid row_id
4343: from ghr_pa_history
4344: where table_name = ghr_history_api.g_eleevl_table and
4345: pa_request_id = p_hist_rec.pa_request_id and
4346: nature_of_action_id = p_hist_rec.nature_of_action_id
4347: for update of table_name;
4348: l_proc varchar2(30):='delete_eleentval';
5079: l_proc varchar2(72) := 'delete_appl_row';
5080: BEGIN
5081: hr_utility.set_location( 'Entering : ' || l_proc, 10);
5082: hr_utility.set_location(' P_TABLE_NAME:' || p_table_name, 15);
5083: if (lower(p_table_name) = lower(ghr_history_api.g_peop_table)) then
5084: delete_peop_row( p_person_id => p_table_pk_id,
5085: p_dt_mode => p_dt_mode,
5086: p_date_effective => p_date_effective);
5087: -- Added Handling of Position table. Bug# 1252481 11-MAY-2000
5084: delete_peop_row( p_person_id => p_table_pk_id,
5085: p_dt_mode => p_dt_mode,
5086: p_date_effective => p_date_effective);
5087: -- Added Handling of Position table. Bug# 1252481 11-MAY-2000
5088: elsif (lower(p_table_name) = lower(ghr_history_api.g_posn_table)) then
5089: delete_posn_row( p_position_id => p_table_pk_id,
5090: p_dt_mode => p_dt_mode,
5091: p_date_effective => p_date_effective);
5092: elsif (lower(p_table_name) = lower(ghr_history_api.g_asgn_table)) then
5088: elsif (lower(p_table_name) = lower(ghr_history_api.g_posn_table)) then
5089: delete_posn_row( p_position_id => p_table_pk_id,
5090: p_dt_mode => p_dt_mode,
5091: p_date_effective => p_date_effective);
5092: elsif (lower(p_table_name) = lower(ghr_history_api.g_asgn_table)) then
5093: delete_asgn_row( p_assignment_id => p_table_pk_id,
5094: p_dt_mode => p_dt_mode,
5095: p_date_effective => p_date_effective);
5096: elsif (lower(p_table_name) = lower(ghr_history_api.g_peopei_table)) then
5092: elsif (lower(p_table_name) = lower(ghr_history_api.g_asgn_table)) then
5093: delete_asgn_row( p_assignment_id => p_table_pk_id,
5094: p_dt_mode => p_dt_mode,
5095: p_date_effective => p_date_effective);
5096: elsif (lower(p_table_name) = lower(ghr_history_api.g_peopei_table)) then
5097: delete_peopei_row( p_person_extra_info_id => p_table_pk_id);
5098: elsif (lower(p_table_name) = lower(ghr_history_api.g_asgnei_table)) then
5099: delete_asgnei_row( p_assignment_extra_info_id => p_table_pk_id);
5100: elsif (lower(p_table_name) = lower(ghr_history_api.g_posnei_table)) then
5094: p_dt_mode => p_dt_mode,
5095: p_date_effective => p_date_effective);
5096: elsif (lower(p_table_name) = lower(ghr_history_api.g_peopei_table)) then
5097: delete_peopei_row( p_person_extra_info_id => p_table_pk_id);
5098: elsif (lower(p_table_name) = lower(ghr_history_api.g_asgnei_table)) then
5099: delete_asgnei_row( p_assignment_extra_info_id => p_table_pk_id);
5100: elsif (lower(p_table_name) = lower(ghr_history_api.g_posnei_table)) then
5101: delete_posnei_row( p_position_extra_info_id => p_table_pk_id);
5102: elsif (lower(p_table_name) = lower(ghr_history_api.g_addres_table)) then
5096: elsif (lower(p_table_name) = lower(ghr_history_api.g_peopei_table)) then
5097: delete_peopei_row( p_person_extra_info_id => p_table_pk_id);
5098: elsif (lower(p_table_name) = lower(ghr_history_api.g_asgnei_table)) then
5099: delete_asgnei_row( p_assignment_extra_info_id => p_table_pk_id);
5100: elsif (lower(p_table_name) = lower(ghr_history_api.g_posnei_table)) then
5101: delete_posnei_row( p_position_extra_info_id => p_table_pk_id);
5102: elsif (lower(p_table_name) = lower(ghr_history_api.g_addres_table)) then
5103: delete_address_row( p_address_id => p_table_pk_id);
5104: elsif (lower(p_table_name) = lower(ghr_history_api.g_perana_table)) then
5098: elsif (lower(p_table_name) = lower(ghr_history_api.g_asgnei_table)) then
5099: delete_asgnei_row( p_assignment_extra_info_id => p_table_pk_id);
5100: elsif (lower(p_table_name) = lower(ghr_history_api.g_posnei_table)) then
5101: delete_posnei_row( p_position_extra_info_id => p_table_pk_id);
5102: elsif (lower(p_table_name) = lower(ghr_history_api.g_addres_table)) then
5103: delete_address_row( p_address_id => p_table_pk_id);
5104: elsif (lower(p_table_name) = lower(ghr_history_api.g_perana_table)) then
5105: delete_person_analyses_row( p_person_analysis_id => p_table_pk_id);
5106: end if;
5100: elsif (lower(p_table_name) = lower(ghr_history_api.g_posnei_table)) then
5101: delete_posnei_row( p_position_extra_info_id => p_table_pk_id);
5102: elsif (lower(p_table_name) = lower(ghr_history_api.g_addres_table)) then
5103: delete_address_row( p_address_id => p_table_pk_id);
5104: elsif (lower(p_table_name) = lower(ghr_history_api.g_perana_table)) then
5105: delete_person_analyses_row( p_person_analysis_id => p_table_pk_id);
5106: end if;
5107: hr_utility.set_location( 'Leaving : ' || l_proc, 20);
5108: END delete_appl_row;
5359: l_shadow_data ghr_pa_request_shadow%rowtype;
5360: l_proc varchar2(30):='build_corrected_sf52';
5361:
5362: --Bug 2141522
5363: l_session_var ghr_history_api.g_session_var_type;
5364: -- Bug#5435374 added l_session_var1.
5365: l_session_var1 ghr_history_api.g_session_var_type;
5366: l_session_sf52_rec ghr_pa_requests%rowtype;
5367: cursor c_rpa is
5361:
5362: --Bug 2141522
5363: l_session_var ghr_history_api.g_session_var_type;
5364: -- Bug#5435374 added l_session_var1.
5365: l_session_var1 ghr_history_api.g_session_var_type;
5366: l_session_sf52_rec ghr_pa_requests%rowtype;
5367: cursor c_rpa is
5368: select *
5369: from ghr_pa_requests
5398:
5399: begin
5400: hr_utility.set_location('Entering:'|| l_proc, 5);
5401: l_sf52_data_result_rec := p_sf52_data_result;
5402: -- ghr_history_api.get_g_session_var(l_session_var);
5403: --Bug 2141522
5404: -- set values of session variables
5405: open c_rpa;
5406: fetch c_rpa into l_session_sf52_rec;
5414: l_session_var.program_name := 'sf50';
5415: l_session_var.assignment_id := l_session_sf52_rec.employee_assignment_id;
5416: l_session_var.altered_pa_request_id := l_session_sf52_rec.altered_pa_request_id;
5417: l_session_var.noa_id_correct := l_session_sf52_rec.second_noa_id;
5418: ghr_history_api.set_g_session_var(l_session_var);
5419: --Bug 2141522
5420:
5421: -- loop through all corrections in the correction chain, incrementally applying them by
5422: -- calling apply_corrections procedure.
5619: IF p_sf52_data_result.from_position_id = p_sf52_data_result.to_position_id THEN
5620:
5621: -- Reinitializing the session variables to get the valid grade as on the
5622: -- effective date.
5623: ghr_history_api.get_g_session_var(l_session_var);
5624: ghr_history_api.reinit_g_session_var;
5625: l_session_var1.date_Effective := l_session_var.date_Effective;
5626: l_session_var1.person_id := l_session_var.person_id;
5627: l_session_var1.assignment_id := l_session_var.assignment_id;
5620:
5621: -- Reinitializing the session variables to get the valid grade as on the
5622: -- effective date.
5623: ghr_history_api.get_g_session_var(l_session_var);
5624: ghr_history_api.reinit_g_session_var;
5625: l_session_var1.date_Effective := l_session_var.date_Effective;
5626: l_session_var1.person_id := l_session_var.person_id;
5627: l_session_var1.assignment_id := l_session_var.assignment_id;
5628: l_session_var1.fire_trigger := 'N';
5626: l_session_var1.person_id := l_session_var.person_id;
5627: l_session_var1.assignment_id := l_session_var.assignment_id;
5628: l_session_var1.fire_trigger := 'N';
5629: l_session_var1.program_name := 'sf50';
5630: ghr_history_api.set_g_session_var(l_session_var1);
5631:
5632: -- Retrieve the Grade info from the POI history table
5633: ghr_history_fetch.fetch_positionei(
5634: p_position_id => p_sf52_data_result.to_position_id,
5636: p_date_effective => p_sf52_data_result.effective_date,
5637: p_pos_ei_data => l_pos_ei_grade_data);
5638:
5639: -- Reset the session variables after getting the date effective grade value.
5640: ghr_history_api.reinit_g_session_var;
5641: ghr_history_api.set_g_session_var(l_session_var);
5642:
5643: IF l_pos_ei_grade_data.position_extra_info_id IS NOT NULL THEN
5644: hr_utility.set_location('GL: to grd id:'||p_sf52_data_result.to_grade_id,30);
5637: p_pos_ei_data => l_pos_ei_grade_data);
5638:
5639: -- Reset the session variables after getting the date effective grade value.
5640: ghr_history_api.reinit_g_session_var;
5641: ghr_history_api.set_g_session_var(l_session_var);
5642:
5643: IF l_pos_ei_grade_data.position_extra_info_id IS NOT NULL THEN
5644: hr_utility.set_location('GL: to grd id:'||p_sf52_data_result.to_grade_id,30);
5645: hr_utility.set_location('GL: pos ei grd:'||l_pos_ei_grade_data.poei_information3,40);
5676:
5677: Procedure populate_corrected_sf52(p_pa_request_id in number,
5678: p_noa_code_correct in varchar2)
5679: is
5680: l_session_var ghr_history_api.g_session_var_type;
5681: l_sf52_data ghr_pa_requests%ROWTYPE;
5682:
5683:
5684: FUNCTION get_record_category(p_sf52_record IN ghr_pa_requests%ROWTYPE)
5853: l_session_var.program_name := 'GHRSF50';
5854: l_session_var.assignment_id := l_sf52_data.employee_assignment_id;
5855: l_session_var.altered_pa_request_id := l_sf52_data.altered_pa_request_id;
5856: l_session_var.noa_id_correct := l_sf52_data.second_noa_id;
5857: ghr_history_api.set_g_session_var(l_session_var);
5858: ---Bug 5220727
5859: IF (l_sf52_data.second_noa_code <> '825' AND
5860: NOT(l_sf52_data.rpa_type='DUAL' and l_sf52_data.second_noa_code like '3%')) then --Bug# 8299172
5861: build_corrected_sf52(p_pa_request_id, p_noa_code_correct, sf52_corr_rec,'NPA');
5976: c_effective_date date,
5977: c_root_hist_id number) is
5978: Select pa_history_id
5979: from ghr_pa_history pah
5980: where table_name = ghr_history_api.g_eleevl_table
5981: and information5 = c_information1
5982: and (effective_date > c_effective_date or
5983: (effective_date = c_effective_date and
5984: c_root_hist_id <
6064: ,status
6065: ,rowid row_id
6066: from ghr_pa_requests
6067: where (level = 1 or ( level > 1 and
6068: nvl(second_noa_cancel_or_correct, '@#$') <> ghr_history_api.g_cancel)) and
6069: first_noa_code <> '001' and
6070: nvl(status, '@!#') <> 'CANCELED'
6071: start with pa_request_id = c_pa_request_id
6072: connect by prior pa_request_id = altered_pa_request_id and
6175: hr_utility.set_location('Fetching original SF52 ' || l_proc , 110);
6176:
6177: -- Set column values in the SF50 being Cancelled;
6178: -- copy first/second_noa_canc_pa_request_id to first/second_noa_pa_request_id
6179: -- set first/second_noa_canel_correct_flag = 'ghr_history_api.g_cancel
6180:
6181: l_sf52.object_version_number := get_sf52_ovn ( p_pa_request_id => l_sf52.pa_request_id);
6182:
6183: if l_sf52.first_noa_code = p_sf52_data.second_noa_code then
6186: ghr_par_upd.upd(
6187: p_pa_request_id => l_sf52.pa_request_id
6188: ,p_object_version_number => l_sf52.object_version_number
6189: ,p_first_noa_pa_request_id => l_sf52.first_noa_canc_pa_request_id
6190: ,p_first_noa_cancel_or_correct => ghr_history_api.g_cancel
6191: );
6192:
6193: end if;
6194: else
6197: ghr_par_upd.upd(
6198: p_pa_request_id => l_sf52.pa_request_id
6199: ,p_object_version_number => l_sf52.object_version_number
6200: ,p_second_noa_pa_request_id => l_sf52.second_noa_canc_pa_request_id
6201: ,p_second_noa_cancel_or_correct => ghr_history_api.g_cancel
6202: );
6203: end if;
6204: end if;
6205:
7245: l_sf52_data_step ghr_pa_requests%rowtype;
7246: l_sf52_ia_rec ghr_pa_requests%rowtype;
7247: l_sf52_dummy ghr_pa_requests%rowtype;
7248: l_sf52_cursor_step_indx number;
7249: l_session_var ghr_history_api.g_session_var_type;
7250: -- Bug#5435374 added l_session_var1.
7251: l_session_var1 ghr_history_api.g_session_var_type;
7252: l_capped_other_pay number := hr_api.g_number;
7253: l_retro_eff_date ghr_pa_requests.effective_date%type;
7247: l_sf52_dummy ghr_pa_requests%rowtype;
7248: l_sf52_cursor_step_indx number;
7249: l_session_var ghr_history_api.g_session_var_type;
7250: -- Bug#5435374 added l_session_var1.
7251: l_session_var1 ghr_history_api.g_session_var_type;
7252: l_capped_other_pay number := hr_api.g_number;
7253: l_retro_eff_date ghr_pa_requests.effective_date%type;
7254: l_retro_pa_request_id ghr_pa_requests.pa_request_id%type;
7255: l_retro_first_noa ghr_nature_of_actions.code%type;
7367: l_retro_action_exists varchar2(1) := 'N';
7368: begin
7369: hr_utility.set_location('Entering:'|| l_proc, 5);
7370: l_sf52_data_result := p_sf52_data_result;
7371: ghr_history_api.get_g_session_var(l_session_var);
7372: -- loop through all corrections in the correction chain, incrementally applying them by
7373: -- calling apply_corrections procedure.
7374: open l_sf52_cursor ;
7375: l_sf52_cursor_step_indx := 0;
7404: end if;
7405: -- We are setting pa_history_id in session var to be able to fetch
7406: -- Pre-record values of the root SF52 for refresh purpose.
7407: -- It'll be reset after refresh has been done
7408: ghr_history_api.set_g_session_var(l_session_var);
7409:
7410: -- 8303159 Added to fetch family code for second correction of dual action before refresh
7411: if (p_sf52_data_result.second_noa_id is not null) then
7412: if (p_sf52_data.second_noa_id = p_sf52_data_result.second_noa_id) then
7423: ghr_process_sf52.redo_pay_calc( p_sf52_rec => p_sf52_data_result,
7424: p_capped_other_pay => l_capped_other_pay);
7425: -- reset pa_history_id in session variable.
7426: l_session_var.pa_history_id := null;
7427: ghr_history_api.set_g_session_var(l_session_var);
7428: -- .47
7429: -- Bug#3543213 For PRD U,V and NOA 894(Pay Adjustment) get the PRD Value from assignment
7430: IF p_sf52_data_result.first_noa_code = '894' AND
7431: p_sf52_data_result.pay_rate_determinant IN ('U','V') THEN
7571: open core_chg_check( p_sf52_data_result.to_position_id,
7572: c_orig_det_rec.effective_date);
7573: fetch core_chg_check into l_core_chg_avbl;
7574: if core_chg_check%found then
7575: ghr_history_api.get_g_session_var(l_session_var);
7576: ghr_history_api.reinit_g_session_var;
7577: l_session_var1.date_Effective := l_session_var.date_Effective;
7578: l_session_var1.person_id := l_session_var.person_id;
7579: l_session_var1.assignment_id := l_session_var.assignment_id;
7572: c_orig_det_rec.effective_date);
7573: fetch core_chg_check into l_core_chg_avbl;
7574: if core_chg_check%found then
7575: ghr_history_api.get_g_session_var(l_session_var);
7576: ghr_history_api.reinit_g_session_var;
7577: l_session_var1.date_Effective := l_session_var.date_Effective;
7578: l_session_var1.person_id := l_session_var.person_id;
7579: l_session_var1.assignment_id := l_session_var.assignment_id;
7580: l_session_var1.fire_trigger := 'N';
7578: l_session_var1.person_id := l_session_var.person_id;
7579: l_session_var1.assignment_id := l_session_var.assignment_id;
7580: l_session_var1.fire_trigger := 'N';
7581: l_session_var1.program_name := 'sf50';
7582: ghr_history_api.set_g_session_var(l_session_var1);
7583: ghr_history_fetch.fetch_positionei(
7584: p_position_id => p_sf52_data_result.to_position_id,
7585: p_information_type => 'GHR_US_POS_GRP1',
7586: p_date_effective => p_sf52_data_result.effective_date,
7586: p_date_effective => p_sf52_data_result.effective_date,
7587: p_pos_ei_data => l_pos_ei_grp1_data);
7588: p_sf52_data_result.supervisory_status := l_pos_ei_grp1_data.poei_information16;
7589: p_sf52_data_result.part_time_hours := l_pos_ei_grp1_data.poei_information23;
7590: ghr_history_api.reinit_g_session_var;
7591: ghr_history_api.set_g_session_var(l_session_var);
7592: end if;
7593: close core_chg_check;
7594: END IF;
7587: p_pos_ei_data => l_pos_ei_grp1_data);
7588: p_sf52_data_result.supervisory_status := l_pos_ei_grp1_data.poei_information16;
7589: p_sf52_data_result.part_time_hours := l_pos_ei_grp1_data.poei_information23;
7590: ghr_history_api.reinit_g_session_var;
7591: ghr_history_api.set_g_session_var(l_session_var);
7592: end if;
7593: close core_chg_check;
7594: END IF;
7595: --bug #6356058 end
7660: -- Bug#5435374 If the from and to position ids are same, verify the pay plan, grade details.
7661: IF p_sf52_data_result.from_position_id = p_sf52_data_result.to_position_id THEN
7662: -- Reinitializing the session variables to get the valid grade as on the
7663: -- effective date.
7664: ghr_history_api.get_g_session_var(l_session_var);
7665: ghr_history_api.reinit_g_session_var;
7666: l_session_var1.date_Effective := l_session_var.date_Effective;
7667: l_session_var1.person_id := l_session_var.person_id;
7668: l_session_var1.assignment_id := l_session_var.assignment_id;
7661: IF p_sf52_data_result.from_position_id = p_sf52_data_result.to_position_id THEN
7662: -- Reinitializing the session variables to get the valid grade as on the
7663: -- effective date.
7664: ghr_history_api.get_g_session_var(l_session_var);
7665: ghr_history_api.reinit_g_session_var;
7666: l_session_var1.date_Effective := l_session_var.date_Effective;
7667: l_session_var1.person_id := l_session_var.person_id;
7668: l_session_var1.assignment_id := l_session_var.assignment_id;
7669: l_session_var1.fire_trigger := 'N';
7667: l_session_var1.person_id := l_session_var.person_id;
7668: l_session_var1.assignment_id := l_session_var.assignment_id;
7669: l_session_var1.fire_trigger := 'N';
7670: l_session_var1.program_name := 'sf50';
7671: ghr_history_api.set_g_session_var(l_session_var1);
7672:
7673: -- Retrieve the Grade info from the POI history table
7674: ghr_history_fetch.fetch_positionei(
7675: p_position_id => p_sf52_data_result.to_position_id,
7678: p_pos_ei_data => l_pos_ei_grade_data);
7679:
7680: -- Reset the session variables after getting the date effective valid grade
7681: -- to continue with the correction process.
7682: ghr_history_api.reinit_g_session_var;
7683: ghr_history_api.set_g_session_var(l_session_var);
7684:
7685: IF l_pos_ei_grade_data.position_extra_info_id IS NOT NULL THEN
7686: hr_utility.set_location('GL: to grd id:'||p_sf52_data_result.to_grade_id,30);
7679:
7680: -- Reset the session variables after getting the date effective valid grade
7681: -- to continue with the correction process.
7682: ghr_history_api.reinit_g_session_var;
7683: ghr_history_api.set_g_session_var(l_session_var);
7684:
7685: IF l_pos_ei_grade_data.position_extra_info_id IS NOT NULL THEN
7686: hr_utility.set_location('GL: to grd id:'||p_sf52_data_result.to_grade_id,30);
7687: hr_utility.set_location('GL: pos ei grd:'||l_pos_ei_grade_data.poei_information3,40);