eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMW_NONSTANDARD_VARIATIONS_PKG dependencies on STANDARD

Line 1: package body AMW_NONSTANDARD_VARIATIONS_PKG as

1: package body AMW_NONSTANDARD_VARIATIONS_PKG as
2: /* $Header: amwnstvb.pls 120.1 2005/06/28 14:26:29 appldev noship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out NOCOPY VARCHAR2,

Line 23: cursor C is select ROWID from AMW_NONSTANDARD_VARIATIONS_B

19: X_LAST_UPDATE_DATE in DATE,
20: X_LAST_UPDATED_BY in NUMBER,
21: X_LAST_UPDATE_LOGIN in NUMBER
22: ) is
23: cursor C is select ROWID from AMW_NONSTANDARD_VARIATIONS_B
24: where VARIATION_ROW_ID = X_VARIATION_ROW_ID
25: ;
26: begin
27: insert into AMW_NONSTANDARD_VARIATIONS_B (

Line 27: insert into AMW_NONSTANDARD_VARIATIONS_B (

23: cursor C is select ROWID from AMW_NONSTANDARD_VARIATIONS_B
24: where VARIATION_ROW_ID = X_VARIATION_ROW_ID
25: ;
26: begin
27: insert into AMW_NONSTANDARD_VARIATIONS_B (
28: VARIATION_ROW_ID,
29: STD_PROCESS_ID,
30: STD_PROCESS_REV_NUM,
31: NON_STD_PROCESS_ID,

Line 61: insert into AMW_NONSTANDARD_VARIATIONS_TL (

57: X_LAST_UPDATED_BY,
58: X_LAST_UPDATE_LOGIN
59: );
60:
61: insert into AMW_NONSTANDARD_VARIATIONS_TL (
62: VARIATION_ROW_ID,
63: REASON,
64: LAST_UPDATE_DATE,
65: LAST_UPDATED_BY,

Line 87: from AMW_NONSTANDARD_VARIATIONS_TL T

83: from FND_LANGUAGES L
84: where L.INSTALLED_FLAG in ('I', 'B')
85: and not exists
86: (select NULL
87: from AMW_NONSTANDARD_VARIATIONS_TL T
88: where T.VARIATION_ROW_ID = X_VARIATION_ROW_ID
89: and T.LANGUAGE = L.LANGUAGE_CODE);
90:
91: open c;

Line 124: from AMW_NONSTANDARD_VARIATIONS_B

120: NON_STD_CHILD_ID,
121: START_DATE,
122: END_DATE,
123: OBJECT_VERSION_NUMBER
124: from AMW_NONSTANDARD_VARIATIONS_B
125: where VARIATION_ROW_ID = X_VARIATION_ROW_ID
126: for update of VARIATION_ROW_ID nowait;
127: recinfo c%rowtype;
128:

Line 132: from AMW_NONSTANDARD_VARIATIONS_TL

128:
129: cursor c1 is select
130: REASON,
131: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
132: from AMW_NONSTANDARD_VARIATIONS_TL
133: where VARIATION_ROW_ID = X_VARIATION_ROW_ID
134: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
135: for update of VARIATION_ROW_ID nowait;
136: begin

Line 201: update AMW_NONSTANDARD_VARIATIONS_B set

197: X_LAST_UPDATED_BY in NUMBER,
198: X_LAST_UPDATE_LOGIN in NUMBER
199: ) is
200: begin
201: update AMW_NONSTANDARD_VARIATIONS_B set
202: STD_PROCESS_ID = X_STD_PROCESS_ID,
203: STD_PROCESS_REV_NUM = X_STD_PROCESS_REV_NUM,
204: NON_STD_PROCESS_ID = X_NON_STD_PROCESS_ID,
205: NON_STD_PROCESS_REV_NUM = X_NON_STD_PROCESS_REV_NUM,

Line 220: update AMW_NONSTANDARD_VARIATIONS_TL set

216: if (sql%notfound) then
217: raise no_data_found;
218: end if;
219:
220: update AMW_NONSTANDARD_VARIATIONS_TL set
221: REASON = X_REASON,
222: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
223: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
224: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 238: delete from AMW_NONSTANDARD_VARIATIONS_TL

234: procedure DELETE_ROW (
235: X_VARIATION_ROW_ID in NUMBER
236: ) is
237: begin
238: delete from AMW_NONSTANDARD_VARIATIONS_TL
239: where VARIATION_ROW_ID = X_VARIATION_ROW_ID;
240:
241: if (sql%notfound) then
242: raise no_data_found;

Line 245: delete from AMW_NONSTANDARD_VARIATIONS_B

241: if (sql%notfound) then
242: raise no_data_found;
243: end if;
244:
245: delete from AMW_NONSTANDARD_VARIATIONS_B
246: where VARIATION_ROW_ID = X_VARIATION_ROW_ID;
247:
248: if (sql%notfound) then
249: raise no_data_found;

Line 256: delete from AMW_NONSTANDARD_VARIATIONS_TL T

252:
253: procedure ADD_LANGUAGE
254: is
255: begin
256: delete from AMW_NONSTANDARD_VARIATIONS_TL T
257: where not exists
258: (select NULL
259: from AMW_NONSTANDARD_VARIATIONS_B B
260: where B.VARIATION_ROW_ID = T.VARIATION_ROW_ID

Line 259: from AMW_NONSTANDARD_VARIATIONS_B B

255: begin
256: delete from AMW_NONSTANDARD_VARIATIONS_TL T
257: where not exists
258: (select NULL
259: from AMW_NONSTANDARD_VARIATIONS_B B
260: where B.VARIATION_ROW_ID = T.VARIATION_ROW_ID
261: );
262:
263: update AMW_NONSTANDARD_VARIATIONS_TL T set (

Line 263: update AMW_NONSTANDARD_VARIATIONS_TL T set (

259: from AMW_NONSTANDARD_VARIATIONS_B B
260: where B.VARIATION_ROW_ID = T.VARIATION_ROW_ID
261: );
262:
263: update AMW_NONSTANDARD_VARIATIONS_TL T set (
264: REASON
265: ) = (select
266: B.REASON
267: from AMW_NONSTANDARD_VARIATIONS_TL B

Line 267: from AMW_NONSTANDARD_VARIATIONS_TL B

263: update AMW_NONSTANDARD_VARIATIONS_TL T set (
264: REASON
265: ) = (select
266: B.REASON
267: from AMW_NONSTANDARD_VARIATIONS_TL B
268: where B.VARIATION_ROW_ID = T.VARIATION_ROW_ID
269: and B.LANGUAGE = T.SOURCE_LANG)
270: where (
271: T.VARIATION_ROW_ID,

Line 276: from AMW_NONSTANDARD_VARIATIONS_TL SUBB, AMW_NONSTANDARD_VARIATIONS_TL SUBT

272: T.LANGUAGE
273: ) in (select
274: SUBT.VARIATION_ROW_ID,
275: SUBT.LANGUAGE
276: from AMW_NONSTANDARD_VARIATIONS_TL SUBB, AMW_NONSTANDARD_VARIATIONS_TL SUBT
277: where SUBB.VARIATION_ROW_ID = SUBT.VARIATION_ROW_ID
278: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
279: and (SUBB.REASON <> SUBT.REASON
280: or (SUBB.REASON is null and SUBT.REASON is not null)

Line 284: insert into AMW_NONSTANDARD_VARIATIONS_TL (

280: or (SUBB.REASON is null and SUBT.REASON is not null)
281: or (SUBB.REASON is not null and SUBT.REASON is null)
282: ));
283:
284: insert into AMW_NONSTANDARD_VARIATIONS_TL (
285: VARIATION_ROW_ID,
286: REASON,
287: LAST_UPDATE_DATE,
288: LAST_UPDATED_BY,

Line 306: from AMW_NONSTANDARD_VARIATIONS_TL B, FND_LANGUAGES L

302: B.CREATED_BY,
303: B.OBJECT_VERSION_NUMBER,
304: L.LANGUAGE_CODE,
305: B.SOURCE_LANG
306: from AMW_NONSTANDARD_VARIATIONS_TL B, FND_LANGUAGES L
307: where L.INSTALLED_FLAG in ('I', 'B')
308: and B.LANGUAGE = userenv('LANG')
309: and not exists
310: (select NULL

Line 311: from AMW_NONSTANDARD_VARIATIONS_TL T

307: where L.INSTALLED_FLAG in ('I', 'B')
308: and B.LANGUAGE = userenv('LANG')
309: and not exists
310: (select NULL
311: from AMW_NONSTANDARD_VARIATIONS_TL T
312: where T.VARIATION_ROW_ID = B.VARIATION_ROW_ID
313: and T.LANGUAGE = L.LANGUAGE_CODE);
314: end ADD_LANGUAGE;
315:

Line 316: end AMW_NONSTANDARD_VARIATIONS_PKG;

312: where T.VARIATION_ROW_ID = B.VARIATION_ROW_ID
313: and T.LANGUAGE = L.LANGUAGE_CODE);
314: end ADD_LANGUAGE;
315:
316: end AMW_NONSTANDARD_VARIATIONS_PKG;