[Home] [Help]
35: *(ool.unit_selling_price), OE_ORDER_UTIL.G_Precision))
36: INTO
37: l_tax_total
38: , l_order_total
39: FROM oe_order_lines_all ool
40: WHERE ool.header_id = p_header_id
41: AND ool.open_flag = 'N'
42: AND ool.cancelled_flag = 'N'
43: AND ool.line_category_code <> 'RETURN'
57: FROM oe_payments op
58: WHERE op.header_id = p_header_id
59: AND NOT EXISTS
60: (SELECT 'Non Invoiceable Item Line'
61: FROM mtl_system_items mti, oe_order_lines_all ool
62: WHERE ool.line_id = op.line_id
63: AND mti.inventory_item_id = ool.inventory_item_id
64: AND mti.organization_id = nvl(ool.ship_from_org_id,
65: oe_sys_parameters.value('MASTER_ORGANIZATION_ID'))
68: ELSE
69: -- Select the Outbound Extended Price for lines that have committment
70: SELECT SUM(ROUND(nvl(ool.Ordered_Quantity,0) *(ool.unit_selling_price), OE_ORDER_UTIL.G_Precision))
71: INTO l_commitment_total
72: FROM oe_order_lines_all ool
73: WHERE ool.header_id = p_header_id
74: AND ool.commitment_id is not null
75: AND ool.open_flag = 'N'
76: AND ool.cancelled_flag = 'N'
113: )
114: )
115: INTO l_chgs_w_line_id
116: FROM OE_PRICE_ADJUSTMENTS P,
117: OE_ORDER_LINES_ALL L
118: WHERE P.HEADER_ID = p_header_id
119: AND P.LINE_ID = L.LINE_ID
120: AND P.LIST_LINE_TYPE_CODE = 'FREIGHT_CHARGE'
121: AND P.APPLIED_FLAG = 'Y'
572: -- get all the lines for those haven't got INVOICE_INTERFACE_STATUS_CODE
573: -- populated.
574: CURSOR line_csr(p_header_id IN NUMBER) IS
575: SELECT line_id
576: FROM oe_order_lines
577: WHERE NVL(INVOICE_INTERFACE_STATUS_CODE, 'N') <> 'PREPAID'
578: AND header_id = p_header_id;
579:
580:
984: OPEN line_csr(l_header_rec.header_id);
985: LOOP
986:
987: FETCH line_csr INTO l_line_id;
988: UPDATE oe_order_lines
989: SET INVOICE_INTERFACE_STATUS_CODE = 'PREPAID'
990: WHERE line_id = l_line_id;
991:
992: EXIT WHEN line_csr%NOTFOUND;
1110: OPEN line_csr(l_header_rec.header_id);
1111: LOOP
1112:
1113: FETCH line_csr INTO l_line_id;
1114: UPDATE oe_order_lines
1115: SET INVOICE_INTERFACE_STATUS_CODE = 'PREPAID'
1116: WHERE line_id = l_line_id;
1117:
1118: EXIT WHEN line_csr%NOTFOUND;
2580: -- create a new trxn_extension_id for the child line from the parent line
2581: BEGIN
2582: SELECT org_id, invoice_to_org_id
2583: INTO l_org_id, l_site_use_id
2584: FROM oe_order_lines_all
2585: WHERE line_id = p_line_id;
2586: EXCEPTION WHEN NO_DATA_FOUND THEN
2587: null;
2588: END;
2796:
2797: BEGIN
2798: SELECT header_id
2799: INTO l_header_id
2800: FROM oe_order_lines_all
2801: WHERE line_id = p_line_id;
2802: EXCEPTION
2803: WHEN OTHERS THEN
2804: IF l_debug_level > 0 THEN
3005: BEGIN
3006: SELECT payment_set_id
3007: INTO l_payment_set_id
3008: FROM oe_payments op
3009: ,oe_order_lines_all ool
3010: WHERE op.header_id = ool.header_id
3011: AND ool.line_id = p_line_id
3012: AND rownum = 1;
3013: EXCEPTION WHEN NO_DATA_FOUND THEN
3570: Savepoint update_line;
3571:
3572: select line_id, payment_type_code, commitment_id
3573: into l_lock_line_id, line_payment_type, line_commitment_id
3574: from oe_order_lines_all
3575: where line_id = p_line_id
3576: for update nowait;
3577:
3578: if l_lock_line_id is null then
3606: end loop;
3607:
3608: if l_pmt_changed = 'Y' then
3609: Begin
3610: update oe_order_lines_all
3611: set payment_type_code = line_payment_type,
3612: commitment_id = line_commitment_id
3613: where line_id = l_lock_line_id;
3614:
4912:
4913: CURSOR lines_cur(p_header_id IN NUMBER) IS
4914: SELECT line_id
4915: ,payment_term_id
4916: FROM oe_order_lines_all
4917: WHERE header_id = p_header_id;
4918:
4919: CURSOR exc_inv_lines_cur(p_header_id IN NUMBER) IS
4920: SELECT line_id
4918:
4919: CURSOR exc_inv_lines_cur(p_header_id IN NUMBER) IS
4920: SELECT line_id
4921: ,payment_term_id
4922: FROM oe_order_lines_all
4923: WHERE header_id = p_header_id
4924: AND nvl(invoice_interface_status_code,'NO') <> 'YES';
4925:
4926: l_pay_now_total_detail_tbl AR_VIEW_TERM_GRP.amounts_table;
4959: ,payment_term_id
4960: INTO l_line_tbl(1).line_id
4961: ,l_line_tbl(1).header_id
4962: ,l_line_tbl(1).payment_term_id
4963: FROM oe_order_lines_all
4964: WHERE line_id=p_line_id;
4965: ELSE
4966: -- this is for header payment
4967: i := 1;