[Home] [Help]
306: Begin
307: IF l_debug_level > 0 THEN
308: oe_debug_pub.add( 'Inside Update Header Flow Status');
309: END IF;
310: Update oe_order_headers_all
311: Set flow_status_code = p_flow_status_code
312: Where header_id = p_header_id;
313: End Update_header_flow_status;
314:
871: IF l_inv_cust_trx_type_id = 0 THEN
872: SELECT NVL(ot.cust_trx_type_id,0)
873: INTO l_inv_cust_trx_type_id
874: FROM oe_order_types_v ot,
875: oe_order_headers_all oh /* MOAC SQL CHANGE */
876: WHERE ot.order_type_id = oh.order_type_id
877: AND oh.header_id = (SELECT header_id
878: FROM oe_order_lines_all /* MOAC SQL CHANGE */
879: WHERE line_id = p_line_rec.reference_line_id);
916: -- Get cust_trx_type_id from order type
917: SELECT NVL(ot.cust_trx_type_id, 0)
918: INTO l_inv_cust_trx_type_id
919: FROM oe_order_types_v ot,
920: oe_order_headers_all oh /* MOAC SQL CHANGE */
921: WHERE ot.order_type_id = oh.order_type_id
922: AND oh.header_id = p_line_rec.header_id;
923: END IF;
924: IF l_debug_level > 0 THEN
1405: ot.non_delivery_invoice_source_id)
1406: INTO l_invoice_source_id
1407: FROM oe_line_types_v lt,
1408: oe_order_types_v ot,
1409: oe_order_headers_all oh /* MOAC SQL CHANGE */
1410: WHERE lt.line_type_id = p_line_rec.line_type_id
1411: AND ot.order_type_id = oh.order_type_id
1412: AND oh.header_id = p_line_rec.header_id;
1413: IF l_invoice_source_id IS NOT NULL THEN
1431: ot.invoice_source_id)
1432: INTO l_invoice_source_id
1433: FROM oe_line_types_v lt,
1434: oe_order_types_v ot,
1435: oe_order_headers_all oh /* MOAC SQL CHANGE */
1436: WHERE lt.line_type_id = p_line_rec.line_type_id
1437: AND ot.order_type_id = oh.order_type_id
1438: AND oh.header_id = p_line_rec.header_id;
1439: IF l_invoice_source_id IS NOT NULL THEN
1536: IF l_cust_trx_type_id = 0 THEN
1537: SELECT NVL(ot.cust_trx_type_id, 0)
1538: INTO l_cust_trx_type_id
1539: FROM oe_order_types_v ot,
1540: oe_order_headers_all oh /* MOAC SQL CHANGE */
1541: WHERE ot.order_type_id = oh.order_type_id
1542: AND oh.header_id = p_line_rec.header_id;
1543: IF l_debug_level > 0 THEN
1544: oe_debug_pub.add( 'CUSTOMER TRANSACTION TYPE ID FROM ORDER TYPE : '||L_CUST_TRX_TYPE_ID , 5 ) ;
1596: IF l_inv_cust_trx_type_id = 0 THEN
1597: SELECT NVL(ot.cust_trx_type_id,0)
1598: INTO l_inv_cust_trx_type_id
1599: FROM oe_order_types_v ot,
1600: oe_order_headers_all oh /* MOAC SQL CHANGE */
1601: WHERE ot.order_type_id = oh.order_type_id
1602: AND oh.header_id = p_line_rec.header_id;
1603: IF l_debug_level > 0 THEN
1604: oe_debug_pub.add( 'CUSTOMER TRANSACTION TYPE ID FROM ORDER TYPE: '||L_INV_CUST_TRX_TYPE_ID , 5 ) ;
1663: INTO l_accting_credit_method_code,
1664: l_invcing_credit_method_code
1665: FROM oe_line_types_v lt,
1666: oe_order_types_v ot,
1667: oe_order_headers_all oh /* MOAC SQL CHANGE */
1668: WHERE lt.line_type_id = p_line_rec.line_type_id
1669: AND ot.order_type_id = oh.order_type_id
1670: AND oh.header_id = p_line_rec.header_id;
1671: x_accting_credit_method_code := l_accting_credit_method_code;
4885: , ool.line_id
4886: , ooh.order_number
4887: , ott.name order_type
4888: FROM oe_order_lines ool,
4889: oe_order_headers_all ooh, /* MOAC SQL CHANGE */
4890: oe_transaction_types_tl ott
4891: WHERE ool.line_id = c_line_id
4892: AND ooh.header_id = ool.header_id
4893: AND ott.transaction_type_id = ooh.order_type_id
5397: -- bug 4680186
5398: IF NOT Return_Line(p_line_rec) THEN
5399: BEGIN
5400: SELECT payment_term_id INTO l_hdr_payment_term_id
5401: FROM oe_order_headers_all
5402: WHERE header_id = p_line_rec.header_id;
5403: EXCEPTION
5404: WHEN NO_DATA_FOUND THEN
5405: l_hdr_payment_term_id := null;