DBA Data[Home] [Help]

APPS.WMS_ARCHIVE_PVT dependencies on WMS_DISPATCHED_TASKS_HISTORY

Line 142: from wms_dispatched_tasks_history

138: -- ### purged(not including this date, is emphasized).
139: cursor c_get_total_eligible_recs is
140: select count(*), min(last_update_date), max(last_update_date),
141: (max(last_update_date) - min(last_update_date))
142: from wms_dispatched_tasks_history
143: where last_update_date < (sysdate - l_purge_days)
144: and organization_id = nvl(p_org_id, organization_id);
145: --
146: --

Line 518: -- @@@ Insert records from the wms_dispatched_tasks_history into wms_dispatched_tasks_arch

514: raise fnd_api.g_exc_error;
515: end if;
516:
517: -- @@@ Insert section.
518: -- @@@ Insert records from the wms_dispatched_tasks_history into wms_dispatched_tasks_arch
519: -- @@@ where parent_transaction_id is not null and task_type in (2,8)
520: if (l_debug = 1) then
521: trace(l_proc || ' Start of insert into wms_dispatched_tasks_arch ...');
522: trace(l_proc || ' for parent_transaction_id is not null and task_type in (2,8)');

Line 657: from wms_dispatched_tasks_history wdth, wms_op_plan_instances_hist wopih

653: ,wdth.TASK_METHOD
654: ,wdth.TRANSACTION_TYPE_ID
655: ,wdth.TRANSACTION_SOURCE_TYPE_ID
656: ,wdth.TRANSACTION_ACTION_ID
657: from wms_dispatched_tasks_history wdth, wms_op_plan_instances_hist wopih
658: where wdth.last_update_date > l_min_date
659: and wdth.last_update_date <= l_max_date
660: and wdth.parent_transaction_id is not null
661: and wdth.task_type in (2,8)

Line 676: -- @@@ Insert records from the wms_dispatched_tasks_history into wms_dispatched_tasks_arch

672: trace(l_proc || ' End of insert into wms_dispatched_tasks_arch ...');
673: trace(l_proc || ' for parent_transaction_id is not null and task_type in (2,8)');
674: end if;
675:
676: -- @@@ Insert records from the wms_dispatched_tasks_history into wms_dispatched_tasks_arch
677: -- @@@ where parent_transaction_id is null and task_type not in (2,8)
678: if (l_debug = 1) then
679: trace(l_proc || ' Start of insert into wms_dispatched_tasks_arch ...');
680: trace(l_proc || ' for parent_transaction_id is null and task_type not in (2,8)');

Line 815: from wms_dispatched_tasks_history wdth

811: ,TASK_METHOD
812: ,TRANSACTION_TYPE_ID
813: ,TRANSACTION_SOURCE_TYPE_ID
814: ,TRANSACTION_ACTION_ID
815: from wms_dispatched_tasks_history wdth
816: where wdth.last_update_date > l_min_date
817: and wdth.last_update_date <= l_max_date
818: and (wdth.parent_transaction_id is null or wdth.task_type not in (2,8))
819: and wdth.organization_id = nvl(p_org_id, wdth.organization_id);

Line 1024: trace(l_proc || ' Start of delete from wms_dispatched_tasks_history ...');

1020:
1021: -- @@@ Delete Section
1022: -- @@@ Delete records from wms_dispatched_tasks_arch table.
1023: if (l_debug = 1) then
1024: trace(l_proc || ' Start of delete from wms_dispatched_tasks_history ...');
1025: trace(l_proc || ' for parent_transaction_id is not null and task_type in (2,8)');
1026: end if;
1027:
1028: delete from wms_dispatched_tasks_history

Line 1028: delete from wms_dispatched_tasks_history

1024: trace(l_proc || ' Start of delete from wms_dispatched_tasks_history ...');
1025: trace(l_proc || ' for parent_transaction_id is not null and task_type in (2,8)');
1026: end if;
1027:
1028: delete from wms_dispatched_tasks_history
1029: where task_id in (
1030: select wdth.task_id
1031: from wms_dispatched_tasks_history wdth, wms_op_plan_instances_hist wopih
1032: where wdth.last_update_date > l_min_date

Line 1031: from wms_dispatched_tasks_history wdth, wms_op_plan_instances_hist wopih

1027:
1028: delete from wms_dispatched_tasks_history
1029: where task_id in (
1030: select wdth.task_id
1031: from wms_dispatched_tasks_history wdth, wms_op_plan_instances_hist wopih
1032: where wdth.last_update_date > l_min_date
1033: and wdth.last_update_date <= l_max_date
1034: and wdth.parent_transaction_id is not null
1035: and wdth.task_type in (2,8)

Line 1046: trace(l_proc || ' End of delete from wms_dispatched_tasks_history ...');

1042: trace(l_proc || ' l_number_of_records => '|| l_number_of_records);
1043: end if;
1044:
1045: if (l_debug = 1) then
1046: trace(l_proc || ' End of delete from wms_dispatched_tasks_history ...');
1047: trace(l_proc || ' for parent_transaction_id is not null and task_type in (2,8)');
1048: end if;
1049:
1050: -- @@@ Delete records from wms_dispatched_tasks_arch table.

Line 1052: trace(l_proc || ' Start of delete from wms_dispatched_tasks_history ...');

1048: end if;
1049:
1050: -- @@@ Delete records from wms_dispatched_tasks_arch table.
1051: if (l_debug = 1) then
1052: trace(l_proc || ' Start of delete from wms_dispatched_tasks_history ...');
1053: trace(l_proc || ' for parent_transaction_id is null and task_type not in (2,8)');
1054: end if;
1055:
1056: delete from wms_dispatched_tasks_history wdth

Line 1056: delete from wms_dispatched_tasks_history wdth

1052: trace(l_proc || ' Start of delete from wms_dispatched_tasks_history ...');
1053: trace(l_proc || ' for parent_transaction_id is null and task_type not in (2,8)');
1054: end if;
1055:
1056: delete from wms_dispatched_tasks_history wdth
1057: where wdth.last_update_date > l_min_date
1058: and wdth.last_update_date <= l_max_date
1059: and (wdth.parent_transaction_id is null or wdth.task_type not in (2,8))
1060: and wdth.organization_id = nvl(p_org_id, wdth.organization_id);

Line 1068: trace(l_proc || ' End of delete from wms_dispatched_tasks_history ...');

1064: trace(l_proc || ' l_number_of_records => '|| l_number_of_records);
1065: end if;
1066:
1067: if (l_debug = 1) then
1068: trace(l_proc || ' End of delete from wms_dispatched_tasks_history ...');
1069: trace(l_proc || ' for parent_transaction_id is null and task_type not in (2,8)');
1070: end if;
1071:
1072: -- @@@ Delete records from the wms_op_plan_instances_hist table.

Line 1365: -- @@@ Insert records from the wms_dispatched_tasks_arch into wms_dispatched_tasks_history

1361: end if;
1362:
1363: --savepoint unarch_task_master_savepoint;
1364: -- @@@ Insert section.
1365: -- @@@ Insert records from the wms_dispatched_tasks_arch into wms_dispatched_tasks_history
1366: -- @@@ These records are those which may have be missed in the worker cursor.
1367: -- @@@ For every wopia, there can be multiple records in the wdta. Since the main cursor in
1368: -- @@@ the master, queries on the wdta, there is a chance that the from and to date
1369: -- @@@ specified by the user may not get all the related records satisfied by the condition

Line 1371: insert into wms_dispatched_tasks_history(

1367: -- @@@ For every wopia, there can be multiple records in the wdta. Since the main cursor in
1368: -- @@@ the master, queries on the wdta, there is a chance that the from and to date
1369: -- @@@ specified by the user may not get all the related records satisfied by the condition
1370: -- @@@ mentioned in this SQL. This makes sure that there is no data inconsistency.
1371: insert into wms_dispatched_tasks_history(
1372: TASK_ID
1373: ,TRANSACTION_ID
1374: ,ORGANIZATION_ID
1375: ,USER_TASK_TYPE

Line 1830: -- @@@ Insert records from the wms_dispatched_tasks_arch into wms_dispatched_tasks_history

1826: raise fnd_api.g_exc_error;
1827: end if;
1828:
1829: -- @@@ Insert section.
1830: -- @@@ Insert records from the wms_dispatched_tasks_arch into wms_dispatched_tasks_history
1831: -- @@@ where parent_transaction_id is not null and task_type in (2,8)
1832: if (l_debug = 1) then
1833: trace(l_proc || ' Start of insert into wms_dispatched_tasks_history ...');
1834: end if;

Line 1833: trace(l_proc || ' Start of insert into wms_dispatched_tasks_history ...');

1829: -- @@@ Insert section.
1830: -- @@@ Insert records from the wms_dispatched_tasks_arch into wms_dispatched_tasks_history
1831: -- @@@ where parent_transaction_id is not null and task_type in (2,8)
1832: if (l_debug = 1) then
1833: trace(l_proc || ' Start of insert into wms_dispatched_tasks_history ...');
1834: end if;
1835:
1836: insert into wms_dispatched_tasks_history(
1837: TASK_ID

Line 1836: insert into wms_dispatched_tasks_history(

1832: if (l_debug = 1) then
1833: trace(l_proc || ' Start of insert into wms_dispatched_tasks_history ...');
1834: end if;
1835:
1836: insert into wms_dispatched_tasks_history(
1837: TASK_ID
1838: ,TRANSACTION_ID
1839: ,ORGANIZATION_ID
1840: ,USER_TASK_TYPE

Line 1979: trace(l_proc || ' End of insert into wms_dispatched_tasks_history ...');

1975: trace(l_proc || ' l_number_of_records => '|| l_number_of_records);
1976: end if;
1977:
1978: if (l_debug = 1) then
1979: trace(l_proc || ' End of insert into wms_dispatched_tasks_history ...');
1980: end if;
1981:
1982: -- @@@ Insert records from the wms_op_plan_instance_hist into wms_op_plan_instances_archive
1983: if (l_debug = 1) then