APPS.PA_CANDIDATE_PUB dependencies on FND_USER

Line 225: l_fnd_user_id NUMBER;

221: l_ret_code VARCHAR2(1);
222: l_asmt_start_date DATE;
223: l_resource_type_id NUMBER;
224: l_is_cand_on_asmt VARCHAR2(1) := 'N';
225: l_fnd_user_id NUMBER;
226: l_enable_wf_flag VARCHAR2(1);
227: l_wf_item_type VARCHAR2(30);
228: l_wf_process VARCHAR2(30);
229: l_check_id_flag VARCHAR2(1);

Line 348: l_fnd_user_id := FND_GLOBAL.USER_ID;

344: END IF;
345: END IF;
346:
347: l_nominated_by_person_id := Get_Person_Id;
348: l_fnd_user_id := FND_GLOBAL.USER_ID;
349: ELSE
350: l_resource_id := p_resource_id;
351: l_nominated_by_person_id := null;
352: l_status_code := p_status_code;

Line 353: l_fnd_user_id := -1;

349: ELSE
350: l_resource_id := p_resource_id;
351: l_nominated_by_person_id := null;
352: l_status_code := p_status_code;
353: l_fnd_user_id := -1;
354: END IF;
355:
356: -- Check if candidate Status is passed. If not, get the value from
357: -- the profile

Line 416: l_fnd_user_id,

412: sysdate,
413: p_nomination_comments,
414: null,
415: SYSDATE,
416: l_fnd_user_id,
417: SYSDATE,
418: l_fnd_user_id)
419: RETURNING
420: CANDIDATE_ID into l_candidate_id;

Line 418: l_fnd_user_id)

414: null,
415: SYSDATE,
416: l_fnd_user_id,
417: SYSDATE,
418: l_fnd_user_id)
419: RETURNING
420: CANDIDATE_ID into l_candidate_id;
421: ELSE
422: UPDATE PA_CANDIDATES

Line 429: LAST_UPDATED_BY = l_fnd_user_id

425: RECORD_VERSION_NUMBER = record_version_number + 1,
426: NOMINATED_BY_PERSON_ID = l_nominated_by_person_id,
427: NOMINATION_DATE = SYSDATE,
428: LAST_UPDATE_DATE = SYSDATE,
429: LAST_UPDATED_BY = l_fnd_user_id
430: WHERE assignment_id = p_assignment_id
431: AND resource_id = l_resource_id;
432: END IF;
433:

Line 2406: FROM fnd_user

2402: l_employee_id NUMBER;
2403: BEGIN
2404: SELECT employee_id
2405: INTO l_employee_id
2406: FROM fnd_user
2407: where user_id = FND_GLOBAL.USER_ID;
2408:
2409: RETURN l_employee_id;
2410: