APPS.OE_INVOICE_PUB dependencies on OE_PAYMENTS

Line 1055: FROM oe_payments

1051: SELECT nvl(commitment_applied_amount, 0)
1052: ,nvl(commitment_interfaced_amount, 0)
1053: INTO x_commitment_applied
1054: ,x_commitment_interfaced
1055: FROM oe_payments
1056: WHERE payment_trx_id = p_line_rec.commitment_id
1057: AND payment_type_code = 'COMMITMENT'
1058: AND line_id = p_line_rec.line_id;
1059: ELSE

Line 1065: FROM oe_payments

1061: SELECT nvl(commitment_applied_amount, 0)
1062: ,nvl(commitment_interfaced_amount, 0)
1063: INTO x_commitment_applied
1064: ,x_commitment_interfaced
1065: FROM oe_payments
1066: WHERE payment_trx_id = p_line_rec.commitment_id
1067: AND line_id = p_line_rec.line_id;
1068: --serla begin
1069: END IF;

Line 6234: oe_debug_pub.add( 'GETTING PAYMENT_SET_ID FROM OE_PAYMENTS' ) ;

6230: IF NOT Return_Line(p_line_rec) THEN
6231: IF OE_PrePayment_Util.Is_Prepaid_Order(p_header_rec) = 'Y' THEN
6232: -- p_x_interface_line_rec.Term_Id := p_header_rec.payment_term_id;
6233: IF l_debug_level > 0 THEN
6234: oe_debug_pub.add( 'GETTING PAYMENT_SET_ID FROM OE_PAYMENTS' ) ;
6235: END IF;
6236: BEGIN
6237: --serla begin
6238: IF OE_PrePayment_UTIL.IS_MULTIPLE_PAYMENTS_ENABLED THEN

Line 6241: FROM oe_payments

6237: --serla begin
6238: IF OE_PrePayment_UTIL.IS_MULTIPLE_PAYMENTS_ENABLED THEN
6239: SELECT payment_set_id
6240: INTO p_x_interface_line_rec.Payment_Set_ID
6241: FROM oe_payments
6242: WHERE header_id = p_line_rec.header_id
6243: AND payment_set_id IS NOT NULL
6244: AND rownum=1;
6245: ELSE

Line 6249: FROM oe_payments

6245: ELSE
6246: --serla end
6247: SELECT payment_set_id
6248: INTO p_x_interface_line_rec.Payment_Set_ID
6249: FROM oe_payments
6250: WHERE header_id = p_line_rec.header_id
6251: AND line_id is null
6252: AND payment_type_code = 'CREDIT_CARD';
6253: --serla begin

Line 7093: FROM oe_payments

7089: -- , l_tangible_id
7090: -- , l_credit_card_holder_name
7091: -- , l_credit_card_approval_code
7092: , l_payment_trxn_extension_id
7093: FROM oe_payments
7094: WHERE line_id = p_line_rec.line_id
7095: AND header_id = p_line_rec.header_id
7096: AND payment_type_code <> 'COMMITMENT'
7097: AND payment_collection_event = 'INVOICE';

Line 7135: FROM oe_payments

7131: -- , l_tangible_id
7132: -- , l_credit_card_holder_name
7133: -- , l_credit_card_approval_code
7134: , l_payment_trxn_extension_id
7135: FROM oe_payments
7136: WHERE header_id = p_line_rec.header_id
7137: AND line_id is NULL
7138: AND payment_collection_event = 'INVOICE';
7139: IF l_debug_level > 0 THEN

Line 7647: oe_debug_pub.add( 'UPDATING OE_PAYMENTS' , 3 ) ;

7643: IF OE_Commitment_Pvt.DO_Commitment_Sequencing THEN --commitment sequencing ON
7644: IF p_line_rec.commitment_id IS NOT NULL AND
7645: p_interface_line_rec.promised_commitment_amount IS NOT NULL THEN
7646: IF l_debug_level > 0 THEN
7647: oe_debug_pub.add( 'UPDATING OE_PAYMENTS' , 3 ) ;
7648: END IF;
7649: UPDATE oe_payments
7650: SET commitment_interfaced_amount = nvl(commitment_interfaced_amount, 0) + nvl(p_interface_line_rec.promised_commitment_amount, 0)
7651: WHERE LINE_ID = p_line_rec.line_id

Line 7649: UPDATE oe_payments

7645: p_interface_line_rec.promised_commitment_amount IS NOT NULL THEN
7646: IF l_debug_level > 0 THEN
7647: oe_debug_pub.add( 'UPDATING OE_PAYMENTS' , 3 ) ;
7648: END IF;
7649: UPDATE oe_payments
7650: SET commitment_interfaced_amount = nvl(commitment_interfaced_amount, 0) + nvl(p_interface_line_rec.promised_commitment_amount, 0)
7651: WHERE LINE_ID = p_line_rec.line_id
7652: AND PAYMENT_TRX_ID = p_line_rec.commitment_id;
7653: END IF;

Line 9752: (select 'x' from oe_payments

9748: FROM OE_ORDER_LINES L
9749: WHERE HEADER_ID = l_header_id
9750: AND invoice_interface_status_code = 'YES'
9751: AND NOT EXISTS
9752: (select 'x' from oe_payments
9753: WHERE header_id = l_header_id
9754: AND line_id = L.line_id
9755: AND payment_type_code <> 'COMMITMENT'
9756: )