DBA Data[Home] [Help]

APPS.FA_CUA_HR_RETIREMENTS_PKG dependencies on FND_GLOBAL

Line 993: v_conc_request_id := fnd_global.conc_request_id;

989: x_err_stack := x_err_stack||'->'||'generate_retirement_batch';
990:
991: x_err_stage:= 'Initializing Parameters';
992: v_sysdate:= sysdate;
993: v_conc_request_id := fnd_global.conc_request_id;
994: v_created_by:= nvl(TO_NUMBER(fnd_profile.value('USER_ID')),-1);
995: v_last_updated_by:= v_created_by;
996: v_last_update_login:= nvl(TO_NUMBER(fnd_profile.value('LOGIN_ID')),-1);
997:

Line 1376: v_conc_request_id := fnd_global.conc_request_id;

1372:
1373: BEGIN
1374: RETCODE:= '0';
1375: BEGIN
1376: v_conc_request_id := fnd_global.conc_request_id;
1377:
1378: for hrh_rec IN c_hrh LOOP
1379: update fa_hr_retirement_headers
1380: set status_code = 'IP'

Line 1447: , last_updated_by = fnd_global.login_id

1443: v_dummy:= 'N';
1444: update fa_hr_retirement_headers
1445: set status_code = 'R' -- Rejected Processed
1446: , concurrent_request_id = v_conc_request_ID
1447: , last_updated_by = fnd_global.login_id
1448: , last_update_date = sysdate
1449: , last_update_login = fnd_global.login_id
1450: where batch_id = hrh_rec.batch_id;
1451:

Line 1449: , last_update_login = fnd_global.login_id

1445: set status_code = 'R' -- Rejected Processed
1446: , concurrent_request_id = v_conc_request_ID
1447: , last_updated_by = fnd_global.login_id
1448: , last_update_date = sysdate
1449: , last_update_login = fnd_global.login_id
1450: where batch_id = hrh_rec.batch_id;
1451:
1452: Update fa_hr_retirement_details
1453: set status_code = 'P'

Line 1460: , last_updated_by = fnd_global.login_id

1456: else
1457: update fa_hr_retirement_headers
1458: set status_code = 'CP' -- Completetly Processed
1459: , concurrent_request_id = v_conc_request_ID
1460: , last_updated_by = fnd_global.login_id
1461: , last_update_date = sysdate
1462: , last_update_login = fnd_global.login_id
1463: where batch_id = hrh_rec.batch_id;
1464: end if;

Line 1462: , last_update_login = fnd_global.login_id

1458: set status_code = 'CP' -- Completetly Processed
1459: , concurrent_request_id = v_conc_request_ID
1460: , last_updated_by = fnd_global.login_id
1461: , last_update_date = sysdate
1462: , last_update_login = fnd_global.login_id
1463: where batch_id = hrh_rec.batch_id;
1464: end if;
1465:
1466: commit;