[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
1141: RETURN VARCHAR2 IS
1142: CURSOR l_project_template (c_project_id NUMBER)
1143: IS
1144: SELECT created_from_project_id
1145: FROM PA_PROJECTS_ALL
1146: WHERE project_id = p_project_id;
1147:
1148: CURSOR l_project_option (p_template_id NUMBER, p_option_code VARCHAR2)
1149: IS
1149: IS
1150: SELECT 'x'
1151: FROM PA_OPTIONS OPT1, PA_PROJECT_OPTIONS OPT2
1152: /* Commented for Bug 2499051
1153: , PA_PROJECTS_ALL PROJ
1154: */
1155: WHERE opt1.option_code = opt2.option_code
1156: AND opt1.OPTION_FUNCTION_NAME = p_option_code
1157: AND opt2.project_id = p_template_id;
1382: CURSOR C2(c_object_id NUMBER, c_class_category VARCHAR2)
1383: IS
1384: SELECT 1
1385: FROM PA_VALID_CATEGORIES vc,
1386: PA_PROJECTS_ALL ppa,
1387: PA_PROJECT_TYPES_ALL ppta
1388: WHERE vc.mandatory_flag = 'Y'
1389: AND vc.class_category = c_class_category
1390: AND ppa.project_id = p_object_id
1661: CURSOR C2
1662: IS
1663: SELECT total_100_percent_flag
1664: FROM PA_VALID_CATEGORIES_V vc,
1665: PA_PROJECTS_ALL ppa,
1666: PA_PROJECT_TYPES_ALL ppta
1667: WHERE ppa.project_id = p_object_id
1668: AND ppa.project_type = ppta.project_type
1669: AND nvl(ppa.org_id, -99) = nvl(ppta.org_id, -99)
1733: CURSOR C1
1734: IS
1735: SELECT ppta.project_type_id
1736: FROM PA_PROJECT_TYPES_ALL ppta,
1737: PA_PROJECTS_ALL ppa
1738: WHERE ppa.project_id = p_object_id
1739: AND ppa.project_type = ppta.project_type
1740: AND ppa.org_id = ppta.org_id; --MOAC Changes: Bug 4363092: removed nvl usage with org_id
1741:
1852:
1853: cursor template_csr
1854: IS
1855: SELECT template_flag
1856: FROM pa_projects_all
1857: WHERE project_id = p_project_id;
1858:
1859: cursor org_csr
1860: IS
1858:
1859: cursor org_csr
1860: IS
1861: SELECT carrying_out_organization_id
1862: FROM PA_PROJECTS_ALL
1863: WHERE project_id = p_project_id;
1864:
1865: l_cdl_exist NUMBER;
1866: l_template_flag VARCHAR2(1);
1932: RETURN VARCHAR2
1933: IS
1934: CURSOR C1 IS
1935: SELECT probability_member_id, expected_approval_date
1936: FROM PA_PROJECTS_ALL
1937: WHERE project_id = p_project_id;
1938:
1939: l_probability_member_id NUMBER;
1940: l_expected_approval_date DATE;
2214: WHERE class_category = p_class_category;
2215:
2216: CURSOR C2 IS
2217: SELECT ps.project_system_status_code
2218: FROM pa_project_statuses ps, pa_projects_all pp
2219: WHERE pp.project_id = p_project_id
2220: AND pp.project_status_code = ps.project_status_code;
2221:
2222: /* added cursor c3 for bug 2784433 */
2227: AND EXISTS (SELECT 'X'
2228: FROM pa_project_types_all pta
2229: WHERE pta.project_type_id = pvc.object_type_id
2230: AND EXISTS (SELECT 'X'
2231: FROM pa_projects_all ppa
2232: WHERE pta.project_type = ppa.project_type
2233: AND project_id = p_project_id));
2234:
2235: x_mandatory_flag VARCHAR2(1);