1 PACKAGE IGW_BUDGET_PERSONS_TBH AUTHID CURRENT_USER as
2 -- $Header: igwtbpss.pls 115.4 2002/11/14 18:43:14 vmedikon ship $
3 G_package_name VARCHAR2(30) := 'IGW_BUDGET_PERSONS_TBH';
4 procedure INSERT_ROW (
5 p_proposal_id NUMBER
6 ,p_version_id NUMBER
7 ,p_person_id NUMBER
8 ,p_party_id NUMBER
9 ,p_appointment_type_code VARCHAR2
10 ,p_effective_date DATE
11 ,p_calculation_base NUMBER
12 ,x_rowid OUT NOCOPY VARCHAR2
13 ,x_return_status OUT NOCOPY VARCHAR2);
14
15
16 ----------------------------------------------------------------------
17 procedure UPDATE_ROW (
18 p_proposal_id NUMBER
19 ,p_version_id NUMBER
20 ,p_person_id NUMBER
21 ,p_party_id NUMBER
22 ,p_appointment_type_code VARCHAR2
23 ,p_effective_date DATE
24 ,p_calculation_base NUMBER
25 ,p_rowid VARCHAR2
26 ,p_record_version_number NUMBER
27 ,x_return_status OUT NOCOPY VARCHAR2);
28
29
30 -----------------------------------------------------------------------
31
32 procedure DELETE_ROW (
33 p_rowid IN ROWID
34 ,p_proposal_id IN NUMBER
35 ,p_version_id IN NUMBER
36 ,p_person_id IN NUMBER
37 ,p_party_id NUMBER
38 ,p_record_version_number IN NUMBER
39 ,x_return_status OUT NOCOPY VARCHAR2);
40
41
42 END IGW_BUDGET_PERSONS_TBH;
[Home] [Help]