DBA Data[Home] [Help]

PACKAGE: APPS.PA_CI_IMPACTS_PKG

Source


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;