2182: l_is_to_be_updated := 'N';
2183: l_update_extn := 'N';
2184: l_rehire_rev_emp_flag := 'N';
2185: l_activate_salesreps := 'N';
2186: l_user_id := nvl(FND_GLOBAL.USER_ID,-1);
2187: l_login := nvl(FND_GLOBAL.LOGIN_ID,-1);
2188:
2189: --Standard Start of API SAVEPOINT
2190:
2183: l_update_extn := 'N';
2184: l_rehire_rev_emp_flag := 'N';
2185: l_activate_salesreps := 'N';
2186: l_user_id := nvl(FND_GLOBAL.USER_ID,-1);
2187: l_login := nvl(FND_GLOBAL.LOGIN_ID,-1);
2188:
2189: --Standard Start of API SAVEPOINT
2190:
2191: SAVEPOINT UPDATE_EMPLOYEE_SP;
2992:
2993: begin
2994: UPDATE jtf_rs_resource_extns RES
2995: SET RES.LAST_UPDATE_DATE = sysdate,
2996: RES.LAST_UPDATED_BY = fnd_global.user_id,
2997: (RES.SOURCE_NUMBER ,
2998: RES.SOURCE_NAME ,
2999: RES.SOURCE_PHONE ,
3000: RES.SOURCE_EMAIL ,
3086: fetch fetch_emp_cur into emp_rec;
3087: close fetch_emp_cur;
3088: UPDATE jtf_rs_resource_extns RES
3089: SET RES.LAST_UPDATE_DATE = sysdate,
3090: RES.LAST_UPDATED_BY = fnd_global.user_id,
3091: RES.SOURCE_NUMBER = emp_rec.employee_number ,
3092: RES.SOURCE_NAME = emp_rec.full_name,
3093: RES.SOURCE_PHONE = emp_rec.phone,
3094: RES.SOURCE_EMAIL = emp_rec.email,
3132: BEGIN
3133:
3134: update jtf_rs_resource_extns res
3135: SET RES.LAST_UPDATE_DATE = sysdate,
3136: RES.LAST_UPDATED_BY = fnd_global.user_id,
3137: RES.SOURCE_PHONE
3138: = (select per.phone_number
3139: from per_phones per
3140: where parent_table = 'PER_ALL_PEOPLE_F'
3405:
3406: BEGIN
3407:
3408: l_sysdate := sysdate;
3409: l_user_id := nvl(FND_GLOBAL.USER_ID,-1);
3410: l_login := nvl(FND_GLOBAL.LOGIN_ID,-1);
3411:
3412: -- first populate the address id where address id is null
3413: BEGIN
3406: BEGIN
3407:
3408: l_sysdate := sysdate;
3409: l_user_id := nvl(FND_GLOBAL.USER_ID,-1);
3410: l_login := nvl(FND_GLOBAL.LOGIN_ID,-1);
3411:
3412: -- first populate the address id where address id is null
3413: BEGIN
3414: UPDATE JTF_RS_RESOURCE_EXTNS RES
3631:
3632: begin
3633:
3634: l_sysdate := sysdate;
3635: l_user_id := nvl(FND_GLOBAL.USER_ID,-1);
3636: l_login := nvl(FND_GLOBAL.LOGIN_ID,-1);
3637:
3638: -- synchronize supp cont
3639:
3632: begin
3633:
3634: l_sysdate := sysdate;
3635: l_user_id := nvl(FND_GLOBAL.USER_ID,-1);
3636: l_login := nvl(FND_GLOBAL.LOGIN_ID,-1);
3637:
3638: -- synchronize supp cont
3639:
3640: FOR r_res in c_res LOOP