APPS.FA_RX_PUBLISH dependencies on FND_CONCURRENT_REQUESTS

Line 929: fnd_concurrent_requests r

925: from
926: fnd_descr_flex_col_usage_vl d,
927: fnd_flex_value_sets v,
928: fnd_concurrent_programs c,
929: fnd_concurrent_requests r
930: WHERE
931: r.request_id = l_request_id
932: AND c.application_id = r.program_application_id
933: AND c.concurrent_program_id = r.concurrent_program_id

Line 1010: -- from FND_CONCURRENT_REQUESTS (and FND_CONC_REQUEST_ARGUMENTS)

1006:
1007:
1008: --
1009: -- Build the SELECT statement which will retrieve the parameter values
1010: -- from FND_CONCURRENT_REQUESTS (and FND_CONC_REQUEST_ARGUMENTS)
1011: sqlstmt := 'SELECT ';
1012: for idx in 1..m_param_count loop
1013: if m_params(idx).param_idx <= 25 then
1014: sqlstmt := sqlstmt||sep||'r.argument'||to_char(m_params(idx).param_idx);

Line 1020: sqlstmt := sqlstmt||NEWLINE||'from fnd_concurrent_requests r';

1016: sqlstmt := sqlstmt||sep||'rs.argument'||to_char(m_params(idx).param_idx);
1017: end if;
1018: sep := NEWLINE||',';
1019: end loop;
1020: sqlstmt := sqlstmt||NEWLINE||'from fnd_concurrent_requests r';
1021: if max_param_idx > 25 then
1022: sqlstmt := sqlstmt||', fnd_conc_request_arguments rs';
1023: end if;
1024:

Line 1763: fnd_concurrent_requests r,

1759: INTO
1760: m_report.concurrent_program_name,
1761: m_report.conc_appname
1762: from
1763: fnd_concurrent_requests r,
1764: fnd_concurrent_programs p,
1765: fnd_application a
1766: where
1767: r.request_id = conc_request_id and