APPS.MSC_PHUB_FILE_PKG dependencies on MSC_APCC_UPLOAD_DETAIL

Line 30: update msc_apcc_upload_detail set

26: l_entity_name varchar2(30);
27: l_sql varchar2(200);
28: begin
29: msc_phub_util.log('msc_phub_file_pkg.export_table');
30: update msc_apcc_upload_detail set
31: last_updated_by=fnd_global.user_id,
32: last_update_date=sysdate,
33: last_update_login=fnd_global.login_id,
34: program_id=fnd_global.conc_program_id,

Line 139: insert into msc_apcc_upload_detail (

135: from msc_hub_query
136: where query_id=p_query_id
137: and number1=1;
138:
139: insert into msc_apcc_upload_detail (
140: transfer_id,
141: fact_type,
142: file_name,
143: file_data,

Line 267: insert into msc_apcc_upload_detail (

263: ',p_include_pds='||p_include_pds||
264: ',l_sr_instance_id='||l_sr_instance_id||
265: ',l_organization_id='||l_organization_id);
266:
267: insert into msc_apcc_upload_detail (
268: transfer_id, fact_type, file_name,
269: created_by, creation_date, last_updated_by, last_update_date, last_update_login)
270: select
271: l_transfer_id, fact_type, upper('msc_st_'||entity_name||'_f')||'.csv',

Line 288: update msc_apcc_upload_detail

284: is
285: begin
286: msc_phub_util.log('msc_phub_file_pkg.save_overwrite_date ('||
287: p_transfer_id||','||p_fact_type||','||p_overwrite_after_date||')');
288: update msc_apcc_upload_detail
289: set overwrite_after_date=p_overwrite_after_date
290: where transfer_id=p_transfer_id and fact_type=p_fact_type;
291:
292: commit;

Line 330: from msc_apcc_upload_detail

326: where transfer_id=p_transfer_id;
327:
328: if (l_plan_run_id is null) then
329: select fact_type into l_fact_type
330: from msc_apcc_upload_detail
331: where transfer_id=p_transfer_id;
332:
333: if (l_fact_type <> 4) then
334: retcode := 2;

Line 488: from msc_apcc_upload_detail

484: 'l_pi.plan_type='||l_pi.plan_type||','||
485: 'l_upload_mode='||l_upload_mode);
486:
487: select count(*) into n
488: from msc_apcc_upload_detail
489: where transfer_id=p_transfer_id
490: and fact_type=4
491: and (file_data is not null or l_import_level <> 3);
492:

Line 683: update msc_apcc_upload_detail set

679: l_entity_name varchar2(30);
680: l_sql varchar2(1000);
681: begin
682: msc_phub_util.log('msc_phub_file_pkg.import_table');
683: update msc_apcc_upload_detail set
684: last_updated_by=fnd_global.user_id,
685: last_update_date=sysdate,
686: last_update_login=fnd_global.login_id,
687: program_id=fnd_global.conc_program_id,

Line 706: from msc_apcc_upload_detail

702: where transfer_id=p_transfer_id;
703:
704: select overwrite_after_date
705: into l_overwrite_after_date
706: from msc_apcc_upload_detail
707: where transfer_id=p_transfer_id
708: and fact_type=p_fact_type;
709:
710: begin

Line 872: update msc_apcc_upload_detail set file_data=null where transfer_id=p_transfer_id;

868: begin
869: msc_phub_util.log('msc_phub_file_pkg.cleanup('||p_transfer_id||')');
870: msc_phub_pkg.drop_staging_partitions(p_transfer_id, null, null);
871:
872: update msc_apcc_upload_detail set file_data=null where transfer_id=p_transfer_id;
873: commit;
874:
875: exception
876: when others then

Line 918: delete from msc_apcc_upload_detail where transfer_id in (

914: when others then null;
915: end;
916: end loop;
917:
918: delete from msc_apcc_upload_detail where transfer_id in (
919: select distinct transfer_id from msc_apcc_upload
920: where transfer_status=status_purging);
921:
922: delete from msc_apcc_upload where transfer_status=status_purging;