[Home] [Help]
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;
1170: UPDATE pa_candidates
1171: SET status_code = l_status_code,
1172: record_version_number = record_version_number + 1,
1173: LAST_UPDATE_DATE = SYSDATE,
1174: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1175: -- start for bug#9468526, Added nvl such that, if the passed value is null, existing one is retained.
1176: attribute_category = nvl(p_attribute_category,attribute_category),
1177: attribute1 = nvl(p_attribute1,attribute1),
1178: attribute2 = nvl(p_attribute2,attribute2),
1295: p_attribute12,
1296: p_attribute13,
1297: p_attribute14,
1298: p_attribute15,
1299: FND_GLOBAL.user_id,
1300: sysdate,
1301: FND_GLOBAL.user_id
1302: );
1303:
1297: p_attribute14,
1298: p_attribute15,
1299: FND_GLOBAL.user_id,
1300: sysdate,
1301: FND_GLOBAL.user_id
1302: );
1303:
1304: -- Check is the status change needs a workflow to be started
1305: IF l_system_status_code <> l_old_system_status_code THEN
1574: status_code = l_status_code,
1575: candidate_ranking = p_ranking,
1576: record_version_number = p_record_version_number+1,
1577: LAST_UPDATE_DATE = SYSDATE,
1578: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1579: -- start for bug#9468526, Added nvl such that, if the passed value is null, existing one is retained.
1580: attribute_category = nvl(p_attribute_category,attribute_category),
1581: attribute1 = nvl(p_attribute1,attribute1),
1582: attribute2 = nvl(p_attribute2,attribute2),
1663: p_attribute12,
1664: p_attribute13,
1665: p_attribute14,
1666: p_attribute15,
1667: FND_GLOBAL.user_id,
1668: sysdate,
1669: FND_GLOBAL.user_id
1670: );
1671:
1665: p_attribute14,
1666: p_attribute15,
1667: FND_GLOBAL.user_id,
1668: sysdate,
1669: FND_GLOBAL.user_id
1670: );
1671:
1672: -- Update No_Of_Active_Candidates in PA_PROJECT_ASSIGNMENTS
1673: Update_No_Of_Active_Candidates(
2368:
2369: -- loop for l_out_nf_recipients_rec to generate l_role_name with recipients which has
2370: -- been passed by client extension procedure
2371: FOR I in 1..l_out_nf_recipients_rec.count LOOP
2372: IF FND_GLOBAL.USER_NAME <> l_out_nf_recipients_rec(l_out_recp_rec_index).User_Name THEN
2373:
2374: l_count_recipients := l_count_recipients + 1 ; -- added for bug 6144224
2375: IF l_role_users is not null THEN
2376: l_role_users := l_role_users || ',' || l_out_nf_recipients_rec(l_out_recp_rec_index).User_Name;
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:
2674: EXCEPTION
2952: c2.nomination_date,
2953: c2.nomination_comments,
2954: c2.candidate_ranking,
2955: SYSDATE,
2956: FND_GLOBAL.USER_ID,
2957: SYSDATE,
2958: FND_GLOBAL.USER_ID)
2959: RETURNING
2960: CANDIDATE_ID into l_new_candidate_id;
2954: c2.candidate_ranking,
2955: SYSDATE,
2956: FND_GLOBAL.USER_ID,
2957: SYSDATE,
2958: FND_GLOBAL.USER_ID)
2959: RETURNING
2960: CANDIDATE_ID into l_new_candidate_id;
2961:
2962: FOR c4 in c3 LOOP
2983: c4.review_date,
2984: c4.change_reason_code,
2985: c4.review_comments,
2986: sysdate,
2987: FND_GLOBAL.user_id,
2988: sysdate,
2989: FND_GLOBAL.user_id
2990: );
2991: END LOOP;
2985: c4.review_comments,
2986: sysdate,
2987: FND_GLOBAL.user_id,
2988: sysdate,
2989: FND_GLOBAL.user_id
2990: );
2991: END LOOP;
2992: END LOOP;
2993:
3150: UPDATE pa_candidates SET
3151: status_code = l_decline_status_code,
3152: record_version_number = l_record_version_number_tbl(i) + 1,
3153: LAST_UPDATE_DATE = SYSDATE,
3154: LAST_UPDATED_BY = FND_GLOBAL.USER_ID
3155: WHERE candidate_id = l_candidate_id_tbl(i);
3156:
3157: -- Change reason code is not supplied in this case
3158:
3178: sysdate,
3179: null,
3180: null,
3181: sysdate,
3182: FND_GLOBAL.user_id,
3183: sysdate,
3184: FND_GLOBAL.user_id
3185: );
3186:
3180: null,
3181: sysdate,
3182: FND_GLOBAL.user_id,
3183: sysdate,
3184: FND_GLOBAL.user_id
3185: );
3186:
3187: IF p_launch_wf = 'Y' AND l_enable_wf_flag = 'Y' AND
3188: l_wf_item_type IS NOT NULL AND l_wf_process IS NOT NULL THEN