eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_PR_PICKING_ROWS dependencies on WSH_PR_PICKING_SESSION

Line 190: backorder_mode := WSH_PR_PICKING_SESSION.backorders_flag;

186: RETURN SUCCESS;
187: END IF;
188:
189: -- Store the backorder mode for the session
190: backorder_mode := WSH_PR_PICKING_SESSION.backorders_flag;
191: IF backorder_mode NOT IN ('E','I','O') THEN
192: WSH_UTIL.Write_Log('Invalid backorder mode.');
193: RETURN FAILURE;
194: END IF;

Line 197: primary_rsr := WSH_PR_PICKING_SESSION.primary_rsr;

193: RETURN FAILURE;
194: END IF;
195:
196: -- Get the primary release sequence rule attribute
197: primary_rsr := WSH_PR_PICKING_SESSION.primary_rsr;
198:
199: -- If backorders are excluded or included, must process unreleased lines
200: IF backorder_mode in ('E', 'I') THEN
201: WSH_UTIL.Write_Log('Calling Open_Unreleased_SQL_Cursor...');

Line 266: -- This function calls WSH_PR_PICKING_SESSION to create the dynamic SQL

262: -- Name
263: -- FUNCTION Open_Unreleased_SQL_Cursor
264: --
265: -- Purpose
266: -- This function calls WSH_PR_PICKING_SESSION to create the dynamic SQL
267: -- statement for unreleased lines, calls open_execute_cursor to open,
268: -- parse and execute the cursor for unreleased lines.
269: --
270: -- Return Values

Line 286: WSH_UTIL.Write_Log('Calling WSH_PR_PICKING_SESSION.Unreleased_Line_Details...');

282: BEGIN
283: WSH_UTIL.Write_Log('Starting WSH_PICKING_ROWS.Open_Unreleased_SQL_Cursor');
284:
285: -- Call to dynamically create SQL for unreleased lines
286: WSH_UTIL.Write_Log('Calling WSH_PR_PICKING_SESSION.Unreleased_Line_Details...');
287: cs := WSH_PR_PICKING_SESSION.Unreleased_Line_Details;
288: IF cs = FAILURE THEN
289: WSH_UTIL.Write_Log('Error in WSH_PR_PICKING_SESSION.Unreleased_Line_Details');
290: RETURN FAILURE;

Line 287: cs := WSH_PR_PICKING_SESSION.Unreleased_Line_Details;

283: WSH_UTIL.Write_Log('Starting WSH_PICKING_ROWS.Open_Unreleased_SQL_Cursor');
284:
285: -- Call to dynamically create SQL for unreleased lines
286: WSH_UTIL.Write_Log('Calling WSH_PR_PICKING_SESSION.Unreleased_Line_Details...');
287: cs := WSH_PR_PICKING_SESSION.Unreleased_Line_Details;
288: IF cs = FAILURE THEN
289: WSH_UTIL.Write_Log('Error in WSH_PR_PICKING_SESSION.Unreleased_Line_Details');
290: RETURN FAILURE;
291: END IF;

Line 289: WSH_UTIL.Write_Log('Error in WSH_PR_PICKING_SESSION.Unreleased_Line_Details');

285: -- Call to dynamically create SQL for unreleased lines
286: WSH_UTIL.Write_Log('Calling WSH_PR_PICKING_SESSION.Unreleased_Line_Details...');
287: cs := WSH_PR_PICKING_SESSION.Unreleased_Line_Details;
288: IF cs = FAILURE THEN
289: WSH_UTIL.Write_Log('Error in WSH_PR_PICKING_SESSION.Unreleased_Line_Details');
290: RETURN FAILURE;
291: END IF;
292:
293: -- Fetch the unreleased_SQL string

Line 294: WSH_UTIL.Write_Log('Calling WSH_PR_PICKING_SESSION.Get_Session_Value for unreleased SQL');

290: RETURN FAILURE;
291: END IF;
292:
293: -- Fetch the unreleased_SQL string
294: WSH_UTIL.Write_Log('Calling WSH_PR_PICKING_SESSION.Get_Session_Value for unreleased SQL');
295: unreleased_SQL := WSH_PR_PICKING_SESSION.Get_Session_Value('UNRELEASED_SQL');
296: IF unreleased_SQL = '-1' THEN
297: WSH_UTIL.Write_Log('Error in call to WSH_PR_PICKING_SESSION.Get_Session_Value');
298: RETURN FAILURE;

Line 295: unreleased_SQL := WSH_PR_PICKING_SESSION.Get_Session_Value('UNRELEASED_SQL');

291: END IF;
292:
293: -- Fetch the unreleased_SQL string
294: WSH_UTIL.Write_Log('Calling WSH_PR_PICKING_SESSION.Get_Session_Value for unreleased SQL');
295: unreleased_SQL := WSH_PR_PICKING_SESSION.Get_Session_Value('UNRELEASED_SQL');
296: IF unreleased_SQL = '-1' THEN
297: WSH_UTIL.Write_Log('Error in call to WSH_PR_PICKING_SESSION.Get_Session_Value');
298: RETURN FAILURE;
299: END IF;

Line 297: WSH_UTIL.Write_Log('Error in call to WSH_PR_PICKING_SESSION.Get_Session_Value');

293: -- Fetch the unreleased_SQL string
294: WSH_UTIL.Write_Log('Calling WSH_PR_PICKING_SESSION.Get_Session_Value for unreleased SQL');
295: unreleased_SQL := WSH_PR_PICKING_SESSION.Get_Session_Value('UNRELEASED_SQL');
296: IF unreleased_SQL = '-1' THEN
297: WSH_UTIL.Write_Log('Error in call to WSH_PR_PICKING_SESSION.Get_Session_Value');
298: RETURN FAILURE;
299: END IF;
300:
301: -- Call package to process buffer into cursor for parsing and executing

Line 318: -- This function calls WSH_PR_PICKING_SESSION to create the dynamic SQL

314: -- Name
315: -- FUNCTION Open_Backordered_SQL_Cursor
316: --
317: -- Purpose
318: -- This function calls WSH_PR_PICKING_SESSION to create the dynamic SQL
319: -- statement for backordered lines, calls open_execute_cursor to open,
320: -- parse and execute the cursor for backordered lines.
321: --
322: -- Return Values

Line 337: WSH_UTIL.Write_Log('Calling WSH_PR_PICKING_SESSION.Backordered_Line_Details');

333:
334: BEGIN
335: -- Call to dynamically create SQL for backordered lines
336: WSH_UTIL.Write_Log('Starting WSH_PICKING_ROWS.Open_Backordered_SQL_Cursor');
337: WSH_UTIL.Write_Log('Calling WSH_PR_PICKING_SESSION.Backordered_Line_Details');
338: cs := WSH_PR_PICKING_SESSION.Backordered_Line_Details;
339: IF cs = FAILURE THEN
340: WSH_UTIL.Write_Log('Error in WSH_PR_PICKING_SESSION.Backordered_Line_Details');
341: RETURN FAILURE;

Line 338: cs := WSH_PR_PICKING_SESSION.Backordered_Line_Details;

334: BEGIN
335: -- Call to dynamically create SQL for backordered lines
336: WSH_UTIL.Write_Log('Starting WSH_PICKING_ROWS.Open_Backordered_SQL_Cursor');
337: WSH_UTIL.Write_Log('Calling WSH_PR_PICKING_SESSION.Backordered_Line_Details');
338: cs := WSH_PR_PICKING_SESSION.Backordered_Line_Details;
339: IF cs = FAILURE THEN
340: WSH_UTIL.Write_Log('Error in WSH_PR_PICKING_SESSION.Backordered_Line_Details');
341: RETURN FAILURE;
342: END IF;

Line 340: WSH_UTIL.Write_Log('Error in WSH_PR_PICKING_SESSION.Backordered_Line_Details');

336: WSH_UTIL.Write_Log('Starting WSH_PICKING_ROWS.Open_Backordered_SQL_Cursor');
337: WSH_UTIL.Write_Log('Calling WSH_PR_PICKING_SESSION.Backordered_Line_Details');
338: cs := WSH_PR_PICKING_SESSION.Backordered_Line_Details;
339: IF cs = FAILURE THEN
340: WSH_UTIL.Write_Log('Error in WSH_PR_PICKING_SESSION.Backordered_Line_Details');
341: RETURN FAILURE;
342: END IF;
343:
344: -- Fetch the backordered_SQL string

Line 345: WSH_UTIL.Write_Log('Calling WSH_PR_PICKING_SESSION.Get_Session_Value for backordered SQL');

341: RETURN FAILURE;
342: END IF;
343:
344: -- Fetch the backordered_SQL string
345: WSH_UTIL.Write_Log('Calling WSH_PR_PICKING_SESSION.Get_Session_Value for backordered SQL');
346: backordered_SQL := WSH_PR_PICKING_SESSION.Get_Session_Value('BACKORDERED_SQL');
347: IF backordered_SQL = '-1' THEN
348: WSH_UTIL.Write_Log('Error in call to WSH_PR_PICKING_SESSION.Get_Session_Value');
349: RETURN FAILURE;

Line 346: backordered_SQL := WSH_PR_PICKING_SESSION.Get_Session_Value('BACKORDERED_SQL');

342: END IF;
343:
344: -- Fetch the backordered_SQL string
345: WSH_UTIL.Write_Log('Calling WSH_PR_PICKING_SESSION.Get_Session_Value for backordered SQL');
346: backordered_SQL := WSH_PR_PICKING_SESSION.Get_Session_Value('BACKORDERED_SQL');
347: IF backordered_SQL = '-1' THEN
348: WSH_UTIL.Write_Log('Error in call to WSH_PR_PICKING_SESSION.Get_Session_Value');
349: RETURN FAILURE;
350: END IF;

Line 348: WSH_UTIL.Write_Log('Error in call to WSH_PR_PICKING_SESSION.Get_Session_Value');

344: -- Fetch the backordered_SQL string
345: WSH_UTIL.Write_Log('Calling WSH_PR_PICKING_SESSION.Get_Session_Value for backordered SQL');
346: backordered_SQL := WSH_PR_PICKING_SESSION.Get_Session_Value('BACKORDERED_SQL');
347: IF backordered_SQL = '-1' THEN
348: WSH_UTIL.Write_Log('Error in call to WSH_PR_PICKING_SESSION.Get_Session_Value');
349: RETURN FAILURE;
350: END IF;
351:
352: -- Call package to process buffer into cursor for parsing and executing

Line 369: -- This function calls WSH_PR_PICKING_SESSION to create the dynamic SQL

365: -- Name
366: -- FUNCTION Open_Non_Shippable_SQL_Cursor
367: --
368: -- Purpose
369: -- This function calls WSH_PR_PICKING_SESSION to create the dynamic SQL
370: -- statement for non-shippable lines, calls open_execute_cursor to open,
371: -- parse and execute the cursor for non-shippable lines.
372: --
373: -- Return Values

Line 389: WSH_UTIL.Write_Log('Calling WSH_PR_PICKING_SESSION.Non_Shippable_Line_Details');

385: BEGIN
386: -- Call to dynamically create non_ship_SQL statement based on session
387: -- variables
388: WSH_UTIL.Write_Log('Starting WSH_PICKING_ROWS.Open_Non_Shippable_SQL_Cursor');
389: WSH_UTIL.Write_Log('Calling WSH_PR_PICKING_SESSION.Non_Shippable_Line_Details');
390: cs := WSH_PR_PICKING_SESSION.Non_Shippable_Lines;
391: IF cs = FAILURE THEN
392: WSH_UTIL.Write_Log('Error in WSH_PR_PICKING_SESSION.Non_Shippable_Lines');
393: RETURN FAILURE;

Line 390: cs := WSH_PR_PICKING_SESSION.Non_Shippable_Lines;

386: -- Call to dynamically create non_ship_SQL statement based on session
387: -- variables
388: WSH_UTIL.Write_Log('Starting WSH_PICKING_ROWS.Open_Non_Shippable_SQL_Cursor');
389: WSH_UTIL.Write_Log('Calling WSH_PR_PICKING_SESSION.Non_Shippable_Line_Details');
390: cs := WSH_PR_PICKING_SESSION.Non_Shippable_Lines;
391: IF cs = FAILURE THEN
392: WSH_UTIL.Write_Log('Error in WSH_PR_PICKING_SESSION.Non_Shippable_Lines');
393: RETURN FAILURE;
394: END IF;

Line 392: WSH_UTIL.Write_Log('Error in WSH_PR_PICKING_SESSION.Non_Shippable_Lines');

388: WSH_UTIL.Write_Log('Starting WSH_PICKING_ROWS.Open_Non_Shippable_SQL_Cursor');
389: WSH_UTIL.Write_Log('Calling WSH_PR_PICKING_SESSION.Non_Shippable_Line_Details');
390: cs := WSH_PR_PICKING_SESSION.Non_Shippable_Lines;
391: IF cs = FAILURE THEN
392: WSH_UTIL.Write_Log('Error in WSH_PR_PICKING_SESSION.Non_Shippable_Lines');
393: RETURN FAILURE;
394: END IF;
395:
396: -- Fetch the non_ship_SQL string

Line 397: WSH_UTIL.Write_Log('Calling WSH_PR_PICKING_SESSION.Get_Session_Value for non-ship SQL');

393: RETURN FAILURE;
394: END IF;
395:
396: -- Fetch the non_ship_SQL string
397: WSH_UTIL.Write_Log('Calling WSH_PR_PICKING_SESSION.Get_Session_Value for non-ship SQL');
398: non_ship_SQL := WSH_PR_PICKING_SESSION.Get_Session_Value('NON_SHIP_SQL');
399: IF non_ship_SQL = '-1' THEN
400: WSH_UTIL.Write_Log('Error in call to WSH_PR_PICKING_SESSION.Get_Session_Value');
401: RETURN FAILURE;

Line 398: non_ship_SQL := WSH_PR_PICKING_SESSION.Get_Session_Value('NON_SHIP_SQL');

394: END IF;
395:
396: -- Fetch the non_ship_SQL string
397: WSH_UTIL.Write_Log('Calling WSH_PR_PICKING_SESSION.Get_Session_Value for non-ship SQL');
398: non_ship_SQL := WSH_PR_PICKING_SESSION.Get_Session_Value('NON_SHIP_SQL');
399: IF non_ship_SQL = '-1' THEN
400: WSH_UTIL.Write_Log('Error in call to WSH_PR_PICKING_SESSION.Get_Session_Value');
401: RETURN FAILURE;
402: END IF;

Line 400: WSH_UTIL.Write_Log('Error in call to WSH_PR_PICKING_SESSION.Get_Session_Value');

396: -- Fetch the non_ship_SQL string
397: WSH_UTIL.Write_Log('Calling WSH_PR_PICKING_SESSION.Get_Session_Value for non-ship SQL');
398: non_ship_SQL := WSH_PR_PICKING_SESSION.Get_Session_Value('NON_SHIP_SQL');
399: IF non_ship_SQL = '-1' THEN
400: WSH_UTIL.Write_Log('Error in call to WSH_PR_PICKING_SESSION.Get_Session_Value');
401: RETURN FAILURE;
402: END IF;
403:
404: -- Call package to process buffer into cursor for parsing and executing

Line 499: IF (wsh_pr_picking_session.header_id <> 0) THEN

495:
496: -- Bind release criteria values
497: WSH_UTIL.Write_Log('Binding unreleased cursor');
498:
499: IF (wsh_pr_picking_session.header_id <> 0) THEN
500: WSH_UTIL.Write_Log('X_header_id = ' || to_char(wsh_pr_picking_session.header_id));
501: DBMS_SQL.Bind_Variable(u_cursor, ':X_header_id',
502: wsh_pr_picking_session.header_id);
503: END IF;

Line 500: WSH_UTIL.Write_Log('X_header_id = ' || to_char(wsh_pr_picking_session.header_id));

496: -- Bind release criteria values
497: WSH_UTIL.Write_Log('Binding unreleased cursor');
498:
499: IF (wsh_pr_picking_session.header_id <> 0) THEN
500: WSH_UTIL.Write_Log('X_header_id = ' || to_char(wsh_pr_picking_session.header_id));
501: DBMS_SQL.Bind_Variable(u_cursor, ':X_header_id',
502: wsh_pr_picking_session.header_id);
503: END IF;
504: WSH_UTIL.Write_Log('X_order_type_id = ' || to_char(wsh_pr_picking_session.order_type_id));

Line 502: wsh_pr_picking_session.header_id);

498:
499: IF (wsh_pr_picking_session.header_id <> 0) THEN
500: WSH_UTIL.Write_Log('X_header_id = ' || to_char(wsh_pr_picking_session.header_id));
501: DBMS_SQL.Bind_Variable(u_cursor, ':X_header_id',
502: wsh_pr_picking_session.header_id);
503: END IF;
504: WSH_UTIL.Write_Log('X_order_type_id = ' || to_char(wsh_pr_picking_session.order_type_id));
505: DBMS_SQL.Bind_Variable(u_cursor, ':X_order_type_id',
506: wsh_pr_picking_session.order_type_id);

Line 504: WSH_UTIL.Write_Log('X_order_type_id = ' || to_char(wsh_pr_picking_session.order_type_id));

500: WSH_UTIL.Write_Log('X_header_id = ' || to_char(wsh_pr_picking_session.header_id));
501: DBMS_SQL.Bind_Variable(u_cursor, ':X_header_id',
502: wsh_pr_picking_session.header_id);
503: END IF;
504: WSH_UTIL.Write_Log('X_order_type_id = ' || to_char(wsh_pr_picking_session.order_type_id));
505: DBMS_SQL.Bind_Variable(u_cursor, ':X_order_type_id',
506: wsh_pr_picking_session.order_type_id);
507: IF (wsh_pr_picking_session.customer_id <> 0) THEN
508: WSH_UTIL.Write_Log('X_customer_id = ' || to_char(wsh_pr_picking_session.customer_id));

Line 506: wsh_pr_picking_session.order_type_id);

502: wsh_pr_picking_session.header_id);
503: END IF;
504: WSH_UTIL.Write_Log('X_order_type_id = ' || to_char(wsh_pr_picking_session.order_type_id));
505: DBMS_SQL.Bind_Variable(u_cursor, ':X_order_type_id',
506: wsh_pr_picking_session.order_type_id);
507: IF (wsh_pr_picking_session.customer_id <> 0) THEN
508: WSH_UTIL.Write_Log('X_customer_id = ' || to_char(wsh_pr_picking_session.customer_id));
509: DBMS_SQL.Bind_Variable(u_cursor, ':X_customer_id',
510: wsh_pr_picking_session.customer_id);

Line 507: IF (wsh_pr_picking_session.customer_id <> 0) THEN

503: END IF;
504: WSH_UTIL.Write_Log('X_order_type_id = ' || to_char(wsh_pr_picking_session.order_type_id));
505: DBMS_SQL.Bind_Variable(u_cursor, ':X_order_type_id',
506: wsh_pr_picking_session.order_type_id);
507: IF (wsh_pr_picking_session.customer_id <> 0) THEN
508: WSH_UTIL.Write_Log('X_customer_id = ' || to_char(wsh_pr_picking_session.customer_id));
509: DBMS_SQL.Bind_Variable(u_cursor, ':X_customer_id',
510: wsh_pr_picking_session.customer_id);
511: END IF;

Line 508: WSH_UTIL.Write_Log('X_customer_id = ' || to_char(wsh_pr_picking_session.customer_id));

504: WSH_UTIL.Write_Log('X_order_type_id = ' || to_char(wsh_pr_picking_session.order_type_id));
505: DBMS_SQL.Bind_Variable(u_cursor, ':X_order_type_id',
506: wsh_pr_picking_session.order_type_id);
507: IF (wsh_pr_picking_session.customer_id <> 0) THEN
508: WSH_UTIL.Write_Log('X_customer_id = ' || to_char(wsh_pr_picking_session.customer_id));
509: DBMS_SQL.Bind_Variable(u_cursor, ':X_customer_id',
510: wsh_pr_picking_session.customer_id);
511: END IF;
512:

Line 510: wsh_pr_picking_session.customer_id);

506: wsh_pr_picking_session.order_type_id);
507: IF (wsh_pr_picking_session.customer_id <> 0) THEN
508: WSH_UTIL.Write_Log('X_customer_id = ' || to_char(wsh_pr_picking_session.customer_id));
509: DBMS_SQL.Bind_Variable(u_cursor, ':X_customer_id',
510: wsh_pr_picking_session.customer_id);
511: END IF;
512:
513: IF (wsh_pr_picking_session.order_line_id <> 0) THEN
514: WSH_UTIL.Write_Log('X_order_line_id = ' || to_char(wsh_pr_picking_session.order_line_id));

Line 513: IF (wsh_pr_picking_session.order_line_id <> 0) THEN

509: DBMS_SQL.Bind_Variable(u_cursor, ':X_customer_id',
510: wsh_pr_picking_session.customer_id);
511: END IF;
512:
513: IF (wsh_pr_picking_session.order_line_id <> 0) THEN
514: WSH_UTIL.Write_Log('X_order_line_id = ' || to_char(wsh_pr_picking_session.order_line_id));
515: DBMS_SQL.Bind_Variable(u_cursor, ':X_order_line_id',
516: wsh_pr_picking_session.order_line_id);
517: END IF;

Line 514: WSH_UTIL.Write_Log('X_order_line_id = ' || to_char(wsh_pr_picking_session.order_line_id));

510: wsh_pr_picking_session.customer_id);
511: END IF;
512:
513: IF (wsh_pr_picking_session.order_line_id <> 0) THEN
514: WSH_UTIL.Write_Log('X_order_line_id = ' || to_char(wsh_pr_picking_session.order_line_id));
515: DBMS_SQL.Bind_Variable(u_cursor, ':X_order_line_id',
516: wsh_pr_picking_session.order_line_id);
517: END IF;
518:

Line 516: wsh_pr_picking_session.order_line_id);

512:
513: IF (wsh_pr_picking_session.order_line_id <> 0) THEN
514: WSH_UTIL.Write_Log('X_order_line_id = ' || to_char(wsh_pr_picking_session.order_line_id));
515: DBMS_SQL.Bind_Variable(u_cursor, ':X_order_line_id',
516: wsh_pr_picking_session.order_line_id);
517: END IF;
518:
519: WSH_UTIL.Write_Log('X_ship_set_number = ' || to_char(wsh_pr_picking_session.ship_set_number));
520: DBMS_SQL.Bind_Variable(u_cursor, ':X_ship_set_number',

Line 519: WSH_UTIL.Write_Log('X_ship_set_number = ' || to_char(wsh_pr_picking_session.ship_set_number));

515: DBMS_SQL.Bind_Variable(u_cursor, ':X_order_line_id',
516: wsh_pr_picking_session.order_line_id);
517: END IF;
518:
519: WSH_UTIL.Write_Log('X_ship_set_number = ' || to_char(wsh_pr_picking_session.ship_set_number));
520: DBMS_SQL.Bind_Variable(u_cursor, ':X_ship_set_number',
521: wsh_pr_picking_session.ship_set_number);
522: WSH_UTIL.Write_Log('X_ship_site_use_id = ' || to_char(wsh_pr_picking_session.ship_site_use_id));
523: DBMS_SQL.Bind_Variable(u_cursor, ':X_ship_site_use_id',

Line 521: wsh_pr_picking_session.ship_set_number);

517: END IF;
518:
519: WSH_UTIL.Write_Log('X_ship_set_number = ' || to_char(wsh_pr_picking_session.ship_set_number));
520: DBMS_SQL.Bind_Variable(u_cursor, ':X_ship_set_number',
521: wsh_pr_picking_session.ship_set_number);
522: WSH_UTIL.Write_Log('X_ship_site_use_id = ' || to_char(wsh_pr_picking_session.ship_site_use_id));
523: DBMS_SQL.Bind_Variable(u_cursor, ':X_ship_site_use_id',
524: wsh_pr_picking_session.ship_site_use_id);
525: WSH_UTIL.Write_Log('X_ship_method_code = ' || wsh_pr_picking_session.ship_method_code);

Line 522: WSH_UTIL.Write_Log('X_ship_site_use_id = ' || to_char(wsh_pr_picking_session.ship_site_use_id));

518:
519: WSH_UTIL.Write_Log('X_ship_set_number = ' || to_char(wsh_pr_picking_session.ship_set_number));
520: DBMS_SQL.Bind_Variable(u_cursor, ':X_ship_set_number',
521: wsh_pr_picking_session.ship_set_number);
522: WSH_UTIL.Write_Log('X_ship_site_use_id = ' || to_char(wsh_pr_picking_session.ship_site_use_id));
523: DBMS_SQL.Bind_Variable(u_cursor, ':X_ship_site_use_id',
524: wsh_pr_picking_session.ship_site_use_id);
525: WSH_UTIL.Write_Log('X_ship_method_code = ' || wsh_pr_picking_session.ship_method_code);
526: DBMS_SQL.Bind_Variable(u_cursor, ':X_ship_method_code',

Line 524: wsh_pr_picking_session.ship_site_use_id);

520: DBMS_SQL.Bind_Variable(u_cursor, ':X_ship_set_number',
521: wsh_pr_picking_session.ship_set_number);
522: WSH_UTIL.Write_Log('X_ship_site_use_id = ' || to_char(wsh_pr_picking_session.ship_site_use_id));
523: DBMS_SQL.Bind_Variable(u_cursor, ':X_ship_site_use_id',
524: wsh_pr_picking_session.ship_site_use_id);
525: WSH_UTIL.Write_Log('X_ship_method_code = ' || wsh_pr_picking_session.ship_method_code);
526: DBMS_SQL.Bind_Variable(u_cursor, ':X_ship_method_code',
527: wsh_pr_picking_session.ship_method_code);
528: WSH_UTIL.Write_Log('X_warehouse_id = ' || to_char(wsh_pr_picking_session.warehouse_id));

Line 525: WSH_UTIL.Write_Log('X_ship_method_code = ' || wsh_pr_picking_session.ship_method_code);

521: wsh_pr_picking_session.ship_set_number);
522: WSH_UTIL.Write_Log('X_ship_site_use_id = ' || to_char(wsh_pr_picking_session.ship_site_use_id));
523: DBMS_SQL.Bind_Variable(u_cursor, ':X_ship_site_use_id',
524: wsh_pr_picking_session.ship_site_use_id);
525: WSH_UTIL.Write_Log('X_ship_method_code = ' || wsh_pr_picking_session.ship_method_code);
526: DBMS_SQL.Bind_Variable(u_cursor, ':X_ship_method_code',
527: wsh_pr_picking_session.ship_method_code);
528: WSH_UTIL.Write_Log('X_warehouse_id = ' || to_char(wsh_pr_picking_session.warehouse_id));
529: DBMS_SQL.Bind_Variable(u_cursor, ':X_warehouse_id',

Line 527: wsh_pr_picking_session.ship_method_code);

523: DBMS_SQL.Bind_Variable(u_cursor, ':X_ship_site_use_id',
524: wsh_pr_picking_session.ship_site_use_id);
525: WSH_UTIL.Write_Log('X_ship_method_code = ' || wsh_pr_picking_session.ship_method_code);
526: DBMS_SQL.Bind_Variable(u_cursor, ':X_ship_method_code',
527: wsh_pr_picking_session.ship_method_code);
528: WSH_UTIL.Write_Log('X_warehouse_id = ' || to_char(wsh_pr_picking_session.warehouse_id));
529: DBMS_SQL.Bind_Variable(u_cursor, ':X_warehouse_id',
530: wsh_pr_picking_session.warehouse_id);
531: WSH_UTIL.Write_Log('X_subinventory = ' || wsh_pr_picking_session.subinventory);

Line 528: WSH_UTIL.Write_Log('X_warehouse_id = ' || to_char(wsh_pr_picking_session.warehouse_id));

524: wsh_pr_picking_session.ship_site_use_id);
525: WSH_UTIL.Write_Log('X_ship_method_code = ' || wsh_pr_picking_session.ship_method_code);
526: DBMS_SQL.Bind_Variable(u_cursor, ':X_ship_method_code',
527: wsh_pr_picking_session.ship_method_code);
528: WSH_UTIL.Write_Log('X_warehouse_id = ' || to_char(wsh_pr_picking_session.warehouse_id));
529: DBMS_SQL.Bind_Variable(u_cursor, ':X_warehouse_id',
530: wsh_pr_picking_session.warehouse_id);
531: WSH_UTIL.Write_Log('X_subinventory = ' || wsh_pr_picking_session.subinventory);
532: DBMS_SQL.Bind_Variable(u_cursor, ':X_subinventory',

Line 530: wsh_pr_picking_session.warehouse_id);

526: DBMS_SQL.Bind_Variable(u_cursor, ':X_ship_method_code',
527: wsh_pr_picking_session.ship_method_code);
528: WSH_UTIL.Write_Log('X_warehouse_id = ' || to_char(wsh_pr_picking_session.warehouse_id));
529: DBMS_SQL.Bind_Variable(u_cursor, ':X_warehouse_id',
530: wsh_pr_picking_session.warehouse_id);
531: WSH_UTIL.Write_Log('X_subinventory = ' || wsh_pr_picking_session.subinventory);
532: DBMS_SQL.Bind_Variable(u_cursor, ':X_subinventory',
533: wsh_pr_picking_session.subinventory);
534: WSH_UTIL.Write_Log('X_shipment_priority = ' || wsh_pr_picking_session.shipment_priority);

Line 531: WSH_UTIL.Write_Log('X_subinventory = ' || wsh_pr_picking_session.subinventory);

527: wsh_pr_picking_session.ship_method_code);
528: WSH_UTIL.Write_Log('X_warehouse_id = ' || to_char(wsh_pr_picking_session.warehouse_id));
529: DBMS_SQL.Bind_Variable(u_cursor, ':X_warehouse_id',
530: wsh_pr_picking_session.warehouse_id);
531: WSH_UTIL.Write_Log('X_subinventory = ' || wsh_pr_picking_session.subinventory);
532: DBMS_SQL.Bind_Variable(u_cursor, ':X_subinventory',
533: wsh_pr_picking_session.subinventory);
534: WSH_UTIL.Write_Log('X_shipment_priority = ' || wsh_pr_picking_session.shipment_priority);
535: DBMS_SQL.Bind_Variable(u_cursor, ':X_shipment_priority',

Line 533: wsh_pr_picking_session.subinventory);

529: DBMS_SQL.Bind_Variable(u_cursor, ':X_warehouse_id',
530: wsh_pr_picking_session.warehouse_id);
531: WSH_UTIL.Write_Log('X_subinventory = ' || wsh_pr_picking_session.subinventory);
532: DBMS_SQL.Bind_Variable(u_cursor, ':X_subinventory',
533: wsh_pr_picking_session.subinventory);
534: WSH_UTIL.Write_Log('X_shipment_priority = ' || wsh_pr_picking_session.shipment_priority);
535: DBMS_SQL.Bind_Variable(u_cursor, ':X_shipment_priority',
536: wsh_pr_picking_session.shipment_priority);
537: WSH_UTIL.Write_Log('X_from_request_date = ' || to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));

Line 534: WSH_UTIL.Write_Log('X_shipment_priority = ' || wsh_pr_picking_session.shipment_priority);

530: wsh_pr_picking_session.warehouse_id);
531: WSH_UTIL.Write_Log('X_subinventory = ' || wsh_pr_picking_session.subinventory);
532: DBMS_SQL.Bind_Variable(u_cursor, ':X_subinventory',
533: wsh_pr_picking_session.subinventory);
534: WSH_UTIL.Write_Log('X_shipment_priority = ' || wsh_pr_picking_session.shipment_priority);
535: DBMS_SQL.Bind_Variable(u_cursor, ':X_shipment_priority',
536: wsh_pr_picking_session.shipment_priority);
537: WSH_UTIL.Write_Log('X_from_request_date = ' || to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
538: DBMS_SQL.Bind_Variable(u_cursor, ':X_from_request_date',

Line 536: wsh_pr_picking_session.shipment_priority);

532: DBMS_SQL.Bind_Variable(u_cursor, ':X_subinventory',
533: wsh_pr_picking_session.subinventory);
534: WSH_UTIL.Write_Log('X_shipment_priority = ' || wsh_pr_picking_session.shipment_priority);
535: DBMS_SQL.Bind_Variable(u_cursor, ':X_shipment_priority',
536: wsh_pr_picking_session.shipment_priority);
537: WSH_UTIL.Write_Log('X_from_request_date = ' || to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
538: DBMS_SQL.Bind_Variable(u_cursor, ':X_from_request_date',
539: to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
540: WSH_UTIL.Write_Log('X_to_request_date = ' || to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));

Line 537: WSH_UTIL.Write_Log('X_from_request_date = ' || to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));

533: wsh_pr_picking_session.subinventory);
534: WSH_UTIL.Write_Log('X_shipment_priority = ' || wsh_pr_picking_session.shipment_priority);
535: DBMS_SQL.Bind_Variable(u_cursor, ':X_shipment_priority',
536: wsh_pr_picking_session.shipment_priority);
537: WSH_UTIL.Write_Log('X_from_request_date = ' || to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
538: DBMS_SQL.Bind_Variable(u_cursor, ':X_from_request_date',
539: to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
540: WSH_UTIL.Write_Log('X_to_request_date = ' || to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
541: DBMS_SQL.Bind_Variable(u_cursor, ':X_to_request_date',

Line 539: to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));

535: DBMS_SQL.Bind_Variable(u_cursor, ':X_shipment_priority',
536: wsh_pr_picking_session.shipment_priority);
537: WSH_UTIL.Write_Log('X_from_request_date = ' || to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
538: DBMS_SQL.Bind_Variable(u_cursor, ':X_from_request_date',
539: to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
540: WSH_UTIL.Write_Log('X_to_request_date = ' || to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
541: DBMS_SQL.Bind_Variable(u_cursor, ':X_to_request_date',
542: to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
543: WSH_UTIL.Write_Log('X_from_sched_ship_date = ' || to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));

Line 540: WSH_UTIL.Write_Log('X_to_request_date = ' || to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));

536: wsh_pr_picking_session.shipment_priority);
537: WSH_UTIL.Write_Log('X_from_request_date = ' || to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
538: DBMS_SQL.Bind_Variable(u_cursor, ':X_from_request_date',
539: to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
540: WSH_UTIL.Write_Log('X_to_request_date = ' || to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
541: DBMS_SQL.Bind_Variable(u_cursor, ':X_to_request_date',
542: to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
543: WSH_UTIL.Write_Log('X_from_sched_ship_date = ' || to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
544: DBMS_SQL.Bind_Variable(u_cursor, ':X_from_sched_ship_date',

Line 542: to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));

538: DBMS_SQL.Bind_Variable(u_cursor, ':X_from_request_date',
539: to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
540: WSH_UTIL.Write_Log('X_to_request_date = ' || to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
541: DBMS_SQL.Bind_Variable(u_cursor, ':X_to_request_date',
542: to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
543: WSH_UTIL.Write_Log('X_from_sched_ship_date = ' || to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
544: DBMS_SQL.Bind_Variable(u_cursor, ':X_from_sched_ship_date',
545: to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
546: WSH_UTIL.Write_Log('X_to_sched_ship_date = ' || to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));

Line 543: WSH_UTIL.Write_Log('X_from_sched_ship_date = ' || to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));

539: to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
540: WSH_UTIL.Write_Log('X_to_request_date = ' || to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
541: DBMS_SQL.Bind_Variable(u_cursor, ':X_to_request_date',
542: to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
543: WSH_UTIL.Write_Log('X_from_sched_ship_date = ' || to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
544: DBMS_SQL.Bind_Variable(u_cursor, ':X_from_sched_ship_date',
545: to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
546: WSH_UTIL.Write_Log('X_to_sched_ship_date = ' || to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
547: DBMS_SQL.Bind_Variable(u_cursor, ':X_to_sched_ship_date',

Line 545: to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));

541: DBMS_SQL.Bind_Variable(u_cursor, ':X_to_request_date',
542: to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
543: WSH_UTIL.Write_Log('X_from_sched_ship_date = ' || to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
544: DBMS_SQL.Bind_Variable(u_cursor, ':X_from_sched_ship_date',
545: to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
546: WSH_UTIL.Write_Log('X_to_sched_ship_date = ' || to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
547: DBMS_SQL.Bind_Variable(u_cursor, ':X_to_sched_ship_date',
548: to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
549: WSH_UTIL.Write_Log('X_existing_rsvs_only_flag = ' || wsh_pr_picking_session.existing_rsvs_only_flag);

Line 546: WSH_UTIL.Write_Log('X_to_sched_ship_date = ' || to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));

542: to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
543: WSH_UTIL.Write_Log('X_from_sched_ship_date = ' || to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
544: DBMS_SQL.Bind_Variable(u_cursor, ':X_from_sched_ship_date',
545: to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
546: WSH_UTIL.Write_Log('X_to_sched_ship_date = ' || to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
547: DBMS_SQL.Bind_Variable(u_cursor, ':X_to_sched_ship_date',
548: to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
549: WSH_UTIL.Write_Log('X_existing_rsvs_only_flag = ' || wsh_pr_picking_session.existing_rsvs_only_flag);
550: DBMS_SQL.Bind_Variable(u_cursor, ':X_existing_rsvs_only_flag',

Line 548: to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));

544: DBMS_SQL.Bind_Variable(u_cursor, ':X_from_sched_ship_date',
545: to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
546: WSH_UTIL.Write_Log('X_to_sched_ship_date = ' || to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
547: DBMS_SQL.Bind_Variable(u_cursor, ':X_to_sched_ship_date',
548: to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
549: WSH_UTIL.Write_Log('X_existing_rsvs_only_flag = ' || wsh_pr_picking_session.existing_rsvs_only_flag);
550: DBMS_SQL.Bind_Variable(u_cursor, ':X_existing_rsvs_only_flag',
551: wsh_pr_picking_session.existing_rsvs_only_flag);
552: WSH_UTIL.Write_Log('X_inventory_item_id = ' || to_char(wsh_pr_picking_session.inventory_item_id));

Line 549: WSH_UTIL.Write_Log('X_existing_rsvs_only_flag = ' || wsh_pr_picking_session.existing_rsvs_only_flag);

545: to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
546: WSH_UTIL.Write_Log('X_to_sched_ship_date = ' || to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
547: DBMS_SQL.Bind_Variable(u_cursor, ':X_to_sched_ship_date',
548: to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
549: WSH_UTIL.Write_Log('X_existing_rsvs_only_flag = ' || wsh_pr_picking_session.existing_rsvs_only_flag);
550: DBMS_SQL.Bind_Variable(u_cursor, ':X_existing_rsvs_only_flag',
551: wsh_pr_picking_session.existing_rsvs_only_flag);
552: WSH_UTIL.Write_Log('X_inventory_item_id = ' || to_char(wsh_pr_picking_session.inventory_item_id));
553: DBMS_SQL.Bind_Variable(u_cursor, ':X_inventory_item_id',

Line 551: wsh_pr_picking_session.existing_rsvs_only_flag);

547: DBMS_SQL.Bind_Variable(u_cursor, ':X_to_sched_ship_date',
548: to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
549: WSH_UTIL.Write_Log('X_existing_rsvs_only_flag = ' || wsh_pr_picking_session.existing_rsvs_only_flag);
550: DBMS_SQL.Bind_Variable(u_cursor, ':X_existing_rsvs_only_flag',
551: wsh_pr_picking_session.existing_rsvs_only_flag);
552: WSH_UTIL.Write_Log('X_inventory_item_id = ' || to_char(wsh_pr_picking_session.inventory_item_id));
553: DBMS_SQL.Bind_Variable(u_cursor, ':X_inventory_item_id',
554: wsh_pr_picking_session.inventory_item_id);
555: WSH_UTIL.Write_Log('X_reservations = ' || wsh_pr_picking_session.reservations);

Line 552: WSH_UTIL.Write_Log('X_inventory_item_id = ' || to_char(wsh_pr_picking_session.inventory_item_id));

548: to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
549: WSH_UTIL.Write_Log('X_existing_rsvs_only_flag = ' || wsh_pr_picking_session.existing_rsvs_only_flag);
550: DBMS_SQL.Bind_Variable(u_cursor, ':X_existing_rsvs_only_flag',
551: wsh_pr_picking_session.existing_rsvs_only_flag);
552: WSH_UTIL.Write_Log('X_inventory_item_id = ' || to_char(wsh_pr_picking_session.inventory_item_id));
553: DBMS_SQL.Bind_Variable(u_cursor, ':X_inventory_item_id',
554: wsh_pr_picking_session.inventory_item_id);
555: WSH_UTIL.Write_Log('X_reservations = ' || wsh_pr_picking_session.reservations);
556: DBMS_SQL.Bind_Variable(u_cursor, ':X_reservations',

Line 554: wsh_pr_picking_session.inventory_item_id);

550: DBMS_SQL.Bind_Variable(u_cursor, ':X_existing_rsvs_only_flag',
551: wsh_pr_picking_session.existing_rsvs_only_flag);
552: WSH_UTIL.Write_Log('X_inventory_item_id = ' || to_char(wsh_pr_picking_session.inventory_item_id));
553: DBMS_SQL.Bind_Variable(u_cursor, ':X_inventory_item_id',
554: wsh_pr_picking_session.inventory_item_id);
555: WSH_UTIL.Write_Log('X_reservations = ' || wsh_pr_picking_session.reservations);
556: DBMS_SQL.Bind_Variable(u_cursor, ':X_reservations',
557: wsh_pr_picking_session.reservations);
558: WSH_UTIL.Write_Log('X_departure_id = ' || to_char(wsh_pr_picking_session.departure_id));

Line 555: WSH_UTIL.Write_Log('X_reservations = ' || wsh_pr_picking_session.reservations);

551: wsh_pr_picking_session.existing_rsvs_only_flag);
552: WSH_UTIL.Write_Log('X_inventory_item_id = ' || to_char(wsh_pr_picking_session.inventory_item_id));
553: DBMS_SQL.Bind_Variable(u_cursor, ':X_inventory_item_id',
554: wsh_pr_picking_session.inventory_item_id);
555: WSH_UTIL.Write_Log('X_reservations = ' || wsh_pr_picking_session.reservations);
556: DBMS_SQL.Bind_Variable(u_cursor, ':X_reservations',
557: wsh_pr_picking_session.reservations);
558: WSH_UTIL.Write_Log('X_departure_id = ' || to_char(wsh_pr_picking_session.departure_id));
559: DBMS_SQL.Bind_Variable(u_cursor, ':X_departure_id',

Line 557: wsh_pr_picking_session.reservations);

553: DBMS_SQL.Bind_Variable(u_cursor, ':X_inventory_item_id',
554: wsh_pr_picking_session.inventory_item_id);
555: WSH_UTIL.Write_Log('X_reservations = ' || wsh_pr_picking_session.reservations);
556: DBMS_SQL.Bind_Variable(u_cursor, ':X_reservations',
557: wsh_pr_picking_session.reservations);
558: WSH_UTIL.Write_Log('X_departure_id = ' || to_char(wsh_pr_picking_session.departure_id));
559: DBMS_SQL.Bind_Variable(u_cursor, ':X_departure_id',
560: wsh_pr_picking_session.departure_id);
561: IF (wsh_pr_picking_session.delivery_id <> 0) THEN

Line 558: WSH_UTIL.Write_Log('X_departure_id = ' || to_char(wsh_pr_picking_session.departure_id));

554: wsh_pr_picking_session.inventory_item_id);
555: WSH_UTIL.Write_Log('X_reservations = ' || wsh_pr_picking_session.reservations);
556: DBMS_SQL.Bind_Variable(u_cursor, ':X_reservations',
557: wsh_pr_picking_session.reservations);
558: WSH_UTIL.Write_Log('X_departure_id = ' || to_char(wsh_pr_picking_session.departure_id));
559: DBMS_SQL.Bind_Variable(u_cursor, ':X_departure_id',
560: wsh_pr_picking_session.departure_id);
561: IF (wsh_pr_picking_session.delivery_id <> 0) THEN
562: WSH_UTIL.Write_Log('X_delivery_id = ' || to_char(wsh_pr_picking_session.delivery_id));

Line 560: wsh_pr_picking_session.departure_id);

556: DBMS_SQL.Bind_Variable(u_cursor, ':X_reservations',
557: wsh_pr_picking_session.reservations);
558: WSH_UTIL.Write_Log('X_departure_id = ' || to_char(wsh_pr_picking_session.departure_id));
559: DBMS_SQL.Bind_Variable(u_cursor, ':X_departure_id',
560: wsh_pr_picking_session.departure_id);
561: IF (wsh_pr_picking_session.delivery_id <> 0) THEN
562: WSH_UTIL.Write_Log('X_delivery_id = ' || to_char(wsh_pr_picking_session.delivery_id));
563: DBMS_SQL.Bind_Variable(u_cursor, ':X_delivery_id',
564: wsh_pr_picking_session.delivery_id);

Line 561: IF (wsh_pr_picking_session.delivery_id <> 0) THEN

557: wsh_pr_picking_session.reservations);
558: WSH_UTIL.Write_Log('X_departure_id = ' || to_char(wsh_pr_picking_session.departure_id));
559: DBMS_SQL.Bind_Variable(u_cursor, ':X_departure_id',
560: wsh_pr_picking_session.departure_id);
561: IF (wsh_pr_picking_session.delivery_id <> 0) THEN
562: WSH_UTIL.Write_Log('X_delivery_id = ' || to_char(wsh_pr_picking_session.delivery_id));
563: DBMS_SQL.Bind_Variable(u_cursor, ':X_delivery_id',
564: wsh_pr_picking_session.delivery_id);
565: END IF;

Line 562: WSH_UTIL.Write_Log('X_delivery_id = ' || to_char(wsh_pr_picking_session.delivery_id));

558: WSH_UTIL.Write_Log('X_departure_id = ' || to_char(wsh_pr_picking_session.departure_id));
559: DBMS_SQL.Bind_Variable(u_cursor, ':X_departure_id',
560: wsh_pr_picking_session.departure_id);
561: IF (wsh_pr_picking_session.delivery_id <> 0) THEN
562: WSH_UTIL.Write_Log('X_delivery_id = ' || to_char(wsh_pr_picking_session.delivery_id));
563: DBMS_SQL.Bind_Variable(u_cursor, ':X_delivery_id',
564: wsh_pr_picking_session.delivery_id);
565: END IF;
566: WSH_UTIL.Write_Log('X_include_planned_lines = ' || wsh_pr_picking_session.include_planned_lines);

Line 564: wsh_pr_picking_session.delivery_id);

560: wsh_pr_picking_session.departure_id);
561: IF (wsh_pr_picking_session.delivery_id <> 0) THEN
562: WSH_UTIL.Write_Log('X_delivery_id = ' || to_char(wsh_pr_picking_session.delivery_id));
563: DBMS_SQL.Bind_Variable(u_cursor, ':X_delivery_id',
564: wsh_pr_picking_session.delivery_id);
565: END IF;
566: WSH_UTIL.Write_Log('X_include_planned_lines = ' || wsh_pr_picking_session.include_planned_lines);
567: DBMS_SQL.Bind_Variable(u_cursor, ':X_include_planned_lines',
568: wsh_pr_picking_session.include_planned_lines);

Line 566: WSH_UTIL.Write_Log('X_include_planned_lines = ' || wsh_pr_picking_session.include_planned_lines);

562: WSH_UTIL.Write_Log('X_delivery_id = ' || to_char(wsh_pr_picking_session.delivery_id));
563: DBMS_SQL.Bind_Variable(u_cursor, ':X_delivery_id',
564: wsh_pr_picking_session.delivery_id);
565: END IF;
566: WSH_UTIL.Write_Log('X_include_planned_lines = ' || wsh_pr_picking_session.include_planned_lines);
567: DBMS_SQL.Bind_Variable(u_cursor, ':X_include_planned_lines',
568: wsh_pr_picking_session.include_planned_lines);
569:
570: -- Execute the cursor

Line 568: wsh_pr_picking_session.include_planned_lines);

564: wsh_pr_picking_session.delivery_id);
565: END IF;
566: WSH_UTIL.Write_Log('X_include_planned_lines = ' || wsh_pr_picking_session.include_planned_lines);
567: DBMS_SQL.Bind_Variable(u_cursor, ':X_include_planned_lines',
568: wsh_pr_picking_session.include_planned_lines);
569:
570: -- Execute the cursor
571: WSH_UTIL.Write_Log('Executing unreleased cursor');
572: v_ignore := DBMS_SQL.Execute(u_cursor);

Line 627: IF (wsh_pr_picking_session.header_id <> 0) THEN

623:
624: -- Bind release criteria values
625: WSH_UTIL.Write_Log('Binding backordered cursor');
626:
627: IF (wsh_pr_picking_session.header_id <> 0) THEN
628: WSH_UTIL.Write_Log('X_header_id = ' || to_char(wsh_pr_picking_session.header_id));
629: DBMS_SQL.Bind_Variable(b_cursor, ':X_header_id',
630: wsh_pr_picking_session.header_id);
631: END IF;

Line 628: WSH_UTIL.Write_Log('X_header_id = ' || to_char(wsh_pr_picking_session.header_id));

624: -- Bind release criteria values
625: WSH_UTIL.Write_Log('Binding backordered cursor');
626:
627: IF (wsh_pr_picking_session.header_id <> 0) THEN
628: WSH_UTIL.Write_Log('X_header_id = ' || to_char(wsh_pr_picking_session.header_id));
629: DBMS_SQL.Bind_Variable(b_cursor, ':X_header_id',
630: wsh_pr_picking_session.header_id);
631: END IF;
632: WSH_UTIL.Write_Log('X_order_type_id = ' || to_char(wsh_pr_picking_session.order_type_id));

Line 630: wsh_pr_picking_session.header_id);

626:
627: IF (wsh_pr_picking_session.header_id <> 0) THEN
628: WSH_UTIL.Write_Log('X_header_id = ' || to_char(wsh_pr_picking_session.header_id));
629: DBMS_SQL.Bind_Variable(b_cursor, ':X_header_id',
630: wsh_pr_picking_session.header_id);
631: END IF;
632: WSH_UTIL.Write_Log('X_order_type_id = ' || to_char(wsh_pr_picking_session.order_type_id));
633: DBMS_SQL.Bind_Variable(b_cursor, ':X_order_type_id',
634: wsh_pr_picking_session.order_type_id);

Line 632: WSH_UTIL.Write_Log('X_order_type_id = ' || to_char(wsh_pr_picking_session.order_type_id));

628: WSH_UTIL.Write_Log('X_header_id = ' || to_char(wsh_pr_picking_session.header_id));
629: DBMS_SQL.Bind_Variable(b_cursor, ':X_header_id',
630: wsh_pr_picking_session.header_id);
631: END IF;
632: WSH_UTIL.Write_Log('X_order_type_id = ' || to_char(wsh_pr_picking_session.order_type_id));
633: DBMS_SQL.Bind_Variable(b_cursor, ':X_order_type_id',
634: wsh_pr_picking_session.order_type_id);
635: IF (wsh_pr_picking_session.customer_id <> 0) THEN
636: WSH_UTIL.Write_Log('X_customer_id = ' || to_char(wsh_pr_picking_session.customer_id));

Line 634: wsh_pr_picking_session.order_type_id);

630: wsh_pr_picking_session.header_id);
631: END IF;
632: WSH_UTIL.Write_Log('X_order_type_id = ' || to_char(wsh_pr_picking_session.order_type_id));
633: DBMS_SQL.Bind_Variable(b_cursor, ':X_order_type_id',
634: wsh_pr_picking_session.order_type_id);
635: IF (wsh_pr_picking_session.customer_id <> 0) THEN
636: WSH_UTIL.Write_Log('X_customer_id = ' || to_char(wsh_pr_picking_session.customer_id));
637: DBMS_SQL.Bind_Variable(b_cursor, ':X_customer_id',
638: wsh_pr_picking_session.customer_id);

Line 635: IF (wsh_pr_picking_session.customer_id <> 0) THEN

631: END IF;
632: WSH_UTIL.Write_Log('X_order_type_id = ' || to_char(wsh_pr_picking_session.order_type_id));
633: DBMS_SQL.Bind_Variable(b_cursor, ':X_order_type_id',
634: wsh_pr_picking_session.order_type_id);
635: IF (wsh_pr_picking_session.customer_id <> 0) THEN
636: WSH_UTIL.Write_Log('X_customer_id = ' || to_char(wsh_pr_picking_session.customer_id));
637: DBMS_SQL.Bind_Variable(b_cursor, ':X_customer_id',
638: wsh_pr_picking_session.customer_id);
639: END IF;

Line 636: WSH_UTIL.Write_Log('X_customer_id = ' || to_char(wsh_pr_picking_session.customer_id));

632: WSH_UTIL.Write_Log('X_order_type_id = ' || to_char(wsh_pr_picking_session.order_type_id));
633: DBMS_SQL.Bind_Variable(b_cursor, ':X_order_type_id',
634: wsh_pr_picking_session.order_type_id);
635: IF (wsh_pr_picking_session.customer_id <> 0) THEN
636: WSH_UTIL.Write_Log('X_customer_id = ' || to_char(wsh_pr_picking_session.customer_id));
637: DBMS_SQL.Bind_Variable(b_cursor, ':X_customer_id',
638: wsh_pr_picking_session.customer_id);
639: END IF;
640:

Line 638: wsh_pr_picking_session.customer_id);

634: wsh_pr_picking_session.order_type_id);
635: IF (wsh_pr_picking_session.customer_id <> 0) THEN
636: WSH_UTIL.Write_Log('X_customer_id = ' || to_char(wsh_pr_picking_session.customer_id));
637: DBMS_SQL.Bind_Variable(b_cursor, ':X_customer_id',
638: wsh_pr_picking_session.customer_id);
639: END IF;
640:
641: IF (wsh_pr_picking_session.order_line_id <> 0) THEN
642: WSH_UTIL.Write_Log('X_order_line_id = ' || to_char(wsh_pr_picking_session.order_line_id));

Line 641: IF (wsh_pr_picking_session.order_line_id <> 0) THEN

637: DBMS_SQL.Bind_Variable(b_cursor, ':X_customer_id',
638: wsh_pr_picking_session.customer_id);
639: END IF;
640:
641: IF (wsh_pr_picking_session.order_line_id <> 0) THEN
642: WSH_UTIL.Write_Log('X_order_line_id = ' || to_char(wsh_pr_picking_session.order_line_id));
643: DBMS_SQL.Bind_Variable(b_cursor, ':X_order_line_id',
644: wsh_pr_picking_session.order_line_id);
645: END IF;

Line 642: WSH_UTIL.Write_Log('X_order_line_id = ' || to_char(wsh_pr_picking_session.order_line_id));

638: wsh_pr_picking_session.customer_id);
639: END IF;
640:
641: IF (wsh_pr_picking_session.order_line_id <> 0) THEN
642: WSH_UTIL.Write_Log('X_order_line_id = ' || to_char(wsh_pr_picking_session.order_line_id));
643: DBMS_SQL.Bind_Variable(b_cursor, ':X_order_line_id',
644: wsh_pr_picking_session.order_line_id);
645: END IF;
646:

Line 644: wsh_pr_picking_session.order_line_id);

640:
641: IF (wsh_pr_picking_session.order_line_id <> 0) THEN
642: WSH_UTIL.Write_Log('X_order_line_id = ' || to_char(wsh_pr_picking_session.order_line_id));
643: DBMS_SQL.Bind_Variable(b_cursor, ':X_order_line_id',
644: wsh_pr_picking_session.order_line_id);
645: END IF;
646:
647: WSH_UTIL.Write_Log('X_ship_set_number = ' || to_char(wsh_pr_picking_session.ship_set_number));
648: DBMS_SQL.Bind_Variable(b_cursor, ':X_ship_set_number',

Line 647: WSH_UTIL.Write_Log('X_ship_set_number = ' || to_char(wsh_pr_picking_session.ship_set_number));

643: DBMS_SQL.Bind_Variable(b_cursor, ':X_order_line_id',
644: wsh_pr_picking_session.order_line_id);
645: END IF;
646:
647: WSH_UTIL.Write_Log('X_ship_set_number = ' || to_char(wsh_pr_picking_session.ship_set_number));
648: DBMS_SQL.Bind_Variable(b_cursor, ':X_ship_set_number',
649: wsh_pr_picking_session.ship_set_number);
650: WSH_UTIL.Write_Log('X_ship_site_use_id = ' || to_char(wsh_pr_picking_session.ship_site_use_id));
651: DBMS_SQL.Bind_Variable(b_cursor, ':X_ship_site_use_id',

Line 649: wsh_pr_picking_session.ship_set_number);

645: END IF;
646:
647: WSH_UTIL.Write_Log('X_ship_set_number = ' || to_char(wsh_pr_picking_session.ship_set_number));
648: DBMS_SQL.Bind_Variable(b_cursor, ':X_ship_set_number',
649: wsh_pr_picking_session.ship_set_number);
650: WSH_UTIL.Write_Log('X_ship_site_use_id = ' || to_char(wsh_pr_picking_session.ship_site_use_id));
651: DBMS_SQL.Bind_Variable(b_cursor, ':X_ship_site_use_id',
652: wsh_pr_picking_session.ship_site_use_id);
653: WSH_UTIL.Write_Log('X_ship_method_code = ' || wsh_pr_picking_session.ship_method_code);

Line 650: WSH_UTIL.Write_Log('X_ship_site_use_id = ' || to_char(wsh_pr_picking_session.ship_site_use_id));

646:
647: WSH_UTIL.Write_Log('X_ship_set_number = ' || to_char(wsh_pr_picking_session.ship_set_number));
648: DBMS_SQL.Bind_Variable(b_cursor, ':X_ship_set_number',
649: wsh_pr_picking_session.ship_set_number);
650: WSH_UTIL.Write_Log('X_ship_site_use_id = ' || to_char(wsh_pr_picking_session.ship_site_use_id));
651: DBMS_SQL.Bind_Variable(b_cursor, ':X_ship_site_use_id',
652: wsh_pr_picking_session.ship_site_use_id);
653: WSH_UTIL.Write_Log('X_ship_method_code = ' || wsh_pr_picking_session.ship_method_code);
654: DBMS_SQL.Bind_Variable(b_cursor, ':X_ship_method_code',

Line 652: wsh_pr_picking_session.ship_site_use_id);

648: DBMS_SQL.Bind_Variable(b_cursor, ':X_ship_set_number',
649: wsh_pr_picking_session.ship_set_number);
650: WSH_UTIL.Write_Log('X_ship_site_use_id = ' || to_char(wsh_pr_picking_session.ship_site_use_id));
651: DBMS_SQL.Bind_Variable(b_cursor, ':X_ship_site_use_id',
652: wsh_pr_picking_session.ship_site_use_id);
653: WSH_UTIL.Write_Log('X_ship_method_code = ' || wsh_pr_picking_session.ship_method_code);
654: DBMS_SQL.Bind_Variable(b_cursor, ':X_ship_method_code',
655: wsh_pr_picking_session.ship_method_code);
656: WSH_UTIL.Write_Log('X_warehouse_id = ' || to_char(wsh_pr_picking_session.warehouse_id));

Line 653: WSH_UTIL.Write_Log('X_ship_method_code = ' || wsh_pr_picking_session.ship_method_code);

649: wsh_pr_picking_session.ship_set_number);
650: WSH_UTIL.Write_Log('X_ship_site_use_id = ' || to_char(wsh_pr_picking_session.ship_site_use_id));
651: DBMS_SQL.Bind_Variable(b_cursor, ':X_ship_site_use_id',
652: wsh_pr_picking_session.ship_site_use_id);
653: WSH_UTIL.Write_Log('X_ship_method_code = ' || wsh_pr_picking_session.ship_method_code);
654: DBMS_SQL.Bind_Variable(b_cursor, ':X_ship_method_code',
655: wsh_pr_picking_session.ship_method_code);
656: WSH_UTIL.Write_Log('X_warehouse_id = ' || to_char(wsh_pr_picking_session.warehouse_id));
657: DBMS_SQL.Bind_Variable(b_cursor, ':X_warehouse_id',

Line 655: wsh_pr_picking_session.ship_method_code);

651: DBMS_SQL.Bind_Variable(b_cursor, ':X_ship_site_use_id',
652: wsh_pr_picking_session.ship_site_use_id);
653: WSH_UTIL.Write_Log('X_ship_method_code = ' || wsh_pr_picking_session.ship_method_code);
654: DBMS_SQL.Bind_Variable(b_cursor, ':X_ship_method_code',
655: wsh_pr_picking_session.ship_method_code);
656: WSH_UTIL.Write_Log('X_warehouse_id = ' || to_char(wsh_pr_picking_session.warehouse_id));
657: DBMS_SQL.Bind_Variable(b_cursor, ':X_warehouse_id',
658: wsh_pr_picking_session.warehouse_id);
659: WSH_UTIL.Write_Log('X_subinventory = ' || wsh_pr_picking_session.subinventory);

Line 656: WSH_UTIL.Write_Log('X_warehouse_id = ' || to_char(wsh_pr_picking_session.warehouse_id));

652: wsh_pr_picking_session.ship_site_use_id);
653: WSH_UTIL.Write_Log('X_ship_method_code = ' || wsh_pr_picking_session.ship_method_code);
654: DBMS_SQL.Bind_Variable(b_cursor, ':X_ship_method_code',
655: wsh_pr_picking_session.ship_method_code);
656: WSH_UTIL.Write_Log('X_warehouse_id = ' || to_char(wsh_pr_picking_session.warehouse_id));
657: DBMS_SQL.Bind_Variable(b_cursor, ':X_warehouse_id',
658: wsh_pr_picking_session.warehouse_id);
659: WSH_UTIL.Write_Log('X_subinventory = ' || wsh_pr_picking_session.subinventory);
660: DBMS_SQL.Bind_Variable(b_cursor, ':X_subinventory',

Line 658: wsh_pr_picking_session.warehouse_id);

654: DBMS_SQL.Bind_Variable(b_cursor, ':X_ship_method_code',
655: wsh_pr_picking_session.ship_method_code);
656: WSH_UTIL.Write_Log('X_warehouse_id = ' || to_char(wsh_pr_picking_session.warehouse_id));
657: DBMS_SQL.Bind_Variable(b_cursor, ':X_warehouse_id',
658: wsh_pr_picking_session.warehouse_id);
659: WSH_UTIL.Write_Log('X_subinventory = ' || wsh_pr_picking_session.subinventory);
660: DBMS_SQL.Bind_Variable(b_cursor, ':X_subinventory',
661: wsh_pr_picking_session.subinventory);
662: WSH_UTIL.Write_Log('X_shipment_priority = ' || wsh_pr_picking_session.shipment_priority);

Line 659: WSH_UTIL.Write_Log('X_subinventory = ' || wsh_pr_picking_session.subinventory);

655: wsh_pr_picking_session.ship_method_code);
656: WSH_UTIL.Write_Log('X_warehouse_id = ' || to_char(wsh_pr_picking_session.warehouse_id));
657: DBMS_SQL.Bind_Variable(b_cursor, ':X_warehouse_id',
658: wsh_pr_picking_session.warehouse_id);
659: WSH_UTIL.Write_Log('X_subinventory = ' || wsh_pr_picking_session.subinventory);
660: DBMS_SQL.Bind_Variable(b_cursor, ':X_subinventory',
661: wsh_pr_picking_session.subinventory);
662: WSH_UTIL.Write_Log('X_shipment_priority = ' || wsh_pr_picking_session.shipment_priority);
663: DBMS_SQL.Bind_Variable(b_cursor, ':X_shipment_priority',

Line 661: wsh_pr_picking_session.subinventory);

657: DBMS_SQL.Bind_Variable(b_cursor, ':X_warehouse_id',
658: wsh_pr_picking_session.warehouse_id);
659: WSH_UTIL.Write_Log('X_subinventory = ' || wsh_pr_picking_session.subinventory);
660: DBMS_SQL.Bind_Variable(b_cursor, ':X_subinventory',
661: wsh_pr_picking_session.subinventory);
662: WSH_UTIL.Write_Log('X_shipment_priority = ' || wsh_pr_picking_session.shipment_priority);
663: DBMS_SQL.Bind_Variable(b_cursor, ':X_shipment_priority',
664: wsh_pr_picking_session.shipment_priority);
665: WSH_UTIL.Write_Log('X_from_request_date = ' || to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));

Line 662: WSH_UTIL.Write_Log('X_shipment_priority = ' || wsh_pr_picking_session.shipment_priority);

658: wsh_pr_picking_session.warehouse_id);
659: WSH_UTIL.Write_Log('X_subinventory = ' || wsh_pr_picking_session.subinventory);
660: DBMS_SQL.Bind_Variable(b_cursor, ':X_subinventory',
661: wsh_pr_picking_session.subinventory);
662: WSH_UTIL.Write_Log('X_shipment_priority = ' || wsh_pr_picking_session.shipment_priority);
663: DBMS_SQL.Bind_Variable(b_cursor, ':X_shipment_priority',
664: wsh_pr_picking_session.shipment_priority);
665: WSH_UTIL.Write_Log('X_from_request_date = ' || to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
666: DBMS_SQL.Bind_Variable(b_cursor, ':X_from_request_date',

Line 664: wsh_pr_picking_session.shipment_priority);

660: DBMS_SQL.Bind_Variable(b_cursor, ':X_subinventory',
661: wsh_pr_picking_session.subinventory);
662: WSH_UTIL.Write_Log('X_shipment_priority = ' || wsh_pr_picking_session.shipment_priority);
663: DBMS_SQL.Bind_Variable(b_cursor, ':X_shipment_priority',
664: wsh_pr_picking_session.shipment_priority);
665: WSH_UTIL.Write_Log('X_from_request_date = ' || to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
666: DBMS_SQL.Bind_Variable(b_cursor, ':X_from_request_date',
667: to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
668: WSH_UTIL.Write_Log('X_to_request_date = ' || to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));

Line 665: WSH_UTIL.Write_Log('X_from_request_date = ' || to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));

661: wsh_pr_picking_session.subinventory);
662: WSH_UTIL.Write_Log('X_shipment_priority = ' || wsh_pr_picking_session.shipment_priority);
663: DBMS_SQL.Bind_Variable(b_cursor, ':X_shipment_priority',
664: wsh_pr_picking_session.shipment_priority);
665: WSH_UTIL.Write_Log('X_from_request_date = ' || to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
666: DBMS_SQL.Bind_Variable(b_cursor, ':X_from_request_date',
667: to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
668: WSH_UTIL.Write_Log('X_to_request_date = ' || to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
669: DBMS_SQL.Bind_Variable(b_cursor, ':X_to_request_date',

Line 667: to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));

663: DBMS_SQL.Bind_Variable(b_cursor, ':X_shipment_priority',
664: wsh_pr_picking_session.shipment_priority);
665: WSH_UTIL.Write_Log('X_from_request_date = ' || to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
666: DBMS_SQL.Bind_Variable(b_cursor, ':X_from_request_date',
667: to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
668: WSH_UTIL.Write_Log('X_to_request_date = ' || to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
669: DBMS_SQL.Bind_Variable(b_cursor, ':X_to_request_date',
670: to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
671: WSH_UTIL.Write_Log('X_from_sched_ship_date = ' || to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));

Line 668: WSH_UTIL.Write_Log('X_to_request_date = ' || to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));

664: wsh_pr_picking_session.shipment_priority);
665: WSH_UTIL.Write_Log('X_from_request_date = ' || to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
666: DBMS_SQL.Bind_Variable(b_cursor, ':X_from_request_date',
667: to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
668: WSH_UTIL.Write_Log('X_to_request_date = ' || to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
669: DBMS_SQL.Bind_Variable(b_cursor, ':X_to_request_date',
670: to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
671: WSH_UTIL.Write_Log('X_from_sched_ship_date = ' || to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
672: DBMS_SQL.Bind_Variable(b_cursor, ':X_from_sched_ship_date',

Line 670: to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));

666: DBMS_SQL.Bind_Variable(b_cursor, ':X_from_request_date',
667: to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
668: WSH_UTIL.Write_Log('X_to_request_date = ' || to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
669: DBMS_SQL.Bind_Variable(b_cursor, ':X_to_request_date',
670: to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
671: WSH_UTIL.Write_Log('X_from_sched_ship_date = ' || to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
672: DBMS_SQL.Bind_Variable(b_cursor, ':X_from_sched_ship_date',
673: to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
674: WSH_UTIL.Write_Log('X_to_sched_ship_date = ' || to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));

Line 671: WSH_UTIL.Write_Log('X_from_sched_ship_date = ' || to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));

667: to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
668: WSH_UTIL.Write_Log('X_to_request_date = ' || to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
669: DBMS_SQL.Bind_Variable(b_cursor, ':X_to_request_date',
670: to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
671: WSH_UTIL.Write_Log('X_from_sched_ship_date = ' || to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
672: DBMS_SQL.Bind_Variable(b_cursor, ':X_from_sched_ship_date',
673: to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
674: WSH_UTIL.Write_Log('X_to_sched_ship_date = ' || to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
675: DBMS_SQL.Bind_Variable(b_cursor, ':X_to_sched_ship_date',

Line 673: to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));

669: DBMS_SQL.Bind_Variable(b_cursor, ':X_to_request_date',
670: to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
671: WSH_UTIL.Write_Log('X_from_sched_ship_date = ' || to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
672: DBMS_SQL.Bind_Variable(b_cursor, ':X_from_sched_ship_date',
673: to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
674: WSH_UTIL.Write_Log('X_to_sched_ship_date = ' || to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
675: DBMS_SQL.Bind_Variable(b_cursor, ':X_to_sched_ship_date',
676: to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
677: WSH_UTIL.Write_Log('X_existing_rsvs_only_flag = ' || wsh_pr_picking_session.existing_rsvs_only_flag);

Line 674: WSH_UTIL.Write_Log('X_to_sched_ship_date = ' || to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));

670: to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
671: WSH_UTIL.Write_Log('X_from_sched_ship_date = ' || to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
672: DBMS_SQL.Bind_Variable(b_cursor, ':X_from_sched_ship_date',
673: to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
674: WSH_UTIL.Write_Log('X_to_sched_ship_date = ' || to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
675: DBMS_SQL.Bind_Variable(b_cursor, ':X_to_sched_ship_date',
676: to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
677: WSH_UTIL.Write_Log('X_existing_rsvs_only_flag = ' || wsh_pr_picking_session.existing_rsvs_only_flag);
678: DBMS_SQL.Bind_Variable(b_cursor, ':X_existing_rsvs_only_flag',

Line 676: to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));

672: DBMS_SQL.Bind_Variable(b_cursor, ':X_from_sched_ship_date',
673: to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
674: WSH_UTIL.Write_Log('X_to_sched_ship_date = ' || to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
675: DBMS_SQL.Bind_Variable(b_cursor, ':X_to_sched_ship_date',
676: to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
677: WSH_UTIL.Write_Log('X_existing_rsvs_only_flag = ' || wsh_pr_picking_session.existing_rsvs_only_flag);
678: DBMS_SQL.Bind_Variable(b_cursor, ':X_existing_rsvs_only_flag',
679: wsh_pr_picking_session.existing_rsvs_only_flag);
680: WSH_UTIL.Write_Log('X_inventory_item_id = ' || to_char(wsh_pr_picking_session.inventory_item_id));

Line 677: WSH_UTIL.Write_Log('X_existing_rsvs_only_flag = ' || wsh_pr_picking_session.existing_rsvs_only_flag);

673: to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
674: WSH_UTIL.Write_Log('X_to_sched_ship_date = ' || to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
675: DBMS_SQL.Bind_Variable(b_cursor, ':X_to_sched_ship_date',
676: to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
677: WSH_UTIL.Write_Log('X_existing_rsvs_only_flag = ' || wsh_pr_picking_session.existing_rsvs_only_flag);
678: DBMS_SQL.Bind_Variable(b_cursor, ':X_existing_rsvs_only_flag',
679: wsh_pr_picking_session.existing_rsvs_only_flag);
680: WSH_UTIL.Write_Log('X_inventory_item_id = ' || to_char(wsh_pr_picking_session.inventory_item_id));
681: DBMS_SQL.Bind_Variable(b_cursor, ':X_inventory_item_id',

Line 679: wsh_pr_picking_session.existing_rsvs_only_flag);

675: DBMS_SQL.Bind_Variable(b_cursor, ':X_to_sched_ship_date',
676: to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
677: WSH_UTIL.Write_Log('X_existing_rsvs_only_flag = ' || wsh_pr_picking_session.existing_rsvs_only_flag);
678: DBMS_SQL.Bind_Variable(b_cursor, ':X_existing_rsvs_only_flag',
679: wsh_pr_picking_session.existing_rsvs_only_flag);
680: WSH_UTIL.Write_Log('X_inventory_item_id = ' || to_char(wsh_pr_picking_session.inventory_item_id));
681: DBMS_SQL.Bind_Variable(b_cursor, ':X_inventory_item_id',
682: wsh_pr_picking_session.inventory_item_id);
683: WSH_UTIL.Write_Log('X_reservations = ' || wsh_pr_picking_session.reservations);

Line 680: WSH_UTIL.Write_Log('X_inventory_item_id = ' || to_char(wsh_pr_picking_session.inventory_item_id));

676: to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
677: WSH_UTIL.Write_Log('X_existing_rsvs_only_flag = ' || wsh_pr_picking_session.existing_rsvs_only_flag);
678: DBMS_SQL.Bind_Variable(b_cursor, ':X_existing_rsvs_only_flag',
679: wsh_pr_picking_session.existing_rsvs_only_flag);
680: WSH_UTIL.Write_Log('X_inventory_item_id = ' || to_char(wsh_pr_picking_session.inventory_item_id));
681: DBMS_SQL.Bind_Variable(b_cursor, ':X_inventory_item_id',
682: wsh_pr_picking_session.inventory_item_id);
683: WSH_UTIL.Write_Log('X_reservations = ' || wsh_pr_picking_session.reservations);
684: DBMS_SQL.Bind_Variable(b_cursor, ':X_reservations',

Line 682: wsh_pr_picking_session.inventory_item_id);

678: DBMS_SQL.Bind_Variable(b_cursor, ':X_existing_rsvs_only_flag',
679: wsh_pr_picking_session.existing_rsvs_only_flag);
680: WSH_UTIL.Write_Log('X_inventory_item_id = ' || to_char(wsh_pr_picking_session.inventory_item_id));
681: DBMS_SQL.Bind_Variable(b_cursor, ':X_inventory_item_id',
682: wsh_pr_picking_session.inventory_item_id);
683: WSH_UTIL.Write_Log('X_reservations = ' || wsh_pr_picking_session.reservations);
684: DBMS_SQL.Bind_Variable(b_cursor, ':X_reservations',
685: wsh_pr_picking_session.reservations);
686: WSH_UTIL.Write_Log('X_departure_id = ' || to_char(wsh_pr_picking_session.departure_id));

Line 683: WSH_UTIL.Write_Log('X_reservations = ' || wsh_pr_picking_session.reservations);

679: wsh_pr_picking_session.existing_rsvs_only_flag);
680: WSH_UTIL.Write_Log('X_inventory_item_id = ' || to_char(wsh_pr_picking_session.inventory_item_id));
681: DBMS_SQL.Bind_Variable(b_cursor, ':X_inventory_item_id',
682: wsh_pr_picking_session.inventory_item_id);
683: WSH_UTIL.Write_Log('X_reservations = ' || wsh_pr_picking_session.reservations);
684: DBMS_SQL.Bind_Variable(b_cursor, ':X_reservations',
685: wsh_pr_picking_session.reservations);
686: WSH_UTIL.Write_Log('X_departure_id = ' || to_char(wsh_pr_picking_session.departure_id));
687: DBMS_SQL.Bind_Variable(b_cursor, ':X_departure_id',

Line 685: wsh_pr_picking_session.reservations);

681: DBMS_SQL.Bind_Variable(b_cursor, ':X_inventory_item_id',
682: wsh_pr_picking_session.inventory_item_id);
683: WSH_UTIL.Write_Log('X_reservations = ' || wsh_pr_picking_session.reservations);
684: DBMS_SQL.Bind_Variable(b_cursor, ':X_reservations',
685: wsh_pr_picking_session.reservations);
686: WSH_UTIL.Write_Log('X_departure_id = ' || to_char(wsh_pr_picking_session.departure_id));
687: DBMS_SQL.Bind_Variable(b_cursor, ':X_departure_id',
688: wsh_pr_picking_session.departure_id);
689: IF (wsh_pr_picking_session.delivery_id <> 0) THEN

Line 686: WSH_UTIL.Write_Log('X_departure_id = ' || to_char(wsh_pr_picking_session.departure_id));

682: wsh_pr_picking_session.inventory_item_id);
683: WSH_UTIL.Write_Log('X_reservations = ' || wsh_pr_picking_session.reservations);
684: DBMS_SQL.Bind_Variable(b_cursor, ':X_reservations',
685: wsh_pr_picking_session.reservations);
686: WSH_UTIL.Write_Log('X_departure_id = ' || to_char(wsh_pr_picking_session.departure_id));
687: DBMS_SQL.Bind_Variable(b_cursor, ':X_departure_id',
688: wsh_pr_picking_session.departure_id);
689: IF (wsh_pr_picking_session.delivery_id <> 0) THEN
690: WSH_UTIL.Write_Log('X_delivery_id = ' || to_char(wsh_pr_picking_session.delivery_id));

Line 688: wsh_pr_picking_session.departure_id);

684: DBMS_SQL.Bind_Variable(b_cursor, ':X_reservations',
685: wsh_pr_picking_session.reservations);
686: WSH_UTIL.Write_Log('X_departure_id = ' || to_char(wsh_pr_picking_session.departure_id));
687: DBMS_SQL.Bind_Variable(b_cursor, ':X_departure_id',
688: wsh_pr_picking_session.departure_id);
689: IF (wsh_pr_picking_session.delivery_id <> 0) THEN
690: WSH_UTIL.Write_Log('X_delivery_id = ' || to_char(wsh_pr_picking_session.delivery_id));
691: DBMS_SQL.Bind_Variable(b_cursor, ':X_delivery_id',
692: wsh_pr_picking_session.delivery_id);

Line 689: IF (wsh_pr_picking_session.delivery_id <> 0) THEN

685: wsh_pr_picking_session.reservations);
686: WSH_UTIL.Write_Log('X_departure_id = ' || to_char(wsh_pr_picking_session.departure_id));
687: DBMS_SQL.Bind_Variable(b_cursor, ':X_departure_id',
688: wsh_pr_picking_session.departure_id);
689: IF (wsh_pr_picking_session.delivery_id <> 0) THEN
690: WSH_UTIL.Write_Log('X_delivery_id = ' || to_char(wsh_pr_picking_session.delivery_id));
691: DBMS_SQL.Bind_Variable(b_cursor, ':X_delivery_id',
692: wsh_pr_picking_session.delivery_id);
693: END IF;

Line 690: WSH_UTIL.Write_Log('X_delivery_id = ' || to_char(wsh_pr_picking_session.delivery_id));

686: WSH_UTIL.Write_Log('X_departure_id = ' || to_char(wsh_pr_picking_session.departure_id));
687: DBMS_SQL.Bind_Variable(b_cursor, ':X_departure_id',
688: wsh_pr_picking_session.departure_id);
689: IF (wsh_pr_picking_session.delivery_id <> 0) THEN
690: WSH_UTIL.Write_Log('X_delivery_id = ' || to_char(wsh_pr_picking_session.delivery_id));
691: DBMS_SQL.Bind_Variable(b_cursor, ':X_delivery_id',
692: wsh_pr_picking_session.delivery_id);
693: END IF;
694: WSH_UTIL.Write_Log('X_include_planned_lines = ' || wsh_pr_picking_session.include_planned_lines);

Line 692: wsh_pr_picking_session.delivery_id);

688: wsh_pr_picking_session.departure_id);
689: IF (wsh_pr_picking_session.delivery_id <> 0) THEN
690: WSH_UTIL.Write_Log('X_delivery_id = ' || to_char(wsh_pr_picking_session.delivery_id));
691: DBMS_SQL.Bind_Variable(b_cursor, ':X_delivery_id',
692: wsh_pr_picking_session.delivery_id);
693: END IF;
694: WSH_UTIL.Write_Log('X_include_planned_lines = ' || wsh_pr_picking_session.include_planned_lines);
695: DBMS_SQL.Bind_Variable(b_cursor, ':X_include_planned_lines',
696: wsh_pr_picking_session.include_planned_lines);

Line 694: WSH_UTIL.Write_Log('X_include_planned_lines = ' || wsh_pr_picking_session.include_planned_lines);

690: WSH_UTIL.Write_Log('X_delivery_id = ' || to_char(wsh_pr_picking_session.delivery_id));
691: DBMS_SQL.Bind_Variable(b_cursor, ':X_delivery_id',
692: wsh_pr_picking_session.delivery_id);
693: END IF;
694: WSH_UTIL.Write_Log('X_include_planned_lines = ' || wsh_pr_picking_session.include_planned_lines);
695: DBMS_SQL.Bind_Variable(b_cursor, ':X_include_planned_lines',
696: wsh_pr_picking_session.include_planned_lines);
697:
698: -- Execute the cursor

Line 696: wsh_pr_picking_session.include_planned_lines);

692: wsh_pr_picking_session.delivery_id);
693: END IF;
694: WSH_UTIL.Write_Log('X_include_planned_lines = ' || wsh_pr_picking_session.include_planned_lines);
695: DBMS_SQL.Bind_Variable(b_cursor, ':X_include_planned_lines',
696: wsh_pr_picking_session.include_planned_lines);
697:
698: -- Execute the cursor
699: WSH_UTIL.Write_Log('Executing backordered cursor');
700: v_ignore := DBMS_SQL.Execute(b_cursor);

Line 743: WSH_UTIL.Write_Log('X_p_param_1 = ' || to_char(wsh_pr_picking_session.sync_line_id));

739:
740: -- Bind release criteria values
741: WSH_UTIL.Write_Log('Binding sync cursor');
742:
743: WSH_UTIL.Write_Log('X_p_param_1 = ' || to_char(wsh_pr_picking_session.sync_line_id));
744: DBMS_SQL.Bind_Variable(s_cursor, ':X_p_param_1',
745: wsh_pr_picking_session.sync_line_id);
746: WSH_UTIL.Write_Log('X_warehouse_id = ' || to_char(wsh_pr_picking_session.warehouse_id));
747: DBMS_SQL.Bind_Variable(s_cursor, ':X_warehouse_id',

Line 745: wsh_pr_picking_session.sync_line_id);

741: WSH_UTIL.Write_Log('Binding sync cursor');
742:
743: WSH_UTIL.Write_Log('X_p_param_1 = ' || to_char(wsh_pr_picking_session.sync_line_id));
744: DBMS_SQL.Bind_Variable(s_cursor, ':X_p_param_1',
745: wsh_pr_picking_session.sync_line_id);
746: WSH_UTIL.Write_Log('X_warehouse_id = ' || to_char(wsh_pr_picking_session.warehouse_id));
747: DBMS_SQL.Bind_Variable(s_cursor, ':X_warehouse_id',
748: wsh_pr_picking_session.warehouse_id);
749: WSH_UTIL.Write_Log('X_subinventory = ' || wsh_pr_picking_session.subinventory);

Line 746: WSH_UTIL.Write_Log('X_warehouse_id = ' || to_char(wsh_pr_picking_session.warehouse_id));

742:
743: WSH_UTIL.Write_Log('X_p_param_1 = ' || to_char(wsh_pr_picking_session.sync_line_id));
744: DBMS_SQL.Bind_Variable(s_cursor, ':X_p_param_1',
745: wsh_pr_picking_session.sync_line_id);
746: WSH_UTIL.Write_Log('X_warehouse_id = ' || to_char(wsh_pr_picking_session.warehouse_id));
747: DBMS_SQL.Bind_Variable(s_cursor, ':X_warehouse_id',
748: wsh_pr_picking_session.warehouse_id);
749: WSH_UTIL.Write_Log('X_subinventory = ' || wsh_pr_picking_session.subinventory);
750: DBMS_SQL.Bind_Variable(s_cursor, ':X_subinventory',

Line 748: wsh_pr_picking_session.warehouse_id);

744: DBMS_SQL.Bind_Variable(s_cursor, ':X_p_param_1',
745: wsh_pr_picking_session.sync_line_id);
746: WSH_UTIL.Write_Log('X_warehouse_id = ' || to_char(wsh_pr_picking_session.warehouse_id));
747: DBMS_SQL.Bind_Variable(s_cursor, ':X_warehouse_id',
748: wsh_pr_picking_session.warehouse_id);
749: WSH_UTIL.Write_Log('X_subinventory = ' || wsh_pr_picking_session.subinventory);
750: DBMS_SQL.Bind_Variable(s_cursor, ':X_subinventory',
751: wsh_pr_picking_session.subinventory);
752: WSH_UTIL.Write_Log('X_from_request_date = ' || to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));

Line 749: WSH_UTIL.Write_Log('X_subinventory = ' || wsh_pr_picking_session.subinventory);

745: wsh_pr_picking_session.sync_line_id);
746: WSH_UTIL.Write_Log('X_warehouse_id = ' || to_char(wsh_pr_picking_session.warehouse_id));
747: DBMS_SQL.Bind_Variable(s_cursor, ':X_warehouse_id',
748: wsh_pr_picking_session.warehouse_id);
749: WSH_UTIL.Write_Log('X_subinventory = ' || wsh_pr_picking_session.subinventory);
750: DBMS_SQL.Bind_Variable(s_cursor, ':X_subinventory',
751: wsh_pr_picking_session.subinventory);
752: WSH_UTIL.Write_Log('X_from_request_date = ' || to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
753: DBMS_SQL.Bind_Variable(s_cursor, ':X_from_request_date',

Line 751: wsh_pr_picking_session.subinventory);

747: DBMS_SQL.Bind_Variable(s_cursor, ':X_warehouse_id',
748: wsh_pr_picking_session.warehouse_id);
749: WSH_UTIL.Write_Log('X_subinventory = ' || wsh_pr_picking_session.subinventory);
750: DBMS_SQL.Bind_Variable(s_cursor, ':X_subinventory',
751: wsh_pr_picking_session.subinventory);
752: WSH_UTIL.Write_Log('X_from_request_date = ' || to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
753: DBMS_SQL.Bind_Variable(s_cursor, ':X_from_request_date',
754: to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
755: WSH_UTIL.Write_Log('X_to_request_date = ' || to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));

Line 752: WSH_UTIL.Write_Log('X_from_request_date = ' || to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));

748: wsh_pr_picking_session.warehouse_id);
749: WSH_UTIL.Write_Log('X_subinventory = ' || wsh_pr_picking_session.subinventory);
750: DBMS_SQL.Bind_Variable(s_cursor, ':X_subinventory',
751: wsh_pr_picking_session.subinventory);
752: WSH_UTIL.Write_Log('X_from_request_date = ' || to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
753: DBMS_SQL.Bind_Variable(s_cursor, ':X_from_request_date',
754: to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
755: WSH_UTIL.Write_Log('X_to_request_date = ' || to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
756: DBMS_SQL.Bind_Variable(s_cursor, ':X_to_request_date',

Line 754: to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));

750: DBMS_SQL.Bind_Variable(s_cursor, ':X_subinventory',
751: wsh_pr_picking_session.subinventory);
752: WSH_UTIL.Write_Log('X_from_request_date = ' || to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
753: DBMS_SQL.Bind_Variable(s_cursor, ':X_from_request_date',
754: to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
755: WSH_UTIL.Write_Log('X_to_request_date = ' || to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
756: DBMS_SQL.Bind_Variable(s_cursor, ':X_to_request_date',
757: to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
758: WSH_UTIL.Write_Log('X_from_sched_ship_date = ' || to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));

Line 755: WSH_UTIL.Write_Log('X_to_request_date = ' || to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));

751: wsh_pr_picking_session.subinventory);
752: WSH_UTIL.Write_Log('X_from_request_date = ' || to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
753: DBMS_SQL.Bind_Variable(s_cursor, ':X_from_request_date',
754: to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
755: WSH_UTIL.Write_Log('X_to_request_date = ' || to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
756: DBMS_SQL.Bind_Variable(s_cursor, ':X_to_request_date',
757: to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
758: WSH_UTIL.Write_Log('X_from_sched_ship_date = ' || to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
759: DBMS_SQL.Bind_Variable(s_cursor, ':X_from_sched_ship_date',

Line 757: to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));

753: DBMS_SQL.Bind_Variable(s_cursor, ':X_from_request_date',
754: to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
755: WSH_UTIL.Write_Log('X_to_request_date = ' || to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
756: DBMS_SQL.Bind_Variable(s_cursor, ':X_to_request_date',
757: to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
758: WSH_UTIL.Write_Log('X_from_sched_ship_date = ' || to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
759: DBMS_SQL.Bind_Variable(s_cursor, ':X_from_sched_ship_date',
760: to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
761: WSH_UTIL.Write_Log('X_to_sched_ship_date = ' || to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));

Line 758: WSH_UTIL.Write_Log('X_from_sched_ship_date = ' || to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));

754: to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
755: WSH_UTIL.Write_Log('X_to_request_date = ' || to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
756: DBMS_SQL.Bind_Variable(s_cursor, ':X_to_request_date',
757: to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
758: WSH_UTIL.Write_Log('X_from_sched_ship_date = ' || to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
759: DBMS_SQL.Bind_Variable(s_cursor, ':X_from_sched_ship_date',
760: to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
761: WSH_UTIL.Write_Log('X_to_sched_ship_date = ' || to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
762: DBMS_SQL.Bind_Variable(s_cursor, ':X_to_sched_ship_date',

Line 760: to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));

756: DBMS_SQL.Bind_Variable(s_cursor, ':X_to_request_date',
757: to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
758: WSH_UTIL.Write_Log('X_from_sched_ship_date = ' || to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
759: DBMS_SQL.Bind_Variable(s_cursor, ':X_from_sched_ship_date',
760: to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
761: WSH_UTIL.Write_Log('X_to_sched_ship_date = ' || to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
762: DBMS_SQL.Bind_Variable(s_cursor, ':X_to_sched_ship_date',
763: to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
764: WSH_UTIL.Write_Log('X_existing_rsvs_only_flag = ' || wsh_pr_picking_session.existing_rsvs_only_flag);

Line 761: WSH_UTIL.Write_Log('X_to_sched_ship_date = ' || to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));

757: to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
758: WSH_UTIL.Write_Log('X_from_sched_ship_date = ' || to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
759: DBMS_SQL.Bind_Variable(s_cursor, ':X_from_sched_ship_date',
760: to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
761: WSH_UTIL.Write_Log('X_to_sched_ship_date = ' || to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
762: DBMS_SQL.Bind_Variable(s_cursor, ':X_to_sched_ship_date',
763: to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
764: WSH_UTIL.Write_Log('X_existing_rsvs_only_flag = ' || wsh_pr_picking_session.existing_rsvs_only_flag);
765: DBMS_SQL.Bind_Variable(s_cursor, ':X_existing_rsvs_only_flag',

Line 763: to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));

759: DBMS_SQL.Bind_Variable(s_cursor, ':X_from_sched_ship_date',
760: to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
761: WSH_UTIL.Write_Log('X_to_sched_ship_date = ' || to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
762: DBMS_SQL.Bind_Variable(s_cursor, ':X_to_sched_ship_date',
763: to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
764: WSH_UTIL.Write_Log('X_existing_rsvs_only_flag = ' || wsh_pr_picking_session.existing_rsvs_only_flag);
765: DBMS_SQL.Bind_Variable(s_cursor, ':X_existing_rsvs_only_flag',
766: wsh_pr_picking_session.existing_rsvs_only_flag);
767: WSH_UTIL.Write_Log('X_inventory_item_id = ' || to_char(wsh_pr_picking_session.inventory_item_id));

Line 764: WSH_UTIL.Write_Log('X_existing_rsvs_only_flag = ' || wsh_pr_picking_session.existing_rsvs_only_flag);

760: to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
761: WSH_UTIL.Write_Log('X_to_sched_ship_date = ' || to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
762: DBMS_SQL.Bind_Variable(s_cursor, ':X_to_sched_ship_date',
763: to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
764: WSH_UTIL.Write_Log('X_existing_rsvs_only_flag = ' || wsh_pr_picking_session.existing_rsvs_only_flag);
765: DBMS_SQL.Bind_Variable(s_cursor, ':X_existing_rsvs_only_flag',
766: wsh_pr_picking_session.existing_rsvs_only_flag);
767: WSH_UTIL.Write_Log('X_inventory_item_id = ' || to_char(wsh_pr_picking_session.inventory_item_id));
768: DBMS_SQL.Bind_Variable(s_cursor, ':X_inventory_item_id',

Line 766: wsh_pr_picking_session.existing_rsvs_only_flag);

762: DBMS_SQL.Bind_Variable(s_cursor, ':X_to_sched_ship_date',
763: to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
764: WSH_UTIL.Write_Log('X_existing_rsvs_only_flag = ' || wsh_pr_picking_session.existing_rsvs_only_flag);
765: DBMS_SQL.Bind_Variable(s_cursor, ':X_existing_rsvs_only_flag',
766: wsh_pr_picking_session.existing_rsvs_only_flag);
767: WSH_UTIL.Write_Log('X_inventory_item_id = ' || to_char(wsh_pr_picking_session.inventory_item_id));
768: DBMS_SQL.Bind_Variable(s_cursor, ':X_inventory_item_id',
769: wsh_pr_picking_session.inventory_item_id);
770: WSH_UTIL.Write_Log('X_reservations = ' || wsh_pr_picking_session.reservations);

Line 767: WSH_UTIL.Write_Log('X_inventory_item_id = ' || to_char(wsh_pr_picking_session.inventory_item_id));

763: to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
764: WSH_UTIL.Write_Log('X_existing_rsvs_only_flag = ' || wsh_pr_picking_session.existing_rsvs_only_flag);
765: DBMS_SQL.Bind_Variable(s_cursor, ':X_existing_rsvs_only_flag',
766: wsh_pr_picking_session.existing_rsvs_only_flag);
767: WSH_UTIL.Write_Log('X_inventory_item_id = ' || to_char(wsh_pr_picking_session.inventory_item_id));
768: DBMS_SQL.Bind_Variable(s_cursor, ':X_inventory_item_id',
769: wsh_pr_picking_session.inventory_item_id);
770: WSH_UTIL.Write_Log('X_reservations = ' || wsh_pr_picking_session.reservations);
771: DBMS_SQL.Bind_Variable(s_cursor, ':X_reservations',

Line 769: wsh_pr_picking_session.inventory_item_id);

765: DBMS_SQL.Bind_Variable(s_cursor, ':X_existing_rsvs_only_flag',
766: wsh_pr_picking_session.existing_rsvs_only_flag);
767: WSH_UTIL.Write_Log('X_inventory_item_id = ' || to_char(wsh_pr_picking_session.inventory_item_id));
768: DBMS_SQL.Bind_Variable(s_cursor, ':X_inventory_item_id',
769: wsh_pr_picking_session.inventory_item_id);
770: WSH_UTIL.Write_Log('X_reservations = ' || wsh_pr_picking_session.reservations);
771: DBMS_SQL.Bind_Variable(s_cursor, ':X_reservations',
772: wsh_pr_picking_session.reservations);
773: WSH_UTIL.Write_Log('X_departure_id = ' || to_char(wsh_pr_picking_session.departure_id));

Line 770: WSH_UTIL.Write_Log('X_reservations = ' || wsh_pr_picking_session.reservations);

766: wsh_pr_picking_session.existing_rsvs_only_flag);
767: WSH_UTIL.Write_Log('X_inventory_item_id = ' || to_char(wsh_pr_picking_session.inventory_item_id));
768: DBMS_SQL.Bind_Variable(s_cursor, ':X_inventory_item_id',
769: wsh_pr_picking_session.inventory_item_id);
770: WSH_UTIL.Write_Log('X_reservations = ' || wsh_pr_picking_session.reservations);
771: DBMS_SQL.Bind_Variable(s_cursor, ':X_reservations',
772: wsh_pr_picking_session.reservations);
773: WSH_UTIL.Write_Log('X_departure_id = ' || to_char(wsh_pr_picking_session.departure_id));
774: DBMS_SQL.Bind_Variable(s_cursor, ':X_departure_id',

Line 772: wsh_pr_picking_session.reservations);

768: DBMS_SQL.Bind_Variable(s_cursor, ':X_inventory_item_id',
769: wsh_pr_picking_session.inventory_item_id);
770: WSH_UTIL.Write_Log('X_reservations = ' || wsh_pr_picking_session.reservations);
771: DBMS_SQL.Bind_Variable(s_cursor, ':X_reservations',
772: wsh_pr_picking_session.reservations);
773: WSH_UTIL.Write_Log('X_departure_id = ' || to_char(wsh_pr_picking_session.departure_id));
774: DBMS_SQL.Bind_Variable(s_cursor, ':X_departure_id',
775: wsh_pr_picking_session.departure_id);
776: IF (wsh_pr_picking_session.delivery_id <> 0) THEN

Line 773: WSH_UTIL.Write_Log('X_departure_id = ' || to_char(wsh_pr_picking_session.departure_id));

769: wsh_pr_picking_session.inventory_item_id);
770: WSH_UTIL.Write_Log('X_reservations = ' || wsh_pr_picking_session.reservations);
771: DBMS_SQL.Bind_Variable(s_cursor, ':X_reservations',
772: wsh_pr_picking_session.reservations);
773: WSH_UTIL.Write_Log('X_departure_id = ' || to_char(wsh_pr_picking_session.departure_id));
774: DBMS_SQL.Bind_Variable(s_cursor, ':X_departure_id',
775: wsh_pr_picking_session.departure_id);
776: IF (wsh_pr_picking_session.delivery_id <> 0) THEN
777: WSH_UTIL.Write_Log('X_delivery_id = ' || to_char(wsh_pr_picking_session.delivery_id));

Line 775: wsh_pr_picking_session.departure_id);

771: DBMS_SQL.Bind_Variable(s_cursor, ':X_reservations',
772: wsh_pr_picking_session.reservations);
773: WSH_UTIL.Write_Log('X_departure_id = ' || to_char(wsh_pr_picking_session.departure_id));
774: DBMS_SQL.Bind_Variable(s_cursor, ':X_departure_id',
775: wsh_pr_picking_session.departure_id);
776: IF (wsh_pr_picking_session.delivery_id <> 0) THEN
777: WSH_UTIL.Write_Log('X_delivery_id = ' || to_char(wsh_pr_picking_session.delivery_id));
778: DBMS_SQL.Bind_Variable(s_cursor, ':X_delivery_id',
779: wsh_pr_picking_session.delivery_id);

Line 776: IF (wsh_pr_picking_session.delivery_id <> 0) THEN

772: wsh_pr_picking_session.reservations);
773: WSH_UTIL.Write_Log('X_departure_id = ' || to_char(wsh_pr_picking_session.departure_id));
774: DBMS_SQL.Bind_Variable(s_cursor, ':X_departure_id',
775: wsh_pr_picking_session.departure_id);
776: IF (wsh_pr_picking_session.delivery_id <> 0) THEN
777: WSH_UTIL.Write_Log('X_delivery_id = ' || to_char(wsh_pr_picking_session.delivery_id));
778: DBMS_SQL.Bind_Variable(s_cursor, ':X_delivery_id',
779: wsh_pr_picking_session.delivery_id);
780: END IF;

Line 777: WSH_UTIL.Write_Log('X_delivery_id = ' || to_char(wsh_pr_picking_session.delivery_id));

773: WSH_UTIL.Write_Log('X_departure_id = ' || to_char(wsh_pr_picking_session.departure_id));
774: DBMS_SQL.Bind_Variable(s_cursor, ':X_departure_id',
775: wsh_pr_picking_session.departure_id);
776: IF (wsh_pr_picking_session.delivery_id <> 0) THEN
777: WSH_UTIL.Write_Log('X_delivery_id = ' || to_char(wsh_pr_picking_session.delivery_id));
778: DBMS_SQL.Bind_Variable(s_cursor, ':X_delivery_id',
779: wsh_pr_picking_session.delivery_id);
780: END IF;
781: WSH_UTIL.Write_Log('X_include_planned_lines = ' || wsh_pr_picking_session.include_planned_lines);

Line 779: wsh_pr_picking_session.delivery_id);

775: wsh_pr_picking_session.departure_id);
776: IF (wsh_pr_picking_session.delivery_id <> 0) THEN
777: WSH_UTIL.Write_Log('X_delivery_id = ' || to_char(wsh_pr_picking_session.delivery_id));
778: DBMS_SQL.Bind_Variable(s_cursor, ':X_delivery_id',
779: wsh_pr_picking_session.delivery_id);
780: END IF;
781: WSH_UTIL.Write_Log('X_include_planned_lines = ' || wsh_pr_picking_session.include_planned_lines);
782: DBMS_SQL.Bind_Variable(s_cursor, ':X_include_planned_lines',
783: wsh_pr_picking_session.include_planned_lines);

Line 781: WSH_UTIL.Write_Log('X_include_planned_lines = ' || wsh_pr_picking_session.include_planned_lines);

777: WSH_UTIL.Write_Log('X_delivery_id = ' || to_char(wsh_pr_picking_session.delivery_id));
778: DBMS_SQL.Bind_Variable(s_cursor, ':X_delivery_id',
779: wsh_pr_picking_session.delivery_id);
780: END IF;
781: WSH_UTIL.Write_Log('X_include_planned_lines = ' || wsh_pr_picking_session.include_planned_lines);
782: DBMS_SQL.Bind_Variable(s_cursor, ':X_include_planned_lines',
783: wsh_pr_picking_session.include_planned_lines);
784:
785: -- Execute the cursor

Line 783: wsh_pr_picking_session.include_planned_lines);

779: wsh_pr_picking_session.delivery_id);
780: END IF;
781: WSH_UTIL.Write_Log('X_include_planned_lines = ' || wsh_pr_picking_session.include_planned_lines);
782: DBMS_SQL.Bind_Variable(s_cursor, ':X_include_planned_lines',
783: wsh_pr_picking_session.include_planned_lines);
784:
785: -- Execute the cursor
786: WSH_UTIL.Write_Log('Executing sync cursor');
787: v_ignore := DBMS_SQL.Execute(s_cursor);

Line 807: WSH_UTIL.Write_Log('X_request_id = ' || to_char(wsh_pr_picking_session.request_id));

803:
804: -- Bind release criteria values
805: WSH_UTIL.Write_Log('Binding non-ship cursor');
806:
807: WSH_UTIL.Write_Log('X_request_id = ' || to_char(wsh_pr_picking_session.request_id));
808: DBMS_SQL.Bind_Variable(ns_cursor, ':X_request_id',
809: wsh_pr_picking_session.request_id);
810:
811: IF (wsh_pr_picking_session.header_id <> 0) THEN

Line 809: wsh_pr_picking_session.request_id);

805: WSH_UTIL.Write_Log('Binding non-ship cursor');
806:
807: WSH_UTIL.Write_Log('X_request_id = ' || to_char(wsh_pr_picking_session.request_id));
808: DBMS_SQL.Bind_Variable(ns_cursor, ':X_request_id',
809: wsh_pr_picking_session.request_id);
810:
811: IF (wsh_pr_picking_session.header_id <> 0) THEN
812: WSH_UTIL.Write_Log('X_header_id = ' || to_char(wsh_pr_picking_session.header_id));
813: DBMS_SQL.Bind_Variable(ns_cursor, ':X_header_id',

Line 811: IF (wsh_pr_picking_session.header_id <> 0) THEN

807: WSH_UTIL.Write_Log('X_request_id = ' || to_char(wsh_pr_picking_session.request_id));
808: DBMS_SQL.Bind_Variable(ns_cursor, ':X_request_id',
809: wsh_pr_picking_session.request_id);
810:
811: IF (wsh_pr_picking_session.header_id <> 0) THEN
812: WSH_UTIL.Write_Log('X_header_id = ' || to_char(wsh_pr_picking_session.header_id));
813: DBMS_SQL.Bind_Variable(ns_cursor, ':X_header_id',
814: wsh_pr_picking_session.header_id);
815: END IF;

Line 812: WSH_UTIL.Write_Log('X_header_id = ' || to_char(wsh_pr_picking_session.header_id));

808: DBMS_SQL.Bind_Variable(ns_cursor, ':X_request_id',
809: wsh_pr_picking_session.request_id);
810:
811: IF (wsh_pr_picking_session.header_id <> 0) THEN
812: WSH_UTIL.Write_Log('X_header_id = ' || to_char(wsh_pr_picking_session.header_id));
813: DBMS_SQL.Bind_Variable(ns_cursor, ':X_header_id',
814: wsh_pr_picking_session.header_id);
815: END IF;
816: WSH_UTIL.Write_Log('X_order_type_id = ' || to_char(wsh_pr_picking_session.order_type_id));

Line 814: wsh_pr_picking_session.header_id);

810:
811: IF (wsh_pr_picking_session.header_id <> 0) THEN
812: WSH_UTIL.Write_Log('X_header_id = ' || to_char(wsh_pr_picking_session.header_id));
813: DBMS_SQL.Bind_Variable(ns_cursor, ':X_header_id',
814: wsh_pr_picking_session.header_id);
815: END IF;
816: WSH_UTIL.Write_Log('X_order_type_id = ' || to_char(wsh_pr_picking_session.order_type_id));
817: DBMS_SQL.Bind_Variable(ns_cursor, ':X_order_type_id',
818: wsh_pr_picking_session.order_type_id);

Line 816: WSH_UTIL.Write_Log('X_order_type_id = ' || to_char(wsh_pr_picking_session.order_type_id));

812: WSH_UTIL.Write_Log('X_header_id = ' || to_char(wsh_pr_picking_session.header_id));
813: DBMS_SQL.Bind_Variable(ns_cursor, ':X_header_id',
814: wsh_pr_picking_session.header_id);
815: END IF;
816: WSH_UTIL.Write_Log('X_order_type_id = ' || to_char(wsh_pr_picking_session.order_type_id));
817: DBMS_SQL.Bind_Variable(ns_cursor, ':X_order_type_id',
818: wsh_pr_picking_session.order_type_id);
819: IF (wsh_pr_picking_session.customer_id <> 0) THEN
820: WSH_UTIL.Write_Log('X_customer_id = ' || to_char(wsh_pr_picking_session.customer_id));

Line 818: wsh_pr_picking_session.order_type_id);

814: wsh_pr_picking_session.header_id);
815: END IF;
816: WSH_UTIL.Write_Log('X_order_type_id = ' || to_char(wsh_pr_picking_session.order_type_id));
817: DBMS_SQL.Bind_Variable(ns_cursor, ':X_order_type_id',
818: wsh_pr_picking_session.order_type_id);
819: IF (wsh_pr_picking_session.customer_id <> 0) THEN
820: WSH_UTIL.Write_Log('X_customer_id = ' || to_char(wsh_pr_picking_session.customer_id));
821: DBMS_SQL.Bind_Variable(ns_cursor, ':X_customer_id',
822: wsh_pr_picking_session.customer_id);

Line 819: IF (wsh_pr_picking_session.customer_id <> 0) THEN

815: END IF;
816: WSH_UTIL.Write_Log('X_order_type_id = ' || to_char(wsh_pr_picking_session.order_type_id));
817: DBMS_SQL.Bind_Variable(ns_cursor, ':X_order_type_id',
818: wsh_pr_picking_session.order_type_id);
819: IF (wsh_pr_picking_session.customer_id <> 0) THEN
820: WSH_UTIL.Write_Log('X_customer_id = ' || to_char(wsh_pr_picking_session.customer_id));
821: DBMS_SQL.Bind_Variable(ns_cursor, ':X_customer_id',
822: wsh_pr_picking_session.customer_id);
823: END IF;

Line 820: WSH_UTIL.Write_Log('X_customer_id = ' || to_char(wsh_pr_picking_session.customer_id));

816: WSH_UTIL.Write_Log('X_order_type_id = ' || to_char(wsh_pr_picking_session.order_type_id));
817: DBMS_SQL.Bind_Variable(ns_cursor, ':X_order_type_id',
818: wsh_pr_picking_session.order_type_id);
819: IF (wsh_pr_picking_session.customer_id <> 0) THEN
820: WSH_UTIL.Write_Log('X_customer_id = ' || to_char(wsh_pr_picking_session.customer_id));
821: DBMS_SQL.Bind_Variable(ns_cursor, ':X_customer_id',
822: wsh_pr_picking_session.customer_id);
823: END IF;
824:

Line 822: wsh_pr_picking_session.customer_id);

818: wsh_pr_picking_session.order_type_id);
819: IF (wsh_pr_picking_session.customer_id <> 0) THEN
820: WSH_UTIL.Write_Log('X_customer_id = ' || to_char(wsh_pr_picking_session.customer_id));
821: DBMS_SQL.Bind_Variable(ns_cursor, ':X_customer_id',
822: wsh_pr_picking_session.customer_id);
823: END IF;
824:
825: IF (wsh_pr_picking_session.order_line_id <> 0) THEN
826: WSH_UTIL.Write_Log('X_order_line_id = ' || to_char(wsh_pr_picking_session.order_line_id));

Line 825: IF (wsh_pr_picking_session.order_line_id <> 0) THEN

821: DBMS_SQL.Bind_Variable(ns_cursor, ':X_customer_id',
822: wsh_pr_picking_session.customer_id);
823: END IF;
824:
825: IF (wsh_pr_picking_session.order_line_id <> 0) THEN
826: WSH_UTIL.Write_Log('X_order_line_id = ' || to_char(wsh_pr_picking_session.order_line_id));
827: DBMS_SQL.Bind_Variable(ns_cursor, ':X_order_line_id',
828: wsh_pr_picking_session.order_line_id);
829: END IF;

Line 826: WSH_UTIL.Write_Log('X_order_line_id = ' || to_char(wsh_pr_picking_session.order_line_id));

822: wsh_pr_picking_session.customer_id);
823: END IF;
824:
825: IF (wsh_pr_picking_session.order_line_id <> 0) THEN
826: WSH_UTIL.Write_Log('X_order_line_id = ' || to_char(wsh_pr_picking_session.order_line_id));
827: DBMS_SQL.Bind_Variable(ns_cursor, ':X_order_line_id',
828: wsh_pr_picking_session.order_line_id);
829: END IF;
830:

Line 828: wsh_pr_picking_session.order_line_id);

824:
825: IF (wsh_pr_picking_session.order_line_id <> 0) THEN
826: WSH_UTIL.Write_Log('X_order_line_id = ' || to_char(wsh_pr_picking_session.order_line_id));
827: DBMS_SQL.Bind_Variable(ns_cursor, ':X_order_line_id',
828: wsh_pr_picking_session.order_line_id);
829: END IF;
830:
831: WSH_UTIL.Write_Log('X_ship_set_number = ' || to_char(wsh_pr_picking_session.ship_set_number));
832: DBMS_SQL.Bind_Variable(ns_cursor, ':X_ship_set_number',

Line 831: WSH_UTIL.Write_Log('X_ship_set_number = ' || to_char(wsh_pr_picking_session.ship_set_number));

827: DBMS_SQL.Bind_Variable(ns_cursor, ':X_order_line_id',
828: wsh_pr_picking_session.order_line_id);
829: END IF;
830:
831: WSH_UTIL.Write_Log('X_ship_set_number = ' || to_char(wsh_pr_picking_session.ship_set_number));
832: DBMS_SQL.Bind_Variable(ns_cursor, ':X_ship_set_number',
833: wsh_pr_picking_session.ship_set_number);
834: WSH_UTIL.Write_Log('X_warehouse_id = ' || to_char(wsh_pr_picking_session.warehouse_id));
835: DBMS_SQL.Bind_Variable(ns_cursor, ':X_warehouse_id',

Line 833: wsh_pr_picking_session.ship_set_number);

829: END IF;
830:
831: WSH_UTIL.Write_Log('X_ship_set_number = ' || to_char(wsh_pr_picking_session.ship_set_number));
832: DBMS_SQL.Bind_Variable(ns_cursor, ':X_ship_set_number',
833: wsh_pr_picking_session.ship_set_number);
834: WSH_UTIL.Write_Log('X_warehouse_id = ' || to_char(wsh_pr_picking_session.warehouse_id));
835: DBMS_SQL.Bind_Variable(ns_cursor, ':X_warehouse_id',
836: wsh_pr_picking_session.warehouse_id);
837: WSH_UTIL.Write_Log('X_from_request_date = ' || to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));

Line 834: WSH_UTIL.Write_Log('X_warehouse_id = ' || to_char(wsh_pr_picking_session.warehouse_id));

830:
831: WSH_UTIL.Write_Log('X_ship_set_number = ' || to_char(wsh_pr_picking_session.ship_set_number));
832: DBMS_SQL.Bind_Variable(ns_cursor, ':X_ship_set_number',
833: wsh_pr_picking_session.ship_set_number);
834: WSH_UTIL.Write_Log('X_warehouse_id = ' || to_char(wsh_pr_picking_session.warehouse_id));
835: DBMS_SQL.Bind_Variable(ns_cursor, ':X_warehouse_id',
836: wsh_pr_picking_session.warehouse_id);
837: WSH_UTIL.Write_Log('X_from_request_date = ' || to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
838: DBMS_SQL.Bind_Variable(ns_cursor, ':X_from_request_date',

Line 836: wsh_pr_picking_session.warehouse_id);

832: DBMS_SQL.Bind_Variable(ns_cursor, ':X_ship_set_number',
833: wsh_pr_picking_session.ship_set_number);
834: WSH_UTIL.Write_Log('X_warehouse_id = ' || to_char(wsh_pr_picking_session.warehouse_id));
835: DBMS_SQL.Bind_Variable(ns_cursor, ':X_warehouse_id',
836: wsh_pr_picking_session.warehouse_id);
837: WSH_UTIL.Write_Log('X_from_request_date = ' || to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
838: DBMS_SQL.Bind_Variable(ns_cursor, ':X_from_request_date',
839: to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
840: WSH_UTIL.Write_Log('X_to_request_date = ' || to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));

Line 837: WSH_UTIL.Write_Log('X_from_request_date = ' || to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));

833: wsh_pr_picking_session.ship_set_number);
834: WSH_UTIL.Write_Log('X_warehouse_id = ' || to_char(wsh_pr_picking_session.warehouse_id));
835: DBMS_SQL.Bind_Variable(ns_cursor, ':X_warehouse_id',
836: wsh_pr_picking_session.warehouse_id);
837: WSH_UTIL.Write_Log('X_from_request_date = ' || to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
838: DBMS_SQL.Bind_Variable(ns_cursor, ':X_from_request_date',
839: to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
840: WSH_UTIL.Write_Log('X_to_request_date = ' || to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
841: DBMS_SQL.Bind_Variable(ns_cursor, ':X_to_request_date',

Line 839: to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));

835: DBMS_SQL.Bind_Variable(ns_cursor, ':X_warehouse_id',
836: wsh_pr_picking_session.warehouse_id);
837: WSH_UTIL.Write_Log('X_from_request_date = ' || to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
838: DBMS_SQL.Bind_Variable(ns_cursor, ':X_from_request_date',
839: to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
840: WSH_UTIL.Write_Log('X_to_request_date = ' || to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
841: DBMS_SQL.Bind_Variable(ns_cursor, ':X_to_request_date',
842: to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
843: WSH_UTIL.Write_Log('X_from_sched_ship_date = ' || to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));

Line 840: WSH_UTIL.Write_Log('X_to_request_date = ' || to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));

836: wsh_pr_picking_session.warehouse_id);
837: WSH_UTIL.Write_Log('X_from_request_date = ' || to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
838: DBMS_SQL.Bind_Variable(ns_cursor, ':X_from_request_date',
839: to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
840: WSH_UTIL.Write_Log('X_to_request_date = ' || to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
841: DBMS_SQL.Bind_Variable(ns_cursor, ':X_to_request_date',
842: to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
843: WSH_UTIL.Write_Log('X_from_sched_ship_date = ' || to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
844: DBMS_SQL.Bind_Variable(ns_cursor, ':X_from_sched_ship_date',

Line 842: to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));

838: DBMS_SQL.Bind_Variable(ns_cursor, ':X_from_request_date',
839: to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
840: WSH_UTIL.Write_Log('X_to_request_date = ' || to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
841: DBMS_SQL.Bind_Variable(ns_cursor, ':X_to_request_date',
842: to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
843: WSH_UTIL.Write_Log('X_from_sched_ship_date = ' || to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
844: DBMS_SQL.Bind_Variable(ns_cursor, ':X_from_sched_ship_date',
845: to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
846: WSH_UTIL.Write_Log('X_to_sched_ship_date = ' || to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));

Line 843: WSH_UTIL.Write_Log('X_from_sched_ship_date = ' || to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));

839: to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
840: WSH_UTIL.Write_Log('X_to_request_date = ' || to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
841: DBMS_SQL.Bind_Variable(ns_cursor, ':X_to_request_date',
842: to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
843: WSH_UTIL.Write_Log('X_from_sched_ship_date = ' || to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
844: DBMS_SQL.Bind_Variable(ns_cursor, ':X_from_sched_ship_date',
845: to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
846: WSH_UTIL.Write_Log('X_to_sched_ship_date = ' || to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
847: DBMS_SQL.Bind_Variable(ns_cursor, ':X_to_sched_ship_date',

Line 845: to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));

841: DBMS_SQL.Bind_Variable(ns_cursor, ':X_to_request_date',
842: to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
843: WSH_UTIL.Write_Log('X_from_sched_ship_date = ' || to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
844: DBMS_SQL.Bind_Variable(ns_cursor, ':X_from_sched_ship_date',
845: to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
846: WSH_UTIL.Write_Log('X_to_sched_ship_date = ' || to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
847: DBMS_SQL.Bind_Variable(ns_cursor, ':X_to_sched_ship_date',
848: to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
849: WSH_UTIL.Write_Log('X_inventory_item_id = ' || to_char(wsh_pr_picking_session.inventory_item_id));

Line 846: WSH_UTIL.Write_Log('X_to_sched_ship_date = ' || to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));

842: to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
843: WSH_UTIL.Write_Log('X_from_sched_ship_date = ' || to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
844: DBMS_SQL.Bind_Variable(ns_cursor, ':X_from_sched_ship_date',
845: to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
846: WSH_UTIL.Write_Log('X_to_sched_ship_date = ' || to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
847: DBMS_SQL.Bind_Variable(ns_cursor, ':X_to_sched_ship_date',
848: to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
849: WSH_UTIL.Write_Log('X_inventory_item_id = ' || to_char(wsh_pr_picking_session.inventory_item_id));
850: DBMS_SQL.Bind_Variable(ns_cursor, ':X_inventory_item_id',

Line 848: to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));

844: DBMS_SQL.Bind_Variable(ns_cursor, ':X_from_sched_ship_date',
845: to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
846: WSH_UTIL.Write_Log('X_to_sched_ship_date = ' || to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
847: DBMS_SQL.Bind_Variable(ns_cursor, ':X_to_sched_ship_date',
848: to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
849: WSH_UTIL.Write_Log('X_inventory_item_id = ' || to_char(wsh_pr_picking_session.inventory_item_id));
850: DBMS_SQL.Bind_Variable(ns_cursor, ':X_inventory_item_id',
851: wsh_pr_picking_session.inventory_item_id);
852: IF (wsh_pr_picking_session.departure_id <> 0) THEN

Line 849: WSH_UTIL.Write_Log('X_inventory_item_id = ' || to_char(wsh_pr_picking_session.inventory_item_id));

845: to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
846: WSH_UTIL.Write_Log('X_to_sched_ship_date = ' || to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
847: DBMS_SQL.Bind_Variable(ns_cursor, ':X_to_sched_ship_date',
848: to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
849: WSH_UTIL.Write_Log('X_inventory_item_id = ' || to_char(wsh_pr_picking_session.inventory_item_id));
850: DBMS_SQL.Bind_Variable(ns_cursor, ':X_inventory_item_id',
851: wsh_pr_picking_session.inventory_item_id);
852: IF (wsh_pr_picking_session.departure_id <> 0) THEN
853: WSH_UTIL.Write_Log('X_departure_id = ' || to_char(wsh_pr_picking_session.departure_id));

Line 851: wsh_pr_picking_session.inventory_item_id);

847: DBMS_SQL.Bind_Variable(ns_cursor, ':X_to_sched_ship_date',
848: to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
849: WSH_UTIL.Write_Log('X_inventory_item_id = ' || to_char(wsh_pr_picking_session.inventory_item_id));
850: DBMS_SQL.Bind_Variable(ns_cursor, ':X_inventory_item_id',
851: wsh_pr_picking_session.inventory_item_id);
852: IF (wsh_pr_picking_session.departure_id <> 0) THEN
853: WSH_UTIL.Write_Log('X_departure_id = ' || to_char(wsh_pr_picking_session.departure_id));
854: DBMS_SQL.Bind_Variable(ns_cursor, ':X_departure_id',
855: wsh_pr_picking_session.departure_id);

Line 852: IF (wsh_pr_picking_session.departure_id <> 0) THEN

848: to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
849: WSH_UTIL.Write_Log('X_inventory_item_id = ' || to_char(wsh_pr_picking_session.inventory_item_id));
850: DBMS_SQL.Bind_Variable(ns_cursor, ':X_inventory_item_id',
851: wsh_pr_picking_session.inventory_item_id);
852: IF (wsh_pr_picking_session.departure_id <> 0) THEN
853: WSH_UTIL.Write_Log('X_departure_id = ' || to_char(wsh_pr_picking_session.departure_id));
854: DBMS_SQL.Bind_Variable(ns_cursor, ':X_departure_id',
855: wsh_pr_picking_session.departure_id);
856: END IF;

Line 853: WSH_UTIL.Write_Log('X_departure_id = ' || to_char(wsh_pr_picking_session.departure_id));

849: WSH_UTIL.Write_Log('X_inventory_item_id = ' || to_char(wsh_pr_picking_session.inventory_item_id));
850: DBMS_SQL.Bind_Variable(ns_cursor, ':X_inventory_item_id',
851: wsh_pr_picking_session.inventory_item_id);
852: IF (wsh_pr_picking_session.departure_id <> 0) THEN
853: WSH_UTIL.Write_Log('X_departure_id = ' || to_char(wsh_pr_picking_session.departure_id));
854: DBMS_SQL.Bind_Variable(ns_cursor, ':X_departure_id',
855: wsh_pr_picking_session.departure_id);
856: END IF;
857: IF (wsh_pr_picking_session.delivery_id <> 0) THEN

Line 855: wsh_pr_picking_session.departure_id);

851: wsh_pr_picking_session.inventory_item_id);
852: IF (wsh_pr_picking_session.departure_id <> 0) THEN
853: WSH_UTIL.Write_Log('X_departure_id = ' || to_char(wsh_pr_picking_session.departure_id));
854: DBMS_SQL.Bind_Variable(ns_cursor, ':X_departure_id',
855: wsh_pr_picking_session.departure_id);
856: END IF;
857: IF (wsh_pr_picking_session.delivery_id <> 0) THEN
858: WSH_UTIL.Write_Log('X_delivery_id = ' || to_char(wsh_pr_picking_session.delivery_id));
859: DBMS_SQL.Bind_Variable(ns_cursor, ':X_delivery_id',

Line 857: IF (wsh_pr_picking_session.delivery_id <> 0) THEN

853: WSH_UTIL.Write_Log('X_departure_id = ' || to_char(wsh_pr_picking_session.departure_id));
854: DBMS_SQL.Bind_Variable(ns_cursor, ':X_departure_id',
855: wsh_pr_picking_session.departure_id);
856: END IF;
857: IF (wsh_pr_picking_session.delivery_id <> 0) THEN
858: WSH_UTIL.Write_Log('X_delivery_id = ' || to_char(wsh_pr_picking_session.delivery_id));
859: DBMS_SQL.Bind_Variable(ns_cursor, ':X_delivery_id',
860: wsh_pr_picking_session.delivery_id);
861: END IF;

Line 858: WSH_UTIL.Write_Log('X_delivery_id = ' || to_char(wsh_pr_picking_session.delivery_id));

854: DBMS_SQL.Bind_Variable(ns_cursor, ':X_departure_id',
855: wsh_pr_picking_session.departure_id);
856: END IF;
857: IF (wsh_pr_picking_session.delivery_id <> 0) THEN
858: WSH_UTIL.Write_Log('X_delivery_id = ' || to_char(wsh_pr_picking_session.delivery_id));
859: DBMS_SQL.Bind_Variable(ns_cursor, ':X_delivery_id',
860: wsh_pr_picking_session.delivery_id);
861: END IF;
862:

Line 860: wsh_pr_picking_session.delivery_id);

856: END IF;
857: IF (wsh_pr_picking_session.delivery_id <> 0) THEN
858: WSH_UTIL.Write_Log('X_delivery_id = ' || to_char(wsh_pr_picking_session.delivery_id));
859: DBMS_SQL.Bind_Variable(ns_cursor, ':X_delivery_id',
860: wsh_pr_picking_session.delivery_id);
861: END IF;
862:
863: -- Execute the cursor
864: WSH_UTIL.Write_Log('Executing non-ship cursor');

Line 1273: next_line := WSH_PR_PICKING_SESSION.Get_Next_Line_Detail(u_invoice_value,

1269: RETURN DONE;
1270: END IF;
1271: ELSE
1272: line := 11;
1273: next_line := WSH_PR_PICKING_SESSION.Get_Next_Line_Detail(u_invoice_value,
1274: b_invoice_value,
1275: u_order_number,
1276: b_order_number,
1277: u_schedule_date,

Line 1685: wsh_pr_picking_session.sync_line_id := p_sync_line_id;

1681:
1682: BEGIN
1683:
1684: WSH_UTIL.Write_Log('Setting sync_line_id to ' || to_char(p_sync_line_id));
1685: wsh_pr_picking_session.sync_line_id := p_sync_line_id;
1686:
1687: -- Call to dynamically create SQL for Sync Lines
1688: WSH_UTIL.Write_Log('Calling WSH_PR_PICKING_SESSION.Sync_Details...');
1689: cs := WSH_PR_PICKING_SESSION.Sync_Details;

Line 1688: WSH_UTIL.Write_Log('Calling WSH_PR_PICKING_SESSION.Sync_Details...');

1684: WSH_UTIL.Write_Log('Setting sync_line_id to ' || to_char(p_sync_line_id));
1685: wsh_pr_picking_session.sync_line_id := p_sync_line_id;
1686:
1687: -- Call to dynamically create SQL for Sync Lines
1688: WSH_UTIL.Write_Log('Calling WSH_PR_PICKING_SESSION.Sync_Details...');
1689: cs := WSH_PR_PICKING_SESSION.Sync_Details;
1690: IF cs = FAILURE THEN
1691: WSH_UTIL.Write_Log('Error in WSH_PR_PICKING_SESSION.Sync_Details');
1692: RETURN FAILURE;

Line 1689: cs := WSH_PR_PICKING_SESSION.Sync_Details;

1685: wsh_pr_picking_session.sync_line_id := p_sync_line_id;
1686:
1687: -- Call to dynamically create SQL for Sync Lines
1688: WSH_UTIL.Write_Log('Calling WSH_PR_PICKING_SESSION.Sync_Details...');
1689: cs := WSH_PR_PICKING_SESSION.Sync_Details;
1690: IF cs = FAILURE THEN
1691: WSH_UTIL.Write_Log('Error in WSH_PR_PICKING_SESSION.Sync_Details');
1692: RETURN FAILURE;
1693: END IF;

Line 1691: WSH_UTIL.Write_Log('Error in WSH_PR_PICKING_SESSION.Sync_Details');

1687: -- Call to dynamically create SQL for Sync Lines
1688: WSH_UTIL.Write_Log('Calling WSH_PR_PICKING_SESSION.Sync_Details...');
1689: cs := WSH_PR_PICKING_SESSION.Sync_Details;
1690: IF cs = FAILURE THEN
1691: WSH_UTIL.Write_Log('Error in WSH_PR_PICKING_SESSION.Sync_Details');
1692: RETURN FAILURE;
1693: END IF;
1694:
1695: -- Fetch the Sync Lines SQL

Line 1696: WSH_UTIL.Write_Log('Calling WSH_PR_PICKING_SESSION.Get_Session_Value for sync SQL');

1692: RETURN FAILURE;
1693: END IF;
1694:
1695: -- Fetch the Sync Lines SQL
1696: WSH_UTIL.Write_Log('Calling WSH_PR_PICKING_SESSION.Get_Session_Value for sync SQL');
1697: sync_SQL := WSH_PR_PICKING_SESSION.Get_Session_Value('SYNC_SQL');
1698: IF sync_SQL = '-1' THEN
1699: WSH_UTIL.Write_Log('Error in call to WSH_PR_PICKING_SESSION.Get_Session_Value');
1700: RETURN FAILURE;

Line 1697: sync_SQL := WSH_PR_PICKING_SESSION.Get_Session_Value('SYNC_SQL');

1693: END IF;
1694:
1695: -- Fetch the Sync Lines SQL
1696: WSH_UTIL.Write_Log('Calling WSH_PR_PICKING_SESSION.Get_Session_Value for sync SQL');
1697: sync_SQL := WSH_PR_PICKING_SESSION.Get_Session_Value('SYNC_SQL');
1698: IF sync_SQL = '-1' THEN
1699: WSH_UTIL.Write_Log('Error in call to WSH_PR_PICKING_SESSION.Get_Session_Value');
1700: RETURN FAILURE;
1701: END IF;

Line 1699: WSH_UTIL.Write_Log('Error in call to WSH_PR_PICKING_SESSION.Get_Session_Value');

1695: -- Fetch the Sync Lines SQL
1696: WSH_UTIL.Write_Log('Calling WSH_PR_PICKING_SESSION.Get_Session_Value for sync SQL');
1697: sync_SQL := WSH_PR_PICKING_SESSION.Get_Session_Value('SYNC_SQL');
1698: IF sync_SQL = '-1' THEN
1699: WSH_UTIL.Write_Log('Error in call to WSH_PR_PICKING_SESSION.Get_Session_Value');
1700: RETURN FAILURE;
1701: END IF;
1702:
1703: -- Call package to process buffer into cursor for parsing and executing

Line 1742: cs := WSH_PR_PICKING_SESSION.Construct_SQL('SET REQUEST');

1738: ) RETURN BINARY_INTEGER IS
1739: cs BINARY_INTEGER;
1740: BEGIN
1741:
1742: cs := WSH_PR_PICKING_SESSION.Construct_SQL('SET REQUEST');
1743: IF cs = FAILURE THEN
1744: WSH_UTIL.Write_Log('Error in Construct SQL');
1745: RETURN FAILURE;
1746: END IF;

Line 1747: sreq_SQL := WSH_PR_PICKING_SESSION.Get_Session_Value('SET_REQUEST_SQL');

1743: IF cs = FAILURE THEN
1744: WSH_UTIL.Write_Log('Error in Construct SQL');
1745: RETURN FAILURE;
1746: END IF;
1747: sreq_SQL := WSH_PR_PICKING_SESSION.Get_Session_Value('SET_REQUEST_SQL');
1748: sreq_cursor := DBMS_SQL.Open_Cursor;
1749: DBMS_SQL.Parse(sreq_cursor, sreq_SQL, DBMS_SQL.v7);
1750:
1751: WSH_UTIL.Write_Log('Binding Set Request ID cursor');

Line 1753: WSH_UTIL.Write_Log('X_request_id = ' || to_char(wsh_pr_picking_session.request_id));

1749: DBMS_SQL.Parse(sreq_cursor, sreq_SQL, DBMS_SQL.v7);
1750:
1751: WSH_UTIL.Write_Log('Binding Set Request ID cursor');
1752:
1753: WSH_UTIL.Write_Log('X_request_id = ' || to_char(wsh_pr_picking_session.request_id));
1754: DBMS_SQL.Bind_Variable(sreq_cursor, ':X_request_id',
1755: wsh_pr_picking_session.request_id);
1756: WSH_UTIL.Write_Log('X_sync_line_id = ' || to_char(p_sync_line_id));
1757: DBMS_SQL.Bind_Variable(sreq_cursor, ':X_sync_line_id',

Line 1755: wsh_pr_picking_session.request_id);

1751: WSH_UTIL.Write_Log('Binding Set Request ID cursor');
1752:
1753: WSH_UTIL.Write_Log('X_request_id = ' || to_char(wsh_pr_picking_session.request_id));
1754: DBMS_SQL.Bind_Variable(sreq_cursor, ':X_request_id',
1755: wsh_pr_picking_session.request_id);
1756: WSH_UTIL.Write_Log('X_sync_line_id = ' || to_char(p_sync_line_id));
1757: DBMS_SQL.Bind_Variable(sreq_cursor, ':X_sync_line_id',
1758: p_sync_line_id);
1759: WSH_UTIL.Write_Log('X_from_request_date = ' || to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));

Line 1759: WSH_UTIL.Write_Log('X_from_request_date = ' || to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));

1755: wsh_pr_picking_session.request_id);
1756: WSH_UTIL.Write_Log('X_sync_line_id = ' || to_char(p_sync_line_id));
1757: DBMS_SQL.Bind_Variable(sreq_cursor, ':X_sync_line_id',
1758: p_sync_line_id);
1759: WSH_UTIL.Write_Log('X_from_request_date = ' || to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
1760: DBMS_SQL.Bind_Variable(sreq_cursor, ':X_from_request_date',
1761: to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
1762: WSH_UTIL.Write_Log('X_to_request_date = ' || to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
1763: DBMS_SQL.Bind_Variable(sreq_cursor, ':X_to_request_date',

Line 1761: to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));

1757: DBMS_SQL.Bind_Variable(sreq_cursor, ':X_sync_line_id',
1758: p_sync_line_id);
1759: WSH_UTIL.Write_Log('X_from_request_date = ' || to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
1760: DBMS_SQL.Bind_Variable(sreq_cursor, ':X_from_request_date',
1761: to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
1762: WSH_UTIL.Write_Log('X_to_request_date = ' || to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
1763: DBMS_SQL.Bind_Variable(sreq_cursor, ':X_to_request_date',
1764: to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
1765: WSH_UTIL.Write_Log('X_inventory_item_id = ' || to_char(wsh_pr_picking_session.inventory_item_id));

Line 1762: WSH_UTIL.Write_Log('X_to_request_date = ' || to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));

1758: p_sync_line_id);
1759: WSH_UTIL.Write_Log('X_from_request_date = ' || to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
1760: DBMS_SQL.Bind_Variable(sreq_cursor, ':X_from_request_date',
1761: to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
1762: WSH_UTIL.Write_Log('X_to_request_date = ' || to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
1763: DBMS_SQL.Bind_Variable(sreq_cursor, ':X_to_request_date',
1764: to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
1765: WSH_UTIL.Write_Log('X_inventory_item_id = ' || to_char(wsh_pr_picking_session.inventory_item_id));
1766: DBMS_SQL.Bind_Variable(sreq_cursor, ':X_inventory_item_id',

Line 1764: to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));

1760: DBMS_SQL.Bind_Variable(sreq_cursor, ':X_from_request_date',
1761: to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
1762: WSH_UTIL.Write_Log('X_to_request_date = ' || to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
1763: DBMS_SQL.Bind_Variable(sreq_cursor, ':X_to_request_date',
1764: to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
1765: WSH_UTIL.Write_Log('X_inventory_item_id = ' || to_char(wsh_pr_picking_session.inventory_item_id));
1766: DBMS_SQL.Bind_Variable(sreq_cursor, ':X_inventory_item_id',
1767: wsh_pr_picking_session.inventory_item_id);
1768: WSH_UTIL.Write_Log('X_warehouse_id = ' || to_char(wsh_pr_picking_session.warehouse_id));

Line 1765: WSH_UTIL.Write_Log('X_inventory_item_id = ' || to_char(wsh_pr_picking_session.inventory_item_id));

1761: to_char(wsh_pr_picking_session.from_request_date,'YYYY/MM/DD HH24:MI:SS'));
1762: WSH_UTIL.Write_Log('X_to_request_date = ' || to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
1763: DBMS_SQL.Bind_Variable(sreq_cursor, ':X_to_request_date',
1764: to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
1765: WSH_UTIL.Write_Log('X_inventory_item_id = ' || to_char(wsh_pr_picking_session.inventory_item_id));
1766: DBMS_SQL.Bind_Variable(sreq_cursor, ':X_inventory_item_id',
1767: wsh_pr_picking_session.inventory_item_id);
1768: WSH_UTIL.Write_Log('X_warehouse_id = ' || to_char(wsh_pr_picking_session.warehouse_id));
1769: DBMS_SQL.Bind_Variable(sreq_cursor, ':X_warehouse_id',

Line 1767: wsh_pr_picking_session.inventory_item_id);

1763: DBMS_SQL.Bind_Variable(sreq_cursor, ':X_to_request_date',
1764: to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
1765: WSH_UTIL.Write_Log('X_inventory_item_id = ' || to_char(wsh_pr_picking_session.inventory_item_id));
1766: DBMS_SQL.Bind_Variable(sreq_cursor, ':X_inventory_item_id',
1767: wsh_pr_picking_session.inventory_item_id);
1768: WSH_UTIL.Write_Log('X_warehouse_id = ' || to_char(wsh_pr_picking_session.warehouse_id));
1769: DBMS_SQL.Bind_Variable(sreq_cursor, ':X_warehouse_id',
1770: wsh_pr_picking_session.warehouse_id);
1771: WSH_UTIL.Write_Log('X_from_sched_ship_date = ' || to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));

Line 1768: WSH_UTIL.Write_Log('X_warehouse_id = ' || to_char(wsh_pr_picking_session.warehouse_id));

1764: to_char(wsh_pr_picking_session.to_request_date,'YYYY/MM/DD HH24:MI:SS'));
1765: WSH_UTIL.Write_Log('X_inventory_item_id = ' || to_char(wsh_pr_picking_session.inventory_item_id));
1766: DBMS_SQL.Bind_Variable(sreq_cursor, ':X_inventory_item_id',
1767: wsh_pr_picking_session.inventory_item_id);
1768: WSH_UTIL.Write_Log('X_warehouse_id = ' || to_char(wsh_pr_picking_session.warehouse_id));
1769: DBMS_SQL.Bind_Variable(sreq_cursor, ':X_warehouse_id',
1770: wsh_pr_picking_session.warehouse_id);
1771: WSH_UTIL.Write_Log('X_from_sched_ship_date = ' || to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
1772: DBMS_SQL.Bind_Variable(sreq_cursor, ':X_from_sched_ship_date',

Line 1770: wsh_pr_picking_session.warehouse_id);

1766: DBMS_SQL.Bind_Variable(sreq_cursor, ':X_inventory_item_id',
1767: wsh_pr_picking_session.inventory_item_id);
1768: WSH_UTIL.Write_Log('X_warehouse_id = ' || to_char(wsh_pr_picking_session.warehouse_id));
1769: DBMS_SQL.Bind_Variable(sreq_cursor, ':X_warehouse_id',
1770: wsh_pr_picking_session.warehouse_id);
1771: WSH_UTIL.Write_Log('X_from_sched_ship_date = ' || to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
1772: DBMS_SQL.Bind_Variable(sreq_cursor, ':X_from_sched_ship_date',
1773: to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
1774: WSH_UTIL.Write_Log('X_to_sched_ship_date = ' || to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));

Line 1771: WSH_UTIL.Write_Log('X_from_sched_ship_date = ' || to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));

1767: wsh_pr_picking_session.inventory_item_id);
1768: WSH_UTIL.Write_Log('X_warehouse_id = ' || to_char(wsh_pr_picking_session.warehouse_id));
1769: DBMS_SQL.Bind_Variable(sreq_cursor, ':X_warehouse_id',
1770: wsh_pr_picking_session.warehouse_id);
1771: WSH_UTIL.Write_Log('X_from_sched_ship_date = ' || to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
1772: DBMS_SQL.Bind_Variable(sreq_cursor, ':X_from_sched_ship_date',
1773: to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
1774: WSH_UTIL.Write_Log('X_to_sched_ship_date = ' || to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
1775: DBMS_SQL.Bind_Variable(sreq_cursor, ':X_to_sched_ship_date',

Line 1773: to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));

1769: DBMS_SQL.Bind_Variable(sreq_cursor, ':X_warehouse_id',
1770: wsh_pr_picking_session.warehouse_id);
1771: WSH_UTIL.Write_Log('X_from_sched_ship_date = ' || to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
1772: DBMS_SQL.Bind_Variable(sreq_cursor, ':X_from_sched_ship_date',
1773: to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
1774: WSH_UTIL.Write_Log('X_to_sched_ship_date = ' || to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
1775: DBMS_SQL.Bind_Variable(sreq_cursor, ':X_to_sched_ship_date',
1776: to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
1777:

Line 1774: WSH_UTIL.Write_Log('X_to_sched_ship_date = ' || to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));

1770: wsh_pr_picking_session.warehouse_id);
1771: WSH_UTIL.Write_Log('X_from_sched_ship_date = ' || to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
1772: DBMS_SQL.Bind_Variable(sreq_cursor, ':X_from_sched_ship_date',
1773: to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
1774: WSH_UTIL.Write_Log('X_to_sched_ship_date = ' || to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
1775: DBMS_SQL.Bind_Variable(sreq_cursor, ':X_to_sched_ship_date',
1776: to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
1777:
1778: v_ignore := DBMS_SQL.Execute(sreq_cursor);

Line 1776: to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));

1772: DBMS_SQL.Bind_Variable(sreq_cursor, ':X_from_sched_ship_date',
1773: to_char(wsh_pr_picking_session.from_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
1774: WSH_UTIL.Write_Log('X_to_sched_ship_date = ' || to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
1775: DBMS_SQL.Bind_Variable(sreq_cursor, ':X_to_sched_ship_date',
1776: to_char(wsh_pr_picking_session.to_sched_ship_date,'YYYY/MM/DD HH24:MI:SS'));
1777:
1778: v_ignore := DBMS_SQL.Execute(sreq_cursor);
1779: WSH_UTIL.Write_Log('Updated ' || to_char(v_ignore) || ' lines in model');
1780: DBMS_SQL.Close_Cursor(sreq_cursor);