APPS.PA_PROJECT_PUB dependencies on PA_PROJECT_CLASSES

Line 9674: FROM pa_project_classes

9670: CURSOR l_class_categories_csr (l_project_id NUMBER,
9671: l_class_category VARCHAR2 )
9672: IS
9673: SELECT class_code
9674: FROM pa_project_classes
9675: WHERE project_id = l_project_id
9676: AND class_category = l_class_category;
9677:
9678: CURSOR l_get_task_csr (l_project_id NUMBER,l_pm_task_reference VARCHAR2) IS

Line 10275: FROM pa_project_classes

10271: l_class_category VARCHAR2,
10272: l_class_code VARCHAR2 )
10273: IS
10274: SELECT code_percentage
10275: FROM pa_project_classes
10276: WHERE project_id = l_project_id
10277: AND class_category = l_class_category
10278: AND class_code = l_class_code;
10279:

Line 10280: TYPE class_code_tbl_type IS TABLE OF pa_project_classes.class_code%type

10276: WHERE project_id = l_project_id
10277: AND class_category = l_class_category
10278: AND class_code = l_class_code;
10279:
10280: TYPE class_code_tbl_type IS TABLE OF pa_project_classes.class_code%type
10281: INDEX BY BINARY_INTEGER;
10282:
10283: class_code_tbl class_code_tbl_type;
10284: l_code_percentage pa_project_classes.code_percentage%type;

Line 10284: l_code_percentage pa_project_classes.code_percentage%type;

10280: TYPE class_code_tbl_type IS TABLE OF pa_project_classes.class_code%type
10281: INDEX BY BINARY_INTEGER;
10282:
10283: class_code_tbl class_code_tbl_type;
10284: l_code_percentage pa_project_classes.code_percentage%type;
10285:
10286: -- END of Addition for bug 4191009.
10287:
10288: -- 5348726 :: Start of Addition for bug#5294891.

Line 18914: DELETE FROM pa_project_classes

18910: if (p_class_categories(i).new_class_code <>
18911: PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ) AND
18912: (p_class_categories(i).new_class_code IS NOT NULL ) THEN -- 5348726 Added for bug#5294891
18913: --remove the old class_code
18914: DELETE FROM pa_project_classes
18915: WHERE project_id = l_project_id
18916: AND class_category = p_class_categories(i).class_category
18917: AND class_code = p_class_categories(i).class_code;
18918:

Line 18973: DELETE FROM pa_project_classes

18969: If l_code_percentage = p_class_categories(i).code_percentage then
18970: Null;
18971: Else
18972: --remove the old class_code
18973: DELETE FROM pa_project_classes
18974: WHERE project_id = l_project_id
18975: AND class_category = p_class_categories(i).class_category
18976: AND class_code = p_class_categories(i).class_code;
18977: --and add the new values to the temp table

Line 19007: DELETE FROM pa_project_classes

19003: --if new value for class_code is same as old do nothing
19004: NULL;
19005: ELSE
19006: --remove the old class_code
19007: DELETE FROM pa_project_classes
19008: WHERE project_id = l_project_id
19009: AND class_category = p_class_categories(i).class_category
19010: AND class_code = l_class_code;
19011: --and add the new value for class_code to the temp table