[Home] [Help]
77: --it means that it is in use.
78:
79: CURSOR c_dlv_type_in_use IS
80: SELECT 'X'
81: FROM DUAL
82: WHERE EXISTS (SELECT 'X'
83: FROM PA_PROJ_ELEMENTS
84: WHERE TYPE_ID = p_deliverable_type_id
85: AND OBJECT_TYPE='PA_DELIVERABLES');
127: --Note : The relationship is defined by the relationship_type 'A'
128:
129: CURSOR c_dlv_type_action_exists IS
130: SELECT 'X'
131: FROM DUAL
132: WHERE EXISTS (SELECT 'X'
133: FROM PA_OBJECT_RELATIONSHIPS obj
134: WHERE obj.object_id_from2 = p_deliverable_type_id
135: AND obj.object_type_from = 'PA_DLVR_TYPES'
184: --Note : The relationship is defined by the relationship_type 'A'
185:
186: CURSOR c_dlv_action_exists IS
187: SELECT 'X'
188: FROM DUAL
189: WHERE EXISTS (SELECT 'X'
190: FROM PA_OBJECT_RELATIONSHIPS obj,
191: PA_PROJ_ELEMENTS ppe
192: where ppe.type_id = p_deliverable_type_id
248: --Note : The relationship is defined by the relationship_type 'A'
249:
250: CURSOR c_dlv_based_task_exists IS
251: SELECT 'X'
252: FROM DUAL
253: WHERE EXISTS (SELECT 'X'
254: FROM PA_OBJECT_RELATIONSHIPS obj,
255: PA_PROJ_ELEMENTS ppe1,
256: PA_PROJ_ELEMENTS ppe2
434: IS
435:
436: CURSOR ship_procure_flag_dlv IS
437: SELECT 'Y'
438: FROM dual
439: WHERE EXISTS ( SELECT 'Y'
440: FROM pa_object_relationships obj
441: ,pa_proj_element_versions ver
442: WHERE obj.object_id_from2 = p_dlvr_item_id
545: IS
546: l_task_assignment_exists VARCHAR2(1) := 'N' ;
547: CURSOR C IS
548: SELECT 'Y'
549: FROM dual
550: WHERE EXISTS (SELECT 'X'
551: from pa_object_relationships
552: where object_id_to2 = p_dlvr_item_id
553: and object_type_from = 'PA_ASSIGNMENTS'
598: -- been initiated or billing action exists
599:
600: CURSOR c_ship_procure_flag_dlv IS
601: SELECT 'Y'
602: FROM dual
603: WHERE EXISTS ( SELECT 'Y'
604: FROM pa_object_relationships obj
605: ,pa_proj_element_versions ver
606: WHERE obj.object_id_from2 = p_dlvr_item_id
628: --the deliverable's status to completed .So,if this cursor returns 'Y' then status change to COMPLETED should not be allowed
629:
630: CURSOR c_complete_dlv_check IS
631: SELECT 'Y'
632: FROM dual
633: WHERE EXISTS ( SELECT 'Y'
634: FROM pa_object_relationships obj
635: ,pa_proj_element_versions ver
636: WHERE
657:
658: -- Bug 3512346 CHECK_DELV_EVENT_PROCESSED API was uncommented by avaithia on 01-Apr-2004 (Also,Included Project Id,ElementVerId as params)
659: CURSOR c_complete_dlv_bill_check IS
660: SELECT 'Y'
661: FROM dual
662: WHERE EXISTS ( SELECT 'Y'
663: FROM pa_object_relationships obj
664: ,pa_proj_element_versions ver
665: WHERE
891: IS
892: SELECT
893: 'Y'
894: FROM
895: DUAL
896: WHERE EXISTS
897: (
898: SELECT
899: 'Y'
1234:
1235: SELECT
1236: 'Y' into x_actions_exists
1237: FROM
1238: DUAL
1239: WHERE
1240: EXISTS
1241: (
1242: SELECT
1294:
1295: SELECT
1296: 'Y' into x_biling_function_exists
1297: FROM
1298: DUAL
1299: WHERE
1300: EXISTS
1301: (
1302: SELECT
2183: l_return_status VARCHAR2(1) := 'N' ;
2184: -- Bug: 3902158 - Changing Cursor query to avoid call to function PA_DELIVERABLE_UTILS.GET_PROGRESS_ROLLUP_METHOD
2185: /*CURSOR c_dlv_based_task_exists IS
2186: SELECT 'X'
2187: FROM DUAL
2188: WHERE EXISTS (SELECT 'X'
2189: FROM PA_OBJECT_RELATIONSHIPS obj,
2190: PA_PROJ_ELEMENTS ppe
2191: where ppe.proj_element_id = p_dlv_element_id
2199: ); */
2200:
2201: CURSOR c_dlv_based_task_exists IS
2202: SELECT 'X'
2203: FROM DUAL
2204: WHERE EXISTS (SELECT 'X'
2205: FROM PA_OBJECT_RELATIONSHIPS obj,
2206: pa_proj_elements ppe,
2207: pa_task_types ptt
2237: ) RETURN VARCHAR2
2238: IS
2239: CURSOR ship_flag_dlv IS
2240: SELECT 'Y'
2241: FROM dual
2242: WHERE EXISTS ( SELECT 'Y'
2243: FROM pa_object_relationships obj
2244: ,pa_proj_element_versions ver
2245: WHERE obj.object_id_from2 = p_dlv_element_id
2271: ) RETURN VARCHAR2
2272: IS
2273: CURSOR proc_flag_dlv IS
2274: SELECT 'Y'
2275: FROM dual
2276: WHERE EXISTS ( SELECT 'Y'
2277: FROM pa_object_relationships obj
2278: ,pa_proj_element_versions ver
2279: WHERE obj.object_id_from2 = p_dlv_element_id
2307: ) RETURN VARCHAR2
2308: IS
2309: CURSOR c_prog_enabled_dlv_exists IS
2310: SELECT 'Y'
2311: FROM dual
2312: WHERE EXISTS ( SELECT 'Y'
2313: FROM pa_object_relationships obj
2314: ,pa_proj_elements ppe
2315: ,pa_task_types ptt
2505: ) RETURN VARCHAR2
2506: IS
2507: CURSOR c_is_dlv_item_based IS
2508: SELECT 'Y'
2509: FROM dual
2510: WHERE EXISTS (SELECT 'Y'
2511: FROM pa_proj_elements ppe
2512: ,pa_object_relationships obj
2513: ,pa_proj_element_versions pev
2670:
2671: /* Bug 3597178 This cursor is no more needed
2672: As we dont need to check for existence of association b/w deliverable and deliverable based tasks for that project
2673: CURSOR cur_tsk_assoc IS
2674: SELECT 1 FROM dual
2675: WHERE EXISTS(
2676: SELECT ppe.proj_element_id DlvrElemId, ppev.element_version_id DlvrElemVerId
2677: FROM pa_proj_elements ppe,
2678: pa_proj_element_versions ppev
2685: );
2686: */
2687:
2688: CURSOR cur_dlvr_progress IS
2689: SELECT 1 FROM dual
2690: WHERE EXISTS(
2691: SELECT 1
2692: FROM pa_proj_elements ppe
2693: WHERE ppe.project_id = p_project_id
2695: AND 'Y' = PA_DELIVERABLE_UTILS.IS_DELIVERABLE_HAS_PROGRESS(p_project_id,ppe.proj_element_id)
2696: );
2697: /* Commented the following SELECT statement for Performance Bug Fix 3614361 */
2698: /*
2699: SELECT 1 FROM dual
2700: WHERE EXISTS(
2701: SELECT ppe.proj_element_id DlvrElemId, ppev.element_version_id DlvrElemVerId
2702: FROM pa_proj_elements ppe,
2703: pa_proj_element_versions ppev
2707: );
2708: */
2709:
2710: CURSOR cur_ship_or_proc IS
2711: SELECT 1 FROM dual
2712: WHERE EXISTS(
2713: SELECT ppe.proj_element_id DlvrElemId, ppev.element_version_id DlvrElemVerId
2714: FROM pa_proj_elements ppe,
2715: pa_proj_element_versions ppev
2722: OR 'Y' = PA_DELIVERABLE_UTILS.GET_READY_TO_PROC_FLAG(ppe.proj_element_id,ppev.element_version_id) )
2723: );
2724:
2725: CURSOR cur_billing_fn IS
2726: SELECT 1 FROM dual
2727: WHERE EXISTS(
2728: SELECT 1
2729: FROM pa_proj_elements ppe
2730: WHERE ppe.project_id = p_project_id
2869: )
2870: IS
2871:
2872: CURSOR cur_check_cancel_possible IS
2873: SELECT 1 FROM dual
2874: WHERE EXISTS(
2875: SELECT 1
2876: FROM pa_proj_elements ppe,
2877: pa_proj_element_versions ppv,
3003: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3004: )
3005: IS
3006: CURSOR cur_check_transaction_init IS
3007: SELECT 1 FROM dual
3008: WHERE EXISTS(
3009: SELECT 1
3010: FROM pa_proj_elements ppe,
3011: pa_proj_element_versions ppv,
3109: )
3110: IS
3111: /* Commented this Cursor as It is not used anywhere
3112: CURSOR cur_assoc_dlvr_has_prog IS
3113: SELECT 1 FROM dual
3114: WHERE EXISTS(
3115: SELECT ppe.proj_element_id
3116: FROM pa_proj_elements ppe,
3117: pa_object_relationships obj
3125: );
3126: */
3127:
3128: CURSOR cur_dlvr_assoc_exists IS
3129: SELECT 1 FROM dual
3130: WHERE EXISTS(
3131: SELECT 1
3132: FROM pa_proj_elements ppe,
3133: pa_object_relationships obj,
3228: )
3229: RETURN VARCHAR2 IS
3230:
3231: CURSOR cur_proj_txn_exists IS
3232: SELECT 'Y' FROM dual
3233: WHERE EXISTS(
3234: SELECT 1
3235: FROM pa_proj_elements ppe,
3236: pa_proj_elements ppe2,
3559:
3560: FUNCTION IS_ITEM_BASED_DLV_EXISTS RETURN VARCHAR2
3561: IS
3562: CURSOR C IS
3563: SELECT 'Y' FROM DUAL
3564: WHERE EXISTS(SELECT 'Y'
3565: FROM pa_proj_elements ppe,
3566: pa_task_types ptt
3567: WHERE ppe.object_type = 'PA_DELIVERABLES'
3584: RETURN VARCHAR2
3585: IS
3586: CURSOR C IS
3587: SELECT 'Y'
3588: FROM DUAL
3589: WHERE EXISTS (Select 'Y'
3590: from pa_proj_elements ppe,
3591: pa_proj_element_versions pev
3592: where pev.element_version_id = p_action_version_id
5300: l_dummy varchar2(1):='N';
5301:
5302: CURSOR c_task_dlvs IS
5303: SELECT 'Y'
5304: FROM dual
5305: WHERE exists
5306: (Select 'xyz'
5307: from pa_object_relationships
5308: where object_id_from2 = p_str_task_id
5497: ) RETURN VARCHAR2
5498: IS
5499: CURSOR dlv_based_task IS
5500: SELECT 'Y'
5501: FROM dual
5502: WHERE EXISTS ( SELECT 'Y'
5503: FROM pa_proj_elements
5504: WHERE base_percent_comp_deriv_code = 'DELIVERABLE'
5505: AND object_type = 'PA_TASKS'
5519: ) RETURN VARCHAR2
5520: IS
5521: CURSOR is_dlv_exists IS
5522: SELECT 'Y'
5523: FROM dual
5524: WHERE EXISTS ( SELECT 'Y'
5525: FROM pa_proj_elements
5526: WHERE object_type = 'PA_DELIVERABLES'
5527: AND project_id = p_project_id);
5850: ) RETURN VARCHAR2
5851: IS
5852: CURSOR ship_flag_dlv IS
5853: SELECT 'Y'
5854: FROM dual
5855: WHERE EXISTS ( SELECT 'Y'
5856: FROM pa_object_relationships obj
5857: ,pa_proj_element_versions ver
5858: WHERE obj.object_id_from2 = p_dlv_element_id
5896: ) RETURN VARCHAR2
5897: IS
5898: CURSOR proc_flag_dlv IS
5899: SELECT 'Y'
5900: FROM dual
5901: WHERE EXISTS ( SELECT 'Y'
5902: FROM pa_object_relationships obj
5903: ,pa_proj_element_versions ver
5904: WHERE obj.object_id_from2 = p_dlv_element_id
5942: ) RETURN VARCHAR2
5943: IS
5944: CURSOR bill_flag_dlv IS
5945: SELECT 'Y'
5946: FROM dual
5947: WHERE EXISTS ( SELECT 'Y'
5948: FROM pa_object_relationships obj
5949: ,pa_proj_element_versions ver
5950: WHERE obj.object_id_from2 = p_dlv_element_id