1 PACKAGE IGW_BUDGET_PERIODS_PVT AUTHID CURRENT_USER as
2 --$Header: igwvbprs.pls 115.4 2002/11/14 18:40:52 vmedikon ship $
3 G_package_name VARCHAR2(30) := 'IGW_BUDGET_PERIODS_PVT';
4 procedure create_budget_period
5 (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
6 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
7 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
8 ,p_proposal_id NUMBER
9 ,p_version_id NUMBER
10 ,p_budget_period_id NUMBER
11 ,p_start_date DATE
12 ,p_end_date DATE
13 ,p_total_cost NUMBER := 0
14 ,p_total_direct_cost NUMBER := 0
15 ,p_total_indirect_cost NUMBER := 0
16 ,p_cost_sharing_amount NUMBER := 0
17 ,p_underrecovery_amount NUMBER := 0
18 ,p_total_cost_limit NUMBER := 0
19 ,p_program_income VARCHAR2 := 0
20 ,p_program_income_source VARCHAR2
21 ,x_rowid OUT NOCOPY ROWID
22 ,x_return_status OUT NOCOPY VARCHAR2
23 ,x_msg_count OUT NOCOPY NUMBER
24 ,x_msg_data OUT NOCOPY VARCHAR2);
25
26
27 ----------------------------------------------------------------------
28 procedure update_budget_period
29 (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
30 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
31 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
32 ,p_proposal_id NUMBER
33 ,p_version_id NUMBER
34 ,p_budget_period_id NUMBER
35 ,p_start_date DATE
36 ,p_end_date DATE
37 ,p_total_cost NUMBER
38 ,p_total_direct_cost NUMBER
39 ,p_total_indirect_cost NUMBER
40 ,p_cost_sharing_amount NUMBER
41 ,p_underrecovery_amount NUMBER
42 ,p_total_cost_limit NUMBER
43 ,p_program_income VARCHAR2
44 ,p_program_income_source VARCHAR2
45 ,p_record_version_number IN NUMBER
46 ,p_rowid IN ROWID
47 ,x_return_status OUT NOCOPY VARCHAR2
48 ,x_msg_count OUT NOCOPY NUMBER
49 ,x_msg_data OUT NOCOPY VARCHAR2);
50
51 -----------------------------------------------------------------------
52
53 procedure delete_budget_period
54 (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
55 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
56 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
57 ,p_proposal_id NUMBER
58 ,p_version_id NUMBER
59 ,p_budget_period_id NUMBER
60 ,p_record_version_number IN NUMBER
61 ,p_rowid IN ROWID
62 ,x_return_status OUT NOCOPY VARCHAR2
63 ,x_msg_count OUT NOCOPY NUMBER
64 ,x_msg_data OUT NOCOPY VARCHAR2);
65
66
67 END IGW_BUDGET_PERIODS_PVT;