APPS.FA_CUA_HR_RETIREMENTS_PKG dependencies on FND_PROFILE

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

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:
998: x_err_stack:= x_err_stack||'->'||'Insert_hr_retirement_hdrs';

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

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:
998: x_err_stack:= x_err_stack||'->'||'Insert_hr_retirement_hdrs';
999: insert_hr_retirement_hdrs (
1000: x_event_code

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

1643: v_err_code := '0';
1644:
1645: -- initializing parameters
1646: v_sysdate:= sysdate;
1647: v_user:= nvl(TO_NUMBER(fnd_profile.value('USER_ID')),-1);
1648: v_last_update_login:= nvl(TO_NUMBER(fnd_profile.value('LOGIN_ID')),-1);
1649:
1650: FOR hrd_rec IN C_hrd LOOP
1651:

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

1644:
1645: -- initializing parameters
1646: v_sysdate:= sysdate;
1647: v_user:= nvl(TO_NUMBER(fnd_profile.value('USER_ID')),-1);
1648: v_last_update_login:= nvl(TO_NUMBER(fnd_profile.value('LOGIN_ID')),-1);
1649:
1650: FOR hrd_rec IN C_hrd LOOP
1651:
1652: --initialize for each loop