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