[Home] [Help]
PACKAGE: APPS.IGW_PROP_RATES_TBH
Source
1 PACKAGE IGW_PROP_RATES_TBH AUTHID CURRENT_USER as
2 -- $Header: igwtprts.pls 115.3 2002/11/15 00:44:57 ashkumar ship $
3 G_package_name VARCHAR2(30) := 'IGW_PROP_RATES_TBH';
4 procedure INSERT_ROW (
5 p_proposal_id NUMBER
6 ,p_version_id NUMBER
7 ,p_rate_class_id NUMBER
8 ,p_rate_type_id NUMBER
9 ,p_fiscal_year VARCHAR2
10 ,p_location_code VARCHAR2
11 ,p_activity_type_code VARCHAR2
12 ,p_start_date DATE
13 ,p_applicable_rate NUMBER
14 ,p_institute_rate NUMBER
15 ,x_rowid OUT NOCOPY VARCHAR2
16 ,x_return_status OUT NOCOPY VARCHAR2);
17
18
19 ----------------------------------------------------------------------
20 procedure UPDATE_ROW (
21 p_proposal_id NUMBER
22 ,p_version_id NUMBER
23 ,p_rate_class_id NUMBER
24 ,p_rate_type_id NUMBER
25 ,p_fiscal_year VARCHAR2
26 ,p_location_code VARCHAR2
27 ,p_activity_type_code VARCHAR2
28 ,p_start_date DATE
29 ,p_applicable_rate NUMBER
30 ,p_institute_rate NUMBER
31 ,p_rowid VARCHAR2
32 ,p_record_version_number NUMBER
33 ,x_return_status OUT NOCOPY VARCHAR2);
34
35
36 -----------------------------------------------------------------------
37
38 procedure DELETE_ROW (
39 p_rowid IN ROWID
40 ,p_proposal_id NUMBER
41 ,p_version_id NUMBER
42 ,p_rate_class_id NUMBER
43 ,p_rate_type_id NUMBER
44 ,p_fiscal_year VARCHAR2
45 ,p_location_code VARCHAR2
46 ,p_activity_type_code VARCHAR2
47 ,p_start_date DATE
48 ,p_applicable_rate NUMBER
49 ,p_institute_rate NUMBER
50 ,p_record_version_number IN NUMBER
51 ,x_return_status OUT NOCOPY VARCHAR2);
52
53
54 END IGW_PROP_RATES_TBH;