[Home] [Help]
PACKAGE: APPS.IGW_BUDGET_OPERATIONS
Source
1 PACKAGE IGW_BUDGET_OPERATIONS AUTHID CURRENT_USER as
2 -- $Header: igwbuops.pls 115.11 2002/11/14 18:40:30 vmedikon ship $
3 G_PKG_NAME CONSTANT VARCHAR2(30) := 'PACKAGE IGW_BUDGET_OPERATIONS';
4 G_START_PERIOD NUMBER(10):=1;
5 G_PROPOSAL_ID NUMBER(15):=0;
6 G_VERSION_ID NUMBER(4):=0;
7
8 /* duplicated procedure below to recalculate individually */
9
10 /*
11 PROCEDURE recalculate_budget (p_proposal_id NUMBER
12 ,p_version_id NUMBER
13 ,p_activity_type_code VARCHAR2
14 ,p_oh_rate_class_id NUMBER
15 ,x_return_status OUT NOCOPY VARCHAR2
16 ,x_msg_data OUT NOCOPY VARCHAR2
17 ,x_msg_count OUT NOCOPY NUMBER);
18 */
19
20 ----------------------------------------------------------------------------------
21 PROCEDURE copy_budget(p_proposal_id NUMBER
22 ,p_target_proposal_id NUMBER
23 ,p_version_id NUMBER
24 ,p_copy_first_period VARCHAR2
25 ,p_copy_type VARCHAR2
26 ,p_budget_type_code VARCHAR2
27 ,x_return_status OUT NOCOPY VARCHAR2
28 ,x_msg_data OUT NOCOPY VARCHAR2
29 ,x_msg_count OUT NOCOPY NUMBER);
30 ----------------------------------------------------------------------------------
31 Function get_period_id RETURN NUMBER;
32 pragma restrict_references(get_period_id, wnds, wnps);
33 ----------------------------------------------------------------------------------
34 Function get_version_id RETURN NUMBER;
35 pragma restrict_references(get_version_id, wnds, wnps);
36 ----------------------------------------------------------------------------------
37 Function get_proposal_id RETURN NUMBER;
38 pragma restrict_references(get_proposal_id, wnds, wnps);
39 ----------------------------------------------------------------------------------
40 Procedure set_global_variables(p_start_period NUMBER
41 ,p_proposal_id NUMBER
42 ,p_version_id NUMBER);
43 ----------------------------------------------------------------------------------
44 PROCEDURE recalculate_budget(p_proposal_id NUMBER
45 ,p_version_id NUMBER
46 ,p_budget_period_id NUMBER :=NULL
47 ,p_line_item_id NUMBER :=NULL
48 ,p_budget_personnel_detail_id NUMBER :=NULL
49 ,p_activity_type_code VARCHAR2 :=NULL
50 ,p_oh_rate_class_id NUMBER :=NULL
51 ,x_return_status OUT NOCOPY VARCHAR2
52 ,x_msg_data OUT NOCOPY VARCHAR2
53 ,x_msg_count OUT NOCOPY NUMBER);
54 END IGW_BUDGET_OPERATIONS;