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_SET dependencies on FND_CONCURRENT_PROGRAMS

Line 173: program_id fnd_concurrent_programs.concurrent_program_id%TYPE;

169:
170: /* Get a concurrent program ID given appl ID and short name */
171: FUNCTION concurrent_program_id_f(program_application_id number,
172: program_short_name varchar2) return number is
173: program_id fnd_concurrent_programs.concurrent_program_id%TYPE;
174: BEGIN
175: SELECT concurrent_program_id
176: INTO program_id
177: FROM fnd_concurrent_programs

Line 177: FROM fnd_concurrent_programs

173: program_id fnd_concurrent_programs.concurrent_program_id%TYPE;
174: BEGIN
175: SELECT concurrent_program_id
176: INTO program_id
177: FROM fnd_concurrent_programs
178: WHERE application_id = program_application_id
179: AND concurrent_program_name = program_short_name;
180:
181: RETURN program_id;

Line 357: ra fnd_concurrent_programs.run_alone_flag%TYPE;

353: lang in varchar2,
354: set_short_name in varchar2 DEFAULT NULL,
355: stage_short_name in varchar2 DEFAULT NULL)
356: return number is
357: ra fnd_concurrent_programs.run_alone_flag%TYPE;
358: srs fnd_concurrent_programs.srs_flag%TYPE;
359: enabled fnd_concurrent_programs.enabled_flag%TYPE;
360: qc fnd_concurrent_programs.queue_control_flag%TYPE;
361: qmc fnd_concurrent_programs.queue_method_code%TYPE;

Line 358: srs fnd_concurrent_programs.srs_flag%TYPE;

354: set_short_name in varchar2 DEFAULT NULL,
355: stage_short_name in varchar2 DEFAULT NULL)
356: return number is
357: ra fnd_concurrent_programs.run_alone_flag%TYPE;
358: srs fnd_concurrent_programs.srs_flag%TYPE;
359: enabled fnd_concurrent_programs.enabled_flag%TYPE;
360: qc fnd_concurrent_programs.queue_control_flag%TYPE;
361: qmc fnd_concurrent_programs.queue_method_code%TYPE;
362: amc fnd_concurrent_programs.argument_method_code%TYPE;

Line 359: enabled fnd_concurrent_programs.enabled_flag%TYPE;

355: stage_short_name in varchar2 DEFAULT NULL)
356: return number is
357: ra fnd_concurrent_programs.run_alone_flag%TYPE;
358: srs fnd_concurrent_programs.srs_flag%TYPE;
359: enabled fnd_concurrent_programs.enabled_flag%TYPE;
360: qc fnd_concurrent_programs.queue_control_flag%TYPE;
361: qmc fnd_concurrent_programs.queue_method_code%TYPE;
362: amc fnd_concurrent_programs.argument_method_code%TYPE;
363: so fnd_concurrent_programs.save_output_flag%TYPE;

Line 360: qc fnd_concurrent_programs.queue_control_flag%TYPE;

356: return number is
357: ra fnd_concurrent_programs.run_alone_flag%TYPE;
358: srs fnd_concurrent_programs.srs_flag%TYPE;
359: enabled fnd_concurrent_programs.enabled_flag%TYPE;
360: qc fnd_concurrent_programs.queue_control_flag%TYPE;
361: qmc fnd_concurrent_programs.queue_method_code%TYPE;
362: amc fnd_concurrent_programs.argument_method_code%TYPE;
363: so fnd_concurrent_programs.save_output_flag%TYPE;
364: print fnd_concurrent_programs.print_flag%TYPE;

Line 361: qmc fnd_concurrent_programs.queue_method_code%TYPE;

357: ra fnd_concurrent_programs.run_alone_flag%TYPE;
358: srs fnd_concurrent_programs.srs_flag%TYPE;
359: enabled fnd_concurrent_programs.enabled_flag%TYPE;
360: qc fnd_concurrent_programs.queue_control_flag%TYPE;
361: qmc fnd_concurrent_programs.queue_method_code%TYPE;
362: amc fnd_concurrent_programs.argument_method_code%TYPE;
363: so fnd_concurrent_programs.save_output_flag%TYPE;
364: print fnd_concurrent_programs.print_flag%TYPE;
365: rs fnd_concurrent_programs.required_style%TYPE;

Line 362: amc fnd_concurrent_programs.argument_method_code%TYPE;

358: srs fnd_concurrent_programs.srs_flag%TYPE;
359: enabled fnd_concurrent_programs.enabled_flag%TYPE;
360: qc fnd_concurrent_programs.queue_control_flag%TYPE;
361: qmc fnd_concurrent_programs.queue_method_code%TYPE;
362: amc fnd_concurrent_programs.argument_method_code%TYPE;
363: so fnd_concurrent_programs.save_output_flag%TYPE;
364: print fnd_concurrent_programs.print_flag%TYPE;
365: rs fnd_concurrent_programs.required_style%TYPE;
366: printer fnd_concurrent_programs.printer_name%TYPE;

Line 363: so fnd_concurrent_programs.save_output_flag%TYPE;

359: enabled fnd_concurrent_programs.enabled_flag%TYPE;
360: qc fnd_concurrent_programs.queue_control_flag%TYPE;
361: qmc fnd_concurrent_programs.queue_method_code%TYPE;
362: amc fnd_concurrent_programs.argument_method_code%TYPE;
363: so fnd_concurrent_programs.save_output_flag%TYPE;
364: print fnd_concurrent_programs.print_flag%TYPE;
365: rs fnd_concurrent_programs.required_style%TYPE;
366: printer fnd_concurrent_programs.printer_name%TYPE;
367: style fnd_concurrent_programs.output_print_style%TYPE;

Line 364: print fnd_concurrent_programs.print_flag%TYPE;

360: qc fnd_concurrent_programs.queue_control_flag%TYPE;
361: qmc fnd_concurrent_programs.queue_method_code%TYPE;
362: amc fnd_concurrent_programs.argument_method_code%TYPE;
363: so fnd_concurrent_programs.save_output_flag%TYPE;
364: print fnd_concurrent_programs.print_flag%TYPE;
365: rs fnd_concurrent_programs.required_style%TYPE;
366: printer fnd_concurrent_programs.printer_name%TYPE;
367: style fnd_concurrent_programs.output_print_style%TYPE;
368: eo fnd_concurrent_programs.execution_options%TYPE;

Line 365: rs fnd_concurrent_programs.required_style%TYPE;

361: qmc fnd_concurrent_programs.queue_method_code%TYPE;
362: amc fnd_concurrent_programs.argument_method_code%TYPE;
363: so fnd_concurrent_programs.save_output_flag%TYPE;
364: print fnd_concurrent_programs.print_flag%TYPE;
365: rs fnd_concurrent_programs.required_style%TYPE;
366: printer fnd_concurrent_programs.printer_name%TYPE;
367: style fnd_concurrent_programs.output_print_style%TYPE;
368: eo fnd_concurrent_programs.execution_options%TYPE;
369: ex_app_id fnd_concurrent_programs.executable_application_id%TYPE;

Line 366: printer fnd_concurrent_programs.printer_name%TYPE;

362: amc fnd_concurrent_programs.argument_method_code%TYPE;
363: so fnd_concurrent_programs.save_output_flag%TYPE;
364: print fnd_concurrent_programs.print_flag%TYPE;
365: rs fnd_concurrent_programs.required_style%TYPE;
366: printer fnd_concurrent_programs.printer_name%TYPE;
367: style fnd_concurrent_programs.output_print_style%TYPE;
368: eo fnd_concurrent_programs.execution_options%TYPE;
369: ex_app_id fnd_concurrent_programs.executable_application_id%TYPE;
370: ex_id fnd_concurrent_programs.executable_id%TYPE;

Line 367: style fnd_concurrent_programs.output_print_style%TYPE;

363: so fnd_concurrent_programs.save_output_flag%TYPE;
364: print fnd_concurrent_programs.print_flag%TYPE;
365: rs fnd_concurrent_programs.required_style%TYPE;
366: printer fnd_concurrent_programs.printer_name%TYPE;
367: style fnd_concurrent_programs.output_print_style%TYPE;
368: eo fnd_concurrent_programs.execution_options%TYPE;
369: ex_app_id fnd_concurrent_programs.executable_application_id%TYPE;
370: ex_id fnd_concurrent_programs.executable_id%TYPE;
371: cl_app_id fnd_concurrent_programs.class_application_id%TYPE;

Line 368: eo fnd_concurrent_programs.execution_options%TYPE;

364: print fnd_concurrent_programs.print_flag%TYPE;
365: rs fnd_concurrent_programs.required_style%TYPE;
366: printer fnd_concurrent_programs.printer_name%TYPE;
367: style fnd_concurrent_programs.output_print_style%TYPE;
368: eo fnd_concurrent_programs.execution_options%TYPE;
369: ex_app_id fnd_concurrent_programs.executable_application_id%TYPE;
370: ex_id fnd_concurrent_programs.executable_id%TYPE;
371: cl_app_id fnd_concurrent_programs.class_application_id%TYPE;
372: cl_id fnd_concurrent_programs.concurrent_class_id%TYPE;

Line 369: ex_app_id fnd_concurrent_programs.executable_application_id%TYPE;

365: rs fnd_concurrent_programs.required_style%TYPE;
366: printer fnd_concurrent_programs.printer_name%TYPE;
367: style fnd_concurrent_programs.output_print_style%TYPE;
368: eo fnd_concurrent_programs.execution_options%TYPE;
369: ex_app_id fnd_concurrent_programs.executable_application_id%TYPE;
370: ex_id fnd_concurrent_programs.executable_id%TYPE;
371: cl_app_id fnd_concurrent_programs.class_application_id%TYPE;
372: cl_id fnd_concurrent_programs.concurrent_class_id%TYPE;
373:

Line 370: ex_id fnd_concurrent_programs.executable_id%TYPE;

366: printer fnd_concurrent_programs.printer_name%TYPE;
367: style fnd_concurrent_programs.output_print_style%TYPE;
368: eo fnd_concurrent_programs.execution_options%TYPE;
369: ex_app_id fnd_concurrent_programs.executable_application_id%TYPE;
370: ex_id fnd_concurrent_programs.executable_id%TYPE;
371: cl_app_id fnd_concurrent_programs.class_application_id%TYPE;
372: cl_id fnd_concurrent_programs.concurrent_class_id%TYPE;
373:
374: last_update_login fnd_concurrent_programs.last_update_login%TYPE

Line 371: cl_app_id fnd_concurrent_programs.class_application_id%TYPE;

367: style fnd_concurrent_programs.output_print_style%TYPE;
368: eo fnd_concurrent_programs.execution_options%TYPE;
369: ex_app_id fnd_concurrent_programs.executable_application_id%TYPE;
370: ex_id fnd_concurrent_programs.executable_id%TYPE;
371: cl_app_id fnd_concurrent_programs.class_application_id%TYPE;
372: cl_id fnd_concurrent_programs.concurrent_class_id%TYPE;
373:
374: last_update_login fnd_concurrent_programs.last_update_login%TYPE
375: := last_update_login_f;

Line 372: cl_id fnd_concurrent_programs.concurrent_class_id%TYPE;

368: eo fnd_concurrent_programs.execution_options%TYPE;
369: ex_app_id fnd_concurrent_programs.executable_application_id%TYPE;
370: ex_id fnd_concurrent_programs.executable_id%TYPE;
371: cl_app_id fnd_concurrent_programs.class_application_id%TYPE;
372: cl_id fnd_concurrent_programs.concurrent_class_id%TYPE;
373:
374: last_update_login fnd_concurrent_programs.last_update_login%TYPE
375: := last_update_login_f;
376: last_update_date fnd_concurrent_programs.last_update_date%TYPE

Line 374: last_update_login fnd_concurrent_programs.last_update_login%TYPE

370: ex_id fnd_concurrent_programs.executable_id%TYPE;
371: cl_app_id fnd_concurrent_programs.class_application_id%TYPE;
372: cl_id fnd_concurrent_programs.concurrent_class_id%TYPE;
373:
374: last_update_login fnd_concurrent_programs.last_update_login%TYPE
375: := last_update_login_f;
376: last_update_date fnd_concurrent_programs.last_update_date%TYPE
377: := last_update_date_f;
378: last_updated_by fnd_concurrent_programs.last_updated_by%TYPE

Line 376: last_update_date fnd_concurrent_programs.last_update_date%TYPE

372: cl_id fnd_concurrent_programs.concurrent_class_id%TYPE;
373:
374: last_update_login fnd_concurrent_programs.last_update_login%TYPE
375: := last_update_login_f;
376: last_update_date fnd_concurrent_programs.last_update_date%TYPE
377: := last_update_date_f;
378: last_updated_by fnd_concurrent_programs.last_updated_by%TYPE
379: := last_updated_by_f;
380: creation_date fnd_concurrent_programs.creation_date%TYPE

Line 378: last_updated_by fnd_concurrent_programs.last_updated_by%TYPE

374: last_update_login fnd_concurrent_programs.last_update_login%TYPE
375: := last_update_login_f;
376: last_update_date fnd_concurrent_programs.last_update_date%TYPE
377: := last_update_date_f;
378: last_updated_by fnd_concurrent_programs.last_updated_by%TYPE
379: := last_updated_by_f;
380: creation_date fnd_concurrent_programs.creation_date%TYPE
381: := creation_date_f;
382: created_by fnd_concurrent_programs.created_by%TYPE

Line 380: creation_date fnd_concurrent_programs.creation_date%TYPE

376: last_update_date fnd_concurrent_programs.last_update_date%TYPE
377: := last_update_date_f;
378: last_updated_by fnd_concurrent_programs.last_updated_by%TYPE
379: := last_updated_by_f;
380: creation_date fnd_concurrent_programs.creation_date%TYPE
381: := creation_date_f;
382: created_by fnd_concurrent_programs.created_by%TYPE
383: := created_by_f;
384: program_id fnd_concurrent_programs.concurrent_program_id%TYPE;

Line 382: created_by fnd_concurrent_programs.created_by%TYPE

378: last_updated_by fnd_concurrent_programs.last_updated_by%TYPE
379: := last_updated_by_f;
380: creation_date fnd_concurrent_programs.creation_date%TYPE
381: := creation_date_f;
382: created_by fnd_concurrent_programs.created_by%TYPE
383: := created_by_f;
384: program_id fnd_concurrent_programs.concurrent_program_id%TYPE;
385: request_set_text varchar2(256);
386:

Line 384: program_id fnd_concurrent_programs.concurrent_program_id%TYPE;

380: creation_date fnd_concurrent_programs.creation_date%TYPE
381: := creation_date_f;
382: created_by fnd_concurrent_programs.created_by%TYPE
383: := created_by_f;
384: program_id fnd_concurrent_programs.concurrent_program_id%TYPE;
385: request_set_text varchar2(256);
386:
387: program_name varchar2(10);
388: user_program_name varchar2(240);

Line 391: -- insert into fnd concurrent programs.

387: program_name varchar2(10);
388: user_program_name varchar2(240);
389: new_name varchar2(30);
390: BEGIN
391: -- insert into fnd concurrent programs.
392: -- get id first
393:
394:
395: select fnd_concurrent_programs_s.nextval

Line 395: select fnd_concurrent_programs_s.nextval

391: -- insert into fnd concurrent programs.
392: -- get id first
393:
394:
395: select fnd_concurrent_programs_s.nextval
396: into program_id
397: from sys.dual;
398:
399: if (stage_id is not null) then

Line 426: from fnd_concurrent_programs

422: executable_application_id, executable_id,
423: save_output_flag, printer_name
424: into amc, qc, qmc, ra, enabled, srs, print, style, rs, eo,
425: cl_app_id, cl_id, ex_app_id, ex_id, so, printer
426: from fnd_concurrent_programs
427: where application_id = 0
428: and concurrent_program_name = program_name;
429: exception
430: when no_data_found then

Line 435: insert into fnd_concurrent_programs

431: message('Could not find program '||program_name||' for copy!');
432: raise program_error;
433: END;
434:
435: insert into fnd_concurrent_programs
436: (application_id, concurrent_program_id, concurrent_program_name,
437: last_update_date, last_updated_by, execution_method_code,
438: queue_method_code, argument_method_code, queue_control_flag,
439: run_alone_flag, enabled_flag,

Line 457: insert into fnd_concurrent_programs_tl

453:
454: --
455: -- Insert into TL table
456: --
457: insert into fnd_concurrent_programs_tl
458: (application_id,
459: concurrent_program_id,
460: last_update_date,
461: last_updated_by,

Line 602: fnd_concurrent_programs.concurrent_program_id%TYPE;

598: created_by fnd_flex_value_sets.created_by%TYPE
599: := created_by_f;
600: application_id_i fnd_application.application_id%TYPE;
601: concurrent_program_id_i
602: fnd_concurrent_programs.concurrent_program_id%TYPE;
603: to_run_concurrent_program_id_i
604: fnd_concurrent_programs.concurrent_program_id%TYPE;
605: to_run_application_id_i fnd_application.application_id%TYPE;
606: set_id number;

Line 604: fnd_concurrent_programs.concurrent_program_id%TYPE;

600: application_id_i fnd_application.application_id%TYPE;
601: concurrent_program_id_i
602: fnd_concurrent_programs.concurrent_program_id%TYPE;
603: to_run_concurrent_program_id_i
604: fnd_concurrent_programs.concurrent_program_id%TYPE;
605: to_run_application_id_i fnd_application.application_id%TYPE;
606: set_id number;
607: stage_id number;
608: BEGIN

Line 654: UPDATE fnd_concurrent_programs SET

650: end if;
651:
652:
653: /* update program definitions */
654: UPDATE fnd_concurrent_programs SET
655: queue_method_code = 'B'
656: WHERE ((application_id = application_id_i
657: AND concurrent_program_id = concurrent_program_id_i)
658: OR (application_id = to_run_application_id_i

Line 768: program_id fnd_concurrent_programs.concurrent_program_id%TYPE;

764: := created_by_f;
765: set_appl_id fnd_application.application_id%TYPE;
766: set_id fnd_request_sets.request_set_id%TYPE;
767: owner_id fnd_user.user_id%TYPE;
768: program_id fnd_concurrent_programs.concurrent_program_id%TYPE;
769:
770: BEGIN
771: message_init;
772:

Line 899: program_id fnd_concurrent_programs.concurrent_program_id%TYPE;

895: set_id fnd_request_sets.request_set_id%TYPE;
896: print_style_name fnd_printer_styles.printer_style_name%TYPE;
897: stage_id fnd_request_set_stages_tl.request_set_stage_id%TYPE;
898: dummy varchar2(1);
899: program_id fnd_concurrent_programs.concurrent_program_id%TYPE;
900: outcome_meaning varchar2(1);
901: function_id number := null;
902: function_appl_id number := null;
903: set_name varchar2(240);

Line 1125: program_id fnd_concurrent_programs.concurrent_program_id%TYPE;

1121: set_appl_id fnd_application.application_id%TYPE;
1122: program_appl_id fnd_application.application_id%TYPE;
1123: set_id fnd_request_sets.request_set_id%TYPE;
1124: stage_id fnd_request_set_stages.request_set_stage_id%TYPE;
1125: program_id fnd_concurrent_programs.concurrent_program_id%TYPE;
1126: print_style_name fnd_printer_styles.printer_style_name%TYPE;
1127: dummy varchar2(1);
1128: BEGIN
1129: message_init;

Line 1225: program_short_name fnd_concurrent_programs.concurrent_program_name%TYPE;

1221: is
1222: set_appl_id fnd_application.application_id%TYPE;
1223: set_id fnd_request_sets.request_set_id%TYPE;
1224: stage_id fnd_request_set_stages.request_set_stage_id%TYPE;
1225: program_short_name fnd_concurrent_programs.concurrent_program_name%TYPE;
1226: BEGIN
1227: message_init;
1228:
1229: check_notnull(set_application);

Line 1257: from fnd_concurrent_programs p,

1253: -- Delete stage program (if any)
1254: begin
1255: select concurrent_program_name
1256: into program_short_name
1257: from fnd_concurrent_programs p,
1258: fnd_request_set_stages r
1259: where r.set_application_id = set_appl_id
1260: and r.request_set_id = set_id
1261: and r.request_set_stage_id = stage_id

Line 1338: program_id fnd_concurrent_programs.concurrent_program_id%TYPE;

1334: set_appl_id fnd_application.application_id%TYPE;
1335: program_appl_id fnd_application.application_id%TYPE;
1336: set_id fnd_request_sets.request_set_id%TYPE;
1337: stage_id fnd_request_set_stages.request_set_stage_id%TYPE;
1338: program_id fnd_concurrent_programs.concurrent_program_id%TYPE;
1339: BEGIN
1340: message_init;
1341:
1342: check_notnull(program);

Line 1429: program_id fnd_concurrent_programs.concurrent_program_id%TYPE;

1425: set_appl_id fnd_application.application_id%TYPE;
1426: program_appl_id fnd_application.application_id%TYPE;
1427: set_id fnd_request_sets.request_set_id%TYPE;
1428: stage_id fnd_request_set_stages.request_set_stage_id%TYPE;
1429: program_id fnd_concurrent_programs.concurrent_program_id%TYPE;
1430: default_type_code fnd_request_set_program_args.default_type%TYPE;
1431: set_program_id fnd_request_set_programs.request_set_program_id%TYPE;
1432: appl_column_name
1433: fnd_descr_flex_column_usages.application_column_name%TYPE;

Line 1717: fnd_concurrent_programs p

1713: BEGIN
1714: select request_set_program_id
1715: into set_program_id
1716: from fnd_request_set_programs s,
1717: fnd_concurrent_programs p
1718: where p.concurrent_program_name = program
1719: and p.application_id = program_appl_id
1720: and p.concurrent_program_id = s.concurrent_program_id
1721: and p.application_id = s.program_application_id

Line 1772: fnd_concurrent_programs.concurrent_program_name%TYPE;

1768: fnd_application.application_id%TYPE;
1769: set_id
1770: fnd_request_sets.request_set_id%TYPE;
1771: program_short_name
1772: fnd_concurrent_programs.concurrent_program_name%TYPE;
1773:
1774: cursor c (set_appl_id number, set_id number) is
1775: select request_set_stage_id
1776: from fnd_request_set_stages

Line 1800: from fnd_concurrent_programs p,

1796: -- Delete the program if it exists
1797: BEGIN
1798: select concurrent_program_name
1799: into program_short_name
1800: from fnd_concurrent_programs p,
1801: fnd_request_sets r
1802: where r.application_id = set_appl_id
1803: and r.request_set_id = set_id
1804: and r.application_id = p.application_id

Line 1842: from fnd_concurrent_programs p,

1838: for rec in c(set_appl_id, set_id) loop
1839: begin
1840: select concurrent_program_name
1841: into program_short_name
1842: from fnd_concurrent_programs p,
1843: fnd_request_set_stages r
1844: where r.set_application_id = set_application_id
1845: and r.request_set_id = set_id
1846: and r.request_set_stage_id = rec.request_set_stage_id

Line 1914: fnd_concurrent_programs.concurrent_program_id%TYPE;

1910: inc_stage IN VARCHAR2 DEFAULT NULL)
1911: IS
1912: application_id_i fnd_application.application_id%TYPE;
1913: concurrent_program_id_i
1914: fnd_concurrent_programs.concurrent_program_id%TYPE;
1915: to_run_concurrent_program_id_i
1916: fnd_concurrent_programs.concurrent_program_id%TYPE;
1917: to_run_application_id_i fnd_application.application_id%TYPE;
1918: dummy varchar2(1);

Line 1916: fnd_concurrent_programs.concurrent_program_id%TYPE;

1912: application_id_i fnd_application.application_id%TYPE;
1913: concurrent_program_id_i
1914: fnd_concurrent_programs.concurrent_program_id%TYPE;
1915: to_run_concurrent_program_id_i
1916: fnd_concurrent_programs.concurrent_program_id%TYPE;
1917: to_run_application_id_i fnd_application.application_id%TYPE;
1918: dummy varchar2(1);
1919: set_id number;
1920: stage_id number;

Line 1972: update fnd_concurrent_programs

1968: and running_concurrent_program_id = to_run_concurrent_program_id_i;
1969:
1970: /* update incompatibilies */
1971: BEGIN
1972: update fnd_concurrent_programs
1973: set queue_method_code = 'I'
1974: WHERE application_id = application_id_i
1975: AND concurrent_program_id = concurrent_program_id_i
1976: AND NOT EXISTS

Line 1987: update fnd_concurrent_programs

1983: when no_data_found then null;
1984: END;
1985:
1986: BEGIN
1987: update fnd_concurrent_programs
1988: set queue_method_code = 'I'
1989: WHERE application_id = to_run_application_id_i
1990: AND concurrent_program_id = to_run_concurrent_program_id_i
1991: AND NOT EXISTS

Line 2034: concurrent_program_id_i fnd_concurrent_programs.concurrent_program_id%TYPE;

2030: inc_stage IN VARCHAR2 DEFAULT NULL)
2031: return boolean is
2032:
2033: application_id_i fnd_application.application_id%TYPE;
2034: concurrent_program_id_i fnd_concurrent_programs.concurrent_program_id%TYPE;
2035: to_run_concurrent_program_id_i
2036: fnd_concurrent_programs.concurrent_program_id%TYPE;
2037: to_run_application_id_i fnd_application.application_id%TYPE;
2038: dummy varchar2(1);

Line 2036: fnd_concurrent_programs.concurrent_program_id%TYPE;

2032:
2033: application_id_i fnd_application.application_id%TYPE;
2034: concurrent_program_id_i fnd_concurrent_programs.concurrent_program_id%TYPE;
2035: to_run_concurrent_program_id_i
2036: fnd_concurrent_programs.concurrent_program_id%TYPE;
2037: to_run_application_id_i fnd_application.application_id%TYPE;
2038: dummy varchar2(1);
2039: set_id number;
2040: stage_id number;

Line 2193: program_id fnd_concurrent_programs.concurrent_program_id%TYPE;

2189: set_appl_id fnd_application.application_id%TYPE;
2190: program_appl_id fnd_application.application_id%TYPE;
2191: set_id fnd_request_sets.request_set_id%TYPE;
2192: stage_id fnd_request_set_stages.request_set_stage_id%TYPE;
2193: program_id fnd_concurrent_programs.concurrent_program_id%TYPE;
2194: dummy varchar2(1);
2195:
2196: BEGIN
2197: message_init;

Line 2267: fnd_concurrent_programs p

2263:
2264: select request_set_program_id
2265: into set_program_id
2266: from fnd_request_set_programs s,
2267: fnd_concurrent_programs p
2268: where p.concurrent_program_name = program
2269: and p.application_id = program_appl_id
2270: and p.concurrent_program_id = s.concurrent_program_id
2271: and p.application_id = s.program_application_id