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 PA_PROJECT_STATUSES

Line 57: l_project_status_name pa_project_statuses.project_status_name%TYPE;

53:
54: l_approver_rec PA_ASSIGNMENT_APPROVAL_PUB.Asgmt_Approvers_Rec_Type;
55: l_assignment_type pa_project_assignments.assignment_type%TYPE;
56: l_project_id pa_project_assignments.project_id%TYPE;
57: l_project_status_name pa_project_statuses.project_status_name%TYPE;
58: l_success_status_code pa_project_statuses.project_status_code%TYPE;
59: l_failure_status_code pa_project_statuses.project_status_code%TYPE;
60: l_start_date pa_project_assignments.start_date%TYPE;
61: l_pending_approval_flag pa_project_assignments.pending_approval_flag%TYPE;

Line 58: l_success_status_code pa_project_statuses.project_status_code%TYPE;

54: l_approver_rec PA_ASSIGNMENT_APPROVAL_PUB.Asgmt_Approvers_Rec_Type;
55: l_assignment_type pa_project_assignments.assignment_type%TYPE;
56: l_project_id pa_project_assignments.project_id%TYPE;
57: l_project_status_name pa_project_statuses.project_status_name%TYPE;
58: l_success_status_code pa_project_statuses.project_status_code%TYPE;
59: l_failure_status_code pa_project_statuses.project_status_code%TYPE;
60: l_start_date pa_project_assignments.start_date%TYPE;
61: l_pending_approval_flag pa_project_assignments.pending_approval_flag%TYPE;
62: l_project_manager_person_id NUMBER ;

Line 59: l_failure_status_code pa_project_statuses.project_status_code%TYPE;

55: l_assignment_type pa_project_assignments.assignment_type%TYPE;
56: l_project_id pa_project_assignments.project_id%TYPE;
57: l_project_status_name pa_project_statuses.project_status_name%TYPE;
58: l_success_status_code pa_project_statuses.project_status_code%TYPE;
59: l_failure_status_code pa_project_statuses.project_status_code%TYPE;
60: l_start_date pa_project_assignments.start_date%TYPE;
61: l_pending_approval_flag pa_project_assignments.pending_approval_flag%TYPE;
62: l_project_manager_person_id NUMBER ;
63: l_project_manager_name VARCHAR2(200);

Line 101: pa_project_statuses pps,

97: CURSOR get_asgmt_info IS
98: SELECT ppa.assignment_type, ppa.project_id, ppa.start_date, ppa.status_code,
99: pps.project_status_name, ppa.pending_approval_flag
100: FROM pa_project_assignments ppa,
101: pa_project_statuses pps,
102: pa_projects_all pal
103: WHERE ppa.assignment_id = p_assignment_id
104: AND ppa.project_id = pal.project_id
105: AND pal.project_status_code = pps.project_status_code;

Line 1616: l_start_req_status_code pa_project_statuses.project_status_code%TYPE;

1612: l_record_version_number pa_project_assignments.record_version_number%TYPE;
1613: l_asgn_status_canceled_flag VARCHAR2(1);
1614: l_req_status_canceled_flag VARCHAR2(1);
1615: l_full_cancel_flag VARCHAR2(1);
1616: l_start_req_status_code pa_project_statuses.project_status_code%TYPE;
1617: l_new_assignment_flag VARCHAR2(1);
1618: l_change_id NUMBER;
1619: l_apprvl_status_code pa_project_statuses.project_status_code%TYPE;
1620: l_save_to_hist VARCHAR2(1);

Line 1619: l_apprvl_status_code pa_project_statuses.project_status_code%TYPE;

1615: l_full_cancel_flag VARCHAR2(1);
1616: l_start_req_status_code pa_project_statuses.project_status_code%TYPE;
1617: l_new_assignment_flag VARCHAR2(1);
1618: l_change_id NUMBER;
1619: l_apprvl_status_code pa_project_statuses.project_status_code%TYPE;
1620: l_save_to_hist VARCHAR2(1);
1621: l_new_assignment_id NUMBER;
1622: l_assignment_type pa_project_assignments.assignment_type%TYPE;
1623: l_req_start_date pa_project_assignments.start_date%TYPE;

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

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

Line 2817: FROM pa_project_statuses ps

2813: WHERE assignment_id = p_assignment_id;
2814:
2815: CURSOR l_stus_csr IS
2816: SELECT ps.enable_wf_flag
2817: FROM pa_project_statuses ps
2818: WHERE ps.project_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_submitted;
2819:
2820: l_stus_rec l_stus_csr%ROWTYPE;
2821: