APPS.WMS_ARCHIVE_PVT dependencies on WMS_OP_OPERTN_INSTANCES_HIST

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 1007: from wms_op_opertn_instances_hist wooih

1003: ,EQUIPMENT_ID
1004: ,ACTIVATE_TIME
1005: ,COMPLETE_TIME
1006: ,IS_IN_INVENTORY
1007: from wms_op_opertn_instances_hist wooih
1008: where wooih.last_update_date > l_min_date
1009: and wooih.last_update_date <= l_max_date
1010: and wooih.organization_id = nvl(p_org_id, wooih.organization_id);
1011:

Line 1091: -- @@@ Delete records from the wms_op_opertn_instances_hist table

1087: if (l_debug = 1) then
1088: trace(l_proc || ' End of delete from wms_op_plan_instances_hist ...');
1089: end if;
1090:
1091: -- @@@ Delete records from the wms_op_opertn_instances_hist table
1092: if (l_debug = 1) then
1093: trace(l_proc || ' Start of delete from wms_op_opertn_instances_hist ...');
1094: end if;
1095:

Line 1093: trace(l_proc || ' Start of delete from wms_op_opertn_instances_hist ...');

1089: end if;
1090:
1091: -- @@@ Delete records from the wms_op_opertn_instances_hist table
1092: if (l_debug = 1) then
1093: trace(l_proc || ' Start of delete from wms_op_opertn_instances_hist ...');
1094: end if;
1095:
1096: delete from wms_op_opertn_instances_hist wooih
1097: where wooih.last_update_date > l_min_date

Line 1096: delete from wms_op_opertn_instances_hist wooih

1092: if (l_debug = 1) then
1093: trace(l_proc || ' Start of delete from wms_op_opertn_instances_hist ...');
1094: end if;
1095:
1096: delete from wms_op_opertn_instances_hist wooih
1097: where wooih.last_update_date > l_min_date
1098: and wooih.last_update_date <= l_max_date
1099: and wooih.organization_id = nvl(p_org_id, wooih.organization_id);
1100:

Line 1107: trace(l_proc || ' End of delete from wms_op_opertn_instances_hist ...');

1103: trace(l_proc || ' l_number_of_records => '|| l_number_of_records);
1104: end if;
1105:
1106: if (l_debug = 1) then
1107: trace(l_proc || ' End of delete from wms_op_opertn_instances_hist ...');
1108: end if;
1109:
1110: -- @@@ Delete records from the wms_op_opertn_instances_hist table
1111: if (l_debug = 1) then

Line 1110: -- @@@ Delete records from the wms_op_opertn_instances_hist table

1106: if (l_debug = 1) then
1107: trace(l_proc || ' End of delete from wms_op_opertn_instances_hist ...');
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:

Line 2071: trace(l_proc || ' Start of insert into wms_op_opertn_instances_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:
2074: insert into wms_op_opertn_instances_hist(
2075: OPERATION_INSTANCE_ID

Line 2074: insert into wms_op_opertn_instances_hist(

2070: if (l_debug = 1) then
2071: trace(l_proc || ' Start of insert into wms_op_opertn_instances_hist ...');
2072: end if;
2073:
2074: insert into wms_op_opertn_instances_hist(
2075: OPERATION_INSTANCE_ID
2076: ,OP_PLAN_INSTANCE_ID
2077: ,ORGANIZATION_ID
2078: ,OPERATION_STATUS

Line 2173: trace(l_proc || ' End of insert into wms_op_opertn_instances_hist ...');

2169: trace(l_proc || ' l_number_of_records => '|| l_number_of_records);
2170: end if;
2171:
2172: if (l_debug = 1) then
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.

Line 2215: -- @@@ Delete records from the wms_op_opertn_instances_hist table

2211: if (l_debug = 1) then
2212: trace(l_proc || ' End of delete from wms_op_plan_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: