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.FND_PRODUCT_INITIALIZATION_PKG dependencies on FND_PRODUCT_INIT_CONDITION

Line 80: delete from FND_PRODUCT_INIT_CONDITION

76: procedure RemoveInitCondition(x_apps_name in varchar2,
77: x_condition in varchar2) is
78: begin
79: begin
80: delete from FND_PRODUCT_INIT_CONDITION
81: where APPLICATION_SHORT_NAME = upper(x_apps_name)
82: and RE_INIT_CONDITION = upper(x_condition);
83:
84: exception

Line 277: 'from FND_PRODUCT_INIT_CONDITION C '||

273: 'from FND_PRODUCT_INITIALIZATION '||
274: 'where APPLICATION_SHORT_NAME = :v1 '||
275: 'and exists '||
276: '(select 1 '||
277: 'from FND_PRODUCT_INIT_CONDITION C '||
278: 'where C.APPLICATION_SHORT_NAME = :v2 '||
279: 'and C.RE_INIT_CONDITION in ('||conditions||'))';
280:
281: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

Line 304: from FND_PRODUCT_INIT_CONDITION C

300: from FND_PRODUCT_INITIALIZATION
301: where APPLICATION_SHORT_NAME = deparr(i)
302: and exists
303: (select 1
304: from FND_PRODUCT_INIT_CONDITION C
305: where C.APPLICATION_SHORT_NAME = deparr(i)
306: and C.RE_INIT_CONDITION in (strings(1)));
307: elsif (n = 2) then
308: select INIT_FUNCTION_NAME

Line 314: from FND_PRODUCT_INIT_CONDITION C

310: from FND_PRODUCT_INITIALIZATION
311: where APPLICATION_SHORT_NAME = deparr(i)
312: and exists
313: (select 1
314: from FND_PRODUCT_INIT_CONDITION C
315: where C.APPLICATION_SHORT_NAME = deparr(i)
316: and C.RE_INIT_CONDITION in (strings(1), strings(2)));
317: elsif (n = 3) then
318: select INIT_FUNCTION_NAME

Line 324: from FND_PRODUCT_INIT_CONDITION C

320: from FND_PRODUCT_INITIALIZATION
321: where APPLICATION_SHORT_NAME = deparr(i)
322: and exists
323: (select 1
324: from FND_PRODUCT_INIT_CONDITION C
325: where C.APPLICATION_SHORT_NAME = deparr(i)
326: and C.RE_INIT_CONDITION in (strings(1), strings(2), strings(3)));
327: elsif (n = 4) then
328: select INIT_FUNCTION_NAME

Line 334: from FND_PRODUCT_INIT_CONDITION C

330: from FND_PRODUCT_INITIALIZATION
331: where APPLICATION_SHORT_NAME = deparr(i)
332: and exists
333: (select 1
334: from FND_PRODUCT_INIT_CONDITION C
335: where C.APPLICATION_SHORT_NAME = deparr(i)
336: and C.RE_INIT_CONDITION in (strings(1), strings(2), strings(3), strings(4)));
337: elsif (n = 5) then
338: select INIT_FUNCTION_NAME

Line 344: from FND_PRODUCT_INIT_CONDITION C

340: from FND_PRODUCT_INITIALIZATION
341: where APPLICATION_SHORT_NAME = deparr(i)
342: and exists
343: (select 1
344: from FND_PRODUCT_INIT_CONDITION C
345: where C.APPLICATION_SHORT_NAME = deparr(i)
346: and C.RE_INIT_CONDITION in (strings(1), strings(2), strings(3), strings(4), strings(5)));
347: elsif (n = 6) then
348: select INIT_FUNCTION_NAME

Line 354: from FND_PRODUCT_INIT_CONDITION C

350: from FND_PRODUCT_INITIALIZATION
351: where APPLICATION_SHORT_NAME = deparr(i)
352: and exists
353: (select 1
354: from FND_PRODUCT_INIT_CONDITION C
355: where C.APPLICATION_SHORT_NAME = deparr(i)
356: and C.RE_INIT_CONDITION in (strings(1), strings(2), strings(3), strings(4), strings(5), strings(6)));
357: elsif (n = 7) then
358: select INIT_FUNCTION_NAME

Line 364: from FND_PRODUCT_INIT_CONDITION C

360: from FND_PRODUCT_INITIALIZATION
361: where APPLICATION_SHORT_NAME = deparr(i)
362: and exists
363: (select 1
364: from FND_PRODUCT_INIT_CONDITION C
365: where C.APPLICATION_SHORT_NAME = deparr(i)
366: and C.RE_INIT_CONDITION in (strings(1), strings(2), strings(3), strings(4), strings(5), strings(6), strings(7)));
367: elsif (n = 8) then
368: select INIT_FUNCTION_NAME

Line 374: from FND_PRODUCT_INIT_CONDITION C

370: from FND_PRODUCT_INITIALIZATION
371: where APPLICATION_SHORT_NAME = deparr(i)
372: and exists
373: (select 1
374: from FND_PRODUCT_INIT_CONDITION C
375: where C.APPLICATION_SHORT_NAME = deparr(i)
376: and C.RE_INIT_CONDITION in (strings(1), strings(2), strings(3), strings(4), strings(5), strings(6), strings(7), strings(8)));
377: elsif (n = 9) then
378: select INIT_FUNCTION_NAME

Line 384: from FND_PRODUCT_INIT_CONDITION C

380: from FND_PRODUCT_INITIALIZATION
381: where APPLICATION_SHORT_NAME = deparr(i)
382: and exists
383: (select 1
384: from FND_PRODUCT_INIT_CONDITION C
385: where C.APPLICATION_SHORT_NAME = deparr(i)
386: and C.RE_INIT_CONDITION in (strings(1), strings(2), strings(3), strings(4), strings(5), strings(6), strings(7), strings(8), strings(9)));
387: elsif (n = 10) then
388: select INIT_FUNCTION_NAME

Line 394: from FND_PRODUCT_INIT_CONDITION C

390: from FND_PRODUCT_INITIALIZATION
391: where APPLICATION_SHORT_NAME = deparr(i)
392: and exists
393: (select 1
394: from FND_PRODUCT_INIT_CONDITION C
395: where C.APPLICATION_SHORT_NAME = deparr(i)
396: and C.RE_INIT_CONDITION in (strings(1), strings(2), strings(3), strings(4), strings(5), strings(6), strings(7), strings(8), strings(9), strings(10)));
397: end if;
398: exception

Line 614: insert into FND_PRODUCT_INIT_CONDITION(

610: -- Translate char last_update_date to date
611: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
612:
613: begin
614: insert into FND_PRODUCT_INIT_CONDITION(
615: APPLICATION_SHORT_NAME,
616: RE_INIT_CONDITION,
617: LAST_UPDATED_BY,
618: LAST_UPDATE_DATE,

Line 678: delete from fnd_product_init_condition

674: begin
675: delete from fnd_product_init_dependency
676: where application_short_name = apps_short_name;
677:
678: delete from fnd_product_init_condition
679: where application_short_name = apps_short_name;
680:
681: delete from fnd_product_initialization
682: where application_short_name = apps_short_name;