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
739: | 4. Query selling price of RMA created by TM
740: *------------------------------------------------------*/
741: i := l_x_line_tbl.FIRST;
742: IF i IS NOT NULL THEN
743: l_header_rec := OE_ORDER_PUB.g_miss_header_rec;
744: l_header_rec.header_id := l_x_header_rec.header_id;
745: -- [BEGIN OF BUG 3868264 FIXING]
746: l_header_rec.change_reason := 'SYSTEM';
747: -- [END OF BUG 3868264 FIXING]
769: RAISE FND_API.g_exc_error;
770: ELSE
771: l_rma_price_diff := l_rma_unit_price - p_claim_line_tbl(i).rate;
772:
773: l_line_adj_tbl(l_adj_idx) :=OE_ORDER_PUB.g_miss_line_adj_rec;
774:
775: l_line_adj_tbl(l_adj_idx).line_index := i;
776: l_line_adj_tbl(l_adj_idx).list_header_id := l_modifer_header_id;
777: l_line_adj_tbl(l_adj_idx).list_line_id := l_modifer_line_id;
949: l_api_name CONSTANT VARCHAR2(30) := 'Book_RMA_Order';
950: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
951: l_return_status VARCHAR2(1);
952:
953: l_header_rec OE_ORDER_PUB.header_rec_type;
954: l_header_val_rec OE_ORDER_PUB.header_val_rec_type;
955: l_header_adj_tbl OE_ORDER_PUB.header_adj_tbl_type;
956: l_header_adj_val_tbl OE_ORDER_PUB.header_adj_val_tbl_type;
957: l_header_price_att_tbl OE_ORDER_PUB.header_price_att_tbl_type;
950: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
951: l_return_status VARCHAR2(1);
952:
953: l_header_rec OE_ORDER_PUB.header_rec_type;
954: l_header_val_rec OE_ORDER_PUB.header_val_rec_type;
955: l_header_adj_tbl OE_ORDER_PUB.header_adj_tbl_type;
956: l_header_adj_val_tbl OE_ORDER_PUB.header_adj_val_tbl_type;
957: l_header_price_att_tbl OE_ORDER_PUB.header_price_att_tbl_type;
958: l_header_adj_att_tbl OE_ORDER_PUB.header_adj_att_tbl_type;
951: l_return_status VARCHAR2(1);
952:
953: l_header_rec OE_ORDER_PUB.header_rec_type;
954: l_header_val_rec OE_ORDER_PUB.header_val_rec_type;
955: l_header_adj_tbl OE_ORDER_PUB.header_adj_tbl_type;
956: l_header_adj_val_tbl OE_ORDER_PUB.header_adj_val_tbl_type;
957: l_header_price_att_tbl OE_ORDER_PUB.header_price_att_tbl_type;
958: l_header_adj_att_tbl OE_ORDER_PUB.header_adj_att_tbl_type;
959: l_header_adj_assoc_tbl OE_ORDER_PUB.header_adj_assoc_tbl_type;
952:
953: l_header_rec OE_ORDER_PUB.header_rec_type;
954: l_header_val_rec OE_ORDER_PUB.header_val_rec_type;
955: l_header_adj_tbl OE_ORDER_PUB.header_adj_tbl_type;
956: l_header_adj_val_tbl OE_ORDER_PUB.header_adj_val_tbl_type;
957: l_header_price_att_tbl OE_ORDER_PUB.header_price_att_tbl_type;
958: l_header_adj_att_tbl OE_ORDER_PUB.header_adj_att_tbl_type;
959: l_header_adj_assoc_tbl OE_ORDER_PUB.header_adj_assoc_tbl_type;
960: l_header_scredit_tbl OE_ORDER_PUB.header_scredit_tbl_type;
953: l_header_rec OE_ORDER_PUB.header_rec_type;
954: l_header_val_rec OE_ORDER_PUB.header_val_rec_type;
955: l_header_adj_tbl OE_ORDER_PUB.header_adj_tbl_type;
956: l_header_adj_val_tbl OE_ORDER_PUB.header_adj_val_tbl_type;
957: l_header_price_att_tbl OE_ORDER_PUB.header_price_att_tbl_type;
958: l_header_adj_att_tbl OE_ORDER_PUB.header_adj_att_tbl_type;
959: l_header_adj_assoc_tbl OE_ORDER_PUB.header_adj_assoc_tbl_type;
960: l_header_scredit_tbl OE_ORDER_PUB.header_scredit_tbl_type;
961: l_header_scredit_val_tbl OE_ORDER_PUB.header_scredit_val_tbl_type;
954: l_header_val_rec OE_ORDER_PUB.header_val_rec_type;
955: l_header_adj_tbl OE_ORDER_PUB.header_adj_tbl_type;
956: l_header_adj_val_tbl OE_ORDER_PUB.header_adj_val_tbl_type;
957: l_header_price_att_tbl OE_ORDER_PUB.header_price_att_tbl_type;
958: l_header_adj_att_tbl OE_ORDER_PUB.header_adj_att_tbl_type;
959: l_header_adj_assoc_tbl OE_ORDER_PUB.header_adj_assoc_tbl_type;
960: l_header_scredit_tbl OE_ORDER_PUB.header_scredit_tbl_type;
961: l_header_scredit_val_tbl OE_ORDER_PUB.header_scredit_val_tbl_type;
962:
955: l_header_adj_tbl OE_ORDER_PUB.header_adj_tbl_type;
956: l_header_adj_val_tbl OE_ORDER_PUB.header_adj_val_tbl_type;
957: l_header_price_att_tbl OE_ORDER_PUB.header_price_att_tbl_type;
958: l_header_adj_att_tbl OE_ORDER_PUB.header_adj_att_tbl_type;
959: l_header_adj_assoc_tbl OE_ORDER_PUB.header_adj_assoc_tbl_type;
960: l_header_scredit_tbl OE_ORDER_PUB.header_scredit_tbl_type;
961: l_header_scredit_val_tbl OE_ORDER_PUB.header_scredit_val_tbl_type;
962:
963: l_line_tbl OE_ORDER_PUB.line_tbl_type;
956: l_header_adj_val_tbl OE_ORDER_PUB.header_adj_val_tbl_type;
957: l_header_price_att_tbl OE_ORDER_PUB.header_price_att_tbl_type;
958: l_header_adj_att_tbl OE_ORDER_PUB.header_adj_att_tbl_type;
959: l_header_adj_assoc_tbl OE_ORDER_PUB.header_adj_assoc_tbl_type;
960: l_header_scredit_tbl OE_ORDER_PUB.header_scredit_tbl_type;
961: l_header_scredit_val_tbl OE_ORDER_PUB.header_scredit_val_tbl_type;
962:
963: l_line_tbl OE_ORDER_PUB.line_tbl_type;
964: l_line_val_tbl OE_ORDER_PUB.line_val_tbl_type;
957: l_header_price_att_tbl OE_ORDER_PUB.header_price_att_tbl_type;
958: l_header_adj_att_tbl OE_ORDER_PUB.header_adj_att_tbl_type;
959: l_header_adj_assoc_tbl OE_ORDER_PUB.header_adj_assoc_tbl_type;
960: l_header_scredit_tbl OE_ORDER_PUB.header_scredit_tbl_type;
961: l_header_scredit_val_tbl OE_ORDER_PUB.header_scredit_val_tbl_type;
962:
963: l_line_tbl OE_ORDER_PUB.line_tbl_type;
964: l_line_val_tbl OE_ORDER_PUB.line_val_tbl_type;
965: l_line_adj_tbl OE_ORDER_PUB.line_adj_tbl_type;
959: l_header_adj_assoc_tbl OE_ORDER_PUB.header_adj_assoc_tbl_type;
960: l_header_scredit_tbl OE_ORDER_PUB.header_scredit_tbl_type;
961: l_header_scredit_val_tbl OE_ORDER_PUB.header_scredit_val_tbl_type;
962:
963: l_line_tbl OE_ORDER_PUB.line_tbl_type;
964: l_line_val_tbl OE_ORDER_PUB.line_val_tbl_type;
965: l_line_adj_tbl OE_ORDER_PUB.line_adj_tbl_type;
966: l_line_adj_val_tbl OE_ORDER_PUB.line_adj_val_tbl_type;
967: l_line_price_att_tbl OE_ORDER_PUB.line_price_att_tbl_type;
960: l_header_scredit_tbl OE_ORDER_PUB.header_scredit_tbl_type;
961: l_header_scredit_val_tbl OE_ORDER_PUB.header_scredit_val_tbl_type;
962:
963: l_line_tbl OE_ORDER_PUB.line_tbl_type;
964: l_line_val_tbl OE_ORDER_PUB.line_val_tbl_type;
965: l_line_adj_tbl OE_ORDER_PUB.line_adj_tbl_type;
966: l_line_adj_val_tbl OE_ORDER_PUB.line_adj_val_tbl_type;
967: l_line_price_att_tbl OE_ORDER_PUB.line_price_att_tbl_type;
968: l_line_adj_att_tbl OE_ORDER_PUB.line_adj_att_tbl_type;
961: l_header_scredit_val_tbl OE_ORDER_PUB.header_scredit_val_tbl_type;
962:
963: l_line_tbl OE_ORDER_PUB.line_tbl_type;
964: l_line_val_tbl OE_ORDER_PUB.line_val_tbl_type;
965: l_line_adj_tbl OE_ORDER_PUB.line_adj_tbl_type;
966: l_line_adj_val_tbl OE_ORDER_PUB.line_adj_val_tbl_type;
967: l_line_price_att_tbl OE_ORDER_PUB.line_price_att_tbl_type;
968: l_line_adj_att_tbl OE_ORDER_PUB.line_adj_att_tbl_type;
969: l_line_adj_assoc_tbl OE_ORDER_PUB.line_adj_assoc_tbl_type;
962:
963: l_line_tbl OE_ORDER_PUB.line_tbl_type;
964: l_line_val_tbl OE_ORDER_PUB.line_val_tbl_type;
965: l_line_adj_tbl OE_ORDER_PUB.line_adj_tbl_type;
966: l_line_adj_val_tbl OE_ORDER_PUB.line_adj_val_tbl_type;
967: l_line_price_att_tbl OE_ORDER_PUB.line_price_att_tbl_type;
968: l_line_adj_att_tbl OE_ORDER_PUB.line_adj_att_tbl_type;
969: l_line_adj_assoc_tbl OE_ORDER_PUB.line_adj_assoc_tbl_type;
970: l_line_scredit_tbl OE_ORDER_PUB.line_scredit_tbl_type;
963: l_line_tbl OE_ORDER_PUB.line_tbl_type;
964: l_line_val_tbl OE_ORDER_PUB.line_val_tbl_type;
965: l_line_adj_tbl OE_ORDER_PUB.line_adj_tbl_type;
966: l_line_adj_val_tbl OE_ORDER_PUB.line_adj_val_tbl_type;
967: l_line_price_att_tbl OE_ORDER_PUB.line_price_att_tbl_type;
968: l_line_adj_att_tbl OE_ORDER_PUB.line_adj_att_tbl_type;
969: l_line_adj_assoc_tbl OE_ORDER_PUB.line_adj_assoc_tbl_type;
970: l_line_scredit_tbl OE_ORDER_PUB.line_scredit_tbl_type;
971: l_line_scredit_val_tbl OE_ORDER_PUB.line_scredit_val_tbl_type;
964: l_line_val_tbl OE_ORDER_PUB.line_val_tbl_type;
965: l_line_adj_tbl OE_ORDER_PUB.line_adj_tbl_type;
966: l_line_adj_val_tbl OE_ORDER_PUB.line_adj_val_tbl_type;
967: l_line_price_att_tbl OE_ORDER_PUB.line_price_att_tbl_type;
968: l_line_adj_att_tbl OE_ORDER_PUB.line_adj_att_tbl_type;
969: l_line_adj_assoc_tbl OE_ORDER_PUB.line_adj_assoc_tbl_type;
970: l_line_scredit_tbl OE_ORDER_PUB.line_scredit_tbl_type;
971: l_line_scredit_val_tbl OE_ORDER_PUB.line_scredit_val_tbl_type;
972: l_lot_serial_tbl OE_ORDER_PUB.lot_serial_tbl_type;
965: l_line_adj_tbl OE_ORDER_PUB.line_adj_tbl_type;
966: l_line_adj_val_tbl OE_ORDER_PUB.line_adj_val_tbl_type;
967: l_line_price_att_tbl OE_ORDER_PUB.line_price_att_tbl_type;
968: l_line_adj_att_tbl OE_ORDER_PUB.line_adj_att_tbl_type;
969: l_line_adj_assoc_tbl OE_ORDER_PUB.line_adj_assoc_tbl_type;
970: l_line_scredit_tbl OE_ORDER_PUB.line_scredit_tbl_type;
971: l_line_scredit_val_tbl OE_ORDER_PUB.line_scredit_val_tbl_type;
972: l_lot_serial_tbl OE_ORDER_PUB.lot_serial_tbl_type;
973: l_lot_serial_val_tbl OE_ORDER_PUB.lot_serial_val_tbl_type;
966: l_line_adj_val_tbl OE_ORDER_PUB.line_adj_val_tbl_type;
967: l_line_price_att_tbl OE_ORDER_PUB.line_price_att_tbl_type;
968: l_line_adj_att_tbl OE_ORDER_PUB.line_adj_att_tbl_type;
969: l_line_adj_assoc_tbl OE_ORDER_PUB.line_adj_assoc_tbl_type;
970: l_line_scredit_tbl OE_ORDER_PUB.line_scredit_tbl_type;
971: l_line_scredit_val_tbl OE_ORDER_PUB.line_scredit_val_tbl_type;
972: l_lot_serial_tbl OE_ORDER_PUB.lot_serial_tbl_type;
973: l_lot_serial_val_tbl OE_ORDER_PUB.lot_serial_val_tbl_type;
974: l_action_request_tbl OE_ORDER_PUB.request_tbl_type;
967: l_line_price_att_tbl OE_ORDER_PUB.line_price_att_tbl_type;
968: l_line_adj_att_tbl OE_ORDER_PUB.line_adj_att_tbl_type;
969: l_line_adj_assoc_tbl OE_ORDER_PUB.line_adj_assoc_tbl_type;
970: l_line_scredit_tbl OE_ORDER_PUB.line_scredit_tbl_type;
971: l_line_scredit_val_tbl OE_ORDER_PUB.line_scredit_val_tbl_type;
972: l_lot_serial_tbl OE_ORDER_PUB.lot_serial_tbl_type;
973: l_lot_serial_val_tbl OE_ORDER_PUB.lot_serial_val_tbl_type;
974: l_action_request_tbl OE_ORDER_PUB.request_tbl_type;
975:
968: l_line_adj_att_tbl OE_ORDER_PUB.line_adj_att_tbl_type;
969: l_line_adj_assoc_tbl OE_ORDER_PUB.line_adj_assoc_tbl_type;
970: l_line_scredit_tbl OE_ORDER_PUB.line_scredit_tbl_type;
971: l_line_scredit_val_tbl OE_ORDER_PUB.line_scredit_val_tbl_type;
972: l_lot_serial_tbl OE_ORDER_PUB.lot_serial_tbl_type;
973: l_lot_serial_val_tbl OE_ORDER_PUB.lot_serial_val_tbl_type;
974: l_action_request_tbl OE_ORDER_PUB.request_tbl_type;
975:
976: l_x_header_rec OE_ORDER_PUB.header_rec_type;
969: l_line_adj_assoc_tbl OE_ORDER_PUB.line_adj_assoc_tbl_type;
970: l_line_scredit_tbl OE_ORDER_PUB.line_scredit_tbl_type;
971: l_line_scredit_val_tbl OE_ORDER_PUB.line_scredit_val_tbl_type;
972: l_lot_serial_tbl OE_ORDER_PUB.lot_serial_tbl_type;
973: l_lot_serial_val_tbl OE_ORDER_PUB.lot_serial_val_tbl_type;
974: l_action_request_tbl OE_ORDER_PUB.request_tbl_type;
975:
976: l_x_header_rec OE_ORDER_PUB.header_rec_type;
977: l_x_header_val_rec OE_ORDER_PUB.header_val_rec_type;
970: l_line_scredit_tbl OE_ORDER_PUB.line_scredit_tbl_type;
971: l_line_scredit_val_tbl OE_ORDER_PUB.line_scredit_val_tbl_type;
972: l_lot_serial_tbl OE_ORDER_PUB.lot_serial_tbl_type;
973: l_lot_serial_val_tbl OE_ORDER_PUB.lot_serial_val_tbl_type;
974: l_action_request_tbl OE_ORDER_PUB.request_tbl_type;
975:
976: l_x_header_rec OE_ORDER_PUB.header_rec_type;
977: l_x_header_val_rec OE_ORDER_PUB.header_val_rec_type;
978: l_x_header_adj_tbl OE_ORDER_PUB.header_adj_tbl_type;
972: l_lot_serial_tbl OE_ORDER_PUB.lot_serial_tbl_type;
973: l_lot_serial_val_tbl OE_ORDER_PUB.lot_serial_val_tbl_type;
974: l_action_request_tbl OE_ORDER_PUB.request_tbl_type;
975:
976: l_x_header_rec OE_ORDER_PUB.header_rec_type;
977: l_x_header_val_rec OE_ORDER_PUB.header_val_rec_type;
978: l_x_header_adj_tbl OE_ORDER_PUB.header_adj_tbl_type;
979: l_x_header_adj_val_tbl OE_ORDER_PUB.header_adj_val_tbl_type;
980: l_x_header_price_att_tbl OE_ORDER_PUB.header_price_att_tbl_type;
973: l_lot_serial_val_tbl OE_ORDER_PUB.lot_serial_val_tbl_type;
974: l_action_request_tbl OE_ORDER_PUB.request_tbl_type;
975:
976: l_x_header_rec OE_ORDER_PUB.header_rec_type;
977: l_x_header_val_rec OE_ORDER_PUB.header_val_rec_type;
978: l_x_header_adj_tbl OE_ORDER_PUB.header_adj_tbl_type;
979: l_x_header_adj_val_tbl OE_ORDER_PUB.header_adj_val_tbl_type;
980: l_x_header_price_att_tbl OE_ORDER_PUB.header_price_att_tbl_type;
981: l_x_header_adj_att_tbl OE_ORDER_PUB.header_adj_att_tbl_type;
974: l_action_request_tbl OE_ORDER_PUB.request_tbl_type;
975:
976: l_x_header_rec OE_ORDER_PUB.header_rec_type;
977: l_x_header_val_rec OE_ORDER_PUB.header_val_rec_type;
978: l_x_header_adj_tbl OE_ORDER_PUB.header_adj_tbl_type;
979: l_x_header_adj_val_tbl OE_ORDER_PUB.header_adj_val_tbl_type;
980: l_x_header_price_att_tbl OE_ORDER_PUB.header_price_att_tbl_type;
981: l_x_header_adj_att_tbl OE_ORDER_PUB.header_adj_att_tbl_type;
982: l_x_header_adj_assoc_tbl OE_ORDER_PUB.header_adj_assoc_tbl_type;
975:
976: l_x_header_rec OE_ORDER_PUB.header_rec_type;
977: l_x_header_val_rec OE_ORDER_PUB.header_val_rec_type;
978: l_x_header_adj_tbl OE_ORDER_PUB.header_adj_tbl_type;
979: l_x_header_adj_val_tbl OE_ORDER_PUB.header_adj_val_tbl_type;
980: l_x_header_price_att_tbl OE_ORDER_PUB.header_price_att_tbl_type;
981: l_x_header_adj_att_tbl OE_ORDER_PUB.header_adj_att_tbl_type;
982: l_x_header_adj_assoc_tbl OE_ORDER_PUB.header_adj_assoc_tbl_type;
983: l_x_header_scredit_tbl OE_ORDER_PUB.header_scredit_tbl_type;
976: l_x_header_rec OE_ORDER_PUB.header_rec_type;
977: l_x_header_val_rec OE_ORDER_PUB.header_val_rec_type;
978: l_x_header_adj_tbl OE_ORDER_PUB.header_adj_tbl_type;
979: l_x_header_adj_val_tbl OE_ORDER_PUB.header_adj_val_tbl_type;
980: l_x_header_price_att_tbl OE_ORDER_PUB.header_price_att_tbl_type;
981: l_x_header_adj_att_tbl OE_ORDER_PUB.header_adj_att_tbl_type;
982: l_x_header_adj_assoc_tbl OE_ORDER_PUB.header_adj_assoc_tbl_type;
983: l_x_header_scredit_tbl OE_ORDER_PUB.header_scredit_tbl_type;
984: l_x_header_scredit_val_tbl OE_ORDER_PUB.header_scredit_val_tbl_type;
977: l_x_header_val_rec OE_ORDER_PUB.header_val_rec_type;
978: l_x_header_adj_tbl OE_ORDER_PUB.header_adj_tbl_type;
979: l_x_header_adj_val_tbl OE_ORDER_PUB.header_adj_val_tbl_type;
980: l_x_header_price_att_tbl OE_ORDER_PUB.header_price_att_tbl_type;
981: l_x_header_adj_att_tbl OE_ORDER_PUB.header_adj_att_tbl_type;
982: l_x_header_adj_assoc_tbl OE_ORDER_PUB.header_adj_assoc_tbl_type;
983: l_x_header_scredit_tbl OE_ORDER_PUB.header_scredit_tbl_type;
984: l_x_header_scredit_val_tbl OE_ORDER_PUB.header_scredit_val_tbl_type;
985:
978: l_x_header_adj_tbl OE_ORDER_PUB.header_adj_tbl_type;
979: l_x_header_adj_val_tbl OE_ORDER_PUB.header_adj_val_tbl_type;
980: l_x_header_price_att_tbl OE_ORDER_PUB.header_price_att_tbl_type;
981: l_x_header_adj_att_tbl OE_ORDER_PUB.header_adj_att_tbl_type;
982: l_x_header_adj_assoc_tbl OE_ORDER_PUB.header_adj_assoc_tbl_type;
983: l_x_header_scredit_tbl OE_ORDER_PUB.header_scredit_tbl_type;
984: l_x_header_scredit_val_tbl OE_ORDER_PUB.header_scredit_val_tbl_type;
985:
986: l_x_line_tbl OE_ORDER_PUB.line_tbl_type;
979: l_x_header_adj_val_tbl OE_ORDER_PUB.header_adj_val_tbl_type;
980: l_x_header_price_att_tbl OE_ORDER_PUB.header_price_att_tbl_type;
981: l_x_header_adj_att_tbl OE_ORDER_PUB.header_adj_att_tbl_type;
982: l_x_header_adj_assoc_tbl OE_ORDER_PUB.header_adj_assoc_tbl_type;
983: l_x_header_scredit_tbl OE_ORDER_PUB.header_scredit_tbl_type;
984: l_x_header_scredit_val_tbl OE_ORDER_PUB.header_scredit_val_tbl_type;
985:
986: l_x_line_tbl OE_ORDER_PUB.line_tbl_type;
987: l_x_line_val_tbl OE_ORDER_PUB.line_val_tbl_type;
980: l_x_header_price_att_tbl OE_ORDER_PUB.header_price_att_tbl_type;
981: l_x_header_adj_att_tbl OE_ORDER_PUB.header_adj_att_tbl_type;
982: l_x_header_adj_assoc_tbl OE_ORDER_PUB.header_adj_assoc_tbl_type;
983: l_x_header_scredit_tbl OE_ORDER_PUB.header_scredit_tbl_type;
984: l_x_header_scredit_val_tbl OE_ORDER_PUB.header_scredit_val_tbl_type;
985:
986: l_x_line_tbl OE_ORDER_PUB.line_tbl_type;
987: l_x_line_val_tbl OE_ORDER_PUB.line_val_tbl_type;
988: l_x_line_adj_tbl OE_ORDER_PUB.line_adj_tbl_type;
982: l_x_header_adj_assoc_tbl OE_ORDER_PUB.header_adj_assoc_tbl_type;
983: l_x_header_scredit_tbl OE_ORDER_PUB.header_scredit_tbl_type;
984: l_x_header_scredit_val_tbl OE_ORDER_PUB.header_scredit_val_tbl_type;
985:
986: l_x_line_tbl OE_ORDER_PUB.line_tbl_type;
987: l_x_line_val_tbl OE_ORDER_PUB.line_val_tbl_type;
988: l_x_line_adj_tbl OE_ORDER_PUB.line_adj_tbl_type;
989: l_x_line_adj_val_tbl OE_ORDER_PUB.line_adj_val_tbl_type;
990: l_x_line_price_att_tbl OE_ORDER_PUB.line_price_att_tbl_type;
983: l_x_header_scredit_tbl OE_ORDER_PUB.header_scredit_tbl_type;
984: l_x_header_scredit_val_tbl OE_ORDER_PUB.header_scredit_val_tbl_type;
985:
986: l_x_line_tbl OE_ORDER_PUB.line_tbl_type;
987: l_x_line_val_tbl OE_ORDER_PUB.line_val_tbl_type;
988: l_x_line_adj_tbl OE_ORDER_PUB.line_adj_tbl_type;
989: l_x_line_adj_val_tbl OE_ORDER_PUB.line_adj_val_tbl_type;
990: l_x_line_price_att_tbl OE_ORDER_PUB.line_price_att_tbl_type;
991: l_x_line_adj_att_tbl OE_ORDER_PUB.line_adj_att_tbl_type;
984: l_x_header_scredit_val_tbl OE_ORDER_PUB.header_scredit_val_tbl_type;
985:
986: l_x_line_tbl OE_ORDER_PUB.line_tbl_type;
987: l_x_line_val_tbl OE_ORDER_PUB.line_val_tbl_type;
988: l_x_line_adj_tbl OE_ORDER_PUB.line_adj_tbl_type;
989: l_x_line_adj_val_tbl OE_ORDER_PUB.line_adj_val_tbl_type;
990: l_x_line_price_att_tbl OE_ORDER_PUB.line_price_att_tbl_type;
991: l_x_line_adj_att_tbl OE_ORDER_PUB.line_adj_att_tbl_type;
992: l_x_line_adj_assoc_tbl OE_ORDER_PUB.line_adj_assoc_tbl_type;
985:
986: l_x_line_tbl OE_ORDER_PUB.line_tbl_type;
987: l_x_line_val_tbl OE_ORDER_PUB.line_val_tbl_type;
988: l_x_line_adj_tbl OE_ORDER_PUB.line_adj_tbl_type;
989: l_x_line_adj_val_tbl OE_ORDER_PUB.line_adj_val_tbl_type;
990: l_x_line_price_att_tbl OE_ORDER_PUB.line_price_att_tbl_type;
991: l_x_line_adj_att_tbl OE_ORDER_PUB.line_adj_att_tbl_type;
992: l_x_line_adj_assoc_tbl OE_ORDER_PUB.line_adj_assoc_tbl_type;
993: l_x_line_scredit_tbl OE_ORDER_PUB.line_scredit_tbl_type;
986: l_x_line_tbl OE_ORDER_PUB.line_tbl_type;
987: l_x_line_val_tbl OE_ORDER_PUB.line_val_tbl_type;
988: l_x_line_adj_tbl OE_ORDER_PUB.line_adj_tbl_type;
989: l_x_line_adj_val_tbl OE_ORDER_PUB.line_adj_val_tbl_type;
990: l_x_line_price_att_tbl OE_ORDER_PUB.line_price_att_tbl_type;
991: l_x_line_adj_att_tbl OE_ORDER_PUB.line_adj_att_tbl_type;
992: l_x_line_adj_assoc_tbl OE_ORDER_PUB.line_adj_assoc_tbl_type;
993: l_x_line_scredit_tbl OE_ORDER_PUB.line_scredit_tbl_type;
994: l_x_line_scredit_val_tbl OE_ORDER_PUB.line_scredit_val_tbl_type;
987: l_x_line_val_tbl OE_ORDER_PUB.line_val_tbl_type;
988: l_x_line_adj_tbl OE_ORDER_PUB.line_adj_tbl_type;
989: l_x_line_adj_val_tbl OE_ORDER_PUB.line_adj_val_tbl_type;
990: l_x_line_price_att_tbl OE_ORDER_PUB.line_price_att_tbl_type;
991: l_x_line_adj_att_tbl OE_ORDER_PUB.line_adj_att_tbl_type;
992: l_x_line_adj_assoc_tbl OE_ORDER_PUB.line_adj_assoc_tbl_type;
993: l_x_line_scredit_tbl OE_ORDER_PUB.line_scredit_tbl_type;
994: l_x_line_scredit_val_tbl OE_ORDER_PUB.line_scredit_val_tbl_type;
995: l_x_lot_serial_tbl OE_ORDER_PUB.lot_serial_tbl_type;
988: l_x_line_adj_tbl OE_ORDER_PUB.line_adj_tbl_type;
989: l_x_line_adj_val_tbl OE_ORDER_PUB.line_adj_val_tbl_type;
990: l_x_line_price_att_tbl OE_ORDER_PUB.line_price_att_tbl_type;
991: l_x_line_adj_att_tbl OE_ORDER_PUB.line_adj_att_tbl_type;
992: l_x_line_adj_assoc_tbl OE_ORDER_PUB.line_adj_assoc_tbl_type;
993: l_x_line_scredit_tbl OE_ORDER_PUB.line_scredit_tbl_type;
994: l_x_line_scredit_val_tbl OE_ORDER_PUB.line_scredit_val_tbl_type;
995: l_x_lot_serial_tbl OE_ORDER_PUB.lot_serial_tbl_type;
996: l_x_lot_serial_val_tbl OE_ORDER_PUB.lot_serial_val_tbl_type;
989: l_x_line_adj_val_tbl OE_ORDER_PUB.line_adj_val_tbl_type;
990: l_x_line_price_att_tbl OE_ORDER_PUB.line_price_att_tbl_type;
991: l_x_line_adj_att_tbl OE_ORDER_PUB.line_adj_att_tbl_type;
992: l_x_line_adj_assoc_tbl OE_ORDER_PUB.line_adj_assoc_tbl_type;
993: l_x_line_scredit_tbl OE_ORDER_PUB.line_scredit_tbl_type;
994: l_x_line_scredit_val_tbl OE_ORDER_PUB.line_scredit_val_tbl_type;
995: l_x_lot_serial_tbl OE_ORDER_PUB.lot_serial_tbl_type;
996: l_x_lot_serial_val_tbl OE_ORDER_PUB.lot_serial_val_tbl_type;
997: l_x_action_request_tbl OE_ORDER_PUB.request_tbl_type;
990: l_x_line_price_att_tbl OE_ORDER_PUB.line_price_att_tbl_type;
991: l_x_line_adj_att_tbl OE_ORDER_PUB.line_adj_att_tbl_type;
992: l_x_line_adj_assoc_tbl OE_ORDER_PUB.line_adj_assoc_tbl_type;
993: l_x_line_scredit_tbl OE_ORDER_PUB.line_scredit_tbl_type;
994: l_x_line_scredit_val_tbl OE_ORDER_PUB.line_scredit_val_tbl_type;
995: l_x_lot_serial_tbl OE_ORDER_PUB.lot_serial_tbl_type;
996: l_x_lot_serial_val_tbl OE_ORDER_PUB.lot_serial_val_tbl_type;
997: l_x_action_request_tbl OE_ORDER_PUB.request_tbl_type;
998:
991: l_x_line_adj_att_tbl OE_ORDER_PUB.line_adj_att_tbl_type;
992: l_x_line_adj_assoc_tbl OE_ORDER_PUB.line_adj_assoc_tbl_type;
993: l_x_line_scredit_tbl OE_ORDER_PUB.line_scredit_tbl_type;
994: l_x_line_scredit_val_tbl OE_ORDER_PUB.line_scredit_val_tbl_type;
995: l_x_lot_serial_tbl OE_ORDER_PUB.lot_serial_tbl_type;
996: l_x_lot_serial_val_tbl OE_ORDER_PUB.lot_serial_val_tbl_type;
997: l_x_action_request_tbl OE_ORDER_PUB.request_tbl_type;
998:
999: i NUMBER;
992: l_x_line_adj_assoc_tbl OE_ORDER_PUB.line_adj_assoc_tbl_type;
993: l_x_line_scredit_tbl OE_ORDER_PUB.line_scredit_tbl_type;
994: l_x_line_scredit_val_tbl OE_ORDER_PUB.line_scredit_val_tbl_type;
995: l_x_lot_serial_tbl OE_ORDER_PUB.lot_serial_tbl_type;
996: l_x_lot_serial_val_tbl OE_ORDER_PUB.lot_serial_val_tbl_type;
997: l_x_action_request_tbl OE_ORDER_PUB.request_tbl_type;
998:
999: i NUMBER;
1000: l_oe_msg_count NUMBER;
993: l_x_line_scredit_tbl OE_ORDER_PUB.line_scredit_tbl_type;
994: l_x_line_scredit_val_tbl OE_ORDER_PUB.line_scredit_val_tbl_type;
995: l_x_lot_serial_tbl OE_ORDER_PUB.lot_serial_tbl_type;
996: l_x_lot_serial_val_tbl OE_ORDER_PUB.lot_serial_val_tbl_type;
997: l_x_action_request_tbl OE_ORDER_PUB.request_tbl_type;
998:
999: i NUMBER;
1000: l_oe_msg_count NUMBER;
1001: l_oe_msg_data VARCHAR2(2000);
1013: ------------------------ start -------------------------
1014: /*------------------------------------------------------*
1015: | Book RMA order
1016: *------------------------------------------------------*/
1017: l_action_request_tbl(1) := OE_ORDER_PUB.g_miss_request_rec;
1018: l_action_request_tbl(1).request_type := OE_GLOBALS.g_book_order;
1019: l_action_request_tbl(1).entity_code := OE_GLOBALS.g_entity_header;
1020: --l_action_request_tbl(1).entity_id := l_x_header_rec.header_id;
1021: l_action_request_tbl(1).entity_id := p_claim_rec.payment_reference_id;