APPS.EAM_SAFETY_STATUSES_PKG dependencies on EAM_SAFETY_USR_DEF_STATUSES_B

Line 24: --This procedure will insert new rows in EAM_SAFETY_USR_DEF_STATUSES_B and eam_safety_usr_def_statuses_tl tables

20: -- 24-MAR-2010 vboddapa Initial Creation
21: ***************************************************************************/
22:
23:
24: --This procedure will insert new rows in EAM_SAFETY_USR_DEF_STATUSES_B and eam_safety_usr_def_statuses_tl tables
25: procedure INSERT_ROW (
26: X_ROWID in out NOCOPY VARCHAR2,
27: X_STATUS_ID in out NOCOPY NUMBER,
28: P_SEEDED_FLAG in VARCHAR2,

Line 40: cursor C is select ROWID from eam_safety_usr_def_statuses_b

36: P_LAST_UPDATED_BY in NUMBER,
37: P_LAST_UPDATE_LOGIN in NUMBER
38: ) is
39:
40: cursor C is select ROWID from eam_safety_usr_def_statuses_b
41: where STATUS_ID = X_STATUS_ID and
42: entity_type = P_ENTITY_TYPE;
43:
44: CURSOR C2 IS SELECT eam_wo_statuses_b_s.nextval FROM sys.dual;

Line 54: insert into eam_safety_usr_def_statuses_b (

50: CLOSE C2;
51: end if;
52:
53:
54: insert into eam_safety_usr_def_statuses_b (
55: STATUS_ID,
56: SEEDED_FLAG,
57: ENTITY_TYPE,
58: SYSTEM_STATUS,

Line 124: --This procedure will update rows in EAM_SAFETY_USR_DEF_STATUSES_B and eam_safety_usr_def_statuses_tl tables

120: close c;
121: END IF;
122: end INSERT_ROW;
123:
124: --This procedure will update rows in EAM_SAFETY_USR_DEF_STATUSES_B and eam_safety_usr_def_statuses_tl tables
125: procedure UPDATE_ROW (
126: P_STATUS_ID in NUMBER,
127: P_SEEDED_FLAG in VARCHAR2,
128: P_SYSTEM_STATUS in NUMBER,

Line 143: update eam_safety_usr_def_statuses_b set

139: l_resp_id NUMBER;
140: l_request_id NUMBER;
141: begin
142:
143: update eam_safety_usr_def_statuses_b set
144: SEEDED_FLAG = P_SEEDED_FLAG,
145: SYSTEM_STATUS = P_SYSTEM_STATUS,
146: ENABLED_FLAG = P_ENABLED_FLAG,
147: LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,

Line 197: --This procedure will delete rows in EAM_SAFETY_USR_DEF_STATUSES_B and eam_safety_usr_def_statuses_tl tables

193: end UPDATE_ROW;
194:
195:
196:
197: --This procedure will delete rows in EAM_SAFETY_USR_DEF_STATUSES_B and eam_safety_usr_def_statuses_tl tables
198: procedure DELETE_ROW (
199: P_STATUS_ID in NUMBER,
200: P_ENTITY_TYPE in NUMBER
201: ) is

Line 208: delete from eam_safety_usr_def_statuses_b

204: delete from eam_safety_usr_def_statuses_tl
205: where STATUS_ID = P_STATUS_ID
206: and ENTITY_TYPE = P_ENTITY_TYPE;
207:
208: delete from eam_safety_usr_def_statuses_b
209: where STATUS_ID = P_STATUS_ID
210: and ENTITY_TYPE = P_ENTITY_TYPE;
211:
212: if (sql%notfound) then

Line 226: from eam_safety_usr_def_statuses_b B

222:
223: delete from eam_safety_usr_def_statuses_tl T
224: where not exists
225: (select NULL
226: from eam_safety_usr_def_statuses_b B
227: where B.STATUS_ID = T.STATUS_ID
228: and B.ENTITY_TYPE = T.ENTITY_TYPE
229: );
230:

Line 369: from eam_safety_usr_def_statuses_b

365: f_ludate := nvl(to_date(P_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
366:
367: select LAST_UPDATED_BY, LAST_UPDATE_DATE
368: into db_luby, db_ludate
369: from eam_safety_usr_def_statuses_b
370: where status_id = X_STATUS_ID
371: and ENTITY_TYPE = P_ENTITY_TYPE;
372:
373: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,