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_SEARCH_PUB dependencies on PA_SEARCH_GLOB

Line 33: --, p_competences IN pa_search_glob.Competence_Criteria_Tbl_Type

29: , p_mandatory IN system.pa_varchar2_1_tbl_type := NULL
30: , p_provisional_availability IN VARCHAR
31: , p_region IN VARCHAR := FND_API.G_MISS_CHAR
32: , p_city IN VARCHAR := FND_API.G_MISS_CHAR
33: --, p_competences IN pa_search_glob.Competence_Criteria_Tbl_Type
34: , p_work_current_loc IN VARCHAR
35: , p_work_all_loc IN VARCHAR
36: , p_travel_domestically IN VARCHAR
37: , p_travel_internationally IN VARCHAR

Line 74: l_competence_criteria PA_SEARCH_GLOB.Competence_Criteria_Tbl_Type;

70: l_new_competence_id per_competences.competence_id%TYPE;
71: -- added for Bug fix: 4537865
72: l_competence_alias per_competences.competence_alias%TYPE;
73: l_resource_type_id NUMBER;
74: l_competence_criteria PA_SEARCH_GLOB.Competence_Criteria_Tbl_Type;
75: l_org_structure_type PA_ORG_HIERARCHY_DENORM.pa_org_use_type%TYPE;
76: i NUMBER := 1;
77: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
78:

Line 132: PA_SEARCH_GLOB.g_search_criteria.assignment_id := p_assignment_id;

128: -- assign the assignment id to the g_search_criteria global pl/sql record
129: -- if the assignment id is passed to the API.
130: IF p_assignment_id <> FND_API.G_MISS_NUM AND p_assignment_id IS NOT NULL THEN
131:
132: PA_SEARCH_GLOB.g_search_criteria.assignment_id := p_assignment_id;
133:
134: END IF;
135:
136: -- assign the project id to the g_search_criteria global pl/sql record

Line 140: PA_SEARCH_GLOB.g_search_criteria.project_id := p_project_id;

136: -- assign the project id to the g_search_criteria global pl/sql record
137: -- if the project id is passed to the API.
138: IF p_project_id <> FND_API.G_MISS_NUM AND p_project_id IS NOT NULL THEN
139:
140: PA_SEARCH_GLOB.g_search_criteria.project_id := p_project_id;
141:
142: END IF;
143:
144: IF (P_DEBUG_MODE ='Y') THEN

Line 166: x_assignment_id => PA_SEARCH_GLOB.g_search_criteria.assignment_id,

162: PA_ASSIGNMENT_UTILS.Check_Assignment_Number_Or_Id(
163: p_assignment_number => p_assignment_number,
164: p_assignment_id => p_assignment_id,
165: p_check_id_flag => PA_STARTUP.G_Check_ID_Flag,
166: x_assignment_id => PA_SEARCH_GLOB.g_search_criteria.assignment_id,
167: x_return_status => l_return_status,
168: x_error_message_code => l_error_message_code);
169:
170: -- if the assignment number is not valid then

Line 182: PA_SEARCH_GLOB.g_search_criteria.employees_only := p_employees_only;

178: -- assign the p_employees_only parameter, indicating if the search is for
179: -- employees only, to the g_search_criteria global record.
180: IF p_employees_only <> FND_API.G_MISS_CHAR THEN
181:
182: PA_SEARCH_GLOB.g_search_criteria.employees_only := p_employees_only;
183:
184: END IF;
185:
186: -- assign the p_restrict_res_comp parameter to the g_search_criteria

Line 193: PA_SEARCH_GLOB.g_search_criteria.restrict_res_comp :=

189: -- does not have one of the requirement's mandatory competences.
190: --
191: IF p_restrict_res_comp <> FND_API.G_MISS_CHAR THEN
192:
193: PA_SEARCH_GLOB.g_search_criteria.restrict_res_comp :=
194: p_restrict_res_comp;
195:
196: END IF;
197:

Line 205: PA_SEARCH_GLOB.g_search_criteria.exclude_candidates :=

201: -- is already a candidate for that requirement.
202: --
203: IF p_exclude_candidates <> FND_API.G_MISS_CHAR THEN
204:
205: PA_SEARCH_GLOB.g_search_criteria.exclude_candidates :=
206: p_exclude_candidates;
207:
208: END IF;
209:

Line 229: x_org_hierarchy_version_id => PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id,

225: PA_HR_ORG_UTILS.Check_OrgHierName_Or_Id(
226: p_org_hierarchy_version_id => p_org_hierarchy_version_id,
227: p_org_hierarchy_name => p_org_hierarchy_name,
228: p_check_id_flag => PA_STARTUP.G_Check_ID_Flag,
229: x_org_hierarchy_version_id => PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id,
230: x_return_status => l_return_status,
231: x_error_msg_code => l_error_msg_data);
232:
233: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 242: PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id,

238: -- i.e. EXPENDITURES for resource search
239: -- PROJECTS for requirement search
240: PA_ORG_UTILS.Check_OrgHierarchy_Type(
241: p_org_structure_version_id =>
242: PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id,
243: p_org_structure_type => l_org_structure_type,
244: x_return_status => l_return_status,
245: x_error_message_code => l_error_msg_data);
246:

Line 265: PA_SEARCH_GLOB.g_search_criteria.organization_id,

261: p_organization_id => p_organization_id,
262: p_organization_name => p_organization_name,
263: p_check_id_flag => PA_STARTUP.G_Check_ID_Flag,
264: x_organization_id =>
265: PA_SEARCH_GLOB.g_search_criteria.organization_id,
266: x_return_status => l_return_status,
267: x_error_msg_code => l_error_msg_data);
268:
269: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 277: PA_SEARCH_GLOB.g_search_criteria.organization_id,

273: -- i.e. EXPENDITURES for resource search
274: -- PROJECTS for requirement search
275: PA_ORG_UTILS.Check_Org_Type(
276: p_organization_id =>
277: PA_SEARCH_GLOB.g_search_criteria.organization_id,
278: p_org_structure_type => l_org_structure_type,
279: x_return_status => l_return_status,
280: x_error_message_code => l_error_msg_data);
281:

Line 296: IF PA_SEARCH_GLOB.g_search_criteria.organization_id IS NOT NULL AND

292: (p_organization_name <> FND_API.G_MISS_CHAR AND
293: p_organization_name IS NOT NULL)
294: THEN
295:
296: IF PA_SEARCH_GLOB.g_search_criteria.organization_id IS NOT NULL AND
297: PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id IS NOT NULL
298: THEN
299:
300: PA_ORG_UTILS.Check_Org_In_OrgHierarchy(

Line 297: PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id IS NOT NULL

293: p_organization_name IS NOT NULL)
294: THEN
295:
296: IF PA_SEARCH_GLOB.g_search_criteria.organization_id IS NOT NULL AND
297: PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id IS NOT NULL
298: THEN
299:
300: PA_ORG_UTILS.Check_Org_In_OrgHierarchy(
301: p_organization_id =>

Line 302: PA_SEARCH_GLOB.g_search_criteria.organization_id,

298: THEN
299:
300: PA_ORG_UTILS.Check_Org_In_OrgHierarchy(
301: p_organization_id =>
302: PA_SEARCH_GLOB.g_search_criteria.organization_id,
303: p_org_structure_version_id =>
304: PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id,
305: p_org_structure_type => l_org_structure_type,
306: x_return_status => l_return_status,

Line 304: PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id,

300: PA_ORG_UTILS.Check_Org_In_OrgHierarchy(
301: p_organization_id =>
302: PA_SEARCH_GLOB.g_search_criteria.organization_id,
303: p_org_structure_version_id =>
304: PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id,
305: p_org_structure_type => l_org_structure_type,
306: x_return_status => l_return_status,
307: x_error_message_code => l_error_msg_data);
308:

Line 326: PA_SEARCH_GLOB.g_search_criteria.staffing_priority_code,

322: p_staffing_priority_code => p_staffing_priority_code,
323: p_staffing_priority_name => p_staffing_priority_name,
324: p_check_id_flag => PA_STARTUP.G_Check_ID_Flag,
325: x_staffing_priority_code =>
326: PA_SEARCH_GLOB.g_search_criteria.staffing_priority_code,
327: x_return_status => l_return_status,
328: x_error_message_code => l_error_msg_data);
329:
330: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 347: ,x_resource_id => PA_SEARCH_GLOB.g_search_criteria.staffing_owner_person_id

343: p_resource_id => p_staffing_owner_person_id
344: ,p_resource_name => p_staffing_owner_name
345: ,p_check_id_flag => PA_STARTUP.G_Check_ID_Flag
346: ,p_date => sysdate
347: ,x_resource_id => PA_SEARCH_GLOB.g_search_criteria.staffing_owner_person_id
348: ,x_resource_type_id => l_resource_type_id
349: ,x_return_status => l_return_status
350: ,x_error_message_code => l_error_message_code);
351:

Line 370: x_country_code => PA_SEARCH_GLOB.g_search_criteria.territory_code,

366: PA_LOCATION_UTILS.Check_Country_Name_Or_Code(
367: p_country_code => p_territory_code,
368: p_country_name => p_territory_short_name,
369: p_check_id_flag => PA_STARTUP.G_Check_ID_Flag,
370: x_country_code => PA_SEARCH_GLOB.g_search_criteria.territory_code,
371: x_return_status => l_return_status,
372: x_error_message_code => l_error_msg_data);
373:
374: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 380: PA_SEARCH_GLOB.g_search_criteria.region := p_region;

376: END IF;
377: END IF;
378:
379: -- Add region and city values to global search criteria.
380: PA_SEARCH_GLOB.g_search_criteria.region := p_region;
381: PA_SEARCH_GLOB.g_search_criteria.city := p_city;
382:
383: -- Add person type to global search criteria. Bug 6526674
384: PA_SEARCH_GLOB.g_search_criteria.person_type := p_person_type;

Line 381: PA_SEARCH_GLOB.g_search_criteria.city := p_city;

377: END IF;
378:
379: -- Add region and city values to global search criteria.
380: PA_SEARCH_GLOB.g_search_criteria.region := p_region;
381: PA_SEARCH_GLOB.g_search_criteria.city := p_city;
382:
383: -- Add person type to global search criteria. Bug 6526674
384: PA_SEARCH_GLOB.g_search_criteria.person_type := p_person_type;
385:

Line 384: PA_SEARCH_GLOB.g_search_criteria.person_type := p_person_type;

380: PA_SEARCH_GLOB.g_search_criteria.region := p_region;
381: PA_SEARCH_GLOB.g_search_criteria.city := p_city;
382:
383: -- Add person type to global search criteria. Bug 6526674
384: PA_SEARCH_GLOB.g_search_criteria.person_type := p_person_type;
385:
386: -- Add work preferences to global search criteria.
387: PA_SEARCH_GLOB.g_search_criteria.work_current_loc := p_work_current_loc;
388: PA_SEARCH_GLOB.g_search_criteria.work_all_loc := p_work_all_loc;

Line 387: PA_SEARCH_GLOB.g_search_criteria.work_current_loc := p_work_current_loc;

383: -- Add person type to global search criteria. Bug 6526674
384: PA_SEARCH_GLOB.g_search_criteria.person_type := p_person_type;
385:
386: -- Add work preferences to global search criteria.
387: PA_SEARCH_GLOB.g_search_criteria.work_current_loc := p_work_current_loc;
388: PA_SEARCH_GLOB.g_search_criteria.work_all_loc := p_work_all_loc;
389: PA_SEARCH_GLOB.g_search_criteria.travel_domestically :=
390: p_travel_domestically;
391: PA_SEARCH_GLOB.g_search_criteria.travel_internationally :=

Line 388: PA_SEARCH_GLOB.g_search_criteria.work_all_loc := p_work_all_loc;

384: PA_SEARCH_GLOB.g_search_criteria.person_type := p_person_type;
385:
386: -- Add work preferences to global search criteria.
387: PA_SEARCH_GLOB.g_search_criteria.work_current_loc := p_work_current_loc;
388: PA_SEARCH_GLOB.g_search_criteria.work_all_loc := p_work_all_loc;
389: PA_SEARCH_GLOB.g_search_criteria.travel_domestically :=
390: p_travel_domestically;
391: PA_SEARCH_GLOB.g_search_criteria.travel_internationally :=
392: p_travel_internationally;

Line 389: PA_SEARCH_GLOB.g_search_criteria.travel_domestically :=

385:
386: -- Add work preferences to global search criteria.
387: PA_SEARCH_GLOB.g_search_criteria.work_current_loc := p_work_current_loc;
388: PA_SEARCH_GLOB.g_search_criteria.work_all_loc := p_work_all_loc;
389: PA_SEARCH_GLOB.g_search_criteria.travel_domestically :=
390: p_travel_domestically;
391: PA_SEARCH_GLOB.g_search_criteria.travel_internationally :=
392: p_travel_internationally;
393:

Line 391: PA_SEARCH_GLOB.g_search_criteria.travel_internationally :=

387: PA_SEARCH_GLOB.g_search_criteria.work_current_loc := p_work_current_loc;
388: PA_SEARCH_GLOB.g_search_criteria.work_all_loc := p_work_all_loc;
389: PA_SEARCH_GLOB.g_search_criteria.travel_domestically :=
390: p_travel_domestically;
391: PA_SEARCH_GLOB.g_search_criteria.travel_internationally :=
392: p_travel_internationally;
393:
394: -- validate match weightings and assign them to global record
395:

Line 414: PA_SEARCH_GLOB.g_search_criteria.competence_match_weighting :=

410: p_app_short_name => 'PA'
411: ,p_msg_name => 'PA_INVALID_MATCH_WEIGHTING');
412: ELSE
413: -- assign match weightings to global record.
414: PA_SEARCH_GLOB.g_search_criteria.competence_match_weighting :=
415: p_comp_match_weighting;
416: PA_SEARCH_GLOB.g_search_criteria.availability_match_weighting :=
417: p_avail_match_weighting;
418: PA_SEARCH_GLOB.g_search_criteria.job_level_match_weighting :=

Line 416: PA_SEARCH_GLOB.g_search_criteria.availability_match_weighting :=

412: ELSE
413: -- assign match weightings to global record.
414: PA_SEARCH_GLOB.g_search_criteria.competence_match_weighting :=
415: p_comp_match_weighting;
416: PA_SEARCH_GLOB.g_search_criteria.availability_match_weighting :=
417: p_avail_match_weighting;
418: PA_SEARCH_GLOB.g_search_criteria.job_level_match_weighting :=
419: p_job_level_match_weighting;
420: END IF;

Line 418: PA_SEARCH_GLOB.g_search_criteria.job_level_match_weighting :=

414: PA_SEARCH_GLOB.g_search_criteria.competence_match_weighting :=
415: p_comp_match_weighting;
416: PA_SEARCH_GLOB.g_search_criteria.availability_match_weighting :=
417: p_avail_match_weighting;
418: PA_SEARCH_GLOB.g_search_criteria.job_level_match_weighting :=
419: p_job_level_match_weighting;
420: END IF;
421: END IF;
422:

Line 439: ,x_resource_id => PA_SEARCH_GLOB.g_search_criteria.resource_source_id

435: p_resource_id => p_resource_source_id
436: ,p_resource_name => p_resource_name
437: ,p_check_id_flag => PA_STARTUP.G_Check_ID_Flag
438: ,p_date => p_start_date
439: ,x_resource_id => PA_SEARCH_GLOB.g_search_criteria.resource_source_id
440: ,x_resource_type_id => l_resource_type_id
441: ,x_return_status => l_return_status
442: ,x_error_message_code => l_error_message_code);
443:

Line 461: ,x_role_id => PA_SEARCH_GLOB.g_search_criteria.role_id

457: PA_ROLE_UTILS.Check_Role_Name_Or_Id(
458: p_role_id => p_role_id
459: ,p_role_name => p_role_name
460: ,p_check_id_flag => PA_STARTUP.G_Check_ID_Flag
461: ,x_role_id => PA_SEARCH_GLOB.g_search_criteria.role_id
462: ,x_return_status => l_return_status
463: ,x_error_message_code => l_error_message_code );
464:
465: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 486: PA_SEARCH_GLOB.g_search_criteria.min_job_level := p_min_job_level;

482: ,p_msg_name => 'PA_MIN_JL_GREATER_THAN_MAX');
483: ELSE
484:
485: -- assign job levels to global record.
486: PA_SEARCH_GLOB.g_search_criteria.min_job_level := p_min_job_level;
487: PA_SEARCH_GLOB.g_search_criteria.max_job_level := p_max_job_level;
488: END IF;
489: END IF;
490:

Line 487: PA_SEARCH_GLOB.g_search_criteria.max_job_level := p_max_job_level;

483: ELSE
484:
485: -- assign job levels to global record.
486: PA_SEARCH_GLOB.g_search_criteria.min_job_level := p_min_job_level;
487: PA_SEARCH_GLOB.g_search_criteria.max_job_level := p_max_job_level;
488: END IF;
489: END IF;
490:
491: --Check that min availability is between 0 and 100

Line 501: PA_SEARCH_GLOB.g_search_criteria.min_availability :=

497: ,p_msg_name => 'PA_MIN_AVAIL_INVALID');
498: END IF;
499:
500: -- assign the min availability to the global record.
501: PA_SEARCH_GLOB.g_search_criteria.min_availability :=
502: p_minimum_availability;
503:
504: END IF;
505:

Line 507: PA_SEARCH_GLOB.g_search_criteria.provisional_availability :=

503:
504: END IF;
505:
506: -- Assign Provisional Availability to the global record.
507: PA_SEARCH_GLOB.g_search_criteria.provisional_availability :=
508: p_provisional_availability;
509:
510: -- validate that start date <= end date.
511: -- assign p_start_date to the global record before the validation

Line 518: PA_SEARCH_GLOB.g_search_criteria.start_date := p_start_date;

514: -- if the end date is passed in as well. The end date will only
515: -- be assigned to the global record if it is passed in and valid.
516:
517: IF p_start_date <> FND_API.G_MISS_DATE AND p_start_date IS NOT NULL THEN
518: PA_SEARCH_GLOB.g_search_criteria.start_date := p_start_date;
519: END IF;
520:
521: IF (p_start_date <> FND_API.G_MISS_DATE AND p_start_date IS NOT NULL) AND
522: (p_end_date <> FND_API.G_MISS_DATE AND p_end_date IS NOT NULL)

Line 534: PA_SEARCH_GLOB.g_search_criteria.end_date := p_end_date;

530:
531: -- if end date >= start date then assignment end date
532: -- to the global record.
533: --
534: PA_SEARCH_GLOB.g_search_criteria.end_date := p_end_date;
535:
536: END IF;
537:
538: IF (p_search_mode = 'RESOURCE') AND

Line 548: PA_SEARCH_GLOB.g_search_criteria.end_date := ADD_MONTHS(p_start_date,6);

544:
545: ELSIF (p_start_date <> FND_API.G_MISS_DATE AND
546: p_start_date IS NOT NULL) AND
547: (p_end_date = FND_API.G_MISS_DATE OR p_end_date IS NULL) THEN
548: PA_SEARCH_GLOB.g_search_criteria.end_date := ADD_MONTHS(p_start_date,6);
549: END IF;
550:
551: -- validate competence
552: -- competence name/alias/id will only be passed in if this is a

Line 562: l_index := PA_SEARCH_GLOB.g_competence_criteria.COUNT;

558: IF p_competence_id.COUNT > 0 THEN
559: FOR i in p_competence_id.first .. p_competence_id.last LOOP
560:
561: -- find the number of competences already in the global comp table.
562: l_index := PA_SEARCH_GLOB.g_competence_criteria.COUNT;
563:
564: IF p_competence_id(i) <> -1 THEN
565: IF p_competence_id(i) = -999 THEN
566: l_competence_id := NULL;

Line 598: PA_SEARCH_GLOB.g_competence_criteria(l_index).competence_id :=

594: PA_UTILS.Add_Message ('PA', l_error_msg_data);
595: ELSE
596:
597: -- insert the competence into the global table at l_index.
598: PA_SEARCH_GLOB.g_competence_criteria(l_index).competence_id :=
599: l_competence_id;
600: END IF;
601: ELSE
602: -- insert the competence category into the global table at l_index.

Line 603: PA_SEARCH_GLOB.g_competence_criteria(l_index).competence_id :=

599: l_competence_id;
600: END IF;
601: ELSE
602: -- insert the competence category into the global table at l_index.
603: PA_SEARCH_GLOB.g_competence_criteria(l_index).competence_id :=
604: p_competence_id(i);
605: END IF;
606:
607: PA_SEARCH_GLOB.g_competence_criteria(l_index).rating_level :=

Line 607: PA_SEARCH_GLOB.g_competence_criteria(l_index).rating_level :=

603: PA_SEARCH_GLOB.g_competence_criteria(l_index).competence_id :=
604: p_competence_id(i);
605: END IF;
606:
607: PA_SEARCH_GLOB.g_competence_criteria(l_index).rating_level :=
608: p_rating(i);
609: PA_SEARCH_GLOB.g_competence_criteria(l_index).mandatory_flag :=
610: p_mandatory(i);
611: PA_SEARCH_GLOB.g_competence_criteria(l_index).competence_name :=

Line 609: PA_SEARCH_GLOB.g_competence_criteria(l_index).mandatory_flag :=

605: END IF;
606:
607: PA_SEARCH_GLOB.g_competence_criteria(l_index).rating_level :=
608: p_rating(i);
609: PA_SEARCH_GLOB.g_competence_criteria(l_index).mandatory_flag :=
610: p_mandatory(i);
611: PA_SEARCH_GLOB.g_competence_criteria(l_index).competence_name :=
612: p_competence_name(i);
613:

Line 611: PA_SEARCH_GLOB.g_competence_criteria(l_index).competence_name :=

607: PA_SEARCH_GLOB.g_competence_criteria(l_index).rating_level :=
608: p_rating(i);
609: PA_SEARCH_GLOB.g_competence_criteria(l_index).mandatory_flag :=
610: p_mandatory(i);
611: PA_SEARCH_GLOB.g_competence_criteria(l_index).competence_name :=
612: p_competence_name(i);
613:
614: END LOOP;
615: END IF;

Line 631: PA_SEARCH_GLOB.g_search_criteria.work_current_loc := 'N';

627: ,x_Msg => 'resource search being execute from page OTHER than the resource search criteria page, get search criteria'
628: ,x_Log_Level => 6);
629: End If;
630:
631: PA_SEARCH_GLOB.g_search_criteria.work_current_loc := 'N';
632: PA_SEARCH_GLOB.g_search_criteria.work_all_loc := 'N';
633: PA_SEARCH_GLOB.g_search_criteria.travel_domestically := 'N';
634: PA_SEARCH_GLOB.g_search_criteria.travel_internationally := 'N';
635:

Line 632: PA_SEARCH_GLOB.g_search_criteria.work_all_loc := 'N';

628: ,x_Log_Level => 6);
629: End If;
630:
631: PA_SEARCH_GLOB.g_search_criteria.work_current_loc := 'N';
632: PA_SEARCH_GLOB.g_search_criteria.work_all_loc := 'N';
633: PA_SEARCH_GLOB.g_search_criteria.travel_domestically := 'N';
634: PA_SEARCH_GLOB.g_search_criteria.travel_internationally := 'N';
635:
636: -- Assign Provisional Availability to the global record.

Line 633: PA_SEARCH_GLOB.g_search_criteria.travel_domestically := 'N';

629: End If;
630:
631: PA_SEARCH_GLOB.g_search_criteria.work_current_loc := 'N';
632: PA_SEARCH_GLOB.g_search_criteria.work_all_loc := 'N';
633: PA_SEARCH_GLOB.g_search_criteria.travel_domestically := 'N';
634: PA_SEARCH_GLOB.g_search_criteria.travel_internationally := 'N';
635:
636: -- Assign Provisional Availability to the global record.
637: PA_SEARCH_GLOB.g_search_criteria.provisional_availability := 'N';

Line 634: PA_SEARCH_GLOB.g_search_criteria.travel_internationally := 'N';

630:
631: PA_SEARCH_GLOB.g_search_criteria.work_current_loc := 'N';
632: PA_SEARCH_GLOB.g_search_criteria.work_all_loc := 'N';
633: PA_SEARCH_GLOB.g_search_criteria.travel_domestically := 'N';
634: PA_SEARCH_GLOB.g_search_criteria.travel_internationally := 'N';
635:
636: -- Assign Provisional Availability to the global record.
637: PA_SEARCH_GLOB.g_search_criteria.provisional_availability := 'N';
638:

Line 637: PA_SEARCH_GLOB.g_search_criteria.provisional_availability := 'N';

633: PA_SEARCH_GLOB.g_search_criteria.travel_domestically := 'N';
634: PA_SEARCH_GLOB.g_search_criteria.travel_internationally := 'N';
635:
636: -- Assign Provisional Availability to the global record.
637: PA_SEARCH_GLOB.g_search_criteria.provisional_availability := 'N';
638:
639: -- get the search criteria for the assignment.
640: OPEN get_search_criteria;
641:

Line 643: PA_SEARCH_GLOB.g_search_criteria.min_job_level,

639: -- get the search criteria for the assignment.
640: OPEN get_search_criteria;
641:
642: FETCH get_search_criteria INTO
643: PA_SEARCH_GLOB.g_search_criteria.min_job_level,
644: PA_SEARCH_GLOB.g_search_criteria.max_job_level,
645: PA_SEARCH_GLOB.g_search_criteria.start_date,
646: PA_SEARCH_GLOB.g_search_criteria.end_date,
647: PA_SEARCH_GLOB.g_search_criteria.competence_match_weighting,

Line 644: PA_SEARCH_GLOB.g_search_criteria.max_job_level,

640: OPEN get_search_criteria;
641:
642: FETCH get_search_criteria INTO
643: PA_SEARCH_GLOB.g_search_criteria.min_job_level,
644: PA_SEARCH_GLOB.g_search_criteria.max_job_level,
645: PA_SEARCH_GLOB.g_search_criteria.start_date,
646: PA_SEARCH_GLOB.g_search_criteria.end_date,
647: PA_SEARCH_GLOB.g_search_criteria.competence_match_weighting,
648: PA_SEARCH_GLOB.g_search_criteria.availability_match_weighting,

Line 645: PA_SEARCH_GLOB.g_search_criteria.start_date,

641:
642: FETCH get_search_criteria INTO
643: PA_SEARCH_GLOB.g_search_criteria.min_job_level,
644: PA_SEARCH_GLOB.g_search_criteria.max_job_level,
645: PA_SEARCH_GLOB.g_search_criteria.start_date,
646: PA_SEARCH_GLOB.g_search_criteria.end_date,
647: PA_SEARCH_GLOB.g_search_criteria.competence_match_weighting,
648: PA_SEARCH_GLOB.g_search_criteria.availability_match_weighting,
649: PA_SEARCH_GLOB.g_search_criteria.job_level_match_weighting,

Line 646: PA_SEARCH_GLOB.g_search_criteria.end_date,

642: FETCH get_search_criteria INTO
643: PA_SEARCH_GLOB.g_search_criteria.min_job_level,
644: PA_SEARCH_GLOB.g_search_criteria.max_job_level,
645: PA_SEARCH_GLOB.g_search_criteria.start_date,
646: PA_SEARCH_GLOB.g_search_criteria.end_date,
647: PA_SEARCH_GLOB.g_search_criteria.competence_match_weighting,
648: PA_SEARCH_GLOB.g_search_criteria.availability_match_weighting,
649: PA_SEARCH_GLOB.g_search_criteria.job_level_match_weighting,
650: PA_SEARCH_GLOB.g_search_criteria.min_availability,

Line 647: PA_SEARCH_GLOB.g_search_criteria.competence_match_weighting,

643: PA_SEARCH_GLOB.g_search_criteria.min_job_level,
644: PA_SEARCH_GLOB.g_search_criteria.max_job_level,
645: PA_SEARCH_GLOB.g_search_criteria.start_date,
646: PA_SEARCH_GLOB.g_search_criteria.end_date,
647: PA_SEARCH_GLOB.g_search_criteria.competence_match_weighting,
648: PA_SEARCH_GLOB.g_search_criteria.availability_match_weighting,
649: PA_SEARCH_GLOB.g_search_criteria.job_level_match_weighting,
650: PA_SEARCH_GLOB.g_search_criteria.min_availability,
651: PA_SEARCH_GLOB.g_search_criteria.territory_code,

Line 648: PA_SEARCH_GLOB.g_search_criteria.availability_match_weighting,

644: PA_SEARCH_GLOB.g_search_criteria.max_job_level,
645: PA_SEARCH_GLOB.g_search_criteria.start_date,
646: PA_SEARCH_GLOB.g_search_criteria.end_date,
647: PA_SEARCH_GLOB.g_search_criteria.competence_match_weighting,
648: PA_SEARCH_GLOB.g_search_criteria.availability_match_weighting,
649: PA_SEARCH_GLOB.g_search_criteria.job_level_match_weighting,
650: PA_SEARCH_GLOB.g_search_criteria.min_availability,
651: PA_SEARCH_GLOB.g_search_criteria.territory_code,
652: PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id,

Line 649: PA_SEARCH_GLOB.g_search_criteria.job_level_match_weighting,

645: PA_SEARCH_GLOB.g_search_criteria.start_date,
646: PA_SEARCH_GLOB.g_search_criteria.end_date,
647: PA_SEARCH_GLOB.g_search_criteria.competence_match_weighting,
648: PA_SEARCH_GLOB.g_search_criteria.availability_match_weighting,
649: PA_SEARCH_GLOB.g_search_criteria.job_level_match_weighting,
650: PA_SEARCH_GLOB.g_search_criteria.min_availability,
651: PA_SEARCH_GLOB.g_search_criteria.territory_code,
652: PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id,
653: PA_SEARCH_GLOB.g_search_criteria.organization_id;

Line 650: PA_SEARCH_GLOB.g_search_criteria.min_availability,

646: PA_SEARCH_GLOB.g_search_criteria.end_date,
647: PA_SEARCH_GLOB.g_search_criteria.competence_match_weighting,
648: PA_SEARCH_GLOB.g_search_criteria.availability_match_weighting,
649: PA_SEARCH_GLOB.g_search_criteria.job_level_match_weighting,
650: PA_SEARCH_GLOB.g_search_criteria.min_availability,
651: PA_SEARCH_GLOB.g_search_criteria.territory_code,
652: PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id,
653: PA_SEARCH_GLOB.g_search_criteria.organization_id;
654:

Line 651: PA_SEARCH_GLOB.g_search_criteria.territory_code,

647: PA_SEARCH_GLOB.g_search_criteria.competence_match_weighting,
648: PA_SEARCH_GLOB.g_search_criteria.availability_match_weighting,
649: PA_SEARCH_GLOB.g_search_criteria.job_level_match_weighting,
650: PA_SEARCH_GLOB.g_search_criteria.min_availability,
651: PA_SEARCH_GLOB.g_search_criteria.territory_code,
652: PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id,
653: PA_SEARCH_GLOB.g_search_criteria.organization_id;
654:
655: IF PA_SEARCH_GLOB.g_search_criteria.start_date < SYSDATE AND

Line 652: PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id,

648: PA_SEARCH_GLOB.g_search_criteria.availability_match_weighting,
649: PA_SEARCH_GLOB.g_search_criteria.job_level_match_weighting,
650: PA_SEARCH_GLOB.g_search_criteria.min_availability,
651: PA_SEARCH_GLOB.g_search_criteria.territory_code,
652: PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id,
653: PA_SEARCH_GLOB.g_search_criteria.organization_id;
654:
655: IF PA_SEARCH_GLOB.g_search_criteria.start_date < SYSDATE AND
656: PA_SEARCH_GLOB.g_search_criteria.end_date < SYSDATE

Line 653: PA_SEARCH_GLOB.g_search_criteria.organization_id;

649: PA_SEARCH_GLOB.g_search_criteria.job_level_match_weighting,
650: PA_SEARCH_GLOB.g_search_criteria.min_availability,
651: PA_SEARCH_GLOB.g_search_criteria.territory_code,
652: PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id,
653: PA_SEARCH_GLOB.g_search_criteria.organization_id;
654:
655: IF PA_SEARCH_GLOB.g_search_criteria.start_date < SYSDATE AND
656: PA_SEARCH_GLOB.g_search_criteria.end_date < SYSDATE
657: THEN

Line 655: IF PA_SEARCH_GLOB.g_search_criteria.start_date < SYSDATE AND

651: PA_SEARCH_GLOB.g_search_criteria.territory_code,
652: PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id,
653: PA_SEARCH_GLOB.g_search_criteria.organization_id;
654:
655: IF PA_SEARCH_GLOB.g_search_criteria.start_date < SYSDATE AND
656: PA_SEARCH_GLOB.g_search_criteria.end_date < SYSDATE
657: THEN
658: PA_UTILS.Add_Message(p_app_short_name => 'PA'
659: ,p_msg_name => 'PA_REQ_DATES_IN_PAST');

Line 656: PA_SEARCH_GLOB.g_search_criteria.end_date < SYSDATE

652: PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id,
653: PA_SEARCH_GLOB.g_search_criteria.organization_id;
654:
655: IF PA_SEARCH_GLOB.g_search_criteria.start_date < SYSDATE AND
656: PA_SEARCH_GLOB.g_search_criteria.end_date < SYSDATE
657: THEN
658: PA_UTILS.Add_Message(p_app_short_name => 'PA'
659: ,p_msg_name => 'PA_REQ_DATES_IN_PAST');
660: END IF;

Line 673: p_object_id => PA_SEARCH_GLOB.g_search_criteria.assignment_id,

669:
670: -- get the competencies for the requirement
671: PA_HR_COMPETENCE_UTILS.get_competencies(
672: p_object_name => 'OPEN_ASSIGNMENT',
673: p_object_id => PA_SEARCH_GLOB.g_search_criteria.assignment_id,
674: x_competency_tbl => l_competency_tbl,
675: x_no_of_competencies => l_no_of_competencies,
676: x_error_message_code => l_error_msg_data,
677: x_return_status => l_return_status);

Line 687: PA_SEARCH_GLOB.g_competence_criteria(i).competence_id :=

683:
684: -- store the competences in the global comp table.
685: FOR i IN l_competency_tbl.FIRST..l_competency_tbl.LAST LOOP
686:
687: PA_SEARCH_GLOB.g_competence_criteria(i).competence_id :=
688: l_competency_tbl(i).competence_id;
689: PA_SEARCH_GLOB.g_competence_criteria(i).competence_alias :=
690: l_competency_tbl(i).competence_alias;
691: PA_SEARCH_GLOB.g_competence_criteria(i).mandatory_flag :=

Line 689: PA_SEARCH_GLOB.g_competence_criteria(i).competence_alias :=

685: FOR i IN l_competency_tbl.FIRST..l_competency_tbl.LAST LOOP
686:
687: PA_SEARCH_GLOB.g_competence_criteria(i).competence_id :=
688: l_competency_tbl(i).competence_id;
689: PA_SEARCH_GLOB.g_competence_criteria(i).competence_alias :=
690: l_competency_tbl(i).competence_alias;
691: PA_SEARCH_GLOB.g_competence_criteria(i).mandatory_flag :=
692: l_competency_tbl(i).mandatory;
693:

Line 691: PA_SEARCH_GLOB.g_competence_criteria(i).mandatory_flag :=

687: PA_SEARCH_GLOB.g_competence_criteria(i).competence_id :=
688: l_competency_tbl(i).competence_id;
689: PA_SEARCH_GLOB.g_competence_criteria(i).competence_alias :=
690: l_competency_tbl(i).competence_alias;
691: PA_SEARCH_GLOB.g_competence_criteria(i).mandatory_flag :=
692: l_competency_tbl(i).mandatory;
693:
694: -- get the rating level given the id if id is not null
695: -- and store in global comp table.

Line 699: PA_SEARCH_GLOB.g_competence_criteria(i).rating_level;

695: -- and store in global comp table.
696: IF l_competency_tbl(i).rating_level_id IS NOT NULL THEN
697: OPEN get_step_value(l_competency_tbl(i).rating_level_id);
698: FETCH get_step_value INTO
699: PA_SEARCH_GLOB.g_competence_criteria(i).rating_level;
700: CLOSE get_step_value;
701: ELSE
702: PA_SEARCH_GLOB.g_competence_criteria(i).rating_level := NULL;
703: END IF;

Line 702: PA_SEARCH_GLOB.g_competence_criteria(i).rating_level := NULL;

698: FETCH get_step_value INTO
699: PA_SEARCH_GLOB.g_competence_criteria(i).rating_level;
700: CLOSE get_step_value;
701: ELSE
702: PA_SEARCH_GLOB.g_competence_criteria(i).rating_level := NULL;
703: END IF;
704:
705: END LOOP;
706:

Line 736: x_Msg => 'assignment_id=' || PA_SEARCH_GLOB.g_search_criteria.assignment_id,

732: x_Msg => 'p_search_mode=' || p_search_mode,
733: x_Log_Level => 6);
734: PA_DEBUG.WRITE_LOG(
735: x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.parameter',
736: x_Msg => 'assignment_id=' || PA_SEARCH_GLOB.g_search_criteria.assignment_id,
737: x_Log_Level => 6);
738: PA_DEBUG.WRITE_LOG(
739: x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.parameter',
740: x_Msg => 'resource_source_id' || PA_SEARCH_GLOB.g_search_criteria.resource_source_id,

Line 740: x_Msg => 'resource_source_id' || PA_SEARCH_GLOB.g_search_criteria.resource_source_id,

736: x_Msg => 'assignment_id=' || PA_SEARCH_GLOB.g_search_criteria.assignment_id,
737: x_Log_Level => 6);
738: PA_DEBUG.WRITE_LOG(
739: x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.parameter',
740: x_Msg => 'resource_source_id' || PA_SEARCH_GLOB.g_search_criteria.resource_source_id,
741: x_Log_Level => 6);
742: PA_DEBUG.WRITE_LOG(
743: x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.parameter',
744: x_Msg => 'project_id=' || PA_SEARCH_GLOB.g_search_criteria.project_id,

Line 744: x_Msg => 'project_id=' || PA_SEARCH_GLOB.g_search_criteria.project_id,

740: x_Msg => 'resource_source_id' || PA_SEARCH_GLOB.g_search_criteria.resource_source_id,
741: x_Log_Level => 6);
742: PA_DEBUG.WRITE_LOG(
743: x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.parameter',
744: x_Msg => 'project_id=' || PA_SEARCH_GLOB.g_search_criteria.project_id,
745: x_Log_Level => 6);
746: PA_DEBUG.WRITE_LOG(
747: x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.parameter',
748: x_Msg => 'min_job_level=' || PA_SEARCH_GLOB.g_search_criteria.min_job_level,

Line 748: x_Msg => 'min_job_level=' || PA_SEARCH_GLOB.g_search_criteria.min_job_level,

744: x_Msg => 'project_id=' || PA_SEARCH_GLOB.g_search_criteria.project_id,
745: x_Log_Level => 6);
746: PA_DEBUG.WRITE_LOG(
747: x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.parameter',
748: x_Msg => 'min_job_level=' || PA_SEARCH_GLOB.g_search_criteria.min_job_level,
749: x_Log_Level => 6);
750: PA_DEBUG.WRITE_LOG(
751: x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.parameter',
752: x_Msg => 'max_job_level=' || PA_SEARCH_GLOB.g_search_criteria.max_job_level,

Line 752: x_Msg => 'max_job_level=' || PA_SEARCH_GLOB.g_search_criteria.max_job_level,

748: x_Msg => 'min_job_level=' || PA_SEARCH_GLOB.g_search_criteria.min_job_level,
749: x_Log_Level => 6);
750: PA_DEBUG.WRITE_LOG(
751: x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.parameter',
752: x_Msg => 'max_job_level=' || PA_SEARCH_GLOB.g_search_criteria.max_job_level,
753: x_Log_Level => 6);
754: PA_DEBUG.WRITE_LOG(
755: x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.parameter',
756: x_Msg => 'org_hierarchy_version_id=' || PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id,

Line 756: x_Msg => 'org_hierarchy_version_id=' || PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id,

752: x_Msg => 'max_job_level=' || PA_SEARCH_GLOB.g_search_criteria.max_job_level,
753: x_Log_Level => 6);
754: PA_DEBUG.WRITE_LOG(
755: x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.parameter',
756: x_Msg => 'org_hierarchy_version_id=' || PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id,
757: x_Log_Level => 6);
758: PA_DEBUG.WRITE_LOG(
759: x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.parameter',
760: x_Msg => 'organization_id=' || PA_SEARCH_GLOB.g_search_criteria.organization_id,

Line 760: x_Msg => 'organization_id=' || PA_SEARCH_GLOB.g_search_criteria.organization_id,

756: x_Msg => 'org_hierarchy_version_id=' || PA_SEARCH_GLOB.g_search_criteria.org_hierarchy_version_id,
757: x_Log_Level => 6);
758: PA_DEBUG.WRITE_LOG(
759: x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.parameter',
760: x_Msg => 'organization_id=' || PA_SEARCH_GLOB.g_search_criteria.organization_id,
761: x_Log_Level => 6);
762: PA_DEBUG.WRITE_LOG(
763: x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.parameter',
764: x_Msg => 'territory_code=' || PA_SEARCH_GLOB.g_search_criteria.territory_code,

Line 764: x_Msg => 'territory_code=' || PA_SEARCH_GLOB.g_search_criteria.territory_code,

760: x_Msg => 'organization_id=' || PA_SEARCH_GLOB.g_search_criteria.organization_id,
761: x_Log_Level => 6);
762: PA_DEBUG.WRITE_LOG(
763: x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.parameter',
764: x_Msg => 'territory_code=' || PA_SEARCH_GLOB.g_search_criteria.territory_code,
765: x_Log_Level => 6);
766: PA_DEBUG.WRITE_LOG(
767: x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.parameter',
768: x_Msg => 'start_date=' || PA_SEARCH_GLOB.g_search_criteria.start_date,

Line 768: x_Msg => 'start_date=' || PA_SEARCH_GLOB.g_search_criteria.start_date,

764: x_Msg => 'territory_code=' || PA_SEARCH_GLOB.g_search_criteria.territory_code,
765: x_Log_Level => 6);
766: PA_DEBUG.WRITE_LOG(
767: x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.parameter',
768: x_Msg => 'start_date=' || PA_SEARCH_GLOB.g_search_criteria.start_date,
769: x_Log_Level => 6);
770: PA_DEBUG.WRITE_LOG(
771: x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.parameter',
772: x_Msg => 'end_date=' || PA_SEARCH_GLOB.g_search_criteria.end_date,

Line 772: x_Msg => 'end_date=' || PA_SEARCH_GLOB.g_search_criteria.end_date,

768: x_Msg => 'start_date=' || PA_SEARCH_GLOB.g_search_criteria.start_date,
769: x_Log_Level => 6);
770: PA_DEBUG.WRITE_LOG(
771: x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.parameter',
772: x_Msg => 'end_date=' || PA_SEARCH_GLOB.g_search_criteria.end_date,
773: x_Log_Level => 6);
774: PA_DEBUG.WRITE_LOG(
775: x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.parameter',
776: x_Msg => 'min_availability=' || PA_SEARCH_GLOB.g_search_criteria.min_availability,

Line 776: x_Msg => 'min_availability=' || PA_SEARCH_GLOB.g_search_criteria.min_availability,

772: x_Msg => 'end_date=' || PA_SEARCH_GLOB.g_search_criteria.end_date,
773: x_Log_Level => 6);
774: PA_DEBUG.WRITE_LOG(
775: x_Module => 'pa.plsql.PA_SEARCH_PUB.Run_Search.parameter',
776: x_Msg => 'min_availability=' || PA_SEARCH_GLOB.g_search_criteria.min_availability,
777: x_Log_Level => 6);
778: End if;
779:
780: END IF;

Line 790: , p_search_criteria => PA_SEARCH_GLOB.g_search_criteria

786: End If;
787:
788: PA_SEARCH_PVT.Run_Search(
789: p_search_mode => p_search_mode
790: , p_search_criteria => PA_SEARCH_GLOB.g_search_criteria
791: , p_competence_criteria => PA_SEARCH_GLOB.g_competence_criteria
792: , p_commit => p_commit
793: , p_validate_only => p_validate_only
794: , x_return_status => l_return_status

Line 791: , p_competence_criteria => PA_SEARCH_GLOB.g_competence_criteria

787:
788: PA_SEARCH_PVT.Run_Search(
789: p_search_mode => p_search_mode
790: , p_search_criteria => PA_SEARCH_GLOB.g_search_criteria
791: , p_competence_criteria => PA_SEARCH_GLOB.g_competence_criteria
792: , p_commit => p_commit
793: , p_validate_only => p_validate_only
794: , x_return_status => l_return_status
795: );

Line 798: PA_SEARCH_GLOB.g_search_criteria := NULL;

794: , x_return_status => l_return_status
795: );
796:
797: -- clear the globals
798: PA_SEARCH_GLOB.g_search_criteria := NULL;
799: PA_SEARCH_GLOB.g_competence_criteria.DELETE;
800:
801: -- Reset the error stack when returning to the calling environment
802: PA_DEBUG.Reset_Err_Stack;

Line 799: PA_SEARCH_GLOB.g_competence_criteria.DELETE;

795: );
796:
797: -- clear the globals
798: PA_SEARCH_GLOB.g_search_criteria := NULL;
799: PA_SEARCH_GLOB.g_competence_criteria.DELETE;
800:
801: -- Reset the error stack when returning to the calling environment
802: PA_DEBUG.Reset_Err_Stack;
803:

Line 828: PA_SEARCH_GLOB.g_search_criteria := NULL;

824:
825: x_return_status := FND_API.G_RET_STS_ERROR;
826:
827: -- clear the globals
828: PA_SEARCH_GLOB.g_search_criteria := NULL;
829: PA_SEARCH_GLOB.g_competence_criteria.DELETE;
830:
831: END IF;
832:

Line 829: PA_SEARCH_GLOB.g_competence_criteria.DELETE;

825: x_return_status := FND_API.G_RET_STS_ERROR;
826:
827: -- clear the globals
828: PA_SEARCH_GLOB.g_search_criteria := NULL;
829: PA_SEARCH_GLOB.g_competence_criteria.DELETE;
830:
831: END IF;
832:
833: EXCEPTION

Line 837: PA_SEARCH_GLOB.g_search_criteria := NULL;

833: EXCEPTION
834: WHEN OTHERS THEN
835:
836: -- clear the globals
837: PA_SEARCH_GLOB.g_search_criteria := NULL;
838: PA_SEARCH_GLOB.g_competence_criteria.DELETE;
839:
840: IF p_commit = FND_API.G_TRUE THEN
841: ROLLBACK TO SEARCH_PUB_RUN_OA_SEARCH;

Line 838: PA_SEARCH_GLOB.g_competence_criteria.DELETE;

834: WHEN OTHERS THEN
835:
836: -- clear the globals
837: PA_SEARCH_GLOB.g_search_criteria := NULL;
838: PA_SEARCH_GLOB.g_competence_criteria.DELETE;
839:
840: IF p_commit = FND_API.G_TRUE THEN
841: ROLLBACK TO SEARCH_PUB_RUN_OA_SEARCH;
842: END IF;