1 package CSD_SC_RECOMMENDATIONS_PKG as
2 /* $Header: csdtscrs.pls 120.0 2005/10/26 12:52:56 swai noship $ */
3
4 procedure INSERT_ROW (
5 -- P_ROWID in out nocopy VARCHAR2,
6 PX_SC_RECOMMENDATION_ID in out nocopy NUMBER,
7 P_SC_DOMAIN_ID in NUMBER,
8 P_RECOMMENDATION_TYPE_CODE in VARCHAR2,
9 P_ACTIVE_FROM in DATE,
10 P_ACTIVE_TO in DATE,
11 P_OBJECT_VERSION_NUMBER in NUMBER,
12 P_SC_RECOMMENDATION_NAME in VARCHAR2,
13 P_CREATION_DATE in DATE,
14 P_CREATED_BY in NUMBER,
15 P_LAST_UPDATE_DATE in DATE,
16 P_LAST_UPDATED_BY in NUMBER,
17 P_LAST_UPDATE_LOGIN in NUMBER);
18
19 procedure LOCK_ROW (
20 P_SC_RECOMMENDATION_ID in NUMBER,
21 P_OBJECT_VERSION_NUMBER in NUMBER
22 );
23
24 procedure UPDATE_ROW (
25 P_SC_RECOMMENDATION_ID in NUMBER,
26 P_SC_DOMAIN_ID in NUMBER,
27 P_RECOMMENDATION_TYPE_CODE in VARCHAR2,
28 P_ACTIVE_FROM in DATE,
29 P_ACTIVE_TO in DATE,
30 P_SC_RECOMMENDATION_NAME in VARCHAR2,
31 P_OBJECT_VERSION_NUMBER in NUMBER,
32 P_LAST_UPDATE_DATE in DATE,
33 P_LAST_UPDATED_BY in NUMBER,
34 P_LAST_UPDATE_LOGIN in NUMBER
35 );
36
37 procedure DELETE_ROW (
38 P_SC_RECOMMENDATION_ID in NUMBER
39 );
40
41 procedure ADD_LANGUAGE;
42
43 end CSD_SC_RECOMMENDATIONS_PKG;