[Home] [Help]
1175: -- Bug 6156686
1176: CURSOR cur_obj_rel
1177: IS
1178: SELECT NULL
1179: FROM DUAL
1180: WHERE EXISTS
1181: (SELECT NULL
1182: FROM pa_object_relationships por,
1183: pa_proj_element_versions pev,
2542: */
2543:
2544: cursor c1 IS
2545: select 'Y'
2546: from dual
2547: where exists (
2548: select 'xyz'
2549: from PA_PROJ_ELEMENTS
2550: where type_id = p_task_type_id
3440:
3441: -- Bug 6156686
3442: cursor child_exist IS
3443: select null
3444: from dual where exists
3445: (select null from pa_object_relationships
3446: where object_id_from1 = p_element_version_id
3447: and relationship_type = 'S');
3448: BEGIN
4248: and prior relationship_type = relationship_type
4249: start with object_id_to1 = p_element_version_id
4250: and relationship_type = 'S'
4251: union
4252: select p_element_version_id from dual ; --bug 3429648*/
4253:
4254: cursor C1 is
4255: select object_id_to1
4256: from pa_object_relationships
4297: and prior relationship_type = relationship_type
4298: start with object_id_to1 = p_element_version_id
4299: and relationship_type = 'S'
4300: union
4301: select p_element_version_id from dual ); --bug 3429648*/
4302: select object_id_to1
4303: from pa_object_relationships
4304: where relationship_type='S'
4305: and object_type_from='PA_STRUCTURES'
4450:
4451: CURSOR c_is_parent_task
4452: IS
4453: select 1
4454: from dual
4455: where exists
4456: (select 1
4457: from pa_tasks
4458: where nvl(parent_task_id,-9999) = p_proj_element_id
5351: l_dummy := 0;
5352: SELECT
5353: 1 into l_dummy
5354: FROM
5355: sys.dual
5356: WHERE
5357: exists (SELECT NULL
5358: FROM PA_EXPENDITURE_ITEMS_all pei,table(cast(l_task_tbl as sub_task)) st --Changed the query for Bug#4964992
5359: WHERE pei.TASK_ID = st.task_id)
5388: l_dummy := 0;
5389: SELECT
5390: 1 into l_dummy
5391: FROM
5392: sys.dual
5393: WHERE
5394: exists (SELECT NULL
5395: FROM po_distributions_all poa, table(cast(l_task_tbl as sub_task)) st --Changed the query for Bug#4964992
5396: where poa.project_id = p_project_id
5425: l_dummy := 0;
5426: SELECT
5427: 1 into l_dummy
5428: FROM
5429: sys.dual
5430: WHERE
5431: exists (SELECT NULL
5432: FROM po_req_distributions_all prd, table(cast(l_task_tbl as sub_task)) st --Changed the query for Bug#4964992
5433: where prd.project_id = p_project_id
5462: l_dummy := 0;
5463: SELECT
5464: 1 into l_dummy
5465: FROM
5466: sys.dual
5467: WHERE
5468: exists (SELECT NULL
5469: FROM ap_invoices_all aia, table(cast(l_task_tbl as sub_task)) st --Changed the query for Bug#4964992
5470: where aia.project_id = p_project_id
5498: l_dummy := 0;
5499: SELECT
5500: 1 into l_dummy
5501: FROM
5502: sys.dual
5503: WHERE
5504: exists (SELECT NULL
5505: FROM ap_invoice_distributions_all aid, table(cast(l_task_tbl as sub_task)) st --Changed the query for Bug#4964992
5506: where aid.project_id = p_project_id
5534: l_dummy := 0;
5535: SELECT
5536: 1 into l_dummy
5537: FROM
5538: sys.dual
5539: WHERE
5540: exists (SELECT NULL
5541: FROM pa_commitment_txns pct, table(cast(l_task_tbl as sub_task)) st --Changed the query for Bug#4964992
5542: where pct.project_id = p_project_id
5570: l_dummy := 0;
5571: SELECT
5572: 1 into l_dummy
5573: FROM
5574: sys.dual
5575: WHERE
5576: exists (SELECT NULL
5577: FROM pa_comp_rule_ot_defaults_all pcr, table(cast(l_task_tbl as sub_task)) st --Changed the query for Bug#4964992
5578: where pcr.project_id = p_project_id
5610: l_dummy := 0;
5611: SELECT
5612: 1 into l_dummy
5613: FROM
5614: sys.dual
5615: WHERE
5616: exists (SELECT NULL
5617: FROM pa_draft_invoice_details_all pdi, table(cast(l_task_tbl as sub_task)) st --Changed the query for Bug#4964992
5618: where pdi.CC_TAX_TASK_ID =st.task_id);
5645: l_dummy := 0;
5646: SELECT
5647: 1 into l_dummy
5648: FROM
5649: sys.dual
5650: WHERE
5651: exists (SELECT NULL
5652: FROM pa_project_customers pc, table(cast(l_task_tbl as sub_task)) st --Changed the query for Bug#4964992
5653: where pc.project_id = p_project_id
5682: l_dummy := 0;
5683: SELECT
5684: 1 into l_dummy
5685: FROM
5686: sys.dual
5687: WHERE
5688: exists (SELECT NULL
5689: FROM ap_exp_report_dists_all er, table(cast(l_task_tbl as sub_task)) st --Changed the query for Bug#4964992
5690: where er.project_id = p_project_id
5719: l_dummy := 0;
5720: SELECT
5721: 1 into l_dummy
5722: FROM
5723: sys.dual
5724: WHERE
5725: exists (SELECT NULL
5726: FROM mtl_material_transactions mtl, table(cast(l_task_tbl as sub_task)) st --Changed the query for Bug#4964992
5727: where mtl.project_id = p_project_id
5874: p_project_id NUMBER) RETURN VARCHAR2
5875: is
5876: l_dummy number;
5877: cursor child_exist IS
5878: select 1 from dual where exists(
5879: select 1
5880: from pa_object_relationships por, pa_proj_element_versions ppev, pa_proj_elements ppe
5881: where por.object_type_from = 'PA_TASKS'
5882: and por.object_id_from1 = p_task_version_id