PACKAGE: APPS.EGO_CATG_MAP_PKG

Source

1 package EGO_CATG_MAP_PKG AUTHID CURRENT_USER as
2 /* $Header: EGOCTMPS.pls 120.1 2005/12/08 01:54:25 lparihar noship $ */
3 procedure INSERT_ROW (
4   X_ROWID in out NOCOPY VARCHAR2,
5   X_CATG_MAP_ID in NUMBER,
6   X_SOURCE_CATG_SET_ID in NUMBER,
7   X_TARGET_CATG_SET_ID in NUMBER,
8   X_ENABLED_FLAG in VARCHAR2,
9   X_CATG_MAP_NAME in VARCHAR2,
10   X_CATG_MAP_DESC in VARCHAR2,
11   X_CREATION_DATE in DATE,
12   X_CREATED_BY in NUMBER,
13   X_LAST_UPDATE_DATE in DATE,
14   X_LAST_UPDATED_BY in NUMBER,
15   X_LAST_UPDATE_LOGIN in NUMBER
16 );
17 
18 procedure LOCK_ROW (
19   X_CATG_MAP_ID in NUMBER,
20   X_SOURCE_CATG_SET_ID in NUMBER,
21   X_TARGET_CATG_SET_ID in NUMBER,
22   X_ENABLED_FLAG in VARCHAR2,
23  X_CATG_MAP_NAME in VARCHAR2,
24   X_CATG_MAP_DESC in VARCHAR2
25 );
26 
27 procedure UPDATE_ROW (
28   X_CATG_MAP_ID in NUMBER,
29   X_SOURCE_CATG_SET_ID in NUMBER,
30   X_TARGET_CATG_SET_ID in NUMBER,
31   X_ENABLED_FLAG in VARCHAR2,
32   X_CATG_MAP_NAME in VARCHAR2,
33   X_CATG_MAP_DESC in VARCHAR2,
34   X_LAST_UPDATE_DATE in DATE,
35   X_LAST_UPDATED_BY in NUMBER,
36   X_LAST_UPDATE_LOGIN in NUMBER
37 );
38 
39 procedure DELETE_ROW (
40   X_CATG_MAP_ID in NUMBER
41 );
42 
43 PROCEDURE Load_Row
44 (
45   X_CATG_MAP_ID          in NUMBER,
46   X_SOURCE_CATG_SET_NAME in VARCHAR2,
47   X_TARGET_CATG_SET_NAME in VARCHAR2,
48   X_ENABLED_FLAG         in VARCHAR2,
49   X_OWNER                in VARCHAR2,
50   X_LAST_UPDATE_DATE     in VARCHAR2,
51   X_CATG_MAP_NAME        in VARCHAR2,
52   X_CATG_MAP_DESC        in VARCHAR2
53 );
54 
55 PROCEDURE Load_Row
56 (
57   X_CATG_MAP_ID          in NUMBER,
58   X_SOURCE_CATG_SET_NAME in VARCHAR2,
59   X_TARGET_CATG_SET_NAME in VARCHAR2,
60   X_OWNER                in VARCHAR2,
61   X_LAST_UPDATE_DATE     in VARCHAR2,
62   X_SOURCE_CATG_NAME     in VARCHAR2,
63   X_TARGET_CATG_NAME     in VARCHAR2
64 );
65 
66 PROCEDURE Translate_Row
67 (
68   X_CATG_MAP_ID          in NUMBER,
69   X_SOURCE_CATG_SET_NAME in VARCHAR2,
70   X_TARGET_CATG_SET_NAME in VARCHAR2,
71   X_ENABLED_FLAG         in VARCHAR2,
72   X_OWNER                in VARCHAR2,
73   X_LAST_UPDATE_DATE     in VARCHAR2,
74   X_CATG_MAP_NAME        in VARCHAR2,
75   X_CATG_MAP_DESC        in VARCHAR2
76 );
77 
78 procedure ADD_LANGUAGE;
79 
80 end EGO_CATG_MAP_PKG;