1 package CSD_RT_TRANS_PKG as
2 /* $Header: csdtrtts.pls 120.0 2005/06/30 21:06:35 vkjain noship $ */
3
4 procedure INSERT_ROW (
5 -- P_ROWID in out nocopy VARCHAR2,
6 PX_RT_TRAN_ID in out nocopy NUMBER,
7 P_FROM_REPAIR_TYPE_ID in NUMBER,
8 P_TO_REPAIR_TYPE_ID in NUMBER,
9 P_COMMON_FLOW_STATUS_ID in NUMBER,
10 P_REASON_REQUIRED_FLAG in VARCHAR2,
11 P_CAPTURE_ACTIVITY_FLAG in VARCHAR2,
12 P_ALLOW_ALL_RESP_FLAG in VARCHAR2,
13 P_OBJECT_VERSION_NUMBER in NUMBER,
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
21 procedure LOCK_ROW (
22 P_RT_TRAN_ID in NUMBER,
23 P_OBJECT_VERSION_NUMBER in NUMBER
24 );
25
26 procedure UPDATE_ROW (
27 P_RT_TRAN_ID in NUMBER,
28 P_FROM_REPAIR_TYPE_ID in NUMBER,
29 P_TO_REPAIR_TYPE_ID in NUMBER,
30 P_COMMON_FLOW_STATUS_ID in NUMBER,
31 P_REASON_REQUIRED_FLAG in VARCHAR2,
32 P_CAPTURE_ACTIVITY_FLAG in VARCHAR2,
33 P_ALLOW_ALL_RESP_FLAG in VARCHAR2,
34 P_DESCRIPTION in VARCHAR2,
35 P_OBJECT_VERSION_NUMBER in NUMBER,
36 P_LAST_UPDATE_DATE in DATE,
37 P_LAST_UPDATED_BY in NUMBER,
38 P_LAST_UPDATE_LOGIN in NUMBER
39 );
40
41 procedure DELETE_ROW (
42 P_RT_TRAN_ID in NUMBER
43 );
44
45 procedure ADD_LANGUAGE;
46
47 end CSD_RT_TRANS_PKG;