APPS.JTF_RS_CONC_RES_PUB dependencies on FND_GLOBAL

Line 2617: l_user_id := nvl(FND_GLOBAL.USER_ID,-1);

2613: l_is_to_be_updated := 'N';
2614: l_update_extn := 'N';
2615: l_rehire_rev_emp_flag := 'N';
2616: l_activate_salesreps := 'N';
2617: l_user_id := nvl(FND_GLOBAL.USER_ID,-1);
2618: l_login := nvl(FND_GLOBAL.LOGIN_ID,-1);
2619:
2620: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2621: debug(p_message=>' update_employee (+)',

Line 2618: l_login := nvl(FND_GLOBAL.LOGIN_ID,-1);

2614: l_update_extn := 'N';
2615: l_rehire_rev_emp_flag := 'N';
2616: l_activate_salesreps := 'N';
2617: l_user_id := nvl(FND_GLOBAL.USER_ID,-1);
2618: l_login := nvl(FND_GLOBAL.LOGIN_ID,-1);
2619:
2620: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2621: debug(p_message=>' update_employee (+)',
2622: p_prefix =>l_debug_prefix,

Line 3447: RES.LAST_UPDATED_BY = fnd_global.user_id,

3443:
3444: begin
3445: UPDATE jtf_rs_resource_extns RES
3446: SET RES.LAST_UPDATE_DATE = sysdate,
3447: RES.LAST_UPDATED_BY = fnd_global.user_id,
3448: (RES.SOURCE_NUMBER ,
3449: RES.SOURCE_NAME ,
3450: RES.SOURCE_PHONE ,
3451: RES.SOURCE_EMAIL ,

Line 3541: RES.LAST_UPDATED_BY = fnd_global.user_id,

3537: fetch fetch_emp_cur into emp_rec;
3538: close fetch_emp_cur;
3539: UPDATE jtf_rs_resource_extns RES
3540: SET RES.LAST_UPDATE_DATE = sysdate,
3541: RES.LAST_UPDATED_BY = fnd_global.user_id,
3542: RES.SOURCE_NUMBER = emp_rec.employee_number ,
3543: RES.SOURCE_NAME = emp_rec.full_name,
3544: RES.SOURCE_PHONE = emp_rec.phone,
3545: RES.SOURCE_EMAIL = emp_rec.email,

Line 3587: RES.LAST_UPDATED_BY = fnd_global.user_id,

3583: BEGIN
3584:
3585: update jtf_rs_resource_extns res
3586: SET RES.LAST_UPDATE_DATE = sysdate,
3587: RES.LAST_UPDATED_BY = fnd_global.user_id,
3588: RES.SOURCE_PHONE
3589: = (select per.phone_number
3590: from per_phones per
3591: where parent_table = 'PER_ALL_PEOPLE_F'

Line 3860: l_user_id := nvl(FND_GLOBAL.USER_ID,-1);

3856:
3857: BEGIN
3858:
3859: l_sysdate := sysdate;
3860: l_user_id := nvl(FND_GLOBAL.USER_ID,-1);
3861: l_login := nvl(FND_GLOBAL.LOGIN_ID,-1);
3862:
3863: -- first populate the address id where address id is null
3864: BEGIN

Line 3861: l_login := nvl(FND_GLOBAL.LOGIN_ID,-1);

3857: BEGIN
3858:
3859: l_sysdate := sysdate;
3860: l_user_id := nvl(FND_GLOBAL.USER_ID,-1);
3861: l_login := nvl(FND_GLOBAL.LOGIN_ID,-1);
3862:
3863: -- first populate the address id where address id is null
3864: BEGIN
3865: UPDATE JTF_RS_RESOURCE_EXTNS RES

Line 4084: l_user_id := nvl(FND_GLOBAL.USER_ID,-1);

4080:
4081: begin
4082:
4083: l_sysdate := sysdate;
4084: l_user_id := nvl(FND_GLOBAL.USER_ID,-1);
4085: l_login := nvl(FND_GLOBAL.LOGIN_ID,-1);
4086:
4087: -- synchronize supp cont
4088:

Line 4085: l_login := nvl(FND_GLOBAL.LOGIN_ID,-1);

4081: begin
4082:
4083: l_sysdate := sysdate;
4084: l_user_id := nvl(FND_GLOBAL.USER_ID,-1);
4085: l_login := nvl(FND_GLOBAL.LOGIN_ID,-1);
4086:
4087: -- synchronize supp cont
4088:
4089: FOR r_res in c_res LOOP