APPS.FND_SET dependencies on FND_CONCURRENT_PROGRAM_SERIAL

Line 662: INSERT INTO fnd_concurrent_program_serial(running_concurrent_program_id,

658: OR (application_id = to_run_application_id_i
659: AND concurrent_program_id = to_run_concurrent_program_id_i));
660:
661:
662: INSERT INTO fnd_concurrent_program_serial(running_concurrent_program_id,
663: running_application_id,
664: running_type,
665: to_run_concurrent_program_id,
666: to_run_application_id,

Line 693: INTO fnd_concurrent_program_serial(running_concurrent_program_id,

689: OR
690: (application_id_i <> to_run_application_id_i)) THEN
691: BEGIN
692: INSERT
693: INTO fnd_concurrent_program_serial(running_concurrent_program_id,
694: running_application_id,
695: running_type,
696: to_run_concurrent_program_id,
697: to_run_application_id,

Line 1958: delete from fnd_concurrent_program_serial

1954: to_run_concurrent_program_id_i := get_prog_id(to_run_application_id_i,
1955: set_id, stage_id);
1956: end if;
1957:
1958: delete from fnd_concurrent_program_serial
1959: where to_run_application_id = to_run_application_id_i
1960: and to_run_concurrent_program_id = to_run_concurrent_program_id_i
1961: and running_application_id = application_id_i
1962: and running_concurrent_program_id = concurrent_program_id_i;

Line 1964: delete from fnd_concurrent_program_serial

1960: and to_run_concurrent_program_id = to_run_concurrent_program_id_i
1961: and running_application_id = application_id_i
1962: and running_concurrent_program_id = concurrent_program_id_i;
1963:
1964: delete from fnd_concurrent_program_serial
1965: where to_run_application_id = application_id_i
1966: and to_run_concurrent_program_id = concurrent_program_id_i
1967: and running_application_id = to_run_application_id_i
1968: and running_concurrent_program_id = to_run_concurrent_program_id_i;

Line 1978: from fnd_concurrent_program_serial

1974: WHERE application_id = application_id_i
1975: AND concurrent_program_id = concurrent_program_id_i
1976: AND NOT EXISTS
1977: (select 'x'
1978: from fnd_concurrent_program_serial
1979: where running_application_id = application_id_i
1980: and running_concurrent_program_id =
1981: concurrent_program_id_i);
1982: EXCEPTION

Line 1993: from fnd_concurrent_program_serial

1989: WHERE application_id = to_run_application_id_i
1990: AND concurrent_program_id = to_run_concurrent_program_id_i
1991: AND NOT EXISTS
1992: (select 'x'
1993: from fnd_concurrent_program_serial
1994: where running_application_id = to_run_application_id_i
1995: and running_concurrent_program_id =
1996: to_run_concurrent_program_id_i);
1997: EXCEPTION

Line 2078: from fnd_concurrent_program_serial

2074: end if;
2075:
2076: select 'Y'
2077: into dummy
2078: from fnd_concurrent_program_serial
2079: where to_run_application_id = to_run_application_id_i
2080: and to_run_concurrent_program_id = to_run_concurrent_program_id_i
2081: and running_application_id = application_id_i
2082: and running_concurrent_program_id = concurrent_program_id_i;