APPS.WMS_SEARCH_ORDER_GLOBALS_PVT dependencies on WMS_RULE_TRACE_LINES

Line 713: SELECT wms_rule_trace_lines_s.NEXTVAL INTO l_line_id FROM dual;

709: -- Bug #3107777
710: if l_index is null then
711: exit;
712: end if;
713: SELECT wms_rule_trace_lines_s.NEXTVAL INTO l_line_id FROM dual;
714:
715: /* call the table insert procedure to do the insert */
716: insert_lines_row
717: (

Line 899: insert into WMS_RULE_TRACE_LINES

895:
896: PRAGMA AUTONOMOUS_TRANSACTION;
897: ----
898: begin
899: insert into WMS_RULE_TRACE_LINES
900: (
901: header_id
902: ,line_id
903: ,rule_id

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 1164: delete wms_rule_trace_lines

1160:
1161: l_user_id := fnd_global.user_id;
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);