376: l_api_name CONSTANT VARCHAR2(30) := 'Complete_RMA_Order';
377: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
378: l_return_status VARCHAR2(1);
379:
380: l_header_rec OE_ORDER_PUB.header_rec_type;
381: l_header_val_rec OE_ORDER_PUB.header_val_rec_type;
382: l_header_adj_tbl OE_ORDER_PUB.header_adj_tbl_type;
383: l_header_adj_val_tbl OE_ORDER_PUB.header_adj_val_tbl_type;
384: l_header_price_att_tbl OE_ORDER_PUB.header_price_att_tbl_type;
377: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
378: l_return_status VARCHAR2(1);
379:
380: l_header_rec OE_ORDER_PUB.header_rec_type;
381: l_header_val_rec OE_ORDER_PUB.header_val_rec_type;
382: l_header_adj_tbl OE_ORDER_PUB.header_adj_tbl_type;
383: l_header_adj_val_tbl OE_ORDER_PUB.header_adj_val_tbl_type;
384: l_header_price_att_tbl OE_ORDER_PUB.header_price_att_tbl_type;
385: l_header_adj_att_tbl OE_ORDER_PUB.header_adj_att_tbl_type;
378: l_return_status VARCHAR2(1);
379:
380: l_header_rec OE_ORDER_PUB.header_rec_type;
381: l_header_val_rec OE_ORDER_PUB.header_val_rec_type;
382: l_header_adj_tbl OE_ORDER_PUB.header_adj_tbl_type;
383: l_header_adj_val_tbl OE_ORDER_PUB.header_adj_val_tbl_type;
384: l_header_price_att_tbl OE_ORDER_PUB.header_price_att_tbl_type;
385: l_header_adj_att_tbl OE_ORDER_PUB.header_adj_att_tbl_type;
386: l_header_adj_assoc_tbl OE_ORDER_PUB.header_adj_assoc_tbl_type;
379:
380: l_header_rec OE_ORDER_PUB.header_rec_type;
381: l_header_val_rec OE_ORDER_PUB.header_val_rec_type;
382: l_header_adj_tbl OE_ORDER_PUB.header_adj_tbl_type;
383: l_header_adj_val_tbl OE_ORDER_PUB.header_adj_val_tbl_type;
384: l_header_price_att_tbl OE_ORDER_PUB.header_price_att_tbl_type;
385: l_header_adj_att_tbl OE_ORDER_PUB.header_adj_att_tbl_type;
386: l_header_adj_assoc_tbl OE_ORDER_PUB.header_adj_assoc_tbl_type;
387: l_header_scredit_tbl OE_ORDER_PUB.header_scredit_tbl_type;
380: l_header_rec OE_ORDER_PUB.header_rec_type;
381: l_header_val_rec OE_ORDER_PUB.header_val_rec_type;
382: l_header_adj_tbl OE_ORDER_PUB.header_adj_tbl_type;
383: l_header_adj_val_tbl OE_ORDER_PUB.header_adj_val_tbl_type;
384: l_header_price_att_tbl OE_ORDER_PUB.header_price_att_tbl_type;
385: l_header_adj_att_tbl OE_ORDER_PUB.header_adj_att_tbl_type;
386: l_header_adj_assoc_tbl OE_ORDER_PUB.header_adj_assoc_tbl_type;
387: l_header_scredit_tbl OE_ORDER_PUB.header_scredit_tbl_type;
388: l_header_scredit_val_tbl OE_ORDER_PUB.header_scredit_val_tbl_type;
381: l_header_val_rec OE_ORDER_PUB.header_val_rec_type;
382: l_header_adj_tbl OE_ORDER_PUB.header_adj_tbl_type;
383: l_header_adj_val_tbl OE_ORDER_PUB.header_adj_val_tbl_type;
384: l_header_price_att_tbl OE_ORDER_PUB.header_price_att_tbl_type;
385: l_header_adj_att_tbl OE_ORDER_PUB.header_adj_att_tbl_type;
386: l_header_adj_assoc_tbl OE_ORDER_PUB.header_adj_assoc_tbl_type;
387: l_header_scredit_tbl OE_ORDER_PUB.header_scredit_tbl_type;
388: l_header_scredit_val_tbl OE_ORDER_PUB.header_scredit_val_tbl_type;
389:
382: l_header_adj_tbl OE_ORDER_PUB.header_adj_tbl_type;
383: l_header_adj_val_tbl OE_ORDER_PUB.header_adj_val_tbl_type;
384: l_header_price_att_tbl OE_ORDER_PUB.header_price_att_tbl_type;
385: l_header_adj_att_tbl OE_ORDER_PUB.header_adj_att_tbl_type;
386: l_header_adj_assoc_tbl OE_ORDER_PUB.header_adj_assoc_tbl_type;
387: l_header_scredit_tbl OE_ORDER_PUB.header_scredit_tbl_type;
388: l_header_scredit_val_tbl OE_ORDER_PUB.header_scredit_val_tbl_type;
389:
390: l_line_tbl OE_ORDER_PUB.line_tbl_type;
383: l_header_adj_val_tbl OE_ORDER_PUB.header_adj_val_tbl_type;
384: l_header_price_att_tbl OE_ORDER_PUB.header_price_att_tbl_type;
385: l_header_adj_att_tbl OE_ORDER_PUB.header_adj_att_tbl_type;
386: l_header_adj_assoc_tbl OE_ORDER_PUB.header_adj_assoc_tbl_type;
387: l_header_scredit_tbl OE_ORDER_PUB.header_scredit_tbl_type;
388: l_header_scredit_val_tbl OE_ORDER_PUB.header_scredit_val_tbl_type;
389:
390: l_line_tbl OE_ORDER_PUB.line_tbl_type;
391: l_line_val_tbl OE_ORDER_PUB.line_val_tbl_type;
384: l_header_price_att_tbl OE_ORDER_PUB.header_price_att_tbl_type;
385: l_header_adj_att_tbl OE_ORDER_PUB.header_adj_att_tbl_type;
386: l_header_adj_assoc_tbl OE_ORDER_PUB.header_adj_assoc_tbl_type;
387: l_header_scredit_tbl OE_ORDER_PUB.header_scredit_tbl_type;
388: l_header_scredit_val_tbl OE_ORDER_PUB.header_scredit_val_tbl_type;
389:
390: l_line_tbl OE_ORDER_PUB.line_tbl_type;
391: l_line_val_tbl OE_ORDER_PUB.line_val_tbl_type;
392: l_line_adj_tbl OE_ORDER_PUB.line_adj_tbl_type;
386: l_header_adj_assoc_tbl OE_ORDER_PUB.header_adj_assoc_tbl_type;
387: l_header_scredit_tbl OE_ORDER_PUB.header_scredit_tbl_type;
388: l_header_scredit_val_tbl OE_ORDER_PUB.header_scredit_val_tbl_type;
389:
390: l_line_tbl OE_ORDER_PUB.line_tbl_type;
391: l_line_val_tbl OE_ORDER_PUB.line_val_tbl_type;
392: l_line_adj_tbl OE_ORDER_PUB.line_adj_tbl_type;
393: l_line_adj_val_tbl OE_ORDER_PUB.line_adj_val_tbl_type;
394: l_line_price_att_tbl OE_ORDER_PUB.line_price_att_tbl_type;
387: l_header_scredit_tbl OE_ORDER_PUB.header_scredit_tbl_type;
388: l_header_scredit_val_tbl OE_ORDER_PUB.header_scredit_val_tbl_type;
389:
390: l_line_tbl OE_ORDER_PUB.line_tbl_type;
391: l_line_val_tbl OE_ORDER_PUB.line_val_tbl_type;
392: l_line_adj_tbl OE_ORDER_PUB.line_adj_tbl_type;
393: l_line_adj_val_tbl OE_ORDER_PUB.line_adj_val_tbl_type;
394: l_line_price_att_tbl OE_ORDER_PUB.line_price_att_tbl_type;
395: l_line_adj_att_tbl OE_ORDER_PUB.line_adj_att_tbl_type;
388: l_header_scredit_val_tbl OE_ORDER_PUB.header_scredit_val_tbl_type;
389:
390: l_line_tbl OE_ORDER_PUB.line_tbl_type;
391: l_line_val_tbl OE_ORDER_PUB.line_val_tbl_type;
392: l_line_adj_tbl OE_ORDER_PUB.line_adj_tbl_type;
393: l_line_adj_val_tbl OE_ORDER_PUB.line_adj_val_tbl_type;
394: l_line_price_att_tbl OE_ORDER_PUB.line_price_att_tbl_type;
395: l_line_adj_att_tbl OE_ORDER_PUB.line_adj_att_tbl_type;
396: l_line_adj_assoc_tbl OE_ORDER_PUB.line_adj_assoc_tbl_type;
389:
390: l_line_tbl OE_ORDER_PUB.line_tbl_type;
391: l_line_val_tbl OE_ORDER_PUB.line_val_tbl_type;
392: l_line_adj_tbl OE_ORDER_PUB.line_adj_tbl_type;
393: l_line_adj_val_tbl OE_ORDER_PUB.line_adj_val_tbl_type;
394: l_line_price_att_tbl OE_ORDER_PUB.line_price_att_tbl_type;
395: l_line_adj_att_tbl OE_ORDER_PUB.line_adj_att_tbl_type;
396: l_line_adj_assoc_tbl OE_ORDER_PUB.line_adj_assoc_tbl_type;
397: l_line_scredit_tbl OE_ORDER_PUB.line_scredit_tbl_type;
390: l_line_tbl OE_ORDER_PUB.line_tbl_type;
391: l_line_val_tbl OE_ORDER_PUB.line_val_tbl_type;
392: l_line_adj_tbl OE_ORDER_PUB.line_adj_tbl_type;
393: l_line_adj_val_tbl OE_ORDER_PUB.line_adj_val_tbl_type;
394: l_line_price_att_tbl OE_ORDER_PUB.line_price_att_tbl_type;
395: l_line_adj_att_tbl OE_ORDER_PUB.line_adj_att_tbl_type;
396: l_line_adj_assoc_tbl OE_ORDER_PUB.line_adj_assoc_tbl_type;
397: l_line_scredit_tbl OE_ORDER_PUB.line_scredit_tbl_type;
398: l_line_scredit_val_tbl OE_ORDER_PUB.line_scredit_val_tbl_type;
391: l_line_val_tbl OE_ORDER_PUB.line_val_tbl_type;
392: l_line_adj_tbl OE_ORDER_PUB.line_adj_tbl_type;
393: l_line_adj_val_tbl OE_ORDER_PUB.line_adj_val_tbl_type;
394: l_line_price_att_tbl OE_ORDER_PUB.line_price_att_tbl_type;
395: l_line_adj_att_tbl OE_ORDER_PUB.line_adj_att_tbl_type;
396: l_line_adj_assoc_tbl OE_ORDER_PUB.line_adj_assoc_tbl_type;
397: l_line_scredit_tbl OE_ORDER_PUB.line_scredit_tbl_type;
398: l_line_scredit_val_tbl OE_ORDER_PUB.line_scredit_val_tbl_type;
399: l_lot_serial_tbl OE_ORDER_PUB.lot_serial_tbl_type;
392: l_line_adj_tbl OE_ORDER_PUB.line_adj_tbl_type;
393: l_line_adj_val_tbl OE_ORDER_PUB.line_adj_val_tbl_type;
394: l_line_price_att_tbl OE_ORDER_PUB.line_price_att_tbl_type;
395: l_line_adj_att_tbl OE_ORDER_PUB.line_adj_att_tbl_type;
396: l_line_adj_assoc_tbl OE_ORDER_PUB.line_adj_assoc_tbl_type;
397: l_line_scredit_tbl OE_ORDER_PUB.line_scredit_tbl_type;
398: l_line_scredit_val_tbl OE_ORDER_PUB.line_scredit_val_tbl_type;
399: l_lot_serial_tbl OE_ORDER_PUB.lot_serial_tbl_type;
400: l_lot_serial_val_tbl OE_ORDER_PUB.lot_serial_val_tbl_type;
393: l_line_adj_val_tbl OE_ORDER_PUB.line_adj_val_tbl_type;
394: l_line_price_att_tbl OE_ORDER_PUB.line_price_att_tbl_type;
395: l_line_adj_att_tbl OE_ORDER_PUB.line_adj_att_tbl_type;
396: l_line_adj_assoc_tbl OE_ORDER_PUB.line_adj_assoc_tbl_type;
397: l_line_scredit_tbl OE_ORDER_PUB.line_scredit_tbl_type;
398: l_line_scredit_val_tbl OE_ORDER_PUB.line_scredit_val_tbl_type;
399: l_lot_serial_tbl OE_ORDER_PUB.lot_serial_tbl_type;
400: l_lot_serial_val_tbl OE_ORDER_PUB.lot_serial_val_tbl_type;
401: l_action_request_tbl OE_ORDER_PUB.request_tbl_type;
394: l_line_price_att_tbl OE_ORDER_PUB.line_price_att_tbl_type;
395: l_line_adj_att_tbl OE_ORDER_PUB.line_adj_att_tbl_type;
396: l_line_adj_assoc_tbl OE_ORDER_PUB.line_adj_assoc_tbl_type;
397: l_line_scredit_tbl OE_ORDER_PUB.line_scredit_tbl_type;
398: l_line_scredit_val_tbl OE_ORDER_PUB.line_scredit_val_tbl_type;
399: l_lot_serial_tbl OE_ORDER_PUB.lot_serial_tbl_type;
400: l_lot_serial_val_tbl OE_ORDER_PUB.lot_serial_val_tbl_type;
401: l_action_request_tbl OE_ORDER_PUB.request_tbl_type;
402:
395: l_line_adj_att_tbl OE_ORDER_PUB.line_adj_att_tbl_type;
396: l_line_adj_assoc_tbl OE_ORDER_PUB.line_adj_assoc_tbl_type;
397: l_line_scredit_tbl OE_ORDER_PUB.line_scredit_tbl_type;
398: l_line_scredit_val_tbl OE_ORDER_PUB.line_scredit_val_tbl_type;
399: l_lot_serial_tbl OE_ORDER_PUB.lot_serial_tbl_type;
400: l_lot_serial_val_tbl OE_ORDER_PUB.lot_serial_val_tbl_type;
401: l_action_request_tbl OE_ORDER_PUB.request_tbl_type;
402:
403: l_x_header_rec OE_ORDER_PUB.header_rec_type;
396: l_line_adj_assoc_tbl OE_ORDER_PUB.line_adj_assoc_tbl_type;
397: l_line_scredit_tbl OE_ORDER_PUB.line_scredit_tbl_type;
398: l_line_scredit_val_tbl OE_ORDER_PUB.line_scredit_val_tbl_type;
399: l_lot_serial_tbl OE_ORDER_PUB.lot_serial_tbl_type;
400: l_lot_serial_val_tbl OE_ORDER_PUB.lot_serial_val_tbl_type;
401: l_action_request_tbl OE_ORDER_PUB.request_tbl_type;
402:
403: l_x_header_rec OE_ORDER_PUB.header_rec_type;
404: l_x_header_val_rec OE_ORDER_PUB.header_val_rec_type;
397: l_line_scredit_tbl OE_ORDER_PUB.line_scredit_tbl_type;
398: l_line_scredit_val_tbl OE_ORDER_PUB.line_scredit_val_tbl_type;
399: l_lot_serial_tbl OE_ORDER_PUB.lot_serial_tbl_type;
400: l_lot_serial_val_tbl OE_ORDER_PUB.lot_serial_val_tbl_type;
401: l_action_request_tbl OE_ORDER_PUB.request_tbl_type;
402:
403: l_x_header_rec OE_ORDER_PUB.header_rec_type;
404: l_x_header_val_rec OE_ORDER_PUB.header_val_rec_type;
405: l_x_header_adj_tbl OE_ORDER_PUB.header_adj_tbl_type;
399: l_lot_serial_tbl OE_ORDER_PUB.lot_serial_tbl_type;
400: l_lot_serial_val_tbl OE_ORDER_PUB.lot_serial_val_tbl_type;
401: l_action_request_tbl OE_ORDER_PUB.request_tbl_type;
402:
403: l_x_header_rec OE_ORDER_PUB.header_rec_type;
404: l_x_header_val_rec OE_ORDER_PUB.header_val_rec_type;
405: l_x_header_adj_tbl OE_ORDER_PUB.header_adj_tbl_type;
406: l_x_header_adj_val_tbl OE_ORDER_PUB.header_adj_val_tbl_type;
407: l_x_header_price_att_tbl OE_ORDER_PUB.header_price_att_tbl_type;
400: l_lot_serial_val_tbl OE_ORDER_PUB.lot_serial_val_tbl_type;
401: l_action_request_tbl OE_ORDER_PUB.request_tbl_type;
402:
403: l_x_header_rec OE_ORDER_PUB.header_rec_type;
404: l_x_header_val_rec OE_ORDER_PUB.header_val_rec_type;
405: l_x_header_adj_tbl OE_ORDER_PUB.header_adj_tbl_type;
406: l_x_header_adj_val_tbl OE_ORDER_PUB.header_adj_val_tbl_type;
407: l_x_header_price_att_tbl OE_ORDER_PUB.header_price_att_tbl_type;
408: l_x_header_adj_att_tbl OE_ORDER_PUB.header_adj_att_tbl_type;
401: l_action_request_tbl OE_ORDER_PUB.request_tbl_type;
402:
403: l_x_header_rec OE_ORDER_PUB.header_rec_type;
404: l_x_header_val_rec OE_ORDER_PUB.header_val_rec_type;
405: l_x_header_adj_tbl OE_ORDER_PUB.header_adj_tbl_type;
406: l_x_header_adj_val_tbl OE_ORDER_PUB.header_adj_val_tbl_type;
407: l_x_header_price_att_tbl OE_ORDER_PUB.header_price_att_tbl_type;
408: l_x_header_adj_att_tbl OE_ORDER_PUB.header_adj_att_tbl_type;
409: l_x_header_adj_assoc_tbl OE_ORDER_PUB.header_adj_assoc_tbl_type;
402:
403: l_x_header_rec OE_ORDER_PUB.header_rec_type;
404: l_x_header_val_rec OE_ORDER_PUB.header_val_rec_type;
405: l_x_header_adj_tbl OE_ORDER_PUB.header_adj_tbl_type;
406: l_x_header_adj_val_tbl OE_ORDER_PUB.header_adj_val_tbl_type;
407: l_x_header_price_att_tbl OE_ORDER_PUB.header_price_att_tbl_type;
408: l_x_header_adj_att_tbl OE_ORDER_PUB.header_adj_att_tbl_type;
409: l_x_header_adj_assoc_tbl OE_ORDER_PUB.header_adj_assoc_tbl_type;
410: l_x_header_scredit_tbl OE_ORDER_PUB.header_scredit_tbl_type;
403: l_x_header_rec OE_ORDER_PUB.header_rec_type;
404: l_x_header_val_rec OE_ORDER_PUB.header_val_rec_type;
405: l_x_header_adj_tbl OE_ORDER_PUB.header_adj_tbl_type;
406: l_x_header_adj_val_tbl OE_ORDER_PUB.header_adj_val_tbl_type;
407: l_x_header_price_att_tbl OE_ORDER_PUB.header_price_att_tbl_type;
408: l_x_header_adj_att_tbl OE_ORDER_PUB.header_adj_att_tbl_type;
409: l_x_header_adj_assoc_tbl OE_ORDER_PUB.header_adj_assoc_tbl_type;
410: l_x_header_scredit_tbl OE_ORDER_PUB.header_scredit_tbl_type;
411: l_x_header_scredit_val_tbl OE_ORDER_PUB.header_scredit_val_tbl_type;
404: l_x_header_val_rec OE_ORDER_PUB.header_val_rec_type;
405: l_x_header_adj_tbl OE_ORDER_PUB.header_adj_tbl_type;
406: l_x_header_adj_val_tbl OE_ORDER_PUB.header_adj_val_tbl_type;
407: l_x_header_price_att_tbl OE_ORDER_PUB.header_price_att_tbl_type;
408: l_x_header_adj_att_tbl OE_ORDER_PUB.header_adj_att_tbl_type;
409: l_x_header_adj_assoc_tbl OE_ORDER_PUB.header_adj_assoc_tbl_type;
410: l_x_header_scredit_tbl OE_ORDER_PUB.header_scredit_tbl_type;
411: l_x_header_scredit_val_tbl OE_ORDER_PUB.header_scredit_val_tbl_type;
412:
405: l_x_header_adj_tbl OE_ORDER_PUB.header_adj_tbl_type;
406: l_x_header_adj_val_tbl OE_ORDER_PUB.header_adj_val_tbl_type;
407: l_x_header_price_att_tbl OE_ORDER_PUB.header_price_att_tbl_type;
408: l_x_header_adj_att_tbl OE_ORDER_PUB.header_adj_att_tbl_type;
409: l_x_header_adj_assoc_tbl OE_ORDER_PUB.header_adj_assoc_tbl_type;
410: l_x_header_scredit_tbl OE_ORDER_PUB.header_scredit_tbl_type;
411: l_x_header_scredit_val_tbl OE_ORDER_PUB.header_scredit_val_tbl_type;
412:
413: l_x_line_tbl OE_ORDER_PUB.line_tbl_type;
406: l_x_header_adj_val_tbl OE_ORDER_PUB.header_adj_val_tbl_type;
407: l_x_header_price_att_tbl OE_ORDER_PUB.header_price_att_tbl_type;
408: l_x_header_adj_att_tbl OE_ORDER_PUB.header_adj_att_tbl_type;
409: l_x_header_adj_assoc_tbl OE_ORDER_PUB.header_adj_assoc_tbl_type;
410: l_x_header_scredit_tbl OE_ORDER_PUB.header_scredit_tbl_type;
411: l_x_header_scredit_val_tbl OE_ORDER_PUB.header_scredit_val_tbl_type;
412:
413: l_x_line_tbl OE_ORDER_PUB.line_tbl_type;
414: l_x_line_val_tbl OE_ORDER_PUB.line_val_tbl_type;
407: l_x_header_price_att_tbl OE_ORDER_PUB.header_price_att_tbl_type;
408: l_x_header_adj_att_tbl OE_ORDER_PUB.header_adj_att_tbl_type;
409: l_x_header_adj_assoc_tbl OE_ORDER_PUB.header_adj_assoc_tbl_type;
410: l_x_header_scredit_tbl OE_ORDER_PUB.header_scredit_tbl_type;
411: l_x_header_scredit_val_tbl OE_ORDER_PUB.header_scredit_val_tbl_type;
412:
413: l_x_line_tbl OE_ORDER_PUB.line_tbl_type;
414: l_x_line_val_tbl OE_ORDER_PUB.line_val_tbl_type;
415: l_x_line_adj_tbl OE_ORDER_PUB.line_adj_tbl_type;
409: l_x_header_adj_assoc_tbl OE_ORDER_PUB.header_adj_assoc_tbl_type;
410: l_x_header_scredit_tbl OE_ORDER_PUB.header_scredit_tbl_type;
411: l_x_header_scredit_val_tbl OE_ORDER_PUB.header_scredit_val_tbl_type;
412:
413: l_x_line_tbl OE_ORDER_PUB.line_tbl_type;
414: l_x_line_val_tbl OE_ORDER_PUB.line_val_tbl_type;
415: l_x_line_adj_tbl OE_ORDER_PUB.line_adj_tbl_type;
416: l_x_line_adj_val_tbl OE_ORDER_PUB.line_adj_val_tbl_type;
417: l_x_line_price_att_tbl OE_ORDER_PUB.line_price_att_tbl_type;
410: l_x_header_scredit_tbl OE_ORDER_PUB.header_scredit_tbl_type;
411: l_x_header_scredit_val_tbl OE_ORDER_PUB.header_scredit_val_tbl_type;
412:
413: l_x_line_tbl OE_ORDER_PUB.line_tbl_type;
414: l_x_line_val_tbl OE_ORDER_PUB.line_val_tbl_type;
415: l_x_line_adj_tbl OE_ORDER_PUB.line_adj_tbl_type;
416: l_x_line_adj_val_tbl OE_ORDER_PUB.line_adj_val_tbl_type;
417: l_x_line_price_att_tbl OE_ORDER_PUB.line_price_att_tbl_type;
418: l_x_line_adj_att_tbl OE_ORDER_PUB.line_adj_att_tbl_type;
411: l_x_header_scredit_val_tbl OE_ORDER_PUB.header_scredit_val_tbl_type;
412:
413: l_x_line_tbl OE_ORDER_PUB.line_tbl_type;
414: l_x_line_val_tbl OE_ORDER_PUB.line_val_tbl_type;
415: l_x_line_adj_tbl OE_ORDER_PUB.line_adj_tbl_type;
416: l_x_line_adj_val_tbl OE_ORDER_PUB.line_adj_val_tbl_type;
417: l_x_line_price_att_tbl OE_ORDER_PUB.line_price_att_tbl_type;
418: l_x_line_adj_att_tbl OE_ORDER_PUB.line_adj_att_tbl_type;
419: l_x_line_adj_assoc_tbl OE_ORDER_PUB.line_adj_assoc_tbl_type;
412:
413: l_x_line_tbl OE_ORDER_PUB.line_tbl_type;
414: l_x_line_val_tbl OE_ORDER_PUB.line_val_tbl_type;
415: l_x_line_adj_tbl OE_ORDER_PUB.line_adj_tbl_type;
416: l_x_line_adj_val_tbl OE_ORDER_PUB.line_adj_val_tbl_type;
417: l_x_line_price_att_tbl OE_ORDER_PUB.line_price_att_tbl_type;
418: l_x_line_adj_att_tbl OE_ORDER_PUB.line_adj_att_tbl_type;
419: l_x_line_adj_assoc_tbl OE_ORDER_PUB.line_adj_assoc_tbl_type;
420: l_x_line_scredit_tbl OE_ORDER_PUB.line_scredit_tbl_type;
413: l_x_line_tbl OE_ORDER_PUB.line_tbl_type;
414: l_x_line_val_tbl OE_ORDER_PUB.line_val_tbl_type;
415: l_x_line_adj_tbl OE_ORDER_PUB.line_adj_tbl_type;
416: l_x_line_adj_val_tbl OE_ORDER_PUB.line_adj_val_tbl_type;
417: l_x_line_price_att_tbl OE_ORDER_PUB.line_price_att_tbl_type;
418: l_x_line_adj_att_tbl OE_ORDER_PUB.line_adj_att_tbl_type;
419: l_x_line_adj_assoc_tbl OE_ORDER_PUB.line_adj_assoc_tbl_type;
420: l_x_line_scredit_tbl OE_ORDER_PUB.line_scredit_tbl_type;
421: l_x_line_scredit_val_tbl OE_ORDER_PUB.line_scredit_val_tbl_type;
414: l_x_line_val_tbl OE_ORDER_PUB.line_val_tbl_type;
415: l_x_line_adj_tbl OE_ORDER_PUB.line_adj_tbl_type;
416: l_x_line_adj_val_tbl OE_ORDER_PUB.line_adj_val_tbl_type;
417: l_x_line_price_att_tbl OE_ORDER_PUB.line_price_att_tbl_type;
418: l_x_line_adj_att_tbl OE_ORDER_PUB.line_adj_att_tbl_type;
419: l_x_line_adj_assoc_tbl OE_ORDER_PUB.line_adj_assoc_tbl_type;
420: l_x_line_scredit_tbl OE_ORDER_PUB.line_scredit_tbl_type;
421: l_x_line_scredit_val_tbl OE_ORDER_PUB.line_scredit_val_tbl_type;
422: l_x_lot_serial_tbl OE_ORDER_PUB.lot_serial_tbl_type;
415: l_x_line_adj_tbl OE_ORDER_PUB.line_adj_tbl_type;
416: l_x_line_adj_val_tbl OE_ORDER_PUB.line_adj_val_tbl_type;
417: l_x_line_price_att_tbl OE_ORDER_PUB.line_price_att_tbl_type;
418: l_x_line_adj_att_tbl OE_ORDER_PUB.line_adj_att_tbl_type;
419: l_x_line_adj_assoc_tbl OE_ORDER_PUB.line_adj_assoc_tbl_type;
420: l_x_line_scredit_tbl OE_ORDER_PUB.line_scredit_tbl_type;
421: l_x_line_scredit_val_tbl OE_ORDER_PUB.line_scredit_val_tbl_type;
422: l_x_lot_serial_tbl OE_ORDER_PUB.lot_serial_tbl_type;
423: l_x_lot_serial_val_tbl OE_ORDER_PUB.lot_serial_val_tbl_type;
416: l_x_line_adj_val_tbl OE_ORDER_PUB.line_adj_val_tbl_type;
417: l_x_line_price_att_tbl OE_ORDER_PUB.line_price_att_tbl_type;
418: l_x_line_adj_att_tbl OE_ORDER_PUB.line_adj_att_tbl_type;
419: l_x_line_adj_assoc_tbl OE_ORDER_PUB.line_adj_assoc_tbl_type;
420: l_x_line_scredit_tbl OE_ORDER_PUB.line_scredit_tbl_type;
421: l_x_line_scredit_val_tbl OE_ORDER_PUB.line_scredit_val_tbl_type;
422: l_x_lot_serial_tbl OE_ORDER_PUB.lot_serial_tbl_type;
423: l_x_lot_serial_val_tbl OE_ORDER_PUB.lot_serial_val_tbl_type;
424: l_x_action_request_tbl OE_ORDER_PUB.request_tbl_type;
417: l_x_line_price_att_tbl OE_ORDER_PUB.line_price_att_tbl_type;
418: l_x_line_adj_att_tbl OE_ORDER_PUB.line_adj_att_tbl_type;
419: l_x_line_adj_assoc_tbl OE_ORDER_PUB.line_adj_assoc_tbl_type;
420: l_x_line_scredit_tbl OE_ORDER_PUB.line_scredit_tbl_type;
421: l_x_line_scredit_val_tbl OE_ORDER_PUB.line_scredit_val_tbl_type;
422: l_x_lot_serial_tbl OE_ORDER_PUB.lot_serial_tbl_type;
423: l_x_lot_serial_val_tbl OE_ORDER_PUB.lot_serial_val_tbl_type;
424: l_x_action_request_tbl OE_ORDER_PUB.request_tbl_type;
425:
418: l_x_line_adj_att_tbl OE_ORDER_PUB.line_adj_att_tbl_type;
419: l_x_line_adj_assoc_tbl OE_ORDER_PUB.line_adj_assoc_tbl_type;
420: l_x_line_scredit_tbl OE_ORDER_PUB.line_scredit_tbl_type;
421: l_x_line_scredit_val_tbl OE_ORDER_PUB.line_scredit_val_tbl_type;
422: l_x_lot_serial_tbl OE_ORDER_PUB.lot_serial_tbl_type;
423: l_x_lot_serial_val_tbl OE_ORDER_PUB.lot_serial_val_tbl_type;
424: l_x_action_request_tbl OE_ORDER_PUB.request_tbl_type;
425:
426: i NUMBER;
419: l_x_line_adj_assoc_tbl OE_ORDER_PUB.line_adj_assoc_tbl_type;
420: l_x_line_scredit_tbl OE_ORDER_PUB.line_scredit_tbl_type;
421: l_x_line_scredit_val_tbl OE_ORDER_PUB.line_scredit_val_tbl_type;
422: l_x_lot_serial_tbl OE_ORDER_PUB.lot_serial_tbl_type;
423: l_x_lot_serial_val_tbl OE_ORDER_PUB.lot_serial_val_tbl_type;
424: l_x_action_request_tbl OE_ORDER_PUB.request_tbl_type;
425:
426: i NUMBER;
427: l_adj_idx NUMBER := 1;
420: l_x_line_scredit_tbl OE_ORDER_PUB.line_scredit_tbl_type;
421: l_x_line_scredit_val_tbl OE_ORDER_PUB.line_scredit_val_tbl_type;
422: l_x_lot_serial_tbl OE_ORDER_PUB.lot_serial_tbl_type;
423: l_x_lot_serial_val_tbl OE_ORDER_PUB.lot_serial_val_tbl_type;
424: l_x_action_request_tbl OE_ORDER_PUB.request_tbl_type;
425:
426: i NUMBER;
427: l_adj_idx NUMBER := 1;
428: l_return_reson_code VARCHAR2(30);
520:
521: /*------------------------------------------------------*
522: | 1. Setting up header record
523: *------------------------------------------------------*/
524: l_header_rec := OE_ORDER_PUB.g_miss_header_rec;
525:
526: -- Bug4249629
527: l_header_rec.ordered_date :=
528: NVL(p_x_claim_rec.effective_date,p_x_claim_rec.settled_date);
575: i := p_claim_line_tbl.FIRST;
576: IF i IS NOT NULL THEN
577: LOOP
578: IF p_claim_line_tbl(i).item_id IS NOT NULL THEN
579: l_line_tbl(i) := OE_ORDER_PUB.g_miss_line_rec;
580: IF p_claim_line_tbl(i).source_object_class IN ('INVOICE', 'ORDER') AND
581: p_claim_line_tbl(i).source_object_id IS NOT NULL AND
582: p_claim_line_tbl(i).source_object_line_id IS NOT NULL THEN
583: IF p_claim_line_tbl(i).source_object_class = 'INVOICE' THEN
733: | 4. Query selling price of RMA created by TM
734: *------------------------------------------------------*/
735: i := l_x_line_tbl.FIRST;
736: IF i IS NOT NULL THEN
737: l_header_rec := OE_ORDER_PUB.g_miss_header_rec;
738: l_header_rec.header_id := l_x_header_rec.header_id;
739: -- [BEGIN OF BUG 3868264 FIXING]
740: l_header_rec.change_reason := 'SYSTEM';
741: -- [END OF BUG 3868264 FIXING]
763: RAISE FND_API.g_exc_error;
764: ELSE
765: l_rma_price_diff := l_rma_unit_price - p_claim_line_tbl(i).rate;
766:
767: l_line_adj_tbl(l_adj_idx) :=OE_ORDER_PUB.g_miss_line_adj_rec;
768:
769: l_line_adj_tbl(l_adj_idx).line_index := i;
770: l_line_adj_tbl(l_adj_idx).list_header_id := l_modifer_header_id;
771: l_line_adj_tbl(l_adj_idx).list_line_id := l_modifer_line_id;
943: l_api_name CONSTANT VARCHAR2(30) := 'Book_RMA_Order';
944: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
945: l_return_status VARCHAR2(1);
946:
947: l_header_rec OE_ORDER_PUB.header_rec_type;
948: l_header_val_rec OE_ORDER_PUB.header_val_rec_type;
949: l_header_adj_tbl OE_ORDER_PUB.header_adj_tbl_type;
950: l_header_adj_val_tbl OE_ORDER_PUB.header_adj_val_tbl_type;
951: l_header_price_att_tbl OE_ORDER_PUB.header_price_att_tbl_type;
944: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
945: l_return_status VARCHAR2(1);
946:
947: l_header_rec OE_ORDER_PUB.header_rec_type;
948: l_header_val_rec OE_ORDER_PUB.header_val_rec_type;
949: l_header_adj_tbl OE_ORDER_PUB.header_adj_tbl_type;
950: l_header_adj_val_tbl OE_ORDER_PUB.header_adj_val_tbl_type;
951: l_header_price_att_tbl OE_ORDER_PUB.header_price_att_tbl_type;
952: l_header_adj_att_tbl OE_ORDER_PUB.header_adj_att_tbl_type;
945: l_return_status VARCHAR2(1);
946:
947: l_header_rec OE_ORDER_PUB.header_rec_type;
948: l_header_val_rec OE_ORDER_PUB.header_val_rec_type;
949: l_header_adj_tbl OE_ORDER_PUB.header_adj_tbl_type;
950: l_header_adj_val_tbl OE_ORDER_PUB.header_adj_val_tbl_type;
951: l_header_price_att_tbl OE_ORDER_PUB.header_price_att_tbl_type;
952: l_header_adj_att_tbl OE_ORDER_PUB.header_adj_att_tbl_type;
953: l_header_adj_assoc_tbl OE_ORDER_PUB.header_adj_assoc_tbl_type;
946:
947: l_header_rec OE_ORDER_PUB.header_rec_type;
948: l_header_val_rec OE_ORDER_PUB.header_val_rec_type;
949: l_header_adj_tbl OE_ORDER_PUB.header_adj_tbl_type;
950: l_header_adj_val_tbl OE_ORDER_PUB.header_adj_val_tbl_type;
951: l_header_price_att_tbl OE_ORDER_PUB.header_price_att_tbl_type;
952: l_header_adj_att_tbl OE_ORDER_PUB.header_adj_att_tbl_type;
953: l_header_adj_assoc_tbl OE_ORDER_PUB.header_adj_assoc_tbl_type;
954: l_header_scredit_tbl OE_ORDER_PUB.header_scredit_tbl_type;
947: l_header_rec OE_ORDER_PUB.header_rec_type;
948: l_header_val_rec OE_ORDER_PUB.header_val_rec_type;
949: l_header_adj_tbl OE_ORDER_PUB.header_adj_tbl_type;
950: l_header_adj_val_tbl OE_ORDER_PUB.header_adj_val_tbl_type;
951: l_header_price_att_tbl OE_ORDER_PUB.header_price_att_tbl_type;
952: l_header_adj_att_tbl OE_ORDER_PUB.header_adj_att_tbl_type;
953: l_header_adj_assoc_tbl OE_ORDER_PUB.header_adj_assoc_tbl_type;
954: l_header_scredit_tbl OE_ORDER_PUB.header_scredit_tbl_type;
955: l_header_scredit_val_tbl OE_ORDER_PUB.header_scredit_val_tbl_type;
948: l_header_val_rec OE_ORDER_PUB.header_val_rec_type;
949: l_header_adj_tbl OE_ORDER_PUB.header_adj_tbl_type;
950: l_header_adj_val_tbl OE_ORDER_PUB.header_adj_val_tbl_type;
951: l_header_price_att_tbl OE_ORDER_PUB.header_price_att_tbl_type;
952: l_header_adj_att_tbl OE_ORDER_PUB.header_adj_att_tbl_type;
953: l_header_adj_assoc_tbl OE_ORDER_PUB.header_adj_assoc_tbl_type;
954: l_header_scredit_tbl OE_ORDER_PUB.header_scredit_tbl_type;
955: l_header_scredit_val_tbl OE_ORDER_PUB.header_scredit_val_tbl_type;
956:
949: l_header_adj_tbl OE_ORDER_PUB.header_adj_tbl_type;
950: l_header_adj_val_tbl OE_ORDER_PUB.header_adj_val_tbl_type;
951: l_header_price_att_tbl OE_ORDER_PUB.header_price_att_tbl_type;
952: l_header_adj_att_tbl OE_ORDER_PUB.header_adj_att_tbl_type;
953: l_header_adj_assoc_tbl OE_ORDER_PUB.header_adj_assoc_tbl_type;
954: l_header_scredit_tbl OE_ORDER_PUB.header_scredit_tbl_type;
955: l_header_scredit_val_tbl OE_ORDER_PUB.header_scredit_val_tbl_type;
956:
957: l_line_tbl OE_ORDER_PUB.line_tbl_type;
950: l_header_adj_val_tbl OE_ORDER_PUB.header_adj_val_tbl_type;
951: l_header_price_att_tbl OE_ORDER_PUB.header_price_att_tbl_type;
952: l_header_adj_att_tbl OE_ORDER_PUB.header_adj_att_tbl_type;
953: l_header_adj_assoc_tbl OE_ORDER_PUB.header_adj_assoc_tbl_type;
954: l_header_scredit_tbl OE_ORDER_PUB.header_scredit_tbl_type;
955: l_header_scredit_val_tbl OE_ORDER_PUB.header_scredit_val_tbl_type;
956:
957: l_line_tbl OE_ORDER_PUB.line_tbl_type;
958: l_line_val_tbl OE_ORDER_PUB.line_val_tbl_type;
951: l_header_price_att_tbl OE_ORDER_PUB.header_price_att_tbl_type;
952: l_header_adj_att_tbl OE_ORDER_PUB.header_adj_att_tbl_type;
953: l_header_adj_assoc_tbl OE_ORDER_PUB.header_adj_assoc_tbl_type;
954: l_header_scredit_tbl OE_ORDER_PUB.header_scredit_tbl_type;
955: l_header_scredit_val_tbl OE_ORDER_PUB.header_scredit_val_tbl_type;
956:
957: l_line_tbl OE_ORDER_PUB.line_tbl_type;
958: l_line_val_tbl OE_ORDER_PUB.line_val_tbl_type;
959: l_line_adj_tbl OE_ORDER_PUB.line_adj_tbl_type;
953: l_header_adj_assoc_tbl OE_ORDER_PUB.header_adj_assoc_tbl_type;
954: l_header_scredit_tbl OE_ORDER_PUB.header_scredit_tbl_type;
955: l_header_scredit_val_tbl OE_ORDER_PUB.header_scredit_val_tbl_type;
956:
957: l_line_tbl OE_ORDER_PUB.line_tbl_type;
958: l_line_val_tbl OE_ORDER_PUB.line_val_tbl_type;
959: l_line_adj_tbl OE_ORDER_PUB.line_adj_tbl_type;
960: l_line_adj_val_tbl OE_ORDER_PUB.line_adj_val_tbl_type;
961: l_line_price_att_tbl OE_ORDER_PUB.line_price_att_tbl_type;
954: l_header_scredit_tbl OE_ORDER_PUB.header_scredit_tbl_type;
955: l_header_scredit_val_tbl OE_ORDER_PUB.header_scredit_val_tbl_type;
956:
957: l_line_tbl OE_ORDER_PUB.line_tbl_type;
958: l_line_val_tbl OE_ORDER_PUB.line_val_tbl_type;
959: l_line_adj_tbl OE_ORDER_PUB.line_adj_tbl_type;
960: l_line_adj_val_tbl OE_ORDER_PUB.line_adj_val_tbl_type;
961: l_line_price_att_tbl OE_ORDER_PUB.line_price_att_tbl_type;
962: l_line_adj_att_tbl OE_ORDER_PUB.line_adj_att_tbl_type;
955: l_header_scredit_val_tbl OE_ORDER_PUB.header_scredit_val_tbl_type;
956:
957: l_line_tbl OE_ORDER_PUB.line_tbl_type;
958: l_line_val_tbl OE_ORDER_PUB.line_val_tbl_type;
959: l_line_adj_tbl OE_ORDER_PUB.line_adj_tbl_type;
960: l_line_adj_val_tbl OE_ORDER_PUB.line_adj_val_tbl_type;
961: l_line_price_att_tbl OE_ORDER_PUB.line_price_att_tbl_type;
962: l_line_adj_att_tbl OE_ORDER_PUB.line_adj_att_tbl_type;
963: l_line_adj_assoc_tbl OE_ORDER_PUB.line_adj_assoc_tbl_type;
956:
957: l_line_tbl OE_ORDER_PUB.line_tbl_type;
958: l_line_val_tbl OE_ORDER_PUB.line_val_tbl_type;
959: l_line_adj_tbl OE_ORDER_PUB.line_adj_tbl_type;
960: l_line_adj_val_tbl OE_ORDER_PUB.line_adj_val_tbl_type;
961: l_line_price_att_tbl OE_ORDER_PUB.line_price_att_tbl_type;
962: l_line_adj_att_tbl OE_ORDER_PUB.line_adj_att_tbl_type;
963: l_line_adj_assoc_tbl OE_ORDER_PUB.line_adj_assoc_tbl_type;
964: l_line_scredit_tbl OE_ORDER_PUB.line_scredit_tbl_type;
957: l_line_tbl OE_ORDER_PUB.line_tbl_type;
958: l_line_val_tbl OE_ORDER_PUB.line_val_tbl_type;
959: l_line_adj_tbl OE_ORDER_PUB.line_adj_tbl_type;
960: l_line_adj_val_tbl OE_ORDER_PUB.line_adj_val_tbl_type;
961: l_line_price_att_tbl OE_ORDER_PUB.line_price_att_tbl_type;
962: l_line_adj_att_tbl OE_ORDER_PUB.line_adj_att_tbl_type;
963: l_line_adj_assoc_tbl OE_ORDER_PUB.line_adj_assoc_tbl_type;
964: l_line_scredit_tbl OE_ORDER_PUB.line_scredit_tbl_type;
965: l_line_scredit_val_tbl OE_ORDER_PUB.line_scredit_val_tbl_type;
958: l_line_val_tbl OE_ORDER_PUB.line_val_tbl_type;
959: l_line_adj_tbl OE_ORDER_PUB.line_adj_tbl_type;
960: l_line_adj_val_tbl OE_ORDER_PUB.line_adj_val_tbl_type;
961: l_line_price_att_tbl OE_ORDER_PUB.line_price_att_tbl_type;
962: l_line_adj_att_tbl OE_ORDER_PUB.line_adj_att_tbl_type;
963: l_line_adj_assoc_tbl OE_ORDER_PUB.line_adj_assoc_tbl_type;
964: l_line_scredit_tbl OE_ORDER_PUB.line_scredit_tbl_type;
965: l_line_scredit_val_tbl OE_ORDER_PUB.line_scredit_val_tbl_type;
966: l_lot_serial_tbl OE_ORDER_PUB.lot_serial_tbl_type;
959: l_line_adj_tbl OE_ORDER_PUB.line_adj_tbl_type;
960: l_line_adj_val_tbl OE_ORDER_PUB.line_adj_val_tbl_type;
961: l_line_price_att_tbl OE_ORDER_PUB.line_price_att_tbl_type;
962: l_line_adj_att_tbl OE_ORDER_PUB.line_adj_att_tbl_type;
963: l_line_adj_assoc_tbl OE_ORDER_PUB.line_adj_assoc_tbl_type;
964: l_line_scredit_tbl OE_ORDER_PUB.line_scredit_tbl_type;
965: l_line_scredit_val_tbl OE_ORDER_PUB.line_scredit_val_tbl_type;
966: l_lot_serial_tbl OE_ORDER_PUB.lot_serial_tbl_type;
967: l_lot_serial_val_tbl OE_ORDER_PUB.lot_serial_val_tbl_type;
960: l_line_adj_val_tbl OE_ORDER_PUB.line_adj_val_tbl_type;
961: l_line_price_att_tbl OE_ORDER_PUB.line_price_att_tbl_type;
962: l_line_adj_att_tbl OE_ORDER_PUB.line_adj_att_tbl_type;
963: l_line_adj_assoc_tbl OE_ORDER_PUB.line_adj_assoc_tbl_type;
964: l_line_scredit_tbl OE_ORDER_PUB.line_scredit_tbl_type;
965: l_line_scredit_val_tbl OE_ORDER_PUB.line_scredit_val_tbl_type;
966: l_lot_serial_tbl OE_ORDER_PUB.lot_serial_tbl_type;
967: l_lot_serial_val_tbl OE_ORDER_PUB.lot_serial_val_tbl_type;
968: l_action_request_tbl OE_ORDER_PUB.request_tbl_type;
961: l_line_price_att_tbl OE_ORDER_PUB.line_price_att_tbl_type;
962: l_line_adj_att_tbl OE_ORDER_PUB.line_adj_att_tbl_type;
963: l_line_adj_assoc_tbl OE_ORDER_PUB.line_adj_assoc_tbl_type;
964: l_line_scredit_tbl OE_ORDER_PUB.line_scredit_tbl_type;
965: l_line_scredit_val_tbl OE_ORDER_PUB.line_scredit_val_tbl_type;
966: l_lot_serial_tbl OE_ORDER_PUB.lot_serial_tbl_type;
967: l_lot_serial_val_tbl OE_ORDER_PUB.lot_serial_val_tbl_type;
968: l_action_request_tbl OE_ORDER_PUB.request_tbl_type;
969:
962: l_line_adj_att_tbl OE_ORDER_PUB.line_adj_att_tbl_type;
963: l_line_adj_assoc_tbl OE_ORDER_PUB.line_adj_assoc_tbl_type;
964: l_line_scredit_tbl OE_ORDER_PUB.line_scredit_tbl_type;
965: l_line_scredit_val_tbl OE_ORDER_PUB.line_scredit_val_tbl_type;
966: l_lot_serial_tbl OE_ORDER_PUB.lot_serial_tbl_type;
967: l_lot_serial_val_tbl OE_ORDER_PUB.lot_serial_val_tbl_type;
968: l_action_request_tbl OE_ORDER_PUB.request_tbl_type;
969:
970: l_x_header_rec OE_ORDER_PUB.header_rec_type;
963: l_line_adj_assoc_tbl OE_ORDER_PUB.line_adj_assoc_tbl_type;
964: l_line_scredit_tbl OE_ORDER_PUB.line_scredit_tbl_type;
965: l_line_scredit_val_tbl OE_ORDER_PUB.line_scredit_val_tbl_type;
966: l_lot_serial_tbl OE_ORDER_PUB.lot_serial_tbl_type;
967: l_lot_serial_val_tbl OE_ORDER_PUB.lot_serial_val_tbl_type;
968: l_action_request_tbl OE_ORDER_PUB.request_tbl_type;
969:
970: l_x_header_rec OE_ORDER_PUB.header_rec_type;
971: l_x_header_val_rec OE_ORDER_PUB.header_val_rec_type;
964: l_line_scredit_tbl OE_ORDER_PUB.line_scredit_tbl_type;
965: l_line_scredit_val_tbl OE_ORDER_PUB.line_scredit_val_tbl_type;
966: l_lot_serial_tbl OE_ORDER_PUB.lot_serial_tbl_type;
967: l_lot_serial_val_tbl OE_ORDER_PUB.lot_serial_val_tbl_type;
968: l_action_request_tbl OE_ORDER_PUB.request_tbl_type;
969:
970: l_x_header_rec OE_ORDER_PUB.header_rec_type;
971: l_x_header_val_rec OE_ORDER_PUB.header_val_rec_type;
972: l_x_header_adj_tbl OE_ORDER_PUB.header_adj_tbl_type;
966: l_lot_serial_tbl OE_ORDER_PUB.lot_serial_tbl_type;
967: l_lot_serial_val_tbl OE_ORDER_PUB.lot_serial_val_tbl_type;
968: l_action_request_tbl OE_ORDER_PUB.request_tbl_type;
969:
970: l_x_header_rec OE_ORDER_PUB.header_rec_type;
971: l_x_header_val_rec OE_ORDER_PUB.header_val_rec_type;
972: l_x_header_adj_tbl OE_ORDER_PUB.header_adj_tbl_type;
973: l_x_header_adj_val_tbl OE_ORDER_PUB.header_adj_val_tbl_type;
974: l_x_header_price_att_tbl OE_ORDER_PUB.header_price_att_tbl_type;
967: l_lot_serial_val_tbl OE_ORDER_PUB.lot_serial_val_tbl_type;
968: l_action_request_tbl OE_ORDER_PUB.request_tbl_type;
969:
970: l_x_header_rec OE_ORDER_PUB.header_rec_type;
971: l_x_header_val_rec OE_ORDER_PUB.header_val_rec_type;
972: l_x_header_adj_tbl OE_ORDER_PUB.header_adj_tbl_type;
973: l_x_header_adj_val_tbl OE_ORDER_PUB.header_adj_val_tbl_type;
974: l_x_header_price_att_tbl OE_ORDER_PUB.header_price_att_tbl_type;
975: l_x_header_adj_att_tbl OE_ORDER_PUB.header_adj_att_tbl_type;
968: l_action_request_tbl OE_ORDER_PUB.request_tbl_type;
969:
970: l_x_header_rec OE_ORDER_PUB.header_rec_type;
971: l_x_header_val_rec OE_ORDER_PUB.header_val_rec_type;
972: l_x_header_adj_tbl OE_ORDER_PUB.header_adj_tbl_type;
973: l_x_header_adj_val_tbl OE_ORDER_PUB.header_adj_val_tbl_type;
974: l_x_header_price_att_tbl OE_ORDER_PUB.header_price_att_tbl_type;
975: l_x_header_adj_att_tbl OE_ORDER_PUB.header_adj_att_tbl_type;
976: l_x_header_adj_assoc_tbl OE_ORDER_PUB.header_adj_assoc_tbl_type;
969:
970: l_x_header_rec OE_ORDER_PUB.header_rec_type;
971: l_x_header_val_rec OE_ORDER_PUB.header_val_rec_type;
972: l_x_header_adj_tbl OE_ORDER_PUB.header_adj_tbl_type;
973: l_x_header_adj_val_tbl OE_ORDER_PUB.header_adj_val_tbl_type;
974: l_x_header_price_att_tbl OE_ORDER_PUB.header_price_att_tbl_type;
975: l_x_header_adj_att_tbl OE_ORDER_PUB.header_adj_att_tbl_type;
976: l_x_header_adj_assoc_tbl OE_ORDER_PUB.header_adj_assoc_tbl_type;
977: l_x_header_scredit_tbl OE_ORDER_PUB.header_scredit_tbl_type;
970: l_x_header_rec OE_ORDER_PUB.header_rec_type;
971: l_x_header_val_rec OE_ORDER_PUB.header_val_rec_type;
972: l_x_header_adj_tbl OE_ORDER_PUB.header_adj_tbl_type;
973: l_x_header_adj_val_tbl OE_ORDER_PUB.header_adj_val_tbl_type;
974: l_x_header_price_att_tbl OE_ORDER_PUB.header_price_att_tbl_type;
975: l_x_header_adj_att_tbl OE_ORDER_PUB.header_adj_att_tbl_type;
976: l_x_header_adj_assoc_tbl OE_ORDER_PUB.header_adj_assoc_tbl_type;
977: l_x_header_scredit_tbl OE_ORDER_PUB.header_scredit_tbl_type;
978: l_x_header_scredit_val_tbl OE_ORDER_PUB.header_scredit_val_tbl_type;
971: l_x_header_val_rec OE_ORDER_PUB.header_val_rec_type;
972: l_x_header_adj_tbl OE_ORDER_PUB.header_adj_tbl_type;
973: l_x_header_adj_val_tbl OE_ORDER_PUB.header_adj_val_tbl_type;
974: l_x_header_price_att_tbl OE_ORDER_PUB.header_price_att_tbl_type;
975: l_x_header_adj_att_tbl OE_ORDER_PUB.header_adj_att_tbl_type;
976: l_x_header_adj_assoc_tbl OE_ORDER_PUB.header_adj_assoc_tbl_type;
977: l_x_header_scredit_tbl OE_ORDER_PUB.header_scredit_tbl_type;
978: l_x_header_scredit_val_tbl OE_ORDER_PUB.header_scredit_val_tbl_type;
979:
972: l_x_header_adj_tbl OE_ORDER_PUB.header_adj_tbl_type;
973: l_x_header_adj_val_tbl OE_ORDER_PUB.header_adj_val_tbl_type;
974: l_x_header_price_att_tbl OE_ORDER_PUB.header_price_att_tbl_type;
975: l_x_header_adj_att_tbl OE_ORDER_PUB.header_adj_att_tbl_type;
976: l_x_header_adj_assoc_tbl OE_ORDER_PUB.header_adj_assoc_tbl_type;
977: l_x_header_scredit_tbl OE_ORDER_PUB.header_scredit_tbl_type;
978: l_x_header_scredit_val_tbl OE_ORDER_PUB.header_scredit_val_tbl_type;
979:
980: l_x_line_tbl OE_ORDER_PUB.line_tbl_type;
973: l_x_header_adj_val_tbl OE_ORDER_PUB.header_adj_val_tbl_type;
974: l_x_header_price_att_tbl OE_ORDER_PUB.header_price_att_tbl_type;
975: l_x_header_adj_att_tbl OE_ORDER_PUB.header_adj_att_tbl_type;
976: l_x_header_adj_assoc_tbl OE_ORDER_PUB.header_adj_assoc_tbl_type;
977: l_x_header_scredit_tbl OE_ORDER_PUB.header_scredit_tbl_type;
978: l_x_header_scredit_val_tbl OE_ORDER_PUB.header_scredit_val_tbl_type;
979:
980: l_x_line_tbl OE_ORDER_PUB.line_tbl_type;
981: l_x_line_val_tbl OE_ORDER_PUB.line_val_tbl_type;
974: l_x_header_price_att_tbl OE_ORDER_PUB.header_price_att_tbl_type;
975: l_x_header_adj_att_tbl OE_ORDER_PUB.header_adj_att_tbl_type;
976: l_x_header_adj_assoc_tbl OE_ORDER_PUB.header_adj_assoc_tbl_type;
977: l_x_header_scredit_tbl OE_ORDER_PUB.header_scredit_tbl_type;
978: l_x_header_scredit_val_tbl OE_ORDER_PUB.header_scredit_val_tbl_type;
979:
980: l_x_line_tbl OE_ORDER_PUB.line_tbl_type;
981: l_x_line_val_tbl OE_ORDER_PUB.line_val_tbl_type;
982: l_x_line_adj_tbl OE_ORDER_PUB.line_adj_tbl_type;
976: l_x_header_adj_assoc_tbl OE_ORDER_PUB.header_adj_assoc_tbl_type;
977: l_x_header_scredit_tbl OE_ORDER_PUB.header_scredit_tbl_type;
978: l_x_header_scredit_val_tbl OE_ORDER_PUB.header_scredit_val_tbl_type;
979:
980: l_x_line_tbl OE_ORDER_PUB.line_tbl_type;
981: l_x_line_val_tbl OE_ORDER_PUB.line_val_tbl_type;
982: l_x_line_adj_tbl OE_ORDER_PUB.line_adj_tbl_type;
983: l_x_line_adj_val_tbl OE_ORDER_PUB.line_adj_val_tbl_type;
984: l_x_line_price_att_tbl OE_ORDER_PUB.line_price_att_tbl_type;
977: l_x_header_scredit_tbl OE_ORDER_PUB.header_scredit_tbl_type;
978: l_x_header_scredit_val_tbl OE_ORDER_PUB.header_scredit_val_tbl_type;
979:
980: l_x_line_tbl OE_ORDER_PUB.line_tbl_type;
981: l_x_line_val_tbl OE_ORDER_PUB.line_val_tbl_type;
982: l_x_line_adj_tbl OE_ORDER_PUB.line_adj_tbl_type;
983: l_x_line_adj_val_tbl OE_ORDER_PUB.line_adj_val_tbl_type;
984: l_x_line_price_att_tbl OE_ORDER_PUB.line_price_att_tbl_type;
985: l_x_line_adj_att_tbl OE_ORDER_PUB.line_adj_att_tbl_type;
978: l_x_header_scredit_val_tbl OE_ORDER_PUB.header_scredit_val_tbl_type;
979:
980: l_x_line_tbl OE_ORDER_PUB.line_tbl_type;
981: l_x_line_val_tbl OE_ORDER_PUB.line_val_tbl_type;
982: l_x_line_adj_tbl OE_ORDER_PUB.line_adj_tbl_type;
983: l_x_line_adj_val_tbl OE_ORDER_PUB.line_adj_val_tbl_type;
984: l_x_line_price_att_tbl OE_ORDER_PUB.line_price_att_tbl_type;
985: l_x_line_adj_att_tbl OE_ORDER_PUB.line_adj_att_tbl_type;
986: l_x_line_adj_assoc_tbl OE_ORDER_PUB.line_adj_assoc_tbl_type;
979:
980: l_x_line_tbl OE_ORDER_PUB.line_tbl_type;
981: l_x_line_val_tbl OE_ORDER_PUB.line_val_tbl_type;
982: l_x_line_adj_tbl OE_ORDER_PUB.line_adj_tbl_type;
983: l_x_line_adj_val_tbl OE_ORDER_PUB.line_adj_val_tbl_type;
984: l_x_line_price_att_tbl OE_ORDER_PUB.line_price_att_tbl_type;
985: l_x_line_adj_att_tbl OE_ORDER_PUB.line_adj_att_tbl_type;
986: l_x_line_adj_assoc_tbl OE_ORDER_PUB.line_adj_assoc_tbl_type;
987: l_x_line_scredit_tbl OE_ORDER_PUB.line_scredit_tbl_type;
980: l_x_line_tbl OE_ORDER_PUB.line_tbl_type;
981: l_x_line_val_tbl OE_ORDER_PUB.line_val_tbl_type;
982: l_x_line_adj_tbl OE_ORDER_PUB.line_adj_tbl_type;
983: l_x_line_adj_val_tbl OE_ORDER_PUB.line_adj_val_tbl_type;
984: l_x_line_price_att_tbl OE_ORDER_PUB.line_price_att_tbl_type;
985: l_x_line_adj_att_tbl OE_ORDER_PUB.line_adj_att_tbl_type;
986: l_x_line_adj_assoc_tbl OE_ORDER_PUB.line_adj_assoc_tbl_type;
987: l_x_line_scredit_tbl OE_ORDER_PUB.line_scredit_tbl_type;
988: l_x_line_scredit_val_tbl OE_ORDER_PUB.line_scredit_val_tbl_type;
981: l_x_line_val_tbl OE_ORDER_PUB.line_val_tbl_type;
982: l_x_line_adj_tbl OE_ORDER_PUB.line_adj_tbl_type;
983: l_x_line_adj_val_tbl OE_ORDER_PUB.line_adj_val_tbl_type;
984: l_x_line_price_att_tbl OE_ORDER_PUB.line_price_att_tbl_type;
985: l_x_line_adj_att_tbl OE_ORDER_PUB.line_adj_att_tbl_type;
986: l_x_line_adj_assoc_tbl OE_ORDER_PUB.line_adj_assoc_tbl_type;
987: l_x_line_scredit_tbl OE_ORDER_PUB.line_scredit_tbl_type;
988: l_x_line_scredit_val_tbl OE_ORDER_PUB.line_scredit_val_tbl_type;
989: l_x_lot_serial_tbl OE_ORDER_PUB.lot_serial_tbl_type;
982: l_x_line_adj_tbl OE_ORDER_PUB.line_adj_tbl_type;
983: l_x_line_adj_val_tbl OE_ORDER_PUB.line_adj_val_tbl_type;
984: l_x_line_price_att_tbl OE_ORDER_PUB.line_price_att_tbl_type;
985: l_x_line_adj_att_tbl OE_ORDER_PUB.line_adj_att_tbl_type;
986: l_x_line_adj_assoc_tbl OE_ORDER_PUB.line_adj_assoc_tbl_type;
987: l_x_line_scredit_tbl OE_ORDER_PUB.line_scredit_tbl_type;
988: l_x_line_scredit_val_tbl OE_ORDER_PUB.line_scredit_val_tbl_type;
989: l_x_lot_serial_tbl OE_ORDER_PUB.lot_serial_tbl_type;
990: l_x_lot_serial_val_tbl OE_ORDER_PUB.lot_serial_val_tbl_type;
983: l_x_line_adj_val_tbl OE_ORDER_PUB.line_adj_val_tbl_type;
984: l_x_line_price_att_tbl OE_ORDER_PUB.line_price_att_tbl_type;
985: l_x_line_adj_att_tbl OE_ORDER_PUB.line_adj_att_tbl_type;
986: l_x_line_adj_assoc_tbl OE_ORDER_PUB.line_adj_assoc_tbl_type;
987: l_x_line_scredit_tbl OE_ORDER_PUB.line_scredit_tbl_type;
988: l_x_line_scredit_val_tbl OE_ORDER_PUB.line_scredit_val_tbl_type;
989: l_x_lot_serial_tbl OE_ORDER_PUB.lot_serial_tbl_type;
990: l_x_lot_serial_val_tbl OE_ORDER_PUB.lot_serial_val_tbl_type;
991: l_x_action_request_tbl OE_ORDER_PUB.request_tbl_type;
984: l_x_line_price_att_tbl OE_ORDER_PUB.line_price_att_tbl_type;
985: l_x_line_adj_att_tbl OE_ORDER_PUB.line_adj_att_tbl_type;
986: l_x_line_adj_assoc_tbl OE_ORDER_PUB.line_adj_assoc_tbl_type;
987: l_x_line_scredit_tbl OE_ORDER_PUB.line_scredit_tbl_type;
988: l_x_line_scredit_val_tbl OE_ORDER_PUB.line_scredit_val_tbl_type;
989: l_x_lot_serial_tbl OE_ORDER_PUB.lot_serial_tbl_type;
990: l_x_lot_serial_val_tbl OE_ORDER_PUB.lot_serial_val_tbl_type;
991: l_x_action_request_tbl OE_ORDER_PUB.request_tbl_type;
992:
985: l_x_line_adj_att_tbl OE_ORDER_PUB.line_adj_att_tbl_type;
986: l_x_line_adj_assoc_tbl OE_ORDER_PUB.line_adj_assoc_tbl_type;
987: l_x_line_scredit_tbl OE_ORDER_PUB.line_scredit_tbl_type;
988: l_x_line_scredit_val_tbl OE_ORDER_PUB.line_scredit_val_tbl_type;
989: l_x_lot_serial_tbl OE_ORDER_PUB.lot_serial_tbl_type;
990: l_x_lot_serial_val_tbl OE_ORDER_PUB.lot_serial_val_tbl_type;
991: l_x_action_request_tbl OE_ORDER_PUB.request_tbl_type;
992:
993: i NUMBER;
986: l_x_line_adj_assoc_tbl OE_ORDER_PUB.line_adj_assoc_tbl_type;
987: l_x_line_scredit_tbl OE_ORDER_PUB.line_scredit_tbl_type;
988: l_x_line_scredit_val_tbl OE_ORDER_PUB.line_scredit_val_tbl_type;
989: l_x_lot_serial_tbl OE_ORDER_PUB.lot_serial_tbl_type;
990: l_x_lot_serial_val_tbl OE_ORDER_PUB.lot_serial_val_tbl_type;
991: l_x_action_request_tbl OE_ORDER_PUB.request_tbl_type;
992:
993: i NUMBER;
994: l_oe_msg_count NUMBER;
987: l_x_line_scredit_tbl OE_ORDER_PUB.line_scredit_tbl_type;
988: l_x_line_scredit_val_tbl OE_ORDER_PUB.line_scredit_val_tbl_type;
989: l_x_lot_serial_tbl OE_ORDER_PUB.lot_serial_tbl_type;
990: l_x_lot_serial_val_tbl OE_ORDER_PUB.lot_serial_val_tbl_type;
991: l_x_action_request_tbl OE_ORDER_PUB.request_tbl_type;
992:
993: i NUMBER;
994: l_oe_msg_count NUMBER;
995: l_oe_msg_data VARCHAR2(2000);
1007: ------------------------ start -------------------------
1008: /*------------------------------------------------------*
1009: | Book RMA order
1010: *------------------------------------------------------*/
1011: l_action_request_tbl(1) := OE_ORDER_PUB.g_miss_request_rec;
1012: l_action_request_tbl(1).request_type := OE_GLOBALS.g_book_order;
1013: l_action_request_tbl(1).entity_code := OE_GLOBALS.g_entity_header;
1014: --l_action_request_tbl(1).entity_id := l_x_header_rec.header_id;
1015: l_action_request_tbl(1).entity_id := p_claim_rec.payment_reference_id;