DBA Data[Home] [Help]

APPS.WMS_ARCHIVE_PVT dependencies on WMS_EXCEPTIONS

Line 1112: trace(l_proc || ' Start of delete from wms_exceptions ...');

1108: end if;
1109:
1110: -- @@@ Delete records from the wms_op_opertn_instances_hist table
1111: if (l_debug = 1) then
1112: trace(l_proc || ' Start of delete from wms_exceptions ...');
1113: end if;
1114:
1115: delete from wms_exceptions wex
1116: where wex.creation_date > l_min_date

Line 1115: delete from wms_exceptions wex

1111: if (l_debug = 1) then
1112: trace(l_proc || ' Start of delete from wms_exceptions ...');
1113: end if;
1114:
1115: delete from wms_exceptions wex
1116: where wex.creation_date > l_min_date
1117: and wex.creation_date <= l_max_date
1118: and wex.organization_id = nvl(p_org_id, wex.organization_id);
1119:

Line 1121: trace(l_proc || ' End of delete from wms_exceptions ...');

1117: and wex.creation_date <= l_max_date
1118: and wex.organization_id = nvl(p_org_id, wex.organization_id);
1119:
1120: if (l_debug = 1) then
1121: trace(l_proc || ' End of delete from wms_exceptions ...');
1122: end if;
1123:
1124: if (l_debug = 1) then
1125: trace(l_proc || ' Before commit in Worker...');