1 PACKAGE CS_SR_RES_CODE_MAP_DETAIL_PKG AUTHID CURRENT_USER as
2 /* $Header: csrcmpds.pls 120.0 2006/03/01 17:40:51 aseethep noship $ */
3
4 procedure INSERT_ROW (
5 PX_RESOLUTION_MAP_DETAIL_ID IN OUT NOCOPY NUMBER,
6 P_RESOLUTION_MAP_ID in NUMBER,
7 P_INCIDENT_TYPE_ID in NUMBER,
8 P_INVENTORY_ITEM_ID in NUMBER,
9 P_ORGANIZATION_ID in NUMBER,
10 P_CATEGORY_ID in NUMBER,
11 P_PROBLEM_CODE in VARCHAR2,
12 P_MAP_START_DATE_ACTIVE in DATE,
13 P_MAP_END_DATE_ACTIVE in DATE,
14 P_RESOLUTION_CODE in VARCHAR2,
15 P_START_DATE_ACTIVE in DATE,
16 P_END_DATE_ACTIVE in DATE,
17 P_OBJECT_VERSION_NUMBER in NUMBER,
18 P_ATTRIBUTE1 in VARCHAR2,
19 P_ATTRIBUTE2 in VARCHAR2,
20 P_ATTRIBUTE3 in VARCHAR2,
21 P_ATTRIBUTE4 in VARCHAR2,
22 P_ATTRIBUTE5 in VARCHAR2,
23 P_ATTRIBUTE6 in VARCHAR2,
24 P_ATTRIBUTE7 in VARCHAR2,
25 P_ATTRIBUTE8 in VARCHAR2,
26 P_ATTRIBUTE9 in VARCHAR2,
27 P_ATTRIBUTE10 in VARCHAR2,
28 P_ATTRIBUTE11 in VARCHAR2,
29 P_ATTRIBUTE12 in VARCHAR2,
30 P_ATTRIBUTE13 in VARCHAR2,
31 P_ATTRIBUTE14 in VARCHAR2,
32 P_ATTRIBUTE15 in VARCHAR2,
33 P_ATTRIBUTE_CATEGORY in VARCHAR2,
34 P_CREATION_DATE in DATE,
35 P_CREATED_BY in NUMBER,
36 P_LAST_UPDATE_DATE in DATE,
37 P_LAST_UPDATED_BY in NUMBER,
38 P_LAST_UPDATE_LOGIN in NUMBER,
39 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
40 X_MSG_COUNT OUT NOCOPY NUMBER,
41 X_MSG_DATA OUT NOCOPY VARCHAR2
42 );
43
44 procedure LOCK_ROW (
45 P_RESOLUTION_MAP_DETAIL_ID in NUMBER,
46 P_RESOLUTION_MAP_ID in NUMBER,
47 P_INCIDENT_TYPE_ID in NUMBER,
48 P_INVENTORY_ITEM_ID in NUMBER,
49 P_ORGANIZATION_ID in NUMBER,
50 P_CATEGORY_ID in NUMBER,
51 P_PROBLEM_CODE in VARCHAR2,
52 P_MAP_START_DATE_ACTIVE in DATE,
53 P_MAP_END_DATE_ACTIVE in DATE,
54 P_RESOLUTION_CODE in VARCHAR2,
55 P_START_DATE_ACTIVE in DATE,
56 P_END_DATE_ACTIVE in DATE,
57 P_OBJECT_VERSION_NUMBER in NUMBER,
58 P_ATTRIBUTE1 in VARCHAR2,
59 P_ATTRIBUTE2 in VARCHAR2,
60 P_ATTRIBUTE3 in VARCHAR2,
61 P_ATTRIBUTE4 in VARCHAR2,
62 P_ATTRIBUTE5 in VARCHAR2,
63 P_ATTRIBUTE6 in VARCHAR2,
64 P_ATTRIBUTE7 in VARCHAR2,
65 P_ATTRIBUTE8 in VARCHAR2,
66 P_ATTRIBUTE9 in VARCHAR2,
67 P_ATTRIBUTE10 in VARCHAR2,
68 P_ATTRIBUTE11 in VARCHAR2,
69 P_ATTRIBUTE12 in VARCHAR2,
70 P_ATTRIBUTE13 in VARCHAR2,
71 P_ATTRIBUTE14 in VARCHAR2,
72 P_ATTRIBUTE15 in VARCHAR2,
73 P_ATTRIBUTE_CATEGORY in VARCHAR2
74 );
75
76 procedure UPDATE_ROW (
77 P_RESOLUTION_MAP_DETAIL_ID in NUMBER,
78 P_RESOLUTION_MAP_ID in NUMBER,
79 P_INCIDENT_TYPE_ID in NUMBER,
80 P_INVENTORY_ITEM_ID in NUMBER,
81 P_ORGANIZATION_ID in NUMBER,
82 P_CATEGORY_ID in NUMBER,
83 P_PROBLEM_CODE in VARCHAR2,
84 P_MAP_START_DATE_ACTIVE in DATE,
85 P_MAP_END_DATE_ACTIVE in DATE,
86 P_RESOLUTION_CODE in VARCHAR2,
87 P_START_DATE_ACTIVE in DATE,
88 P_END_DATE_ACTIVE in DATE,
89 P_OBJECT_VERSION_NUMBER in NUMBER,
90 P_ATTRIBUTE1 in VARCHAR2,
91 P_ATTRIBUTE2 in VARCHAR2,
92 P_ATTRIBUTE3 in VARCHAR2,
93 P_ATTRIBUTE4 in VARCHAR2,
94 P_ATTRIBUTE5 in VARCHAR2,
95 P_ATTRIBUTE6 in VARCHAR2,
96 P_ATTRIBUTE7 in VARCHAR2,
97 P_ATTRIBUTE8 in VARCHAR2,
98 P_ATTRIBUTE9 in VARCHAR2,
99 P_ATTRIBUTE10 in VARCHAR2,
100 P_ATTRIBUTE11 in VARCHAR2,
101 P_ATTRIBUTE12 in VARCHAR2,
102 P_ATTRIBUTE13 in VARCHAR2,
103 P_ATTRIBUTE14 in VARCHAR2,
104 P_ATTRIBUTE15 in VARCHAR2,
105 P_ATTRIBUTE_CATEGORY in VARCHAR2,
106 P_LAST_UPDATE_DATE in DATE,
107 P_LAST_UPDATED_BY in NUMBER,
108 P_LAST_UPDATE_LOGIN in NUMBER,
109 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
110 X_MSG_COUNT OUT NOCOPY NUMBER,
111 X_MSG_DATA OUT NOCOPY VARCHAR2
112 );
113
114 procedure DELETE_ROW (
115 P_RESOLUTION_MAP_DETAIL_ID in NUMBER
116 );
117
118 end CS_SR_RES_CODE_MAP_DETAIL_PKG;