1 package CSD_FLWSTS_TRANS_PKG as
2 /* $Header: csdtflts.pls 120.0 2005/06/30 21:05:15 vkjain noship $ */
3
4 procedure INSERT_ROW (
5 -- P_ROWID in out nocopy VARCHAR2,
6 PX_FLWSTS_TRAN_ID in out nocopy NUMBER,
7 P_REPAIR_TYPE_ID in NUMBER,
8 P_FROM_FLOW_STATUS_ID in NUMBER,
9 P_TO_FLOW_STATUS_ID in NUMBER,
10 P_WF_ITEM_TYPE in VARCHAR2,
11 P_WF_PROCESS_NAME in VARCHAR2,
12 P_REASON_REQUIRED_FLAG in VARCHAR2,
13 P_CAPTURE_ACTIVITY_FLAG in VARCHAR2,
14 P_ALLOW_ALL_RESP_FLAG in VARCHAR2,
15 P_OBJECT_VERSION_NUMBER in NUMBER,
16 P_DESCRIPTION in VARCHAR2,
17 P_CREATION_DATE in DATE,
18 P_CREATED_BY in NUMBER,
19 P_LAST_UPDATE_DATE in DATE,
20 P_LAST_UPDATED_BY in NUMBER,
21 P_LAST_UPDATE_LOGIN in NUMBER);
22
23 procedure LOCK_ROW (
24 P_FLWSTS_TRAN_ID in NUMBER,
25 P_OBJECT_VERSION_NUMBER in NUMBER
26 /*
27 P_REPAIR_TYPE_ID in NUMBER,
28 P_FROM_FLOW_STATUS_ID in NUMBER,
29 P_TO_FLOW_STATUS_ID in NUMBER,
30 P_WF_ITEM_TYPE in VARCHAR2,
31 P_WF_PROCESS_NAME in VARCHAR2,
32 P_REASON_REQUIRED_FLAG in VARCHAR2,
33 P_CAPTURE_ACTIVITY_FLAG in VARCHAR2,
34 P_ALLOW_ALL_RESP_FLAG in VARCHAR2,
35 P_DESCRIPTION in VARCHAR2
36 */
37 );
38
39 procedure UPDATE_ROW (
40 P_FLWSTS_TRAN_ID in NUMBER,
41 P_REPAIR_TYPE_ID in NUMBER,
42 P_FROM_FLOW_STATUS_ID in NUMBER,
43 P_TO_FLOW_STATUS_ID in NUMBER,
44 P_WF_ITEM_TYPE in VARCHAR2,
45 P_WF_PROCESS_NAME in VARCHAR2,
46 P_REASON_REQUIRED_FLAG in VARCHAR2,
47 P_CAPTURE_ACTIVITY_FLAG in VARCHAR2,
48 P_ALLOW_ALL_RESP_FLAG in VARCHAR2,
49 P_OBJECT_VERSION_NUMBER in NUMBER,
50 P_DESCRIPTION in VARCHAR2,
51 P_LAST_UPDATE_DATE in DATE,
52 P_LAST_UPDATED_BY in NUMBER,
53 P_LAST_UPDATE_LOGIN in NUMBER
54 );
55
56 procedure DELETE_ROW (
57 P_FLWSTS_TRAN_ID in NUMBER
58 );
59
60 procedure ADD_LANGUAGE;
61
62 end CSD_FLWSTS_TRANS_PKG;