1 package PA_CI_IMPACTS_PKG AUTHID CURRENT_USER as
2 /* $Header: PACIIPTS.pls 120.0 2005/06/03 13:41:01 appldev noship $ */
3 procedure INSERT_ROW (
4 X_ROWID out NOCOPY VARCHAR2,
5 X_CI_IMPACT_ID out NOCOPY NUMBER,
6
7 x_ci_id IN NUMBER,
8 x_impact_type_code IN varchar2,
9 x_status_code IN VARCHAR2,
10 x_description IN VARCHAR2,
11 x_implementation_date IN DATE,
12 x_implemented_by IN NUMBER,
13 x_implementation_comment IN VARCHAR2,
14 x_impacted_task_id IN NUMBER,
15 X_CREATION_DATE in DATE default null,
16 X_CREATED_BY in NUMBER default null,
17 X_LAST_UPDATE_DATE in DATE default null,
18 X_LAST_UPDATED_BY in NUMBER default null,
19 X_LAST_UPDATE_LOGIN in NUMBER default null
20 );
21
22 procedure UPDATE_ROW (
23 X_CI_IMPACT_ID NUMBER,
24
25 x_ci_id IN NUMBER,
26 x_impact_type_code IN varchar2,
27 x_status_code IN VARCHAR2,
28 x_description IN VARCHAR2,
29 x_implementation_date IN DATE,
30 x_implemented_by IN NUMBER,
31 x_implementation_comment IN VARCHAR2,
32 x_impacted_task_id IN NUMBER,
33
34 X_LAST_UPDATE_DATE in DATE,
35 X_LAST_UPDATED_BY in NUMBER,
36 X_LAST_UPDATE_LOGIN in NUMBER,
37 x_record_version_number IN number
38 );
39 /*
40 procedure LOCK_ROW (
41 X_CI_IMPACT_ID in NUMBER,
42 x_impact_type_code IN varchar2,
43 X_CI_ID in NUMBER
44 );*/
45
46 procedure DELETE_ROW (
47 X_CI_IMPACT_ID in NUMBER,
48 X_record_version_number in NUMBER
49 );
50
51 end PA_CI_IMPACTS_PKG;