1 PACKAGE gms_client_extn_budget AUTHID CURRENT_USER AS
2 /* $Header: gmsbcecs.pls 120.4 2006/08/16 11:09:28 lveerubh ship $ */
3 /*#
4 * This client extension allows you to override certain budget validations.
5 * @rep:scope public
6 * @rep:product GMS
7 * @rep:lifecycle active
8 * @rep:displayname Budget Client Extension
9 * @rep:compatibility S
10 * @rep:category BUSINESS_ENTITY GMS_AWARD
11 * @rep:doccd 120gmsug.pdf See the Oracle Oracle Grants Accounting User's Guide
12 */
13 procedure Calc_Raw_Cost( x_budget_version_id in number,
14 x_project_id in number,
15 x_task_id in number,
16 x_resource_list_member_id in number,
17 x_resource_list_id in number,
18 x_resource_id in number,
19 x_start_date in date,
20 x_end_date in date,
21 x_period_name in varchar2,
22 x_quantity in number,
23 x_raw_cost in out NOCOPY number,
24 x_pm_product_code in varchar2,
25 x_error_code out NOCOPY number,
26 x_error_message out NOCOPY varchar2);
27
28 procedure Calc_Burdened_Cost( x_budget_version_id in number,
29 x_project_id in number,
30 x_task_id in number,
31 x_resource_list_member_id in number,
32 x_resource_list_id in number,
33 x_resource_id in number,
34 x_start_date in date,
35 x_end_date in date,
36 x_period_name in varchar2,
37 x_quantity in number,
38 x_raw_cost in number,
39 x_burdened_cost in out NOCOPY number,
40 x_pm_product_code in varchar2,
41 x_error_code out NOCOPY number,
42 x_error_message out NOCOPY varchar2);
43
44
45 PROCEDURE Verify_Budget_Rules
46 (p_draft_version_id IN NUMBER
47 , p_mark_as_original IN VARCHAR2
48 , p_event IN VARCHAR2
49 , p_project_id IN NUMBER
50 , p_budget_type_code IN VARCHAR2
51 , p_resource_list_id IN NUMBER
52 , p_project_type_class_code IN VARCHAR2
53 , p_created_by IN NUMBER
54 , p_calling_module IN VARCHAR2
55 , p_warnings_only_flag OUT NOCOPY VARCHAR2
56 , p_err_msg_count OUT NOCOPY NUMBER
57 , p_error_code OUT NOCOPY NUMBER
58 , p_error_message OUT NOCOPY VARCHAR2
59 );
60
61 -- For Bug:2395386
62 /*#
63 *This procedures allows you to override following budget validations :
64 * a) Does not allow budgeting outside of installment dates.
65 * b) Budget line amount against available funds in the order of budget period. This default
66 * functionality can be overriden to check the funds availability in the ascending order of budget
67 * line amounts so that negative amounts are compared first.
68 * @param p_award_id Identifier of the award_id whose budget-installment validation to override
69 * @rep:paraminfo {@rep:required}
70 * @param p_project_id Identifier of the project_id whose budget-installment validation to override
71 * @rep:paraminfo {@rep:required}
72 * @param p_override_validation RETURN Y to override validation or N not to override validation
73 * @rep:paraminfo {@rep:required}
74 * @rep:scope public
75 * @rep:lifecycle active
76 * @rep:displayname Override Installment Date Validation
77 * @rep:compatibility S
78 */
79 PROCEDURE override_inst_date_validation
80 ( p_award_id IN NUMBER,
81 p_project_id IN NUMBER,
82 p_override_validation OUT NOCOPY VARCHAR2 );
83
84 pragma restrict_references(override_inst_date_validation, wnds, wnps);
85
86 END gms_client_extn_budget;