eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_CANDIDATE_PUB dependencies on PA_CANDIDATES

Line 17: FROM pa_candidates

13: l_no_of_candidates NUMBER := 0;
14: BEGIN
15: SELECT count(*)
16: into l_no_of_candidates
17: FROM pa_candidates
18: where assignment_id = g_assignment_id
19: AND status_code = p_project_status_code;
20:
21: RETURN l_no_of_candidates;

Line 34: FROM pa_candidates

30: l_no_of_candidates NUMBER := 0;
31: BEGIN
32: SELECT count(*)
33: into l_no_of_candidates
34: FROM pa_candidates
35: where assignment_id = g_assignment_id
36: and status_code in ('UNDER_REVIEW','SUITABLE');
37:
38: RETURN l_no_of_candidates;

Line 52: FROM pa_candidates

48: l_exists VARCHAR2(1) := 'N';
49: BEGIN
50: SELECT 'Y'
51: into l_exists
52: FROM pa_candidates
53: WHERE resource_id=p_resource_id
54: AND assignment_id = p_assignment_id;
55:
56: RETURN 'Y';

Line 87: FROM pa_candidates pc,

83: BEGIN
84: --Bug 8295734: For active candidate project_system_status_code should not be CANDIDATE_ASSIGNED
85: SELECT 'Y'
86: INTO l_exists
87: FROM pa_candidates pc,
88: pa_project_statuses pps
89: WHERE pc.resource_id = p_resource_id
90: AND pc.assignment_id <> p_assignment_id
91: AND pc.status_code = pps.project_status_code

Line 148: FROM pa_candidates

144: BEGIN
145: IF p_status_code IS NULL THEN
146: SELECT 'Y'
147: INTO l_exists
148: FROM pa_candidates
149: WHERE resource_id = p_resource_id
150: AND assignment_id = p_assignment_id;
151: ELSE
152: SELECT project_system_status_code

Line 154: FROM pa_candidates, pa_project_statuses

150: AND assignment_id = p_assignment_id;
151: ELSE
152: SELECT project_system_status_code
153: INTO l_old_project_system_status
154: FROM pa_candidates, pa_project_statuses
155: WHERE resource_id = p_resource_id
156: AND assignment_id = p_assignment_id
157: AND status_code = project_status_code
158: AND status_type = 'CANDIDATE';

Line 208: p_attribute_category IN pa_candidates.attribute_category%TYPE,

204: p_privilege_name IN VARCHAR2 DEFAULT NULL,
205: p_project_super_user IN VARCHAR2 DEFAULT 'N',
206: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE, -- Added for Bug 5130421: PJR Enhancements for Public APIs
207: -- Added for bug 9187892
208: p_attribute_category IN pa_candidates.attribute_category%TYPE,
209: p_attribute1 IN pa_candidates.attribute1%TYPE,
210: p_attribute2 IN pa_candidates.attribute2%TYPE,
211: p_attribute3 IN pa_candidates.attribute3%TYPE,
212: p_attribute4 IN pa_candidates.attribute4%TYPE,

Line 209: p_attribute1 IN pa_candidates.attribute1%TYPE,

205: p_project_super_user IN VARCHAR2 DEFAULT 'N',
206: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE, -- Added for Bug 5130421: PJR Enhancements for Public APIs
207: -- Added for bug 9187892
208: p_attribute_category IN pa_candidates.attribute_category%TYPE,
209: p_attribute1 IN pa_candidates.attribute1%TYPE,
210: p_attribute2 IN pa_candidates.attribute2%TYPE,
211: p_attribute3 IN pa_candidates.attribute3%TYPE,
212: p_attribute4 IN pa_candidates.attribute4%TYPE,
213: p_attribute5 IN pa_candidates.attribute5%TYPE,

Line 210: p_attribute2 IN pa_candidates.attribute2%TYPE,

206: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE, -- Added for Bug 5130421: PJR Enhancements for Public APIs
207: -- Added for bug 9187892
208: p_attribute_category IN pa_candidates.attribute_category%TYPE,
209: p_attribute1 IN pa_candidates.attribute1%TYPE,
210: p_attribute2 IN pa_candidates.attribute2%TYPE,
211: p_attribute3 IN pa_candidates.attribute3%TYPE,
212: p_attribute4 IN pa_candidates.attribute4%TYPE,
213: p_attribute5 IN pa_candidates.attribute5%TYPE,
214: p_attribute6 IN pa_candidates.attribute6%TYPE,

Line 211: p_attribute3 IN pa_candidates.attribute3%TYPE,

207: -- Added for bug 9187892
208: p_attribute_category IN pa_candidates.attribute_category%TYPE,
209: p_attribute1 IN pa_candidates.attribute1%TYPE,
210: p_attribute2 IN pa_candidates.attribute2%TYPE,
211: p_attribute3 IN pa_candidates.attribute3%TYPE,
212: p_attribute4 IN pa_candidates.attribute4%TYPE,
213: p_attribute5 IN pa_candidates.attribute5%TYPE,
214: p_attribute6 IN pa_candidates.attribute6%TYPE,
215: p_attribute7 IN pa_candidates.attribute7%TYPE,

Line 212: p_attribute4 IN pa_candidates.attribute4%TYPE,

208: p_attribute_category IN pa_candidates.attribute_category%TYPE,
209: p_attribute1 IN pa_candidates.attribute1%TYPE,
210: p_attribute2 IN pa_candidates.attribute2%TYPE,
211: p_attribute3 IN pa_candidates.attribute3%TYPE,
212: p_attribute4 IN pa_candidates.attribute4%TYPE,
213: p_attribute5 IN pa_candidates.attribute5%TYPE,
214: p_attribute6 IN pa_candidates.attribute6%TYPE,
215: p_attribute7 IN pa_candidates.attribute7%TYPE,
216: p_attribute8 IN pa_candidates.attribute8%TYPE,

Line 213: p_attribute5 IN pa_candidates.attribute5%TYPE,

209: p_attribute1 IN pa_candidates.attribute1%TYPE,
210: p_attribute2 IN pa_candidates.attribute2%TYPE,
211: p_attribute3 IN pa_candidates.attribute3%TYPE,
212: p_attribute4 IN pa_candidates.attribute4%TYPE,
213: p_attribute5 IN pa_candidates.attribute5%TYPE,
214: p_attribute6 IN pa_candidates.attribute6%TYPE,
215: p_attribute7 IN pa_candidates.attribute7%TYPE,
216: p_attribute8 IN pa_candidates.attribute8%TYPE,
217: p_attribute9 IN pa_candidates.attribute9%TYPE,

Line 214: p_attribute6 IN pa_candidates.attribute6%TYPE,

210: p_attribute2 IN pa_candidates.attribute2%TYPE,
211: p_attribute3 IN pa_candidates.attribute3%TYPE,
212: p_attribute4 IN pa_candidates.attribute4%TYPE,
213: p_attribute5 IN pa_candidates.attribute5%TYPE,
214: p_attribute6 IN pa_candidates.attribute6%TYPE,
215: p_attribute7 IN pa_candidates.attribute7%TYPE,
216: p_attribute8 IN pa_candidates.attribute8%TYPE,
217: p_attribute9 IN pa_candidates.attribute9%TYPE,
218: p_attribute10 IN pa_candidates.attribute10%TYPE,

Line 215: p_attribute7 IN pa_candidates.attribute7%TYPE,

211: p_attribute3 IN pa_candidates.attribute3%TYPE,
212: p_attribute4 IN pa_candidates.attribute4%TYPE,
213: p_attribute5 IN pa_candidates.attribute5%TYPE,
214: p_attribute6 IN pa_candidates.attribute6%TYPE,
215: p_attribute7 IN pa_candidates.attribute7%TYPE,
216: p_attribute8 IN pa_candidates.attribute8%TYPE,
217: p_attribute9 IN pa_candidates.attribute9%TYPE,
218: p_attribute10 IN pa_candidates.attribute10%TYPE,
219: p_attribute11 IN pa_candidates.attribute11%TYPE,

Line 216: p_attribute8 IN pa_candidates.attribute8%TYPE,

212: p_attribute4 IN pa_candidates.attribute4%TYPE,
213: p_attribute5 IN pa_candidates.attribute5%TYPE,
214: p_attribute6 IN pa_candidates.attribute6%TYPE,
215: p_attribute7 IN pa_candidates.attribute7%TYPE,
216: p_attribute8 IN pa_candidates.attribute8%TYPE,
217: p_attribute9 IN pa_candidates.attribute9%TYPE,
218: p_attribute10 IN pa_candidates.attribute10%TYPE,
219: p_attribute11 IN pa_candidates.attribute11%TYPE,
220: p_attribute12 IN pa_candidates.attribute12%TYPE,

Line 217: p_attribute9 IN pa_candidates.attribute9%TYPE,

213: p_attribute5 IN pa_candidates.attribute5%TYPE,
214: p_attribute6 IN pa_candidates.attribute6%TYPE,
215: p_attribute7 IN pa_candidates.attribute7%TYPE,
216: p_attribute8 IN pa_candidates.attribute8%TYPE,
217: p_attribute9 IN pa_candidates.attribute9%TYPE,
218: p_attribute10 IN pa_candidates.attribute10%TYPE,
219: p_attribute11 IN pa_candidates.attribute11%TYPE,
220: p_attribute12 IN pa_candidates.attribute12%TYPE,
221: p_attribute13 IN pa_candidates.attribute13%TYPE,

Line 218: p_attribute10 IN pa_candidates.attribute10%TYPE,

214: p_attribute6 IN pa_candidates.attribute6%TYPE,
215: p_attribute7 IN pa_candidates.attribute7%TYPE,
216: p_attribute8 IN pa_candidates.attribute8%TYPE,
217: p_attribute9 IN pa_candidates.attribute9%TYPE,
218: p_attribute10 IN pa_candidates.attribute10%TYPE,
219: p_attribute11 IN pa_candidates.attribute11%TYPE,
220: p_attribute12 IN pa_candidates.attribute12%TYPE,
221: p_attribute13 IN pa_candidates.attribute13%TYPE,
222: p_attribute14 IN pa_candidates.attribute14%TYPE,

Line 219: p_attribute11 IN pa_candidates.attribute11%TYPE,

215: p_attribute7 IN pa_candidates.attribute7%TYPE,
216: p_attribute8 IN pa_candidates.attribute8%TYPE,
217: p_attribute9 IN pa_candidates.attribute9%TYPE,
218: p_attribute10 IN pa_candidates.attribute10%TYPE,
219: p_attribute11 IN pa_candidates.attribute11%TYPE,
220: p_attribute12 IN pa_candidates.attribute12%TYPE,
221: p_attribute13 IN pa_candidates.attribute13%TYPE,
222: p_attribute14 IN pa_candidates.attribute14%TYPE,
223: p_attribute15 IN pa_candidates.attribute15%TYPE,

Line 220: p_attribute12 IN pa_candidates.attribute12%TYPE,

216: p_attribute8 IN pa_candidates.attribute8%TYPE,
217: p_attribute9 IN pa_candidates.attribute9%TYPE,
218: p_attribute10 IN pa_candidates.attribute10%TYPE,
219: p_attribute11 IN pa_candidates.attribute11%TYPE,
220: p_attribute12 IN pa_candidates.attribute12%TYPE,
221: p_attribute13 IN pa_candidates.attribute13%TYPE,
222: p_attribute14 IN pa_candidates.attribute14%TYPE,
223: p_attribute15 IN pa_candidates.attribute15%TYPE,
224: x_return_status OUT NOCOPY VARCHAR2, -- 4537865

Line 221: p_attribute13 IN pa_candidates.attribute13%TYPE,

217: p_attribute9 IN pa_candidates.attribute9%TYPE,
218: p_attribute10 IN pa_candidates.attribute10%TYPE,
219: p_attribute11 IN pa_candidates.attribute11%TYPE,
220: p_attribute12 IN pa_candidates.attribute12%TYPE,
221: p_attribute13 IN pa_candidates.attribute13%TYPE,
222: p_attribute14 IN pa_candidates.attribute14%TYPE,
223: p_attribute15 IN pa_candidates.attribute15%TYPE,
224: x_return_status OUT NOCOPY VARCHAR2, -- 4537865
225: x_msg_count OUT NOCOPY NUMBER, -- 4537865

Line 222: p_attribute14 IN pa_candidates.attribute14%TYPE,

218: p_attribute10 IN pa_candidates.attribute10%TYPE,
219: p_attribute11 IN pa_candidates.attribute11%TYPE,
220: p_attribute12 IN pa_candidates.attribute12%TYPE,
221: p_attribute13 IN pa_candidates.attribute13%TYPE,
222: p_attribute14 IN pa_candidates.attribute14%TYPE,
223: p_attribute15 IN pa_candidates.attribute15%TYPE,
224: x_return_status OUT NOCOPY VARCHAR2, -- 4537865
225: x_msg_count OUT NOCOPY NUMBER, -- 4537865
226: x_msg_data OUT NOCOPY VARCHAR2) -- 4537865

Line 223: p_attribute15 IN pa_candidates.attribute15%TYPE,

219: p_attribute11 IN pa_candidates.attribute11%TYPE,
220: p_attribute12 IN pa_candidates.attribute12%TYPE,
221: p_attribute13 IN pa_candidates.attribute13%TYPE,
222: p_attribute14 IN pa_candidates.attribute14%TYPE,
223: p_attribute15 IN pa_candidates.attribute15%TYPE,
224: x_return_status OUT NOCOPY VARCHAR2, -- 4537865
225: x_msg_count OUT NOCOPY NUMBER, -- 4537865
226: x_msg_data OUT NOCOPY VARCHAR2) -- 4537865
227: IS

Line 412: INSERT INTO PA_CANDIDATES

408: END IF;
409:
410: IF l_is_cand_on_asmt = 'N' THEN
411: -- Insert into the candidate table.
412: INSERT INTO PA_CANDIDATES
413: (CANDIDATE_ID,
414: ASSIGNMENT_ID,
415: RESOURCE_ID,
416: RECORD_VERSION_NUMBER,

Line 444: (PA_CANDIDATES_S.nextval,

440: CREATED_BY,
441: LAST_UPDATE_DATE,
442: LAST_UPDATED_BY)
443: VALUES
444: (PA_CANDIDATES_S.nextval,
445: p_ASSIGNMENT_ID,
446: l_RESOURCE_ID,
447: 1,
448: l_status_code,

Line 477: UPDATE PA_CANDIDATES

473: l_fnd_user_id)
474: RETURNING
475: CANDIDATE_ID into l_candidate_id;
476: ELSE
477: UPDATE PA_CANDIDATES
478: SET STATUS_CODE = l_status_code,
479: NOMINATION_COMMENTS = p_nomination_comments,
480: RECORD_VERSION_NUMBER = record_version_number + 1,
481: NOMINATED_BY_PERSON_ID = l_nominated_by_person_id,

Line 672: p_attribute_category IN pa_candidates.attribute_category%TYPE :=NULL ,

668: p_change_reason_code IN VARCHAR2,
669: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
670: -- Added for bug 9187892
671: -- start for bug#9468526 , Added default null values
672: p_attribute_category IN pa_candidates.attribute_category%TYPE :=NULL ,
673: p_attribute1 IN pa_candidates.attribute1%TYPE :=NULL ,
674: p_attribute2 IN pa_candidates.attribute2%TYPE :=NULL ,
675: p_attribute3 IN pa_candidates.attribute3%TYPE :=NULL ,
676: p_attribute4 IN pa_candidates.attribute4%TYPE :=NULL ,

Line 673: p_attribute1 IN pa_candidates.attribute1%TYPE :=NULL ,

669: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
670: -- Added for bug 9187892
671: -- start for bug#9468526 , Added default null values
672: p_attribute_category IN pa_candidates.attribute_category%TYPE :=NULL ,
673: p_attribute1 IN pa_candidates.attribute1%TYPE :=NULL ,
674: p_attribute2 IN pa_candidates.attribute2%TYPE :=NULL ,
675: p_attribute3 IN pa_candidates.attribute3%TYPE :=NULL ,
676: p_attribute4 IN pa_candidates.attribute4%TYPE :=NULL ,
677: p_attribute5 IN pa_candidates.attribute5%TYPE :=NULL ,

Line 674: p_attribute2 IN pa_candidates.attribute2%TYPE :=NULL ,

670: -- Added for bug 9187892
671: -- start for bug#9468526 , Added default null values
672: p_attribute_category IN pa_candidates.attribute_category%TYPE :=NULL ,
673: p_attribute1 IN pa_candidates.attribute1%TYPE :=NULL ,
674: p_attribute2 IN pa_candidates.attribute2%TYPE :=NULL ,
675: p_attribute3 IN pa_candidates.attribute3%TYPE :=NULL ,
676: p_attribute4 IN pa_candidates.attribute4%TYPE :=NULL ,
677: p_attribute5 IN pa_candidates.attribute5%TYPE :=NULL ,
678: p_attribute6 IN pa_candidates.attribute6%TYPE :=NULL ,

Line 675: p_attribute3 IN pa_candidates.attribute3%TYPE :=NULL ,

671: -- start for bug#9468526 , Added default null values
672: p_attribute_category IN pa_candidates.attribute_category%TYPE :=NULL ,
673: p_attribute1 IN pa_candidates.attribute1%TYPE :=NULL ,
674: p_attribute2 IN pa_candidates.attribute2%TYPE :=NULL ,
675: p_attribute3 IN pa_candidates.attribute3%TYPE :=NULL ,
676: p_attribute4 IN pa_candidates.attribute4%TYPE :=NULL ,
677: p_attribute5 IN pa_candidates.attribute5%TYPE :=NULL ,
678: p_attribute6 IN pa_candidates.attribute6%TYPE :=NULL ,
679: p_attribute7 IN pa_candidates.attribute7%TYPE :=NULL ,

Line 676: p_attribute4 IN pa_candidates.attribute4%TYPE :=NULL ,

672: p_attribute_category IN pa_candidates.attribute_category%TYPE :=NULL ,
673: p_attribute1 IN pa_candidates.attribute1%TYPE :=NULL ,
674: p_attribute2 IN pa_candidates.attribute2%TYPE :=NULL ,
675: p_attribute3 IN pa_candidates.attribute3%TYPE :=NULL ,
676: p_attribute4 IN pa_candidates.attribute4%TYPE :=NULL ,
677: p_attribute5 IN pa_candidates.attribute5%TYPE :=NULL ,
678: p_attribute6 IN pa_candidates.attribute6%TYPE :=NULL ,
679: p_attribute7 IN pa_candidates.attribute7%TYPE :=NULL ,
680: p_attribute8 IN pa_candidates.attribute8%TYPE :=NULL ,

Line 677: p_attribute5 IN pa_candidates.attribute5%TYPE :=NULL ,

673: p_attribute1 IN pa_candidates.attribute1%TYPE :=NULL ,
674: p_attribute2 IN pa_candidates.attribute2%TYPE :=NULL ,
675: p_attribute3 IN pa_candidates.attribute3%TYPE :=NULL ,
676: p_attribute4 IN pa_candidates.attribute4%TYPE :=NULL ,
677: p_attribute5 IN pa_candidates.attribute5%TYPE :=NULL ,
678: p_attribute6 IN pa_candidates.attribute6%TYPE :=NULL ,
679: p_attribute7 IN pa_candidates.attribute7%TYPE :=NULL ,
680: p_attribute8 IN pa_candidates.attribute8%TYPE :=NULL ,
681: p_attribute9 IN pa_candidates.attribute9%TYPE :=NULL ,

Line 678: p_attribute6 IN pa_candidates.attribute6%TYPE :=NULL ,

674: p_attribute2 IN pa_candidates.attribute2%TYPE :=NULL ,
675: p_attribute3 IN pa_candidates.attribute3%TYPE :=NULL ,
676: p_attribute4 IN pa_candidates.attribute4%TYPE :=NULL ,
677: p_attribute5 IN pa_candidates.attribute5%TYPE :=NULL ,
678: p_attribute6 IN pa_candidates.attribute6%TYPE :=NULL ,
679: p_attribute7 IN pa_candidates.attribute7%TYPE :=NULL ,
680: p_attribute8 IN pa_candidates.attribute8%TYPE :=NULL ,
681: p_attribute9 IN pa_candidates.attribute9%TYPE :=NULL ,
682: p_attribute10 IN pa_candidates.attribute10%TYPE :=NULL ,

Line 679: p_attribute7 IN pa_candidates.attribute7%TYPE :=NULL ,

675: p_attribute3 IN pa_candidates.attribute3%TYPE :=NULL ,
676: p_attribute4 IN pa_candidates.attribute4%TYPE :=NULL ,
677: p_attribute5 IN pa_candidates.attribute5%TYPE :=NULL ,
678: p_attribute6 IN pa_candidates.attribute6%TYPE :=NULL ,
679: p_attribute7 IN pa_candidates.attribute7%TYPE :=NULL ,
680: p_attribute8 IN pa_candidates.attribute8%TYPE :=NULL ,
681: p_attribute9 IN pa_candidates.attribute9%TYPE :=NULL ,
682: p_attribute10 IN pa_candidates.attribute10%TYPE :=NULL ,
683: p_attribute11 IN pa_candidates.attribute11%TYPE :=NULL ,

Line 680: p_attribute8 IN pa_candidates.attribute8%TYPE :=NULL ,

676: p_attribute4 IN pa_candidates.attribute4%TYPE :=NULL ,
677: p_attribute5 IN pa_candidates.attribute5%TYPE :=NULL ,
678: p_attribute6 IN pa_candidates.attribute6%TYPE :=NULL ,
679: p_attribute7 IN pa_candidates.attribute7%TYPE :=NULL ,
680: p_attribute8 IN pa_candidates.attribute8%TYPE :=NULL ,
681: p_attribute9 IN pa_candidates.attribute9%TYPE :=NULL ,
682: p_attribute10 IN pa_candidates.attribute10%TYPE :=NULL ,
683: p_attribute11 IN pa_candidates.attribute11%TYPE :=NULL ,
684: p_attribute12 IN pa_candidates.attribute12%TYPE :=NULL ,

Line 681: p_attribute9 IN pa_candidates.attribute9%TYPE :=NULL ,

677: p_attribute5 IN pa_candidates.attribute5%TYPE :=NULL ,
678: p_attribute6 IN pa_candidates.attribute6%TYPE :=NULL ,
679: p_attribute7 IN pa_candidates.attribute7%TYPE :=NULL ,
680: p_attribute8 IN pa_candidates.attribute8%TYPE :=NULL ,
681: p_attribute9 IN pa_candidates.attribute9%TYPE :=NULL ,
682: p_attribute10 IN pa_candidates.attribute10%TYPE :=NULL ,
683: p_attribute11 IN pa_candidates.attribute11%TYPE :=NULL ,
684: p_attribute12 IN pa_candidates.attribute12%TYPE :=NULL ,
685: p_attribute13 IN pa_candidates.attribute13%TYPE :=NULL ,

Line 682: p_attribute10 IN pa_candidates.attribute10%TYPE :=NULL ,

678: p_attribute6 IN pa_candidates.attribute6%TYPE :=NULL ,
679: p_attribute7 IN pa_candidates.attribute7%TYPE :=NULL ,
680: p_attribute8 IN pa_candidates.attribute8%TYPE :=NULL ,
681: p_attribute9 IN pa_candidates.attribute9%TYPE :=NULL ,
682: p_attribute10 IN pa_candidates.attribute10%TYPE :=NULL ,
683: p_attribute11 IN pa_candidates.attribute11%TYPE :=NULL ,
684: p_attribute12 IN pa_candidates.attribute12%TYPE :=NULL ,
685: p_attribute13 IN pa_candidates.attribute13%TYPE :=NULL ,
686: p_attribute14 IN pa_candidates.attribute14%TYPE :=NULL ,

Line 683: p_attribute11 IN pa_candidates.attribute11%TYPE :=NULL ,

679: p_attribute7 IN pa_candidates.attribute7%TYPE :=NULL ,
680: p_attribute8 IN pa_candidates.attribute8%TYPE :=NULL ,
681: p_attribute9 IN pa_candidates.attribute9%TYPE :=NULL ,
682: p_attribute10 IN pa_candidates.attribute10%TYPE :=NULL ,
683: p_attribute11 IN pa_candidates.attribute11%TYPE :=NULL ,
684: p_attribute12 IN pa_candidates.attribute12%TYPE :=NULL ,
685: p_attribute13 IN pa_candidates.attribute13%TYPE :=NULL ,
686: p_attribute14 IN pa_candidates.attribute14%TYPE :=NULL ,
687: p_attribute15 IN pa_candidates.attribute15%TYPE :=NULL ,

Line 684: p_attribute12 IN pa_candidates.attribute12%TYPE :=NULL ,

680: p_attribute8 IN pa_candidates.attribute8%TYPE :=NULL ,
681: p_attribute9 IN pa_candidates.attribute9%TYPE :=NULL ,
682: p_attribute10 IN pa_candidates.attribute10%TYPE :=NULL ,
683: p_attribute11 IN pa_candidates.attribute11%TYPE :=NULL ,
684: p_attribute12 IN pa_candidates.attribute12%TYPE :=NULL ,
685: p_attribute13 IN pa_candidates.attribute13%TYPE :=NULL ,
686: p_attribute14 IN pa_candidates.attribute14%TYPE :=NULL ,
687: p_attribute15 IN pa_candidates.attribute15%TYPE :=NULL ,
688: -- start for bug#9468526 , Added default null values

Line 685: p_attribute13 IN pa_candidates.attribute13%TYPE :=NULL ,

681: p_attribute9 IN pa_candidates.attribute9%TYPE :=NULL ,
682: p_attribute10 IN pa_candidates.attribute10%TYPE :=NULL ,
683: p_attribute11 IN pa_candidates.attribute11%TYPE :=NULL ,
684: p_attribute12 IN pa_candidates.attribute12%TYPE :=NULL ,
685: p_attribute13 IN pa_candidates.attribute13%TYPE :=NULL ,
686: p_attribute14 IN pa_candidates.attribute14%TYPE :=NULL ,
687: p_attribute15 IN pa_candidates.attribute15%TYPE :=NULL ,
688: -- start for bug#9468526 , Added default null values
689: x_return_status OUT NOCOPY VARCHAR2, -- 4537865 : Added nocopy hint

Line 686: p_attribute14 IN pa_candidates.attribute14%TYPE :=NULL ,

682: p_attribute10 IN pa_candidates.attribute10%TYPE :=NULL ,
683: p_attribute11 IN pa_candidates.attribute11%TYPE :=NULL ,
684: p_attribute12 IN pa_candidates.attribute12%TYPE :=NULL ,
685: p_attribute13 IN pa_candidates.attribute13%TYPE :=NULL ,
686: p_attribute14 IN pa_candidates.attribute14%TYPE :=NULL ,
687: p_attribute15 IN pa_candidates.attribute15%TYPE :=NULL ,
688: -- start for bug#9468526 , Added default null values
689: x_return_status OUT NOCOPY VARCHAR2, -- 4537865 : Added nocopy hint
690: x_msg_data OUT NOCOPY VARCHAR2, -- 4537865 : Added nocopy hint

Line 687: p_attribute15 IN pa_candidates.attribute15%TYPE :=NULL ,

683: p_attribute11 IN pa_candidates.attribute11%TYPE :=NULL ,
684: p_attribute12 IN pa_candidates.attribute12%TYPE :=NULL ,
685: p_attribute13 IN pa_candidates.attribute13%TYPE :=NULL ,
686: p_attribute14 IN pa_candidates.attribute14%TYPE :=NULL ,
687: p_attribute15 IN pa_candidates.attribute15%TYPE :=NULL ,
688: -- start for bug#9468526 , Added default null values
689: x_return_status OUT NOCOPY VARCHAR2, -- 4537865 : Added nocopy hint
690: x_msg_data OUT NOCOPY VARCHAR2, -- 4537865 : Added nocopy hint
691: x_msg_count OUT NOCOPY NUMBER) -- 4537865 : Added nocopy hint

Line 697: FROM pa_candidates

693:
694: cursor remain_candidates_csr is
695: SELECT candidate_id, resource_id, record_version_number,
696: candidate_ranking, status_code
697: FROM pa_candidates
698: WHERE assignment_id = p_assignment_id
699: and resource_id <> p_resource_id;
700:
701: cursor assigned_candidate_csr is

Line 703: FROM pa_candidates

699: and resource_id <> p_resource_id;
700:
701: cursor assigned_candidate_csr is
702: SELECT status_code
703: FROM pa_candidates
704: WHERE assignment_id = p_assignment_id
705: and resource_id = p_resource_id;
706:
707: l_return_status VARCHAR2(1);

Line 755: -- get information of the assigned person from pa_candidates

751: END;
752: END IF;
753:
754: BEGIN
755: -- get information of the assigned person from pa_candidates
756: -- if the passed resource is not one of the candidates,
757: -- it won't update anything for the assigned person.
758:
759: SELECT candidate_id,

Line 765: FROM pa_candidates

761: candidate_ranking
762: INTO l_asgned_candidate_id,
763: l_asgned_record_version_number,
764: l_candidate_ranking
765: FROM pa_candidates
766: WHERE assignment_id = p_assignment_id
767: AND resource_id = p_resource_id;
768:
769: BEGIN

Line 833: -- For the remaing candiates, update the status in pa_candidates

829: null;
830: END;
831:
832:
833: -- For the remaing candiates, update the status in pa_candidates
834: -- and create a record in review comments table for the changed status.
835: -- only if the passed status_code, which is for the remaining
836: -- candidates, is not null
837:

Line 914: FROM pa_candidates cand, pa_project_statuses ps

910:
911: -- Get the original project_system_status_code for the assigned candidate.
912: SELECT ps.project_system_status_code
913: INTO l_old_system_status_code
914: FROM pa_candidates cand, pa_project_statuses ps
915: WHERE cand.assignment_id = p_assignment_id
916: AND cand.resource_id = p_resource_id
917: AND ps.project_status_code = cand.status_code;
918:

Line 980: the status in pa_candidates table.

976: /* --------------------------------------------------------------------
977: PROCEDURE: Add_Candidate_Log
978: PURPOSE: This Procedure will add a review comment to for a Candidate
979: in the pa_candidate_reviews table. It will also update
980: the status in pa_candidates table.
981: A change reason can be associated with every status change.
982: A review comment can be associated with every status change.
983: This API will error out if:
984: 1. The status change from p_old_status_code to p_new_status_code

Line 999: (from pa_candidates). We do not

995: p_review_comments : Review Comments
996: p_change_reason_code : Change Reason for Status change.
997: p_record_version_number : Record Version of the Candidate Record
998: p_cand_rec_version_number : Record Version Number of the Candidate
999: (from pa_candidates). We do not
1000: need the record version number for
1001: the review_comments table, since we only
1002: insert in this table, we do not update it.
1003: -------------------------------------------------------------------- */

Line 1014: p_attribute_category IN pa_candidates.attribute_category%TYPE :=NULL ,

1010: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE, -- Added for Bug 5130421: PJR Enhancements for Public APIs
1011: x_cand_record_version_number OUT NOCOPY NUMBER, -- 4537865
1012: -- Added for bug 9187892
1013: -- start for bug#9468526 , Added default null values
1014: p_attribute_category IN pa_candidates.attribute_category%TYPE :=NULL ,
1015: p_attribute1 IN pa_candidates.attribute1%TYPE :=NULL ,
1016: p_attribute2 IN pa_candidates.attribute2%TYPE :=NULL ,
1017: p_attribute3 IN pa_candidates.attribute3%TYPE :=NULL ,
1018: p_attribute4 IN pa_candidates.attribute4%TYPE :=NULL ,

Line 1015: p_attribute1 IN pa_candidates.attribute1%TYPE :=NULL ,

1011: x_cand_record_version_number OUT NOCOPY NUMBER, -- 4537865
1012: -- Added for bug 9187892
1013: -- start for bug#9468526 , Added default null values
1014: p_attribute_category IN pa_candidates.attribute_category%TYPE :=NULL ,
1015: p_attribute1 IN pa_candidates.attribute1%TYPE :=NULL ,
1016: p_attribute2 IN pa_candidates.attribute2%TYPE :=NULL ,
1017: p_attribute3 IN pa_candidates.attribute3%TYPE :=NULL ,
1018: p_attribute4 IN pa_candidates.attribute4%TYPE :=NULL ,
1019: p_attribute5 IN pa_candidates.attribute5%TYPE :=NULL ,

Line 1016: p_attribute2 IN pa_candidates.attribute2%TYPE :=NULL ,

1012: -- Added for bug 9187892
1013: -- start for bug#9468526 , Added default null values
1014: p_attribute_category IN pa_candidates.attribute_category%TYPE :=NULL ,
1015: p_attribute1 IN pa_candidates.attribute1%TYPE :=NULL ,
1016: p_attribute2 IN pa_candidates.attribute2%TYPE :=NULL ,
1017: p_attribute3 IN pa_candidates.attribute3%TYPE :=NULL ,
1018: p_attribute4 IN pa_candidates.attribute4%TYPE :=NULL ,
1019: p_attribute5 IN pa_candidates.attribute5%TYPE :=NULL ,
1020: p_attribute6 IN pa_candidates.attribute6%TYPE :=NULL ,

Line 1017: p_attribute3 IN pa_candidates.attribute3%TYPE :=NULL ,

1013: -- start for bug#9468526 , Added default null values
1014: p_attribute_category IN pa_candidates.attribute_category%TYPE :=NULL ,
1015: p_attribute1 IN pa_candidates.attribute1%TYPE :=NULL ,
1016: p_attribute2 IN pa_candidates.attribute2%TYPE :=NULL ,
1017: p_attribute3 IN pa_candidates.attribute3%TYPE :=NULL ,
1018: p_attribute4 IN pa_candidates.attribute4%TYPE :=NULL ,
1019: p_attribute5 IN pa_candidates.attribute5%TYPE :=NULL ,
1020: p_attribute6 IN pa_candidates.attribute6%TYPE :=NULL ,
1021: p_attribute7 IN pa_candidates.attribute7%TYPE :=NULL ,

Line 1018: p_attribute4 IN pa_candidates.attribute4%TYPE :=NULL ,

1014: p_attribute_category IN pa_candidates.attribute_category%TYPE :=NULL ,
1015: p_attribute1 IN pa_candidates.attribute1%TYPE :=NULL ,
1016: p_attribute2 IN pa_candidates.attribute2%TYPE :=NULL ,
1017: p_attribute3 IN pa_candidates.attribute3%TYPE :=NULL ,
1018: p_attribute4 IN pa_candidates.attribute4%TYPE :=NULL ,
1019: p_attribute5 IN pa_candidates.attribute5%TYPE :=NULL ,
1020: p_attribute6 IN pa_candidates.attribute6%TYPE :=NULL ,
1021: p_attribute7 IN pa_candidates.attribute7%TYPE :=NULL ,
1022: p_attribute8 IN pa_candidates.attribute8%TYPE :=NULL ,

Line 1019: p_attribute5 IN pa_candidates.attribute5%TYPE :=NULL ,

1015: p_attribute1 IN pa_candidates.attribute1%TYPE :=NULL ,
1016: p_attribute2 IN pa_candidates.attribute2%TYPE :=NULL ,
1017: p_attribute3 IN pa_candidates.attribute3%TYPE :=NULL ,
1018: p_attribute4 IN pa_candidates.attribute4%TYPE :=NULL ,
1019: p_attribute5 IN pa_candidates.attribute5%TYPE :=NULL ,
1020: p_attribute6 IN pa_candidates.attribute6%TYPE :=NULL ,
1021: p_attribute7 IN pa_candidates.attribute7%TYPE :=NULL ,
1022: p_attribute8 IN pa_candidates.attribute8%TYPE :=NULL ,
1023: p_attribute9 IN pa_candidates.attribute9%TYPE :=NULL ,

Line 1020: p_attribute6 IN pa_candidates.attribute6%TYPE :=NULL ,

1016: p_attribute2 IN pa_candidates.attribute2%TYPE :=NULL ,
1017: p_attribute3 IN pa_candidates.attribute3%TYPE :=NULL ,
1018: p_attribute4 IN pa_candidates.attribute4%TYPE :=NULL ,
1019: p_attribute5 IN pa_candidates.attribute5%TYPE :=NULL ,
1020: p_attribute6 IN pa_candidates.attribute6%TYPE :=NULL ,
1021: p_attribute7 IN pa_candidates.attribute7%TYPE :=NULL ,
1022: p_attribute8 IN pa_candidates.attribute8%TYPE :=NULL ,
1023: p_attribute9 IN pa_candidates.attribute9%TYPE :=NULL ,
1024: p_attribute10 IN pa_candidates.attribute10%TYPE :=NULL ,

Line 1021: p_attribute7 IN pa_candidates.attribute7%TYPE :=NULL ,

1017: p_attribute3 IN pa_candidates.attribute3%TYPE :=NULL ,
1018: p_attribute4 IN pa_candidates.attribute4%TYPE :=NULL ,
1019: p_attribute5 IN pa_candidates.attribute5%TYPE :=NULL ,
1020: p_attribute6 IN pa_candidates.attribute6%TYPE :=NULL ,
1021: p_attribute7 IN pa_candidates.attribute7%TYPE :=NULL ,
1022: p_attribute8 IN pa_candidates.attribute8%TYPE :=NULL ,
1023: p_attribute9 IN pa_candidates.attribute9%TYPE :=NULL ,
1024: p_attribute10 IN pa_candidates.attribute10%TYPE :=NULL ,
1025: p_attribute11 IN pa_candidates.attribute11%TYPE :=NULL ,

Line 1022: p_attribute8 IN pa_candidates.attribute8%TYPE :=NULL ,

1018: p_attribute4 IN pa_candidates.attribute4%TYPE :=NULL ,
1019: p_attribute5 IN pa_candidates.attribute5%TYPE :=NULL ,
1020: p_attribute6 IN pa_candidates.attribute6%TYPE :=NULL ,
1021: p_attribute7 IN pa_candidates.attribute7%TYPE :=NULL ,
1022: p_attribute8 IN pa_candidates.attribute8%TYPE :=NULL ,
1023: p_attribute9 IN pa_candidates.attribute9%TYPE :=NULL ,
1024: p_attribute10 IN pa_candidates.attribute10%TYPE :=NULL ,
1025: p_attribute11 IN pa_candidates.attribute11%TYPE :=NULL ,
1026: p_attribute12 IN pa_candidates.attribute12%TYPE :=NULL ,

Line 1023: p_attribute9 IN pa_candidates.attribute9%TYPE :=NULL ,

1019: p_attribute5 IN pa_candidates.attribute5%TYPE :=NULL ,
1020: p_attribute6 IN pa_candidates.attribute6%TYPE :=NULL ,
1021: p_attribute7 IN pa_candidates.attribute7%TYPE :=NULL ,
1022: p_attribute8 IN pa_candidates.attribute8%TYPE :=NULL ,
1023: p_attribute9 IN pa_candidates.attribute9%TYPE :=NULL ,
1024: p_attribute10 IN pa_candidates.attribute10%TYPE :=NULL ,
1025: p_attribute11 IN pa_candidates.attribute11%TYPE :=NULL ,
1026: p_attribute12 IN pa_candidates.attribute12%TYPE :=NULL ,
1027: p_attribute13 IN pa_candidates.attribute13%TYPE :=NULL ,

Line 1024: p_attribute10 IN pa_candidates.attribute10%TYPE :=NULL ,

1020: p_attribute6 IN pa_candidates.attribute6%TYPE :=NULL ,
1021: p_attribute7 IN pa_candidates.attribute7%TYPE :=NULL ,
1022: p_attribute8 IN pa_candidates.attribute8%TYPE :=NULL ,
1023: p_attribute9 IN pa_candidates.attribute9%TYPE :=NULL ,
1024: p_attribute10 IN pa_candidates.attribute10%TYPE :=NULL ,
1025: p_attribute11 IN pa_candidates.attribute11%TYPE :=NULL ,
1026: p_attribute12 IN pa_candidates.attribute12%TYPE :=NULL ,
1027: p_attribute13 IN pa_candidates.attribute13%TYPE :=NULL ,
1028: p_attribute14 IN pa_candidates.attribute14%TYPE :=NULL ,

Line 1025: p_attribute11 IN pa_candidates.attribute11%TYPE :=NULL ,

1021: p_attribute7 IN pa_candidates.attribute7%TYPE :=NULL ,
1022: p_attribute8 IN pa_candidates.attribute8%TYPE :=NULL ,
1023: p_attribute9 IN pa_candidates.attribute9%TYPE :=NULL ,
1024: p_attribute10 IN pa_candidates.attribute10%TYPE :=NULL ,
1025: p_attribute11 IN pa_candidates.attribute11%TYPE :=NULL ,
1026: p_attribute12 IN pa_candidates.attribute12%TYPE :=NULL ,
1027: p_attribute13 IN pa_candidates.attribute13%TYPE :=NULL ,
1028: p_attribute14 IN pa_candidates.attribute14%TYPE :=NULL ,
1029: p_attribute15 IN pa_candidates.attribute15%TYPE :=NULL ,

Line 1026: p_attribute12 IN pa_candidates.attribute12%TYPE :=NULL ,

1022: p_attribute8 IN pa_candidates.attribute8%TYPE :=NULL ,
1023: p_attribute9 IN pa_candidates.attribute9%TYPE :=NULL ,
1024: p_attribute10 IN pa_candidates.attribute10%TYPE :=NULL ,
1025: p_attribute11 IN pa_candidates.attribute11%TYPE :=NULL ,
1026: p_attribute12 IN pa_candidates.attribute12%TYPE :=NULL ,
1027: p_attribute13 IN pa_candidates.attribute13%TYPE :=NULL ,
1028: p_attribute14 IN pa_candidates.attribute14%TYPE :=NULL ,
1029: p_attribute15 IN pa_candidates.attribute15%TYPE :=NULL ,
1030: -- start for bug#9468526 , Added default null values

Line 1027: p_attribute13 IN pa_candidates.attribute13%TYPE :=NULL ,

1023: p_attribute9 IN pa_candidates.attribute9%TYPE :=NULL ,
1024: p_attribute10 IN pa_candidates.attribute10%TYPE :=NULL ,
1025: p_attribute11 IN pa_candidates.attribute11%TYPE :=NULL ,
1026: p_attribute12 IN pa_candidates.attribute12%TYPE :=NULL ,
1027: p_attribute13 IN pa_candidates.attribute13%TYPE :=NULL ,
1028: p_attribute14 IN pa_candidates.attribute14%TYPE :=NULL ,
1029: p_attribute15 IN pa_candidates.attribute15%TYPE :=NULL ,
1030: -- start for bug#9468526 , Added default null values
1031: x_return_status OUT NOCOPY VARCHAR2, -- 4537865

Line 1028: p_attribute14 IN pa_candidates.attribute14%TYPE :=NULL ,

1024: p_attribute10 IN pa_candidates.attribute10%TYPE :=NULL ,
1025: p_attribute11 IN pa_candidates.attribute11%TYPE :=NULL ,
1026: p_attribute12 IN pa_candidates.attribute12%TYPE :=NULL ,
1027: p_attribute13 IN pa_candidates.attribute13%TYPE :=NULL ,
1028: p_attribute14 IN pa_candidates.attribute14%TYPE :=NULL ,
1029: p_attribute15 IN pa_candidates.attribute15%TYPE :=NULL ,
1030: -- start for bug#9468526 , Added default null values
1031: x_return_status OUT NOCOPY VARCHAR2, -- 4537865
1032: x_msg_count OUT NOCOPY NUMBER, -- 4537865

Line 1029: p_attribute15 IN pa_candidates.attribute15%TYPE :=NULL ,

1025: p_attribute11 IN pa_candidates.attribute11%TYPE :=NULL ,
1026: p_attribute12 IN pa_candidates.attribute12%TYPE :=NULL ,
1027: p_attribute13 IN pa_candidates.attribute13%TYPE :=NULL ,
1028: p_attribute14 IN pa_candidates.attribute14%TYPE :=NULL ,
1029: p_attribute15 IN pa_candidates.attribute15%TYPE :=NULL ,
1030: -- start for bug#9468526 , Added default null values
1031: x_return_status OUT NOCOPY VARCHAR2, -- 4537865
1032: x_msg_count OUT NOCOPY NUMBER, -- 4537865
1033: x_msg_data OUT NOCOPY VARCHAR2) -- 4537865

Line 1069: FROM pa_candidates

1065: END IF;
1066:
1067: SELECT record_version_number
1068: INTO l_old_record_version_number
1069: FROM pa_candidates
1070: WHERE candidate_id = p_candidate_id;
1071:
1072: IF l_old_record_version_number <> p_cand_record_version_number THEN
1073: pa_utils.add_message

Line 1081: FROM pa_candidates

1077: END IF;
1078:
1079: SELECT status_code
1080: INTO l_old_status_code
1081: FROM pa_candidates
1082: WHERE candidate_id=p_candidate_id;
1083:
1084: l_status_code := p_status_code;
1085: l_review_comments := p_review_comments;

Line 1095: FROM pa_candidates

1091:
1092: -- this is for workflow.
1093: SELECT assignment_id,resource_id
1094: INTO l_assignment_id,l_resource_id
1095: FROM pa_candidates
1096: where candidate_id = p_candidate_id;
1097:
1098: IF nvl(l_old_status_code,'-1') = nvl(l_status_code,'-1') THEN
1099: -- There is no status change

Line 1136: -- Since pa_candidates has not been updated, the new record version number should be

1132: -- Since user status has not changed, assigning the same
1133: -- value to system status
1134: l_old_system_status_code := l_system_status_code;
1135:
1136: -- Since pa_candidates has not been updated, the new record version number should be
1137: -- same as the original passed value.
1138: l_new_cand_record_version_num := p_cand_record_version_number;
1139: ELSE
1140: -- Status has changed.

Line 1165: -- Update pa_candidates with the new status code

1161: p_msg_name => 'PA_CAND_CHG_REASON_REQD');
1162: RAISE FND_API.G_EXC_ERROR;
1163: END IF;
1164:
1165: -- Update pa_candidates with the new status code
1166: -- Added WHO Column update. Bug 7168412.
1167:
1168: -- Added Attribute Columns update for Bug 9187892
1169:

Line 1170: UPDATE pa_candidates

1166: -- Added WHO Column update. Bug 7168412.
1167:
1168: -- Added Attribute Columns update for Bug 9187892
1169:
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,

Line 1196: -- Since pa_candidates has been updated, set the increased record version number to the local

1192: -- end for bug#9468526
1193: WHERE candidate_id = p_candidate_id AND
1194: record_version_number=p_cand_record_version_number;
1195:
1196: -- Since pa_candidates has been updated, set the increased record version number to the local
1197: -- variabe to pass back as a out parameter.
1198: l_new_cand_record_version_num := p_cand_record_version_number+1;
1199:
1200: IF l_status_code is null THEN

Line 1381: PA_CANDIDATES_LOG table. we will also update the

1377: PROCEDURE: Update_Candidate
1378: PURPOSE: This Procedure will update candidate p_candidate_id's
1379: status or ranking.
1380: If the status changes, we will create a log entry in the
1381: PA_CANDIDATES_LOG table. we will also update the
1382: NO_OF_ACTIVE_CANDIDATES column in PA_PROJECT_STATUSES, if an
1383: active candidate goes inactive or vice versa
1384: Since no comment is passed, we will create the log with an empty
1385: log message. This API will be called from the Candidate List Page,

Line 1408: p_attribute_category IN pa_candidates.attribute_category%TYPE :=NULL ,

1404: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1405: p_validate_status IN VARCHAR2 := FND_API.G_TRUE,
1406: -- Added for bug 9187892
1407: -- start for bug#9468526 , Added default null values
1408: p_attribute_category IN pa_candidates.attribute_category%TYPE :=NULL ,
1409: p_attribute1 IN pa_candidates.attribute1%TYPE :=NULL ,
1410: p_attribute2 IN pa_candidates.attribute2%TYPE :=NULL ,
1411: p_attribute3 IN pa_candidates.attribute3%TYPE :=NULL ,
1412: p_attribute4 IN pa_candidates.attribute4%TYPE :=NULL ,

Line 1409: p_attribute1 IN pa_candidates.attribute1%TYPE :=NULL ,

1405: p_validate_status IN VARCHAR2 := FND_API.G_TRUE,
1406: -- Added for bug 9187892
1407: -- start for bug#9468526 , Added default null values
1408: p_attribute_category IN pa_candidates.attribute_category%TYPE :=NULL ,
1409: p_attribute1 IN pa_candidates.attribute1%TYPE :=NULL ,
1410: p_attribute2 IN pa_candidates.attribute2%TYPE :=NULL ,
1411: p_attribute3 IN pa_candidates.attribute3%TYPE :=NULL ,
1412: p_attribute4 IN pa_candidates.attribute4%TYPE :=NULL ,
1413: p_attribute5 IN pa_candidates.attribute5%TYPE :=NULL ,

Line 1410: p_attribute2 IN pa_candidates.attribute2%TYPE :=NULL ,

1406: -- Added for bug 9187892
1407: -- start for bug#9468526 , Added default null values
1408: p_attribute_category IN pa_candidates.attribute_category%TYPE :=NULL ,
1409: p_attribute1 IN pa_candidates.attribute1%TYPE :=NULL ,
1410: p_attribute2 IN pa_candidates.attribute2%TYPE :=NULL ,
1411: p_attribute3 IN pa_candidates.attribute3%TYPE :=NULL ,
1412: p_attribute4 IN pa_candidates.attribute4%TYPE :=NULL ,
1413: p_attribute5 IN pa_candidates.attribute5%TYPE :=NULL ,
1414: p_attribute6 IN pa_candidates.attribute6%TYPE :=NULL ,

Line 1411: p_attribute3 IN pa_candidates.attribute3%TYPE :=NULL ,

1407: -- start for bug#9468526 , Added default null values
1408: p_attribute_category IN pa_candidates.attribute_category%TYPE :=NULL ,
1409: p_attribute1 IN pa_candidates.attribute1%TYPE :=NULL ,
1410: p_attribute2 IN pa_candidates.attribute2%TYPE :=NULL ,
1411: p_attribute3 IN pa_candidates.attribute3%TYPE :=NULL ,
1412: p_attribute4 IN pa_candidates.attribute4%TYPE :=NULL ,
1413: p_attribute5 IN pa_candidates.attribute5%TYPE :=NULL ,
1414: p_attribute6 IN pa_candidates.attribute6%TYPE :=NULL ,
1415: p_attribute7 IN pa_candidates.attribute7%TYPE :=NULL ,

Line 1412: p_attribute4 IN pa_candidates.attribute4%TYPE :=NULL ,

1408: p_attribute_category IN pa_candidates.attribute_category%TYPE :=NULL ,
1409: p_attribute1 IN pa_candidates.attribute1%TYPE :=NULL ,
1410: p_attribute2 IN pa_candidates.attribute2%TYPE :=NULL ,
1411: p_attribute3 IN pa_candidates.attribute3%TYPE :=NULL ,
1412: p_attribute4 IN pa_candidates.attribute4%TYPE :=NULL ,
1413: p_attribute5 IN pa_candidates.attribute5%TYPE :=NULL ,
1414: p_attribute6 IN pa_candidates.attribute6%TYPE :=NULL ,
1415: p_attribute7 IN pa_candidates.attribute7%TYPE :=NULL ,
1416: p_attribute8 IN pa_candidates.attribute8%TYPE :=NULL ,

Line 1413: p_attribute5 IN pa_candidates.attribute5%TYPE :=NULL ,

1409: p_attribute1 IN pa_candidates.attribute1%TYPE :=NULL ,
1410: p_attribute2 IN pa_candidates.attribute2%TYPE :=NULL ,
1411: p_attribute3 IN pa_candidates.attribute3%TYPE :=NULL ,
1412: p_attribute4 IN pa_candidates.attribute4%TYPE :=NULL ,
1413: p_attribute5 IN pa_candidates.attribute5%TYPE :=NULL ,
1414: p_attribute6 IN pa_candidates.attribute6%TYPE :=NULL ,
1415: p_attribute7 IN pa_candidates.attribute7%TYPE :=NULL ,
1416: p_attribute8 IN pa_candidates.attribute8%TYPE :=NULL ,
1417: p_attribute9 IN pa_candidates.attribute9%TYPE :=NULL ,

Line 1414: p_attribute6 IN pa_candidates.attribute6%TYPE :=NULL ,

1410: p_attribute2 IN pa_candidates.attribute2%TYPE :=NULL ,
1411: p_attribute3 IN pa_candidates.attribute3%TYPE :=NULL ,
1412: p_attribute4 IN pa_candidates.attribute4%TYPE :=NULL ,
1413: p_attribute5 IN pa_candidates.attribute5%TYPE :=NULL ,
1414: p_attribute6 IN pa_candidates.attribute6%TYPE :=NULL ,
1415: p_attribute7 IN pa_candidates.attribute7%TYPE :=NULL ,
1416: p_attribute8 IN pa_candidates.attribute8%TYPE :=NULL ,
1417: p_attribute9 IN pa_candidates.attribute9%TYPE :=NULL ,
1418: p_attribute10 IN pa_candidates.attribute10%TYPE :=NULL ,

Line 1415: p_attribute7 IN pa_candidates.attribute7%TYPE :=NULL ,

1411: p_attribute3 IN pa_candidates.attribute3%TYPE :=NULL ,
1412: p_attribute4 IN pa_candidates.attribute4%TYPE :=NULL ,
1413: p_attribute5 IN pa_candidates.attribute5%TYPE :=NULL ,
1414: p_attribute6 IN pa_candidates.attribute6%TYPE :=NULL ,
1415: p_attribute7 IN pa_candidates.attribute7%TYPE :=NULL ,
1416: p_attribute8 IN pa_candidates.attribute8%TYPE :=NULL ,
1417: p_attribute9 IN pa_candidates.attribute9%TYPE :=NULL ,
1418: p_attribute10 IN pa_candidates.attribute10%TYPE :=NULL ,
1419: p_attribute11 IN pa_candidates.attribute11%TYPE :=NULL ,

Line 1416: p_attribute8 IN pa_candidates.attribute8%TYPE :=NULL ,

1412: p_attribute4 IN pa_candidates.attribute4%TYPE :=NULL ,
1413: p_attribute5 IN pa_candidates.attribute5%TYPE :=NULL ,
1414: p_attribute6 IN pa_candidates.attribute6%TYPE :=NULL ,
1415: p_attribute7 IN pa_candidates.attribute7%TYPE :=NULL ,
1416: p_attribute8 IN pa_candidates.attribute8%TYPE :=NULL ,
1417: p_attribute9 IN pa_candidates.attribute9%TYPE :=NULL ,
1418: p_attribute10 IN pa_candidates.attribute10%TYPE :=NULL ,
1419: p_attribute11 IN pa_candidates.attribute11%TYPE :=NULL ,
1420: p_attribute12 IN pa_candidates.attribute12%TYPE :=NULL ,

Line 1417: p_attribute9 IN pa_candidates.attribute9%TYPE :=NULL ,

1413: p_attribute5 IN pa_candidates.attribute5%TYPE :=NULL ,
1414: p_attribute6 IN pa_candidates.attribute6%TYPE :=NULL ,
1415: p_attribute7 IN pa_candidates.attribute7%TYPE :=NULL ,
1416: p_attribute8 IN pa_candidates.attribute8%TYPE :=NULL ,
1417: p_attribute9 IN pa_candidates.attribute9%TYPE :=NULL ,
1418: p_attribute10 IN pa_candidates.attribute10%TYPE :=NULL ,
1419: p_attribute11 IN pa_candidates.attribute11%TYPE :=NULL ,
1420: p_attribute12 IN pa_candidates.attribute12%TYPE :=NULL ,
1421: p_attribute13 IN pa_candidates.attribute13%TYPE :=NULL ,

Line 1418: p_attribute10 IN pa_candidates.attribute10%TYPE :=NULL ,

1414: p_attribute6 IN pa_candidates.attribute6%TYPE :=NULL ,
1415: p_attribute7 IN pa_candidates.attribute7%TYPE :=NULL ,
1416: p_attribute8 IN pa_candidates.attribute8%TYPE :=NULL ,
1417: p_attribute9 IN pa_candidates.attribute9%TYPE :=NULL ,
1418: p_attribute10 IN pa_candidates.attribute10%TYPE :=NULL ,
1419: p_attribute11 IN pa_candidates.attribute11%TYPE :=NULL ,
1420: p_attribute12 IN pa_candidates.attribute12%TYPE :=NULL ,
1421: p_attribute13 IN pa_candidates.attribute13%TYPE :=NULL ,
1422: p_attribute14 IN pa_candidates.attribute14%TYPE :=NULL ,

Line 1419: p_attribute11 IN pa_candidates.attribute11%TYPE :=NULL ,

1415: p_attribute7 IN pa_candidates.attribute7%TYPE :=NULL ,
1416: p_attribute8 IN pa_candidates.attribute8%TYPE :=NULL ,
1417: p_attribute9 IN pa_candidates.attribute9%TYPE :=NULL ,
1418: p_attribute10 IN pa_candidates.attribute10%TYPE :=NULL ,
1419: p_attribute11 IN pa_candidates.attribute11%TYPE :=NULL ,
1420: p_attribute12 IN pa_candidates.attribute12%TYPE :=NULL ,
1421: p_attribute13 IN pa_candidates.attribute13%TYPE :=NULL ,
1422: p_attribute14 IN pa_candidates.attribute14%TYPE :=NULL ,
1423: p_attribute15 IN pa_candidates.attribute15%TYPE :=NULL ,

Line 1420: p_attribute12 IN pa_candidates.attribute12%TYPE :=NULL ,

1416: p_attribute8 IN pa_candidates.attribute8%TYPE :=NULL ,
1417: p_attribute9 IN pa_candidates.attribute9%TYPE :=NULL ,
1418: p_attribute10 IN pa_candidates.attribute10%TYPE :=NULL ,
1419: p_attribute11 IN pa_candidates.attribute11%TYPE :=NULL ,
1420: p_attribute12 IN pa_candidates.attribute12%TYPE :=NULL ,
1421: p_attribute13 IN pa_candidates.attribute13%TYPE :=NULL ,
1422: p_attribute14 IN pa_candidates.attribute14%TYPE :=NULL ,
1423: p_attribute15 IN pa_candidates.attribute15%TYPE :=NULL ,
1424: -- End for bug#9468526 , Added default null values

Line 1421: p_attribute13 IN pa_candidates.attribute13%TYPE :=NULL ,

1417: p_attribute9 IN pa_candidates.attribute9%TYPE :=NULL ,
1418: p_attribute10 IN pa_candidates.attribute10%TYPE :=NULL ,
1419: p_attribute11 IN pa_candidates.attribute11%TYPE :=NULL ,
1420: p_attribute12 IN pa_candidates.attribute12%TYPE :=NULL ,
1421: p_attribute13 IN pa_candidates.attribute13%TYPE :=NULL ,
1422: p_attribute14 IN pa_candidates.attribute14%TYPE :=NULL ,
1423: p_attribute15 IN pa_candidates.attribute15%TYPE :=NULL ,
1424: -- End for bug#9468526 , Added default null values
1425: x_record_version_number OUT NOCOPY NUMBER, -- 4537865 Added nocopy hint

Line 1422: p_attribute14 IN pa_candidates.attribute14%TYPE :=NULL ,

1418: p_attribute10 IN pa_candidates.attribute10%TYPE :=NULL ,
1419: p_attribute11 IN pa_candidates.attribute11%TYPE :=NULL ,
1420: p_attribute12 IN pa_candidates.attribute12%TYPE :=NULL ,
1421: p_attribute13 IN pa_candidates.attribute13%TYPE :=NULL ,
1422: p_attribute14 IN pa_candidates.attribute14%TYPE :=NULL ,
1423: p_attribute15 IN pa_candidates.attribute15%TYPE :=NULL ,
1424: -- End for bug#9468526 , Added default null values
1425: x_record_version_number OUT NOCOPY NUMBER, -- 4537865 Added nocopy hint
1426: x_msg_count OUT NOCOPY NUMBER, -- 4537865 Added nocopy hint

Line 1423: p_attribute15 IN pa_candidates.attribute15%TYPE :=NULL ,

1419: p_attribute11 IN pa_candidates.attribute11%TYPE :=NULL ,
1420: p_attribute12 IN pa_candidates.attribute12%TYPE :=NULL ,
1421: p_attribute13 IN pa_candidates.attribute13%TYPE :=NULL ,
1422: p_attribute14 IN pa_candidates.attribute14%TYPE :=NULL ,
1423: p_attribute15 IN pa_candidates.attribute15%TYPE :=NULL ,
1424: -- End for bug#9468526 , Added default null values
1425: x_record_version_number OUT NOCOPY NUMBER, -- 4537865 Added nocopy hint
1426: x_msg_count OUT NOCOPY NUMBER, -- 4537865 Added nocopy hint
1427: x_msg_data OUT NOCOPY VARCHAR2, -- 4537865 Added nocopy hint

Line 1477: FROM pa_candidates

1473: l_old_status_code,
1474: l_old_record_version_number,
1475: l_resource_id,
1476: l_old_candidate_ranking
1477: FROM pa_candidates
1478: WHERE candidate_id = p_candidate_id;
1479:
1480: EXCEPTION
1481: WHEN NO_DATA_FOUND THEN

Line 1572: UPDATE pa_candidates

1568: END IF;
1569:
1570: -- Added WHO Column update. Bug 7168412.
1571: -- Added Attribute Columns update for Bug 9187892
1572: UPDATE pa_candidates
1573: SET
1574: status_code = l_status_code,
1575: candidate_ranking = p_ranking,
1576: record_version_number = p_record_version_number+1,

Line 2731: FROM pa_candidates

2727:
2728: IF p_status_code IS NULL THEN
2729: SELECT candidate_id
2730: BULK COLLECT INTO l_candidates_tbl
2731: FROM pa_candidates
2732: WHERE assignment_id = p_assignment_id;
2733:
2734: DELETE FROM pa_candidates
2735: WHERE assignment_id = p_assignment_id;

Line 2734: DELETE FROM pa_candidates

2730: BULK COLLECT INTO l_candidates_tbl
2731: FROM pa_candidates
2732: WHERE assignment_id = p_assignment_id;
2733:
2734: DELETE FROM pa_candidates
2735: WHERE assignment_id = p_assignment_id;
2736: ELSE
2737: SELECT candidate_id
2738: BULK COLLECT INTO l_candidates_tbl

Line 2739: FROM pa_candidates

2735: WHERE assignment_id = p_assignment_id;
2736: ELSE
2737: SELECT candidate_id
2738: BULK COLLECT INTO l_candidates_tbl
2739: FROM pa_candidates
2740: WHERE assignment_id = p_assignment_id
2741: AND status_code = p_status_code;
2742:
2743: DELETE FROM pa_candidates

Line 2743: DELETE FROM pa_candidates

2739: FROM pa_candidates
2740: WHERE assignment_id = p_assignment_id
2741: AND status_code = p_status_code;
2742:
2743: DELETE FROM pa_candidates
2744: WHERE assignment_id = p_assignment_id
2745: AND status_code = p_status_code;
2746: END IF;
2747:

Line 2816: pa_candidates cand,

2812: l_record_version_number,
2813: l_system_status_code,
2814: l_assignment_id
2815: FROM pa_project_assignments asmt,
2816: pa_candidates cand,
2817: pa_project_statuses ps
2818: WHERE asmt.assignment_id = cand.assignment_id
2819: AND candidate_id = p_candidate_id
2820: AND cand.status_code = ps.project_status_code

Line 2826: DELETE FROM pa_candidates

2822:
2823: DELETE FROM pa_candidate_reviews
2824: WHERE candidate_id = p_candidate_id;
2825:
2826: DELETE FROM pa_candidates
2827: WHERE candidate_id = p_candidate_id;
2828:
2829: IF (is_active_candidate(l_system_status_code)='Y') THEN
2830: pa_project_assignments_pkg.Update_row(

Line 2897: FROM pa_candidates cand,

2893: cand.nominated_by_person_id,
2894: cand.nomination_date,
2895: cand.nomination_comments,
2896: cand.candidate_ranking
2897: FROM pa_candidates cand,
2898: pa_resources_denorm res
2899: WHERE assignment_id = p_old_requirement_id
2900: AND p_new_start_date BETWEEN
2901: res.resource_effective_start_date AND

Line 2931: INSERT INTO PA_CANDIDATES

2927: FOR c2 in c1 LOOP
2928: l_old_candidate_id := c2.candidate_id;
2929:
2930: -- Insert into the candidate table.
2931: INSERT INTO PA_CANDIDATES
2932: (CANDIDATE_ID,
2933: ASSIGNMENT_ID,
2934: RESOURCE_ID,
2935: RECORD_VERSION_NUMBER,

Line 2946: (PA_CANDIDATES_S.nextval,

2942: CREATED_BY,
2943: LAST_UPDATE_DATE,
2944: LAST_UPDATED_BY)
2945: VALUES
2946: (PA_CANDIDATES_S.nextval,
2947: p_new_requirement_id,
2948: c2.resource_id,
2949: 1,
2950: c2.status_code,

Line 3096: FROM pa_candidates cand,

3092: BULK COLLECT INTO
3093: l_candidate_id_tbl,
3094: l_resource_id_tbl,
3095: l_record_version_number_tbl
3096: FROM pa_candidates cand,
3097: pa_project_statuses status
3098: WHERE cand.assignment_id = p_assignment_id
3099: AND cand.status_code = status.project_status_code
3100: AND status.project_system_status_code IN ('CANDIDATE_PENDING_REVIEW',

Line 3150: UPDATE pa_candidates SET

3146: --dbms_output.put_line ('candidate id to be declined: ' || l_candidate_id_tbl(i));
3147: --dbms_output.put_line ('resource id to be declined: ' || l_resource_id_tbl(i));
3148:
3149: -- Added WHO Column update. Bug 7168412.
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