PACKAGE: APPS.PA_STATUS_LIST_ITEMS_PKG

Source

1 package PA_STATUS_LIST_ITEMS_PKG as
2 /* $Header: PACISITS.pls 120.1 2005/08/19 16:18:18 mwasowic noship $ */
3 procedure INSERT_ROW (
4   X_RECORD_VERSION_NUMBER in NUMBER,
5   X_STATUS_LIST_ITEM_ID in out NOCOPY NUMBER, --File.Sql.39 bug 4440895
6   X_STATUS_LIST_ID in NUMBER,
7   X_PROJECT_STATUS_CODE in VARCHAR2,
8   X_CREATION_DATE in DATE DEFAULT SYSDATE,
9   X_CREATED_BY in NUMBER DEFAULT fnd_global.user_id,
10   X_LAST_UPDATE_DATE in DATE DEFAULT SYSDATE,
11   X_LAST_UPDATED_BY in NUMBER DEFAULT fnd_global.user_id,
12   X_LAST_UPDATE_LOGIN in NUMBER DEFAULT fnd_global.login_id);
13 procedure LOCK_ROW (
14   X_STATUS_LIST_ITEM_ID in NUMBER,
15   X_STATUS_LIST_ID in NUMBER,
16   X_RECORD_VERSION_NUMBER in NUMBER,
17   X_PROJECT_STATUS_CODE in VARCHAR2
18 );
19 procedure UPDATE_ROW (
20   X_RECORD_VERSION_NUMBER in NUMBER,
21   X_STATUS_LIST_ITEM_ID in NUMBER,
22   X_STATUS_LIST_ID in NUMBER,
23   X_PROJECT_STATUS_CODE in VARCHAR2,
24   X_LAST_UPDATE_DATE in DATE DEFAULT SYSDATE,
25   X_LAST_UPDATED_BY in NUMBER DEFAULT fnd_global.user_id,
26   X_LAST_UPDATE_LOGIN in NUMBER DEFAULT fnd_global.login_id,
27   X_CREATION_DATE in DATE DEFAULT SYSDATE,
28   X_CREATED_BY in NUMBER DEFAULT fnd_global.user_id
29 );
30 procedure DELETE_ROW (
31   X_STATUS_LIST_ITEM_ID in NUMBER,
32   X_RECORD_VERSION_NUMBER in NUMBER
33 );
34 end PA_STATUS_LIST_ITEMS_PKG;