eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PROJ_ELEMENTS_UTILS dependencies on SUB_TASK

Line 3038: --do not allow sub-tasks creation if the lowest level task has progress.

3034: END IF;
3035: END IF;
3036: END IF;
3037: --bug 3947726
3038: --do not allow sub-tasks creation if the lowest level task has progress.
3039: --This is also applicable for shared case if the task has only ETC but not actual. If actual is there then it means it will be stopped in expenditure items validation.
3040: IF pa_proj_task_struc_pub.wp_str_exists(l_project_id) = 'Y'
3041: AND pa_task_assignment_utils.get_task_level_record( l_project_id, p_parent_task_ver_id ) IS NOT NULL
3042: AND PA_PROGRESS_UTILS.check_object_has_prog(

Line 5056: function GET_SUB_TASK_VERSION_ID(p_task_version_id IN number) return number

5052: RETURN l_ret_code ;
5053: END CHECK_USER_VIEW_TASK_PRIVILEGE;
5054: --
5055: --
5056: function GET_SUB_TASK_VERSION_ID(p_task_version_id IN number) return number
5057: is
5058: l_sub_task_id NUMBER := NULL;
5059: l_sub_task_version_id NUMBER := NULL;
5060: --

Line 5058: l_sub_task_id NUMBER := NULL;

5054: --
5055: --
5056: function GET_SUB_TASK_VERSION_ID(p_task_version_id IN number) return number
5057: is
5058: l_sub_task_id NUMBER := NULL;
5059: l_sub_task_version_id NUMBER := NULL;
5060: --
5061: --
5062: CURSOR c1 IS

Line 5059: l_sub_task_version_id NUMBER := NULL;

5055: --
5056: function GET_SUB_TASK_VERSION_ID(p_task_version_id IN number) return number
5057: is
5058: l_sub_task_id NUMBER := NULL;
5059: l_sub_task_version_id NUMBER := NULL;
5060: --
5061: --
5062: CURSOR c1 IS
5063: SELECT object_id_to1

Line 5071: FETCH c1 into l_sub_task_version_id;

5067: AND relationship_type = 'S';
5068: --
5069: begin
5070: OPEN c1;
5071: FETCH c1 into l_sub_task_version_id;
5072: CLOSE c1;
5073: return l_sub_task_version_id;
5074: exception
5075: when others then

Line 5073: return l_sub_task_version_id;

5069: begin
5070: OPEN c1;
5071: FETCH c1 into l_sub_task_version_id;
5072: CLOSE c1;
5073: return l_sub_task_version_id;
5074: exception
5075: when others then
5076: return(SQLCODE);
5077: end GET_SUB_TASK_VERSION_ID;

Line 5077: end GET_SUB_TASK_VERSION_ID;

5073: return l_sub_task_version_id;
5074: exception
5075: when others then
5076: return(SQLCODE);
5077: end GET_SUB_TASK_VERSION_ID;
5078: --
5079: --
5080: FUNCTION check_deliv_in_hie_upd(p_task_version_id IN number)
5081: RETURN NUMBER

Line 5127: l_sub_task_ver_id NUMBER:=NULL;

5123: -- l_err_msg VARCHAR2(80) :=NULL;
5124: l_err_msg VARCHAR2(1) :='N'; --Bug 3475920
5125: l_cnt_no_del_in_branch NUMBER:=0;
5126: l_parent_task_ver_id NUMBER:=NULL;
5127: l_sub_task_ver_id NUMBER:=NULL;
5128: BEGIN
5129: --
5130: l_parent_task_ver_id:=GET_PARENT_TASK_VERSION_ID(p_task_version_id);
5131: l_sub_task_ver_id:=GET_SUB_TASK_VERSION_ID(p_task_version_id);

Line 5131: l_sub_task_ver_id:=GET_SUB_TASK_VERSION_ID(p_task_version_id);

5127: l_sub_task_ver_id NUMBER:=NULL;
5128: BEGIN
5129: --
5130: l_parent_task_ver_id:=GET_PARENT_TASK_VERSION_ID(p_task_version_id);
5131: l_sub_task_ver_id:=GET_SUB_TASK_VERSION_ID(p_task_version_id);
5132: --
5133: IF l_parent_task_ver_id IS NOT NULL THEN
5134: FOR cur_check_deliv_bt_rec in cur_check_deliv_bt(l_parent_task_ver_id)
5135: LOOP

Line 5143: IF l_sub_task_ver_id IS NOT NULL THEN

5139: END IF;
5140: END LOOP;
5141: END IF;
5142: --
5143: IF l_sub_task_ver_id IS NOT NULL THEN
5144: FOR cur_check_deliv_tb_rec in cur_check_deliv_tb(l_sub_task_ver_id)
5145: LOOP
5146: IF cur_check_deliv_tb_rec.base_percent_comp_deriv_code LIKE 'DELIVERABLE' THEN
5147: l_cnt_no_del_in_branch := l_cnt_no_del_in_branch + 1;

Line 5144: FOR cur_check_deliv_tb_rec in cur_check_deliv_tb(l_sub_task_ver_id)

5140: END LOOP;
5141: END IF;
5142: --
5143: IF l_sub_task_ver_id IS NOT NULL THEN
5144: FOR cur_check_deliv_tb_rec in cur_check_deliv_tb(l_sub_task_ver_id)
5145: LOOP
5146: IF cur_check_deliv_tb_rec.base_percent_comp_deriv_code LIKE 'DELIVERABLE' THEN
5147: l_cnt_no_del_in_branch := l_cnt_no_del_in_branch + 1;
5148: EXIT;

Line 5234: -- This query checks if the task version has a financial sub-task.

5230: cursor cur_lowest_level_fin_task (c_project_id NUMBER
5231: , c_task_version_id NUMBER
5232: , c_include_sub_proj_flag VARCHAR2) -- Fix for Bug # 4290042.
5233: is
5234: -- This query checks if the task version has a financial sub-task.
5235: select 'N'
5236: from pa_object_relationships por1, pa_proj_element_versions ppev1
5237: where por1.object_id_to1 = ppev1.element_version_id
5238: and por1.relationship_type = 'S'

Line 5243: -- This query checks if the task version has a linking sub-task that has a financial link to

5239: and ppev1.project_id = c_project_id
5240: and por1.object_id_from1 = c_task_version_id
5241: and ppev1.financial_task_flag = 'Y'
5242: union all
5243: -- This query checks if the task version has a linking sub-task that has a financial link to
5244: -- a sub-project if the input p_include_sub_proj_flag = 'Y'.
5245: select 'N'
5246: from pa_object_relationships por2, pa_proj_element_versions ppev2
5247: where por2.object_id_to1 = ppev2.element_version_id

Line 5413: l_task_tbl sub_task; --Added this for Bug#4964992.

5409: AND PROJECT_ID = p_project_id; */
5410:
5411: /*l_task_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(); */ -- Commented this as this is no more needed after Bug#4964992 fix.
5412: l_dummy number:=0;
5413: l_task_tbl sub_task; --Added this for Bug#4964992.
5414:
5415: l_alt_task_Ids SYSTEM.pa_num_tbl_type := SYSTEM.PA_NUM_TBL_TYPE(); --bug#16461684
5416: l_valid_status_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE(); --bug#16461684
5417: l_Cbs_Enabled VARCHAR2(1) := 'N'; -- bug#16461684

Line 5418: l_alt_task_tbl sub_task; --bug#16461684

5414:
5415: l_alt_task_Ids SYSTEM.pa_num_tbl_type := SYSTEM.PA_NUM_TBL_TYPE(); --bug#16461684
5416: l_valid_status_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE(); --bug#16461684
5417: l_Cbs_Enabled VARCHAR2(1) := 'N'; -- bug#16461684
5418: l_alt_task_tbl sub_task; --bug#16461684
5419: l_tmp_task_tbl sub_task; --bug#16461684
5420:
5421: cursor alt_task_cur ( l_task_tbl sub_task ) is
5422: select alt_task_id from pa_alternate_tasks,table(cast(l_task_tbl as sub_task)) st

Line 5419: l_tmp_task_tbl sub_task; --bug#16461684

5415: l_alt_task_Ids SYSTEM.pa_num_tbl_type := SYSTEM.PA_NUM_TBL_TYPE(); --bug#16461684
5416: l_valid_status_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE(); --bug#16461684
5417: l_Cbs_Enabled VARCHAR2(1) := 'N'; -- bug#16461684
5418: l_alt_task_tbl sub_task; --bug#16461684
5419: l_tmp_task_tbl sub_task; --bug#16461684
5420:
5421: cursor alt_task_cur ( l_task_tbl sub_task ) is
5422: select alt_task_id from pa_alternate_tasks,table(cast(l_task_tbl as sub_task)) st
5423: where proj_element_id = st.task_id ;

Line 5421: cursor alt_task_cur ( l_task_tbl sub_task ) is

5417: l_Cbs_Enabled VARCHAR2(1) := 'N'; -- bug#16461684
5418: l_alt_task_tbl sub_task; --bug#16461684
5419: l_tmp_task_tbl sub_task; --bug#16461684
5420:
5421: cursor alt_task_cur ( l_task_tbl sub_task ) is
5422: select alt_task_id from pa_alternate_tasks,table(cast(l_task_tbl as sub_task)) st
5423: where proj_element_id = st.task_id ;
5424:
5425: BEGIN

Line 5422: select alt_task_id from pa_alternate_tasks,table(cast(l_task_tbl as sub_task)) st

5418: l_alt_task_tbl sub_task; --bug#16461684
5419: l_tmp_task_tbl sub_task; --bug#16461684
5420:
5421: cursor alt_task_cur ( l_task_tbl sub_task ) is
5422: select alt_task_id from pa_alternate_tasks,table(cast(l_task_tbl as sub_task)) st
5423: where proj_element_id = st.task_id ;
5424:
5425: BEGIN
5426: x_error_code := 0;

Line 5500: FROM PA_EXPENDITURE_ITEMS_all pei,table(cast(l_alt_task_tbl as sub_task)) st --Changed the query for Bug#4964992

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)
5502: or exists (SELECT NULL
5503: FROM PA_EI_DENORM ped, table(cast(l_task_tbl as sub_task)) st
5504: WHERE ped.TASK_ID = st.task_id);

Line 5503: FROM PA_EI_DENORM ped, table(cast(l_task_tbl as sub_task)) st

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)
5502: or exists (SELECT NULL
5503: FROM PA_EI_DENORM ped, table(cast(l_task_tbl as sub_task)) st
5504: WHERE ped.TASK_ID = st.task_id);
5505: ELSE */
5506: SELECT
5507: 1 into l_dummy

Line 5512: FROM PA_EXPENDITURE_ITEMS_all pei,table(cast(l_task_tbl as sub_task)) st --Changed the query for Bug#4964992

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)
5514: or exists (SELECT NULL
5515: FROM PA_EI_DENORM ped, table(cast(l_task_tbl as sub_task)) st
5516: WHERE ped.TASK_ID = st.task_id);

Line 5515: FROM PA_EI_DENORM ped, table(cast(l_task_tbl as sub_task)) st

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)
5514: or exists (SELECT NULL
5515: FROM PA_EI_DENORM ped, table(cast(l_task_tbl as sub_task)) st
5516: WHERE ped.TASK_ID = st.task_id);
5517: --END IF; commented for 16844815
5518: IF l_dummy = 1 THEN
5519: x_error_code :=50;

Line 5556: FROM po_distributions_all poa, table(cast(l_task_tbl as sub_task)) st --Changed the query for Bug#4964992

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
5558: AND poa.TASK_ID = st.task_id);
5559:
5560: IF l_dummy = 1 THEN

Line 5598: FROM po_req_distributions_all prd, table(cast(l_task_tbl as sub_task)) st --Changed the query for Bug#4964992

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
5600: AND prd.TASK_ID = st.task_id);
5601:
5602: IF l_dummy = 1 THEN

Line 5640: FROM ap_invoices_all aia, table(cast(l_task_tbl as sub_task)) st --Changed the query for Bug#4964992

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
5642: AND aia.TASK_ID = st.task_id);
5643:
5644: IF l_dummy = 1 THEN

Line 5681: FROM ap_invoice_distributions_all aid, table(cast(l_task_tbl as sub_task)) st --Changed the query for Bug#4964992

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
5683: AND aid.TASK_ID = st.task_id);
5684:
5685: IF l_dummy = 1 THEN

Line 5719: FROM pa_commitment_txns pct, table(cast(l_task_tbl as sub_task)) st --Changed the query for Bug#4964992

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
5721: AND pct.TASK_ID = st.task_id);
5722:
5723: IF l_dummy = 1 THEN

Line 5757: FROM pa_comp_rule_ot_defaults_all pcr, table(cast(l_task_tbl as sub_task)) st --Changed the query for Bug#4964992

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
5759: AND pcr.TASK_ID = st.task_id)
5760: or exists (SELECT NULL
5761: FROM pa_org_labor_sch_rule pol, table(cast(l_task_tbl as sub_task)) st

Line 5761: FROM pa_org_labor_sch_rule pol, table(cast(l_task_tbl as sub_task)) st

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
5759: AND pcr.TASK_ID = st.task_id)
5760: or exists (SELECT NULL
5761: FROM pa_org_labor_sch_rule pol, table(cast(l_task_tbl as sub_task)) st
5762: where overtime_project_id = p_project_id
5763: AND pol.overtime_TASK_ID = st.task_id);
5764:
5765: IF l_dummy = 1 THEN

Line 5802: FROM pa_draft_invoice_details_all pdi, table(cast(l_task_tbl as sub_task)) st --Changed the query for Bug#4964992

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
5804: and pdi.project_id = p_project_id); -- Added for bug 8530541
5805:
5806: IF l_dummy = 1 THEN

Line 5840: FROM pa_project_customers pc, table(cast(l_task_tbl as sub_task)) st --Changed the query for Bug#4964992

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 */
5842: pc.receiver_task_id =st.task_id);
5843:
5844: IF l_dummy = 1 THEN

Line 5882: FROM ap_exp_report_dists_all er, table(cast(l_task_tbl as sub_task)) st --Changed the query for Bug#4964992

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
5884: AND er.TASK_ID = st.task_id);
5885:
5886: IF l_dummy = 1 THEN

Line 5924: FROM mtl_material_transactions mtl, table(cast(l_task_tbl as sub_task)) st --Changed the query for Bug#4964992

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
5926: AND mtl.TASK_ID = st.task_id);
5927:
5928: IF l_dummy = 1 THEN

Line 5987: -- Return Value : Type sub_task (Table)

5983:
5984: -- API name : get_task_hierarchy
5985: -- Type : Function
5986: -- Pre-reqs : None
5987: -- Return Value : Type sub_task (Table)
5988:
5989: -- Prameters :
5990: -- p_project_id IN NUMBER
5991: -- p_task_id IN NUMBER

Line 6024: RETURN sub_task

6020: FUNCTION get_task_hierarchy(
6021: p_project_id IN NUMBER,
6022: p_task_id IN NUMBER
6023: )
6024: RETURN sub_task
6025: IS
6026:
6027: l_task_tbl sub_task;
6028: l_debug_level3 CONSTANT NUMBER := 3;

Line 6027: l_task_tbl sub_task;

6023: )
6024: RETURN sub_task
6025: IS
6026:
6027: l_task_tbl sub_task;
6028: l_debug_level3 CONSTANT NUMBER := 3;
6029: l_user_id NUMBER;
6030: l_login_id NUMBER;
6031: l_debug_mode VARCHAR2(1);

Line 6080: RETURN sub_task

6076: FUNCTION get_Alt_task_List(
6077: p_project_id IN NUMBER,
6078: p_task_id IN NUMBER
6079: )
6080: RETURN sub_task
6081: IS
6082:
6083: l_alt_task_tbl sub_task;
6084: l_debug_level3 CONSTANT NUMBER := 3;

Line 6083: l_alt_task_tbl sub_task;

6079: )
6080: RETURN sub_task
6081: IS
6082:
6083: l_alt_task_tbl sub_task;
6084: l_debug_level3 CONSTANT NUMBER := 3;
6085: l_user_id NUMBER;
6086: l_login_id NUMBER;
6087: l_debug_mode VARCHAR2(1);