APPS.WMS_SEARCH_ORDER_GLOBALS_PVT dependencies on WMS_RULE_TRACE_HEADERS

Line 811: INSERT into WMS_RULE_TRACE_HEADERS (

807:
808: PRAGMA AUTONOMOUS_TRANSACTION;
809: -----
810: begin
811: INSERT into WMS_RULE_TRACE_HEADERS (
812: header_id
813: ,pick_header_id
814: ,move_order_line_id
815: ,total_qty

Line 1149: --- Trace Tables to be deleted - WMS_RULE_TRACE_HEADERS, WMS_RULE_TRACE_LINES

1145: RETURN 'N';
1146:
1147: END IS_BO_Object_selected;
1148: -----------------------------------------------------------------------------
1149: --- Trace Tables to be deleted - WMS_RULE_TRACE_HEADERS, WMS_RULE_TRACE_LINES
1150: -- Deleting trace header and line records based on Gobal Variables
1151: --- stored at the time of Insert header row for Picking and Putaway
1152: --- Records. After deleting the trace records G_PICK_HEADER_ID and
1153: --- G_PUTAWAY_HEADER_ID is initilized to 0

Line 1166: from wms_rule_trace_headers

1162: l_login_id := fnd_global.login_id;
1163: -- Deleteing all trace records created in simulation mode for this user
1164: delete wms_rule_trace_lines
1165: where header_id in (select header_id
1166: from wms_rule_trace_headers
1167: where simulation_mode = 'Y'
1168: and sid = l_login_id);
1169: delete wms_rule_trace_headers
1170: where simulation_mode = 'Y'

Line 1169: delete wms_rule_trace_headers

1165: where header_id in (select header_id
1166: from wms_rule_trace_headers
1167: where simulation_mode = 'Y'
1168: and sid = l_login_id);
1169: delete wms_rule_trace_headers
1170: where simulation_mode = 'Y'
1171: and sid = l_login_id;
1172: COMMIT;
1173: --end if;

Line 2228: ---- global variables based on WMS_RULE_TRACE_HEADERS record for a given move order

2224: end if;
2225: End insert_txn_trace_rows;
2226: ---------------------------------------------------------------------------------------
2227: ---- This procedure is used by 'Run time trace form' to set the
2228: ---- global variables based on WMS_RULE_TRACE_HEADERS record for a given move order
2229: ---- so that the actual traceed path could be shown in the form.
2230:
2231: procedure set_global_variables(
2232: p_move_order_line_id in NUMBER

Line 2243: from wms_rule_trace_headers

2239: object_id,
2240: type_code,
2241: pick_header_id,
2242: creation_date
2243: from wms_rule_trace_headers
2244: where move_order_line_id = p_move_order_line_id
2245: and to_char(creation_date, 'HH:MI:SS') = to_char(p_trace_date, 'HH:MI:SS')
2246: and simulation_mode = 'N'
2247: order by type_code ;