1: PACKAGE BODY PA_SWEEPER AS
2: -- $Header: PAFCUAEB.pls 120.7.12020000.5 2013/03/06 09:29:04 admarath ship $
3:
4: -- Function : GetBCBalStartDate
5: -- Purpose : Based on TPC, returns the start date
288: , pbc.balance_posted_flag
289: , pbc.status_code
290: , pbm.time_phased_type_code
291: --, trunc(pbc.expenditure_item_date)
292: , PA_SWEEPER.GetBCBalStartDate(pbm.time_phased_type_code,pbc.project_id,pbc.expenditure_item_date,pbc.budget_version_id, pbc.set_of_books_id, pbc.org_id, pbc.task_id, pbc.top_task_id, pbc.resource_list_member_id,pbc.gl_date,pbc.pa_date)
293: , PA_SWEEPER.GetBCBalEndDate(pbm.time_phased_type_code,pbc.project_id,pbc.expenditure_item_date, pbc.budget_version_id, pbc.set_of_books_id, pbc.org_id, pbc.task_id, pbc.top_task_id, pbc.resource_list_member_id,pbc.gl_date,pbc.pa_date)
294: /*Bug 3007393*/
295: /*, pbc.org_id*/
296: from pa_budget_versions pbv
289: , pbc.status_code
290: , pbm.time_phased_type_code
291: --, trunc(pbc.expenditure_item_date)
292: , PA_SWEEPER.GetBCBalStartDate(pbm.time_phased_type_code,pbc.project_id,pbc.expenditure_item_date,pbc.budget_version_id, pbc.set_of_books_id, pbc.org_id, pbc.task_id, pbc.top_task_id, pbc.resource_list_member_id,pbc.gl_date,pbc.pa_date)
293: , PA_SWEEPER.GetBCBalEndDate(pbm.time_phased_type_code,pbc.project_id,pbc.expenditure_item_date, pbc.budget_version_id, pbc.set_of_books_id, pbc.org_id, pbc.task_id, pbc.top_task_id, pbc.resource_list_member_id,pbc.gl_date,pbc.pa_date)
294: /*Bug 3007393*/
295: /*, pbc.org_id*/
296: from pa_budget_versions pbv
297: , pa_bc_packets pbc
323: , pbc.task_id
324: , pbc.top_task_id
325: , pbc.document_type
326: --, trunc(pbc.expenditure_item_date)
327: , PA_SWEEPER.GetBCBalStartDate(pbm.time_phased_type_code,pbc.project_id,pbc.expenditure_item_date,pbc.budget_version_id, pbc.set_of_books_id, pbc.org_id, pbc.task_id, pbc.top_task_id, pbc.resource_list_member_id,pbc.gl_date,pbc.pa_date)
328: , PA_SWEEPER.GetBCBalEndDate(pbm.time_phased_type_code,pbc.project_id,pbc.expenditure_item_date, pbc.budget_version_id, pbc.set_of_books_id, pbc.org_id, pbc.task_id, pbc.top_task_id, pbc.resource_list_member_id,pbc.gl_date,pbc.pa_date)
329: , pbc.resource_list_member_id
330: , pbc.parent_resource_id
331: , pbc.set_of_books_id
324: , pbc.top_task_id
325: , pbc.document_type
326: --, trunc(pbc.expenditure_item_date)
327: , PA_SWEEPER.GetBCBalStartDate(pbm.time_phased_type_code,pbc.project_id,pbc.expenditure_item_date,pbc.budget_version_id, pbc.set_of_books_id, pbc.org_id, pbc.task_id, pbc.top_task_id, pbc.resource_list_member_id,pbc.gl_date,pbc.pa_date)
328: , PA_SWEEPER.GetBCBalEndDate(pbm.time_phased_type_code,pbc.project_id,pbc.expenditure_item_date, pbc.budget_version_id, pbc.set_of_books_id, pbc.org_id, pbc.task_id, pbc.top_task_id, pbc.resource_list_member_id,pbc.gl_date,pbc.pa_date)
329: , pbc.resource_list_member_id
330: , pbc.parent_resource_id
331: , pbc.set_of_books_id
332: , pbm.time_phased_type_code
650:
651: BEGIN
652:
653: --Initialize the error stack
654: PA_DEBUG.init_err_stack('PA_SWEEPER.UPDATE_ACT_ENC_BALANCE');
655:
656: --Initialize the message table for FND_MSG_PUB
657: fnd_msg_pub.initialize;
658:
1506: rollback;
1507:
1508: x_return_status := fnd_api.g_ret_sts_unexp_error;
1509:
1510: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_SWEEPER'
1511: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1512:
1513: x_error_message_code := (SQLCODE||' '||SQLERRM);
1514:
1529:
1530: raise;
1531: END update_act_enc_balance;
1532:
1533: END PA_SWEEPER;