DBA Data[Home] [Help]

APPS.CSI_RMA_FULFILL_PUB dependencies on OE_ORDER_LINES_ALL

Line 50: FROM oe_order_lines_all oel ,

46: INTO x_rma_line_rec.source_line_ref,
47: x_rma_line_rec.source_line_ref_id,
48: x_rma_line_rec.source_header_ref,
49: x_rma_line_rec.source_header_ref_id
50: FROM oe_order_lines_all oel ,
51: oe_order_headers_all oeh
52: WHERE oeh.header_id = oel.header_id
53: AND oel.line_id = p_rma_line_id;
54:

Line 159: l_src_txn_table varchar2(30) := 'OE_ORDER_LINES_ALL';

155: l_api_name varchar2(30) := 'rma_fulfillment';
156:
157: l_txn_line_id number;
158: l_txn_sub_type_id number ;
159: l_src_txn_table varchar2(30) := 'OE_ORDER_LINES_ALL';
160: l_txn_type_id number := 54;
161: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
162:
163: l_g_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;

Line 179: l_rma_line_rec oe_order_lines_all%rowtype;

175: l_g_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
176:
177: l_party_site_id number;
178:
179: l_rma_line_rec oe_order_lines_all%rowtype;
180: l_rma_header_rec oe_order_headers_all%rowtype;
181:
182: l_processing_status varchar2(30);
183:

Line 246: FROM oe_order_lines_all oel, oe_order_headers_all oeh

242: l_rma_line_rec.item_type_code, l_rma_line_rec.shippable_flag,
243: l_rma_line_rec.org_id, l_rma_line_rec.ordered_quantity,
244: l_rma_line_rec.fulfilled_quantity, l_rma_line_rec.fulfillment_date,
245: l_rma_line_rec.line_category_code
246: FROM oe_order_lines_all oel, oe_order_headers_all oeh
247: WHERE line_id = p_rma_line_id
248: AND oel.header_id = oeh.header_id;
249: EXCEPTION
250: WHEN no_data_found THEN

Line 550: AND source_transaction_table = 'OE_ORDER_LINES_ALL';

546:
547: UPDATE csi_t_transaction_lines
548: SET processing_status = 'ERROR'
549: WHERE source_transaction_id = p_rma_line_id
550: AND source_transaction_table = 'OE_ORDER_LINES_ALL';
551:
552: csi_utl_pkg.update_txn_line_dtl (
553: p_source_trx_id => p_rma_line_id,
554: p_source_trx_table => 'OE_ORDER_LINES_ALL',

Line 554: p_source_trx_table => 'OE_ORDER_LINES_ALL',

550: AND source_transaction_table = 'OE_ORDER_LINES_ALL';
551:
552: csi_utl_pkg.update_txn_line_dtl (
553: p_source_trx_id => p_rma_line_id,
554: p_source_trx_table => 'OE_ORDER_LINES_ALL',
555: p_api_name => l_api_name,
556: p_error_message => l_error_message );
557:
558: WHEN others THEN

Line 574: AND source_transaction_table = 'OE_ORDER_LINES_ALL';

570:
571: UPDATE csi_t_transaction_lines
572: SET processing_status = 'ERROR'
573: WHERE source_transaction_id = p_rma_line_id
574: AND source_transaction_table = 'OE_ORDER_LINES_ALL';
575:
576: csi_utl_pkg.update_txn_line_dtl (
577: p_source_trx_id => p_rma_line_id,
578: p_source_trx_table => 'OE_ORDER_LINES_ALL',

Line 578: p_source_trx_table => 'OE_ORDER_LINES_ALL',

574: AND source_transaction_table = 'OE_ORDER_LINES_ALL';
575:
576: csi_utl_pkg.update_txn_line_dtl (
577: p_source_trx_id => p_rma_line_id,
578: p_source_trx_table => 'OE_ORDER_LINES_ALL',
579: p_api_name => l_api_name,
580: p_error_message => l_error_message );
581:
582: End rma_fulfillment;

Line 585: p_rma_line_rec IN oe_order_lines_all%rowtype,

581:
582: End rma_fulfillment;
583:
584: PROCEDURE fulfill_rma_line(
585: p_rma_line_rec IN oe_order_lines_all%rowtype,
586: p_csi_txn_rec IN csi_datastructures_pub.transaction_rec,
587: p_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
588: px_trx_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec,
589: x_msg_count OUT NOCOPY number,

Line 1119: From oe_order_lines_all

1115: THEN
1116: Begin
1117: Select inventory_item_id, flow_status_code, sold_to_org_id
1118: Into l_orig_rma_item_id, l_orig_rma_status, l_orig_rma_owner_id
1119: From oe_order_lines_all
1120: Where line_id = l_txn_line_dtl_rec.reference_source_line_id
1121: And header_id = l_txn_line_dtl_rec.reference_source_id;
1122: Exception When others Then
1123: l_orig_rma_ref_valid := 'N';

Line 1548: l_literal2 := 'OE_ORDER_LINES_ALL';

1544: Begin
1545:
1546: --Assign the literals.. bug 4311676
1547: l_literal1 := 'IN_PROCESS';
1548: l_literal2 := 'OE_ORDER_LINES_ALL';
1549:
1550: UPDATE csi_t_txn_line_details a
1551: SET error_code = NULL,
1552: error_explanation = NULL,