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 2006/03/31 03:52:46 rshaik noship $
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 599: PA_DEBUG.init_err_stack('PA_SWEEPER.UPDATE_ACT_ENC_BALANCE');

595: END InitPlSqlTabs2;
596: BEGIN
597:
598: --Initialize the error stack
599: PA_DEBUG.init_err_stack('PA_SWEEPER.UPDATE_ACT_ENC_BALANCE');
600:
601: --Initialize the message table for FND_MSG_PUB
602: fnd_msg_pub.initialize;
603:

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

1442: rollback;
1443:
1444: x_return_status := fnd_api.g_ret_sts_unexp_error;
1445:
1446: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_SWEEPER'
1447: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1448:
1449: x_error_message_code := (SQLCODE||' '||SQLERRM);
1450:

Line 1469: END PA_SWEEPER;

1465:
1466: raise;
1467: END update_act_enc_balance;
1468:
1469: END PA_SWEEPER;