PACKAGE: APPS.ENG_CHANGE_ACTIONS_PKG

Source

1 package ENG_CHANGE_ACTIONS_PKG as
2 /* $Header: ENGUCAMS.pls 120.2 2005/12/22 04:23:52 lkasturi noship $ */
3 
4 procedure INSERT_ROW (
5   X_ROWID in out NOCOPY VARCHAR2,
6   X_ACTION_ID in NUMBER,
7   X_ORIGINAL_SYSTEM_REFERENCE in VARCHAR2,
8   X_WORKFLOW_ITEM_KEY in VARCHAR2,
9   X_REQUEST_ID in NUMBER,
10   X_STATUS_CODE in NUMBER,
11   X_PRIORITY_CODE in VARCHAR2,
12   X_ASSIGNEE_ID in NUMBER,
13   X_RESPONSE_BY_DATE in DATE,
14   X_PARTY_ID_LIST in VARCHAR2,
15   X_PARENT_STATUS_CODE in NUMBER,
16   X_WORKFLOW_ITEM_TYPE in VARCHAR2,
17   X_ROUTE_ID in NUMBER,
18   X_PARENT_ACTION_ID in NUMBER,
19   X_ACTION_TYPE in VARCHAR2,
20   X_OBJECT_NAME in VARCHAR2,
21   X_OBJECT_ID1 in NUMBER,
22   X_OBJECT_ID2 in NUMBER,
23   X_OBJECT_ID3 in NUMBER,
24   X_OBJECT_ID4 in NUMBER,
25   X_OBJECT_ID5 in NUMBER,
26   X_DESCRIPTION in VARCHAR2,
27   X_PROGRAM_ID in NUMBER DEFAULT NULL,
28   X_PROGRAM_APPLICATION_ID in NUMBER DEFAULT NULL,
29   X_PROGRAM_UPDATE_DATE in DATE DEFAULT NULL,
30   X_CREATION_DATE in DATE,
31   X_CREATED_BY in NUMBER,
32   X_LAST_UPDATE_DATE in DATE,
33   X_LAST_UPDATED_BY in NUMBER,
34   X_LAST_UPDATE_LOGIN in NUMBER,
35   X_IMPLEMENTATION_REQ_ID in NUMBER DEFAULT NULL,
36   X_LOCAL_ORGANIZATION_ID in NUMBER DEFAULT NULL -- Bug 4704384
37 );
38 
39 procedure LOCK_ROW (
40   X_ACTION_ID in NUMBER,
41   X_ORIGINAL_SYSTEM_REFERENCE in VARCHAR2,
42   X_WORKFLOW_ITEM_KEY in VARCHAR2,
43   X_REQUEST_ID in NUMBER,
44   X_STATUS_CODE in NUMBER,
45   X_PRIORITY_CODE in VARCHAR2,
46   X_ASSIGNEE_ID in NUMBER,
47   X_RESPONSE_BY_DATE in DATE,
48   X_PARTY_ID_LIST in VARCHAR2,
49   X_PARENT_STATUS_CODE in NUMBER,
50   X_WORKFLOW_ITEM_TYPE in VARCHAR2,
51   X_ROUTE_ID in NUMBER,
52   X_PARENT_ACTION_ID in NUMBER,
53   X_ACTION_TYPE in VARCHAR2,
54   X_OBJECT_NAME in VARCHAR2,
55   X_OBJECT_ID1 in NUMBER,
56   X_OBJECT_ID2 in NUMBER,
57   X_OBJECT_ID3 in NUMBER,
58   X_OBJECT_ID4 in NUMBER,
59   X_OBJECT_ID5 in NUMBER,
60   X_DESCRIPTION in VARCHAR2,
61   X_PROGRAM_ID in NUMBER DEFAULT NULL,
62   X_PROGRAM_APPLICATION_ID in NUMBER DEFAULT NULL,
63   X_PROGRAM_UPDATE_DATE in DATE DEFAULT NULL,
64   X_IMPLEMENTATION_REQ_ID in NUMBER DEFAULT NULL,
65   X_LOCAL_ORGANIZATION_ID in NUMBER DEFAULT NULL -- Bug 4704384
66 );
67 
68 procedure UPDATE_ROW (
69   X_ACTION_ID in NUMBER,
70   X_ORIGINAL_SYSTEM_REFERENCE in VARCHAR2,
71   X_WORKFLOW_ITEM_KEY in VARCHAR2,
72   X_REQUEST_ID in NUMBER,
73   X_STATUS_CODE in NUMBER,
74   X_PRIORITY_CODE in VARCHAR2,
75   X_ASSIGNEE_ID in NUMBER,
76   X_RESPONSE_BY_DATE in DATE,
77   X_PARTY_ID_LIST in VARCHAR2,
78   X_PARENT_STATUS_CODE in NUMBER,
79   X_WORKFLOW_ITEM_TYPE in VARCHAR2,
80   X_ROUTE_ID in NUMBER,
81   X_PARENT_ACTION_ID in NUMBER,
82   X_ACTION_TYPE in VARCHAR2,
83   X_OBJECT_NAME in VARCHAR2,
84   X_OBJECT_ID1 in NUMBER,
85   X_OBJECT_ID2 in NUMBER,
86   X_OBJECT_ID3 in NUMBER,
87   X_OBJECT_ID4 in NUMBER,
88   X_OBJECT_ID5 in NUMBER,
89   X_DESCRIPTION in VARCHAR2,
90   X_PROGRAM_ID in NUMBER DEFAULT NULL,
91   X_PROGRAM_APPLICATION_ID in NUMBER DEFAULT NULL,
92   X_PROGRAM_UPDATE_DATE in DATE DEFAULT NULL,
93   X_LAST_UPDATE_DATE in DATE,
94   X_LAST_UPDATED_BY in NUMBER,
95   X_LAST_UPDATE_LOGIN in NUMBER,
96   X_IMPLEMENTATION_REQ_ID in NUMBER DEFAULT NULL,
97   X_LOCAL_ORGANIZATION_ID in NUMBER DEFAULT NULL -- Bug 4704384
98 );
99 
100 procedure DELETE_ROW (
101   X_ACTION_ID in NUMBER
102 );
103 
104 procedure ADD_LANGUAGE;
105 end ENG_CHANGE_ACTIONS_PKG;