DBA Data[Home] [Help]

PACKAGE: APPS.ENG_CHANGE_STATUSES_PKG

Source


1 package ENG_CHANGE_STATUSES_PKG as
2 /* $Header: ENGUSTSS.pls 120.1 2006/01/30 02:24:56 pdutta noship $ */
3 procedure INSERT_ROW (
4   X_ROWID in out NOCOPY VARCHAR2,
5   X_STATUS_CODE in NUMBER,
6   X_SORT_SEQUENCE_NUM in NUMBER,
7   X_DISABLE_DATE in DATE,
8   X_STATUS_NAME in VARCHAR2,
9   X_DESCRIPTION in VARCHAR2,
10   X_SEEDED_FLAG in VARCHAR2,
11   X_CREATION_DATE in DATE,
12   X_CREATED_BY in NUMBER,
13   X_LAST_UPDATE_DATE in DATE,
14   X_LAST_UPDATED_BY in NUMBER,
15   X_LAST_UPDATE_LOGIN in NUMBER,
16   X_STATUS_TYPE in NUMBER,
17   X_OBJECT_NAME in VARCHAR2);
18 
19 procedure LOCK_ROW (
20   X_STATUS_CODE in NUMBER,
21   X_SORT_SEQUENCE_NUM in NUMBER,
22   X_DISABLE_DATE in DATE,
23   X_STATUS_NAME in VARCHAR2,
24   X_DESCRIPTION in VARCHAR2,
25   X_SEEDED_FLAG in VARCHAR2,
26   X_STATUS_TYPE in NUMBER,
27   X_OBJECT_NAME in VARCHAR2
28 );
29 
30 procedure UPDATE_ROW (
31   X_STATUS_CODE in NUMBER,
32   X_SORT_SEQUENCE_NUM in NUMBER,
33   X_DISABLE_DATE in DATE,
34   X_STATUS_NAME in VARCHAR2,
35   X_DESCRIPTION in VARCHAR2,
36   X_SEEDED_FLAG in VARCHAR2,
37   X_LAST_UPDATE_DATE in DATE,
38   X_LAST_UPDATED_BY in NUMBER,
39   X_LAST_UPDATE_LOGIN in NUMBER,
40   X_STATUS_TYPE in NUMBER,
41   X_OBJECT_NAME in VARCHAR2
42 );
43 procedure DELETE_ROW (
44   X_STATUS_CODE in NUMBER
45 );
46 procedure ADD_LANGUAGE;
47 end ENG_CHANGE_STATUSES_PKG;