1 package CS_SR_EVENT_ACTIONS_PKG as
2 /* $Header: csxtneas.pls 120.0 2005/08/12 15:29:42 aneemuch noship $ */
3 procedure INSERT_ROW (
4 PX_EVENT_CODE in out NOCOPY VARCHAR2,
5 PX_ACTION_CODE in out NOCOPY VARCHAR2,
6 P_SEEDED_FLAG in VARCHAR2,
7 P_APPLICATION_ID in NUMBER,
8 P_START_DATE_ACTIVE in DATE,
9 P_END_DATE_ACTIVE in DATE,
10 P_CREATION_DATE in DATE,
11 P_CREATED_BY in NUMBER,
12 P_LAST_UPDATE_DATE in DATE,
13 P_LAST_UPDATED_BY in NUMBER,
14 P_LAST_UPDATE_LOGIN in NUMBER,
15 X_OBJECT_VERSION_NUMBER out NOCOPY NUMBER
16 );
17
18 procedure LOCK_ROW (
19 P_EVENT_CODE in VARCHAR2,
20 P_ACTION_CODE in VARCHAR2,
21 P_OBJECT_VERSION_NUMBER in NUMBER
22 );
23
24 procedure UPDATE_ROW (
25 P_EVENT_CODE in VARCHAR2,
26 P_ACTION_CODE in VARCHAR2,
27 P_SEEDED_FLAG in VARCHAR2,
28 P_APPLICATION_ID in NUMBER,
29 P_START_DATE_ACTIVE in DATE,
30 P_END_DATE_ACTIVE in DATE,
31 P_LAST_UPDATE_DATE in DATE,
32 P_LAST_UPDATED_BY in NUMBER,
33 P_LAST_UPDATE_LOGIN in NUMBER,
34 X_OBJECT_VERSION_NUMBER out NOCOPY NUMBER
35 );
36
37 procedure DELETE_ROW (
38 P_EVENT_CODE in VARCHAR2,
39 P_ACTION_CODE in VARCHAR2
40 );
41
42 PROCEDURE LOAD_ROW (
43 P_EVENT_CODE IN VARCHAR2,
44 P_ACTION_CODE IN VARCHAR2,
45 P_SEEDED_FLAG IN VARCHAR2,
46 P_APPLICATION_ID IN NUMBER,
47 P_START_DATE_ACTIVE IN VARCHAR2,
48 P_END_DATE_ACTIVE IN VARCHAR2,
49 P_OWNER IN VARCHAR2,
50 P_CREATION_DATE IN VARCHAR2,
51 P_CREATED_BY IN NUMBER,
52 P_LAST_UPDATE_DATE IN VARCHAR2,
53 P_LAST_UPDATED_BY IN NUMBER,
54 P_LAST_UPDATE_LOGIN IN NUMBER,
55 P_OBJECT_VERSION_NUMBER IN NUMBER );
56
57 end CS_SR_EVENT_ACTIONS_PKG;