APPS.MSC_PHUB_PKG dependencies on FND_REQUEST

Line 142: l_req_id := fnd_request.submit_request('MSC', 'MSCHUBA2', null,

138: l_req_id number := null;
139: begin
140: if (has_etl(p_package, p_plan_type)) then
141: msc_phub_util.log('msc_phub_pkg.submit_each('||p_package||','||p_plan_id||','||p_plan_run_id||')');
142: l_req_id := fnd_request.submit_request('MSC', 'MSCHUBA2', null,
143: null, false, p_package, p_plan_id, p_plan_run_id);
144: msc_phub_util.log('msc_phub_pkg.submit_each: l_req_id='||l_req_id);
145: commit;
146: end if;

Line 446: l_request_id := fnd_request.submit_request('MSC','MSCHUBP',

442: and plan_run_id 443: and nvl(archive_flag,sys_no)=sys_yes;
444:
445: if (l_prev_plan_run_id is not null) then
446: l_request_id := fnd_request.submit_request('MSC','MSCHUBP',
447: null, null, false, l_plan_name, l_prev_plan_run_id);
448: commit;
449:
450: msc_phub_util.log('msc_phub_pkg.purge_previous_plan_run, MSCHUBP('||

Line 550: ' :1 := fnd_request.submit_request'||l_suffix||'('||

546: l_upload_mode := 4;
547: end if;
548:
549: l_sql :=
550: ' :1 := fnd_request.submit_request'||l_suffix||'('||
551: ' ''MSC'', ''MSCHUBFI'', null, null, false,'||
552: ' :transfer_id, :debug_level, :source_plan_id, :source_plan_run_id,'||
553: ' :source_db_link, :source_version, :target_plan_name,'||
554: ' :plan_description, :plan_type, :directory, :upload_mode, :include_ods,'||

Line 762: l_request_id := fnd_request.submit_request('MSC', 'MSCHUBP', null, null, false, l_pi.plan_name, l_plan_run_id);

758: retcode := -1;
759: errbuf := 'Error while populating the fact tables. purging this plan summary. ';
760: msc_phub_util.log(errbuf);
761:
762: l_request_id := fnd_request.submit_request('MSC', 'MSCHUBP', null, null, false, l_pi.plan_name, l_plan_run_id);
763: commit;
764:
765: msc_phub_util.log('msc_phub_pkg.populate_details_fn, MSCHUBP('||
766: l_pi.plan_name||','||l_plan_run_id||'), l_request_id='||l_request_id);

Line 2306: l_request_id := fnd_request.submit_request('MSC','MSCHUBM', null, null, false);

2302:
2303: msc_phub_util.log('msc_phub_pkg.check_migrate, l_need_migrate='||l_need_migrate);
2304:
2305: if (l_need_migrate > 0) then
2306: l_request_id := fnd_request.submit_request('MSC','MSCHUBM', null, null, false);
2307: msc_phub_util.log('msc_phub_pkg.check_migrate: l_request_id='||l_request_id);
2308: commit;
2309:
2310: msc_wait_for_request(l_request_id);