DBA Data[Home] [Help]

PACKAGE: APPS.GMO_DISPENSE_AREA_PKG

Source


1 package GMO_DISPENSE_AREA_PKG as
2 /* $Header: GMODARES.pls 120.1 2007/06/21 06:08:15 rvsingh noship $ */
3 procedure INSERT_ROW (
4   X_ROWID in out NOCOPY VARCHAR2,
5   X_DISPENSE_AREA_ID in NUMBER,
6   X_ORGANIZATION_ID in NUMBER,
7   X_DISPENSE_AREA_NAME in VARCHAR2,
8   X_DEFAULT_AREA_IND in VARCHAR2,
9   X_SUBINVENTORY_CODE in VARCHAR2,
10   X_NUMBER_OF_TASKS_PER_DAY in NUMBER,
11   X_DISPENSE_AREA_DESC in VARCHAR2,
12   X_CREATION_DATE in DATE,
13   X_CREATED_BY in NUMBER,
14   X_LAST_UPDATE_DATE in DATE,
15   X_LAST_UPDATED_BY in NUMBER,
16   X_LAST_UPDATE_LOGIN in NUMBER);
17 procedure LOCK_ROW (
18   X_DISPENSE_AREA_ID in NUMBER,
19   X_ORGANIZATION_ID in NUMBER,
20   X_DISPENSE_AREA_NAME in VARCHAR2,
21   X_DEFAULT_AREA_IND in VARCHAR2,
22   X_SUBINVENTORY_CODE in VARCHAR2,
23   X_NUMBER_OF_TASKS_PER_DAY in NUMBER,
24   X_DISPENSE_AREA_DESC in VARCHAR2
25 );
26 procedure UPDATE_ROW (
27   X_DISPENSE_AREA_ID in NUMBER,
28   X_ORGANIZATION_ID in NUMBER,
29   X_DISPENSE_AREA_NAME in VARCHAR2,
30   X_DEFAULT_AREA_IND in VARCHAR2,
31   X_SUBINVENTORY_CODE in VARCHAR2,
32   X_NUMBER_OF_TASKS_PER_DAY in NUMBER,
33   X_DISPENSE_AREA_DESC in VARCHAR2,
34   X_LAST_UPDATE_DATE in DATE,
35   X_LAST_UPDATED_BY in NUMBER,
36   X_LAST_UPDATE_LOGIN in NUMBER
37 );
38 procedure DELETE_ROW (
39   X_DISPENSE_AREA_ID in NUMBER
40 );
41 procedure ADD_LANGUAGE;
42 end GMO_DISPENSE_AREA_PKG;