APPS.EAM_POPULATE_STATUSES_PKG dependencies on EAM_WO_STATUSES_TL

Line 57: insert into EAM_WO_STATUSES_TL (

53:
54: IF( P_USER_DEFINED_STATUS IS NOT NULL) THEN
55: -- user_defined_status will be Null for seeded WIP statuses
56:
57: insert into EAM_WO_STATUSES_TL (
58: LAST_UPDATE_LOGIN,
59: CREATION_DATE,
60: STATUS_ID,
61: USER_DEFINED_STATUS,

Line 83: from EAM_WO_STATUSES_TL T

79: where
80: L.INSTALLED_FLAG in ('I', 'B')
81: and not exists
82: (select NULL
83: from EAM_WO_STATUSES_TL T
84: where T.STATUS_ID = X_STATUS_ID
85: and T.LANGUAGE = L.LANGUAGE_CODE);
86:
87: open c;

Line 131: update EAM_WO_STATUSES_TL set

127:
128: IF (P_USER_DEFINED_STATUS IS NOT NULL) THEN
129: -- user_defined_status will be Null for seeded WIP statuses
130:
131: update EAM_WO_STATUSES_TL set
132: USER_DEFINED_STATUS = P_USER_DEFINED_STATUS,
133: LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,
134: LAST_UPDATED_BY = P_LAST_UPDATED_BY,
135: LAST_UPDATE_LOGIN = P_LAST_UPDATE_LOGIN,

Line 173: delete from EAM_WO_STATUSES_TL

169: P_STATUS_ID in NUMBER
170: ) is
171: begin
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;

Line 185: -- in Eam_Wo_Statuses_TL table for the new langauge

181: end if;
182: end DELETE_ROW;
183:
184: --This procedure will be called when a new langauge is installed. This will insert rows
185: -- in Eam_Wo_Statuses_TL table for the new langauge
186: procedure ADD_LANGUAGE
187: is
188: begin
189:

Line 190: delete from EAM_WO_STATUSES_TL T

186: procedure ADD_LANGUAGE
187: is
188: begin
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

Line 197: update EAM_WO_STATUSES_TL T set (

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 (
198: USER_DEFINED_STATUS
199: ) = (select
200: B.USER_DEFINED_STATUS
201: from

Line 202: EAM_WO_STATUSES_TL B

198: USER_DEFINED_STATUS
199: ) = (select
200: B.USER_DEFINED_STATUS
201: from
202: EAM_WO_STATUSES_TL B
203: where
204: B.STATUS_ID = T.STATUS_ID
205: and B.LANGUAGE = T.SOURCE_LANG)
206: where (

Line 212: from EAM_WO_STATUSES_TL SUBB, EAM_WO_STATUSES_TL SUBT

208: T.LANGUAGE
209: ) in (select
210: SUBT.STATUS_ID,
211: SUBT.LANGUAGE
212: from EAM_WO_STATUSES_TL SUBB, EAM_WO_STATUSES_TL SUBT
213: where SUBB.STATUS_ID = SUBT.STATUS_ID
214: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
215: and (SUBB.USER_DEFINED_STATUS <> SUBT.USER_DEFINED_STATUS
216: ));

Line 218: insert into EAM_WO_STATUSES_TL (

214: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
215: and (SUBB.USER_DEFINED_STATUS <> SUBT.USER_DEFINED_STATUS
216: ));
217:
218: insert into EAM_WO_STATUSES_TL (
219: LAST_UPDATE_LOGIN,
220: CREATION_DATE,
221: STATUS_ID,
222: USER_DEFINED_STATUS,

Line 238: from EAM_WO_STATUSES_TL B, FND_LANGUAGES L

234: B.LAST_UPDATED_BY,
235: B.CREATED_BY,
236: L.LANGUAGE_CODE,
237: B.SOURCE_LANG
238: from EAM_WO_STATUSES_TL B, FND_LANGUAGES L
239: where L.INSTALLED_FLAG in ('I', 'B')
240: and B.LANGUAGE = userenv('LANG')
241: and not exists
242: (select NULL

Line 243: from EAM_WO_STATUSES_TL T

239: where L.INSTALLED_FLAG in ('I', 'B')
240: and B.LANGUAGE = userenv('LANG')
241: and not exists
242: (select NULL
243: from EAM_WO_STATUSES_TL T
244: where T.STATUS_ID = B.STATUS_ID
245: and T.LANGUAGE = L.LANGUAGE_CODE);
246:
247: end ADD_LANGUAGE;

Line 272: from EAM_WO_STATUSES_TL

268: f_ludate := nvl(to_date(P_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
269:
270: select LAST_UPDATED_BY, LAST_UPDATE_DATE
271: into db_luby, db_ludate
272: from EAM_WO_STATUSES_TL
273: where STATUS_ID = P_STATUS_ID
274: and language = userenv('LANG') ;
275:
276: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 279: update EAM_WO_STATUSES_TL set

275:
276: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
277: db_ludate, P_CUSTOM_MODE)) then
278:
279: update EAM_WO_STATUSES_TL set
280: user_defined_status = P_USER_DEFINED_STATUS,
281: last_update_date = f_ludate ,
282: last_updated_by = f_luby,
283: last_update_login = 0,