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_WORK_TYPE_UTILS dependencies on PA_PROJECT_TYPES

Line 97: l_proj_typ_class_code pa_project_types.project_type_class_code%TYPE;

93: ,x_error_message_code OUT NOCOPY VARCHAR2)
94: IS
95: BEGIN
96: DECLARE
97: l_proj_typ_class_code pa_project_types.project_type_class_code%TYPE;
98: l_project_id pa_projects.project_id%TYPE;
99: l_project_type pa_project_types.project_type%TYPE;
100: l_flag varchar2(1);
101: CURSOR Get_Project_type_class_cur IS

Line 99: l_project_type pa_project_types.project_type%TYPE;

95: BEGIN
96: DECLARE
97: l_proj_typ_class_code pa_project_types.project_type_class_code%TYPE;
98: l_project_id pa_projects.project_id%TYPE;
99: l_project_type pa_project_types.project_type%TYPE;
100: l_flag varchar2(1);
101: CURSOR Get_Project_type_class_cur IS
102: SELECT p.project_type_class_code
103: FROM pa_project_types p

Line 103: FROM pa_project_types p

99: l_project_type pa_project_types.project_type%TYPE;
100: l_flag varchar2(1);
101: CURSOR Get_Project_type_class_cur IS
102: SELECT p.project_type_class_code
103: FROM pa_project_types p
104: WHERE p.project_type = l_project_type;
105: CURSOR Get_Project_type IS
106: SELECT a.project_type
107: FROM pa_projects a