DBA Data[Home] [Help]

APPS.PA_SWEEPER dependencies on PA_SWEEPER

Line 1: PACKAGE BODY PA_SWEEPER AS

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

Line 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)

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

Line 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)

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

Line 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)

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

Line 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)

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

Line 654: PA_DEBUG.init_err_stack('PA_SWEEPER.UPDATE_ACT_ENC_BALANCE');

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:

Line 1510: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_SWEEPER'

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:

Line 1533: END PA_SWEEPER;

1529:
1530: raise;
1531: END update_act_enc_balance;
1532:
1533: END PA_SWEEPER;