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_PROJECTS_MAINT_UTILS dependencies on PA_CLASS_CATEGORIES

Line 710: FROM pa_class_categories

706: IS
707: CURSOR class_delrec (c_class_category VARCHAR2)
708: IS
709: SELECT autoaccounting_flag
710: FROM pa_class_categories
711: WHERE class_category = c_class_category;
712:
713: l_dummy VARCHAR2(1);
714: l_rec_Status_flag VARCHAR2(1);

Line 846: PA_CLASS_CATEGORIES PCC

842: c_class_category VARCHAR2)
843: IS
844: SELECT 'x'
845: FROM PA_PROJECT_CLASSES_V PAC,
846: PA_CLASS_CATEGORIES PCC
847: WHERE PAC.object_id = c_object_id AND
848: PAC.object_type = c_object_type AND
849: PAC.class_category = c_class_category AND
850: PAC.class_category = PCC.class_category AND

Line 1350: FROM pa_class_categories

1346: x_return_status := 'S';
1347:
1348: SELECT allow_percent_flag
1349: INTO l_allow_percent_flag
1350: FROM pa_class_categories
1351: WHERE class_category = p_class_category;
1352:
1353: if l_allow_percent_flag = 'N' then
1354: x_return_status := 'E';

Line 1387: FROM pa_class_categories pcc,

1383:
1384: CURSOR C1(c_object_id NUMBER, c_object_type VARCHAR2)
1385: IS
1386: SELECT pcc.class_category, mandatory_flag
1387: FROM pa_class_categories pcc,
1388: pa_project_classes ppc
1389: WHERE pcc.class_category <> ppc.class_category
1390: AND ppc.object_id = c_object_id
1391: AND ppc.object_type = c_object_type

Line 1410: l_class_category pa_class_categories.class_category%TYPE;

1406: AND vc.object_type_id = ppta.project_type_id
1407: AND trunc(sysdate) between trunc(ppta.start_date_active)
1408: and trunc(nvl(ppta.end_date_active, sysdate));
1409:
1410: l_class_category pa_class_categories.class_category%TYPE;
1411: l_dummy NUMBER;
1412: l_mandatory_flag VARCHAR2(1);
1413: BEGIN
1414: x_return_status := 'S';

Line 1692: FROM PA_CLASS_CATEGORIES

1688:
1689: CURSOR C2
1690: IS
1691: SELECT total_100_percent_flag
1692: FROM PA_CLASS_CATEGORIES
1693: WHERE object_type = p_object_type
1694: AND class_category = p_class_category;
1695:
1696: -- 3690967 end

Line 2105: p_class_category_id IN pa_class_categories.class_category_id%TYPE

2101: --
2102: -- 20-Nov-2002 -- adabdull - Created
2103:
2104: PROCEDURE Check_ClassCategory_Name_Or_Id(
2105: p_class_category_id IN pa_class_categories.class_category_id%TYPE
2106: ,p_class_category_name IN pa_class_categories.class_category%TYPE
2107: ,p_check_id_flag IN VARCHAR2
2108: ,x_class_category_id OUT NOCOPY pa_class_categories.class_category_id%TYPE --File.Sql.39 bug 4440895
2109: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 2106: ,p_class_category_name IN pa_class_categories.class_category%TYPE

2102: -- 20-Nov-2002 -- adabdull - Created
2103:
2104: PROCEDURE Check_ClassCategory_Name_Or_Id(
2105: p_class_category_id IN pa_class_categories.class_category_id%TYPE
2106: ,p_class_category_name IN pa_class_categories.class_category%TYPE
2107: ,p_check_id_flag IN VARCHAR2
2108: ,x_class_category_id OUT NOCOPY pa_class_categories.class_category_id%TYPE --File.Sql.39 bug 4440895
2109: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2110: ,x_error_message_code OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 2108: ,x_class_category_id OUT NOCOPY pa_class_categories.class_category_id%TYPE --File.Sql.39 bug 4440895

2104: PROCEDURE Check_ClassCategory_Name_Or_Id(
2105: p_class_category_id IN pa_class_categories.class_category_id%TYPE
2106: ,p_class_category_name IN pa_class_categories.class_category%TYPE
2107: ,p_check_id_flag IN VARCHAR2
2108: ,x_class_category_id OUT NOCOPY pa_class_categories.class_category_id%TYPE --File.Sql.39 bug 4440895
2109: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2110: ,x_error_message_code OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
2111: IS
2112:

Line 2115: FROM pa_class_categories

2111: IS
2112:
2113: CURSOR c_ids IS
2114: SELECT class_category_id
2115: FROM pa_class_categories
2116: WHERE class_category = p_class_category_name;
2117:
2118: l_current_id NUMBER := NULL;
2119: l_num_ids NUMBER := 0;

Line 2131: FROM pa_class_categories

2127:
2128: IF p_check_id_flag = 'Y' THEN
2129: SELECT class_category_id
2130: INTO x_class_category_id
2131: FROM pa_class_categories
2132: WHERE class_category_id = p_class_category_id;
2133:
2134: ELSIF (p_check_id_flag = 'N') then
2135: x_class_category_id := p_class_category_id;

Line 2175: FROM pa_class_categories

2171:
2172: IF (p_class_category_name IS NOT NULL) then
2173: SELECT class_category_id
2174: INTO x_class_category_id
2175: FROM pa_class_categories
2176: WHERE class_category = p_class_category_name;
2177:
2178: ELSE
2179: x_class_category_id := NULL;

Line 2226: FROM pa_class_categories

2222: p_project_id NUMBER) RETURN VARCHAR2
2223: IS
2224: CURSOR C1 IS
2225: SELECT mandatory_flag
2226: FROM pa_class_categories
2227: WHERE class_category = p_class_category;
2228:
2229: CURSOR C2 IS
2230: SELECT ps.project_system_status_code