DBA Data[Home] [Help]

APPS.WMS_ARCHIVE_PVT dependencies on WMS_DISPATCHED_TASKS_ARCH

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 521: trace(l_proc || ' Start of insert into wms_dispatched_tasks_arch ...');

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)');
523: end if;
524:
525: insert into wms_dispatched_tasks_arch(

Line 525: insert into wms_dispatched_tasks_arch(

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)');
523: end if;
524:
525: insert into wms_dispatched_tasks_arch(
526: TASK_ID
527: ,TRANSACTION_ID
528: ,ORGANIZATION_ID
529: ,USER_TASK_TYPE

Line 672: trace(l_proc || ' End of insert into wms_dispatched_tasks_arch ...');

668: trace(l_proc || ' l_number_of_records => '|| l_number_of_records);
669: end if;
670:
671: if (l_debug = 1) then
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

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 679: trace(l_proc || ' Start of insert into wms_dispatched_tasks_arch ...');

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)');
681: end if;
682:
683: insert into wms_dispatched_tasks_arch(

Line 683: insert into wms_dispatched_tasks_arch(

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)');
681: end if;
682:
683: insert into wms_dispatched_tasks_arch(
684: TASK_ID
685: ,TRANSACTION_ID
686: ,ORGANIZATION_ID
687: ,USER_TASK_TYPE

Line 827: trace(l_proc || ' End of insert into wms_dispatched_tasks_arch ...');

823: trace(l_proc || ' l_number_of_records => '|| l_number_of_records);
824: end if;
825:
826: if (l_debug = 1) then
827: trace(l_proc || ' End of insert into wms_dispatched_tasks_arch ...');
828: trace(l_proc || ' for parent_transaction_id is null and task_type not in (2,8)');
829: end if;
830:
831: -- @@@ Insert records into the wms_op_plan_instances_arch from the wms_op_plan_instances_hist

Line 1022: -- @@@ Delete records from wms_dispatched_tasks_arch table.

1018: trace(l_proc || ' End of insert into wms_op_opertn_instances_arch ...');
1019: end if;
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;

Line 1050: -- @@@ Delete records from wms_dispatched_tasks_arch table.

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.
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;

Line 1248: from wms_dispatched_tasks_arch

1244: -- ### Data in this tables which lies betweent he range provided is elligible to be moved
1245: -- ### back to the history tables.
1246: cursor c_get_total_eligible_recs is
1247: select count(*), (l_max_date - l_min_date)
1248: from wms_dispatched_tasks_arch
1249: where last_update_date > l_min_date
1250: and last_update_date <= l_max_date
1251: and organization_id = nvl(p_org_id, organization_id);
1252: --

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 1503: from wms_dispatched_tasks_arch wdta, wms_op_plan_instances_arch wopia

1499: ,wdta.TASK_METHOD
1500: ,wdta.TRANSACTION_TYPE_ID
1501: ,wdta.TRANSACTION_SOURCE_TYPE_ID
1502: ,wdta.TRANSACTION_ACTION_ID
1503: from wms_dispatched_tasks_arch wdta, wms_op_plan_instances_arch wopia
1504: where wdta.last_update_date < l_min_date
1505: and wopia.op_plan_instance_id = wdta.op_plan_instance_id
1506: and wdta.organization_id = wopia.organization_id
1507: and wdta.organization_id = nvl(p_org_id, wdta.organization_id)

Line 1524: -- @@@ Delete this information from the wms_dispatched_tasks_arch table after inserting.

1520: if (l_debug = 1) then
1521: trace(l_proc || ' Start of Delete based on the exception condition...');
1522: end if;
1523:
1524: -- @@@ Delete this information from the wms_dispatched_tasks_arch table after inserting.
1525: delete from wms_dispatched_tasks_arch
1526: where task_id in (
1527: select wdta.task_id
1528: from wms_dispatched_tasks_arch wdta, wms_op_plan_instances_arch wopia

Line 1525: delete from wms_dispatched_tasks_arch

1521: trace(l_proc || ' Start of Delete based on the exception condition...');
1522: end if;
1523:
1524: -- @@@ Delete this information from the wms_dispatched_tasks_arch table after inserting.
1525: delete from wms_dispatched_tasks_arch
1526: where task_id in (
1527: select wdta.task_id
1528: from wms_dispatched_tasks_arch wdta, wms_op_plan_instances_arch wopia
1529: where wdta.last_update_date <= l_min_date

Line 1528: from wms_dispatched_tasks_arch wdta, wms_op_plan_instances_arch wopia

1524: -- @@@ Delete this information from the wms_dispatched_tasks_arch table after inserting.
1525: delete from wms_dispatched_tasks_arch
1526: where task_id in (
1527: select wdta.task_id
1528: from wms_dispatched_tasks_arch wdta, wms_op_plan_instances_arch wopia
1529: where wdta.last_update_date <= l_min_date
1530: and wopia.op_plan_instance_id = wdta.op_plan_instance_id
1531: and wdta.organization_id = wopia.organization_id
1532: and wdta.organization_id = nvl(p_org_id, wdta.organization_id)

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 1968: from wms_dispatched_tasks_arch wdta

1964: ,wdta.TASK_METHOD
1965: ,wdta.TRANSACTION_TYPE_ID
1966: ,wdta.TRANSACTION_SOURCE_TYPE_ID
1967: ,wdta.TRANSACTION_ACTION_ID
1968: from wms_dispatched_tasks_arch wdta
1969: where wdta.last_update_date > l_min_date
1970: and wdta.last_update_date <= l_max_date
1971: and wdta.organization_id = nvl(p_org_id, wdta.organization_id);
1972:

Line 2177: -- @@@ Delete records from wms_dispatched_tasks_arch table.

2173: trace(l_proc || ' End of insert into wms_op_opertn_instances_hist ...');
2174: end if;
2175:
2176: -- @@@ Delete Section
2177: -- @@@ Delete records from wms_dispatched_tasks_arch table.
2178: if (l_debug = 1) then
2179: trace(l_proc || ' Start of delete from wms_dispatched_tasks_arch ...');
2180: end if;
2181:

Line 2179: trace(l_proc || ' Start of delete from wms_dispatched_tasks_arch ...');

2175:
2176: -- @@@ Delete Section
2177: -- @@@ Delete records from wms_dispatched_tasks_arch table.
2178: if (l_debug = 1) then
2179: trace(l_proc || ' Start of delete from wms_dispatched_tasks_arch ...');
2180: end if;
2181:
2182: delete from wms_dispatched_tasks_arch wdta
2183: where wdta.last_update_date > l_min_date

Line 2182: delete from wms_dispatched_tasks_arch wdta

2178: if (l_debug = 1) then
2179: trace(l_proc || ' Start of delete from wms_dispatched_tasks_arch ...');
2180: end if;
2181:
2182: delete from wms_dispatched_tasks_arch wdta
2183: where wdta.last_update_date > l_min_date
2184: and wdta.last_update_date <= l_max_date
2185: and wdta.organization_id = nvl(p_org_id, wdta.organization_id);
2186:

Line 2193: trace(l_proc || ' End of delete from wms_dispatched_tasks_arch ...');

2189: trace(l_proc || ' l_number_of_records => '|| l_number_of_records);
2190: end if;
2191:
2192: if (l_debug = 1) then
2193: trace(l_proc || ' End of delete from wms_dispatched_tasks_arch ...');
2194: end if;
2195:
2196: -- @@@ Delete records from the wms_op_plan_instances_arch table.
2197: if (l_debug = 1) then