APPS.OE_LINE_PAYMENT_UTIL dependencies on OE_ORDER_LINES_ALL

Line 2042: FROM oe_order_lines_all l

2038: IF p_line_Payment_rec.payment_type_code = 'COMMITMENT' THEN
2039: BEGIN
2040: SELECT l.transaction_phase_code
2041: INTO l_transaction_phase_code
2042: FROM oe_order_lines_all l
2043: WHERE l.line_id = p_line_Payment_rec.line_id;
2044:
2045: EXCEPTION
2046: WHEN NO_DATA_FOUND THEN

Line 2284: from oe_order_lines_all where

2280: --Calling delete API of Oracle Payments only if the payment
2281: --type is credit card ach or direct debit.
2282: IF l_payment_type_code in ('CREDIT_CARD','ACH','DIRECT_DEBIT') THEN
2283: select invoice_to_org_id into l_invoice_to_org_id --Verify
2284: from oe_order_lines_all where
2285: header_id = p_header_id
2286: and line_id = p_line_id;
2287: IF l_debug_level > 0 THEN
2288: oe_debug_pub.add('Deleting trxn id...'||l_trxn_extension_id);

Line 2514: from oe_order_lines_all where header_id = p_header_id

2510: --Calling delete API of Oracle Payments only if the payment
2511: --type is credit card ach or direct debit.
2512: IF p_payment_type_code in ('CREDIT_CARD','ACH','DIRECT_DEBIT') THEN
2513: select invoice_to_org_id into l_invoice_to_org_id
2514: from oe_order_lines_all where header_id = p_header_id
2515: and line_id = p_line_id;
2516: IF l_debug_level > 0 THEN
2517: oe_debug_pub.add('Deleting trxn id...'||l_trxn_extension_id);
2518: oe_debug_pub.add('Invoice to org.'||l_invoice_to_org_id);

Line 3524: FROM oe_order_lines_all l

3520: -- QUOTING change
3521: SELECT l.transaction_phase_code
3522: INTO
3523: l_transaction_phase_code
3524: FROM oe_order_lines_all l
3525: WHERE l.line_id = p_x_line_Payment_rec.line_id;
3526:
3527: EXCEPTION
3528: WHEN NO_DATA_FOUND THEN

Line 3600: from oe_order_lines_all where header_id = p_x_line_Payment_rec.header_id

3596: --R12 CC Encryption
3597: --Querying the invoice to org id before checking the payment type
3598: --as it is needed for both credit card and check payments.
3599: Select INVOICE_TO_ORG_ID into l_invoice_to_org_id
3600: from oe_order_lines_all where header_id = p_x_line_Payment_rec.header_id
3601: and line_id = p_x_line_payment_rec.line_id;
3602: --Not taking it from the cache as the invoice to org id might change
3603: --in the line level as well.
3604: -- l_invoice_to_org_id := OE_Order_Cache.g_line_rec.invoice_to_org_id;

Line 3664: From oe_order_lines_all

3660: END IF;
3661:
3662: Select SOURCE_DOCUMENT_TYPE_ID
3663: Into l_order_source_doc_id
3664: From oe_order_lines_all
3665: Where line_id = p_x_line_payment_rec.line_id;
3666:
3667: -- To make sure this is coming from external caller,
3668: -- not from a copied order, need to check for source

Line 4165: update oe_order_lines_all

4161: if l_debug_level > 0 then
4162: oe_debug_pub.add('update commitment and payment type ');
4163: end if;
4164:
4165: update oe_order_lines_all
4166: set payment_type_code = null,
4167: commitment_id = null
4168: where line_id = p_line_id;
4169:

Line 4176: update oe_order_lines_all

4172: if l_debug_level > 0 then
4173: oe_debug_pub.add('update payment type ');
4174: end if;
4175:
4176: update oe_order_lines_all
4177: set payment_type_code = null
4178: where line_id = p_line_id;
4179:
4180: elsif l_upd_commitment = 1 then

Line 4186: update oe_order_lines_all

4182: if l_debug_level > 0 then
4183: oe_debug_pub.add('update commitment ');
4184: end if;
4185:
4186: update oe_order_lines_all
4187: set commitment_id = null
4188: where line_id = p_line_id;
4189: end if;
4190: