[Home] [Help]
220: -- Pre-reqs : None.
221: -- Parameters :
222: -- p_probability_member_id IN pa_probability_members.probability_member_id%TYPE Required
223: -- p_probability_percentage IN pa_probability_members.probability_percentage%TYPE Required
224: -- p_project_type IN pa_projects_all.project_type%TYPE
225: -- p_probability_list_id IN pa_probability_lists.probability_list_id%TYPE
226: -- p_check_id_flag IN VARCHAR2 Required
227: -- x_probability_member_id OUT pa_probability_members.probability_member_id%TYPE Required
228: -- x_return_status OUT VARCHAR2 Required
235: --
236: PROCEDURE CHECK_PROBABILITY_CODE_OR_ID
237: (p_probability_member_id IN pa_probability_members.probability_member_id%TYPE
238: ,p_probability_percentage IN pa_probability_members.probability_percentage%TYPE
239: , p_project_type IN pa_projects_all.project_type%TYPE
240: ,p_probability_list_id IN pa_probability_lists.probability_list_id%TYPE:=NULL
241: ,p_check_id_flag IN VARCHAR2
242: ,x_probability_member_id OUT NOCOPY pa_probability_members.probability_member_id%TYPE --File.Sql.39 bug 4440895
243: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1154: RETURN VARCHAR2 IS
1155: CURSOR l_project_template (c_project_id NUMBER)
1156: IS
1157: SELECT created_from_project_id
1158: FROM PA_PROJECTS_ALL
1159: WHERE project_id = p_project_id;
1160:
1161: CURSOR l_project_option (p_template_id NUMBER, p_option_code VARCHAR2)
1162: IS
1162: IS
1163: SELECT 'x'
1164: FROM PA_OPTIONS OPT1, PA_PROJECT_OPTIONS OPT2
1165: /* Commented for Bug 2499051
1166: , PA_PROJECTS_ALL PROJ
1167: */
1168: WHERE opt1.option_code = opt2.option_code
1169: AND opt1.OPTION_FUNCTION_NAME = p_option_code
1170: AND opt2.project_id = p_template_id;
1395: CURSOR C2(c_object_id NUMBER, c_class_category VARCHAR2)
1396: IS
1397: SELECT 1
1398: FROM PA_VALID_CATEGORIES vc,
1399: PA_PROJECTS_ALL ppa,
1400: PA_PROJECT_TYPES_ALL ppta
1401: WHERE vc.mandatory_flag = 'Y'
1402: AND vc.class_category = c_class_category
1403: AND ppa.project_id = p_object_id
1674: CURSOR C2
1675: IS
1676: SELECT total_100_percent_flag
1677: FROM PA_VALID_CATEGORIES_V vc,
1678: PA_PROJECTS_ALL ppa,
1679: PA_PROJECT_TYPES_ALL ppta
1680: WHERE ppa.project_id = p_object_id
1681: AND ppa.project_type = ppta.project_type
1682: AND nvl(ppa.org_id, -99) = nvl(ppta.org_id, -99)
1746: CURSOR C1
1747: IS
1748: SELECT ppta.project_type_id
1749: FROM PA_PROJECT_TYPES_ALL ppta,
1750: PA_PROJECTS_ALL ppa
1751: WHERE ppa.project_id = p_object_id
1752: AND ppa.project_type = ppta.project_type
1753: AND ppa.org_id = ppta.org_id; --MOAC Changes: Bug 4363092: removed nvl usage with org_id
1754:
1865:
1866: cursor template_csr
1867: IS
1868: SELECT template_flag
1869: FROM pa_projects_all
1870: WHERE project_id = p_project_id;
1871:
1872: cursor org_csr
1873: IS
1871:
1872: cursor org_csr
1873: IS
1874: SELECT carrying_out_organization_id
1875: FROM PA_PROJECTS_ALL
1876: WHERE project_id = p_project_id;
1877:
1878: l_cdl_exist NUMBER;
1879: l_template_flag VARCHAR2(1);
1945: RETURN VARCHAR2
1946: IS
1947: CURSOR C1 IS
1948: SELECT probability_member_id, expected_approval_date
1949: FROM PA_PROJECTS_ALL
1950: WHERE project_id = p_project_id;
1951:
1952: l_probability_member_id NUMBER;
1953: l_expected_approval_date DATE;
2227: WHERE class_category = p_class_category;
2228:
2229: CURSOR C2 IS
2230: SELECT ps.project_system_status_code
2231: FROM pa_project_statuses ps, pa_projects_all pp
2232: WHERE pp.project_id = p_project_id
2233: AND pp.project_status_code = ps.project_status_code;
2234:
2235: /* added cursor c3 for bug 2784433 */
2240: AND EXISTS (SELECT 'X'
2241: FROM pa_project_types_all pta
2242: WHERE pta.project_type_id = pvc.object_type_id
2243: AND EXISTS (SELECT 'X'
2244: FROM pa_projects_all ppa
2245: WHERE pta.project_type = ppa.project_type
2246: AND project_id = p_project_id));
2247:
2248: x_mandatory_flag VARCHAR2(1);