1 PACKAGE IGW_BUDGET_PERIODS_TBH AUTHID CURRENT_USER as
2 -- $Header: igwtbprs.pls 115.3 2002/11/14 18:41:13 vmedikon ship $
3 G_package_name VARCHAR2(30) := 'IGW_BUDGET_PERIODS_TBH';
4 procedure INSERT_ROW (
5 p_proposal_id NUMBER
6 ,p_version_id NUMBER
7 ,p_budget_period_id NUMBER
8 ,p_start_date DATE
9 ,p_end_date DATE
10 ,p_total_cost NUMBER
11 ,p_total_direct_cost NUMBER
12 ,p_total_indirect_cost NUMBER
13 ,p_cost_sharing_amount NUMBER
14 ,p_underrecovery_amount NUMBER
15 ,p_total_cost_limit NUMBER
16 ,p_program_income VARCHAR2
17 ,p_program_income_source VARCHAR2
18 ,x_rowid OUT NOCOPY VARCHAR2
19 ,x_return_status OUT NOCOPY VARCHAR2);
20
21
22 ----------------------------------------------------------------------
23 procedure UPDATE_ROW (
24 p_rowid ROWID
25 ,p_proposal_id NUMBER
26 ,p_version_id NUMBER
27 ,p_budget_period_id NUMBER
28 ,p_start_date DATE
29 ,p_end_date DATE
30 ,p_total_cost NUMBER
31 ,p_total_direct_cost NUMBER
32 ,p_total_indirect_cost NUMBER
33 ,p_cost_sharing_amount NUMBER
34 ,p_underrecovery_amount NUMBER
35 ,p_total_cost_limit NUMBER
36 ,p_program_income VARCHAR2
37 ,p_program_income_source VARCHAR2
38 ,p_record_version_number NUMBER
39 ,x_return_status OUT NOCOPY VARCHAR2);
40 -----------------------------------------------------------------------
41
42 procedure DELETE_ROW (
43 p_rowid IN ROWID
44 ,p_proposal_id IN NUMBER
45 ,p_version_id IN NUMBER
46 ,p_budget_period_id IN NUMBER
47 ,p_record_version_number IN NUMBER
48 ,x_return_status OUT NOCOPY VARCHAR2);
49
50
51 END IGW_BUDGET_PERIODS_TBH;
[Home] [Help]