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 697: FROM pa_class_categories

693: IS
694: CURSOR class_delrec (c_class_category VARCHAR2)
695: IS
696: SELECT autoaccounting_flag
697: FROM pa_class_categories
698: WHERE class_category = c_class_category;
699:
700: l_dummy VARCHAR2(1);
701: l_rec_Status_flag VARCHAR2(1);

Line 833: PA_CLASS_CATEGORIES PCC

829: c_class_category VARCHAR2)
830: IS
831: SELECT 'x'
832: FROM PA_PROJECT_CLASSES_V PAC,
833: PA_CLASS_CATEGORIES PCC
834: WHERE PAC.object_id = c_object_id AND
835: PAC.object_type = c_object_type AND
836: PAC.class_category = c_class_category AND
837: PAC.class_category = PCC.class_category AND

Line 1337: FROM pa_class_categories

1333: x_return_status := 'S';
1334:
1335: SELECT allow_percent_flag
1336: INTO l_allow_percent_flag
1337: FROM pa_class_categories
1338: WHERE class_category = p_class_category;
1339:
1340: if l_allow_percent_flag = 'N' then
1341: x_return_status := 'E';

Line 1374: FROM pa_class_categories pcc,

1370:
1371: CURSOR C1(c_object_id NUMBER, c_object_type VARCHAR2)
1372: IS
1373: SELECT pcc.class_category, mandatory_flag
1374: FROM pa_class_categories pcc,
1375: pa_project_classes ppc
1376: WHERE pcc.class_category <> ppc.class_category
1377: AND ppc.object_id = c_object_id
1378: AND ppc.object_type = c_object_type

Line 1397: l_class_category pa_class_categories.class_category%TYPE;

1393: AND vc.object_type_id = ppta.project_type_id
1394: AND trunc(sysdate) between trunc(ppta.start_date_active)
1395: and trunc(nvl(ppta.end_date_active, sysdate));
1396:
1397: l_class_category pa_class_categories.class_category%TYPE;
1398: l_dummy NUMBER;
1399: l_mandatory_flag VARCHAR2(1);
1400: BEGIN
1401: x_return_status := 'S';

Line 1679: FROM PA_CLASS_CATEGORIES

1675:
1676: CURSOR C2
1677: IS
1678: SELECT total_100_percent_flag
1679: FROM PA_CLASS_CATEGORIES
1680: WHERE object_type = p_object_type
1681: AND class_category = p_class_category;
1682:
1683: -- 3690967 end

Line 2092: p_class_category_id IN pa_class_categories.class_category_id%TYPE

2088: --
2089: -- 20-Nov-2002 -- adabdull - Created
2090:
2091: PROCEDURE Check_ClassCategory_Name_Or_Id(
2092: p_class_category_id IN pa_class_categories.class_category_id%TYPE
2093: ,p_class_category_name IN pa_class_categories.class_category%TYPE
2094: ,p_check_id_flag IN VARCHAR2
2095: ,x_class_category_id OUT NOCOPY pa_class_categories.class_category_id%TYPE --File.Sql.39 bug 4440895
2096: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 2093: ,p_class_category_name IN pa_class_categories.class_category%TYPE

2089: -- 20-Nov-2002 -- adabdull - Created
2090:
2091: PROCEDURE Check_ClassCategory_Name_Or_Id(
2092: p_class_category_id IN pa_class_categories.class_category_id%TYPE
2093: ,p_class_category_name IN pa_class_categories.class_category%TYPE
2094: ,p_check_id_flag IN VARCHAR2
2095: ,x_class_category_id OUT NOCOPY pa_class_categories.class_category_id%TYPE --File.Sql.39 bug 4440895
2096: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2097: ,x_error_message_code OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

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

2091: PROCEDURE Check_ClassCategory_Name_Or_Id(
2092: p_class_category_id IN pa_class_categories.class_category_id%TYPE
2093: ,p_class_category_name IN pa_class_categories.class_category%TYPE
2094: ,p_check_id_flag IN VARCHAR2
2095: ,x_class_category_id OUT NOCOPY pa_class_categories.class_category_id%TYPE --File.Sql.39 bug 4440895
2096: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2097: ,x_error_message_code OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
2098: IS
2099:

Line 2102: FROM pa_class_categories

2098: IS
2099:
2100: CURSOR c_ids IS
2101: SELECT class_category_id
2102: FROM pa_class_categories
2103: WHERE class_category = p_class_category_name;
2104:
2105: l_current_id NUMBER := NULL;
2106: l_num_ids NUMBER := 0;

Line 2118: FROM pa_class_categories

2114:
2115: IF p_check_id_flag = 'Y' THEN
2116: SELECT class_category_id
2117: INTO x_class_category_id
2118: FROM pa_class_categories
2119: WHERE class_category_id = p_class_category_id;
2120:
2121: ELSIF (p_check_id_flag = 'N') then
2122: x_class_category_id := p_class_category_id;

Line 2162: FROM pa_class_categories

2158:
2159: IF (p_class_category_name IS NOT NULL) then
2160: SELECT class_category_id
2161: INTO x_class_category_id
2162: FROM pa_class_categories
2163: WHERE class_category = p_class_category_name;
2164:
2165: ELSE
2166: x_class_category_id := NULL;

Line 2213: FROM pa_class_categories

2209: p_project_id NUMBER) RETURN VARCHAR2
2210: IS
2211: CURSOR C1 IS
2212: SELECT mandatory_flag
2213: FROM pa_class_categories
2214: WHERE class_category = p_class_category;
2215:
2216: CURSOR C2 IS
2217: SELECT ps.project_system_status_code