APPS.FA_CUA_HR_RETIREMENTS_PKG dependencies on FND_PROFILE

Line 998: v_created_by:= nvl(TO_NUMBER(fnd_profile.value('USER_ID')),-1);

994:
995: x_err_stage:= 'Initializing Parameters';
996: v_sysdate:= sysdate;
997: v_conc_request_id := fnd_global.conc_request_id;
998: v_created_by:= nvl(TO_NUMBER(fnd_profile.value('USER_ID')),-1);
999: v_last_updated_by:= v_created_by;
1000: v_last_update_login:= nvl(TO_NUMBER(fnd_profile.value('LOGIN_ID')),-1);
1001:
1002: x_err_stack:= x_err_stack||'->'||'Insert_hr_retirement_hdrs';

Line 1000: v_last_update_login:= nvl(TO_NUMBER(fnd_profile.value('LOGIN_ID')),-1);

996: v_sysdate:= sysdate;
997: v_conc_request_id := fnd_global.conc_request_id;
998: v_created_by:= nvl(TO_NUMBER(fnd_profile.value('USER_ID')),-1);
999: v_last_updated_by:= v_created_by;
1000: v_last_update_login:= nvl(TO_NUMBER(fnd_profile.value('LOGIN_ID')),-1);
1001:
1002: x_err_stack:= x_err_stack||'->'||'Insert_hr_retirement_hdrs';
1003: insert_hr_retirement_hdrs (
1004: x_event_code

Line 1654: v_user:= nvl(TO_NUMBER(fnd_profile.value('USER_ID')),-1);

1650: v_err_code := '0';
1651:
1652: -- initializing parameters
1653: v_sysdate:= sysdate;
1654: v_user:= nvl(TO_NUMBER(fnd_profile.value('USER_ID')),-1);
1655: v_last_update_login:= nvl(TO_NUMBER(fnd_profile.value('LOGIN_ID')),-1);
1656:
1657: FOR hrd_rec IN C_hrd LOOP
1658:

Line 1655: v_last_update_login:= nvl(TO_NUMBER(fnd_profile.value('LOGIN_ID')),-1);

1651:
1652: -- initializing parameters
1653: v_sysdate:= sysdate;
1654: v_user:= nvl(TO_NUMBER(fnd_profile.value('USER_ID')),-1);
1655: v_last_update_login:= nvl(TO_NUMBER(fnd_profile.value('LOGIN_ID')),-1);
1656:
1657: FOR hrd_rec IN C_hrd LOOP
1658:
1659: --initialize for each loop