DBA Data[Home] [Help]

PACKAGE: APPS.CSD_FLWSTS_TRANS_PKG

Source


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;