1 package EAM_SAFETY_STATUSES_PKG AUTHID CURRENT_USER as
2 /* $Header: EAMSFSTS.pls 120.0.12010000.4 2010/03/24 10:16:44 vboddapa noship $ */
3
4 --This procedure will insert new rows in EAM_SAFETY_USR_DEF_STATUSES_B and eam_safety_usr_def_statuses_tl tables
5 procedure INSERT_ROW (
6 X_ROWID in out NOCOPY VARCHAR2,
7 X_STATUS_ID in out NOCOPY NUMBER,
8 P_SEEDED_FLAG in VARCHAR2,
9 P_SYSTEM_STATUS in NUMBER,
10 P_ENABLED_FLAG in VARCHAR2,
11 P_USER_DEFINED_STATUS in VARCHAR2,
12 P_ENTITY_TYPE in NUMBER,
13 P_CREATION_DATE in DATE,
14 P_CREATED_BY in NUMBER,
15 P_LAST_UPDATE_DATE in DATE,
16 P_LAST_UPDATED_BY in NUMBER,
17 P_LAST_UPDATE_LOGIN in NUMBER
18 );
19
20 --This procedure will update rows in EAM_SAFETY_USR_DEF_STATUSES_B and eam_safety_usr_def_statuses_tl tables
21 procedure UPDATE_ROW (
22 P_STATUS_ID in NUMBER,
23 P_SEEDED_FLAG in VARCHAR2,
24 P_SYSTEM_STATUS in NUMBER,
25 P_ENABLED_FLAG in VARCHAR2,
26 P_USER_DEFINED_STATUS in VARCHAR2,
27 P_ENTITY_TYPE in NUMBER,
28 P_LAST_UPDATE_DATE in DATE,
29 P_LAST_UPDATED_BY in NUMBER,
30 P_LAST_UPDATE_LOGIN in NUMBER,
31 P_MODE in VARCHAR2 DEFAULT 'FORMS'
32 );
33
34 --This procedure will delete rows in EAM_SAFETY_USR_DEF_STATUSES_B and eam_safety_usr_def_statuses_tl tables
35 procedure DELETE_ROW (
36 P_STATUS_ID in NUMBER,
37 P_ENTITY_TYPE in NUMBER
38 );
39
40 --This procedure will be called when a new langauge is installed. This will insert rows
41 -- in Eam_Wo_Statuses_TL table for the new langauge
42 procedure ADD_LANGUAGE;
43
44 --This procedure will be called for all the langauges to translate the User_Defined_Status value
45 procedure TRANSLATE_ROW
46 (
47 P_STATUS_ID in NUMBER,
48 P_USER_DEFINED_STATUS in VARCHAR2,
49 P_ENTITY_TYPE in NUMBER,
50 P_OWNER in VARCHAR2,
51 P_LAST_UPDATE_DATE in VARCHAR2,
52 P_CUSTOM_MODE in VARCHAR2
53 );
54
55 --This procedure will be called during upgarde of seeded statuses
56 procedure LOAD_ROW
57 (
58 X_STATUS_ID in out nocopy NUMBER,
59 P_SEEDED_FLAG in VARCHAR2,
60 P_SYSTEM_STATUS in NUMBER,
61 P_ENABLED_FLAG in VARCHAR2,
62 P_USER_DEFINED_STATUS in VARCHAR2,
63 P_ENTITY_TYPE in NUMBER,
64 P_OWNER in VARCHAR2,
65 P_LAST_UPDATE_DATE in VARCHAR2,
66 P_CUSTOM_MODE in VARCHAR2
67 );
68
69
70 end EAM_SAFETY_STATUSES_PKG;