APPS.OE_LINE_PAYMENT_UTIL dependencies on OE_ORDER_LINES_ALL

Line 1964: FROM oe_order_lines_all l

1960: IF p_line_Payment_rec.payment_type_code = 'COMMITMENT' THEN
1961: BEGIN
1962: SELECT l.transaction_phase_code
1963: INTO l_transaction_phase_code
1964: FROM oe_order_lines_all l
1965: WHERE l.line_id = p_line_Payment_rec.line_id;
1966:
1967: EXCEPTION
1968: WHEN NO_DATA_FOUND THEN

Line 2206: from oe_order_lines_all where

2202: --Calling delete API of Oracle Payments only if the payment
2203: --type is credit card ach or direct debit.
2204: IF l_payment_type_code in ('CREDIT_CARD','ACH','DIRECT_DEBIT') THEN
2205: select invoice_to_org_id into l_invoice_to_org_id --Verify
2206: from oe_order_lines_all where
2207: header_id = p_header_id
2208: and line_id = p_line_id;
2209: IF l_debug_level > 0 THEN
2210: oe_debug_pub.add('Deleting trxn id...'||l_trxn_extension_id);

Line 2436: from oe_order_lines_all where header_id = p_header_id

2432: --Calling delete API of Oracle Payments only if the payment
2433: --type is credit card ach or direct debit.
2434: IF p_payment_type_code in ('CREDIT_CARD','ACH','DIRECT_DEBIT') THEN
2435: select invoice_to_org_id into l_invoice_to_org_id
2436: from oe_order_lines_all where header_id = p_header_id
2437: and line_id = p_line_id;
2438: IF l_debug_level > 0 THEN
2439: oe_debug_pub.add('Deleting trxn id...'||l_trxn_extension_id);
2440: oe_debug_pub.add('Invoice to org.'||l_invoice_to_org_id);

Line 3446: FROM oe_order_lines_all l

3442: -- QUOTING change
3443: SELECT l.transaction_phase_code
3444: INTO
3445: l_transaction_phase_code
3446: FROM oe_order_lines_all l
3447: WHERE l.line_id = p_x_line_Payment_rec.line_id;
3448:
3449: EXCEPTION
3450: WHEN NO_DATA_FOUND THEN

Line 3522: from oe_order_lines_all where header_id = p_x_line_Payment_rec.header_id

3518: --R12 CC Encryption
3519: --Querying the invoice to org id before checking the payment type
3520: --as it is needed for both credit card and check payments.
3521: Select INVOICE_TO_ORG_ID into l_invoice_to_org_id
3522: from oe_order_lines_all where header_id = p_x_line_Payment_rec.header_id
3523: and line_id = p_x_line_payment_rec.line_id;
3524: --Not taking it from the cache as the invoice to org id might change
3525: --in the line level as well.
3526: -- l_invoice_to_org_id := OE_Order_Cache.g_line_rec.invoice_to_org_id;

Line 3586: From oe_order_lines_all

3582: END IF;
3583:
3584: Select SOURCE_DOCUMENT_TYPE_ID
3585: Into l_order_source_doc_id
3586: From oe_order_lines_all
3587: Where line_id = p_x_line_payment_rec.line_id;
3588:
3589: -- To make sure this is coming from external caller,
3590: -- not from a copied order, need to check for source

Line 4087: update oe_order_lines_all

4083: if l_debug_level > 0 then
4084: oe_debug_pub.add('update commitment and payment type ');
4085: end if;
4086:
4087: update oe_order_lines_all
4088: set payment_type_code = null,
4089: commitment_id = null
4090: where line_id = p_line_id;
4091:

Line 4098: update oe_order_lines_all

4094: if l_debug_level > 0 then
4095: oe_debug_pub.add('update payment type ');
4096: end if;
4097:
4098: update oe_order_lines_all
4099: set payment_type_code = null
4100: where line_id = p_line_id;
4101:
4102: elsif l_upd_commitment = 1 then

Line 4108: update oe_order_lines_all

4104: if l_debug_level > 0 then
4105: oe_debug_pub.add('update commitment ');
4106: end if;
4107:
4108: update oe_order_lines_all
4109: set commitment_id = null
4110: where line_id = p_line_id;
4111: end if;
4112: