1 PACKAGE IGW_BUDGET_DETAILS_TBH AUTHID CURRENT_USER as
2 --$Header: igwtbdts.pls 115.3 2002/11/14 18:39:52 vmedikon ship $
3 G_package_name VARCHAR2(30) := 'IGW_BUDGET_DETAILS_TBH';
4 procedure INSERT_ROW (
5 p_proposal_id NUMBER
6 ,p_version_id NUMBER
7 ,p_budget_period_id NUMBER
8 ,p_line_item_id NUMBER
9 ,p_expenditure_type VARCHAR2
10 ,p_expenditure_category_flag VARCHAR2
11 ,p_budget_category_code VARCHAR2
12 ,p_line_item_description VARCHAR2
13 ,p_based_on_line_item NUMBER
14 ,p_line_item_cost NUMBER
15 ,p_cost_sharing_amount NUMBER
16 ,p_underrecovery_amount NUMBER
17 ,p_apply_inflation_flag VARCHAR2
18 ,p_budget_justification LONG
19 ,p_location_code VARCHAR2
20 ,p_project_id NUMBER
21 ,p_task_id NUMBER
22 ,p_award_id NUMBER
23 ,x_rowid OUT NOCOPY VARCHAR2
24 ,x_return_status OUT NOCOPY VARCHAR2);
25
26
27 ----------------------------------------------------------------------
28 procedure UPDATE_ROW (
29 p_rowid ROWID
30 ,p_proposal_id NUMBER
31 ,p_version_id NUMBER
32 ,p_budget_period_id NUMBER
33 ,p_line_item_id NUMBER
34 ,p_expenditure_type VARCHAR2
35 ,p_expenditure_category_flag VARCHAR2
36 ,p_budget_category_code VARCHAR2
37 ,p_line_item_description VARCHAR2
38 ,p_based_on_line_item NUMBER
39 ,p_line_item_cost NUMBER
40 ,p_cost_sharing_amount NUMBER
41 ,p_underrecovery_amount NUMBER
42 ,p_apply_inflation_flag VARCHAR2
43 ,p_budget_justification LONG
44 ,p_location_code VARCHAR2
45 ,p_project_id NUMBER
46 ,p_task_id NUMBER
47 ,p_award_id NUMBER
48 ,p_record_version_number NUMBER
49 ,x_return_status OUT NOCOPY VARCHAR2);
50 -----------------------------------------------------------------------
51
52 procedure DELETE_ROW (
53 p_rowid IN ROWID
54 ,p_proposal_id IN NUMBER
55 ,p_version_id IN NUMBER
56 ,p_budget_period_id IN NUMBER
57 ,p_line_item_id NUMBER
58 ,p_record_version_number IN NUMBER
59 ,x_return_status OUT NOCOPY VARCHAR2);
60
61
62 END IGW_BUDGET_DETAILS_TBH;
[Home] [Help]