1 PACKAGE HZ_CONTACT_PREFERENCES_PKG AUTHID CURRENT_USER AS
2 /*$Header: ARH2CTTS.pls 115.1 2002/11/21 05:19:54 sponnamb noship $ */
3
4 PROCEDURE Insert_Row (
5 X_Rowid IN OUT NOCOPY VARCHAR2,
6 X_CONTACT_PREFERENCE_ID IN OUT NOCOPY NUMBER,
7 X_CONTACT_LEVEL_TABLE IN VARCHAR2,
8 X_CONTACT_LEVEL_TABLE_ID IN NUMBER,
9 X_CONTACT_TYPE IN VARCHAR2,
10 X_PREFERENCE_CODE IN VARCHAR2,
11 X_PREFERENCE_TOPIC_TYPE IN VARCHAR2,
12 X_PREFERENCE_TOPIC_TYPE_ID IN NUMBER,
13 X_PREFERENCE_TOPIC_TYPE_CODE IN VARCHAR2,
14 X_PREFERENCE_START_DATE IN DATE,
15 X_PREFERENCE_END_DATE IN DATE,
16 X_PREFERENCE_START_TIME_HR IN NUMBER,
17 X_PREFERENCE_END_TIME_HR IN NUMBER,
18 X_PREFERENCE_START_TIME_MI IN NUMBER,
19 X_PREFERENCE_END_TIME_MI IN NUMBER,
20 X_MAX_NO_OF_INTERACTIONS IN NUMBER,
21 X_MAX_NO_OF_INTERACT_UOM_CODE IN VARCHAR2,
22 X_REQUESTED_BY IN VARCHAR2,
23 X_REASON_CODE IN VARCHAR2,
24 X_STATUS IN VARCHAR2,
25 X_OBJECT_VERSION_NUMBER IN NUMBER,
26 X_CREATED_BY_MODULE IN VARCHAR2,
27 X_APPLICATION_ID IN NUMBER
28 );
29
30 PROCEDURE Update_Row (
31 X_Rowid IN OUT NOCOPY VARCHAR2,
32 X_CONTACT_PREFERENCE_ID IN NUMBER,
33 X_CONTACT_LEVEL_TABLE IN VARCHAR2,
34 X_CONTACT_LEVEL_TABLE_ID IN NUMBER,
35 X_CONTACT_TYPE IN VARCHAR2,
36 X_PREFERENCE_CODE IN VARCHAR2,
37 X_PREFERENCE_TOPIC_TYPE IN VARCHAR2,
38 X_PREFERENCE_TOPIC_TYPE_ID IN NUMBER,
39 X_PREFERENCE_TOPIC_TYPE_CODE IN VARCHAR2,
40 X_PREFERENCE_START_DATE IN DATE,
41 X_PREFERENCE_END_DATE IN DATE,
42 X_PREFERENCE_START_TIME_HR IN NUMBER,
43 X_PREFERENCE_END_TIME_HR IN NUMBER,
44 X_PREFERENCE_START_TIME_MI IN NUMBER,
45 X_PREFERENCE_END_TIME_MI IN NUMBER,
46 X_MAX_NO_OF_INTERACTIONS IN NUMBER,
47 X_MAX_NO_OF_INTERACT_UOM_CODE IN VARCHAR2,
48 X_REQUESTED_BY IN VARCHAR2,
49 X_REASON_CODE IN VARCHAR2,
50 X_STATUS IN VARCHAR2,
51 X_OBJECT_VERSION_NUMBER IN NUMBER,
52 X_CREATED_BY_MODULE IN VARCHAR2,
53 X_APPLICATION_ID IN NUMBER
54 );
55
56 PROCEDURE Lock_Row (
57 X_Rowid IN OUT NOCOPY VARCHAR2,
58 X_CONTACT_PREFERENCE_ID IN NUMBER,
59 X_CONTACT_LEVEL_TABLE IN VARCHAR2,
60 X_CONTACT_LEVEL_TABLE_ID IN NUMBER,
61 X_CONTACT_TYPE IN VARCHAR2,
62 X_PREFERENCE_CODE IN VARCHAR2,
63 X_PREFERENCE_TOPIC_TYPE IN VARCHAR2,
64 X_PREFERENCE_TOPIC_TYPE_ID IN NUMBER,
65 X_PREFERENCE_TOPIC_TYPE_CODE IN VARCHAR2,
66 X_PREFERENCE_START_DATE IN DATE,
67 X_PREFERENCE_END_DATE IN DATE,
68 X_PREFERENCE_START_TIME_HR IN NUMBER,
69 X_PREFERENCE_END_TIME_HR IN NUMBER,
70 X_PREFERENCE_START_TIME_MI IN NUMBER,
71 X_PREFERENCE_END_TIME_MI IN NUMBER,
72 X_MAX_NO_OF_INTERACTIONS IN NUMBER,
73 X_MAX_NO_OF_INTERACT_UOM_CODE IN VARCHAR2,
74 X_REQUESTED_BY IN VARCHAR2,
75 X_REASON_CODE IN VARCHAR2,
76 X_CREATED_BY IN NUMBER,
77 X_CREATION_DATE IN DATE,
78 X_LAST_UPDATE_LOGIN IN NUMBER,
79 X_LAST_UPDATE_DATE IN DATE,
80 X_LAST_UPDATED_BY IN NUMBER,
81 X_REQUEST_ID IN NUMBER,
82 X_PROGRAM_APPLICATION_ID IN NUMBER,
83 X_PROGRAM_ID IN NUMBER,
84 X_PROGRAM_UPDATE_DATE IN DATE,
85 X_STATUS IN VARCHAR2,
86 X_OBJECT_VERSION_NUMBER IN NUMBER,
87 X_CREATED_BY_MODULE IN VARCHAR2,
88 X_APPLICATION_ID IN NUMBER
89 );
90
91 PROCEDURE Select_Row (
92 X_CONTACT_PREFERENCE_ID IN OUT NOCOPY NUMBER,
93 X_CONTACT_LEVEL_TABLE OUT NOCOPY VARCHAR2,
94 X_CONTACT_LEVEL_TABLE_ID OUT NOCOPY NUMBER,
95 X_CONTACT_TYPE OUT NOCOPY VARCHAR2,
96 X_PREFERENCE_CODE OUT NOCOPY VARCHAR2,
97 X_PREFERENCE_TOPIC_TYPE OUT NOCOPY VARCHAR2,
98 X_PREFERENCE_TOPIC_TYPE_ID OUT NOCOPY NUMBER,
99 X_PREFERENCE_TOPIC_TYPE_CODE OUT NOCOPY VARCHAR2,
100 X_PREFERENCE_START_DATE OUT NOCOPY DATE,
101 X_PREFERENCE_END_DATE OUT NOCOPY DATE,
102 X_PREFERENCE_START_TIME_HR OUT NOCOPY NUMBER,
103 X_PREFERENCE_END_TIME_HR OUT NOCOPY NUMBER,
104 X_PREFERENCE_START_TIME_MI OUT NOCOPY NUMBER,
105 X_PREFERENCE_END_TIME_MI OUT NOCOPY NUMBER,
106 X_MAX_NO_OF_INTERACTIONS OUT NOCOPY NUMBER,
107 X_MAX_NO_OF_INTERACT_UOM_CODE OUT NOCOPY VARCHAR2,
108 X_REQUESTED_BY OUT NOCOPY VARCHAR2,
109 X_REASON_CODE OUT NOCOPY VARCHAR2,
110 X_STATUS OUT NOCOPY VARCHAR2,
111 X_CREATED_BY_MODULE OUT NOCOPY VARCHAR2,
112 X_APPLICATION_ID OUT NOCOPY NUMBER
113 );
114
115 PROCEDURE Delete_Row (
116 X_CONTACT_PREFERENCE_ID IN NUMBER
117 );
118
119 END HZ_CONTACT_PREFERENCES_PKG;