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;
1040: UPDATE pa_candidates
1041: SET status_code = l_status_code,
1042: record_version_number = record_version_number + 1,
1043: LAST_UPDATE_DATE = SYSDATE,
1044: LAST_UPDATED_BY = FND_GLOBAL.USER_ID
1045: WHERE candidate_id = p_candidate_id AND
1046: record_version_number=p_cand_record_version_number;
1047:
1048: -- Since pa_candidates has been updated, set the increased record version number to the local
1113: sysdate,
1114: l_change_reason_code,
1115: l_review_comments,
1116: sysdate,
1117: FND_GLOBAL.user_id,
1118: sysdate,
1119: FND_GLOBAL.user_id
1120: );
1121:
1115: l_review_comments,
1116: sysdate,
1117: FND_GLOBAL.user_id,
1118: sysdate,
1119: FND_GLOBAL.user_id
1120: );
1121:
1122: -- Check is the status change needs a workflow to be started
1123: IF l_system_status_code <> l_old_system_status_code THEN
1372: status_code = l_status_code,
1373: candidate_ranking = p_ranking,
1374: record_version_number = p_record_version_number+1,
1375: LAST_UPDATE_DATE = SYSDATE,
1376: LAST_UPDATED_BY = FND_GLOBAL.USER_ID
1377: WHERE
1378: candidate_id = p_candidate_id AND
1379: record_version_number = p_record_version_number;
1380:
1409: sysdate,
1410: null,
1411: l_change_reason_code,
1412: sysdate,
1413: FND_GLOBAL.user_id,
1414: sysdate,
1415: FND_GLOBAL.user_id
1416: );
1417:
1411: l_change_reason_code,
1412: sysdate,
1413: FND_GLOBAL.user_id,
1414: sysdate,
1415: FND_GLOBAL.user_id
1416: );
1417:
1418: -- Update No_Of_Active_Candidates in PA_PROJECT_ASSIGNMENTS
1419: Update_No_Of_Active_Candidates(
2105:
2106: -- loop for l_out_nf_recipients_rec to generate l_role_name with recipients which has
2107: -- been passed by client extension procedure
2108: FOR I in 1..l_out_nf_recipients_rec.count LOOP
2109: IF FND_GLOBAL.USER_NAME <> l_out_nf_recipients_rec(l_out_recp_rec_index).User_Name THEN
2110:
2111: l_count_recipients := l_count_recipients + 1 ; -- added for bug 6144224
2112: IF l_role_users is not null THEN
2113: l_role_users := l_role_users || ',' || l_out_nf_recipients_rec(l_out_recp_rec_index).User_Name;
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:
2411: EXCEPTION
2689: c2.nomination_date,
2690: c2.nomination_comments,
2691: c2.candidate_ranking,
2692: SYSDATE,
2693: FND_GLOBAL.USER_ID,
2694: SYSDATE,
2695: FND_GLOBAL.USER_ID)
2696: RETURNING
2697: CANDIDATE_ID into l_new_candidate_id;
2691: c2.candidate_ranking,
2692: SYSDATE,
2693: FND_GLOBAL.USER_ID,
2694: SYSDATE,
2695: FND_GLOBAL.USER_ID)
2696: RETURNING
2697: CANDIDATE_ID into l_new_candidate_id;
2698:
2699: FOR c4 in c3 LOOP
2720: c4.review_date,
2721: c4.change_reason_code,
2722: c4.review_comments,
2723: sysdate,
2724: FND_GLOBAL.user_id,
2725: sysdate,
2726: FND_GLOBAL.user_id
2727: );
2728: END LOOP;
2722: c4.review_comments,
2723: sysdate,
2724: FND_GLOBAL.user_id,
2725: sysdate,
2726: FND_GLOBAL.user_id
2727: );
2728: END LOOP;
2729: END LOOP;
2730:
2887: UPDATE pa_candidates SET
2888: status_code = l_decline_status_code,
2889: record_version_number = l_record_version_number_tbl(i) + 1,
2890: LAST_UPDATE_DATE = SYSDATE,
2891: LAST_UPDATED_BY = FND_GLOBAL.USER_ID
2892: WHERE candidate_id = l_candidate_id_tbl(i);
2893:
2894: -- Change reason code is not supplied in this case
2895:
2915: sysdate,
2916: null,
2917: null,
2918: sysdate,
2919: FND_GLOBAL.user_id,
2920: sysdate,
2921: FND_GLOBAL.user_id
2922: );
2923:
2917: null,
2918: sysdate,
2919: FND_GLOBAL.user_id,
2920: sysdate,
2921: FND_GLOBAL.user_id
2922: );
2923:
2924: IF p_launch_wf = 'Y' AND l_enable_wf_flag = 'Y' AND
2925: l_wf_item_type IS NOT NULL AND l_wf_process IS NOT NULL THEN