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_PVT dependencies on PA_PROJECT_STATUSES

Line 329: ,x_apprvl_status_code OUT NOCOPY pa_project_statuses.project_status_code%TYPE --File.Sql.39 bug 4440895

325: p_assignment_id IN pa_project_assignments.assignment_id%TYPE
326: ,p_action_code IN VARCHAR2 := FND_API.G_MISS_CHAR
327: ,p_record_version_number IN pa_project_assignments.record_version_number%TYPE
328: ,p_note_to_approver IN VARCHAR2 := FND_API.G_MISS_CHAR
329: ,x_apprvl_status_code OUT NOCOPY pa_project_statuses.project_status_code%TYPE --File.Sql.39 bug 4440895
330: ,x_change_id OUT NOCOPY pa_assignments_history.change_id%TYPE --File.Sql.39 bug 4440895
331: ,x_record_version_number OUT NOCOPY pa_project_assignments.record_version_number%TYPE --File.Sql.39 bug 4440895
332: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
333: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 339: l_apprvl_status_code pa_project_statuses.project_status_code%TYPE;

335:
336: ) IS
337:
338: l_record_version_number NUMBER;
339: l_apprvl_status_code pa_project_statuses.project_status_code%TYPE;
340: l_return_status VARCHAR2(1);
341: l_msg_data VARCHAR2(2000);
342: l_msg_count NUMBER;
343: l_error_count NUMBER;

Line 568: ,p_status_code IN pa_project_statuses.project_status_code%TYPE := FND_API.G_MISS_CHAR

564: --
565: PROCEDURE Get_Next_Status_After_Action
566: (
567: p_action_code IN VARCHAR2 := FND_API.G_MISS_CHAR
568: ,p_status_code IN pa_project_statuses.project_status_code%TYPE := FND_API.G_MISS_CHAR
569: ,x_status_code OUT NOCOPY pa_project_statuses.project_status_code%TYPE --File.Sql.39 bug 4440895
570: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
571: ) IS
572:

Line 569: ,x_status_code OUT NOCOPY pa_project_statuses.project_status_code%TYPE --File.Sql.39 bug 4440895

565: PROCEDURE Get_Next_Status_After_Action
566: (
567: p_action_code IN VARCHAR2 := FND_API.G_MISS_CHAR
568: ,p_status_code IN pa_project_statuses.project_status_code%TYPE := FND_API.G_MISS_CHAR
569: ,x_status_code OUT NOCOPY pa_project_statuses.project_status_code%TYPE --File.Sql.39 bug 4440895
570: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
571: ) IS
572:
573: l_return_status VARCHAR2(1);

Line 575: l_success_status_code pa_project_statuses.project_status_code%TYPE;

571: ) IS
572:
573: l_return_status VARCHAR2(1);
574: l_error_message_code VARCHAR2(100);
575: l_success_status_code pa_project_statuses.project_status_code%TYPE;
576: l_failure_status_code pa_project_statuses.project_status_code%TYPE;
577:
578: BEGIN
579:

Line 576: l_failure_status_code pa_project_statuses.project_status_code%TYPE;

572:
573: l_return_status VARCHAR2(1);
574: l_error_message_code VARCHAR2(100);
575: l_success_status_code pa_project_statuses.project_status_code%TYPE;
576: l_failure_status_code pa_project_statuses.project_status_code%TYPE;
577:
578: BEGIN
579:
580: -- Initialize the Error Stack