APPS.FA_CUA_HR_RETIREMENTS_PKG dependencies on FA_HR_RETIREMENT_HEADERS

Line 462: -- fa_hr_retirement_headers table

458: END check_pending_batch;
459:
460: -- ---------------------------------------------------
461: -- This procedure insert passed in information into
462: -- fa_hr_retirement_headers table
463: -- and returns a batch_id
464: -- ----------------------------------------------------
465: PROCEDURE insert_hr_retirement_hdrs(
466: x_event_code IN VARCHAR2

Line 541: Insert into fa_hr_retirement_headers(

537: fetch C1 into x_batch_id;
538: close C1;
539:
540: x_err_stage:= 'Inserting retirement_headers';
541: Insert into fa_hr_retirement_headers(
542: event_code
543: , book_type_code
544: , status_code
545: , asset_hierarchy_id

Line 1372: from fa_hr_retirement_headers

1368: v_ret_value NUMBER;
1369:
1370: CURSOR c_hrh IS
1371: select *
1372: from fa_hr_retirement_headers
1373: where batch_id >= nvl(x_from_batch_num, batch_id )
1374: AND batch_id <= nvl(x_to_batch_num, batch_id)
1375: AND status_code IN ('IP', 'P', 'RC')
1376: order by creation_date

Line 1385: update fa_hr_retirement_headers

1381: BEGIN
1382: v_conc_request_id := fnd_global.conc_request_id;
1383:
1384: for hrh_rec IN c_hrh LOOP
1385: update fa_hr_retirement_headers
1386: set status_code = 'IP'
1387: where batch_id = hrh_rec.batch_id;
1388:
1389: update fa_hr_retirement_details

Line 1451: update fa_hr_retirement_headers

1447: End ;
1448:
1449: if v_dummy = 'Y' then
1450: v_dummy:= 'N';
1451: update fa_hr_retirement_headers
1452: set status_code = 'R' -- Rejected Processed
1453: , concurrent_request_id = v_conc_request_ID
1454: , last_updated_by = fnd_global.login_id
1455: , last_update_date = sysdate

Line 1464: update fa_hr_retirement_headers

1460: set status_code = 'P'
1461: where status_code <> 'R'
1462: and batch_id = hrh_rec.batch_id;
1463: else
1464: update fa_hr_retirement_headers
1465: set status_code = 'CP' -- Completetly Processed
1466: , concurrent_request_id = v_conc_request_ID
1467: , last_updated_by = fnd_global.login_id
1468: , last_update_date = sysdate