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

Line 134: FROM pa_project_statuses ps

130: CURSOR l_stus_csr (c_status_code IN VARCHAR2) IS
131: SELECT ps.wf_success_status_code,
132: ps.wf_failure_status_code,
133: ps.project_status_name
134: FROM pa_project_statuses ps
135: WHERE project_status_code = c_status_code;
136:
137: CURSOR l_resource_csr(l_resource_id IN NUMBER, p_start_date IN DATE) IS
138: SELECT per.full_name resource_name,

Line 265: l_wf_success_status_code pa_project_statuses.project_status_code%TYPE;

261: l_number_of_cancel_nf_rects NUMBER := 0;
262:
263: l_return_status VARCHAR2(1);
264: l_error_message_code VARCHAR2(30);
265: l_wf_success_status_code pa_project_statuses.project_status_code%TYPE;
266: l_wf_failure_status_code pa_project_statuses.project_status_code%TYPE;
267: l_project_status_name pa_project_statuses.project_status_name%TYPE;
268: l_resource_person_id NUMBER;
269: l_reapproval_flag VARCHAR2(1);

Line 266: l_wf_failure_status_code pa_project_statuses.project_status_code%TYPE;

262:
263: l_return_status VARCHAR2(1);
264: l_error_message_code VARCHAR2(30);
265: l_wf_success_status_code pa_project_statuses.project_status_code%TYPE;
266: l_wf_failure_status_code pa_project_statuses.project_status_code%TYPE;
267: l_project_status_name pa_project_statuses.project_status_name%TYPE;
268: l_resource_person_id NUMBER;
269: l_reapproval_flag VARCHAR2(1);
270: l_country_name VARCHAR2(200);

Line 267: l_project_status_name pa_project_statuses.project_status_name%TYPE;

263: l_return_status VARCHAR2(1);
264: l_error_message_code VARCHAR2(30);
265: l_wf_success_status_code pa_project_statuses.project_status_code%TYPE;
266: l_wf_failure_status_code pa_project_statuses.project_status_code%TYPE;
267: l_project_status_name pa_project_statuses.project_status_name%TYPE;
268: l_resource_person_id NUMBER;
269: l_reapproval_flag VARCHAR2(1);
270: l_country_name VARCHAR2(200);
271: l_city VARCHAR2(200);

Line 1484: FROM pa_project_statuses ps

1480: ps.workflow_item_type,
1481: ps.workflow_process,
1482: ps.project_system_status_code ,
1483: ps.enable_wf_flag
1484: FROM pa_project_statuses ps
1485: WHERE project_status_code = p_status_code;
1486:
1487: l_stus_rec l_stus_csr%ROWTYPE;
1488: l_msg_count NUMBER :=0;

Line 1903: ---l_asgmt_success_status_code pa_project_statuses.project_status_code%TYPE;

1899: , actid IN NUMBER
1900: , funcmode IN VARCHAR2
1901: , resultout OUT NOCOPY VARCHAR2 ) IS --File.Sql.39 bug 4440895
1902:
1903: ---l_asgmt_success_status_code pa_project_statuses.project_status_code%TYPE;
1904: l_asgmt_success_status_code VARCHAR2(30);
1905: -- l_assignment_id pa_project_assignments.assignment_id%TYPE;
1906: l_assignment_id NUMBER;
1907: l_msg_count NUMBER;

Line 1982: l_asgmt_failure_status_code pa_project_statuses.project_status_code%TYPE;

1978: , actid IN NUMBER
1979: , funcmode IN VARCHAR2
1980: , resultout OUT NOCOPY VARCHAR2 ) IS --File.Sql.39 bug 4440895
1981:
1982: l_asgmt_failure_status_code pa_project_statuses.project_status_code%TYPE;
1983: l_assignment_id pa_project_assignments.assignment_id%TYPE;
1984: l_msg_count NUMBER;
1985: l_msg_data VARCHAR2(200);
1986: l_error_message_code VARCHAR2(200);

Line 2057: l_assignment_id pa_project_statuses.project_status_code%TYPE;

2053: , actid IN NUMBER
2054: , funcmode IN VARCHAR2
2055: , resultout OUT NOCOPY VARCHAR2 ) IS --File.Sql.39 bug 4440895
2056:
2057: l_assignment_id pa_project_statuses.project_status_code%TYPE;
2058: l_new_item_type VARCHAR2(30);
2059: l_new_process VARCHAR2(30);
2060: l_new_asgmt_status_code pa_project_statuses.project_status_code%TYPE;
2061: l_return_status VARCHAR2(1);

Line 2060: l_new_asgmt_status_code pa_project_statuses.project_status_code%TYPE;

2056:
2057: l_assignment_id pa_project_statuses.project_status_code%TYPE;
2058: l_new_item_type VARCHAR2(30);
2059: l_new_process VARCHAR2(30);
2060: l_new_asgmt_status_code pa_project_statuses.project_status_code%TYPE;
2061: l_return_status VARCHAR2(1);
2062: l_error_message_code VARCHAR2(30);
2063: l_wf_type VARCHAR2(30);
2064: l_msg_count NUMBER;

Line 3427: p_status_code IN pa_project_statuses.project_status_code%TYPE,

3423:
3424:
3425: PROCEDURE Set_Asgmt_wf_result_Status
3426: (p_assignment_id IN pa_project_assignments.assignment_id%TYPE,
3427: p_status_code IN pa_project_statuses.project_status_code%TYPE,
3428: p_result_type IN VARCHAR2,
3429: p_item_type IN VARCHAR2,
3430: p_item_key IN VARCHAR2,
3431: x_return_status OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895

Line 3433: l_apprvl_status_code pa_project_statuses.project_status_code%TYPE;

3429: p_item_type IN VARCHAR2,
3430: p_item_key IN VARCHAR2,
3431: x_return_status OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
3432: IS
3433: l_apprvl_status_code pa_project_statuses.project_status_code%TYPE;
3434: l_change_id pa_assignments_history.change_id%TYPE;
3435: l_return_status VARCHAR2(30);
3436: l_msg_count NUMBER := 0;
3437: l_msg_data VARCHAR2(500);

Line 6644: l_apprvl_status_code pa_project_statuses.project_status_code%TYPE;

6640: AND object_id1 = p_assignment_id
6641: AND rownum = 1;
6642:
6643: l_record_version_number NUMBER;
6644: l_apprvl_status_code pa_project_statuses.project_status_code%TYPE;
6645: l_return_status VARCHAR2(1);
6646:
6647: BEGIN
6648: