APPS.MSC_PHUB_PKG dependencies on MSC_APCC_UPLOAD_S

Line 1064: dbms_lock.allocate_unique('msc_apcc_upload_s', l_lock);

1060: msc_phub_util.log('msc_phub_pkg.create_staging_partitions('||p_plan_type||','||p_include_ods||')');
1061:
1062: if (l_staging_tables.count > 0) then
1063: -- add partitions synchronuously
1064: dbms_lock.allocate_unique('msc_apcc_upload_s', l_lock);
1065: msc_phub_util.log('msc_phub_pkg.create_staging_partitions: dbms_lock.request');
1066: l_error := dbms_lock.request(l_lock);
1067: if (l_error <> 0) then
1068: msc_phub_util.log('msc_phub_pkg.create_staging_partitions: dbms_lock.request='||l_error);

Line 1072: select msc_apcc_upload_s.nextval into l_transfer_id from dual;

1068: msc_phub_util.log('msc_phub_pkg.create_staging_partitions: dbms_lock.request='||l_error);
1069: raise e_create_staging_partitions;
1070: end if;
1071:
1072: select msc_apcc_upload_s.nextval into l_transfer_id from dual;
1073: manage_partitions(l_staging_tables, l_transfer_id, partition_add, partition_range);
1074: l_error := dbms_lock.release(l_lock);
1075: end if;
1076: return l_transfer_id;