1 PACKAGE ICX_CAT_SHOP_STORES_PVT AS
2 /* $Header: ICXVSTRS.pls 120.1 2005/10/21 14:21:08 srmani noship $ */
3
4 PROCEDURE INSERT_ROW(X_ROWID IN OUT NOCOPY VARCHAR2,
5 X_STORE_ID IN NUMBER,
6 X_SEQUENCE IN NUMBER,
7 X_LOCAL_CONTENT_FIRST_FLAG IN VARCHAR2,
8 X_NAME IN VARCHAR2,
9 X_DESCRIPTION IN VARCHAR2,
10 X_LONG_DESCRIPTION IN VARCHAR2,
11 X_IMAGE IN VARCHAR2,
12 X_CREATION_DATE IN DATE,
13 X_CREATED_BY IN NUMBER,
14 X_LAST_UPDATE_DATE IN DATE,
15 X_LAST_UPDATED_BY IN NUMBER,
16 X_LAST_UPDATE_LOGIN IN NUMBER);
17
18 PROCEDURE UPDATE_ROW(X_STORE_ID IN NUMBER,
19 X_SEQUENCE IN NUMBER,
20 X_LOCAL_CONTENT_FIRST_FLAG IN VARCHAR2,
21 X_NAME IN VARCHAR2,
22 X_DESCRIPTION IN VARCHAR2,
23 X_LONG_DESCRIPTION IN VARCHAR2,
24 X_IMAGE IN VARCHAR2,
25 X_LAST_UPDATE_DATE IN DATE,
26 X_LAST_UPDATED_BY IN NUMBER,
27 X_LAST_UPDATE_LOGIN IN NUMBER);
28
29 PROCEDURE TRANSLATE_ROW(X_STORE_ID IN VARCHAR2,
30 X_OWNER IN VARCHAR2,
31 X_NAME IN VARCHAR2,
32 X_DESCRIPTION IN VARCHAR2,
33 X_LONG_DESCRIPTION IN VARCHAR2,
34 X_IMAGE IN VARCHAR2,
35 X_CUSTOM_MODE IN VARCHAR2,
36 X_LAST_UPDATE_DATE IN VARCHAR2);
37
38 PROCEDURE LOAD_ROW(X_STORE_ID IN VARCHAR2,
39 X_OWNER IN VARCHAR2,
40 X_SEQUENCE IN VARCHAR2,
41 X_LOCAL_CONTENT_FIRST_FLAG IN VARCHAR2,
42 X_NAME IN VARCHAR2,
43 X_DESCRIPTION IN VARCHAR2,
44 X_LONG_DESCRIPTION IN VARCHAR2,
45 X_IMAGE IN VARCHAR2,
46 X_CUSTOM_MODE IN VARCHAR2,
47 X_LAST_UPDATE_DATE IN VARCHAR2);
48
49 PROCEDURE ADD_LANGUAGE;
50
51 END ICX_CAT_SHOP_STORES_PVT;