1 package PA_CI_ACTIONS_PKG AUTHID CURRENT_USER as
2 /* $Header: PACIACTS.pls 120.0 2005/05/29 20:28:14 appldev noship $ */
3
4 procedure INSERT_ROW (
5 P_CI_ACTION_ID out NOCOPY NUMBER,
6 P_CI_ID in NUMBER,
7 P_CI_ACTION_NUMBER in NUMBER,
8 P_STATUS_CODE in VARCHAR2,
9 P_TYPE_CODE in VARCHAR2,
10 P_ASSIGNED_TO in NUMBER,
11 P_DATE_REQUIRED in DATE,
12 P_SIGN_OFF_REQUIRED_FLAG in VARCHAR2,
13 P_DATE_CLOSED in DATE,
14 P_SIGN_OFF_FLAG in VARCHAR2,
15 P_SOURCE_CI_ACTION_ID in NUMBER,
16 P_LAST_UPDATED_BY in NUMBER,
17 P_CREATED_BY in NUMBER,
18 P_CREATION_DATE in DATE,
19 P_LAST_UPDATE_DATE in DATE,
20 P_LAST_UPDATE_LOGIN in NUMBER,
21 P_RECORD_VERSION_NUMBER in NUMBER
22 );
23
24 procedure UPDATE_ROW (
25 P_CI_ACTION_ID in NUMBER,
26 P_CI_ID in NUMBER,
27 P_STATUS_CODE in VARCHAR2,
28 P_TYPE_CODE in VARCHAR2,
29 P_ASSIGNED_TO in NUMBER,
30 P_DATE_REQUIRED in DATE,
31 P_SIGN_OFF_REQUIRED_FLAG in VARCHAR2,
32 P_DATE_CLOSED in DATE,
33 P_SIGN_OFF_FLAG in VARCHAR2,
34 P_SOURCE_CI_ACTION_ID in NUMBER,
35 P_LAST_UPDATED_BY in NUMBER,
36 P_CREATED_BY in NUMBER,
37 P_CREATION_DATE in DATE,
38 P_LAST_UPDATE_DATE in DATE,
39 P_LAST_UPDATE_LOGIN in NUMBER,
40 P_RECORD_VERSION_NUMBER in NUMBER
41 );
42
43 procedure DELETE_ROW (
44 P_CI_ACTION_ID in NUMBER );
45
46
47 END; -- Package Specification PA_CI_ACTIONS_PKG