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_ASSIGNMENT_APPROVAL_PUB dependencies on FND_API

Line 32: ,p_note_to_approver IN VARCHAR2 := FND_API.G_MISS_CHAR

28: PROCEDURE Start_Assignment_Approvals
29: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE
30: ,p_new_assignment_flag IN VARCHAR2
31: ,p_action_code IN VARCHAR2
32: ,p_note_to_approver IN VARCHAR2 := FND_API.G_MISS_CHAR
33: ,p_record_version_number IN NUMBER
34: ,p_apr_person_id IN NUMBER DEFAULT NULL
35: ,p_apr_person_name IN VARCHAR2 DEFAULT NULL
36: ,p_apr_person_type IN VARCHAR2 DEFAULT NULL

Line 43: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

39: ,p_check_overcommitment_flag IN VARCHAR2 := 'N'
40: ,p_conflict_group_id IN NUMBER DEFAULT NULL
41: ,p_resolve_con_action_code IN VARCHAR2 DEFAULT NULL
42: ,p_api_version IN NUMBER := 1.0
43: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
44: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
45: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
46: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
47: ,x_overcommitment_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 44: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

40: ,p_conflict_group_id IN NUMBER DEFAULT NULL
41: ,p_resolve_con_action_code IN VARCHAR2 DEFAULT NULL
42: ,p_api_version IN NUMBER := 1.0
43: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
44: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
45: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
46: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
47: ,x_overcommitment_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
48: ,x_conflict_group_id OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 45: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

41: ,p_resolve_con_action_code IN VARCHAR2 DEFAULT NULL
42: ,p_api_version IN NUMBER := 1.0
43: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
44: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
45: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
46: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
47: ,x_overcommitment_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
48: ,x_conflict_group_id OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
49: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 46: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

42: ,p_api_version IN NUMBER := 1.0
43: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
44: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
45: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
46: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
47: ,x_overcommitment_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
48: ,x_conflict_group_id OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
49: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
50: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 133: x_return_status := FND_API.G_RET_STS_SUCCESS;

129: ,x_log_level => 5);
130: END IF;
131:
132: -- Initialize the out paramaters
133: x_return_status := FND_API.G_RET_STS_SUCCESS;
134: x_overcommitment_flag := 'N';
135: x_conflict_group_id := null;
136:
137: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

Line 137: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

133: x_return_status := FND_API.G_RET_STS_SUCCESS;
134: x_overcommitment_flag := 'N';
135: x_conflict_group_id := null;
136:
137: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
138: --Clear the global PL/SQL message table
139: FND_MSG_PUB.initialize;
140:
141: -- delete all the records from the approver_tbl

Line 146: IF p_commit = FND_API.G_TRUE THEN

142: PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl.delete;
143: END IF;
144:
145: -- Issue API savepoint if the transaction is to be committed
146: IF p_commit = FND_API.G_TRUE THEN
147: SAVEPOINT ASG_APR_PUB_START_APPRVL;
148: END IF;
149:
150: -- set local variables

Line 166: IF (p_apr_person_id IS NOT NULL AND p_apr_person_id <>FND_API.G_MISS_NUM) OR

162: --------------------------------------------------------------------------------------------------------
163: -- Put the approver's info into global PL/SQL table
164: --------------------------------------------------------------------------------------------------------
165: -- Check Resource Name or ID
166: IF (p_apr_person_id IS NOT NULL AND p_apr_person_id <>FND_API.G_MISS_NUM) OR
167: (p_apr_person_name IS NOT NULL AND p_apr_person_name <>FND_API.G_MISS_CHAR) THEN
168:
169: l_approver_person_id := p_apr_person_id;
170:

Line 167: (p_apr_person_name IS NOT NULL AND p_apr_person_name <>FND_API.G_MISS_CHAR) THEN

163: -- Put the approver's info into global PL/SQL table
164: --------------------------------------------------------------------------------------------------------
165: -- Check Resource Name or ID
166: IF (p_apr_person_id IS NOT NULL AND p_apr_person_id <>FND_API.G_MISS_NUM) OR
167: (p_apr_person_name IS NOT NULL AND p_apr_person_name <>FND_API.G_MISS_CHAR) THEN
168:
169: l_approver_person_id := p_apr_person_id;
170:
171: --Log Message

Line 197: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

193: ,x_return_status => l_return_status
194: ,x_error_message_code => l_error_message_code);
195: PA_STARTUP.G_Check_ID_Flag := l_check_id_flag;
196: -- bug 4537865
197: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
198: l_approver_person_id := l_new_approver_person_id;
199: END IF;
200: -- bug 4537865
201: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 201: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

197: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
198: l_approver_person_id := l_new_approver_person_id;
199: END IF;
200: -- bug 4537865
201: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
202: PA_UTILS.Add_Message('PA', l_error_message_code);
203:
204: ELSE
205: -- Get submitter_person_id : added for bug#2247058

Line 214: l_return_status := FND_API.G_MISS_CHAR;

210: p_msg_name => 'PA_NO_EMP_ID_USER');
211: END IF;
212: CLOSE l_submitter_person_id_csr;
213:
214: l_return_status := FND_API.G_MISS_CHAR;
215: l_error_message_code := FND_API.G_MISS_CHAR;
216:
217: -- Put the Approver into record only exclude flag=N and submitter is not the approver
218: IF p_apr_person_exclude = 'N' AND l_submitter_person_id <> l_approver_person_id THEN

Line 215: l_error_message_code := FND_API.G_MISS_CHAR;

211: END IF;
212: CLOSE l_submitter_person_id_csr;
213:
214: l_return_status := FND_API.G_MISS_CHAR;
215: l_error_message_code := FND_API.G_MISS_CHAR;
216:
217: -- Put the Approver into record only exclude flag=N and submitter is not the approver
218: IF p_apr_person_exclude = 'N' AND l_submitter_person_id <> l_approver_person_id THEN
219: IF P_DEBUG_MODE = 'Y' THEN

Line 251: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

247:
248: x_overcommitment_flag := l_overcommitment_flag;
249: x_conflict_group_id := to_char(l_conflict_group_id);
250:
251: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
252: RAISE FND_API.G_EXC_ERROR;
253: END IF;
254:
255: IF (l_overcommitment_flag = 'Y') THEN

Line 252: RAISE FND_API.G_EXC_ERROR;

248: x_overcommitment_flag := l_overcommitment_flag;
249: x_conflict_group_id := to_char(l_conflict_group_id);
250:
251: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
252: RAISE FND_API.G_EXC_ERROR;
253: END IF;
254:
255: IF (l_overcommitment_flag = 'Y') THEN
256: return;

Line 263: IF (p_validate_only = FND_API.G_FALSE AND (p_check_overcommitment_flag ='N'

259:
260: --------------------------------------------------------------------------------------------------------
261: -- If p_validate_only = FALSE and need to check overcom, then do all the processing to start assignment approval
262: --------------------------------------------------------------------------------------------------------
263: IF (p_validate_only = FND_API.G_FALSE AND (p_check_overcommitment_flag ='N'
264: OR (p_check_overcommitment_flag ='Y' AND l_overcommitment_flag = 'N'))) THEN
265:
266: IF P_DEBUG_MODE = 'Y' THEN
267: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PUB.Start_Assignment_Approvals.validate_false'

Line 303: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

299: ,p_new_assignment_flag => p_new_assignment_flag
300: ,x_approval_required_flag => l_approval_required_flag
301: ,x_return_status => l_return_status);
302:
303: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
304:
305: --------------------------------------------------------------------------------------------------------
306: -- If Approval Required
307: --------------------------------------------------------------------------------------------------------

Line 324: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

320: x_msg_data => l_msg_data,
321: x_return_status => l_return_status,
322: x_error_message_code => l_error_message_code);
323:
324: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
325: PA_UTILS.Add_Message('PA',l_error_message_code);
326: END IF;
327: /* commented out for bug #2247058
328: --------------------------------------------------------------------------------------------------------

Line 344: END IF; -- l_return_status = FND_API.G_RET_STS_SUCCESS

340: ELSE
341: l_action_code := PA_ASSIGNMENT_APPROVAL_PUB.g_approve_action;
342: END IF; -- if l_approval_required_flag = 'Y'
343:
344: END IF; -- l_return_status = FND_API.G_RET_STS_SUCCESS
345:
346: END IF; -- If Action = SUBMIT
347:
348:

Line 428: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

424: ,x_return_status => l_return_status
425: ,x_msg_count => l_msg_count
426: ,x_msg_data => l_msg_data);
427:
428: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
429: l_return_status := FND_API.G_MISS_CHAR;
430:
431: --------------------------------------------------------------------------------------------------------
432: -- Resolve Overcommitment conflict for Approve case

Line 429: l_return_status := FND_API.G_MISS_CHAR;

425: ,x_msg_count => l_msg_count
426: ,x_msg_data => l_msg_data);
427:
428: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
429: l_return_status := FND_API.G_MISS_CHAR;
430:
431: --------------------------------------------------------------------------------------------------------
432: -- Resolve Overcommitment conflict for Approve case
433: --------------------------------------------------------------------------------------------------------

Line 441: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

437: ,p_assignment_id => p_assignment_id
438: ,x_return_status => l_return_status
439: ,x_msg_count => l_msg_count
440: ,x_msg_data => l_msg_data);
441: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
442: RAISE FND_API.G_EXC_ERROR;
443: END IF;
444:
445: -- complete post overcommitment processing

Line 442: RAISE FND_API.G_EXC_ERROR;

438: ,x_return_status => l_return_status
439: ,x_msg_count => l_msg_count
440: ,x_msg_data => l_msg_data);
441: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
442: RAISE FND_API.G_EXC_ERROR;
443: END IF;
444:
445: -- complete post overcommitment processing
446: PA_SCHEDULE_PVT.OVERCOM_POST_APRVL_PROCESSING

Line 452: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

448: ,p_fnd_user_name => FND_GLOBAL.USER_NAME
449: ,x_return_status => l_return_status
450: ,x_msg_count => l_msg_count
451: ,x_msg_data => l_msg_data);
452: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
453: RAISE FND_API.G_EXC_ERROR;
454: END IF;
455: END IF; -- IF (l_conflict_group_id IS NOT NULL...
456:

Line 453: RAISE FND_API.G_EXC_ERROR;

449: ,x_return_status => l_return_status
450: ,x_msg_count => l_msg_count
451: ,x_msg_data => l_msg_data);
452: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
453: RAISE FND_API.G_EXC_ERROR;
454: END IF;
455: END IF; -- IF (l_conflict_group_id IS NOT NULL...
456:
457:

Line 477: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

473: x_return_status => l_return_status,
474: x_error_message_code => l_error_message_code);
475: --dbms_output.put_line('inside wf type'||l_wf_type);
476:
477: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
478: PA_UTILS.Add_Message('PA', l_error_message_code);
479: END IF;
480:
481: END IF; -- (l_wf_item_type IS NULL AND l..

Line 537: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

533: ,x_project_role_name => l_project_role_name
534: ,x_return_status => l_return_status
535: ,x_error_message_code => l_error_message_code );
536:
537: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
538: PA_UTILS.Add_Message('PA', l_error_message_code);
539: END IF;
540:
541: l_return_status := FND_API.G_MISS_CHAR;

Line 541: l_return_status := FND_API.G_MISS_CHAR;

537: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
538: PA_UTILS.Add_Message('PA', l_error_message_code);
539: END IF;
540:
541: l_return_status := FND_API.G_MISS_CHAR;
542: l_error_message_code := FND_API.G_MISS_CHAR;
543: END IF; -- IF l_assignment_type <> 'STAFFED_ADMIN_ASSIGNMENT'
544:
545: ----------------------------------------------------------

Line 542: l_error_message_code := FND_API.G_MISS_CHAR;

538: PA_UTILS.Add_Message('PA', l_error_message_code);
539: END IF;
540:
541: l_return_status := FND_API.G_MISS_CHAR;
542: l_error_message_code := FND_API.G_MISS_CHAR;
543: END IF; -- IF l_assignment_type <> 'STAFFED_ADMIN_ASSIGNMENT'
544:
545: ----------------------------------------------------------
546: -- check Pending Approval

Line 586: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

582: , x_return_status => l_return_status
583: , x_error_message_code => l_error_message_code);
584: --dbms_output.put_line('start_workflow return status:'||l_return_status );
585:
586: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
587: PA_UTILS.Add_Message('PA', l_error_message_code);
588: END IF;
589: END IF; -- FND_MSG_PUB.Count_Msg < 1
590:

Line 592: END IF; -- return_status of update_approval_status = FND_API.G_RET_STS_SUCCESS

588: END IF;
589: END IF; -- FND_MSG_PUB.Count_Msg < 1
590:
591: END IF; -- IF (l_wf_type <> 'NOT_ENABLED') AND...
592: END IF; -- return_status of update_approval_status = FND_API.G_RET_STS_SUCCESS
593: END IF; -- IF FND_MSG_PUB.Count_Msg < 1
594:
595:
596: --clear PL/SQL table for next time

Line 599: END IF; -- IF p_validate_only = FND_API.G_FALSE

595:
596: --clear PL/SQL table for next time
597: PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl.DELETE;
598:
599: END IF; -- IF p_validate_only = FND_API.G_FALSE
600:
601: --------------------------------------------------------------------------------------------------------
602: -- Set OUT parameters
603: --------------------------------------------------------------------------------------------------------

Line 608: x_return_status := FND_API.G_RET_STS_ERROR;

604: x_msg_count := FND_MSG_PUB.Count_Msg;
605:
606: -- If g_error_exists is TRUE then set the x_return_status to 'E'
607: IF x_msg_count >0 THEN
608: x_return_status := FND_API.G_RET_STS_ERROR;
609:
610: IF x_msg_count = 1 THEN
611: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
612: ,p_msg_index => 1

Line 611: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE

607: IF x_msg_count >0 THEN
608: x_return_status := FND_API.G_RET_STS_ERROR;
609:
610: IF x_msg_count = 1 THEN
611: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
612: ,p_msg_index => 1
613: ,p_data => x_msg_data
614: ,p_msg_index_out => l_msg_index_out );
615: END IF;

Line 622: WHEN FND_API.G_EXC_ERROR THEN

618: -- Reset the error stack when returning to the calling program
619: PA_DEBUG.Reset_Err_Stack;
620:
621: EXCEPTION
622: WHEN FND_API.G_EXC_ERROR THEN
623: x_return_status := FND_API.G_RET_STS_ERROR;
624: x_msg_count := FND_MSG_PUB.Count_Msg;
625:
626: IF x_msg_count = 1 THEN

Line 623: x_return_status := FND_API.G_RET_STS_ERROR;

619: PA_DEBUG.Reset_Err_Stack;
620:
621: EXCEPTION
622: WHEN FND_API.G_EXC_ERROR THEN
623: x_return_status := FND_API.G_RET_STS_ERROR;
624: x_msg_count := FND_MSG_PUB.Count_Msg;
625:
626: IF x_msg_count = 1 THEN
627: pa_interface_utils_pub.get_messages (p_encoded => FND_API.G_TRUE,

Line 627: pa_interface_utils_pub.get_messages (p_encoded => FND_API.G_TRUE,

623: x_return_status := FND_API.G_RET_STS_ERROR;
624: x_msg_count := FND_MSG_PUB.Count_Msg;
625:
626: IF x_msg_count = 1 THEN
627: pa_interface_utils_pub.get_messages (p_encoded => FND_API.G_TRUE,
628: p_msg_index => 1,
629: p_data => x_msg_data,
630: p_msg_index_out => l_msg_index_out );
631: END IF;

Line 634: IF p_commit = FND_API.G_TRUE THEN

630: p_msg_index_out => l_msg_index_out );
631: END IF;
632:
633: WHEN OTHERS THEN
634: IF p_commit = FND_API.G_TRUE THEN
635: ROLLBACK TO ASG_APR_PUB_START_APPRVL;
636: END IF;
637:
638: -- Set the exception Message and the stack

Line 641: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

637:
638: -- Set the exception Message and the stack
639: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PVT.Start_Assignment_Approvals'
640: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
641: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
642:
643: --clear PL/SQL table for next time
644: PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl.DELETE;
645: RAISE; -- This is optional depending on the needs

Line 658: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

654: --
655: PROCEDURE Revert_To_Last_Approved
656: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE
657: ,p_api_version IN NUMBER := 1.0
658: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
659: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
660: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
661: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
662: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 659: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

655: PROCEDURE Revert_To_Last_Approved
656: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE
657: ,p_api_version IN NUMBER := 1.0
658: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
659: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
660: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
661: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
662: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
663: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 660: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

656: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE
657: ,p_api_version IN NUMBER := 1.0
658: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
659: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
660: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
661: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
662: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
663: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
664: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 661: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

657: ,p_api_version IN NUMBER := 1.0
658: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
659: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
660: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
661: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
662: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
663: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
664: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
665: )

Line 699: x_return_status := FND_API.G_RET_STS_SUCCESS;

695: ,x_log_level => 5);
696: END IF;
697:
698: -- Initialize the return status to success
699: x_return_status := FND_API.G_RET_STS_SUCCESS;
700:
701: --Clear the global PL/SQL message table
702: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
703: FND_MSG_PUB.initialize;

Line 702: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

698: -- Initialize the return status to success
699: x_return_status := FND_API.G_RET_STS_SUCCESS;
700:
701: --Clear the global PL/SQL message table
702: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
703: FND_MSG_PUB.initialize;
704: END IF;
705:
706: -- Issue API savepoint if the transaction is to be committed

Line 707: IF p_commit = FND_API.G_TRUE THEN

703: FND_MSG_PUB.initialize;
704: END IF;
705:
706: -- Issue API savepoint if the transaction is to be committed
707: IF p_commit = FND_API.G_TRUE THEN
708: SAVEPOINT ASG_APR_PUB_REVERT;
709: END IF;
710:
711: IF PA_ASGMT_WFSTD.is_approval_pending(p_assignment_id => p_assignment_id) = 'Y' THEN

Line 1074: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE

1070:
1071: x_msg_count := FND_MSG_PUB.Count_Msg;
1072:
1073: IF x_msg_count = 1 THEN
1074: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
1075: ,p_msg_index => 1
1076: ,p_data => x_msg_data
1077: ,p_msg_index_out => l_msg_index_out
1078: );

Line 1089: x_return_status := FND_API.G_RET_STS_ERROR;

1085: -- If g_error_exists is TRUE then set the x_return_status to 'E'
1086:
1087: IF FND_MSG_PUB.Count_Msg >0 THEN
1088:
1089: x_return_status := FND_API.G_RET_STS_ERROR;
1090:
1091: END IF;
1092:
1093:

Line 1096: IF p_commit = FND_API.G_TRUE THEN

1092:
1093:
1094: EXCEPTION
1095: WHEN OTHERS THEN
1096: IF p_commit = FND_API.G_TRUE THEN
1097: ROLLBACK TO ASG_APR_PUB_REVERT;
1098: END IF;
1099:
1100: -- Set the exception Message and the stack

Line 1103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1099:
1100: -- Set the exception Message and the stack
1101: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PUB.Revert_To_Last_Approved'
1102: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1104:
1105: RAISE; -- This is optional depending on the needs
1106:
1107: END Revert_To_Last_Approved;

Line 1121: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR

1117: --
1118: PROCEDURE Populate_Changed_Items_Table
1119: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE
1120: ,p_populate_mode IN VARCHAR2 := 'SAVED'
1121: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
1122: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
1123: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
1124: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
1125: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR

Line 1122: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM

1118: PROCEDURE Populate_Changed_Items_Table
1119: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE
1120: ,p_populate_mode IN VARCHAR2 := 'SAVED'
1121: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
1122: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
1123: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
1124: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
1125: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
1126: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR

Line 1123: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR

1119: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE
1120: ,p_populate_mode IN VARCHAR2 := 'SAVED'
1121: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
1122: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
1123: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
1124: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
1125: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
1126: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
1127: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM

Line 1124: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR

1120: ,p_populate_mode IN VARCHAR2 := 'SAVED'
1121: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
1122: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
1123: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
1124: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
1125: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
1126: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
1127: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
1128: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR

Line 1125: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR

1121: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
1122: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
1123: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
1124: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
1125: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
1126: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
1127: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
1128: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
1129: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM

Line 1126: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR

1122: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
1123: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
1124: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
1125: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
1126: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
1127: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
1128: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
1129: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
1130: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR

Line 1127: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM

1123: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
1124: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
1125: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
1126: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
1127: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
1128: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
1129: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
1130: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
1131: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR

Line 1128: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR

1124: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
1125: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
1126: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
1127: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
1128: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
1129: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
1130: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
1131: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
1132: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR

Line 1129: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM

1125: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
1126: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
1127: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
1128: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
1129: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
1130: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
1131: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
1132: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
1133: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM

Line 1130: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR

1126: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
1127: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
1128: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
1129: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
1130: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
1131: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
1132: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
1133: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
1134: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM

Line 1131: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR

1127: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
1128: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
1129: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
1130: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
1131: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
1132: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
1133: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
1134: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
1135: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR

Line 1132: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR

1128: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
1129: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
1130: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
1131: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
1132: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
1133: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
1134: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
1135: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR
1136: ,p_exception_type_code IN VARCHAR2 := NULL

Line 1133: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM

1129: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
1130: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
1131: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
1132: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
1133: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
1134: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
1135: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR
1136: ,p_exception_type_code IN VARCHAR2 := NULL
1137: ,p_start_date IN DATE := NULL

Line 1134: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM

1130: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
1131: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
1132: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
1133: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
1134: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
1135: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR
1136: ,p_exception_type_code IN VARCHAR2 := NULL
1137: ,p_start_date IN DATE := NULL
1138: ,p_end_date IN DATE := NULL

Line 1135: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR

1131: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
1132: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
1133: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
1134: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
1135: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR
1136: ,p_exception_type_code IN VARCHAR2 := NULL
1137: ,p_start_date IN DATE := NULL
1138: ,p_end_date IN DATE := NULL
1139: ,p_requirement_status_code IN VARCHAR2 := NULL

Line 1161: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

1157: ,p_duration_shift_type_code IN VARCHAR2 := NULL
1158: ,p_duration_shift_unit_code IN VARCHAR2 := NULL
1159: ,p_number_of_shift IN NUMBER := NULL
1160: ,p_api_version IN NUMBER := 1.0
1161: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1162: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
1163: ,x_new_assignment_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1164: ,x_approval_required_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1165: ,x_record_version_number OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 1162: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

1158: ,p_duration_shift_unit_code IN VARCHAR2 := NULL
1159: ,p_number_of_shift IN NUMBER := NULL
1160: ,p_api_version IN NUMBER := 1.0
1161: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1162: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
1163: ,x_new_assignment_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1164: ,x_approval_required_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1165: ,x_record_version_number OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1166: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 1235: x_return_status := FND_API.G_RET_STS_SUCCESS;

1231: -- Initialize the Error Stack
1232: PA_DEBUG.init_err_stack('PA_ASSIGNMENT_APPROVAL_PUB.Populate_Changed_Items_Table');
1233:
1234: -- Initialize the return status to success
1235: x_return_status := FND_API.G_RET_STS_SUCCESS;
1236:
1237: -- Clear the global PL/SQL message table
1238: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
1239: FND_MSG_PUB.initialize;

Line 1238: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

1234: -- Initialize the return status to success
1235: x_return_status := FND_API.G_RET_STS_SUCCESS;
1236:
1237: -- Clear the global PL/SQL message table
1238: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
1239: FND_MSG_PUB.initialize;
1240: END IF;
1241:
1242: -- set out parameter

Line 1564: x_return_status := FND_API.G_RET_STS_ERROR;

1560: x_msg_count := FND_MSG_PUB.Count_Msg;
1561:
1562: -- If g_error_exists is TRUE then set the x_return_status to 'E'
1563: IF x_msg_count > 0 THEN
1564: x_return_status := FND_API.G_RET_STS_ERROR;
1565:
1566: IF x_msg_count = 1 THEN
1567: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
1568: ,p_msg_index => 1

Line 1567: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE

1563: IF x_msg_count > 0 THEN
1564: x_return_status := FND_API.G_RET_STS_ERROR;
1565:
1566: IF x_msg_count = 1 THEN
1567: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
1568: ,p_msg_index => 1
1569: ,p_data => x_msg_data
1570: ,p_msg_index_out => l_msg_index_out );
1571: END IF;

Line 1582: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1578: WHEN OTHERS THEN
1579: -- Set the exception Message and the stack
1580: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PUB.Populate_Changed_Items_Table'
1581: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1582: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1583: RAISE; -- This is optional depending on the needs
1584:
1585: END Populate_Changed_Items_Table;
1586:

Line 1597: p_assignment_status_code IN Varchar2 := FND_API.G_MISS_CHAR,

1593: p_assignment_id IN Number ,
1594: p_assignment_type IN Varchar2 ,
1595: p_start_date IN date ,
1596: p_end_date IN date ,
1597: p_assignment_status_code IN Varchar2 := FND_API.G_MISS_CHAR,
1598: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1599: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1600: x_return_status OUT NOCOPY Varchar2 , --File.Sql.39 bug 4440895
1601: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895

Line 1598: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1594: p_assignment_type IN Varchar2 ,
1595: p_start_date IN date ,
1596: p_end_date IN date ,
1597: p_assignment_status_code IN Varchar2 := FND_API.G_MISS_CHAR,
1598: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1599: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1600: x_return_status OUT NOCOPY Varchar2 , --File.Sql.39 bug 4440895
1601: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
1602: x_msg_data OUT NOCOPY Varchar2 ) --File.Sql.39 bug 4440895

Line 1599: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1595: p_start_date IN date ,
1596: p_end_date IN date ,
1597: p_assignment_status_code IN Varchar2 := FND_API.G_MISS_CHAR,
1598: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1599: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1600: x_return_status OUT NOCOPY Varchar2 , --File.Sql.39 bug 4440895
1601: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
1602: x_msg_data OUT NOCOPY Varchar2 ) --File.Sql.39 bug 4440895
1603: IS

Line 1725: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_FALSE;

1721: ,x_log_level => 5);
1722: END IF;
1723:
1724: -- Initialize the error flag
1725: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_FALSE;
1726:
1727: -- Issue API savepoint if the transaction is to be committed
1728: IF p_commit = FND_API.G_TRUE THEN
1729: SAVEPOINT ASG_PUB_CHANGE_STATUS;

Line 1728: IF p_commit = FND_API.G_TRUE THEN

1724: -- Initialize the error flag
1725: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_FALSE;
1726:
1727: -- Issue API savepoint if the transaction is to be committed
1728: IF p_commit = FND_API.G_TRUE THEN
1729: SAVEPOINT ASG_PUB_CHANGE_STATUS;
1730: END IF;
1731:
1732: --Clear the global PL/SQL message table

Line 1733: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

1729: SAVEPOINT ASG_PUB_CHANGE_STATUS;
1730: END IF;
1731:
1732: --Clear the global PL/SQL message table
1733: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
1734: FND_MSG_PUB.initialize;
1735: END IF;
1736:
1737: OPEN check_record_version;

Line 1747: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;

1743: IF check_record_version%NOTFOUND THEN
1744:
1745: PA_UTILS.Add_Message( p_app_short_name => 'PA'
1746: ,p_msg_name => 'PA_XC_RECORD_CHANGED');
1747: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1748:
1749: ELSE
1750:
1751: l_record_version_number := p_record_version_number;

Line 1756: l_save_to_hist := FND_API.G_FALSE;

1752:
1753: --Change Status in the Schedule tables
1754: /*
1755: IF p_assignment_type = 'OPEN_ASSIGNMENT' THEN
1756: l_save_to_hist := FND_API.G_FALSE;
1757: ELSE
1758: l_save_to_hist := FND_API.G_TRUE;
1759: END IF;
1760: */

Line 1758: l_save_to_hist := FND_API.G_TRUE;

1754: /*
1755: IF p_assignment_type = 'OPEN_ASSIGNMENT' THEN
1756: l_save_to_hist := FND_API.G_FALSE;
1757: ELSE
1758: l_save_to_hist := FND_API.G_TRUE;
1759: END IF;
1760: */
1761:
1762:

Line 1867: ,p_validate_only => FND_API.G_FALSE

1863: ,p_action_set_type_code => 'ADVERTISEMENT'
1864: ,p_status_code => 'CLOSED'
1865: ,p_record_version_number => l_record_version_number
1866: ,p_commit => p_commit
1867: ,p_validate_only => FND_API.G_FALSE
1868: ,p_init_msg_list => FND_API.G_FALSE
1869: ,x_return_status => x_return_status
1870: ,x_msg_count => x_msg_count
1871: ,x_msg_data => x_msg_data);

Line 1868: ,p_init_msg_list => FND_API.G_FALSE

1864: ,p_status_code => 'CLOSED'
1865: ,p_record_version_number => l_record_version_number
1866: ,p_commit => p_commit
1867: ,p_validate_only => FND_API.G_FALSE
1868: ,p_init_msg_list => FND_API.G_FALSE
1869: ,x_return_status => x_return_status
1870: ,x_msg_count => x_msg_count
1871: ,x_msg_data => x_msg_data);
1872:

Line 1921: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1917:
1918: --dbms_output.put_line('after PA_CANDIDATE_UTILS.Reverse_Candidate_Status ');
1919:
1920:
1921: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1922: PA_UTILS.Add_Message( p_app_short_name => 'PA'
1923: ,p_msg_name => l_error_message_code);
1924: END IF;
1925:

Line 1955: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

1951: ,x_msg_count => x_msg_count
1952: ,x_msg_data => x_msg_data
1953: );
1954:
1955: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1956:
1957: --Need to keep the link from the new requirement to the canceled assignment
1958: UPDATE pa_project_assignments
1959: SET source_assignment_id = p_assignment_id

Line 1995: ,p_validate_only => FND_API.G_FALSE

1991: PA_ASSIGNMENT_APPROVAL_PUB.Start_Assignment_Approvals( p_assignment_id => p_assignment_id
1992: ,p_new_assignment_flag => l_new_assignment_flag
1993: ,p_action_code =>PA_ASSIGNMENT_APPROVAL_PUB.g_cancel_action
1994: ,p_record_version_number => NULL
1995: ,p_validate_only => FND_API.G_FALSE
1996: ,x_overcommitment_flag => l_overcommitment_flag
1997: ,x_conflict_group_id => l_conflict_group_id
1998: ,x_return_status => x_return_status
1999: ,x_msg_count => x_msg_count

Line 2055: ,p_named_role => FND_API.G_MISS_CHAR

2051: ,p_task_version_id_tbl => l_task_version_id_tbl
2052: ,p_budget_version_id_tbl => l_budget_version_id_tbl
2053: ,p_struct_version_id_tbl => l_struct_version_id_tbl
2054: ,p_project_assignment_id => -1
2055: ,p_named_role => FND_API.G_MISS_CHAR
2056: ,x_return_status => l_return_status
2057: );
2058: END IF;
2059: CLOSE get_res_mand_attributes;

Line 2070: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE

2066: -- IF the number of messaages is 1 then fetch the message code from the stack and return its text
2067: --
2068: x_msg_count := FND_MSG_PUB.Count_Msg;
2069: IF x_msg_count = 1 THEN
2070: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
2071: ,p_msg_index => 1
2072: ,p_data => x_msg_data
2073: ,p_msg_index_out => l_msg_index_out
2074: );

Line 2083: x_return_status := FND_API.G_RET_STS_ERROR;

2079:
2080:
2081: IF x_msg_count > 0 THEN
2082:
2083: x_return_status := FND_API.G_RET_STS_ERROR;
2084:
2085: END IF;
2086:
2087:

Line 2092: IF p_commit = FND_API.G_TRUE THEN

2088: -- Put any message text from message stack into the Message ARRAY
2089: --
2090: EXCEPTION
2091: WHEN OTHERS THEN
2092: IF p_commit = FND_API.G_TRUE THEN
2093: ROLLBACK TO ASG_PUB_CHANGE_STATUS;
2094: END IF;
2095: -- Set the excetption Message and the stack
2096: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PUB.Change_Assignment_Status'

Line 2099: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2095: -- Set the excetption Message and the stack
2096: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PUB.Change_Assignment_Status'
2097: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
2098: --
2099: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2100: RAISE; -- This is optional depending on the needs
2101:
2102: --
2103: END Change_Assignment_Status;

Line 2204: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2200: p_assignment_id IN Number ,
2201: p_assignment_type IN Varchar2 ,
2202: p_start_date IN date ,
2203: p_end_date IN date ,
2204: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2205: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2206: x_return_status OUT NOCOPY Varchar2 , --File.Sql.39 bug 4440895
2207: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
2208: x_msg_data OUT NOCOPY Varchar2 ) --File.Sql.39 bug 4440895

Line 2205: p_commit IN VARCHAR2 := FND_API.G_FALSE,

2201: p_assignment_type IN Varchar2 ,
2202: p_start_date IN date ,
2203: p_end_date IN date ,
2204: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2205: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2206: x_return_status OUT NOCOPY Varchar2 , --File.Sql.39 bug 4440895
2207: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
2208: x_msg_data OUT NOCOPY Varchar2 ) --File.Sql.39 bug 4440895
2209:

Line 2240: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

2236: ,x_log_level => 5);
2237: END IF;
2238:
2239: --Clear the global PL/SQL message table
2240: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
2241: FND_MSG_PUB.initialize;
2242: END IF;
2243:
2244: -- Assignment cannot be deleted if project transactions

Line 2264: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2260: ,p_new_end_date => l_end_date
2261: ,x_error_message_code => l_error_message_code
2262: ,x_return_status => l_return_status);
2263:
2264: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2265: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2266: ,p_msg_name => l_error_message_code);
2267: END IF;
2268: l_return_status := NULL;

Line 2304: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE

2300: -- IF the number of messaages is 1 then fetch the message code from the stack and return its text
2301: --
2302: x_msg_count := FND_MSG_PUB.Count_Msg;
2303: IF x_msg_count = 1 THEN
2304: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
2305: ,p_msg_index => 1
2306: ,p_data => x_msg_data
2307: ,p_msg_index_out => l_msg_index_out
2308: );

Line 2317: x_return_status := FND_API.G_RET_STS_ERROR;

2313:
2314:
2315: IF x_msg_count > 0 THEN
2316:
2317: x_return_status := FND_API.G_RET_STS_ERROR;
2318:
2319: END IF;
2320:
2321: EXCEPTION

Line 2327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2323: -- Set the excetption Message and the stack
2324: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PUB.Cancel_Assignment'
2325: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
2326: --
2327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2328: RAISE; -- This is optional depending on the needs
2329:
2330: END Cancel_Assignment;
2331:

Line 2346: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

2342: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2343: ,p_submitter_user_id IN NUMBER
2344: ,p_group_id IN NUMBER
2345: ,p_api_version IN NUMBER := 1.0
2346: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
2347: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
2348: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2349: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
2350: ,p_overriding_authority_flag IN VARCHAR2 := 'N'

Line 2347: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

2343: ,p_submitter_user_id IN NUMBER
2344: ,p_group_id IN NUMBER
2345: ,p_api_version IN NUMBER := 1.0
2346: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
2347: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
2348: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2349: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
2350: ,p_overriding_authority_flag IN VARCHAR2 := 'N'
2351: ,x_assignment_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type

Line 2348: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

2344: ,p_group_id IN NUMBER
2345: ,p_api_version IN NUMBER := 1.0
2346: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
2347: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
2348: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2349: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
2350: ,p_overriding_authority_flag IN VARCHAR2 := 'N'
2351: ,x_assignment_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type
2352: ,x_approver1_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type

Line 2349: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

2345: ,p_api_version IN NUMBER := 1.0
2346: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
2347: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
2348: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2349: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
2350: ,p_overriding_authority_flag IN VARCHAR2 := 'N'
2351: ,x_assignment_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type
2352: ,x_approver1_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type
2353: ,x_approver2_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type

Line 2375: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR

2371: (p_mode IN VARCHAR2
2372: ,p_action IN VARCHAR2
2373: ,p_resource_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2374: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2375: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
2376: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
2377: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
2378: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
2379: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR

Line 2376: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR

2372: ,p_action IN VARCHAR2
2373: ,p_resource_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2374: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2375: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
2376: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
2377: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
2378: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
2379: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
2380: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM

Line 2377: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR

2373: ,p_resource_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2374: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2375: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
2376: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
2377: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
2378: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
2379: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
2380: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
2381: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM

Line 2378: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR

2374: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2375: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
2376: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
2377: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
2378: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
2379: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
2380: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
2381: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
2382: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM

Line 2379: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR

2375: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
2376: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
2377: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
2378: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
2379: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
2380: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
2381: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
2382: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
2383: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM

Line 2380: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM

2376: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
2377: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
2378: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
2379: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
2380: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
2381: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
2382: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
2383: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
2384: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR

Line 2381: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM

2377: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
2378: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
2379: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
2380: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
2381: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
2382: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
2383: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
2384: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
2385: ,p_append_description_flag IN VARCHAR2 := 'N'

Line 2382: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM

2378: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
2379: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
2380: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
2381: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
2382: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
2383: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
2384: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
2385: ,p_append_description_flag IN VARCHAR2 := 'N'
2386: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE

Line 2383: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM

2379: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
2380: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
2381: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
2382: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
2383: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
2384: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
2385: ,p_append_description_flag IN VARCHAR2 := 'N'
2386: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
2387: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE

Line 2384: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR

2380: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
2381: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
2382: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
2383: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
2384: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
2385: ,p_append_description_flag IN VARCHAR2 := 'N'
2386: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
2387: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
2388: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR

Line 2386: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE

2382: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
2383: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
2384: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
2385: ,p_append_description_flag IN VARCHAR2 := 'N'
2386: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
2387: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
2388: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
2389: ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
2390: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM

Line 2387: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE

2383: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
2384: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
2385: ,p_append_description_flag IN VARCHAR2 := 'N'
2386: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
2387: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
2388: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
2389: ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
2390: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
2391: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR

Line 2388: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR

2384: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
2385: ,p_append_description_flag IN VARCHAR2 := 'N'
2386: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
2387: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
2388: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
2389: ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
2390: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
2391: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
2392: ,p_append_information_flag IN VARCHAR2 := 'N'

Line 2389: ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM

2385: ,p_append_description_flag IN VARCHAR2 := 'N'
2386: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
2387: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
2388: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
2389: ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
2390: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
2391: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
2392: ,p_append_information_flag IN VARCHAR2 := 'N'
2393: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM

Line 2390: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM

2386: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
2387: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
2388: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
2389: ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
2390: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
2391: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
2392: ,p_append_information_flag IN VARCHAR2 := 'N'
2393: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
2394: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM

Line 2391: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR

2387: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
2388: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
2389: ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
2390: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
2391: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
2392: ,p_append_information_flag IN VARCHAR2 := 'N'
2393: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
2394: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
2395: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR

Line 2393: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM

2389: ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
2390: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
2391: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
2392: ,p_append_information_flag IN VARCHAR2 := 'N'
2393: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
2394: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
2395: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
2396: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
2397: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM

Line 2394: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM

2390: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
2391: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
2392: ,p_append_information_flag IN VARCHAR2 := 'N'
2393: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
2394: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
2395: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
2396: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
2397: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
2398: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR

Line 2395: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR

2391: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
2392: ,p_append_information_flag IN VARCHAR2 := 'N'
2393: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
2394: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
2395: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
2396: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
2397: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
2398: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
2399: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR

Line 2396: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM

2392: ,p_append_information_flag IN VARCHAR2 := 'N'
2393: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
2394: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
2395: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
2396: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
2397: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
2398: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
2399: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
2400: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR

Line 2397: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM

2393: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
2394: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
2395: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
2396: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
2397: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
2398: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
2399: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
2400: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
2401: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR

Line 2398: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR

2394: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
2395: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
2396: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
2397: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
2398: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
2399: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
2400: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
2401: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
2402: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR

Line 2399: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR

2395: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
2396: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
2397: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
2398: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
2399: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
2400: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
2401: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
2402: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
2403: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR

Line 2400: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR

2396: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
2397: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
2398: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
2399: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
2400: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
2401: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
2402: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
2403: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
2404: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR

Line 2401: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR

2397: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
2398: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
2399: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
2400: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
2401: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
2402: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
2403: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
2404: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
2405: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR

Line 2402: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR

2398: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
2399: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
2400: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
2401: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
2402: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
2403: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
2404: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
2405: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
2406: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR

Line 2403: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR

2399: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
2400: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
2401: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
2402: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
2403: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
2404: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
2405: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
2406: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
2407: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR

Line 2404: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR

2400: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
2401: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
2402: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
2403: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
2404: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
2405: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
2406: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
2407: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
2408: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR

Line 2405: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR

2401: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
2402: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
2403: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
2404: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
2405: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
2406: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
2407: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
2408: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
2409: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR

Line 2406: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR

2402: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
2403: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
2404: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
2405: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
2406: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
2407: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
2408: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
2409: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
2410: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR

Line 2407: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR

2403: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
2404: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
2405: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
2406: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
2407: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
2408: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
2409: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
2410: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
2411: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM

Line 2408: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR

2404: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
2405: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
2406: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
2407: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
2408: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
2409: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
2410: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
2411: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
2412: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR

Line 2409: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR

2405: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
2406: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
2407: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
2408: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
2409: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
2410: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
2411: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
2412: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
2413: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR

Line 2410: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR

2406: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
2407: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
2408: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
2409: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
2410: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
2411: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
2412: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
2413: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
2414: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM

Line 2411: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM

2407: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
2408: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
2409: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
2410: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
2411: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
2412: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
2413: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
2414: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
2415: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM

Line 2412: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR

2408: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
2409: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
2410: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
2411: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
2412: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
2413: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
2414: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
2415: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
2416: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM

Line 2413: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR

2409: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
2410: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
2411: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
2412: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
2413: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
2414: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
2415: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
2416: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
2417: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM

Line 2414: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM

2410: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
2411: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
2412: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
2413: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
2414: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
2415: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
2416: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
2417: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
2418: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR

Line 2415: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM

2411: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
2412: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
2413: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
2414: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
2415: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
2416: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
2417: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
2418: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
2419: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR

Line 2416: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM

2412: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
2413: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
2414: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
2415: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
2416: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
2417: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
2418: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
2419: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
2420: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM

Line 2417: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM

2413: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
2414: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
2415: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
2416: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
2417: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
2418: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
2419: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
2420: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
2421: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM

Line 2418: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR

2414: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
2415: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
2416: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
2417: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
2418: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
2419: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
2420: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
2421: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
2422: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM

Line 2419: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR

2415: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
2416: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
2417: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
2418: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
2419: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
2420: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
2421: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
2422: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
2423: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM

Line 2420: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM

2416: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
2417: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
2418: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
2419: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
2420: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
2421: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
2422: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
2423: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
2424: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR

Line 2421: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM

2417: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
2418: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
2419: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
2420: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
2421: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
2422: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
2423: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
2424: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
2425: ,p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR

Line 2422: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM

2418: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
2419: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
2420: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
2421: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
2422: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
2423: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
2424: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
2425: ,p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
2426: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM

Line 2423: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM

2419: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
2420: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
2421: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
2422: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
2423: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
2424: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
2425: ,p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
2426: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
2427: ,p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR

Line 2424: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR

2420: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
2421: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
2422: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
2423: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
2424: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
2425: ,p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
2426: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
2427: ,p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
2428: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM

Line 2425: ,p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR

2421: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
2422: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
2423: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
2424: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
2425: ,p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
2426: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
2427: ,p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
2428: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
2429: ,p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR

Line 2426: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM

2422: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
2423: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
2424: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
2425: ,p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
2426: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
2427: ,p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
2428: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
2429: ,p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
2430: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM

Line 2427: ,p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR

2423: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
2424: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
2425: ,p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
2426: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
2427: ,p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
2428: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
2429: ,p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
2430: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
2431: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR

Line 2428: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM

2424: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
2425: ,p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
2426: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
2427: ,p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
2428: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
2429: ,p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
2430: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
2431: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
2432: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM

Line 2429: ,p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR

2425: ,p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
2426: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
2427: ,p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
2428: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
2429: ,p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
2430: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
2431: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
2432: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
2433: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR

Line 2430: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM

2426: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
2427: ,p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
2428: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
2429: ,p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
2430: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
2431: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
2432: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
2433: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR
2434: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR

Line 2431: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR

2427: ,p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
2428: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
2429: ,p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
2430: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
2431: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
2432: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
2433: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR
2434: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
2435: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR

Line 2432: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM

2428: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
2429: ,p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
2430: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
2431: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
2432: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
2433: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR
2434: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
2435: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
2436: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR

Line 2433: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR

2429: ,p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
2430: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
2431: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
2432: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
2433: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR
2434: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
2435: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
2436: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
2437: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR

Line 2434: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR

2430: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
2431: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
2432: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
2433: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR
2434: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
2435: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
2436: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
2437: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
2438: ,p_exception_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 2435: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR

2431: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
2432: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
2433: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR
2434: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
2435: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
2436: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
2437: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
2438: ,p_exception_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2439: ,p_change_start_date IN DATE := FND_API.G_MISS_DATE

Line 2436: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR

2432: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
2433: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR
2434: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
2435: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
2436: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
2437: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
2438: ,p_exception_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2439: ,p_change_start_date IN DATE := FND_API.G_MISS_DATE
2440: ,p_change_end_date IN DATE := FND_API.G_MISS_DATE

Line 2437: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR

2433: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR
2434: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
2435: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
2436: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
2437: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
2438: ,p_exception_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2439: ,p_change_start_date IN DATE := FND_API.G_MISS_DATE
2440: ,p_change_end_date IN DATE := FND_API.G_MISS_DATE
2441: ,p_change_rqmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 2438: ,p_exception_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR

2434: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
2435: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
2436: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
2437: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
2438: ,p_exception_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2439: ,p_change_start_date IN DATE := FND_API.G_MISS_DATE
2440: ,p_change_end_date IN DATE := FND_API.G_MISS_DATE
2441: ,p_change_rqmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2442: ,p_change_asgmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 2439: ,p_change_start_date IN DATE := FND_API.G_MISS_DATE

2435: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
2436: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
2437: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
2438: ,p_exception_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2439: ,p_change_start_date IN DATE := FND_API.G_MISS_DATE
2440: ,p_change_end_date IN DATE := FND_API.G_MISS_DATE
2441: ,p_change_rqmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2442: ,p_change_asgmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2443: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL

Line 2440: ,p_change_end_date IN DATE := FND_API.G_MISS_DATE

2436: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
2437: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
2438: ,p_exception_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2439: ,p_change_start_date IN DATE := FND_API.G_MISS_DATE
2440: ,p_change_end_date IN DATE := FND_API.G_MISS_DATE
2441: ,p_change_rqmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2442: ,p_change_asgmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2443: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
2444: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL

Line 2441: ,p_change_rqmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR

2437: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
2438: ,p_exception_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2439: ,p_change_start_date IN DATE := FND_API.G_MISS_DATE
2440: ,p_change_end_date IN DATE := FND_API.G_MISS_DATE
2441: ,p_change_rqmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2442: ,p_change_asgmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2443: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
2444: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
2445: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

Line 2442: ,p_change_asgmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR

2438: ,p_exception_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2439: ,p_change_start_date IN DATE := FND_API.G_MISS_DATE
2440: ,p_change_end_date IN DATE := FND_API.G_MISS_DATE
2441: ,p_change_rqmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2442: ,p_change_asgmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2443: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
2444: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
2445: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2446: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

Line 2453: ,p_change_hours_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR

2449: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2450: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2451: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2452: ,p_non_working_day_flag IN VARCHAR2 := 'N'
2453: ,p_change_hours_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2454: ,p_hrs_per_day IN NUMBER := FND_API.G_MISS_NUM
2455: ,p_calendar_percent IN NUMBER := FND_API.G_MISS_NUM
2456: ,p_change_calendar_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2457: ,p_change_calendar_name IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 2454: ,p_hrs_per_day IN NUMBER := FND_API.G_MISS_NUM

2450: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2451: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2452: ,p_non_working_day_flag IN VARCHAR2 := 'N'
2453: ,p_change_hours_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2454: ,p_hrs_per_day IN NUMBER := FND_API.G_MISS_NUM
2455: ,p_calendar_percent IN NUMBER := FND_API.G_MISS_NUM
2456: ,p_change_calendar_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2457: ,p_change_calendar_name IN VARCHAR2 := FND_API.G_MISS_CHAR
2458: ,p_change_calendar_id IN NUMBER := FND_API.G_MISS_NUM

Line 2455: ,p_calendar_percent IN NUMBER := FND_API.G_MISS_NUM

2451: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2452: ,p_non_working_day_flag IN VARCHAR2 := 'N'
2453: ,p_change_hours_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2454: ,p_hrs_per_day IN NUMBER := FND_API.G_MISS_NUM
2455: ,p_calendar_percent IN NUMBER := FND_API.G_MISS_NUM
2456: ,p_change_calendar_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2457: ,p_change_calendar_name IN VARCHAR2 := FND_API.G_MISS_CHAR
2458: ,p_change_calendar_id IN NUMBER := FND_API.G_MISS_NUM
2459: ,p_duration_shift_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 2456: ,p_change_calendar_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR

2452: ,p_non_working_day_flag IN VARCHAR2 := 'N'
2453: ,p_change_hours_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2454: ,p_hrs_per_day IN NUMBER := FND_API.G_MISS_NUM
2455: ,p_calendar_percent IN NUMBER := FND_API.G_MISS_NUM
2456: ,p_change_calendar_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2457: ,p_change_calendar_name IN VARCHAR2 := FND_API.G_MISS_CHAR
2458: ,p_change_calendar_id IN NUMBER := FND_API.G_MISS_NUM
2459: ,p_duration_shift_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2460: ,p_duration_shift_unit_code IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 2457: ,p_change_calendar_name IN VARCHAR2 := FND_API.G_MISS_CHAR

2453: ,p_change_hours_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2454: ,p_hrs_per_day IN NUMBER := FND_API.G_MISS_NUM
2455: ,p_calendar_percent IN NUMBER := FND_API.G_MISS_NUM
2456: ,p_change_calendar_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2457: ,p_change_calendar_name IN VARCHAR2 := FND_API.G_MISS_CHAR
2458: ,p_change_calendar_id IN NUMBER := FND_API.G_MISS_NUM
2459: ,p_duration_shift_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2460: ,p_duration_shift_unit_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2461: ,p_num_of_shift IN NUMBER := FND_API.G_MISS_NUM

Line 2458: ,p_change_calendar_id IN NUMBER := FND_API.G_MISS_NUM

2454: ,p_hrs_per_day IN NUMBER := FND_API.G_MISS_NUM
2455: ,p_calendar_percent IN NUMBER := FND_API.G_MISS_NUM
2456: ,p_change_calendar_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2457: ,p_change_calendar_name IN VARCHAR2 := FND_API.G_MISS_CHAR
2458: ,p_change_calendar_id IN NUMBER := FND_API.G_MISS_NUM
2459: ,p_duration_shift_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2460: ,p_duration_shift_unit_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2461: ,p_num_of_shift IN NUMBER := FND_API.G_MISS_NUM
2462: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl

Line 2459: ,p_duration_shift_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR

2455: ,p_calendar_percent IN NUMBER := FND_API.G_MISS_NUM
2456: ,p_change_calendar_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2457: ,p_change_calendar_name IN VARCHAR2 := FND_API.G_MISS_CHAR
2458: ,p_change_calendar_id IN NUMBER := FND_API.G_MISS_NUM
2459: ,p_duration_shift_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2460: ,p_duration_shift_unit_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2461: ,p_num_of_shift IN NUMBER := FND_API.G_MISS_NUM
2462: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2463: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl

Line 2460: ,p_duration_shift_unit_code IN VARCHAR2 := FND_API.G_MISS_CHAR

2456: ,p_change_calendar_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2457: ,p_change_calendar_name IN VARCHAR2 := FND_API.G_MISS_CHAR
2458: ,p_change_calendar_id IN NUMBER := FND_API.G_MISS_NUM
2459: ,p_duration_shift_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2460: ,p_duration_shift_unit_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2461: ,p_num_of_shift IN NUMBER := FND_API.G_MISS_NUM
2462: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2463: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2464: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl

Line 2461: ,p_num_of_shift IN NUMBER := FND_API.G_MISS_NUM

2457: ,p_change_calendar_name IN VARCHAR2 := FND_API.G_MISS_CHAR
2458: ,p_change_calendar_id IN NUMBER := FND_API.G_MISS_NUM
2459: ,p_duration_shift_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2460: ,p_duration_shift_unit_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2461: ,p_num_of_shift IN NUMBER := FND_API.G_MISS_NUM
2462: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2463: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2464: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2465: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl

Line 2467: ,p_note_to_all_approvers IN VARCHAR2 := FND_API.G_MISS_CHAR

2463: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2464: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2465: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2466: ,p_appr_over_auth_flag IN VARCHAR2 := 'N'
2467: ,p_note_to_all_approvers IN VARCHAR2 := FND_API.G_MISS_CHAR
2468: ,p_competence_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2469: ,p_competence_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2470: ,p_competence_alias_tbl IN SYSTEM.pa_varchar2_30_tbl_type := prm_empty_varchar2_30_tbl
2471: ,p_rating_level_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl

Line 2473: ,p_resolve_con_action_code IN VARCHAR2 := FND_API.G_MISS_CHAR

2469: ,p_competence_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2470: ,p_competence_alias_tbl IN SYSTEM.pa_varchar2_30_tbl_type := prm_empty_varchar2_30_tbl
2471: ,p_rating_level_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2472: ,p_mandatory_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type := prm_empty_varchar2_1_tbl
2473: ,p_resolve_con_action_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2474: ,p_api_version IN NUMBER := 1.0
2475: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
2476: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
2477: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

Line 2475: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

2471: ,p_rating_level_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2472: ,p_mandatory_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type := prm_empty_varchar2_1_tbl
2473: ,p_resolve_con_action_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2474: ,p_api_version IN NUMBER := 1.0
2475: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
2476: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
2477: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2478: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
2479: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 2476: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

2472: ,p_mandatory_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type := prm_empty_varchar2_1_tbl
2473: ,p_resolve_con_action_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2474: ,p_api_version IN NUMBER := 1.0
2475: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
2476: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
2477: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2478: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
2479: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2480: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 2477: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

2473: ,p_resolve_con_action_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2474: ,p_api_version IN NUMBER := 1.0
2475: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
2476: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
2477: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2478: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
2479: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2480: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2481: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 2478: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

2474: ,p_api_version IN NUMBER := 1.0
2475: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
2476: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
2477: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2478: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
2479: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2480: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2481: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2482: )

Line 2491: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

2487: l_project_party_id NUMBER ;
2488: l_project_role_id NUMBER ;
2489: l_project_role_name VARCHAR2(80);
2490: l_admin_project VARCHAR2(1); --Variable which denotes if a project is an admin project or not
2491: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2492: l_error_message_code fnd_new_messages.message_name%TYPE;
2493: l_assignment_start_date DATE;
2494: l_approver1_person_id NUMBER;
2495: l_approver1_person_name VARCHAR2(200);

Line 2520: x_return_status := FND_API.G_RET_STS_SUCCESS;

2516: ,x_log_level => 1);
2517: END IF;
2518:
2519: -- Initialize the return status to success
2520: x_return_status := FND_API.G_RET_STS_SUCCESS;
2521:
2522: --Clear the global PL/SQL message table
2523: FND_MSG_PUB.initialize;
2524:

Line 2526: IF p_commit = FND_API.G_TRUE THEN

2522: --Clear the global PL/SQL message table
2523: FND_MSG_PUB.initialize;
2524:
2525: -- Issue API savepoint if the transaction is to be committed
2526: IF p_commit = FND_API.G_TRUE THEN
2527: SAVEPOINT MASS_SUBMIT_ASGN_APPRVL;
2528: END IF;
2529:
2530: -----------------------------------------

Line 2583: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2579: ,x_project_role_name => l_project_role_name
2580: ,x_return_status => l_return_status
2581: ,x_error_message_code => l_error_message_code );
2582:
2583: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2584: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2585: ,p_msg_name => l_error_message_code);
2586: END IF;
2587:

Line 2588: l_error_message_code := FND_API.G_MISS_CHAR;

2584: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2585: ,p_msg_name => l_error_message_code);
2586: END IF;
2587:
2588: l_error_message_code := FND_API.G_MISS_CHAR;
2589:
2590: END IF;
2591:
2592: IF l_return_status <> FND_API.G_RET_STS_ERROR THEN

Line 2592: IF l_return_status <> FND_API.G_RET_STS_ERROR THEN

2588: l_error_message_code := FND_API.G_MISS_CHAR;
2589:
2590: END IF;
2591:
2592: IF l_return_status <> FND_API.G_RET_STS_ERROR THEN
2593:
2594: ---------------------------------
2595: --Call the mass transaction API
2596: ---------------------------------

Line 2703: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2699: ,p_mandatory_flag_tbl => p_mandatory_flag_tbl
2700: ,p_resolve_con_action_code => p_resolve_con_action_code
2701: ,x_return_status => l_return_status );
2702:
2703: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2704: x_return_status := l_return_status;
2705: END IF;
2706:
2707: END IF;

Line 2715: ( p_encoded => FND_API.G_TRUE

2711: -- IF the number of messages is 1 then fetch the message code from
2712: -- the stack and return its text
2713: IF x_msg_count = 1 THEN
2714: pa_interface_utils_pub.get_messages
2715: ( p_encoded => FND_API.G_TRUE
2716: ,p_msg_index => 1
2717: ,p_data => x_msg_data
2718: ,p_msg_index_out => l_msg_index_out );
2719: END IF;

Line 2726: x_return_status := FND_API.G_RET_STS_ERROR;

2722: PA_DEBUG.Reset_Err_Stack;
2723:
2724: -- If g_error_exists is TRUE then set the x_return_status to 'E'
2725: IF FND_MSG_PUB.Count_Msg >0 THEN
2726: x_return_status := FND_API.G_RET_STS_ERROR;
2727: END IF;
2728:
2729: EXCEPTION
2730: WHEN OTHERS THEN

Line 2732: IF p_commit = FND_API.G_TRUE THEN

2728:
2729: EXCEPTION
2730: WHEN OTHERS THEN
2731:
2732: IF p_commit = FND_API.G_TRUE THEN
2733: ROLLBACK TO MASS_SUBMIT_ASGN_APPRVL;
2734: END IF;
2735:
2736: -- Set the excetption Message and the stack

Line 2741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2737: FND_MSG_PUB.add_exc_msg
2738: ( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PUB.mass_submit_for_asgmt_aprvl'
2739: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
2740:
2741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2742: RAISE;
2743:
2744: END mass_submit_for_asgmt_aprvl;
2745:

Line 2754: ( p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM

2750: --The IN parameters are assignments table which are submitted for
2751: --approval along with 2 approvers tables
2752: ---------------------------------------------------------------------------
2753: PROCEDURE mass_assignment_approval
2754: ( p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
2755: ,p_mode IN VARCHAR2
2756: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2757: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2758: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl

Line 2762: ,p_submitter_user_id IN NUMBER := FND_API.G_MISS_NUM

2758: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2759: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2760: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2761: ,p_overriding_authority_flag IN VARCHAR2 := 'N'
2762: ,p_submitter_user_id IN NUMBER := FND_API.G_MISS_NUM
2763: ,p_note_to_all_approvers IN VARCHAR2 := FND_API.G_MISS_CHAR
2764: ,p_conflict_group_id IN NUMBER := FND_API.G_MISS_NUM
2765: ,p_update_info_doc IN VARCHAR2 := FND_API.G_MISS_CHAR
2766: ,p_api_version IN NUMBER := 1.0

Line 2763: ,p_note_to_all_approvers IN VARCHAR2 := FND_API.G_MISS_CHAR

2759: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2760: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2761: ,p_overriding_authority_flag IN VARCHAR2 := 'N'
2762: ,p_submitter_user_id IN NUMBER := FND_API.G_MISS_NUM
2763: ,p_note_to_all_approvers IN VARCHAR2 := FND_API.G_MISS_CHAR
2764: ,p_conflict_group_id IN NUMBER := FND_API.G_MISS_NUM
2765: ,p_update_info_doc IN VARCHAR2 := FND_API.G_MISS_CHAR
2766: ,p_api_version IN NUMBER := 1.0
2767: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

Line 2764: ,p_conflict_group_id IN NUMBER := FND_API.G_MISS_NUM

2760: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2761: ,p_overriding_authority_flag IN VARCHAR2 := 'N'
2762: ,p_submitter_user_id IN NUMBER := FND_API.G_MISS_NUM
2763: ,p_note_to_all_approvers IN VARCHAR2 := FND_API.G_MISS_CHAR
2764: ,p_conflict_group_id IN NUMBER := FND_API.G_MISS_NUM
2765: ,p_update_info_doc IN VARCHAR2 := FND_API.G_MISS_CHAR
2766: ,p_api_version IN NUMBER := 1.0
2767: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
2768: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

Line 2765: ,p_update_info_doc IN VARCHAR2 := FND_API.G_MISS_CHAR

2761: ,p_overriding_authority_flag IN VARCHAR2 := 'N'
2762: ,p_submitter_user_id IN NUMBER := FND_API.G_MISS_NUM
2763: ,p_note_to_all_approvers IN VARCHAR2 := FND_API.G_MISS_CHAR
2764: ,p_conflict_group_id IN NUMBER := FND_API.G_MISS_NUM
2765: ,p_update_info_doc IN VARCHAR2 := FND_API.G_MISS_CHAR
2766: ,p_api_version IN NUMBER := 1.0
2767: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
2768: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
2769: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

Line 2767: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

2763: ,p_note_to_all_approvers IN VARCHAR2 := FND_API.G_MISS_CHAR
2764: ,p_conflict_group_id IN NUMBER := FND_API.G_MISS_NUM
2765: ,p_update_info_doc IN VARCHAR2 := FND_API.G_MISS_CHAR
2766: ,p_api_version IN NUMBER := 1.0
2767: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
2768: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
2769: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2770: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
2771: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 2768: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

2764: ,p_conflict_group_id IN NUMBER := FND_API.G_MISS_NUM
2765: ,p_update_info_doc IN VARCHAR2 := FND_API.G_MISS_CHAR
2766: ,p_api_version IN NUMBER := 1.0
2767: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
2768: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
2769: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2770: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
2771: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2772: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 2769: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

2765: ,p_update_info_doc IN VARCHAR2 := FND_API.G_MISS_CHAR
2766: ,p_api_version IN NUMBER := 1.0
2767: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
2768: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
2769: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2770: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
2771: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2772: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2773: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 2770: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

2766: ,p_api_version IN NUMBER := 1.0
2767: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
2768: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
2769: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2770: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
2771: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2772: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2773: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2774: )

Line 2909: x_return_status := FND_API.G_RET_STS_SUCCESS;

2905: ,x_log_level => 1);
2906: END IF;
2907:
2908: -- Initialize the return status to success
2909: x_return_status := FND_API.G_RET_STS_SUCCESS;
2910:
2911: --Clear the global PL/SQL message table
2912: FND_MSG_PUB.initialize;
2913:

Line 2915: IF p_commit = FND_API.G_TRUE THEN

2911: --Clear the global PL/SQL message table
2912: FND_MSG_PUB.initialize;
2913:
2914: -- Issue API savepoint if the transaction is to be committed
2915: IF p_commit = FND_API.G_TRUE THEN
2916: SAVEPOINT MASS_ASGN_APPRVL;
2917: END IF;
2918:
2919: ---------------------------------------------------------------------

Line 2994: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2990: ,x_error_message_code => l_error_message_code );
2991:
2992: -- Only non-admin projects require a manager
2993: IF l_projects_rec.admin_flag = 'N' THEN
2994: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2995: pa_utils.add_message (p_app_short_name => 'PA',
2996: p_msg_name => l_error_message_code);
2997: END IF;
2998: END IF;

Line 3008: l_return_status := FND_API.G_RET_STS_ERROR;

3004: -- Also if Workflow is disabled - then exit
3005: OPEN l_stus_csr;
3006: FETCH l_stus_csr INTO l_stus_rec;
3007: IF l_stus_csr%NOTFOUND THEN
3008: l_return_status := FND_API.G_RET_STS_ERROR;
3009: l_error_message_code := 'PA_INVALID_STATUS_CODE';
3010: pa_utils.add_message (p_app_short_name => 'PA'
3011: ,p_msg_name => 'PA_INVALID_STATUS_CODE');
3012: RAISE INVALID_STATUS;

Line 3231: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

3227: ,x_return_status => l_return_status
3228: ,x_msg_count => l_msg_count
3229: ,x_msg_data => l_msg_data);
3230:
3231: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3232: l_return_status := FND_API.G_MISS_CHAR;
3233: log_message('Error in Update approval status 1');
3234: RAISE PROCESS_ASSIGNMENT_EXCEPTION;
3235: END IF;

Line 3232: l_return_status := FND_API.G_MISS_CHAR;

3228: ,x_msg_count => l_msg_count
3229: ,x_msg_data => l_msg_data);
3230:
3231: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3232: l_return_status := FND_API.G_MISS_CHAR;
3233: log_message('Error in Update approval status 1');
3234: RAISE PROCESS_ASSIGNMENT_EXCEPTION;
3235: END IF;
3236:

Line 3244: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

3240: ,x_return_status => l_return_status
3241: ,x_msg_count => l_msg_count
3242: ,x_msg_data => l_msg_data);
3243:
3244: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3245: l_return_status := FND_API.G_MISS_CHAR;
3246: log_message('Error in conflict resolution');
3247: RAISE PROCESS_ASSIGNMENT_EXCEPTION;
3248: END IF;

Line 3245: l_return_status := FND_API.G_MISS_CHAR;

3241: ,x_msg_count => l_msg_count
3242: ,x_msg_data => l_msg_data);
3243:
3244: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3245: l_return_status := FND_API.G_MISS_CHAR;
3246: log_message('Error in conflict resolution');
3247: RAISE PROCESS_ASSIGNMENT_EXCEPTION;
3248: END IF;
3249:

Line 3320: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

3316: ,x_return_status => l_return_status
3317: ,x_msg_count => l_msg_count
3318: ,x_msg_data => l_msg_data);
3319:
3320: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3321: l_return_status := FND_API.G_MISS_CHAR;
3322: log_message('Error in Update approval status 2');
3323: RAISE PROCESS_ASSIGNMENT_EXCEPTION;
3324: END IF;

Line 3321: l_return_status := FND_API.G_MISS_CHAR;

3317: ,x_msg_count => l_msg_count
3318: ,x_msg_data => l_msg_data);
3319:
3320: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3321: l_return_status := FND_API.G_MISS_CHAR;
3322: log_message('Error in Update approval status 2');
3323: RAISE PROCESS_ASSIGNMENT_EXCEPTION;
3324: END IF;
3325:

Line 3452: p_commit => FND_API.G_FALSE,

3448: p_source_identifier2 => l_group_id,
3449: p_context1 => p_project_id,
3450: p_context2 => l_assignment_id_tbl(i),
3451: p_context3 => l_resource_id,
3452: p_commit => FND_API.G_FALSE,
3453: x_return_status => l_return_status);
3454:
3455: --Setting pending approval flag in pa_project_assignments
3456: PA_ASGMT_WFSTD.Maintain_wf_pending_flag

Line 3699: ( p_encoded => FND_API.G_TRUE

3695: x_msg_count := FND_MSG_PUB.Count_Msg;
3696:
3697: IF x_msg_count = 1 THEN
3698: pa_interface_utils_pub.get_messages
3699: ( p_encoded => FND_API.G_TRUE
3700: ,p_msg_index => 1
3701: ,p_data => x_msg_data
3702: ,p_msg_index_out => l_msg_index_out );
3703: END IF;

Line 3710: x_return_status := FND_API.G_RET_STS_ERROR;

3706: PA_DEBUG.Reset_Err_Stack;
3707:
3708: -- If g_error_exists is TRUE then set the x_return_status to 'E'
3709: IF FND_MSG_PUB.Count_Msg >0 THEN
3710: x_return_status := FND_API.G_RET_STS_ERROR;
3711: END IF;
3712:
3713: EXCEPTION
3714: WHEN NO_WORKFLOW_EXCEPTION THEN

Line 3716: x_return_status := FND_API.G_RET_STS_SUCCESS;

3712:
3713: EXCEPTION
3714: WHEN NO_WORKFLOW_EXCEPTION THEN
3715: --TODO: Check
3716: x_return_status := FND_API.G_RET_STS_SUCCESS;
3717:
3718: WHEN INVALID_STATUS THEN
3719:
3720: IF p_commit = FND_API.G_TRUE THEN

Line 3720: IF p_commit = FND_API.G_TRUE THEN

3716: x_return_status := FND_API.G_RET_STS_SUCCESS;
3717:
3718: WHEN INVALID_STATUS THEN
3719:
3720: IF p_commit = FND_API.G_TRUE THEN
3721: ROLLBACK TO MASS_ASGN_APPRVL;
3722: END IF;
3723:
3724: -- Set the excetption Message and the stack

Line 3729: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3725: FND_MSG_PUB.add_exc_msg
3726: ( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PUB.mass_assignment_approval'
3727: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
3728:
3729: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3730: RAISE;
3731:
3732: WHEN OTHERS THEN
3733:

Line 3734: IF p_commit = FND_API.G_TRUE THEN

3730: RAISE;
3731:
3732: WHEN OTHERS THEN
3733:
3734: IF p_commit = FND_API.G_TRUE THEN
3735: ROLLBACK TO MASS_ASGN_APPRVL;
3736: END IF;
3737:
3738: -- Set the excetption Message and the stack

Line 3743: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3739: FND_MSG_PUB.add_exc_msg
3740: ( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PUB.mass_assignment_approval'
3741: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
3742:
3743: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3744: RAISE;
3745: END mass_assignment_approval;
3746:
3747: ---------------------------------------------------------

Line 3755: ( p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM

3751: --Workflow Itemtype: PARMAAP
3752: --Workflow process : 'PA_MASS_PROCESS_APRVL_RESULT'
3753: ---------------------------------------------------------
3754: PROCEDURE mass_process_approval_result
3755: ( p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
3756: ,p_mode IN VARCHAR2
3757: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
3758: ,p_approval_status_tbl IN SYSTEM.pa_varchar2_30_tbl_type := prm_empty_varchar2_30_tbl
3759: ,p_group_id IN NUMBER

Line 3765: ,p_conflict_group_id IN NUMBER := FND_API.G_MISS_NUM

3761: ,p_routing_order IN NUMBER
3762: ,p_item_key IN NUMBER
3763: ,p_notification_id IN NUMBER
3764: ,p_submitter_user_name IN VARCHAR2
3765: ,p_conflict_group_id IN NUMBER := FND_API.G_MISS_NUM
3766: ,p_api_version IN NUMBER := 1.0
3767: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
3768: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
3769: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

Line 3767: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

3763: ,p_notification_id IN NUMBER
3764: ,p_submitter_user_name IN VARCHAR2
3765: ,p_conflict_group_id IN NUMBER := FND_API.G_MISS_NUM
3766: ,p_api_version IN NUMBER := 1.0
3767: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
3768: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
3769: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3770: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
3771: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 3768: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

3764: ,p_submitter_user_name IN VARCHAR2
3765: ,p_conflict_group_id IN NUMBER := FND_API.G_MISS_NUM
3766: ,p_api_version IN NUMBER := 1.0
3767: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
3768: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
3769: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3770: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
3771: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3772: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 3769: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

3765: ,p_conflict_group_id IN NUMBER := FND_API.G_MISS_NUM
3766: ,p_api_version IN NUMBER := 1.0
3767: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
3768: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
3769: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3770: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
3771: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3772: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
3773: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 3770: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

3766: ,p_api_version IN NUMBER := 1.0
3767: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
3768: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
3769: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3770: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
3771: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3772: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
3773: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3774: )

Line 3817: x_return_status := FND_API.G_RET_STS_SUCCESS;

3813: ,x_log_level => 1);
3814: END IF;
3815:
3816: -- Initialize the return status to success
3817: x_return_status := FND_API.G_RET_STS_SUCCESS;
3818:
3819: --Clear the global PL/SQL message table
3820: FND_MSG_PUB.initialize;
3821:

Line 3823: IF p_commit = FND_API.G_TRUE THEN

3819: --Clear the global PL/SQL message table
3820: FND_MSG_PUB.initialize;
3821:
3822: -- Issue API savepoint if the transaction is to be committed
3823: IF p_commit = FND_API.G_TRUE THEN
3824: SAVEPOINT MASS_APPRVL_RESULT;
3825: END IF;
3826:
3827: --------------------------------------------------------

Line 4020: IF p_commit = FND_API.G_TRUE THEN

4016:
4017: EXCEPTION
4018: WHEN OTHERS THEN
4019:
4020: IF p_commit = FND_API.G_TRUE THEN
4021: ROLLBACK TO MASS_APPRVL_RESULT;
4022: END IF;
4023:
4024: --Setting the original value

Line 4032: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4028: FND_MSG_PUB.add_exc_msg
4029: ( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PUB.mass_process_approval_result'
4030: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
4031:
4032: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4033: RAISE;
4034: END mass_process_approval_result;
4035:
4036: ----------------------------------------------------

Line 4051: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

4047: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
4048: ,p_submitter_user_id IN NUMBER
4049: ,p_group_id IN NUMBER
4050: ,p_api_version IN NUMBER := 1.0
4051: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
4052: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
4053: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
4054: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
4055: ,p_overriding_authority_flag IN VARCHAR2 := 'N'

Line 4052: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

4048: ,p_submitter_user_id IN NUMBER
4049: ,p_group_id IN NUMBER
4050: ,p_api_version IN NUMBER := 1.0
4051: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
4052: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
4053: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
4054: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
4055: ,p_overriding_authority_flag IN VARCHAR2 := 'N'
4056: ,x_assignment_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type

Line 4053: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

4049: ,p_group_id IN NUMBER
4050: ,p_api_version IN NUMBER := 1.0
4051: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
4052: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
4053: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
4054: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
4055: ,p_overriding_authority_flag IN VARCHAR2 := 'N'
4056: ,x_assignment_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type
4057: ,x_approver1_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type

Line 4054: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

4050: ,p_api_version IN NUMBER := 1.0
4051: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
4052: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
4053: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
4054: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
4055: ,p_overriding_authority_flag IN VARCHAR2 := 'N'
4056: ,x_assignment_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type
4057: ,x_approver1_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type
4058: ,x_approver2_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type

Line 4065: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

4061: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4062: )
4063: IS
4064:
4065: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
4066: l_error_message_code fnd_new_messages.message_name%TYPE;
4067: l_assignment_start_date DATE;
4068: l_approver1_person_id NUMBER;
4069: l_approver1_person_name VARCHAR2(200);

Line 4090: x_return_status := FND_API.G_RET_STS_SUCCESS;

4086: ,x_log_level => 1);
4087: END IF;
4088:
4089: -- Initialize the return status to success
4090: x_return_status := FND_API.G_RET_STS_SUCCESS;
4091:
4092: --Clear the global PL/SQL message table
4093: FND_MSG_PUB.initialize;
4094:

Line 4096: IF p_commit = FND_API.G_TRUE THEN

4092: --Clear the global PL/SQL message table
4093: FND_MSG_PUB.initialize;
4094:
4095: -- Issue API savepoint if the transaction is to be committed
4096: IF p_commit = FND_API.G_TRUE THEN
4097: SAVEPOINT MASS_APPRVL_VALIDATE_NAMEID;
4098: END IF;
4099:
4100: log_message('Group id:' || p_group_id);

Line 4197: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4193: ,x_resource_type_id => l_resource_type_id
4194: ,x_return_status => l_return_status
4195: ,x_error_message_code => l_error_message_code );
4196:
4197: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4198: PA_UTILS.Add_Message( p_app_short_name => 'PA'
4199: ,p_msg_name => l_error_message_code);
4200: END IF;
4201:

Line 4228: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4224: ,x_resource_type_id => l_resource_type_id
4225: ,x_return_status => l_return_status
4226: ,x_error_message_code => l_error_message_code);
4227:
4228: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4229: PA_UTILS.Add_Message( p_app_short_name => 'PA'
4230: ,p_msg_name => l_error_message_code);
4231: END IF;
4232:

Line 4285: p_commit => FND_API.G_FALSE,

4281: p_source_identifier2 => p_group_id,
4282: p_context1 => p_project_id,
4283: p_context2 => p_assignment_id_tbl(i),
4284: p_context3 => l_resource_id,
4285: p_commit => FND_API.G_FALSE,
4286: x_return_status => l_return_status);
4287:
4288: END IF;
4289:

Line 4297: IF p_commit = FND_API.G_TRUE THEN

4293:
4294: EXCEPTION
4295: WHEN OTHERS THEN
4296:
4297: IF p_commit = FND_API.G_TRUE THEN
4298: ROLLBACK TO MASS_APPRVL_VALIDATE_NAMEID;
4299: END IF;
4300:
4301: -- Set the excetption Message and the stack

Line 4306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4302: FND_MSG_PUB.add_exc_msg
4303: ( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PUB.validate_approver_name_id'
4304: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
4305:
4306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4307: RAISE;
4308: END validate_approver_name_id;
4309:
4310: