PACKAGE: APPS.IGW_BUDGETS_TBH

Source

1 PACKAGE IGW_BUDGETS_TBH AUTHID CURRENT_USER as
2 -- $Header: igwtbvss.pls 115.4 2002/11/14 18:39:01 vmedikon ship $
3 G_package_name   VARCHAR2(30)    := 'IGW_BUDGETS_TBH';
4   procedure INSERT_ROW (
5         p_proposal_id		NUMBER
6 	,p_version_id		NUMBER
7   	,p_start_date		DATE
8   	,p_end_date		DATE
9   	,p_total_cost		NUMBER
10   	,p_total_direct_cost	NUMBER
11 	,p_total_indirect_cost	NUMBER
12 	,p_cost_sharing_amount	NUMBER
13 	,p_underrecovery_amount	NUMBER
14 	,p_residual_funds	NUMBER
15 	,p_total_cost_limit	NUMBER
16 	,p_oh_rate_class_id	NUMBER
17 	,p_proposal_form_number VARCHAR2
18 	,p_comments		VARCHAR2
19 	,p_final_version_flag	VARCHAR2
20 	,p_budget_type_code	VARCHAR2
21         ,p_enter_budget_at_period_level   VARCHAR2
22         ,p_apply_inflation_setup_rates    VARCHAR2
23         ,p_apply_eb_setup_rates VARCHAR2
24         ,p_apply_oh_setup_rates VARCHAR2
25 	,p_attribute_category	VARCHAR2
26 	,p_attribute1		VARCHAR2
27 	,p_attribute2		VARCHAR2
28 	,p_attribute3		VARCHAR2
29 	,p_attribute4		VARCHAR2
30 	,p_attribute5		VARCHAR2
31 	,p_attribute6		VARCHAR2
32 	,p_attribute7		VARCHAR2
33 	,p_attribute8		VARCHAR2
34 	,p_attribute9		VARCHAR2
35 	,p_attribute10		VARCHAR2
36 	,p_attribute11		VARCHAR2
37 	,p_attribute12		VARCHAR2
38 	,p_attribute13		VARCHAR2
39 	,p_attribute14		VARCHAR2
40 	,p_attribute15  	VARCHAR2
41 	,x_rowid    	        OUT NOCOPY  VARCHAR2
42         ,x_return_status        OUT NOCOPY  VARCHAR2);
43 
44 
45 ----------------------------------------------------------------------
46   procedure UPDATE_ROW (
47   	p_rowid    	        VARCHAR2
48 	,p_proposal_id		NUMBER
49 	,p_version_id		NUMBER
50   	,p_start_date		DATE
51   	,p_end_date		DATE
52   	,p_total_cost		NUMBER
53   	,p_total_direct_cost	NUMBER
54 	,p_total_indirect_cost	NUMBER
55 	,p_cost_sharing_amount	NUMBER
56 	,p_underrecovery_amount	NUMBER
57 	,p_residual_funds	NUMBER
58 	,p_total_cost_limit	NUMBER
59 	,p_oh_rate_class_id	NUMBER
60 	,p_proposal_form_number VARCHAR2
61 	,p_comments		VARCHAR2
62 	,p_final_version_flag	VARCHAR2
63 	,p_budget_type_code	VARCHAR2
64         ,p_enter_budget_at_period_level   VARCHAR2
65         ,p_apply_inflation_setup_rates    VARCHAR2
66         ,p_apply_eb_setup_rates VARCHAR2
67         ,p_apply_oh_setup_rates VARCHAR2
68 	,p_attribute_category	VARCHAR2
69 	,p_attribute1		VARCHAR2
70 	,p_attribute2		VARCHAR2
71 	,p_attribute3		VARCHAR2
72 	,p_attribute4		VARCHAR2
73 	,p_attribute5		VARCHAR2
74 	,p_attribute6		VARCHAR2
75 	,p_attribute7		VARCHAR2
76 	,p_attribute8		VARCHAR2
77 	,p_attribute9		VARCHAR2
78 	,p_attribute10		VARCHAR2
79 	,p_attribute11		VARCHAR2
80 	,p_attribute12		VARCHAR2
81 	,p_attribute13		VARCHAR2
82 	,p_attribute14		VARCHAR2
83 	,p_attribute15  	VARCHAR2
84         ,p_record_version_number NUMBER
85         ,x_return_status   OUT NOCOPY  VARCHAR2);
86 -----------------------------------------------------------------------
87 
88 procedure DELETE_ROW (
89    p_rowid                        IN ROWID
90   ,p_proposal_id                  IN NUMBER
91   ,p_version_id                   IN NUMBER
92   ,p_record_version_number        IN NUMBER
93   ,x_return_status                OUT NOCOPY VARCHAR2);
94 
95 
96 END IGW_BUDGETS_TBH;