APPS.MSC_PHUB_FILE_PKG dependencies on MSC_APCC_UPLOAD

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 46: from msc_apcc_upload

42: errbuf := null;
43:
44: select source_plan_run_id, source_dblink, nvl(source_version, msc_phub_util.g_version)
45: into l_plan_run_id, l_source_dblink, l_source_version
46: from msc_apcc_upload
47: where transfer_id=p_transfer_id;
48:
49: msc_phub_util.log('msc_phub_file_pkg.export_table: '||
50: 'p_transfer_id='||p_transfer_id||','||

Line 107: insert into msc_apcc_upload (

103: errbuf := 'msc_phub_file_pkg.prepare_transfer_tables_ui: n2='||n;
104: raise e_prepare_transfer_tables_ui;
105: end if;
106:
107: insert into msc_apcc_upload (
108: transfer_id,
109: import_level,
110: upload_mode,
111: directory,

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 222: insert into msc_apcc_upload (

218: exception
219: when others then null;
220: end;
221:
222: insert into msc_apcc_upload (
223: transfer_id,
224: export_level,
225: import_level,
226: upload_mode,

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 312: update msc_apcc_upload set

308: msc_phub_util.log('msc_phub_file_pkg.prepare_export ('||p_transfer_id||')');
309: retcode := 0;
310: errbuf := null;
311:
312: update msc_apcc_upload set
313: last_updated_by=fnd_global.user_id,
314: last_update_date=sysdate,
315: last_update_login=fnd_global.login_id,
316: program_id=fnd_global.conc_program_id,

Line 325: from msc_apcc_upload

321: commit;
322:
323: select source_plan_run_id
324: into l_plan_run_id
325: from msc_apcc_upload
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

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 352: update msc_apcc_upload

348: procedure finalize_export(errbuf out nocopy varchar2, retcode out nocopy varchar2,
349: p_transfer_id number)
350: is
351: begin
352: update msc_apcc_upload
353: set transfer_status=status_transfered
354: where transfer_id=p_transfer_id;
355: commit;
356:

Line 372: update msc_apcc_upload set

368: msc_phub_util.log('msc_phub_file_pkg.prepare_import ('||p_transfer_id||')');
369: retcode := 0;
370: errbuf := null;
371:
372: update msc_apcc_upload set
373: last_updated_by=fnd_global.user_id,
374: last_update_date=sysdate,
375: last_update_login=fnd_global.login_id,
376: program_id=fnd_global.conc_program_id,

Line 411: from msc_apcc_upload

407: msc_phub_util.log('msc_phub_file_pkg.finalize_import('||p_transfer_id||')');
408:
409: select upload_mode, plan_id, plan_run_id
410: into l_upload_mode, l_plan_id, l_plan_run_id
411: from msc_apcc_upload
412: where transfer_id=p_transfer_id;
413:
414: if (l_upload_mode = msc_phub_util.upload_create_purge_prev) then
415: l_keep_previous := msc_phub_pkg.sys_no;

Line 428: update msc_apcc_upload

424:
425: msc_phub_pkg.build_items_from_apcc(l_plan_id, l_plan_run_id);
426: end if;
427:
428: update msc_apcc_upload
429: set transfer_status=status_transfered
430: where transfer_id=p_transfer_id;
431: commit;
432:

Line 473: from msc_apcc_upload

469: plan_cutoff_date,
470: plan_completion_date,
471: null
472: into l_pi
473: from msc_apcc_upload
474: where transfer_id=p_transfer_id;
475:
476: select import_level, upload_mode
477: into l_import_level, l_upload_mode

Line 478: from msc_apcc_upload

474: where transfer_id=p_transfer_id;
475:
476: select import_level, upload_mode
477: into l_import_level, l_upload_mode
478: from msc_apcc_upload
479: where transfer_id=p_transfer_id;
480:
481: msc_phub_util.log('msc_phub_file_pkg.prepare_context: '||
482: 'l_import_level='||l_import_level||','||

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 566: update msc_apcc_upload

562: plan_completion_date = nvl(l_pi.plan_completion_date, plan_completion_date)
563: where plan_run_id=l_plan_run_id;
564: end if;
565:
566: update msc_apcc_upload
567: set plan_id=l_pi.plan_id, plan_run_id=l_plan_run_id
568: where transfer_id=p_transfer_id;
569: commit;
570: else

Line 639: update msc_apcc_upload

635: end if;
636:
637: l_plan_run_id := msc_phub_pkg.create_plan_run(null, null, msc_phub_pkg.sys_no, l_pi);
638:
639: update msc_apcc_upload
640: set plan_id=l_pi.plan_id, plan_run_id=l_plan_run_id
641: where transfer_id=p_transfer_id;
642: commit;
643: else

Line 645: fnd_message.set_name('MSC', 'MSC_APCC_UPLOAD_MODE_E01');

641: where transfer_id=p_transfer_id;
642: commit;
643: else
644: retcode := 2;
645: fnd_message.set_name('MSC', 'MSC_APCC_UPLOAD_MODE_E01');
646: fnd_message.set_token('PLAN', l_pi.plan_name);
647: errbuf := fnd_message.get;
648: msc_phub_util.log(errbuf);
649: return;

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 701: from msc_apcc_upload

697: select plan_id, plan_run_id, plan_type, sr_instance_id,
698: plan_start_date, plan_cutoff_date, upload_mode
699: into l_plan_id, l_plan_run_id, l_plan_type, l_def_instance_id,
700: l_plan_start_date, l_plan_cutoff_date, l_upload_mode
701: from msc_apcc_upload
702: where transfer_id=p_transfer_id;
703:
704: select overwrite_after_date
705: into l_overwrite_after_date

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 772: select plan_name into l_plan_name from msc_apcc_upload where transfer_id=p_transfer_id;

768: msc_phub_util.log('msc_phub_file_pkg.create_plan '||l_plan_name);
769: retcode := 0;
770: errbuf := null;
771:
772: select plan_name into l_plan_name from msc_apcc_upload where transfer_id=p_transfer_id;
773:
774: select msc_plans_s.nextval into l_plan_id from dual;
775:
776: /*

Line 849: from msc_apcc_upload

845: nvl(plan_completion_date, sysdate),
846: 0, 0, 0, 0, 0, plan_type,
847: 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2,
848: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate
849: from msc_apcc_upload
850: where transfer_id=p_transfer_id;
851: commit;
852:
853: return l_plan_id;

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 888: from msc_apcc_upload

884: procedure purge_plan_summary(errbuf out nocopy varchar2, retcode out nocopy varchar2,
885: p_plan_name varchar2, p_plan_run_id number default null) is
886: cursor c is
887: select transfer_id
888: from msc_apcc_upload
889: where transfer_status=status_purging;
890:
891: begin
892: msc_phub_util.log(fnd_message.get_string('MSC','MSC_HUB_PURGE_STARTS'));

Line 902: update msc_apcc_upload

898: msc_phub_util.log('msc_phub_file_pkg.purge_plan_summary: (p_plan_name is null and p_plan_run_id is null)');
899: return;
900: end if;
901:
902: update msc_apcc_upload
903: set transfer_status=status_purging
904: where ((export_level>0 and source_dblink is null
905: and source_plan_run_id in (select column_value from table(msc_phub_pkg.list_plan_runs(p_plan_name, p_plan_run_id))))
906: or (import_level>0

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;

Line 919: select distinct transfer_id from msc_apcc_upload

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;
923: commit;

Line 922: delete from msc_apcc_upload where transfer_status=status_purging;

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;
923: commit;
924:
925: msc_phub_pkg.purge_details(p_plan_name, p_plan_run_id);
926: msc_phub_util.log(fnd_message.get_string('MSC','MSC_HUB_PURGE_ENDS'));