1 PACKAGE PA_CE_INTEGRATION AUTHID CURRENT_USER AS
2 /* $Header: PAXCEINS.pls 120.1 2005/08/19 17:11:11 mwasowic noship $ */
3
4 -- PUBLIC PROCEDURES and FUNCTIONS
5 --
6 -- This procedure accepts as input a project ID, start and end dates of the
7 -- period for which forecast is to be done, budget type code and budget version
8 -- (C)urrent or (O)riginal. It computes the pro-rated raw cost or revenue amount
9 -- budgeted for that project for the specified forecast period
10
11 PROCEDURE Pa_Ce_Budgets ( X_project_id IN NUMBER
12 , X_period_start_date IN DATE
13 , X_period_end_date IN DATE
14 , X_budget_type IN VARCHAR2
15 , X_version IN VARCHAR2
16 , X_cost_amount OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
17 , X_revenue_amount OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
18 , X_currency_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
19 , X_org_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
20 , X_err_stack IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
21 , X_err_stage IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
22 , X_err_code IN OUT NOCOPY NUMBER ); --File.Sql.39 bug 4440895
23
24
25 END PA_CE_INTEGRATION;