APPS.PA_PROJECT_PUB dependencies on PA_PROJECT_CLASSES

Line 9926: FROM pa_project_classes

9922: CURSOR l_class_categories_csr (l_project_id NUMBER,
9923: l_class_category VARCHAR2 )
9924: IS
9925: SELECT class_code
9926: FROM pa_project_classes
9927: WHERE project_id = l_project_id
9928: AND class_category = l_class_category;
9929:
9930: CURSOR l_get_task_csr (l_project_id NUMBER,l_pm_task_reference VARCHAR2) IS

Line 10537: FROM pa_project_classes

10533: l_class_category VARCHAR2,
10534: l_class_code VARCHAR2 )
10535: IS
10536: SELECT code_percentage
10537: FROM pa_project_classes
10538: WHERE project_id = l_project_id
10539: AND class_category = l_class_category
10540: AND class_code = l_class_code;
10541:

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

10538: WHERE project_id = l_project_id
10539: AND class_category = l_class_category
10540: AND class_code = l_class_code;
10541:
10542: TYPE class_code_tbl_type IS TABLE OF pa_project_classes.class_code%type
10543: INDEX BY BINARY_INTEGER;
10544:
10545: class_code_tbl class_code_tbl_type;
10546: l_code_percentage pa_project_classes.code_percentage%type;

Line 10546: l_code_percentage pa_project_classes.code_percentage%type;

10542: TYPE class_code_tbl_type IS TABLE OF pa_project_classes.class_code%type
10543: INDEX BY BINARY_INTEGER;
10544:
10545: class_code_tbl class_code_tbl_type;
10546: l_code_percentage pa_project_classes.code_percentage%type;
10547:
10548: -- END of Addition for bug 4191009.
10549:
10550: -- 5348726 :: Start of Addition for bug#5294891.

Line 19312: DELETE FROM pa_project_classes

19308: if (p_class_categories(i).new_class_code <>
19309: PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ) AND
19310: (p_class_categories(i).new_class_code IS NOT NULL ) THEN -- 5348726 Added for bug#5294891
19311: --remove the old class_code
19312: DELETE FROM pa_project_classes
19313: WHERE project_id = l_project_id
19314: AND class_category = p_class_categories(i).class_category
19315: AND class_code = p_class_categories(i).class_code;
19316:

Line 19371: DELETE FROM pa_project_classes

19367: If l_code_percentage = p_class_categories(i).code_percentage then
19368: Null;
19369: Else
19370: --remove the old class_code
19371: DELETE FROM pa_project_classes
19372: WHERE project_id = l_project_id
19373: AND class_category = p_class_categories(i).class_category
19374: AND class_code = p_class_categories(i).class_code;
19375: --and add the new values to the temp table

Line 19405: DELETE FROM pa_project_classes

19401: --if new value for class_code is same as old do nothing
19402: NULL;
19403: ELSE
19404: --remove the old class_code
19405: DELETE FROM pa_project_classes
19406: WHERE project_id = l_project_id
19407: AND class_category = p_class_categories(i).class_category
19408: AND class_code = l_class_code;
19409: --and add the new value for class_code to the temp table