APPS.MSC_EXCEPTION_PKG dependencies on MSC_ST_EXCEPTIONS_F

Line 795: delete from msc_st_exceptions_f where st_transaction_id=p_st_transaction_id;

791: msc_phub_util.log('msc_exception_pkg.export_exceptions_f');
792: retcode := 0;
793: errbuf := null;
794:
795: delete from msc_st_exceptions_f where st_transaction_id=p_st_transaction_id;
796: commit;
797:
798: l_sql :=
799: ' insert into msc_st_exceptions_f('||

Line 799: ' insert into msc_st_exceptions_f('||

795: delete from msc_st_exceptions_f where st_transaction_id=p_st_transaction_id;
796: commit;
797:
798: l_sql :=
799: ' insert into msc_st_exceptions_f('||
800: ' st_transaction_id,'||
801: ' error_code,'||
802: ' sr_instance_id,'||
803: ' organization_id,'||

Line 960: l_staging_table varchar2(30) := 'msc_st_exceptions_f';

956: p_st_transaction_id number, p_plan_id number, p_plan_run_id number,
957: p_plan_type number, p_plan_start_date date, p_plan_cutoff_date date,
958: p_upload_mode number, p_overwrite_after_date date, p_def_instance_code varchar2)
959: is
960: l_staging_table varchar2(30) := 'msc_st_exceptions_f';
961: l_fact_table varchar2(30) := 'msc_exceptions_f';
962: l_result number := 0;
963: begin
964: msc_phub_util.log('msc_exception_pkg.import_exceptions_f');

Line 1068: from msc_st_exceptions_f

1064: exception_ratio,
1065: 0, -23453, -23453,
1066: fnd_global.user_id, sysdate,
1067: fnd_global.user_id, sysdate, fnd_global.login_id
1068: from msc_st_exceptions_f
1069: where st_transaction_id=p_st_transaction_id and error_code=0;
1070:
1071: msc_phub_util.log('msc_exception_pkg.import_exceptions_f: inserted='||sql%rowcount);
1072: commit;