APPS.EAM_POPULATE_STATUSES_PKG dependencies on EAM_WO_STATUSES_B

Line 4: --This procedure will insert new rows in Eam_Wo_Statuses_B and Eam_Wo_Statues_TL tables

1: package body EAM_POPULATE_STATUSES_PKG as
2: /* $Header: EAMVUDSB.pls 120.2 2006/02/22 06:14:18 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,

Line 19: cursor C is select ROWID from EAM_WO_STATUSES_B

15: P_LAST_UPDATED_BY in NUMBER,
16: P_LAST_UPDATE_LOGIN in NUMBER
17: ) is
18:
19: cursor C is select ROWID from EAM_WO_STATUSES_B
20: where STATUS_ID = X_STATUS_ID ;
21:
22: CURSOR C2 IS SELECT eam_wo_statuses_b_s.nextval FROM sys.dual;
23:

Line 22: CURSOR C2 IS SELECT eam_wo_statuses_b_s.nextval FROM sys.dual;

18:
19: cursor C is select ROWID from EAM_WO_STATUSES_B
20: where STATUS_ID = X_STATUS_ID ;
21:
22: CURSOR C2 IS SELECT eam_wo_statuses_b_s.nextval FROM sys.dual;
23:
24: begin
25: if (X_Status_Id is NULL) then
26: OPEN C2;

Line 32: insert into EAM_WO_STATUSES_B (

28: CLOSE C2;
29: end if;
30:
31:
32: insert into EAM_WO_STATUSES_B (
33: STATUS_ID,
34: SEEDED_FLAG,
35: SYSTEM_STATUS,
36: ENABLED_FLAG,

Line 97: --This procedure will update rows in Eam_Wo_Statuses_B and Eam_Wo_Statues_TL tables

93: close c;
94: END IF;
95: end INSERT_ROW;
96:
97: --This procedure will update rows in Eam_Wo_Statuses_B and Eam_Wo_Statues_TL tables
98: procedure UPDATE_ROW (
99: P_STATUS_ID in NUMBER,
100: P_SEEDED_FLAG in VARCHAR2,
101: P_SYSTEM_STATUS in NUMBER,

Line 115: update EAM_WO_STATUSES_B set

111: l_resp_id NUMBER;
112: l_request_id NUMBER;
113: begin
114:
115: update EAM_WO_STATUSES_B set
116: SEEDED_FLAG = P_SEEDED_FLAG,
117: SYSTEM_STATUS = P_SYSTEM_STATUS,
118: ENABLED_FLAG = P_ENABLED_FLAG,
119: LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,

Line 167: --This procedure will delete rows in Eam_Wo_Statuses_B and Eam_Wo_Statues_TL tables

163: end UPDATE_ROW;
164:
165:
166:
167: --This procedure will delete rows in Eam_Wo_Statuses_B and Eam_Wo_Statues_TL tables
168: procedure DELETE_ROW (
169: P_STATUS_ID in NUMBER
170: ) is
171: begin

Line 176: delete from EAM_WO_STATUSES_B

172:
173: delete from EAM_WO_STATUSES_TL
174: where STATUS_ID = P_STATUS_ID;
175:
176: delete from EAM_WO_STATUSES_B
177: where STATUS_ID = P_STATUS_ID;
178:
179: if (sql%notfound) then
180: raise no_data_found;

Line 193: from EAM_WO_STATUSES_B B

189:
190: delete from EAM_WO_STATUSES_TL T
191: where not exists
192: (select NULL
193: from EAM_WO_STATUSES_B B
194: where B.STATUS_ID = T.STATUS_ID
195: );
196:
197: update EAM_WO_STATUSES_TL T set (

Line 323: from EAM_WO_STATUSES_B

319: f_ludate := nvl(to_date(P_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
320:
321: select LAST_UPDATED_BY, LAST_UPDATE_DATE
322: into db_luby, db_ludate
323: from EAM_WO_STATUSES_B
324: where status_id = X_STATUS_ID;
325:
326: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
327: db_ludate,P_CUSTOM_MODE)) then