1 PACKAGE ICX_POR_ITEM_SOURCES_PKG AUTHID CURRENT_USER AS
2 /* $Header: ICXSRCS.pls 115.4 2004/03/31 18:47:17 vkartik ship $ */
3
4 procedure INSERT_ROW (
5 X_ROWID in out NOCOPY VARCHAR2,
6 X_ITEM_SOURCE_ID in NUMBER,
7 X_TYPE in VARCHAR2,
8 X_PROTOCOL_SUPPORTED in VARCHAR2,
9 X_URL in VARCHAR2,
10 X_IMAGE_URL in VARCHAR2,
11 X_ITEM_SOURCE_NAME in VARCHAR2,
12 X_DESCRIPTION in VARCHAR2,
13 X_CREATION_DATE in DATE,
14 X_CREATED_BY in NUMBER,
15 X_LAST_UPDATE_DATE in DATE,
16 X_LAST_UPDATED_BY in NUMBER,
17 X_LAST_UPDATE_LOGIN in NUMBER);
18
19 procedure UPDATE_ROW (
20 X_ITEM_SOURCE_ID in NUMBER,
21 X_TYPE in VARCHAR2,
22 X_PROTOCOL_SUPPORTED in VARCHAR2,
23 X_URL in VARCHAR2,
24 X_IMAGE_URL in VARCHAR2,
25 X_ITEM_SOURCE_NAME in VARCHAR2,
26 X_DESCRIPTION in VARCHAR2,
27 X_LAST_UPDATE_DATE in DATE,
28 X_LAST_UPDATED_BY in NUMBER,
29 X_LAST_UPDATE_LOGIN in NUMBER);
30
31 procedure TRANSLATE_ROW(
32 X_ITEM_SOURCE_ID in VARCHAR2,
33 X_OWNER in VARCHAR2,
34 X_ITEM_SOURCE_NAME in VARCHAR2,
35 X_DESCRIPTION in VARCHAR2,
36 X_CUSTOM_MODE in VARCHAR2,
37 X_LAST_UPDATE_DATE in VARCHAR2);
38
39 procedure LOAD_ROW(
40 X_ITEM_SOURCE_ID in VARCHAR2,
41 X_OWNER in VARCHAR2,
42 X_ITEM_SOURCE_NAME in VARCHAR2,
43 X_DESCRIPTION in VARCHAR2,
44 X_TYPE in VARCHAR2,
45 X_PROTOCOL_SUPPORTED in VARCHAR2,
46 X_URL in VARCHAR2,
47 X_IMAGE_URL in VARCHAR2,
48 X_CUSTOM_MODE in VARCHAR2,
49 X_LAST_UPDATE_DATE in VARCHAR2);
50
51 procedure ADD_LANGUAGE;
52
53 end ICX_POR_ITEM_SOURCES_PKG;