1 PACKAGE IGW_BUDGET_PERSONNEL_TBH AUTHID CURRENT_USER as
2 --$Header: igwtbpds.pls 115.4 2002/11/14 18:42:24 vmedikon ship $
3 G_package_name VARCHAR2(30) := 'IGW_BUDGET_PERSONNEL_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_budget_personnel_detail_id NUMBER
10 ,p_person_id NUMBER
11 ,p_party_id NUMBER
12 ,p_start_date DATE
13 ,p_end_date DATE
14 ,p_period_type_code VARCHAR2
15 ,p_appointment_type_code VARCHAR2
16 ,p_salary_requested NUMBER
17 ,p_percent_charged NUMBER
18 ,p_percent_effort NUMBER
19 ,p_cost_sharing_percent NUMBER
20 ,p_cost_sharing_amount NUMBER
21 ,p_underrecovery_amount NUMBER
22 ,x_rowid OUT NOCOPY VARCHAR2
23 ,x_return_status OUT NOCOPY VARCHAR2);
24
25
26 ----------------------------------------------------------------------
27 procedure UPDATE_ROW (
28 p_rowid ROWID
29 ,p_proposal_id NUMBER
30 ,p_version_id NUMBER
31 ,p_budget_period_id NUMBER
32 ,p_line_item_id NUMBER
33 ,p_budget_personnel_detail_id NUMBER
34 ,p_person_id NUMBER
35 ,p_party_id NUMBER
36 ,p_start_date DATE
37 ,p_end_date DATE
38 ,p_period_type_code VARCHAR2
39 ,p_appointment_type_code VARCHAR2
40 ,p_salary_requested NUMBER
41 ,p_percent_charged NUMBER
42 ,p_percent_effort NUMBER
43 ,p_cost_sharing_percent NUMBER
44 ,p_cost_sharing_amount NUMBER
45 ,p_underrecovery_amount NUMBER
46 ,p_record_version_number NUMBER
47 ,x_return_status OUT NOCOPY VARCHAR2);
48 -----------------------------------------------------------------------
49
50 procedure DELETE_ROW (
51 p_rowid IN ROWID
52 ,p_budget_personnel_detail_id NUMBER
53 ,p_proposal_id IN NUMBER
54 ,p_version_id IN NUMBER
55 ,p_budget_period_id IN NUMBER
56 ,p_line_item_id NUMBER
57 ,p_person_id NUMBER
58 ,p_party_id NUMBER
59 ,p_record_version_number IN NUMBER
60 ,x_return_status OUT NOCOPY VARCHAR2);
61
62
63 END IGW_BUDGET_PERSONNEL_TBH;