1 PACKAGE IGW_PROP_PERSON_SUPPORT_TBH AUTHID CURRENT_USER as
2 --$Header: igwtppss.pls 115.5 2002/11/15 00:43:21 ashkumar ship $
3
4 PROCEDURE INSERT_ROW (
5 x_rowid out NOCOPY VARCHAR2,
6 X_PROP_PERSON_SUPPORT_ID OUT NOCOPY NUMBER,
7 P_PROPOSAL_ID IN NUMBER,
8 P_PERSON_ID IN NUMBER,
9 P_PARTY_ID IN NUMBER,
10 P_SUPPORT_TYPE IN VARCHAR2,
11 P_PROPOSAL_AWARD_ID IN NUMBER,
12 P_PROPOSAL_AWARD_NUMBER IN VARCHAR2,
13 P_PROPOSAL_AWARD_TITLE IN VARCHAR2,
14 P_PI_PERSON_ID IN NUMBER,
15 P_PI_PARTY_ID IN NUMBER,
16 P_SPONSOR_ID IN NUMBER,
17 P_PROJECT_LOCATION IN VARCHAR2,
18 P_LOCATION_PARTY_ID IN NUMBER,
19 P_START_DATE IN DATE,
20 P_END_DATE IN DATE,
21 P_PERCENT_EFFORT IN NUMBER,
22 P_MAJOR_GOALS IN VARCHAR2,
23 P_OVERLAP IN VARCHAR2,
24 P_ANNUAL_DIRECT_COST IN NUMBER,
25 P_TOTAL_COST IN NUMBER,
26 P_CALENDAR_START_DATE IN DATE,
27 P_CALENDAR_END_DATE IN DATE,
28 P_ACADEMIC_START_DATE IN DATE,
29 P_ACADEMIC_END_DATE IN DATE,
30 P_SUMMER_START_DATE IN DATE,
31 P_SUMMER_END_DATE IN DATE,
32 P_ATTRIBUTE_CATEGORY IN VARCHAR2,
33 P_ATTRIBUTE1 IN VARCHAR2,
34 P_ATTRIBUTE2 IN VARCHAR2,
35 P_ATTRIBUTE3 IN VARCHAR2,
36 P_ATTRIBUTE4 IN VARCHAR2,
37 P_ATTRIBUTE5 IN VARCHAR2,
38 P_ATTRIBUTE6 IN VARCHAR2,
39 P_ATTRIBUTE7 IN VARCHAR2,
40 P_ATTRIBUTE8 IN VARCHAR2,
41 P_ATTRIBUTE9 IN VARCHAR2,
42 P_ATTRIBUTE10 IN VARCHAR2,
43 P_ATTRIBUTE11 IN VARCHAR2,
44 P_ATTRIBUTE12 IN VARCHAR2,
45 P_ATTRIBUTE13 IN VARCHAR2,
46 P_ATTRIBUTE14 IN VARCHAR2,
47 P_ATTRIBUTE15 IN VARCHAR2,
48 p_mode IN VARCHAR2 default 'R',
49 p_sequence_number IN NUMBER,
50 x_return_status out NOCOPY VARCHAR2);
51
52
53 PROCEDURE UPDATE_ROW (
54 X_ROWID IN VARCHAR2,
55 P_PROP_PERSON_SUPPORT_ID IN NUMBER,
56 P_PROPOSAL_ID IN NUMBER,
57 P_PERSON_ID IN NUMBER,
58 P_PARTY_ID IN NUMBER,
59 P_SUPPORT_TYPE IN VARCHAR2,
60 P_PROPOSAL_AWARD_ID IN NUMBER,
61 P_PROPOSAL_AWARD_NUMBER IN VARCHAR2,
62 P_PROPOSAL_AWARD_TITLE IN VARCHAR2,
63 P_PI_PERSON_ID IN NUMBER,
64 P_PI_PARTY_ID IN NUMBER,
65 P_SPONSOR_ID IN NUMBER,
66 P_PROJECT_LOCATION IN VARCHAR2,
67 P_LOCATION_PARTY_ID IN NUMBER,
68 P_START_DATE IN DATE,
69 P_END_DATE IN DATE,
70 P_PERCENT_EFFORT IN NUMBER,
71 P_MAJOR_GOALS IN VARCHAR2,
72 P_OVERLAP IN VARCHAR2,
73 P_ANNUAL_DIRECT_COST IN NUMBER,
74 P_TOTAL_COST IN NUMBER,
75 P_CALENDAR_START_DATE IN DATE,
76 P_CALENDAR_END_DATE IN DATE,
77 P_ACADEMIC_START_DATE IN DATE,
78 P_ACADEMIC_END_DATE IN DATE,
79 P_SUMMER_START_DATE IN DATE,
80 P_SUMMER_END_DATE IN DATE,
81 P_ATTRIBUTE_CATEGORY IN VARCHAR2,
82 P_ATTRIBUTE1 IN VARCHAR2,
83 P_ATTRIBUTE2 IN VARCHAR2,
84 P_ATTRIBUTE3 IN VARCHAR2,
85 P_ATTRIBUTE4 IN VARCHAR2,
86 P_ATTRIBUTE5 IN VARCHAR2,
87 P_ATTRIBUTE6 IN VARCHAR2,
88 P_ATTRIBUTE7 IN VARCHAR2,
89 P_ATTRIBUTE8 IN VARCHAR2,
90 P_ATTRIBUTE9 IN VARCHAR2,
91 P_ATTRIBUTE10 IN VARCHAR2,
92 P_ATTRIBUTE11 IN VARCHAR2,
93 P_ATTRIBUTE12 IN VARCHAR2,
94 P_ATTRIBUTE13 IN VARCHAR2,
95 P_ATTRIBUTE14 IN VARCHAR2,
96 P_ATTRIBUTE15 IN VARCHAR2,
97 P_MODE IN VARCHAR2 default 'R',
98 P_RECORD_VERSION_NUMBER IN NUMBER,
99 P_SEQUENCE_NUMBER IN NUMBER,
100 X_RETURN_STATUS OUT NOCOPY VARCHAR2);
101
102
103 PROCEDURE DELETE_ROW (
104 x_rowid in VARCHAR2,
105 p_record_version_number in NUMBER,
106 x_return_status out NOCOPY VARCHAR2);
107
108
109 END IGW_PROP_PERSON_SUPPORT_TBH;