DBA Data[Home] [Help]

APPS.PA_PROJECT_ASSIGNMENTS_PKG dependencies on PA_ASSIGNMENTS_PUB

Line 379: PA_ASSIGNMENTS_PUB.g_assignment_id_tbl.DELETE;

375: BEGIN
376:
377: x_return_status := FND_API.G_RET_STS_SUCCESS;
378:
379: PA_ASSIGNMENTS_PUB.g_assignment_id_tbl.DELETE;
380:
381: --if this is a template requirement then check that worflow is not in progress
382: --on the parent team template. If it is in progress then no new template requirements
383: --can be created

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

389:
390: IF l_workflow_in_progress_flag='Y' THEN
391: PA_ASSIGNMENT_UTILS.Add_Message( p_app_short_name => 'PA'
392: ,p_msg_name => 'PA_NO_REQ_WF');
393: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
394: x_return_status := FND_API.G_RET_STS_ERROR;
395: RETURN;
396: END IF;
397: END IF;

Line 673: PA_ASSIGNMENTS_PUB.g_assignment_id_tbl(i).assignment_id := l_assignment_id(i);

669: --so storing the pl/sql table of new assignments in a global.
670: --note that we only create multiple requirements, NOT assignments.
671: --can't bulk collect into a table of records - so need to loop through.
672: FOR i IN l_assignment_id.FIRST .. l_assignment_id.LAST LOOP
673: PA_ASSIGNMENTS_PUB.g_assignment_id_tbl(i).assignment_id := l_assignment_id(i);
674: END LOOP;
675: /*Commented the code for bug 3079906*/
676: --IF p_number_of_requirements = 1 THEN
677: --only return the new assignment id, number and assignment row id if we are creating only 1 requirement.

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

826:
827: IF l_workflow_in_progress_flag='Y' THEN
828: PA_ASSIGNMENT_UTILS.Add_Message( p_app_short_name => 'PA'
829: ,p_msg_name => 'PA_NO_REQ_WF');
830: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
831: x_return_status := FND_API.G_RET_STS_ERROR;
832: RETURN;
833: END IF;
834: END IF;

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

853: IF l_mass_wf_in_progress_flag = 'Y' THEN
854:
855: PA_ASSIGNMENT_UTILS.Add_Message( p_app_short_name => 'PA'
856: ,p_msg_name => 'PA_ASSIGNMENT_WF');
857: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
858: x_return_status := FND_API.G_RET_STS_ERROR;
859: RETURN;
860: END IF;
861: END IF;

Line 870: IF PA_ASSIGNMENTS_PUB.g_assignment_id_tbl.COUNT > 0 AND p_assignment_id IS NULL THEN

866: -- Copy the global assignment_id table into the local array
867: -- If global table is empty, then insert the passed in assignment_id into the local array
868: -- The global assignment_id table is not empty only when user is
869: -- creating multiple copies of requirement
870: IF PA_ASSIGNMENTS_PUB.g_assignment_id_tbl.COUNT > 0 AND p_assignment_id IS NULL THEN
871: FOR i IN PA_ASSIGNMENTS_PUB.g_assignment_id_tbl.FIRST .. PA_ASSIGNMENTS_PUB.g_assignment_id_tbl.LAST LOOP
872: l_assignment_id(i) :=PA_ASSIGNMENTS_PUB.g_assignment_id_tbl(i).assignment_id;
873: END LOOP;
874: ELSE

Line 871: FOR i IN PA_ASSIGNMENTS_PUB.g_assignment_id_tbl.FIRST .. PA_ASSIGNMENTS_PUB.g_assignment_id_tbl.LAST LOOP

867: -- If global table is empty, then insert the passed in assignment_id into the local array
868: -- The global assignment_id table is not empty only when user is
869: -- creating multiple copies of requirement
870: IF PA_ASSIGNMENTS_PUB.g_assignment_id_tbl.COUNT > 0 AND p_assignment_id IS NULL THEN
871: FOR i IN PA_ASSIGNMENTS_PUB.g_assignment_id_tbl.FIRST .. PA_ASSIGNMENTS_PUB.g_assignment_id_tbl.LAST LOOP
872: l_assignment_id(i) :=PA_ASSIGNMENTS_PUB.g_assignment_id_tbl(i).assignment_id;
873: END LOOP;
874: ELSE
875: l_assignment_id(1) := p_assignment_id;

Line 872: l_assignment_id(i) :=PA_ASSIGNMENTS_PUB.g_assignment_id_tbl(i).assignment_id;

868: -- The global assignment_id table is not empty only when user is
869: -- creating multiple copies of requirement
870: IF PA_ASSIGNMENTS_PUB.g_assignment_id_tbl.COUNT > 0 AND p_assignment_id IS NULL THEN
871: FOR i IN PA_ASSIGNMENTS_PUB.g_assignment_id_tbl.FIRST .. PA_ASSIGNMENTS_PUB.g_assignment_id_tbl.LAST LOOP
872: l_assignment_id(i) :=PA_ASSIGNMENTS_PUB.g_assignment_id_tbl(i).assignment_id;
873: END LOOP;
874: ELSE
875: l_assignment_id(1) := p_assignment_id;
876: END IF;

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

969: IF (SQL%NOTFOUND) THEN
970:
971: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
972: ,p_msg_name => 'PA_XC_RECORD_CHANGED');
973: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
974: x_return_status := FND_API.G_RET_STS_ERROR;
975:
976: END IF;
977:

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

1028: CLOSE check_team_template_wf;
1029: IF l_workflow_in_progress_flag = 'Y' THEN
1030: PA_UTILS.Add_Message( p_app_short_name => 'PA'
1031: ,p_msg_name => 'PA_NO_REQ_WF');
1032: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1033: x_return_status := FND_API.G_RET_STS_ERROR;
1034: RETURN;
1035: END IF;
1036:

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

1043: IF l_mass_wf_in_progress_flag = 'Y' THEN
1044:
1045: PA_ASSIGNMENT_UTILS.Add_Message( p_app_short_name => 'PA'
1046: ,p_msg_name => 'PA_ASSIGNMENT_WF');
1047: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1048: x_return_status := FND_API.G_RET_STS_ERROR;
1049: RETURN;
1050: END IF;
1051:

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

1066: IF (SQL%NOTFOUND) THEN
1067:
1068: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
1069: ,p_msg_name => 'PA_XC_RECORD_CHANGED');
1070: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1071: x_return_status := FND_API.G_RET_STS_ERROR;
1072:
1073: END IF;
1074: --