APPS.FA_RX_PUBLISH dependencies on FND_CONCURRENT_REQUESTS

Line 924: fnd_concurrent_requests r

920: from
921: fnd_descr_flex_col_usage_vl d,
922: fnd_flex_value_sets v,
923: fnd_concurrent_programs c,
924: fnd_concurrent_requests r
925: WHERE
926: r.request_id = l_request_id
927: AND c.application_id = r.program_application_id
928: AND c.concurrent_program_id = r.concurrent_program_id

Line 1005: -- from FND_CONCURRENT_REQUESTS (and FND_CONC_REQUEST_ARGUMENTS)

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

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

1011: sqlstmt := sqlstmt||sep||'rs.argument'||to_char(m_params(idx).param_idx);
1012: end if;
1013: sep := NEWLINE||',';
1014: end loop;
1015: sqlstmt := sqlstmt||NEWLINE||'from fnd_concurrent_requests r';
1016: if max_param_idx > 25 then
1017: sqlstmt := sqlstmt||', fnd_conc_request_arguments rs';
1018: end if;
1019:

Line 1744: fnd_concurrent_requests r,

1740: INTO
1741: m_report.concurrent_program_name,
1742: m_report.conc_appname
1743: from
1744: fnd_concurrent_requests r,
1745: fnd_concurrent_programs p,
1746: fnd_application a
1747: where
1748: r.request_id = conc_request_id and