1 PACKAGE HZ_PERSON_INTEREST_PKG AUTHID CURRENT_USER as
2 /* $Header: ARHPINTS.pls 115.4 2003/02/10 09:48:04 ssmohan ship $ */
3
4 PROCEDURE Insert_Row(
5 x_PERSON_INTEREST_ID IN OUT NOCOPY NUMBER,
6 x_LEVEL_OF_INTEREST IN VARCHAR2,
7 x_PARTY_ID IN NUMBER,
8 x_LEVEL_OF_PARTICIPATION IN VARCHAR2,
9 x_INTEREST_TYPE_CODE IN VARCHAR2,
10 x_SPORT_INDICATOR IN VARCHAR2,
11 x_INTEREST_NAME IN VARCHAR2,
12 x_COMMENTS IN VARCHAR2,
13 x_SUB_INTEREST_TYPE_CODE IN VARCHAR2,
14 x_TEAM IN VARCHAR2,
15 x_SINCE IN DATE,
16 x_OBJECT_VERSION_NUMBER IN NUMBER,
17 x_STATUS IN VARCHAR2,
18 x_CREATED_BY_MODULE IN VARCHAR2,
19 x_APPLICATION_ID IN NUMBER
20 );
21
22
23
24 PROCEDURE Lock_Row(
25 x_Rowid IN VARCHAR2,
26 x_PERSON_INTEREST_ID IN NUMBER,
27 x_LEVEL_OF_INTEREST IN VARCHAR2,
28 x_PARTY_ID IN NUMBER,
29 x_LEVEL_OF_PARTICIPATION IN VARCHAR2,
30 x_INTEREST_TYPE_CODE IN VARCHAR2,
31 x_SPORT_INDICATOR IN VARCHAR2,
32 x_INTEREST_NAME IN VARCHAR2,
33 x_CREATED_BY IN NUMBER,
34 x_CREATION_DATE IN DATE,
35 x_LAST_UPDATE_LOGIN IN NUMBER,
36 x_LAST_UPDATE_DATE IN DATE,
37 x_LAST_UPDATED_BY IN NUMBER,
38 x_REQUEST_ID IN NUMBER,
39 x_PROGRAM_APPLICATION_ID IN NUMBER,
40 x_PROGRAM_ID IN NUMBER,
41 x_PROGRAM_UPDATE_DATE IN DATE,
42 x_COMMENTS IN VARCHAR2,
43 x_SUB_INTEREST_TYPE_CODE IN VARCHAR2,
44 x_TEAM IN VARCHAR2,
45 x_SINCE IN DATE,
46 x_STATUS IN VARCHAR2,
47 x_CREATED_BY_MODULE IN VARCHAR2
48 );
49
50
51
52 PROCEDURE Update_Row(
53 x_Rowid IN OUT NOCOPY VARCHAR2,
54 x_PERSON_INTEREST_ID IN NUMBER,
55 x_LEVEL_OF_INTEREST IN VARCHAR2,
56 x_PARTY_ID IN NUMBER,
57 x_LEVEL_OF_PARTICIPATION IN VARCHAR2,
58 x_INTEREST_TYPE_CODE IN VARCHAR2,
59 x_SPORT_INDICATOR IN VARCHAR2,
60 x_INTEREST_NAME IN VARCHAR2,
61 x_COMMENTS IN VARCHAR2,
62 x_SUB_INTEREST_TYPE_CODE IN VARCHAR2,
63 x_TEAM IN VARCHAR2,
64 x_SINCE IN DATE,
65 x_OBJECT_VERSION_NUMBER IN NUMBER,
66 x_STATUS IN VARCHAR2,
67 x_CREATED_BY_MODULE IN VARCHAR2,
68 x_APPLICATION_ID IN NUMBER
69 );
70
71
72
73 PROCEDURE Delete_Row( x_PERSON_INTEREST_ID NUMBER);
74
75
76 PROCEDURE Select_Row (
77 x_person_interest_id IN OUT NOCOPY NUMBER,
78 x_level_of_interest OUT NOCOPY VARCHAR2,
79 x_party_id OUT NOCOPY NUMBER,
80 x_level_of_participation OUT NOCOPY VARCHAR2,
81 x_interest_type_code OUT NOCOPY VARCHAR2,
82 x_comments OUT NOCOPY VARCHAR2,
83 x_sport_indicator OUT NOCOPY VARCHAR2,
84 x_sub_interest_type_code OUT NOCOPY VARCHAR2,
85 x_interest_name OUT NOCOPY VARCHAR2,
86 x_team OUT NOCOPY VARCHAR2,
87 x_since OUT NOCOPY DATE,
88 x_status OUT NOCOPY VARCHAR2,
89 x_application_id OUT NOCOPY NUMBER,
90 x_created_by_module OUT NOCOPY VARCHAR2
91 );
92
93
94
95 END HZ_PERSON_INTEREST_PKG;