APPS.PA_CANDIDATE_PUB dependencies on FND_USER

Line 246: l_fnd_user_id NUMBER;

242: l_ret_code VARCHAR2(1);
243: l_asmt_start_date DATE;
244: l_resource_type_id NUMBER;
245: l_is_cand_on_asmt VARCHAR2(1) := 'N';
246: l_fnd_user_id NUMBER;
247: l_enable_wf_flag VARCHAR2(1);
248: l_wf_item_type VARCHAR2(30);
249: l_wf_process VARCHAR2(30);
250: l_check_id_flag VARCHAR2(1);

Line 369: l_fnd_user_id := FND_GLOBAL.USER_ID;

365: END IF;
366: END IF;
367:
368: l_nominated_by_person_id := Get_Person_Id;
369: l_fnd_user_id := FND_GLOBAL.USER_ID;
370: ELSE
371: l_resource_id := p_resource_id;
372: l_nominated_by_person_id := null;
373: l_status_code := p_status_code;

Line 374: l_fnd_user_id := -1;

370: ELSE
371: l_resource_id := p_resource_id;
372: l_nominated_by_person_id := null;
373: l_status_code := p_status_code;
374: l_fnd_user_id := -1;
375: END IF;
376:
377: -- Check if candidate Status is passed. If not, get the value from
378: -- the profile

Line 471: l_fnd_user_id,

467: p_attribute12,
468: p_attribute13,
469: p_attribute14,
470: p_attribute15,
471: l_fnd_user_id,
472: SYSDATE,
473: l_fnd_user_id)
474: RETURNING
475: CANDIDATE_ID into l_candidate_id;

Line 473: l_fnd_user_id)

469: p_attribute14,
470: p_attribute15,
471: l_fnd_user_id,
472: SYSDATE,
473: l_fnd_user_id)
474: RETURNING
475: CANDIDATE_ID into l_candidate_id;
476: ELSE
477: UPDATE PA_CANDIDATES

Line 484: LAST_UPDATED_BY = l_fnd_user_id

480: RECORD_VERSION_NUMBER = record_version_number + 1,
481: NOMINATED_BY_PERSON_ID = l_nominated_by_person_id,
482: NOMINATION_DATE = SYSDATE,
483: LAST_UPDATE_DATE = SYSDATE,
484: LAST_UPDATED_BY = l_fnd_user_id
485: WHERE assignment_id = p_assignment_id
486: AND resource_id = l_resource_id;
487: END IF;
488:

Line 2669: FROM fnd_user

2665: l_employee_id NUMBER;
2666: BEGIN
2667: SELECT employee_id
2668: INTO l_employee_id
2669: FROM fnd_user
2670: where user_id = FND_GLOBAL.USER_ID;
2671:
2672: RETURN l_employee_id;
2673: