159: RETURN SUCCESS;
160: END IF;
161:
162: -- Initialize who parameters
163: g_login_id := WSH_PR_PICKING_SESSION.login_id;
164: g_user_id := WSH_PR_PICKING_SESSION.user_id;
165: g_program_id := WSH_PR_PICKING_SESSION.program_id;
166: g_request_id := WSH_PR_PICKING_SESSION.request_id;
167: g_application_id := WSH_PR_PICKING_SESSION.application_id;
160: END IF;
161:
162: -- Initialize who parameters
163: g_login_id := WSH_PR_PICKING_SESSION.login_id;
164: g_user_id := WSH_PR_PICKING_SESSION.user_id;
165: g_program_id := WSH_PR_PICKING_SESSION.program_id;
166: g_request_id := WSH_PR_PICKING_SESSION.request_id;
167: g_application_id := WSH_PR_PICKING_SESSION.application_id;
168: g_batch_id := WSH_PR_PICKING_SESSION.batch_id;
161:
162: -- Initialize who parameters
163: g_login_id := WSH_PR_PICKING_SESSION.login_id;
164: g_user_id := WSH_PR_PICKING_SESSION.user_id;
165: g_program_id := WSH_PR_PICKING_SESSION.program_id;
166: g_request_id := WSH_PR_PICKING_SESSION.request_id;
167: g_application_id := WSH_PR_PICKING_SESSION.application_id;
168: g_batch_id := WSH_PR_PICKING_SESSION.batch_id;
169: g_pick_slip_rule_id := WSH_PR_PICKING_SESSION.pick_slip_rule_id;
162: -- Initialize who parameters
163: g_login_id := WSH_PR_PICKING_SESSION.login_id;
164: g_user_id := WSH_PR_PICKING_SESSION.user_id;
165: g_program_id := WSH_PR_PICKING_SESSION.program_id;
166: g_request_id := WSH_PR_PICKING_SESSION.request_id;
167: g_application_id := WSH_PR_PICKING_SESSION.application_id;
168: g_batch_id := WSH_PR_PICKING_SESSION.batch_id;
169: g_pick_slip_rule_id := WSH_PR_PICKING_SESSION.pick_slip_rule_id;
170: g_reservations := WSH_PR_PICKING_SESSION.reservations;
163: g_login_id := WSH_PR_PICKING_SESSION.login_id;
164: g_user_id := WSH_PR_PICKING_SESSION.user_id;
165: g_program_id := WSH_PR_PICKING_SESSION.program_id;
166: g_request_id := WSH_PR_PICKING_SESSION.request_id;
167: g_application_id := WSH_PR_PICKING_SESSION.application_id;
168: g_batch_id := WSH_PR_PICKING_SESSION.batch_id;
169: g_pick_slip_rule_id := WSH_PR_PICKING_SESSION.pick_slip_rule_id;
170: g_reservations := WSH_PR_PICKING_SESSION.reservations;
171: g_warehouse_id := WSH_PR_PICKING_SESSION.warehouse_id;
164: g_user_id := WSH_PR_PICKING_SESSION.user_id;
165: g_program_id := WSH_PR_PICKING_SESSION.program_id;
166: g_request_id := WSH_PR_PICKING_SESSION.request_id;
167: g_application_id := WSH_PR_PICKING_SESSION.application_id;
168: g_batch_id := WSH_PR_PICKING_SESSION.batch_id;
169: g_pick_slip_rule_id := WSH_PR_PICKING_SESSION.pick_slip_rule_id;
170: g_reservations := WSH_PR_PICKING_SESSION.reservations;
171: g_warehouse_id := WSH_PR_PICKING_SESSION.warehouse_id;
172: g_autocreate_deliveries := WSH_PR_PICKING_SESSION.autocreate_deliveries;
165: g_program_id := WSH_PR_PICKING_SESSION.program_id;
166: g_request_id := WSH_PR_PICKING_SESSION.request_id;
167: g_application_id := WSH_PR_PICKING_SESSION.application_id;
168: g_batch_id := WSH_PR_PICKING_SESSION.batch_id;
169: g_pick_slip_rule_id := WSH_PR_PICKING_SESSION.pick_slip_rule_id;
170: g_reservations := WSH_PR_PICKING_SESSION.reservations;
171: g_warehouse_id := WSH_PR_PICKING_SESSION.warehouse_id;
172: g_autocreate_deliveries := WSH_PR_PICKING_SESSION.autocreate_deliveries;
173:
166: g_request_id := WSH_PR_PICKING_SESSION.request_id;
167: g_application_id := WSH_PR_PICKING_SESSION.application_id;
168: g_batch_id := WSH_PR_PICKING_SESSION.batch_id;
169: g_pick_slip_rule_id := WSH_PR_PICKING_SESSION.pick_slip_rule_id;
170: g_reservations := WSH_PR_PICKING_SESSION.reservations;
171: g_warehouse_id := WSH_PR_PICKING_SESSION.warehouse_id;
172: g_autocreate_deliveries := WSH_PR_PICKING_SESSION.autocreate_deliveries;
173:
174: -- Clear tables to track unique picking headers and pick slip numbers
167: g_application_id := WSH_PR_PICKING_SESSION.application_id;
168: g_batch_id := WSH_PR_PICKING_SESSION.batch_id;
169: g_pick_slip_rule_id := WSH_PR_PICKING_SESSION.pick_slip_rule_id;
170: g_reservations := WSH_PR_PICKING_SESSION.reservations;
171: g_warehouse_id := WSH_PR_PICKING_SESSION.warehouse_id;
172: g_autocreate_deliveries := WSH_PR_PICKING_SESSION.autocreate_deliveries;
173:
174: -- Clear tables to track unique picking headers and pick slip numbers
175: g_ps_table.delete;
168: g_batch_id := WSH_PR_PICKING_SESSION.batch_id;
169: g_pick_slip_rule_id := WSH_PR_PICKING_SESSION.pick_slip_rule_id;
170: g_reservations := WSH_PR_PICKING_SESSION.reservations;
171: g_warehouse_id := WSH_PR_PICKING_SESSION.warehouse_id;
172: g_autocreate_deliveries := WSH_PR_PICKING_SESSION.autocreate_deliveries;
173:
174: -- Clear tables to track unique picking headers and pick slip numbers
175: g_ps_table.delete;
176: g_ph_table.delete;