eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.AMV_C_CHANNELS_PKG

Source


1 package AMV_C_CHANNELS_PKG AUTHID CURRENT_USER as
2 /* $Header: amvtchas.pls 120.1 2005/06/22 17:00:46 appldev ship $ */
3 procedure LOAD_ROW (
4   X_CHANNEL_ID in VARCHAR2,
5   X_OBJECT_VERSION_NUMBER in VARCHAR2,
6   X_CHANNEL_TYPE in VARCHAR2,
7   X_CHANNEL_CATEGORY_ID in VARCHAR2,
8   X_STATUS in VARCHAR2,
9   X_OWNER_USER_ID in VARCHAR2,
10   X_DEFAULT_APPROVER_USER_ID in VARCHAR2,
11   X_EFFECTIVE_START_DATE in VARCHAR2,
12   X_EXPIRATION_DATE in VARCHAR2,
13   X_ACCESS_LEVEL_TYPE in VARCHAR2,
14   X_PUB_NEED_APPROVAL_FLAG in VARCHAR2,
15   X_SUB_NEED_APPROVAL_FLAG in VARCHAR2,
16   X_MATCH_ON_ALL_CRITERIA_FLAG in VARCHAR2,
17   X_MATCH_ON_KEYWORD_FLAG in VARCHAR2,
18   X_MATCH_ON_AUTHOR_FLAG in VARCHAR2,
19   X_MATCH_ON_PERSPECTIVE_FLAG in VARCHAR2,
20   X_MATCH_ON_ITEM_TYPE_FLAG in VARCHAR2,
21   X_MATCH_ON_CONTENT_TYPE_FLAG in VARCHAR2,
22   X_MATCH_ON_TIME_FLAG in VARCHAR2,
23   X_APPLICATION_ID in VARCHAR2,
24   X_EXTERNAL_ACCESS_FLAG in VARCHAR2,
25   X_ITEM_MATCH_COUNT in VARCHAR2,
26   X_LAST_MATCH_TIME in VARCHAR2,
27   X_NOTIFICATION_INTERVAL_TYPE in VARCHAR2,
28   X_LAST_NOTIFICATION_TIME in VARCHAR2,
29   X_ATTRIBUTE_CATEGORY in VARCHAR2,
30   X_ATTRIBUTE1 in VARCHAR2,
31   X_ATTRIBUTE2 in VARCHAR2,
32   X_ATTRIBUTE3 in VARCHAR2,
33   X_ATTRIBUTE4 in VARCHAR2,
34   X_ATTRIBUTE5 in VARCHAR2,
35   X_ATTRIBUTE6 in VARCHAR2,
36   X_ATTRIBUTE7 in VARCHAR2,
37   X_ATTRIBUTE8 in VARCHAR2,
38   X_ATTRIBUTE9 in VARCHAR2,
39   X_ATTRIBUTE10 in VARCHAR2,
40   X_ATTRIBUTE11 in VARCHAR2,
41   X_ATTRIBUTE12 in VARCHAR2,
42   X_ATTRIBUTE13 in VARCHAR2,
43   X_ATTRIBUTE14 in VARCHAR2,
44   X_ATTRIBUTE15 in VARCHAR2,
45   X_CHANNEL_NAME in VARCHAR2,
46   X_DESCRIPTION in VARCHAR2,
47   X_OWNER in VARCHAR2);
48 procedure TRANSLATE_ROW (
49   X_CHANNEL_ID in NUMBER,
50   X_CHANNEL_NAME in VARCHAR2,
51   X_DESCRIPTION in VARCHAR2,
52   X_OWNER in VARCHAR2);
53 procedure INSERT_ROW (
54   X_ROWID in OUT NOCOPY  VARCHAR2,
55   X_CHANNEL_ID in NUMBER,
56   X_OBJECT_VERSION_NUMBER in NUMBER,
57   X_CHANNEL_TYPE in VARCHAR2,
58   X_CHANNEL_CATEGORY_ID in NUMBER,
59   X_STATUS in VARCHAR2,
60   X_OWNER_USER_ID in NUMBER,
61   X_DEFAULT_APPROVER_USER_ID in NUMBER,
62   X_EFFECTIVE_START_DATE in DATE,
63   X_EXPIRATION_DATE in DATE,
64   X_ACCESS_LEVEL_TYPE in VARCHAR2,
65   X_PUB_NEED_APPROVAL_FLAG in VARCHAR2,
66   X_SUB_NEED_APPROVAL_FLAG in VARCHAR2,
67   X_MATCH_ON_ALL_CRITERIA_FLAG in VARCHAR2,
68   X_MATCH_ON_KEYWORD_FLAG in VARCHAR2,
69   X_MATCH_ON_AUTHOR_FLAG in VARCHAR2,
70   X_MATCH_ON_PERSPECTIVE_FLAG in VARCHAR2,
71   X_MATCH_ON_ITEM_TYPE_FLAG in VARCHAR2,
72   X_MATCH_ON_CONTENT_TYPE_FLAG in VARCHAR2,
73   X_MATCH_ON_TIME_FLAG in VARCHAR2,
74   X_APPLICATION_ID in NUMBER,
75   X_EXTERNAL_ACCESS_FLAG in VARCHAR2,
76   X_ITEM_MATCH_COUNT in NUMBER,
77   X_LAST_MATCH_TIME in DATE,
78   X_NOTIFICATION_INTERVAL_TYPE in VARCHAR2,
79   X_LAST_NOTIFICATION_TIME in DATE,
80   X_ATTRIBUTE_CATEGORY in VARCHAR2,
81   X_ATTRIBUTE1 in VARCHAR2,
82   X_ATTRIBUTE2 in VARCHAR2,
83   X_ATTRIBUTE3 in VARCHAR2,
84   X_ATTRIBUTE4 in VARCHAR2,
85   X_ATTRIBUTE5 in VARCHAR2,
86   X_ATTRIBUTE6 in VARCHAR2,
87   X_ATTRIBUTE7 in VARCHAR2,
88   X_ATTRIBUTE8 in VARCHAR2,
89   X_ATTRIBUTE9 in VARCHAR2,
90   X_ATTRIBUTE10 in VARCHAR2,
91   X_ATTRIBUTE11 in VARCHAR2,
92   X_ATTRIBUTE12 in VARCHAR2,
93   X_ATTRIBUTE13 in VARCHAR2,
94   X_ATTRIBUTE14 in VARCHAR2,
95   X_ATTRIBUTE15 in VARCHAR2,
96   X_CHANNEL_NAME in VARCHAR2,
97   X_DESCRIPTION in VARCHAR2,
98   X_CREATION_DATE in DATE,
99   X_CREATED_BY in NUMBER,
100   X_LAST_UPDATE_DATE in DATE,
101   X_LAST_UPDATED_BY in NUMBER,
102   X_LAST_UPDATE_LOGIN in NUMBER);
103 procedure LOCK_ROW (
104   X_CHANNEL_ID in NUMBER,
105   X_OBJECT_VERSION_NUMBER in NUMBER,
106   X_CHANNEL_TYPE in VARCHAR2,
107   X_CHANNEL_CATEGORY_ID in NUMBER,
108   X_STATUS in VARCHAR2,
109   X_OWNER_USER_ID in NUMBER,
110   X_DEFAULT_APPROVER_USER_ID in NUMBER,
111   X_EFFECTIVE_START_DATE in DATE,
112   X_EXPIRATION_DATE in DATE,
113   X_ACCESS_LEVEL_TYPE in VARCHAR2,
114   X_PUB_NEED_APPROVAL_FLAG in VARCHAR2,
115   X_SUB_NEED_APPROVAL_FLAG in VARCHAR2,
116   X_MATCH_ON_ALL_CRITERIA_FLAG in VARCHAR2,
117   X_MATCH_ON_KEYWORD_FLAG in VARCHAR2,
118   X_MATCH_ON_AUTHOR_FLAG in VARCHAR2,
119   X_MATCH_ON_PERSPECTIVE_FLAG in VARCHAR2,
120   X_MATCH_ON_ITEM_TYPE_FLAG in VARCHAR2,
121   X_MATCH_ON_CONTENT_TYPE_FLAG in VARCHAR2,
122   X_MATCH_ON_TIME_FLAG in VARCHAR2,
123   X_APPLICATION_ID in NUMBER,
124   X_EXTERNAL_ACCESS_FLAG in VARCHAR2,
125   X_ITEM_MATCH_COUNT in NUMBER,
126   X_LAST_MATCH_TIME in DATE,
127   X_NOTIFICATION_INTERVAL_TYPE in VARCHAR2,
128   X_LAST_NOTIFICATION_TIME in DATE,
129   X_ATTRIBUTE_CATEGORY in VARCHAR2,
130   X_ATTRIBUTE1 in VARCHAR2,
131   X_ATTRIBUTE2 in VARCHAR2,
132   X_ATTRIBUTE3 in VARCHAR2,
133   X_ATTRIBUTE4 in VARCHAR2,
134   X_ATTRIBUTE5 in VARCHAR2,
135   X_ATTRIBUTE6 in VARCHAR2,
136   X_ATTRIBUTE7 in VARCHAR2,
137   X_ATTRIBUTE8 in VARCHAR2,
138   X_ATTRIBUTE9 in VARCHAR2,
139   X_ATTRIBUTE10 in VARCHAR2,
140   X_ATTRIBUTE11 in VARCHAR2,
141   X_ATTRIBUTE12 in VARCHAR2,
142   X_ATTRIBUTE13 in VARCHAR2,
143   X_ATTRIBUTE14 in VARCHAR2,
144   X_ATTRIBUTE15 in VARCHAR2,
145   X_CHANNEL_NAME in VARCHAR2,
146   X_DESCRIPTION in VARCHAR2
147 );
148 procedure UPDATE_ROW (
149   X_CHANNEL_ID in NUMBER,
150   X_OBJECT_VERSION_NUMBER in NUMBER,
151   X_CHANNEL_TYPE in VARCHAR2,
152   X_CHANNEL_CATEGORY_ID in NUMBER,
153   X_STATUS in VARCHAR2,
154   X_OWNER_USER_ID in NUMBER,
155   X_DEFAULT_APPROVER_USER_ID in NUMBER,
156   X_EFFECTIVE_START_DATE in DATE,
157   X_EXPIRATION_DATE in DATE,
158   X_ACCESS_LEVEL_TYPE in VARCHAR2,
159   X_PUB_NEED_APPROVAL_FLAG in VARCHAR2,
160   X_SUB_NEED_APPROVAL_FLAG in VARCHAR2,
161   X_MATCH_ON_ALL_CRITERIA_FLAG in VARCHAR2,
162   X_MATCH_ON_KEYWORD_FLAG in VARCHAR2,
163   X_MATCH_ON_AUTHOR_FLAG in VARCHAR2,
164   X_MATCH_ON_PERSPECTIVE_FLAG in VARCHAR2,
165   X_MATCH_ON_ITEM_TYPE_FLAG in VARCHAR2,
166   X_MATCH_ON_CONTENT_TYPE_FLAG in VARCHAR2,
167   X_MATCH_ON_TIME_FLAG in VARCHAR2,
168   X_APPLICATION_ID in NUMBER,
169   X_EXTERNAL_ACCESS_FLAG in VARCHAR2,
170   X_ITEM_MATCH_COUNT in NUMBER,
171   X_LAST_MATCH_TIME in DATE,
172   X_NOTIFICATION_INTERVAL_TYPE in VARCHAR2,
173   X_LAST_NOTIFICATION_TIME in DATE,
174   X_ATTRIBUTE_CATEGORY in VARCHAR2,
175   X_ATTRIBUTE1 in VARCHAR2,
176   X_ATTRIBUTE2 in VARCHAR2,
177   X_ATTRIBUTE3 in VARCHAR2,
178   X_ATTRIBUTE4 in VARCHAR2,
179   X_ATTRIBUTE5 in VARCHAR2,
180   X_ATTRIBUTE6 in VARCHAR2,
181   X_ATTRIBUTE7 in VARCHAR2,
182   X_ATTRIBUTE8 in VARCHAR2,
183   X_ATTRIBUTE9 in VARCHAR2,
184   X_ATTRIBUTE10 in VARCHAR2,
185   X_ATTRIBUTE11 in VARCHAR2,
186   X_ATTRIBUTE12 in VARCHAR2,
187   X_ATTRIBUTE13 in VARCHAR2,
188   X_ATTRIBUTE14 in VARCHAR2,
189   X_ATTRIBUTE15 in VARCHAR2,
190   X_CHANNEL_NAME in VARCHAR2,
191   X_DESCRIPTION in VARCHAR2,
192   X_LAST_UPDATE_DATE in DATE,
193   X_LAST_UPDATED_BY in NUMBER,
194   X_LAST_UPDATE_LOGIN in NUMBER
195 );
196 procedure DELETE_ROW (
197   X_CHANNEL_ID in NUMBER
198 );
199 procedure ADD_LANGUAGE;
200 end AMV_C_CHANNELS_PKG;