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