[Home] [Help]
1177: -- Bug 6156686
1178: CURSOR cur_obj_rel
1179: IS
1180: SELECT NULL
1181: FROM DUAL
1182: WHERE EXISTS
1183: (SELECT NULL
1184: FROM pa_object_relationships por,
1185: pa_proj_element_versions pev,
1201: -- workplan and financial structure, but some tasks are not marked for financial structure
1202: CURSOR cur_obj_rel_fin
1203: IS
1204: SELECT NULL
1205: FROM DUAL
1206: WHERE EXISTS
1207: (SELECT NULL
1208: FROM pa_object_relationships por,
1209: pa_proj_element_versions pev,
2635: */
2636:
2637: cursor c1 IS
2638: select 'Y'
2639: from dual
2640: where exists (
2641: select 'xyz'
2642: from PA_PROJ_ELEMENTS
2643: where type_id = p_task_type_id
3533:
3534: -- Bug 6156686
3535: cursor child_exist IS
3536: select null
3537: from dual where exists
3538: (select null from pa_object_relationships
3539: where object_id_from1 = p_element_version_id
3540: and relationship_type = 'S');
3541: BEGIN
4341: and prior relationship_type = relationship_type
4342: start with object_id_to1 = p_element_version_id
4343: and relationship_type = 'S'
4344: union
4345: select p_element_version_id from dual ; --bug 3429648*/
4346:
4347: cursor C1 is
4348: select object_id_to1
4349: from pa_object_relationships
4390: and prior relationship_type = relationship_type
4391: start with object_id_to1 = p_element_version_id
4392: and relationship_type = 'S'
4393: union
4394: select p_element_version_id from dual ); --bug 3429648*/
4395: select object_id_to1
4396: from pa_object_relationships
4397: where relationship_type='S'
4398: and object_type_from='PA_STRUCTURES'
4543:
4544: CURSOR c_is_parent_task
4545: IS
4546: select 1
4547: from dual
4548: where exists
4549: (select 1
4550: from pa_tasks
4551: where nvl(parent_task_id,-9999) = p_proj_element_id
5493: IF l_Cbs_Enabled = 'Y' THEN -- CBS enhancement bug#16461684
5494: SELECT
5495: 1 into l_dummy
5496: FROM
5497: sys.dual
5498: WHERE
5499: exists (SELECT NULL
5500: FROM PA_EXPENDITURE_ITEMS_all pei,table(cast(l_alt_task_tbl as sub_task)) st --Changed the query for Bug#4964992
5501: WHERE pei.TASK_ID = st.task_id)
5505: ELSE */
5506: SELECT
5507: 1 into l_dummy
5508: FROM
5509: sys.dual
5510: WHERE
5511: exists (SELECT NULL
5512: FROM PA_EXPENDITURE_ITEMS_all pei,table(cast(l_task_tbl as sub_task)) st --Changed the query for Bug#4964992
5513: WHERE pei.TASK_ID = st.task_id)
5549: END IF;
5550: SELECT
5551: 1 into l_dummy
5552: FROM
5553: sys.dual
5554: WHERE
5555: exists (SELECT NULL
5556: FROM po_distributions_all poa, table(cast(l_task_tbl as sub_task)) st --Changed the query for Bug#4964992
5557: where poa.project_id = p_project_id
5591: END IF;
5592: SELECT
5593: 1 into l_dummy
5594: FROM
5595: sys.dual
5596: WHERE
5597: exists (SELECT NULL
5598: FROM po_req_distributions_all prd, table(cast(l_task_tbl as sub_task)) st --Changed the query for Bug#4964992
5599: where prd.project_id = p_project_id
5633: END IF;
5634: SELECT
5635: 1 into l_dummy
5636: FROM
5637: sys.dual
5638: WHERE
5639: exists (SELECT NULL
5640: FROM ap_invoices_all aia, table(cast(l_task_tbl as sub_task)) st --Changed the query for Bug#4964992
5641: where aia.project_id = p_project_id
5674: END IF;
5675: SELECT
5676: 1 into l_dummy
5677: FROM
5678: sys.dual
5679: WHERE
5680: exists (SELECT NULL
5681: FROM ap_invoice_distributions_all aid, table(cast(l_task_tbl as sub_task)) st --Changed the query for Bug#4964992
5682: where aid.project_id = p_project_id
5712: l_task_tbl := l_tmp_task_tbl;
5713: SELECT
5714: 1 into l_dummy
5715: FROM
5716: sys.dual
5717: WHERE
5718: exists (SELECT NULL
5719: FROM pa_commitment_txns pct, table(cast(l_task_tbl as sub_task)) st --Changed the query for Bug#4964992
5720: where pct.project_id = p_project_id
5750: l_task_tbl := l_tmp_task_tbl;
5751: SELECT
5752: 1 into l_dummy
5753: FROM
5754: sys.dual
5755: WHERE
5756: exists (SELECT NULL
5757: FROM pa_comp_rule_ot_defaults_all pcr, table(cast(l_task_tbl as sub_task)) st --Changed the query for Bug#4964992
5758: where pcr.project_id = p_project_id
5795: END IF;
5796: SELECT
5797: 1 into l_dummy
5798: FROM
5799: sys.dual
5800: WHERE
5801: exists (SELECT NULL
5802: FROM pa_draft_invoice_details_all pdi, table(cast(l_task_tbl as sub_task)) st --Changed the query for Bug#4964992
5803: where pdi.CC_TAX_TASK_ID =st.task_id
5833: l_task_tbl := l_tmp_task_tbl;
5834: SELECT
5835: 1 into l_dummy
5836: FROM
5837: sys.dual
5838: WHERE
5839: exists (SELECT NULL
5840: FROM pa_project_customers pc, table(cast(l_task_tbl as sub_task)) st --Changed the query for Bug#4964992
5841: where /*pc.project_id = p_project_id and */ -- commented for bug 8485835 */
5875: END IF;
5876: SELECT
5877: 1 into l_dummy
5878: FROM
5879: sys.dual
5880: WHERE
5881: exists (SELECT NULL
5882: FROM ap_exp_report_dists_all er, table(cast(l_task_tbl as sub_task)) st --Changed the query for Bug#4964992
5883: where er.project_id = p_project_id
5917: END IF;
5918: SELECT
5919: 1 into l_dummy
5920: FROM
5921: sys.dual
5922: WHERE
5923: exists (SELECT NULL
5924: FROM mtl_material_transactions mtl, table(cast(l_task_tbl as sub_task)) st --Changed the query for Bug#4964992
5925: where mtl.project_id = p_project_id
6136: p_project_id NUMBER) RETURN VARCHAR2
6137: is
6138: l_dummy number;
6139: cursor child_exist IS
6140: select 1 from dual where exists(
6141: select 1
6142: from pa_object_relationships por, pa_proj_element_versions ppev, pa_proj_elements ppe
6143: where por.object_type_from = 'PA_TASKS'
6144: and por.object_id_from1 = p_task_version_id