APPS.WMS_ARCHIVE_PVT dependencies on WMS_OP_OPERTN_INSTANCES_ARCH

Line 918: -- @@@ Insert records from the wms_op_opertn_instances_hist into wms_op_opertn_instances_arch

914: if (l_debug = 1) then
915: trace(l_proc || ' End of insert into wms_op_plan_instances_arch ...');
916: end if;
917:
918: -- @@@ Insert records from the wms_op_opertn_instances_hist into wms_op_opertn_instances_arch
919: if (l_debug = 1) then
920: trace(l_proc || ' Start of insert into wms_op_opertn_instances_arch ...');
921: end if;
922:

Line 920: trace(l_proc || ' Start of insert into wms_op_opertn_instances_arch ...');

916: end if;
917:
918: -- @@@ Insert records from the wms_op_opertn_instances_hist into wms_op_opertn_instances_arch
919: if (l_debug = 1) then
920: trace(l_proc || ' Start of insert into wms_op_opertn_instances_arch ...');
921: end if;
922:
923: insert into wms_op_opertn_instances_arch(
924: OPERATION_INSTANCE_ID

Line 923: insert into wms_op_opertn_instances_arch(

919: if (l_debug = 1) then
920: trace(l_proc || ' Start of insert into wms_op_opertn_instances_arch ...');
921: end if;
922:
923: insert into wms_op_opertn_instances_arch(
924: OPERATION_INSTANCE_ID
925: ,OP_PLAN_INSTANCE_ID
926: ,ORGANIZATION_ID
927: ,OPERATION_STATUS

Line 1018: trace(l_proc || ' End of insert into wms_op_opertn_instances_arch ...');

1014: trace(l_proc || ' l_number_of_records => '|| l_number_of_records);
1015: end if;
1016:
1017: if (l_debug = 1) then
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.

Line 2069: -- @@@ Insert records from the wms_op_opertn_instances_archive into wms_op_opertn_instance_hist

2065: if (l_debug = 1) then
2066: trace(l_proc || ' End of insert into wms_op_plan_instance_hist ...');
2067: end if;
2068:
2069: -- @@@ Insert records from the wms_op_opertn_instances_archive into wms_op_opertn_instance_hist
2070: if (l_debug = 1) then
2071: trace(l_proc || ' Start of insert into wms_op_opertn_instances_hist ...');
2072: end if;
2073:

Line 2162: from wms_op_opertn_instances_arch wooia

2158: ,EQUIPMENT_ID
2159: ,ACTIVATE_TIME
2160: ,COMPLETE_TIME
2161: ,IS_IN_INVENTORY
2162: from wms_op_opertn_instances_arch wooia
2163: where wooia.last_update_date > l_min_date
2164: and wooia.last_update_date <= l_max_date
2165: and wooia.organization_id = nvl(p_org_id, wooia.organization_id);
2166:

Line 2217: trace(l_proc || ' Start of delete from wms_op_opertn_instances_arch ...');

2213: end if;
2214:
2215: -- @@@ Delete records from the wms_op_opertn_instances_hist table
2216: if (l_debug = 1) then
2217: trace(l_proc || ' Start of delete from wms_op_opertn_instances_arch ...');
2218: end if;
2219:
2220: delete from wms_op_opertn_instances_arch wooia
2221: where wooia.last_update_date > l_min_date

Line 2220: delete from wms_op_opertn_instances_arch wooia

2216: if (l_debug = 1) then
2217: trace(l_proc || ' Start of delete from wms_op_opertn_instances_arch ...');
2218: end if;
2219:
2220: delete from wms_op_opertn_instances_arch wooia
2221: where wooia.last_update_date > l_min_date
2222: and wooia.last_update_date <= l_max_date
2223: and wooia.organization_id = nvl(p_org_id, wooia.organization_id);
2224:

Line 2231: trace(l_proc || ' End of delete from wms_op_opertn_instances_arch ...');

2227: trace(l_proc || ' l_number_of_records => '|| l_number_of_records);
2228: end if;
2229:
2230: if (l_debug = 1) then
2231: trace(l_proc || ' End of delete from wms_op_opertn_instances_arch ...');
2232: end if;
2233:
2234: x_retcode := 0;
2235: x_errbuf := 'Success';