APPS.XDP_FULFILL_ACTIONS_PKG dependencies on XDP_FULFILL_ACTIONS_TL

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 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 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 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 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 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,