1 PACKAGE HZ_PARTY_SITE_USES_PKG AUTHID CURRENT_USER AS
2 /*$Header: ARHPSUTS.pls 115.6 2002/11/21 19:42:04 sponnamb ship $ */
3
4 PROCEDURE Insert_Row (
5 X_PARTY_SITE_USE_ID IN OUT NOCOPY NUMBER,
6 X_COMMENTS IN VARCHAR2,
7 X_PARTY_SITE_ID IN NUMBER,
8 X_SITE_USE_TYPE IN VARCHAR2,
9 X_PRIMARY_PER_TYPE IN VARCHAR2,
10 X_STATUS IN VARCHAR2,
11 X_OBJECT_VERSION_NUMBER IN NUMBER,
12 X_CREATED_BY_MODULE IN VARCHAR2,
13 X_APPLICATION_ID IN NUMBER
14 );
15
16 PROCEDURE Update_Row (
17 X_Rowid IN OUT NOCOPY VARCHAR2,
18 X_PARTY_SITE_USE_ID IN NUMBER,
19 X_COMMENTS IN VARCHAR2,
20 X_PARTY_SITE_ID IN NUMBER,
21 X_SITE_USE_TYPE IN VARCHAR2,
22 X_PRIMARY_PER_TYPE IN VARCHAR2,
23 X_STATUS IN VARCHAR2,
24 X_OBJECT_VERSION_NUMBER IN NUMBER,
25 X_CREATED_BY_MODULE IN VARCHAR2,
26 X_APPLICATION_ID IN NUMBER
27 );
28
29 PROCEDURE Lock_Row (
30 X_Rowid IN OUT NOCOPY VARCHAR2,
31 X_PARTY_SITE_USE_ID IN NUMBER,
32 X_COMMENTS IN VARCHAR2,
33 X_PARTY_SITE_ID IN NUMBER,
34 X_LAST_UPDATE_DATE IN DATE,
35 X_REQUEST_ID IN NUMBER,
36 X_LAST_UPDATED_BY IN NUMBER,
37 X_PROGRAM_APPLICATION_ID IN NUMBER,
38 X_CREATION_DATE IN DATE,
39 X_PROGRAM_ID IN NUMBER,
40 X_CREATED_BY IN NUMBER,
41 X_PROGRAM_UPDATE_DATE IN DATE,
42 X_LAST_UPDATE_LOGIN IN NUMBER,
43 X_SITE_USE_TYPE IN VARCHAR2,
44 X_PRIMARY_PER_TYPE IN VARCHAR2,
45 X_STATUS IN VARCHAR2,
46 X_OBJECT_VERSION_NUMBER IN NUMBER,
47 X_CREATED_BY_MODULE IN VARCHAR2,
48 X_APPLICATION_ID IN NUMBER
49 );
50
51 PROCEDURE Select_Row (
52 X_PARTY_SITE_USE_ID IN OUT NOCOPY NUMBER,
53 X_COMMENTS OUT NOCOPY VARCHAR2,
54 X_PARTY_SITE_ID OUT NOCOPY NUMBER,
55 X_SITE_USE_TYPE OUT NOCOPY VARCHAR2,
56 X_PRIMARY_PER_TYPE OUT NOCOPY VARCHAR2,
57 X_STATUS OUT NOCOPY VARCHAR2,
58 X_CREATED_BY_MODULE OUT NOCOPY VARCHAR2,
59 X_APPLICATION_ID OUT NOCOPY NUMBER
60 );
61
62 PROCEDURE Delete_Row (
63 X_PARTY_SITE_USE_ID IN NUMBER
64 );
65
66 END HZ_PARTY_SITE_USES_PKG;