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 2006: ,p_validate_only => FND_API.G_FALSE

2002: PA_ASSIGNMENT_APPROVAL_PUB.Start_Assignment_Approvals( p_assignment_id => p_assignment_id
2003: ,p_new_assignment_flag => l_new_assignment_flag
2004: ,p_action_code =>PA_ASSIGNMENT_APPROVAL_PUB.g_cancel_action
2005: ,p_record_version_number => NULL
2006: ,p_validate_only => FND_API.G_FALSE
2007: ,x_overcommitment_flag => l_overcommitment_flag
2008: ,x_conflict_group_id => l_conflict_group_id
2009: ,x_return_status => x_return_status
2010: ,x_msg_count => x_msg_count

Line 2066: ,p_named_role => FND_API.G_MISS_CHAR

2062: ,p_task_version_id_tbl => l_task_version_id_tbl
2063: ,p_budget_version_id_tbl => l_budget_version_id_tbl
2064: ,p_struct_version_id_tbl => l_struct_version_id_tbl
2065: ,p_project_assignment_id => -1
2066: ,p_named_role => FND_API.G_MISS_CHAR
2067: ,x_return_status => l_return_status
2068: );
2069: END IF;
2070: CLOSE get_res_mand_attributes;

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

2077: -- IF the number of messaages is 1 then fetch the message code from the stack and return its text
2078: --
2079: x_msg_count := FND_MSG_PUB.Count_Msg;
2080: IF x_msg_count = 1 THEN
2081: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
2082: ,p_msg_index => 1
2083: ,p_data => x_msg_data
2084: ,p_msg_index_out => l_msg_index_out
2085: );

Line 2094: x_return_status := FND_API.G_RET_STS_ERROR;

2090:
2091:
2092: IF x_msg_count > 0 THEN
2093:
2094: x_return_status := FND_API.G_RET_STS_ERROR;
2095:
2096: END IF;
2097:
2098:

Line 2103: IF p_commit = FND_API.G_TRUE THEN

2099: -- Put any message text from message stack into the Message ARRAY
2100: --
2101: EXCEPTION
2102: WHEN OTHERS THEN
2103: IF p_commit = FND_API.G_TRUE THEN
2104: ROLLBACK TO ASG_PUB_CHANGE_STATUS;
2105: END IF;
2106: -- Set the excetption Message and the stack
2107: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PUB.Change_Assignment_Status'

Line 2110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2106: -- Set the excetption Message and the stack
2107: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PUB.Change_Assignment_Status'
2108: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
2109: --
2110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2111: RAISE; -- This is optional depending on the needs
2112:
2113: --
2114: END Change_Assignment_Status;

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

2256: p_assignment_id IN Number ,
2257: p_assignment_type IN Varchar2 ,
2258: p_start_date IN date ,
2259: p_end_date IN date ,
2260: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2261: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2262: x_return_status OUT NOCOPY Varchar2 , --File.Sql.39 bug 4440895
2263: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
2264: x_msg_data OUT NOCOPY Varchar2 ) --File.Sql.39 bug 4440895

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

2257: p_assignment_type IN Varchar2 ,
2258: p_start_date IN date ,
2259: p_end_date IN date ,
2260: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2261: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2262: x_return_status OUT NOCOPY Varchar2 , --File.Sql.39 bug 4440895
2263: x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
2264: x_msg_data OUT NOCOPY Varchar2 ) --File.Sql.39 bug 4440895
2265:

Line 2296: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

2292: ,x_log_level => 5);
2293: END IF;
2294:
2295: --Clear the global PL/SQL message table
2296: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
2297: FND_MSG_PUB.initialize;
2298: END IF;
2299:
2300: -- Assignment cannot be deleted if project transactions

Line 2320: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2316: ,p_new_end_date => l_end_date
2317: ,x_error_message_code => l_error_message_code
2318: ,x_return_status => l_return_status);
2319:
2320: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2321: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2322: ,p_msg_name => l_error_message_code);
2323: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE; --bug#8240018
2324: END IF;

Line 2323: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE; --bug#8240018

2319:
2320: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2321: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2322: ,p_msg_name => l_error_message_code);
2323: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE; --bug#8240018
2324: END IF;
2325: l_return_status := NULL;
2326: END IF;
2327:

Line 2330: IF PA_ASSIGNMENTS_PUB.g_error_exists <> FND_API.G_TRUE THEN

2326: END IF;
2327:
2328: --Bug#8240018
2329: -- proceed with the code flow only when there is no error returned
2330: IF PA_ASSIGNMENTS_PUB.g_error_exists <> FND_API.G_TRUE THEN
2331:
2332: --Get Profile Default Status
2333: IF p_assignment_type = 'OPEN_ASSIGNMENT' THEN
2334: FND_PROFILE.Get('PA_DEF_CANCELED_REQMT_STATUS',l_assignment_status_code);

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

2361: -- IF the number of messaages is 1 then fetch the message code from the stack and return its text
2362: --
2363: x_msg_count := FND_MSG_PUB.Count_Msg;
2364: IF x_msg_count = 1 THEN
2365: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
2366: ,p_msg_index => 1
2367: ,p_data => x_msg_data
2368: ,p_msg_index_out => l_msg_index_out
2369: );

Line 2378: x_return_status := FND_API.G_RET_STS_ERROR;

2374:
2375:
2376: IF x_msg_count > 0 THEN
2377:
2378: x_return_status := FND_API.G_RET_STS_ERROR;
2379:
2380: END IF;
2381: END IF; --end of if loop for Bug#8240018
2382: EXCEPTION

Line 2388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2384: -- Set the excetption Message and the stack
2385: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PUB.Cancel_Assignment'
2386: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
2387: --
2388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2389: RAISE; -- This is optional depending on the needs
2390:
2391: END Cancel_Assignment;
2392:

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

2403: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2404: ,p_submitter_user_id IN NUMBER
2405: ,p_group_id IN NUMBER
2406: ,p_api_version IN NUMBER := 1.0
2407: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
2408: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
2409: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2410: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
2411: ,p_overriding_authority_flag IN VARCHAR2 := 'N'

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

2404: ,p_submitter_user_id IN NUMBER
2405: ,p_group_id IN NUMBER
2406: ,p_api_version IN NUMBER := 1.0
2407: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
2408: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
2409: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2410: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
2411: ,p_overriding_authority_flag IN VARCHAR2 := 'N'
2412: ,x_assignment_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type

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

2405: ,p_group_id IN NUMBER
2406: ,p_api_version IN NUMBER := 1.0
2407: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
2408: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
2409: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2410: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
2411: ,p_overriding_authority_flag IN VARCHAR2 := 'N'
2412: ,x_assignment_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type
2413: ,x_approver1_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type

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

2406: ,p_api_version IN NUMBER := 1.0
2407: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
2408: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
2409: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2410: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
2411: ,p_overriding_authority_flag IN VARCHAR2 := 'N'
2412: ,x_assignment_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type
2413: ,x_approver1_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type
2414: ,x_approver2_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type

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

2432: (p_mode IN VARCHAR2
2433: ,p_action IN VARCHAR2
2434: ,p_resource_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2435: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2436: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
2437: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
2438: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
2439: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
2440: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR

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

2433: ,p_action IN VARCHAR2
2434: ,p_resource_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2435: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2436: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
2437: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
2438: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
2439: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
2440: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
2441: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM

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

2434: ,p_resource_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2435: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2436: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
2437: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
2438: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
2439: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
2440: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
2441: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
2442: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM

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

2435: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2436: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
2437: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
2438: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
2439: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
2440: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
2441: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
2442: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
2443: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM

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

2436: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
2437: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
2438: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
2439: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
2440: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
2441: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
2442: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
2443: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
2444: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM

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

2437: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
2438: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
2439: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
2440: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
2441: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
2442: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
2443: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
2444: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
2445: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR

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

2438: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
2439: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
2440: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
2441: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
2442: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
2443: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
2444: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
2445: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
2446: ,p_append_description_flag IN VARCHAR2 := 'N'

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

2439: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR
2440: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
2441: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
2442: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
2443: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
2444: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
2445: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
2446: ,p_append_description_flag IN VARCHAR2 := 'N'
2447: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE

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

2440: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
2441: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
2442: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
2443: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
2444: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
2445: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
2446: ,p_append_description_flag IN VARCHAR2 := 'N'
2447: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
2448: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE

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

2441: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
2442: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
2443: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
2444: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
2445: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
2446: ,p_append_description_flag IN VARCHAR2 := 'N'
2447: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
2448: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
2449: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR

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

2443: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
2444: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
2445: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
2446: ,p_append_description_flag IN VARCHAR2 := 'N'
2447: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
2448: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
2449: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
2450: ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
2451: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM

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

2444: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
2445: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
2446: ,p_append_description_flag IN VARCHAR2 := 'N'
2447: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
2448: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
2449: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
2450: ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
2451: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
2452: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR

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

2445: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
2446: ,p_append_description_flag IN VARCHAR2 := 'N'
2447: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
2448: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
2449: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
2450: ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
2451: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
2452: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
2453: ,p_append_information_flag IN VARCHAR2 := 'N'

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

2446: ,p_append_description_flag IN VARCHAR2 := 'N'
2447: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
2448: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
2449: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
2450: ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
2451: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
2452: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
2453: ,p_append_information_flag IN VARCHAR2 := 'N'
2454: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM

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

2447: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
2448: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
2449: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
2450: ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
2451: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
2452: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
2453: ,p_append_information_flag IN VARCHAR2 := 'N'
2454: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
2455: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM

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

2448: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE
2449: ,p_extension_possible IN pa_project_assignments.extension_possible%TYPE := FND_API.G_MISS_CHAR
2450: ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
2451: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
2452: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
2453: ,p_append_information_flag IN VARCHAR2 := 'N'
2454: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
2455: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
2456: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR

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

2450: ,p_min_resource_job_level IN pa_project_assignments.min_resource_job_level%TYPE := FND_API.G_MISS_NUM
2451: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
2452: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
2453: ,p_append_information_flag IN VARCHAR2 := 'N'
2454: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
2455: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
2456: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
2457: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
2458: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM

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

2451: ,p_max_resource_job_level IN pa_project_assignments.max_resource_job_level%TYPE := FND_API.G_MISS_NUM
2452: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
2453: ,p_append_information_flag IN VARCHAR2 := 'N'
2454: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
2455: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
2456: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
2457: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
2458: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
2459: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR

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

2452: ,p_additional_information IN pa_project_assignments.additional_information%TYPE := FND_API.G_MISS_CHAR
2453: ,p_append_information_flag IN VARCHAR2 := 'N'
2454: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
2455: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
2456: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
2457: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
2458: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
2459: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
2460: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR

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

2453: ,p_append_information_flag IN VARCHAR2 := 'N'
2454: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
2455: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
2456: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
2457: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
2458: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
2459: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
2460: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
2461: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR

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

2454: ,p_location_id IN pa_project_assignments.location_id%TYPE := FND_API.G_MISS_NUM
2455: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
2456: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
2457: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
2458: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
2459: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
2460: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
2461: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
2462: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR

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

2455: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
2456: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
2457: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
2458: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
2459: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
2460: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
2461: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
2462: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
2463: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR

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

2456: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
2457: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
2458: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
2459: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
2460: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
2461: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
2462: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
2463: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
2464: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR

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

2457: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
2458: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
2459: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
2460: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
2461: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
2462: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
2463: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
2464: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
2465: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR

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

2458: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
2459: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
2460: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
2461: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
2462: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
2463: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
2464: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
2465: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
2466: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR

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

2459: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
2460: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
2461: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
2462: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
2463: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
2464: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
2465: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
2466: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
2467: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR

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

2460: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
2461: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
2462: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
2463: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
2464: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
2465: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
2466: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
2467: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
2468: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR

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

2461: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
2462: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
2463: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
2464: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
2465: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
2466: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
2467: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
2468: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
2469: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR

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

2462: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
2463: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
2464: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
2465: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
2466: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
2467: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
2468: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
2469: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
2470: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR

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

2463: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
2464: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
2465: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
2466: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
2467: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
2468: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
2469: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
2470: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
2471: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR

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

2464: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
2465: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
2466: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
2467: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
2468: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
2469: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
2470: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
2471: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
2472: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM

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

2465: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
2466: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
2467: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
2468: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
2469: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
2470: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
2471: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
2472: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
2473: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR

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

2466: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
2467: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
2468: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
2469: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
2470: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
2471: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
2472: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
2473: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
2474: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR

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

2467: ,p_location_country_name IN fnd_territories_tl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
2468: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
2469: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
2470: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
2471: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
2472: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
2473: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
2474: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
2475: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM

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

2468: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
2469: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
2470: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
2471: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
2472: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
2473: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
2474: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
2475: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
2476: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM

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

2469: ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
2470: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
2471: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
2472: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
2473: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
2474: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
2475: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
2476: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
2477: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM

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

2470: ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
2471: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
2472: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
2473: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
2474: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
2475: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
2476: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
2477: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
2478: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM

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

2471: ,p_expense_owner IN pa_project_assignments.expense_owner%TYPE := FND_API.G_MISS_CHAR
2472: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
2473: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
2474: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
2475: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
2476: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
2477: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
2478: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
2479: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR

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

2472: ,p_expense_limit IN pa_project_assignments.expense_limit%TYPE := FND_API.G_MISS_NUM
2473: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
2474: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
2475: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
2476: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
2477: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
2478: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
2479: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
2480: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR

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

2473: ,p_expense_limit_currency_code IN pa_project_assignments.expense_limit_currency_code%TYPE := FND_API.G_MISS_CHAR
2474: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
2475: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
2476: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
2477: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
2478: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
2479: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
2480: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
2481: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM

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

2474: ,p_fcst_tp_amount_type IN pa_project_assignments.fcst_tp_amount_type%TYPE := FND_API.G_MISS_CHAR
2475: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
2476: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
2477: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
2478: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
2479: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
2480: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
2481: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
2482: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM

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

2475: ,p_fcst_job_id IN pa_project_assignments.fcst_job_id%TYPE := FND_API.G_MISS_NUM
2476: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
2477: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
2478: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
2479: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
2480: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
2481: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
2482: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
2483: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM

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

2476: ,p_fcst_job_group_id IN pa_project_assignments.fcst_job_group_id%TYPE := FND_API.G_MISS_NUM
2477: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
2478: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
2479: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
2480: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
2481: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
2482: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
2483: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
2484: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM

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

2477: ,p_expenditure_org_id IN pa_project_assignments.expenditure_org_id%TYPE := FND_API.G_MISS_NUM
2478: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
2479: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
2480: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
2481: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
2482: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
2483: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
2484: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
2485: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR

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

2478: ,p_expenditure_organization_id IN pa_project_assignments.expenditure_organization_id%TYPE := FND_API.G_MISS_NUM
2479: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
2480: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
2481: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
2482: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
2483: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
2484: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
2485: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
2486: ,p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR

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

2479: ,p_expenditure_type_class IN pa_project_assignments.expenditure_type_class%TYPE := FND_API.G_MISS_CHAR
2480: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
2481: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
2482: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
2483: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
2484: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
2485: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
2486: ,p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
2487: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM

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

2480: ,p_expenditure_type IN pa_project_assignments.expenditure_type%TYPE := FND_API.G_MISS_CHAR
2481: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
2482: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
2483: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
2484: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
2485: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
2486: ,p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
2487: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
2488: ,p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR

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

2481: ,p_comp_match_weighting IN pa_project_assignments.competence_match_weighting%TYPE := FND_API.G_MISS_NUM
2482: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
2483: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
2484: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
2485: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
2486: ,p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
2487: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
2488: ,p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
2489: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM

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

2482: ,p_avail_match_weighting IN pa_project_assignments.availability_match_weighting%TYPE := FND_API.G_MISS_NUM
2483: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
2484: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
2485: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
2486: ,p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
2487: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
2488: ,p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
2489: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
2490: ,p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR

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

2483: ,p_job_level_match_weighting IN pa_project_assignments.job_level_match_weighting%TYPE := FND_API.G_MISS_NUM
2484: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
2485: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
2486: ,p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
2487: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
2488: ,p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
2489: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
2490: ,p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
2491: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM

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

2484: ,p_search_min_availability IN pa_project_assignments.search_min_availability%TYPE := FND_API.G_MISS_NUM
2485: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
2486: ,p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
2487: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
2488: ,p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
2489: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
2490: ,p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
2491: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
2492: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR

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

2485: ,p_search_country_code IN pa_project_assignments.search_country_code%TYPE := FND_API.G_MISS_CHAR
2486: ,p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
2487: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
2488: ,p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
2489: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
2490: ,p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
2491: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
2492: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
2493: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM

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

2486: ,p_search_country_name IN fnd_territories_vl.territory_short_name%TYPE := FND_API.G_MISS_CHAR
2487: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
2488: ,p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
2489: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
2490: ,p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
2491: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
2492: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
2493: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
2494: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR

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

2487: ,p_search_exp_org_struct_ver_id IN pa_project_assignments.search_exp_org_struct_ver_id%TYPE := FND_API.G_MISS_NUM
2488: ,p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
2489: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
2490: ,p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
2491: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
2492: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
2493: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
2494: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR
2495: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR

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

2488: ,p_search_exp_org_hier_name IN per_organization_structures.name%TYPE := FND_API.G_MISS_CHAR
2489: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
2490: ,p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
2491: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
2492: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
2493: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
2494: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR
2495: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
2496: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR

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

2489: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
2490: ,p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
2491: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
2492: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
2493: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
2494: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR
2495: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
2496: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
2497: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR

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

2490: ,p_search_exp_start_org_name IN hr_organization_units.name%TYPE := FND_API.G_MISS_CHAR
2491: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
2492: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
2493: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
2494: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR
2495: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
2496: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
2497: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
2498: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR

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

2491: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
2492: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
2493: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
2494: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR
2495: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
2496: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
2497: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
2498: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
2499: ,p_exception_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR

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

2492: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
2493: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
2494: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR
2495: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
2496: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
2497: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
2498: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
2499: ,p_exception_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2500: ,p_change_start_date IN DATE := FND_API.G_MISS_DATE

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

2493: ,p_staffing_owner_person_id IN pa_project_assignments.staffing_owner_person_id%TYPE := FND_API.G_MISS_NUM
2494: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR
2495: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
2496: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
2497: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
2498: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
2499: ,p_exception_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2500: ,p_change_start_date IN DATE := FND_API.G_MISS_DATE
2501: ,p_change_end_date IN DATE := FND_API.G_MISS_DATE

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

2494: ,p_staffing_owner_name IN per_people_f.full_name%TYPE := FND_API.G_MISS_CHAR
2495: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
2496: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
2497: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
2498: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
2499: ,p_exception_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2500: ,p_change_start_date IN DATE := FND_API.G_MISS_DATE
2501: ,p_change_end_date IN DATE := FND_API.G_MISS_DATE
2502: ,p_change_rqmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR

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

2495: ,p_fcst_job_name IN per_jobs.name%TYPE := FND_API.G_MISS_CHAR
2496: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
2497: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
2498: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
2499: ,p_exception_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2500: ,p_change_start_date IN DATE := FND_API.G_MISS_DATE
2501: ,p_change_end_date IN DATE := FND_API.G_MISS_DATE
2502: ,p_change_rqmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2503: ,p_change_asgmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR

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

2496: ,p_fcst_job_group_name IN per_job_groups.displayed_name%TYPE := FND_API.G_MISS_CHAR
2497: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
2498: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
2499: ,p_exception_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2500: ,p_change_start_date IN DATE := FND_API.G_MISS_DATE
2501: ,p_change_end_date IN DATE := FND_API.G_MISS_DATE
2502: ,p_change_rqmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2503: ,p_change_asgmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2504: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL

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

2497: ,p_expenditure_org_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
2498: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
2499: ,p_exception_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2500: ,p_change_start_date IN DATE := FND_API.G_MISS_DATE
2501: ,p_change_end_date IN DATE := FND_API.G_MISS_DATE
2502: ,p_change_rqmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2503: ,p_change_asgmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2504: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
2505: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL

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

2498: ,p_exp_organization_name IN per_organization_units.name%TYPE := FND_API.G_MISS_CHAR
2499: ,p_exception_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2500: ,p_change_start_date IN DATE := FND_API.G_MISS_DATE
2501: ,p_change_end_date IN DATE := FND_API.G_MISS_DATE
2502: ,p_change_rqmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2503: ,p_change_asgmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2504: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
2505: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
2506: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

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

2499: ,p_exception_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2500: ,p_change_start_date IN DATE := FND_API.G_MISS_DATE
2501: ,p_change_end_date IN DATE := FND_API.G_MISS_DATE
2502: ,p_change_rqmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2503: ,p_change_asgmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2504: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
2505: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
2506: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2507: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

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

2510: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2511: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2512: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2513: ,p_non_working_day_flag IN VARCHAR2 := 'N'
2514: ,p_change_hours_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2515: ,p_hrs_per_day IN NUMBER := FND_API.G_MISS_NUM
2516: ,p_calendar_percent IN NUMBER := FND_API.G_MISS_NUM
2517: ,p_change_calendar_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2518: ,p_change_calendar_name IN VARCHAR2 := FND_API.G_MISS_CHAR

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

2511: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2512: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2513: ,p_non_working_day_flag IN VARCHAR2 := 'N'
2514: ,p_change_hours_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2515: ,p_hrs_per_day IN NUMBER := FND_API.G_MISS_NUM
2516: ,p_calendar_percent IN NUMBER := FND_API.G_MISS_NUM
2517: ,p_change_calendar_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2518: ,p_change_calendar_name IN VARCHAR2 := FND_API.G_MISS_CHAR
2519: ,p_change_calendar_id IN NUMBER := FND_API.G_MISS_NUM

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

2512: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2513: ,p_non_working_day_flag IN VARCHAR2 := 'N'
2514: ,p_change_hours_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2515: ,p_hrs_per_day IN NUMBER := FND_API.G_MISS_NUM
2516: ,p_calendar_percent IN NUMBER := FND_API.G_MISS_NUM
2517: ,p_change_calendar_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2518: ,p_change_calendar_name IN VARCHAR2 := FND_API.G_MISS_CHAR
2519: ,p_change_calendar_id IN NUMBER := FND_API.G_MISS_NUM
2520: ,p_duration_shift_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR

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

2513: ,p_non_working_day_flag IN VARCHAR2 := 'N'
2514: ,p_change_hours_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2515: ,p_hrs_per_day IN NUMBER := FND_API.G_MISS_NUM
2516: ,p_calendar_percent IN NUMBER := FND_API.G_MISS_NUM
2517: ,p_change_calendar_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2518: ,p_change_calendar_name IN VARCHAR2 := FND_API.G_MISS_CHAR
2519: ,p_change_calendar_id IN NUMBER := FND_API.G_MISS_NUM
2520: ,p_duration_shift_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2521: ,p_duration_shift_unit_code IN VARCHAR2 := FND_API.G_MISS_CHAR

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

2514: ,p_change_hours_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2515: ,p_hrs_per_day IN NUMBER := FND_API.G_MISS_NUM
2516: ,p_calendar_percent IN NUMBER := FND_API.G_MISS_NUM
2517: ,p_change_calendar_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2518: ,p_change_calendar_name IN VARCHAR2 := FND_API.G_MISS_CHAR
2519: ,p_change_calendar_id IN NUMBER := FND_API.G_MISS_NUM
2520: ,p_duration_shift_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2521: ,p_duration_shift_unit_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2522: ,p_num_of_shift IN NUMBER := FND_API.G_MISS_NUM

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

2515: ,p_hrs_per_day IN NUMBER := FND_API.G_MISS_NUM
2516: ,p_calendar_percent IN NUMBER := FND_API.G_MISS_NUM
2517: ,p_change_calendar_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2518: ,p_change_calendar_name IN VARCHAR2 := FND_API.G_MISS_CHAR
2519: ,p_change_calendar_id IN NUMBER := FND_API.G_MISS_NUM
2520: ,p_duration_shift_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2521: ,p_duration_shift_unit_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2522: ,p_num_of_shift IN NUMBER := FND_API.G_MISS_NUM
2523: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl

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

2516: ,p_calendar_percent IN NUMBER := FND_API.G_MISS_NUM
2517: ,p_change_calendar_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2518: ,p_change_calendar_name IN VARCHAR2 := FND_API.G_MISS_CHAR
2519: ,p_change_calendar_id IN NUMBER := FND_API.G_MISS_NUM
2520: ,p_duration_shift_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2521: ,p_duration_shift_unit_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2522: ,p_num_of_shift IN NUMBER := FND_API.G_MISS_NUM
2523: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2524: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl

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

2517: ,p_change_calendar_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2518: ,p_change_calendar_name IN VARCHAR2 := FND_API.G_MISS_CHAR
2519: ,p_change_calendar_id IN NUMBER := FND_API.G_MISS_NUM
2520: ,p_duration_shift_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2521: ,p_duration_shift_unit_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2522: ,p_num_of_shift IN NUMBER := FND_API.G_MISS_NUM
2523: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2524: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2525: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl

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

2518: ,p_change_calendar_name IN VARCHAR2 := FND_API.G_MISS_CHAR
2519: ,p_change_calendar_id IN NUMBER := FND_API.G_MISS_NUM
2520: ,p_duration_shift_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2521: ,p_duration_shift_unit_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2522: ,p_num_of_shift IN NUMBER := FND_API.G_MISS_NUM
2523: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2524: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2525: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2526: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl

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

2524: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2525: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2526: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2527: ,p_appr_over_auth_flag IN VARCHAR2 := 'N'
2528: ,p_note_to_all_approvers IN VARCHAR2 := FND_API.G_MISS_CHAR
2529: ,p_competence_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2530: ,p_competence_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2531: ,p_competence_alias_tbl IN SYSTEM.pa_varchar2_30_tbl_type := prm_empty_varchar2_30_tbl
2532: ,p_rating_level_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl

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

2530: ,p_competence_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2531: ,p_competence_alias_tbl IN SYSTEM.pa_varchar2_30_tbl_type := prm_empty_varchar2_30_tbl
2532: ,p_rating_level_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2533: ,p_mandatory_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type := prm_empty_varchar2_1_tbl
2534: ,p_resolve_con_action_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2535: ,p_api_version IN NUMBER := 1.0
2536: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
2537: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
2538: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

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

2532: ,p_rating_level_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2533: ,p_mandatory_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type := prm_empty_varchar2_1_tbl
2534: ,p_resolve_con_action_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2535: ,p_api_version IN NUMBER := 1.0
2536: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
2537: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
2538: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2539: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
2540: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

2533: ,p_mandatory_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type := prm_empty_varchar2_1_tbl
2534: ,p_resolve_con_action_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2535: ,p_api_version IN NUMBER := 1.0
2536: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
2537: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
2538: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2539: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
2540: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2541: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

2534: ,p_resolve_con_action_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2535: ,p_api_version IN NUMBER := 1.0
2536: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
2537: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
2538: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2539: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
2540: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2541: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2542: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

2535: ,p_api_version IN NUMBER := 1.0
2536: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
2537: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
2538: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2539: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
2540: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2541: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2542: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2543: )

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

2548: l_project_party_id NUMBER ;
2549: l_project_role_id NUMBER ;
2550: l_project_role_name VARCHAR2(80);
2551: l_admin_project VARCHAR2(1); --Variable which denotes if a project is an admin project or not
2552: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2553: l_error_message_code fnd_new_messages.message_name%TYPE;
2554: l_assignment_start_date DATE;
2555: l_approver1_person_id NUMBER;
2556: l_approver1_person_name VARCHAR2(200);

Line 2581: x_return_status := FND_API.G_RET_STS_SUCCESS;

2577: ,x_log_level => 1);
2578: END IF;
2579:
2580: -- Initialize the return status to success
2581: x_return_status := FND_API.G_RET_STS_SUCCESS;
2582:
2583: --Clear the global PL/SQL message table
2584: FND_MSG_PUB.initialize;
2585:

Line 2587: IF p_commit = FND_API.G_TRUE THEN

2583: --Clear the global PL/SQL message table
2584: FND_MSG_PUB.initialize;
2585:
2586: -- Issue API savepoint if the transaction is to be committed
2587: IF p_commit = FND_API.G_TRUE THEN
2588: SAVEPOINT MASS_SUBMIT_ASGN_APPRVL;
2589: END IF;
2590:
2591: -----------------------------------------

Line 2644: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2640: ,x_project_role_name => l_project_role_name
2641: ,x_return_status => l_return_status
2642: ,x_error_message_code => l_error_message_code );
2643:
2644: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2645: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2646: ,p_msg_name => l_error_message_code);
2647: END IF;
2648:

Line 2649: l_error_message_code := FND_API.G_MISS_CHAR;

2645: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2646: ,p_msg_name => l_error_message_code);
2647: END IF;
2648:
2649: l_error_message_code := FND_API.G_MISS_CHAR;
2650:
2651: END IF;
2652:
2653: IF l_return_status <> FND_API.G_RET_STS_ERROR THEN

Line 2653: IF l_return_status <> FND_API.G_RET_STS_ERROR THEN

2649: l_error_message_code := FND_API.G_MISS_CHAR;
2650:
2651: END IF;
2652:
2653: IF l_return_status <> FND_API.G_RET_STS_ERROR THEN
2654:
2655: ---------------------------------
2656: --Call the mass transaction API
2657: ---------------------------------

Line 2764: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2760: ,p_mandatory_flag_tbl => p_mandatory_flag_tbl
2761: ,p_resolve_con_action_code => p_resolve_con_action_code
2762: ,x_return_status => l_return_status );
2763:
2764: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2765: x_return_status := l_return_status;
2766: END IF;
2767:
2768: END IF;

Line 2776: ( p_encoded => FND_API.G_TRUE

2772: -- IF the number of messages is 1 then fetch the message code from
2773: -- the stack and return its text
2774: IF x_msg_count = 1 THEN
2775: pa_interface_utils_pub.get_messages
2776: ( p_encoded => FND_API.G_TRUE
2777: ,p_msg_index => 1
2778: ,p_data => x_msg_data
2779: ,p_msg_index_out => l_msg_index_out );
2780: END IF;

Line 2787: x_return_status := FND_API.G_RET_STS_ERROR;

2783: PA_DEBUG.Reset_Err_Stack;
2784:
2785: -- If g_error_exists is TRUE then set the x_return_status to 'E'
2786: IF FND_MSG_PUB.Count_Msg >0 THEN
2787: x_return_status := FND_API.G_RET_STS_ERROR;
2788: END IF;
2789:
2790: EXCEPTION
2791: WHEN OTHERS THEN

Line 2793: IF p_commit = FND_API.G_TRUE THEN

2789:
2790: EXCEPTION
2791: WHEN OTHERS THEN
2792:
2793: IF p_commit = FND_API.G_TRUE THEN
2794: ROLLBACK TO MASS_SUBMIT_ASGN_APPRVL;
2795: END IF;
2796:
2797: -- Set the excetption Message and the stack

Line 2802: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2798: FND_MSG_PUB.add_exc_msg
2799: ( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PUB.mass_submit_for_asgmt_aprvl'
2800: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
2801:
2802: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2803: RAISE;
2804:
2805: END mass_submit_for_asgmt_aprvl;
2806:

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

2811: --The IN parameters are assignments table which are submitted for
2812: --approval along with 2 approvers tables
2813: ---------------------------------------------------------------------------
2814: PROCEDURE mass_assignment_approval
2815: ( p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
2816: ,p_mode IN VARCHAR2
2817: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2818: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2819: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl

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

2819: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2820: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2821: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2822: ,p_overriding_authority_flag IN VARCHAR2 := 'N'
2823: ,p_submitter_user_id IN NUMBER := FND_API.G_MISS_NUM
2824: ,p_note_to_all_approvers IN VARCHAR2 := FND_API.G_MISS_CHAR
2825: ,p_conflict_group_id IN NUMBER := FND_API.G_MISS_NUM
2826: ,p_update_info_doc IN VARCHAR2 := FND_API.G_MISS_CHAR
2827: ,p_api_version IN NUMBER := 1.0

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

2820: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2821: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2822: ,p_overriding_authority_flag IN VARCHAR2 := 'N'
2823: ,p_submitter_user_id IN NUMBER := FND_API.G_MISS_NUM
2824: ,p_note_to_all_approvers IN VARCHAR2 := FND_API.G_MISS_CHAR
2825: ,p_conflict_group_id IN NUMBER := FND_API.G_MISS_NUM
2826: ,p_update_info_doc IN VARCHAR2 := FND_API.G_MISS_CHAR
2827: ,p_api_version IN NUMBER := 1.0
2828: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

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

2821: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2822: ,p_overriding_authority_flag IN VARCHAR2 := 'N'
2823: ,p_submitter_user_id IN NUMBER := FND_API.G_MISS_NUM
2824: ,p_note_to_all_approvers IN VARCHAR2 := FND_API.G_MISS_CHAR
2825: ,p_conflict_group_id IN NUMBER := FND_API.G_MISS_NUM
2826: ,p_update_info_doc IN VARCHAR2 := FND_API.G_MISS_CHAR
2827: ,p_api_version IN NUMBER := 1.0
2828: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
2829: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

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

2822: ,p_overriding_authority_flag IN VARCHAR2 := 'N'
2823: ,p_submitter_user_id IN NUMBER := FND_API.G_MISS_NUM
2824: ,p_note_to_all_approvers IN VARCHAR2 := FND_API.G_MISS_CHAR
2825: ,p_conflict_group_id IN NUMBER := FND_API.G_MISS_NUM
2826: ,p_update_info_doc IN VARCHAR2 := FND_API.G_MISS_CHAR
2827: ,p_api_version IN NUMBER := 1.0
2828: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
2829: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
2830: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

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

2824: ,p_note_to_all_approvers IN VARCHAR2 := FND_API.G_MISS_CHAR
2825: ,p_conflict_group_id IN NUMBER := FND_API.G_MISS_NUM
2826: ,p_update_info_doc IN VARCHAR2 := FND_API.G_MISS_CHAR
2827: ,p_api_version IN NUMBER := 1.0
2828: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
2829: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
2830: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2831: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
2832: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

2825: ,p_conflict_group_id IN NUMBER := FND_API.G_MISS_NUM
2826: ,p_update_info_doc IN VARCHAR2 := FND_API.G_MISS_CHAR
2827: ,p_api_version IN NUMBER := 1.0
2828: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
2829: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
2830: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2831: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
2832: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2833: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

2826: ,p_update_info_doc IN VARCHAR2 := FND_API.G_MISS_CHAR
2827: ,p_api_version IN NUMBER := 1.0
2828: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
2829: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
2830: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2831: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
2832: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2833: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2834: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

2827: ,p_api_version IN NUMBER := 1.0
2828: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
2829: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
2830: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2831: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
2832: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2833: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2834: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2835: )

Line 2970: x_return_status := FND_API.G_RET_STS_SUCCESS;

2966: ,x_log_level => 1);
2967: END IF;
2968:
2969: -- Initialize the return status to success
2970: x_return_status := FND_API.G_RET_STS_SUCCESS;
2971:
2972: --Clear the global PL/SQL message table
2973: FND_MSG_PUB.initialize;
2974:

Line 2976: IF p_commit = FND_API.G_TRUE THEN

2972: --Clear the global PL/SQL message table
2973: FND_MSG_PUB.initialize;
2974:
2975: -- Issue API savepoint if the transaction is to be committed
2976: IF p_commit = FND_API.G_TRUE THEN
2977: SAVEPOINT MASS_ASGN_APPRVL;
2978: END IF;
2979:
2980: ---------------------------------------------------------------------

Line 3055: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3051: ,x_error_message_code => l_error_message_code );
3052:
3053: -- Only non-admin projects require a manager
3054: IF l_projects_rec.admin_flag = 'N' THEN
3055: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3056: pa_utils.add_message (p_app_short_name => 'PA',
3057: p_msg_name => l_error_message_code);
3058: END IF;
3059: END IF;

Line 3069: l_return_status := FND_API.G_RET_STS_ERROR;

3065: -- Also if Workflow is disabled - then exit
3066: OPEN l_stus_csr;
3067: FETCH l_stus_csr INTO l_stus_rec;
3068: IF l_stus_csr%NOTFOUND THEN
3069: l_return_status := FND_API.G_RET_STS_ERROR;
3070: l_error_message_code := 'PA_INVALID_STATUS_CODE';
3071: pa_utils.add_message (p_app_short_name => 'PA'
3072: ,p_msg_name => 'PA_INVALID_STATUS_CODE');
3073: RAISE INVALID_STATUS;

Line 3292: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

3288: ,x_return_status => l_return_status
3289: ,x_msg_count => l_msg_count
3290: ,x_msg_data => l_msg_data);
3291:
3292: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3293: l_return_status := FND_API.G_MISS_CHAR;
3294: log_message('Error in Update approval status 1');
3295: RAISE PROCESS_ASSIGNMENT_EXCEPTION;
3296: END IF;

Line 3293: l_return_status := FND_API.G_MISS_CHAR;

3289: ,x_msg_count => l_msg_count
3290: ,x_msg_data => l_msg_data);
3291:
3292: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3293: l_return_status := FND_API.G_MISS_CHAR;
3294: log_message('Error in Update approval status 1');
3295: RAISE PROCESS_ASSIGNMENT_EXCEPTION;
3296: END IF;
3297:

Line 3305: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

3301: ,x_return_status => l_return_status
3302: ,x_msg_count => l_msg_count
3303: ,x_msg_data => l_msg_data);
3304:
3305: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3306: l_return_status := FND_API.G_MISS_CHAR;
3307: log_message('Error in conflict resolution');
3308: RAISE PROCESS_ASSIGNMENT_EXCEPTION;
3309: END IF;

Line 3306: l_return_status := FND_API.G_MISS_CHAR;

3302: ,x_msg_count => l_msg_count
3303: ,x_msg_data => l_msg_data);
3304:
3305: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3306: l_return_status := FND_API.G_MISS_CHAR;
3307: log_message('Error in conflict resolution');
3308: RAISE PROCESS_ASSIGNMENT_EXCEPTION;
3309: END IF;
3310:

Line 3381: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

3377: ,x_return_status => l_return_status
3378: ,x_msg_count => l_msg_count
3379: ,x_msg_data => l_msg_data);
3380:
3381: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3382: l_return_status := FND_API.G_MISS_CHAR;
3383: log_message('Error in Update approval status 2');
3384: RAISE PROCESS_ASSIGNMENT_EXCEPTION;
3385: END IF;

Line 3382: l_return_status := FND_API.G_MISS_CHAR;

3378: ,x_msg_count => l_msg_count
3379: ,x_msg_data => l_msg_data);
3380:
3381: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3382: l_return_status := FND_API.G_MISS_CHAR;
3383: log_message('Error in Update approval status 2');
3384: RAISE PROCESS_ASSIGNMENT_EXCEPTION;
3385: END IF;
3386:

Line 3517: p_commit => FND_API.G_FALSE,

3513: p_source_identifier2 => l_group_id,
3514: p_context1 => p_project_id,
3515: p_context2 => l_assignment_id_tbl(i),
3516: p_context3 => l_resource_id,
3517: p_commit => FND_API.G_FALSE,
3518: x_return_status => l_return_status);
3519:
3520: --Setting pending approval flag in pa_project_assignments
3521: PA_ASGMT_WFSTD.Maintain_wf_pending_flag

Line 3764: ( p_encoded => FND_API.G_TRUE

3760: x_msg_count := FND_MSG_PUB.Count_Msg;
3761:
3762: IF x_msg_count = 1 THEN
3763: pa_interface_utils_pub.get_messages
3764: ( p_encoded => FND_API.G_TRUE
3765: ,p_msg_index => 1
3766: ,p_data => x_msg_data
3767: ,p_msg_index_out => l_msg_index_out );
3768: END IF;

Line 3775: x_return_status := FND_API.G_RET_STS_ERROR;

3771: PA_DEBUG.Reset_Err_Stack;
3772:
3773: -- If g_error_exists is TRUE then set the x_return_status to 'E'
3774: IF FND_MSG_PUB.Count_Msg >0 THEN
3775: x_return_status := FND_API.G_RET_STS_ERROR;
3776: END IF;
3777:
3778: EXCEPTION
3779: WHEN NO_WORKFLOW_EXCEPTION THEN

Line 3781: x_return_status := FND_API.G_RET_STS_SUCCESS;

3777:
3778: EXCEPTION
3779: WHEN NO_WORKFLOW_EXCEPTION THEN
3780: --TODO: Check
3781: x_return_status := FND_API.G_RET_STS_SUCCESS;
3782:
3783: WHEN INVALID_STATUS THEN
3784:
3785: IF p_commit = FND_API.G_TRUE THEN

Line 3785: IF p_commit = FND_API.G_TRUE THEN

3781: x_return_status := FND_API.G_RET_STS_SUCCESS;
3782:
3783: WHEN INVALID_STATUS THEN
3784:
3785: IF p_commit = FND_API.G_TRUE THEN
3786: ROLLBACK TO MASS_ASGN_APPRVL;
3787: END IF;
3788:
3789: -- Set the excetption Message and the stack

Line 3794: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3790: FND_MSG_PUB.add_exc_msg
3791: ( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PUB.mass_assignment_approval'
3792: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
3793:
3794: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3795: RAISE;
3796:
3797: WHEN OTHERS THEN
3798:

Line 3799: IF p_commit = FND_API.G_TRUE THEN

3795: RAISE;
3796:
3797: WHEN OTHERS THEN
3798:
3799: IF p_commit = FND_API.G_TRUE THEN
3800: ROLLBACK TO MASS_ASGN_APPRVL;
3801: END IF;
3802:
3803: -- Set the excetption Message and the stack

Line 3808: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3804: FND_MSG_PUB.add_exc_msg
3805: ( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PUB.mass_assignment_approval'
3806: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
3807:
3808: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3809: RAISE;
3810: END mass_assignment_approval;
3811:
3812: ---------------------------------------------------------

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

3816: --Workflow Itemtype: PARMAAP
3817: --Workflow process : 'PA_MASS_PROCESS_APRVL_RESULT'
3818: ---------------------------------------------------------
3819: PROCEDURE mass_process_approval_result
3820: ( p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
3821: ,p_mode IN VARCHAR2
3822: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
3823: ,p_approval_status_tbl IN SYSTEM.pa_varchar2_30_tbl_type := prm_empty_varchar2_30_tbl
3824: ,p_group_id IN NUMBER

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

3826: ,p_routing_order IN NUMBER
3827: ,p_item_key IN NUMBER
3828: ,p_notification_id IN NUMBER
3829: ,p_submitter_user_name IN VARCHAR2
3830: ,p_conflict_group_id IN NUMBER := FND_API.G_MISS_NUM
3831: ,p_api_version IN NUMBER := 1.0
3832: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
3833: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
3834: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

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

3828: ,p_notification_id IN NUMBER
3829: ,p_submitter_user_name IN VARCHAR2
3830: ,p_conflict_group_id IN NUMBER := FND_API.G_MISS_NUM
3831: ,p_api_version IN NUMBER := 1.0
3832: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
3833: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
3834: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3835: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
3836: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

3829: ,p_submitter_user_name IN VARCHAR2
3830: ,p_conflict_group_id IN NUMBER := FND_API.G_MISS_NUM
3831: ,p_api_version IN NUMBER := 1.0
3832: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
3833: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
3834: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3835: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
3836: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3837: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

3830: ,p_conflict_group_id IN NUMBER := FND_API.G_MISS_NUM
3831: ,p_api_version IN NUMBER := 1.0
3832: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
3833: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
3834: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3835: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
3836: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3837: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
3838: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

3831: ,p_api_version IN NUMBER := 1.0
3832: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
3833: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
3834: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3835: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
3836: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3837: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
3838: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3839: )

Line 3882: x_return_status := FND_API.G_RET_STS_SUCCESS;

3878: ,x_log_level => 1);
3879: END IF;
3880:
3881: -- Initialize the return status to success
3882: x_return_status := FND_API.G_RET_STS_SUCCESS;
3883:
3884: --Clear the global PL/SQL message table
3885: FND_MSG_PUB.initialize;
3886:

Line 3888: IF p_commit = FND_API.G_TRUE THEN

3884: --Clear the global PL/SQL message table
3885: FND_MSG_PUB.initialize;
3886:
3887: -- Issue API savepoint if the transaction is to be committed
3888: IF p_commit = FND_API.G_TRUE THEN
3889: SAVEPOINT MASS_APPRVL_RESULT;
3890: END IF;
3891:
3892: --------------------------------------------------------

Line 4085: IF p_commit = FND_API.G_TRUE THEN

4081:
4082: EXCEPTION
4083: WHEN OTHERS THEN
4084:
4085: IF p_commit = FND_API.G_TRUE THEN
4086: ROLLBACK TO MASS_APPRVL_RESULT;
4087: END IF;
4088:
4089: --Setting the original value

Line 4097: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4093: FND_MSG_PUB.add_exc_msg
4094: ( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PUB.mass_process_approval_result'
4095: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
4096:
4097: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4098: RAISE;
4099: END mass_process_approval_result;
4100:
4101: ----------------------------------------------------

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

4112: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
4113: ,p_submitter_user_id IN NUMBER
4114: ,p_group_id IN NUMBER
4115: ,p_api_version IN NUMBER := 1.0
4116: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
4117: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
4118: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
4119: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
4120: ,p_overriding_authority_flag IN VARCHAR2 := 'N'

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

4113: ,p_submitter_user_id IN NUMBER
4114: ,p_group_id IN NUMBER
4115: ,p_api_version IN NUMBER := 1.0
4116: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
4117: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
4118: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
4119: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
4120: ,p_overriding_authority_flag IN VARCHAR2 := 'N'
4121: ,x_assignment_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type

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

4114: ,p_group_id IN NUMBER
4115: ,p_api_version IN NUMBER := 1.0
4116: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
4117: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
4118: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
4119: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
4120: ,p_overriding_authority_flag IN VARCHAR2 := 'N'
4121: ,x_assignment_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type
4122: ,x_approver1_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type

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

4115: ,p_api_version IN NUMBER := 1.0
4116: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
4117: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
4118: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
4119: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
4120: ,p_overriding_authority_flag IN VARCHAR2 := 'N'
4121: ,x_assignment_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type
4122: ,x_approver1_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type
4123: ,x_approver2_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type

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

4126: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4127: )
4128: IS
4129:
4130: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
4131: l_error_message_code fnd_new_messages.message_name%TYPE;
4132: l_assignment_start_date DATE;
4133: l_approver1_person_id NUMBER;
4134: l_approver1_person_name VARCHAR2(200);

Line 4155: x_return_status := FND_API.G_RET_STS_SUCCESS;

4151: ,x_log_level => 1);
4152: END IF;
4153:
4154: -- Initialize the return status to success
4155: x_return_status := FND_API.G_RET_STS_SUCCESS;
4156:
4157: --Clear the global PL/SQL message table
4158: FND_MSG_PUB.initialize;
4159:

Line 4161: IF p_commit = FND_API.G_TRUE THEN

4157: --Clear the global PL/SQL message table
4158: FND_MSG_PUB.initialize;
4159:
4160: -- Issue API savepoint if the transaction is to be committed
4161: IF p_commit = FND_API.G_TRUE THEN
4162: SAVEPOINT MASS_APPRVL_VALIDATE_NAMEID;
4163: END IF;
4164:
4165: log_message('Group id:' || p_group_id);

Line 4262: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4258: ,x_resource_type_id => l_resource_type_id
4259: ,x_return_status => l_return_status
4260: ,x_error_message_code => l_error_message_code );
4261:
4262: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4263: PA_UTILS.Add_Message( p_app_short_name => 'PA'
4264: ,p_msg_name => l_error_message_code);
4265: END IF;
4266:

Line 4293: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4289: ,x_resource_type_id => l_resource_type_id
4290: ,x_return_status => l_return_status
4291: ,x_error_message_code => l_error_message_code);
4292:
4293: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4294: PA_UTILS.Add_Message( p_app_short_name => 'PA'
4295: ,p_msg_name => l_error_message_code);
4296: END IF;
4297:

Line 4350: p_commit => FND_API.G_FALSE,

4346: p_source_identifier2 => p_group_id,
4347: p_context1 => p_project_id,
4348: p_context2 => p_assignment_id_tbl(i),
4349: p_context3 => l_resource_id,
4350: p_commit => FND_API.G_FALSE,
4351: x_return_status => l_return_status);
4352:
4353: END IF;
4354:

Line 4362: IF p_commit = FND_API.G_TRUE THEN

4358:
4359: EXCEPTION
4360: WHEN OTHERS THEN
4361:
4362: IF p_commit = FND_API.G_TRUE THEN
4363: ROLLBACK TO MASS_APPRVL_VALIDATE_NAMEID;
4364: END IF;
4365:
4366: -- Set the excetption Message and the stack

Line 4371: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4367: FND_MSG_PUB.add_exc_msg
4368: ( p_pkg_name => 'PA_ASSIGNMENT_APPROVAL_PUB.validate_approver_name_id'
4369: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
4370:
4371: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4372: RAISE;
4373: END validate_approver_name_id;
4374:
4375: