eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_VERIFY_PAYMENT_PUB dependencies on OE_PAYMENTS

Line 5284: FROM oe_payments

5280: ,tangible_id*/
5281: ,receipt_method_id
5282: ,payment_number
5283: ,defer_payment_processing_flag
5284: FROM oe_payments
5285: WHERE payment_type_code = 'CREDIT_CARD'
5286: AND header_id = p_header_id
5287: AND line_id IS NOT NULL;
5288:

Line 5301: FROM oe_payments

5297: ,credit_card_approval_date
5298: ,tangible_id*/
5299: ,receipt_method_id
5300: ,defer_payment_processing_flag
5301: FROM oe_payments
5302: WHERE payment_type_code = 'CREDIT_CARD'
5303: AND payment_collection_event = 'INVOICE'
5304: AND line_id is null
5305: AND header_id = p_header_id;

Line 5320: FROM oe_payments

5316: ,tangible_id*/
5317: ,receipt_method_id
5318: ,payment_number
5319: ,defer_payment_processing_flag
5320: FROM oe_payments
5321: WHERE payment_type_code = 'CREDIT_CARD'
5322: AND line_id = p_line_id
5323: AND header_id = p_header_id;
5324:

Line 5623: FROM oe_payments

5619: -- as we need to include those deferred prepayment as well.
5620: BEGIN
5621: SELECT sum(nvl(payment_amount, 0))
5622: INTO l_prepaid_total
5623: FROM oe_payments
5624: WHERE payment_collection_event = 'PREPAY'
5625: AND header_id = p_header_rec.header_id;
5626: EXCEPTION WHEN NO_DATA_FOUND THEN
5627: l_prepaid_total := 0;

Line 5944: FROM OE_PAYMENTS

5940: END IF;
5941: BEGIN
5942: select trxn_extension_id
5943: into l_trxn_extension_id
5944: FROM OE_PAYMENTS
5945: WHERE HEADER_ID = p_header_rec.header_id and line_id is null
5946: AND nvl(payment_collection_event,'PREPAY') = 'INVOICE'; --bug 5020737
5947: EXCEPTION WHEN NO_DATA_FOUND THEN
5948: IF l_debug_level > 0 THEN

Line 5962: FROM OE_PAYMENTS

5958: oe_debug_pub.add('Before getting trxn id else'||l_payments_tbl(I).line_id||' and '||p_header_rec.header_id);
5959: END IF;
5960: select trxn_extension_id
5961: into l_trxn_extension_id
5962: FROM OE_PAYMENTS
5963: WHERE line_id = l_payments_tbl(I).line_id
5964: AND header_id = p_header_rec.header_id
5965: AND payment_type_code <> 'COMMITMENT';
5966:

Line 6980: -- update oe_payments table

6976: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6977: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6978: END IF;
6979:
6980: -- update oe_payments table
6981: UPDATE oe_payments
6982: SET trxn_extension_id = l_trxn_extension_id
6983: ,invoiced_flag ='N' --CC Reversal ER#16014135
6984: WHERE trxn_extension_id = p_trxn_extension_id

Line 6981: UPDATE oe_payments

6977: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6978: END IF;
6979:
6980: -- update oe_payments table
6981: UPDATE oe_payments
6982: SET trxn_extension_id = l_trxn_extension_id
6983: ,invoiced_flag ='N' --CC Reversal ER#16014135
6984: WHERE trxn_extension_id = p_trxn_extension_id
6985: AND header_id = p_header_id --bug 5209584

Line 7038: -- update oe_payments table

7034: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
7035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7036: END IF;
7037:
7038: -- update oe_payments table
7039: UPDATE oe_payments
7040: SET trxn_extension_id = l_trxn_extension_id
7041: ,invoiced_flag ='N' --CC Reversal ER#16014135
7042: WHERE trxn_extension_id = p_trxn_extension_id

Line 7039: UPDATE oe_payments

7035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7036: END IF;
7037:
7038: -- update oe_payments table
7039: UPDATE oe_payments
7040: SET trxn_extension_id = l_trxn_extension_id
7041: ,invoiced_flag ='N' --CC Reversal ER#16014135
7042: WHERE trxn_extension_id = p_trxn_extension_id
7043: AND header_id = p_header_id --bug 5209584

Line 7056: FROM oe_payments

7052: END IF;
7053: BEGIN
7054: SELECT nvl(invoiced_flag,'N')
7055: INTO l_invoiced_flag
7056: FROM oe_payments
7057: WHERE header_id =p_header_id
7058: AND line_id IS NULL
7059: AND trxn_extension_id = p_trxn_extension_id
7060: AND PAYMENT_LEVEL_CODE ='ORDER'

Line 7089: -- update oe_payments table

7085: END IF;
7086: IF l_debug_level > 0 THEN
7087: oe_debug_pub.add( 'OEXPVPMB: updating new trxn_extension_id ');
7088: END IF;
7089: -- update oe_payments table
7090: UPDATE oe_payments
7091: SET trxn_extension_id = l_trxn_extension_id
7092: ,invoiced_flag ='N'
7093: WHERE trxn_extension_id = p_trxn_extension_id

Line 7090: UPDATE oe_payments

7086: IF l_debug_level > 0 THEN
7087: oe_debug_pub.add( 'OEXPVPMB: updating new trxn_extension_id ');
7088: END IF;
7089: -- update oe_payments table
7090: UPDATE oe_payments
7091: SET trxn_extension_id = l_trxn_extension_id
7092: ,invoiced_flag ='N'
7093: WHERE trxn_extension_id = p_trxn_extension_id
7094: AND header_id = p_header_id

Line 7248: FROM oe_payments

7244: oe_debug_pub.add('checking for line_id based on p_trxn_extension_id passed',5);
7245: END IF;
7246: SELECT line_id
7247: INTO l_line_id
7248: FROM oe_payments
7249: WHERE trxn_extension_id=p_trxn_extension_id
7250: AND header_id=p_header_id;
7251:
7252: IF l_line_id IS NOT NULL THEN

Line 7431: FROM oe_payments op

7427: --pnpl added the Do_Commitment_Sequencing check
7428: IF OE_Commitment_Pvt.Do_Commitment_Sequencing THEN
7429: SELECT SUM(nvl(op.commitment_applied_amount,0))
7430: INTO l_commitment_applied
7431: FROM oe_payments op
7432: WHERE op.line_id = p_line_id
7433: AND op.header_id = p_header_id
7434: AND NOT EXISTS
7435: (SELECT 'Non Invoiceable Item Line'

Line 7706: FROM oe_payments op

7702: IF OE_Commitment_Pvt.Do_Commitment_Sequencing THEN
7703: -- Select the committment applied amount
7704: SELECT SUM(nvl(op.commitment_applied_amount,0))
7705: INTO l_commitment_applied
7706: FROM oe_payments op
7707: WHERE op.line_id = p_line_id
7708: AND op.header_id = p_header_id
7709: AND NOT EXISTS
7710: (SELECT 'Non Invoiceable Item Line'

Line 7934: FROM oe_payments op,

7930: IF OE_Commitment_Pvt.Do_Commitment_Sequencing THEN
7931: -- Select the committment applied amount if Commitment Sequencing "On"
7932: SELECT SUM(ROUND(nvl(op.commitment_applied_amount,0),OE_ORDER_UTIL.G_Precision))
7933: INTO l_commitment_total
7934: FROM oe_payments op,
7935: oe_order_lines_all ool --bug3225795
7936: WHERE op.header_id = p_header_id
7937: AND ool.header_id = p_header_id --bug3225795
7938: AND nvl(ool.invoice_interface_status_code,'NO') <> 'YES' --bug3225795

Line 8165: update oe_payments

8161: */
8162:
8163: IF p_line_id IS NOT NULL THEN
8164: -- line level payments
8165: update oe_payments
8166: set credit_card_approval_code = p_auth_code
8167: , credit_card_approval_date = p_auth_date
8168: , tangible_id = p_tangible_id
8169: , last_updated_by = FND_GLOBAL.USER_ID

Line 8178: update oe_payments

8174: and line_id = p_line_id
8175: and header_id = p_header_id;
8176: ELSE
8177: -- header level payments
8178: update oe_payments
8179: set credit_card_approval_code = p_auth_code
8180: , credit_card_approval_date = p_auth_date
8181: , tangible_id = p_tangible_id
8182: , last_updated_by = FND_GLOBAL.USER_ID