[Home] [Help]
269: ,ps.project_system_status_code system_status_code
270: ,cit.ci_type_class_code ci_type_class
271: ,cit.approval_required_flag approval_required_flag
272: from pa_control_items ci
273: ,pa_ci_types_b cit
274: ,pa_project_statuses ps
275: where ci.ci_id = p_ci_id
276: and ci.ci_type_id = cit.ci_type_id
277: and ci.status_code = ps.project_status_code;
831:
832: CURSOR get_control_item_type
833: IS
834: SELECT pl.meaning,pl.lookup_code
835: FROM pa_lookups pl, pa_control_items pci, pa_ci_types_b pcit
836: WHERE
837: pl.lookup_type = 'PA_CI_TYPE_CLASSES'
838: and pci.ci_type_id = pcit.ci_type_id
839: and pl.lookup_code = pcit.ci_type_class_code
1165: end if;
1166:
1167: SELECT ci_type_class_code, approval_required_flag
1168: INTO l_type, l_approval_required
1169: FROM pa_ci_types_b cit,
1170: pa_control_items ci
1171: WHERE ci.ci_id = p_ci_id
1172: and cit.ci_type_id = ci.ci_type_id;
1173:
1201: end if;
1202:
1203: select
1204: resolution_required_flag into l_resolution_required
1205: from pa_ci_types_b cit
1206: ,pa_control_items ci
1207: where ci.ci_id = p_ci_id
1208: and cit.ci_type_id = ci.ci_type_id;
1209:
1220: is
1221: cursor get_resolution_info is
1222: select
1223: resolution_required_flag, resolution_code_id, resolution
1224: from pa_ci_types_b cit
1225: ,pa_control_items ci
1226: where ci.ci_id = p_ci_id
1227: and cit.ci_type_id = ci.ci_type_id;
1228:
1259: end if;
1260:
1261: select
1262: ci_type_class_code into l_type_class_code
1263: from pa_ci_types_b cit
1264: ,pa_control_items ci
1265: where ci.ci_id = p_ci_id
1266: and cit.ci_type_id = ci.ci_type_id;
1267:
1507: tmp NUMBER;
1508: BEGIN
1509: SELECT 1
1510: INTO tmp
1511: FROM pa_ci_types_b
1512: WHERE ( classification_category = p_class_category
1513: OR reason_category = p_class_category
1514: OR resolution_category = p_class_category)
1515: AND ROWNUM = 1;
1551: tmp NUMBER;
1552: BEGIN
1553: SELECT 1
1554: INTO tmp
1555: FROM pa_ci_types_b cit,
1556: pa_object_dist_lists odl,
1557: pa_dist_list_items dli
1558: WHERE odl.object_type = 'PA_CI_TYPES'
1559: AND odl.object_id = cit.ci_type_id
1713: merged the similar select for change order/request/issue using the bind variable p_item_type*/
1714: if (p_item_type = 'ISSUE' or p_item_type = 'CHANGE_ORDER' or p_item_type = 'CHANGE_REQUEST') then
1715: select count(*)
1716: into tot_num
1717: from pa_control_items pci, pa_ci_types_b pctb
1718: where pci.project_id = p_project_id
1719: and pci.object_type = p_object_type
1720: and pci.object_id = p_object_id
1721: and pci.ci_type_id = pctb.ci_type_id
1728:
1729: elsif (p_item_type = 'CHANGE') then
1730: select count(*)
1731: into tot_num
1732: from pa_control_items pci, pa_ci_types_b pctb
1733: where pci.project_id = p_project_id
1734: and pci.object_type = p_object_type
1735: and pci.object_id = p_object_id
1736: and pci.ci_type_id = pctb.ci_type_id
1743:
1744: -- elsif (p_item_type = 'CHANGE_ORDER') then
1745: -- select count(*)
1746: -- into tot_num
1747: -- from pa_control_items pci, pa_ci_types_b pctb
1748: -- where pci.project_id = p_project_id
1749: -- and pci.object_type = p_object_type
1750: -- and pci.object_id = p_object_id
1751: -- and pci.ci_type_id = pctb.ci_type_id
1758:
1759: -- elsif (p_item_type = 'CHANGE_REQUEST') then
1760: -- select count(*)
1761: -- into tot_num
1762: -- from pa_control_items pci, pa_ci_types_b pctb
1763: -- where pci.project_id = p_project_id
1764: -- and pci.object_type = p_object_type
1765: -- and pci.object_id = p_object_id
1766: -- and pci.ci_type_id = pctb.ci_type_id
2119:
2120: CURSOR get_control_item_type
2121: IS
2122: SELECT pl.meaning,pl.lookup_code
2123: FROM pa_lookups pl, pa_control_items pci, pa_ci_types_b pcit
2124: WHERE
2125: pl.lookup_type = 'PA_CI_TYPE_CLASSES'
2126: and pci.ci_type_id = pcit.ci_type_id
2127: and pl.lookup_code = pcit.ci_type_class_code