1 package EAM_POPULATE_STATUSES_PKG as
2 /* $Header: EAMVUDSS.pls 120.2 2006/01/12 04:16:22 cboppana noship $ */
3
4 --This procedure will insert new rows in Eam_Wo_Statuses_B and Eam_Wo_Statues_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_CREATION_DATE in DATE,
13 P_CREATED_BY in NUMBER,
14 P_LAST_UPDATE_DATE in DATE,
15 P_LAST_UPDATED_BY in NUMBER,
16 P_LAST_UPDATE_LOGIN in NUMBER
17 );
18
19 --This procedure will update rows in Eam_Wo_Statuses_B and Eam_Wo_Statues_TL tables
20 procedure UPDATE_ROW (
21 P_STATUS_ID in NUMBER,
22 P_SEEDED_FLAG in VARCHAR2,
23 P_SYSTEM_STATUS in NUMBER,
24 P_ENABLED_FLAG in VARCHAR2,
25 P_USER_DEFINED_STATUS in VARCHAR2,
26 P_LAST_UPDATE_DATE in DATE,
27 P_LAST_UPDATED_BY in NUMBER,
28 P_LAST_UPDATE_LOGIN in NUMBER,
29 P_MODE in VARCHAR2 DEFAULT 'FORMS'
30 );
31
32 --This procedure will delete rows in Eam_Wo_Statuses_B and Eam_Wo_Statues_TL tables
33 procedure DELETE_ROW (
34 P_STATUS_ID in NUMBER
35 );
36
37 --This procedure will be called when a new langauge is installed. This will insert rows
38 -- in Eam_Wo_Statuses_TL table for the new langauge
39 procedure ADD_LANGUAGE;
40
41 --This procedure will be called for all the langauges to translate the User_Defined_Status value
42 procedure TRANSLATE_ROW
43 (
44 P_STATUS_ID in NUMBER,
45 P_USER_DEFINED_STATUS in VARCHAR2,
46 P_OWNER in VARCHAR2,
47 P_LAST_UPDATE_DATE in VARCHAR2,
48 P_CUSTOM_MODE in VARCHAR2
49 );
50
51 --This procedure will be called during upgarde of seeded statuses
52 procedure LOAD_ROW
53 (
54 X_STATUS_ID in out nocopy NUMBER,
55 P_SEEDED_FLAG in VARCHAR2,
56 P_SYSTEM_STATUS in NUMBER,
57 P_ENABLED_FLAG in VARCHAR2,
58 P_USER_DEFINED_STATUS in VARCHAR2,
59 P_OWNER in VARCHAR2,
60 P_LAST_UPDATE_DATE in VARCHAR2,
61 P_CUSTOM_MODE in VARCHAR2
62 );
63
64
65 end EAM_POPULATE_STATUSES_PKG;