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_FULFILL_ACTIONS_PKG dependencies on XDP_FULFILL_ACTIONS

Line 1: package body XDP_FULFILL_ACTIONS_PKG as

1: package body XDP_FULFILL_ACTIONS_PKG as
2: /* $Header: XDPFAB.pls 120.2 2005/07/14 08:32:27 appldev ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in OUT NOCOPY VARCHAR2,
5: X_FULFILLMENT_ACTION_ID in NUMBER,

Line 20: cursor C is select ROWID from XDP_FULFILL_ACTIONS

16: X_LAST_UPDATE_DATE in DATE,
17: X_LAST_UPDATED_BY in NUMBER,
18: X_LAST_UPDATE_LOGIN in NUMBER
19: ) is
20: cursor C is select ROWID from XDP_FULFILL_ACTIONS
21: where FULFILLMENT_ACTION_ID = X_FULFILLMENT_ACTION_ID
22: ;
23: begin
24: insert into XDP_FULFILL_ACTIONS (

Line 24: insert into XDP_FULFILL_ACTIONS (

20: cursor C is select ROWID from XDP_FULFILL_ACTIONS
21: where FULFILLMENT_ACTION_ID = X_FULFILLMENT_ACTION_ID
22: ;
23: begin
24: insert into XDP_FULFILL_ACTIONS (
25: FULFILLMENT_ACTION_ID,
26: FULFILLMENT_ACTION,
27: VERSION,
28: FE_ROUTING_PROC,

Line 52: insert into XDP_FULFILL_ACTIONS_TL (

48: X_LAST_UPDATED_BY,
49: X_LAST_UPDATE_LOGIN
50: );
51:
52: insert into XDP_FULFILL_ACTIONS_TL (
53: FULFILLMENT_ACTION_ID,
54: DISPLAY_NAME,
55: DESCRIPTION,
56: CREATED_BY,

Line 78: from XDP_FULFILL_ACTIONS_TL T

74: from FND_LANGUAGES L
75: where L.INSTALLED_FLAG in ('I', 'B')
76: and not exists
77: (select NULL
78: from XDP_FULFILL_ACTIONS_TL T
79: where T.FULFILLMENT_ACTION_ID = X_FULFILLMENT_ACTION_ID
80: and T.LANGUAGE = L.LANGUAGE_CODE);
81:
82: open c;

Line 110: from XDP_FULFILL_ACTIONS

106: FE_ROUTING_PROC,
107: EVALUATE_PARAM_PROC,
108: FA_TYPE_CODE,
109: ROLE_NAME
110: from XDP_FULFILL_ACTIONS
111: where FULFILLMENT_ACTION_ID = X_FULFILLMENT_ACTION_ID
112: for update of FULFILLMENT_ACTION_ID nowait;
113: recinfo c%rowtype;
114:

Line 119: from XDP_FULFILL_ACTIONS_TL

115: cursor c1 is select
116: DISPLAY_NAME,
117: DESCRIPTION,
118: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
119: from XDP_FULFILL_ACTIONS_TL
120: where FULFILLMENT_ACTION_ID = X_FULFILLMENT_ACTION_ID
121: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
122: for update of FULFILLMENT_ACTION_ID nowait;
123: begin

Line 180: update XDP_FULFILL_ACTIONS set

176: X_LAST_UPDATED_BY in NUMBER,
177: X_LAST_UPDATE_LOGIN in NUMBER
178: ) is
179: begin
180: update XDP_FULFILL_ACTIONS set
181: FULFILLMENT_ACTION = X_FULFILLMENT_ACTION,
182: VERSION = X_VERSION,
183: FE_ROUTING_PROC = X_FE_ROUTING_PROC,
184: EVALUATE_PARAM_PROC = X_EVALUATE_PARAM_PROC,

Line 196: update XDP_FULFILL_ACTIONS_TL set

192: if (sql%notfound) then
193: raise no_data_found;
194: end if;
195:
196: update XDP_FULFILL_ACTIONS_TL set
197: DISPLAY_NAME = X_DISPLAY_NAME,
198: DESCRIPTION = X_DESCRIPTION,
199: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
200: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 215: delete from XDP_FULFILL_ACTIONS_TL

211: procedure DELETE_ROW (
212: X_FULFILLMENT_ACTION_ID in NUMBER
213: ) is
214: begin
215: delete from XDP_FULFILL_ACTIONS_TL
216: where FULFILLMENT_ACTION_ID = X_FULFILLMENT_ACTION_ID;
217:
218: if (sql%notfound) then
219: raise no_data_found;

Line 222: delete from XDP_FULFILL_ACTIONS

218: if (sql%notfound) then
219: raise no_data_found;
220: end if;
221:
222: delete from XDP_FULFILL_ACTIONS
223: where FULFILLMENT_ACTION_ID = X_FULFILLMENT_ACTION_ID;
224:
225: if (sql%notfound) then
226: raise no_data_found;

Line 233: delete from XDP_FULFILL_ACTIONS_TL T

229:
230: procedure ADD_LANGUAGE
231: is
232: begin
233: delete from XDP_FULFILL_ACTIONS_TL T
234: where not exists
235: (select NULL
236: from XDP_FULFILL_ACTIONS B
237: where B.FULFILLMENT_ACTION_ID = T.FULFILLMENT_ACTION_ID

Line 236: from XDP_FULFILL_ACTIONS B

232: begin
233: delete from XDP_FULFILL_ACTIONS_TL T
234: where not exists
235: (select NULL
236: from XDP_FULFILL_ACTIONS B
237: where B.FULFILLMENT_ACTION_ID = T.FULFILLMENT_ACTION_ID
238: );
239:
240: update XDP_FULFILL_ACTIONS_TL T set (

Line 240: update XDP_FULFILL_ACTIONS_TL T set (

236: from XDP_FULFILL_ACTIONS B
237: where B.FULFILLMENT_ACTION_ID = T.FULFILLMENT_ACTION_ID
238: );
239:
240: update XDP_FULFILL_ACTIONS_TL T set (
241: DISPLAY_NAME,
242: DESCRIPTION
243: ) = (select
244: B.DISPLAY_NAME,

Line 246: from XDP_FULFILL_ACTIONS_TL B

242: DESCRIPTION
243: ) = (select
244: B.DISPLAY_NAME,
245: B.DESCRIPTION
246: from XDP_FULFILL_ACTIONS_TL B
247: where B.FULFILLMENT_ACTION_ID = T.FULFILLMENT_ACTION_ID
248: and B.LANGUAGE = T.SOURCE_LANG)
249: where (
250: T.FULFILLMENT_ACTION_ID,

Line 255: from XDP_FULFILL_ACTIONS_TL SUBB, XDP_FULFILL_ACTIONS_TL SUBT

251: T.LANGUAGE
252: ) in (select
253: SUBT.FULFILLMENT_ACTION_ID,
254: SUBT.LANGUAGE
255: from XDP_FULFILL_ACTIONS_TL SUBB, XDP_FULFILL_ACTIONS_TL SUBT
256: where SUBB.FULFILLMENT_ACTION_ID = SUBT.FULFILLMENT_ACTION_ID
257: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
258: and (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME
259: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 264: insert into XDP_FULFILL_ACTIONS_TL (

260: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
261: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
262: ));
263:
264: insert into XDP_FULFILL_ACTIONS_TL (
265: FULFILLMENT_ACTION_ID,
266: DISPLAY_NAME,
267: DESCRIPTION,
268: CREATED_BY,

Line 286: from XDP_FULFILL_ACTIONS_TL B, FND_LANGUAGES L

282: B.LAST_UPDATE_DATE,
283: B.LAST_UPDATE_LOGIN,
284: L.LANGUAGE_CODE,
285: B.SOURCE_LANG
286: from XDP_FULFILL_ACTIONS_TL B, FND_LANGUAGES L
287: where L.INSTALLED_FLAG in ('I', 'B')
288: and B.LANGUAGE = userenv('LANG')
289: and not exists
290: (select NULL

Line 291: from XDP_FULFILL_ACTIONS_TL T

287: where L.INSTALLED_FLAG in ('I', 'B')
288: and B.LANGUAGE = userenv('LANG')
289: and not exists
290: (select NULL
291: from XDP_FULFILL_ACTIONS_TL T
292: where T.FULFILLMENT_ACTION_ID = B.FULFILLMENT_ACTION_ID
293: and T.LANGUAGE = L.LANGUAGE_CODE);
294: end ADD_LANGUAGE;
295:

Line 321: XDP_FULFILL_ACTIONS_PKG.UPDATE_ROW (

317: -- user_id := 1;
318: --end if;
319: user_id := fnd_load_util.owner_id(X_OWNER);
320:
321: XDP_FULFILL_ACTIONS_PKG.UPDATE_ROW (
322: X_FULFILLMENT_ACTION_ID => X_FULFILLMENT_ACTION_ID,
323: X_FULFILLMENT_ACTION => X_FULFILLMENT_ACTION,
324: X_VERSION => X_VERSION,
325: X_FE_ROUTING_PROC => X_FE_ROUTING_PROC,

Line 337: XDP_FULFILL_ACTIONS_PKG.INSERT_ROW (

333: X_LAST_UPDATE_LOGIN => 0);
334:
335: exception
336: when NO_DATA_FOUND then
337: XDP_FULFILL_ACTIONS_PKG.INSERT_ROW (
338: X_ROWID => row_id,
339: X_FULFILLMENT_ACTION_ID => X_FULFILLMENT_ACTION_ID,
340: X_FULFILLMENT_ACTION => X_FULFILLMENT_ACTION,
341: X_VERSION => X_VERSION,

Line 366: update XDP_FULFILL_ACTIONS_TL

362: begin
363:
364: -- only update rows that have not been altered by user
365:
366: update XDP_FULFILL_ACTIONS_TL
367: set display_name = X_DISPLAY_NAME,
368: description = X_DESCRIPTION,
369: source_lang = userenv('LANG'),
370: last_update_date = sysdate,

Line 380: end XDP_FULFILL_ACTIONS_PKG;

376:
377: end TRANSLATE_ROW;
378:
379:
380: end XDP_FULFILL_ACTIONS_PKG;