1 PACKAGE IGW_BUDGET_DETAILS_OH_PVT AUTHID CURRENT_USER as
2 --$Header: igwvbdos.pls 115.3 2002/11/14 18:39:19 vmedikon ship $
3 G_package_name VARCHAR2(30) := 'IGW_BUDGET_DETAILS_OH_PVT';
4 procedure create_budget_line_oh
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_line_item_id NUMBER
12 ,p_rate_class_id NUMBER
13 ,p_rate_type_id NUMBER
14 ,p_apply_rate_flag VARCHAR2
15 ,p_calculated_cost NUMBER := 0
16 ,p_calculated_cost_sharing NUMBER := 0
17 ,x_rowid OUT NOCOPY ROWID
18 ,x_return_status OUT NOCOPY VARCHAR2
19 ,x_msg_count OUT NOCOPY NUMBER
20 ,x_msg_data OUT NOCOPY VARCHAR2);
21
22
23 ----------------------------------------------------------------------
24 procedure update_budget_line_oh
25 (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
26 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
27 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
28 ,p_proposal_id NUMBER := NULL
29 ,p_version_id NUMBER := NULL
30 ,p_budget_period_id NUMBER := NULL
31 ,p_line_item_id NUMBER
32 ,p_rate_class_id NUMBER
33 ,p_rate_type_id NUMBER
34 ,p_apply_rate_flag VARCHAR2
35 ,p_calculated_cost NUMBER
36 ,p_calculated_cost_sharing NUMBER
37 ,p_record_version_number IN NUMBER
38 ,p_rowid IN ROWID
39 ,x_return_status OUT NOCOPY VARCHAR2
40 ,x_msg_count OUT NOCOPY NUMBER
41 ,x_msg_data OUT NOCOPY VARCHAR2);
42
43 -----------------------------------------------------------------------
44
45 procedure delete_budget_line_oh
46 (p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
47 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
48 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
49 ,p_proposal_id IN NUMBER := NULL
50 ,p_version_id IN NUMBER := NULL
51 ,p_budget_period_id NUMBER := NULL
52 ,p_line_item_id NUMBER
53 ,p_rate_class_id NUMBER
54 ,p_rate_type_id NUMBER
55 ,p_record_version_number IN NUMBER
56 ,p_rowid IN ROWID
57 ,x_return_status OUT NOCOPY VARCHAR2
58 ,x_msg_count OUT NOCOPY NUMBER
59 ,x_msg_data OUT NOCOPY VARCHAR2);
60
61
62 END;