1 package CS_SR_EVENT_CODES_PKG AUTHID CURRENT_USER as
2 /* $Header: csxtnevs.pls 115.2 2003/02/28 08:05:09 pkesani noship $ */
3
4 procedure INSERT_ROW (
5 PX_EVENT_CODE in out NOCOPY VARCHAR2,
6 P_RELATIONSHIP_TYPE in VARCHAR2,
7 P_START_DATE_ACTIVE in DATE,
8 P_END_DATE_ACTIVE in DATE,
9 P_WF_BUSINESS_EVENT_ID in VARCHAR2,
10 P_SEEDED_FLAG in VARCHAR2,
11 P_APPLICATION_ID in NUMBER,
12 P_FROM_TO_STATUS in VARCHAR2,
13 P_INCIDENT_STATUS in VARCHAR2,
14 P_NAME in VARCHAR2,
15 P_DESCRIPTION in VARCHAR2,
16 P_CREATION_DATE in DATE,
17 P_CREATED_BY in NUMBER,
18 P_LAST_UPDATE_DATE in DATE,
19 P_LAST_UPDATED_BY in NUMBER,
20 P_LAST_UPDATE_LOGIN in NUMBER,
21 X_OBJECT_VERSION_NUMBER out NOCOPY NUMBER
22 );
23
24 procedure LOCK_ROW (
25 P_EVENT_CODE in VARCHAR2,
26 P_OBJECT_VERSION_NUMBER in NUMBER
27 );
28
29 procedure UPDATE_ROW (
30 P_EVENT_CODE in VARCHAR2,
31 P_RELATIONSHIP_TYPE in VARCHAR2,
32 P_START_DATE_ACTIVE in DATE,
33 P_END_DATE_ACTIVE in DATE,
34 P_WF_BUSINESS_EVENT_ID in VARCHAR2,
35 P_SEEDED_FLAG in VARCHAR2,
36 P_APPLICATION_ID in NUMBER,
37 P_FROM_TO_STATUS in VARCHAR2,
38 P_INCIDENT_STATUS in VARCHAR2,
39 P_NAME in VARCHAR2,
40 P_DESCRIPTION in VARCHAR2,
41 P_LAST_UPDATE_DATE in DATE,
42 P_LAST_UPDATED_BY in NUMBER,
43 P_LAST_UPDATE_LOGIN in NUMBER,
44 X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER
45 );
46
47 procedure DELETE_ROW (
48 P_EVENT_CODE in VARCHAR2
49 );
50
51 procedure ADD_LANGUAGE;
52
53 PROCEDURE LOAD_ROW (
54 P_EVENT_CODE IN VARCHAR2,
55 P_RELATIONSHIP_TYPE IN VARCHAR2,
56 P_START_DATE_ACTIVE IN VARCHAR2,
57 P_END_DATE_ACTIVE IN VARCHAR2,
58 P_WF_BUSINESS_EVENT_ID IN VARCHAR2,
59 P_SEEDED_FLAG IN VARCHAR2,
60 P_APPLICATION_ID IN NUMBER,
61 P_FROM_TO_STATUS IN VARCHAR2,
62 P_INCIDENT_STATUS IN VARCHAR2,
63 P_NAME IN VARCHAR2,
64 P_DESCRIPTION IN VARCHAR2,
65 P_OWNER IN VARCHAR2,
66 P_CREATION_DATE IN VARCHAR2,
67 P_CREATED_BY IN NUMBER,
68 P_LAST_UPDATE_DATE IN VARCHAR2,
69 P_LAST_UPDATED_BY IN NUMBER,
70 P_LAST_UPDATE_LOGIN IN NUMBER,
71 P_OBJECT_VERSION_NUMBER IN NUMBER );
72
73 procedure TRANSLATE_ROW ( X_EVENT_CODE in varchar2,
74 X_NAME in varchar2,
75 X_DESCRIPTION in varchar2,
76 X_LAST_UPDATE_DATE in date,
77 X_LAST_UPDATE_LOGIN in number,
78 X_OWNER in varchar2);
79
80 end CS_SR_EVENT_CODES_PKG;
[Home] [Help]