PACKAGE: APPS.FEM_SIC_PKG

Source

1 package FEM_SIC_PKG as
2 /* $Header: fem_sic_pkh.pls 120.0 2005/06/06 19:31:40 appldev noship $ */
3 procedure INSERT_ROW (
4   X_ROWID in out nocopy VARCHAR2,
5   X_SIC_ID in NUMBER,
6   X_SIC_DISPLAY_CODE in VARCHAR2,
7   X_DIMENSION_GROUP_ID in NUMBER,
8   X_ENABLED_FLAG in VARCHAR2,
9   X_PERSONAL_FLAG in VARCHAR2,
10   X_READ_ONLY_FLAG in VARCHAR2,
11   X_OBJECT_VERSION_NUMBER in NUMBER,
12   X_SIC_NAME in VARCHAR2,
13   X_DESCRIPTION in VARCHAR2,
14   X_CREATION_DATE in DATE,
15   X_CREATED_BY in NUMBER,
16   X_LAST_UPDATE_DATE in DATE,
17   X_LAST_UPDATED_BY in NUMBER,
18   X_LAST_UPDATE_LOGIN in NUMBER);
19 procedure LOCK_ROW (
20   X_SIC_ID in NUMBER,
21   X_SIC_DISPLAY_CODE in VARCHAR2,
22   X_DIMENSION_GROUP_ID in NUMBER,
23   X_ENABLED_FLAG in VARCHAR2,
24   X_PERSONAL_FLAG in VARCHAR2,
25   X_READ_ONLY_FLAG in VARCHAR2,
26   X_OBJECT_VERSION_NUMBER in NUMBER,
27   X_SIC_NAME in VARCHAR2,
28   X_DESCRIPTION in VARCHAR2
29 );
30 procedure UPDATE_ROW (
31   X_SIC_ID in NUMBER,
32   X_SIC_DISPLAY_CODE in VARCHAR2,
33   X_DIMENSION_GROUP_ID in NUMBER,
34   X_ENABLED_FLAG in VARCHAR2,
35   X_PERSONAL_FLAG in VARCHAR2,
36   X_READ_ONLY_FLAG in VARCHAR2,
37   X_OBJECT_VERSION_NUMBER in NUMBER,
38   X_SIC_NAME in VARCHAR2,
39   X_DESCRIPTION in VARCHAR2,
40   X_LAST_UPDATE_DATE in DATE,
41   X_LAST_UPDATED_BY in NUMBER,
42   X_LAST_UPDATE_LOGIN in NUMBER
43 );
44 procedure DELETE_ROW (
45   X_SIC_ID in NUMBER
46 );
47 procedure ADD_LANGUAGE;
48 PROCEDURE TRANSLATE_ROW(
49         x_SIC_ID in number,
50         x_owner in varchar2,
51         x_last_update_date in varchar2,
52         x_SIC_NAME in varchar2,
53         x_description in varchar2,
54         x_custom_mode in varchar2);
55 
56 
57 end FEM_SIC_PKG;