[Home] [Help]
140:
141: SELECT 'Y'
142: INTO l_billable
143: FROM pa_projects_all pp,
144: pa_tasks t,
145: pa_project_types_all pt /** Bug fix 2262118 **/
146: WHERE t.task_id = p_task_id
147: AND pp.project_id = t.project_id
148: AND pp.project_type = pt.project_type
1232: , adjustment_type = 'RECALC_RAW'
1233: /* End Burdening Changes - PA.L */
1234: , project_raw_cost = NULL
1235: , project_burdened_cost = NULL
1236: , labor_cost_multiplier_name = (select labor_cost_multiplier_name from pa_tasks t where t.task_id = ei.task_id) /* Bug 9670726 */
1237: , last_updated_by = X_user
1238: , last_update_date = sysdate
1239: , last_update_login = X_login
1240: WHERE
1325: , ei.adjustment_type = 'RECALC_RAW'
1326: /* End Burdening Changes - PA.L */
1327: , ei.project_raw_cost = NULL
1328: , ei.project_burdened_cost = NULL
1329: , ei.labor_cost_multiplier_name =(select labor_cost_multiplier_name from pa_tasks t where t.task_id = ei.task_id) /* Bug 9670726 */
1330: , ei.last_update_date = sysdate
1331: , ei.last_updated_by = X_user
1332: , ei.last_update_login = X_login
1333: WHERE
1616: , adjustment_type = 'RECALC_RAW'
1617: /* End Burdening Changes - PA.L */
1618: , project_raw_cost = NULL
1619: , project_burdened_cost = NULL
1620: , labor_cost_multiplier_name = (select labor_cost_multiplier_name from pa_tasks t where t.task_id = ei.task_id) /* Bug 9670726 */
1621: , last_updated_by = X_user
1622: , last_update_date = sysdate
1623: , last_update_login = X_login
1624: WHERE
1711: , ei.adjustment_type = 'RECALC_RAW'
1712: /* End Burdening Changes - PA.L */
1713: , ei.project_raw_cost = null
1714: , ei.project_burdened_cost = null
1715: , ei.labor_cost_multiplier_name = (select labor_cost_multiplier_name from pa_tasks t where t.task_id = ei.task_id) /* Bug 9670726 */
1716: , ei.last_update_date = sysdate
1717: , ei.last_updated_by = X_user
1718: , ei.last_update_login = X_login
1719: WHERE
2365: FROM pa_expenditure_items_all EI
2366: ,pa_transaction_sources tr
2367: ,pa_project_types_all pt /** Bug fix 2262118 **/
2368: ,pa_projects_all pp
2369: -- ,pa_tasks t /* Bug 3457922 */
2370: WHERE tr.transaction_source(+) = ei.transaction_source
2371: AND ei.expenditure_item_id = ItemsIdTab(i)
2372: -- AND t.task_id = ei.task_id /* Bug 3457922 */
2373: -- AND pp.project_id = t.project_id /* Bug 3457922 */
4292:
4293: ( SELECT
4294: t.task_id
4295: FROM
4296: pa_tasks t
4297: WHERE
4298: t.project_id = X_project_id
4299: AND t.task_id = nvl( X_task_id, t.task_id )
4300: )
4403: AND ei.billable_flag <> 'Y'
4404: AND nvl( ei.converted_flag, 'N' ) <> 'Y'
4405: AND nvl( eia.converted_flag, 'N' ) <> 'Y'
4406: AND exists (select 1
4407: From pa_tasks t
4408: Where t.task_id = ei.task_id
4409: And t.retirement_cost_flag = 'N')
4410:
4411: )
4414: AND ei.billable_flag = 'Y'
4415: AND nvl( ei.converted_flag, 'N' ) <> 'Y'
4416: AND nvl( eia.converted_flag, 'N' ) <> 'Y'
4417: AND exists (select 1
4418: From pa_tasks t
4419: Where t.task_id = ei.task_id
4420: And t.retirement_cost_flag = 'N')
4421: )
4422: OR
4502: AND ei.billable_flag <> 'Y'
4503: AND nvl( ei.converted_flag, 'N' ) <> 'Y'
4504: AND nvl( eia.converted_flag, 'N' ) <> 'Y'
4505: AND exists (select 1
4506: From pa_tasks t
4507: Where t.task_id = ei.task_id
4508: And t.retirement_cost_flag = 'N')
4509: )
4510: OR
4512: AND ei.billable_flag = 'Y'
4513: AND nvl( ei.converted_flag, 'N' ) <> 'Y'
4514: AND nvl( eia.converted_flag, 'N' ) <> 'Y'
4515: AND exists (select 1
4516: From pa_tasks t
4517: Where t.task_id = ei.task_id
4518: And t.retirement_cost_flag = 'N')
4519: )
4520: OR
4626: WHERE
4627: /* Bug # 3457873
4628: ei.task_id IN (
4629: SELECT task_id
4630: FROM pa_tasks
4631: WHERE project_id = X_project_id )
4632: */
4633: ei.project_id = X_project_id /* Bug # 3457873 */
4634: AND ei.expenditure_item_id = eia.adjusted_expenditure_item_id (+)
6009: || ' AND p.org_id = pt.org_id'
6010: || ' AND p.project_id = ei.project_id'
6011: || ' AND pt.project_type_class_code = ''CAPITAL'')'
6012: || ' AND 1 = (SELECT 1'
6013: || ' FROM pa_tasks t'
6014: || ' WHERE t.task_id = ei.task_id'
6015: || ' AND t.retirement_cost_flag = ''N'')'
6016: || ' AND ei.revenue_distributed_flag = :grouped_cip_flag';
6017: end if;
6024: || ' AND p.org_id = pt.org_id'
6025: || ' AND p.project_id = ei.project_id'
6026: || ' AND pt.project_type_class_code = ''CAPITAL'')'
6027: || ' AND 1 = (SELECT 1'
6028: || ' FROM pa_tasks t'
6029: || ' WHERE t.task_id = ei.task_id'
6030: || ' AND t.retirement_cost_flag = ''Y'')'
6031: || ' AND ei.revenue_distributed_flag = :grouped_rwip_flag';
6032: end if;
6039: || ' AND p.org_id = pt.org_id'
6040: || ' AND p.project_id = ei.project_id'
6041: || ' AND pt.project_type_class_code = ''CAPITAL'')'
6042: || ' AND 1 = (SELECT 1'
6043: || ' FROM pa_tasks t'
6044: || ' WHERE t.task_id = ei.task_id'
6045: || ' AND t.billable_flag = ''N'''
6046: || ' AND t.retirement_cost_flag = ''N'')';
6047: end if;
6838: l_start_date DATE;
6839: l_end_date DATE;
6840: cursor task_start_end_date is
6841: select start_date, completion_date
6842: from pa_tasks
6843: where task_id = X_dest_task_id;
6844: begin
6845: open task_start_end_date;
6846: fetch task_start_end_date into l_start_date, l_end_date;
9661: l_acct_rate_type pa_expenditure_items_all.acct_rate_type%TYPE;
9662: l_acct_rate_date_code pa_implementations_all.acct_rate_date_code%TYPE;
9663: l_acct_exch_rate pa_org_labor_sch_rule.acct_exchange_rate%TYPE;
9664: l_ot_project_id pa_projects_all.project_id%TYPE;
9665: l_ot_task_id pa_tasks.task_id%TYPE;
9666: l_err_stage number;
9667: l_err_code varchar2(1000);
9668: OTHERS_EXCEPTION EXCEPTION;
9669: