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.XDP_WI_FA_MAPPING_PKG dependencies on XDP_WI_FA_MAPPING

Line 1: package body XDP_WI_FA_MAPPING_PKG as

1: package body XDP_WI_FA_MAPPING_PKG as
2: /* $Header: XDPWFMPB.pls 120.2 2005/07/15 06:33:02 appldev ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in OUT NOCOPY VARCHAR2,
5: X_WI_FA_MAPPING_ID in NUMBER,

Line 16: cursor C is select ROWID from XDP_WI_FA_MAPPING

12: X_LAST_UPDATE_DATE in DATE,
13: X_LAST_UPDATED_BY in NUMBER,
14: X_LAST_UPDATE_LOGIN in NUMBER
15: ) is
16: cursor C is select ROWID from XDP_WI_FA_MAPPING
17: where WI_FA_MAPPING_ID = X_WI_FA_MAPPING_ID
18: ;
19: begin
20: insert into XDP_WI_FA_MAPPING (

Line 20: insert into XDP_WI_FA_MAPPING (

16: cursor C is select ROWID from XDP_WI_FA_MAPPING
17: where WI_FA_MAPPING_ID = X_WI_FA_MAPPING_ID
18: ;
19: begin
20: insert into XDP_WI_FA_MAPPING (
21: WI_FA_MAPPING_ID,
22: WORKITEM_ID,
23: FULFILLMENT_ACTION_ID,
24: PROVISIONING_SEQ,

Line 42: insert into XDP_WI_FA_MAPPING_TL (

38: X_LAST_UPDATED_BY,
39: X_LAST_UPDATE_LOGIN
40: );
41:
42: insert into XDP_WI_FA_MAPPING_TL (
43: WI_FA_MAPPING_ID,
44: DESCRIPTION,
45: CREATED_BY,
46: CREATION_DATE,

Line 66: from XDP_WI_FA_MAPPING_TL T

62: from FND_LANGUAGES L
63: where L.INSTALLED_FLAG in ('I', 'B')
64: and not exists
65: (select NULL
66: from XDP_WI_FA_MAPPING_TL T
67: where T.WI_FA_MAPPING_ID = X_WI_FA_MAPPING_ID
68: and T.LANGUAGE = L.LANGUAGE_CODE);
69:
70: open c;

Line 91: from XDP_WI_FA_MAPPING

87: cursor c is select
88: WORKITEM_ID,
89: FULFILLMENT_ACTION_ID,
90: PROVISIONING_SEQ
91: from XDP_WI_FA_MAPPING
92: where WI_FA_MAPPING_ID = X_WI_FA_MAPPING_ID
93: for update of WI_FA_MAPPING_ID nowait;
94: recinfo c%rowtype;
95:

Line 99: from XDP_WI_FA_MAPPING_TL

95:
96: cursor c1 is select
97: DESCRIPTION,
98: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
99: from XDP_WI_FA_MAPPING_TL
100: where WI_FA_MAPPING_ID = X_WI_FA_MAPPING_ID
101: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
102: for update of WI_FA_MAPPING_ID nowait;
103: begin

Line 148: update XDP_WI_FA_MAPPING set

144: X_LAST_UPDATED_BY in NUMBER,
145: X_LAST_UPDATE_LOGIN in NUMBER
146: ) is
147: begin
148: update XDP_WI_FA_MAPPING set
149: WORKITEM_ID = X_WORKITEM_ID,
150: FULFILLMENT_ACTION_ID = X_FULFILLMENT_ACTION_ID,
151: PROVISIONING_SEQ = X_PROVISIONING_SEQ,
152: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 161: update XDP_WI_FA_MAPPING_TL set

157: if (sql%notfound) then
158: raise no_data_found;
159: end if;
160:
161: update XDP_WI_FA_MAPPING_TL set
162: DESCRIPTION = X_DESCRIPTION,
163: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
164: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
165: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 179: delete from XDP_WI_FA_MAPPING_TL

175: procedure DELETE_ROW (
176: X_WI_FA_MAPPING_ID in NUMBER
177: ) is
178: begin
179: delete from XDP_WI_FA_MAPPING_TL
180: where WI_FA_MAPPING_ID = X_WI_FA_MAPPING_ID;
181:
182: if (sql%notfound) then
183: raise no_data_found;

Line 186: delete from XDP_WI_FA_MAPPING

182: if (sql%notfound) then
183: raise no_data_found;
184: end if;
185:
186: delete from XDP_WI_FA_MAPPING
187: where WI_FA_MAPPING_ID = X_WI_FA_MAPPING_ID;
188:
189: if (sql%notfound) then
190: raise no_data_found;

Line 197: delete from XDP_WI_FA_MAPPING_TL T

193:
194: procedure ADD_LANGUAGE
195: is
196: begin
197: delete from XDP_WI_FA_MAPPING_TL T
198: where not exists
199: (select NULL
200: from XDP_WI_FA_MAPPING B
201: where B.WI_FA_MAPPING_ID = T.WI_FA_MAPPING_ID

Line 200: from XDP_WI_FA_MAPPING B

196: begin
197: delete from XDP_WI_FA_MAPPING_TL T
198: where not exists
199: (select NULL
200: from XDP_WI_FA_MAPPING B
201: where B.WI_FA_MAPPING_ID = T.WI_FA_MAPPING_ID
202: );
203:
204: update XDP_WI_FA_MAPPING_TL T set (

Line 204: update XDP_WI_FA_MAPPING_TL T set (

200: from XDP_WI_FA_MAPPING B
201: where B.WI_FA_MAPPING_ID = T.WI_FA_MAPPING_ID
202: );
203:
204: update XDP_WI_FA_MAPPING_TL T set (
205: DESCRIPTION
206: ) = (select
207: B.DESCRIPTION
208: from XDP_WI_FA_MAPPING_TL B

Line 208: from XDP_WI_FA_MAPPING_TL B

204: update XDP_WI_FA_MAPPING_TL T set (
205: DESCRIPTION
206: ) = (select
207: B.DESCRIPTION
208: from XDP_WI_FA_MAPPING_TL B
209: where B.WI_FA_MAPPING_ID = T.WI_FA_MAPPING_ID
210: and B.LANGUAGE = T.SOURCE_LANG)
211: where (
212: T.WI_FA_MAPPING_ID,

Line 217: from XDP_WI_FA_MAPPING_TL SUBB, XDP_WI_FA_MAPPING_TL SUBT

213: T.LANGUAGE
214: ) in (select
215: SUBT.WI_FA_MAPPING_ID,
216: SUBT.LANGUAGE
217: from XDP_WI_FA_MAPPING_TL SUBB, XDP_WI_FA_MAPPING_TL SUBT
218: where SUBB.WI_FA_MAPPING_ID = SUBT.WI_FA_MAPPING_ID
219: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
220: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
221: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)

Line 225: insert into XDP_WI_FA_MAPPING_TL (

221: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
222: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
223: ));
224:
225: insert into XDP_WI_FA_MAPPING_TL (
226: WI_FA_MAPPING_ID,
227: DESCRIPTION,
228: CREATED_BY,
229: CREATION_DATE,

Line 245: from XDP_WI_FA_MAPPING_TL B, FND_LANGUAGES L

241: B.LAST_UPDATE_DATE,
242: B.LAST_UPDATE_LOGIN,
243: L.LANGUAGE_CODE,
244: B.SOURCE_LANG
245: from XDP_WI_FA_MAPPING_TL B, FND_LANGUAGES L
246: where L.INSTALLED_FLAG in ('I', 'B')
247: and B.LANGUAGE = userenv('LANG')
248: and not exists
249: (select NULL

Line 250: from XDP_WI_FA_MAPPING_TL T

246: where L.INSTALLED_FLAG in ('I', 'B')
247: and B.LANGUAGE = userenv('LANG')
248: and not exists
249: (select NULL
250: from XDP_WI_FA_MAPPING_TL T
251: where T.WI_FA_MAPPING_ID = B.WI_FA_MAPPING_ID
252: and T.LANGUAGE = L.LANGUAGE_CODE);
253: end ADD_LANGUAGE;
254:

Line 276: XDP_WI_FA_MAPPING_PKG.UPDATE_ROW (

272: -- user_id := 1;
273: --end if;
274: user_id := fnd_load_util.owner_id(X_OWNER);
275:
276: XDP_WI_FA_MAPPING_PKG.UPDATE_ROW (
277: X_WI_FA_MAPPING_ID => X_WI_FA_MAPPING_ID,
278: X_WORKITEM_ID => X_WORKITEM_ID,
279: X_FULFILLMENT_ACTION_ID => X_FULFILLMENT_ACTION_ID,
280: X_PROVISIONING_SEQ => X_PROVISIONING_SEQ,

Line 288: XDP_WI_FA_MAPPING_PKG.INSERT_ROW (

284: X_LAST_UPDATE_LOGIN => 0);
285:
286: exception
287: when NO_DATA_FOUND then
288: XDP_WI_FA_MAPPING_PKG.INSERT_ROW (
289: X_ROWID => row_id,
290: X_WI_FA_MAPPING_ID => X_WI_FA_MAPPING_ID,
291: X_WORKITEM_ID => X_WORKITEM_ID,
292: X_FULFILLMENT_ACTION_ID => X_FULFILLMENT_ACTION_ID,

Line 312: update XDP_WI_FA_MAPPING_TL

308: begin
309:
310: -- only update rows that have not been altered by user
311:
312: update XDP_WI_FA_MAPPING_TL
313: set description = X_DESCRIPTION,
314: source_lang = userenv('LANG'),
315: last_update_date = sysdate,
316: --last_updated_by = decode(X_OWNER, 'SEED', 1, 0), /*dputhiye 15-JUL-2005. DECODE replaced with FND API.*/

Line 324: end XDP_WI_FA_MAPPING_PKG;

320: and userenv('LANG') in (language, source_lang);
321:
322: end TRANSLATE_ROW;
323:
324: end XDP_WI_FA_MAPPING_PKG;