APPS.OE_INVOICE_PUB dependencies on OE_PAYMENTS

Line 1270: FROM oe_payments

1266: SELECT nvl(commitment_applied_amount, 0)
1267: ,nvl(commitment_interfaced_amount, 0)
1268: INTO x_commitment_applied
1269: ,x_commitment_interfaced
1270: FROM oe_payments
1271: WHERE payment_trx_id = p_line_rec.commitment_id
1272: AND payment_type_code = 'COMMITMENT'
1273: AND line_id = p_line_rec.line_id;
1274: ELSE

Line 1280: FROM oe_payments

1276: SELECT nvl(commitment_applied_amount, 0)
1277: ,nvl(commitment_interfaced_amount, 0)
1278: INTO x_commitment_applied
1279: ,x_commitment_interfaced
1280: FROM oe_payments
1281: WHERE payment_trx_id = p_line_rec.commitment_id
1282: AND line_id = p_line_rec.line_id;
1283: --serla begin
1284: END IF;

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

6488: IF NOT Return_Line(p_line_rec) THEN
6489: IF OE_PrePayment_Util.Is_Prepaid_Order(p_header_rec) = 'Y' THEN
6490: -- p_x_interface_line_rec.Term_Id := p_header_rec.payment_term_id;
6491: IF l_debug_level > 0 THEN
6492: oe_debug_pub.add( 'GETTING PAYMENT_SET_ID FROM OE_PAYMENTS' ) ;
6493: END IF;
6494: BEGIN
6495: --serla begin
6496: IF OE_PrePayment_UTIL.IS_MULTIPLE_PAYMENTS_ENABLED THEN

Line 6499: FROM oe_payments

6495: --serla begin
6496: IF OE_PrePayment_UTIL.IS_MULTIPLE_PAYMENTS_ENABLED THEN
6497: SELECT payment_set_id
6498: INTO p_x_interface_line_rec.Payment_Set_ID
6499: FROM oe_payments
6500: WHERE header_id = p_line_rec.header_id
6501: AND payment_set_id IS NOT NULL
6502: AND rownum=1;
6503: ELSE

Line 6507: FROM oe_payments

6503: ELSE
6504: --serla end
6505: SELECT payment_set_id
6506: INTO p_x_interface_line_rec.Payment_Set_ID
6507: FROM oe_payments
6508: WHERE header_id = p_line_rec.header_id
6509: AND line_id is null
6510: AND payment_type_code = 'CREDIT_CARD';
6511: --serla begin

Line 7378: FROM oe_payments

7374: -- , l_tangible_id
7375: -- , l_credit_card_holder_name
7376: -- , l_credit_card_approval_code
7377: , l_payment_trxn_extension_id
7378: FROM oe_payments
7379: WHERE line_id = p_line_rec.line_id
7380: AND header_id = p_line_rec.header_id
7381: AND payment_type_code <> 'COMMITMENT'
7382: AND payment_collection_event = 'INVOICE';

Line 7420: FROM oe_payments

7416: -- , l_tangible_id
7417: -- , l_credit_card_holder_name
7418: -- , l_credit_card_approval_code
7419: , l_payment_trxn_extension_id
7420: FROM oe_payments
7421: WHERE header_id = p_line_rec.header_id
7422: AND line_id is NULL
7423: AND payment_collection_event = 'INVOICE';
7424: IF l_debug_level > 0 THEN

Line 7847: FROM oe_payments

7843: END IF;
7844: BEGIN
7845: SELECT trxn_extension_id
7846: INTO l_trxn_extension_id
7847: FROM oe_payments
7848: WHERE header_id = p_line_rec.header_id
7849: AND line_id =p_line_rec.line_id
7850: AND PAYMENT_LEVEL_CODE ='LINE'
7851: AND PAYMENT_COLLECTION_EVENT='INVOICE';

Line 7869: FROM oe_payments

7865:
7866: BEGIN
7867: SELECT trxn_extension_id
7868: INTO l_trxn_extension_id
7869: FROM oe_payments
7870: WHERE header_id = p_line_rec.header_id
7871: AND line_id is NULL
7872: AND PAYMENT_LEVEL_CODE ='ORDER'
7873: AND PAYMENT_TYPE_CODE ='CREDIT_CARD'

Line 7891: UPDATE OE_PAYMENTS

7887: IF l_debug_level > 0 THEN
7888: oe_debug_pub.add( 'updating header level invoice payment ', 5 ) ;
7889: END IF;
7890:
7891: UPDATE OE_PAYMENTS
7892: SET INVOICED_FLAG ='Y'
7893: WHERE header_id = p_line_rec.header_id
7894: AND line_id is NULL
7895: AND PAYMENT_LEVEL_CODE ='ORDER'

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

8026: IF OE_Commitment_Pvt.DO_Commitment_Sequencing THEN --commitment sequencing ON
8027: IF p_line_rec.commitment_id IS NOT NULL AND
8028: p_interface_line_rec.promised_commitment_amount IS NOT NULL THEN
8029: IF l_debug_level > 0 THEN
8030: oe_debug_pub.add( 'UPDATING OE_PAYMENTS' , 3 ) ;
8031: END IF;
8032: UPDATE oe_payments
8033: SET commitment_interfaced_amount = nvl(commitment_interfaced_amount, 0) + nvl(p_interface_line_rec.promised_commitment_amount, 0)
8034: WHERE LINE_ID = p_line_rec.line_id

Line 8032: UPDATE oe_payments

8028: p_interface_line_rec.promised_commitment_amount IS NOT NULL THEN
8029: IF l_debug_level > 0 THEN
8030: oe_debug_pub.add( 'UPDATING OE_PAYMENTS' , 3 ) ;
8031: END IF;
8032: UPDATE oe_payments
8033: SET commitment_interfaced_amount = nvl(commitment_interfaced_amount, 0) + nvl(p_interface_line_rec.promised_commitment_amount, 0)
8034: WHERE LINE_ID = p_line_rec.line_id
8035: AND PAYMENT_TRX_ID = p_line_rec.commitment_id;
8036: END IF;

Line 10358: (select 'x' from oe_payments

10354: FROM OE_ORDER_LINES L
10355: WHERE HEADER_ID = l_header_id
10356: AND invoice_interface_status_code = 'YES'
10357: AND NOT EXISTS
10358: (select 'x' from oe_payments
10359: WHERE header_id = l_header_id
10360: AND line_id = L.line_id
10361: AND payment_type_code <> 'COMMITMENT'
10362: )