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 5200: FROM oe_payments

5196: ,tangible_id*/
5197: ,receipt_method_id
5198: ,payment_number
5199: ,defer_payment_processing_flag
5200: FROM oe_payments
5201: WHERE payment_type_code = 'CREDIT_CARD'
5202: AND header_id = p_header_id
5203: AND line_id IS NOT NULL;
5204:

Line 5217: FROM oe_payments

5213: ,credit_card_approval_date
5214: ,tangible_id*/
5215: ,receipt_method_id
5216: ,defer_payment_processing_flag
5217: FROM oe_payments
5218: WHERE payment_type_code = 'CREDIT_CARD'
5219: AND payment_collection_event = 'INVOICE'
5220: AND line_id is null
5221: AND header_id = p_header_id;

Line 5236: FROM oe_payments

5232: ,tangible_id*/
5233: ,receipt_method_id
5234: ,payment_number
5235: ,defer_payment_processing_flag
5236: FROM oe_payments
5237: WHERE payment_type_code = 'CREDIT_CARD'
5238: AND line_id = p_line_id
5239: AND header_id = p_header_id;
5240:

Line 5469: FROM oe_payments

5465: -- as we need to include those deferred prepayment as well.
5466: BEGIN
5467: SELECT sum(nvl(payment_amount, 0))
5468: INTO l_prepaid_total
5469: FROM oe_payments
5470: WHERE payment_collection_event = 'PREPAY'
5471: AND header_id = p_header_rec.header_id;
5472: EXCEPTION WHEN NO_DATA_FOUND THEN
5473: l_prepaid_total := 0;

Line 5780: FROM OE_PAYMENTS

5776: END IF;
5777: BEGIN
5778: select trxn_extension_id
5779: into l_trxn_extension_id
5780: FROM OE_PAYMENTS
5781: WHERE HEADER_ID = p_header_rec.header_id and line_id is null
5782: AND nvl(payment_collection_event,'PREPAY') = 'INVOICE'; --bug 5020737
5783: EXCEPTION WHEN NO_DATA_FOUND THEN
5784: IF l_debug_level > 0 THEN

Line 5798: FROM OE_PAYMENTS

5794: oe_debug_pub.add('Before getting trxn id else'||l_payments_tbl(I).line_id||' and '||p_header_rec.header_id);
5795: END IF;
5796: select trxn_extension_id
5797: into l_trxn_extension_id
5798: FROM OE_PAYMENTS
5799: WHERE line_id = l_payments_tbl(I).line_id
5800: AND header_id = p_header_rec.header_id
5801: AND payment_type_code <> 'COMMITMENT';
5802:

Line 6623: -- update oe_payments table

6619: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6620: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6621: END IF;
6622:
6623: -- update oe_payments table
6624: UPDATE oe_payments
6625: SET trxn_extension_id = l_trxn_extension_id
6626: WHERE trxn_extension_id = p_trxn_extension_id
6627: AND header_id = p_header_id --bug 5209584

Line 6624: UPDATE oe_payments

6620: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6621: END IF;
6622:
6623: -- update oe_payments table
6624: UPDATE oe_payments
6625: SET trxn_extension_id = l_trxn_extension_id
6626: WHERE trxn_extension_id = p_trxn_extension_id
6627: AND header_id = p_header_id --bug 5209584
6628: AND nvl(line_id,-1) = nvl(p_line_id,-1)

Line 6679: -- update oe_payments table

6675: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6676: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6677: END IF;
6678:
6679: -- update oe_payments table
6680: UPDATE oe_payments
6681: SET trxn_extension_id = l_trxn_extension_id
6682: WHERE trxn_extension_id = p_trxn_extension_id
6683: AND header_id = p_header_id --bug 5209584

Line 6680: UPDATE oe_payments

6676: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6677: END IF;
6678:
6679: -- update oe_payments table
6680: UPDATE oe_payments
6681: SET trxn_extension_id = l_trxn_extension_id
6682: WHERE trxn_extension_id = p_trxn_extension_id
6683: AND header_id = p_header_id --bug 5209584
6684: AND nvl(line_id,-1) = nvl(p_line_id,-1)

Line 6806: FROM oe_payments op

6802: --pnpl added the Do_Commitment_Sequencing check
6803: IF OE_Commitment_Pvt.Do_Commitment_Sequencing THEN
6804: SELECT SUM(nvl(op.commitment_applied_amount,0))
6805: INTO l_commitment_applied
6806: FROM oe_payments op
6807: WHERE op.line_id = p_line_id
6808: AND op.header_id = p_header_id
6809: AND NOT EXISTS
6810: (SELECT 'Non Invoiceable Item Line'

Line 7073: FROM oe_payments op

7069: IF OE_Commitment_Pvt.Do_Commitment_Sequencing THEN
7070: -- Select the committment applied amount
7071: SELECT SUM(nvl(op.commitment_applied_amount,0))
7072: INTO l_commitment_applied
7073: FROM oe_payments op
7074: WHERE op.line_id = p_line_id
7075: AND op.header_id = p_header_id
7076: AND NOT EXISTS
7077: (SELECT 'Non Invoiceable Item Line'

Line 7295: FROM oe_payments op,

7291: IF OE_Commitment_Pvt.Do_Commitment_Sequencing THEN
7292: -- Select the committment applied amount if Commitment Sequencing "On"
7293: SELECT SUM(ROUND(nvl(op.commitment_applied_amount,0),OE_ORDER_UTIL.G_Precision))
7294: INTO l_commitment_total
7295: FROM oe_payments op,
7296: oe_order_lines_all ool --bug3225795
7297: WHERE op.header_id = p_header_id
7298: AND ool.header_id = p_header_id --bug3225795
7299: AND nvl(ool.invoice_interface_status_code,'NO') <> 'YES' --bug3225795

Line 7521: update oe_payments

7517: */
7518:
7519: IF p_line_id IS NOT NULL THEN
7520: -- line level payments
7521: update oe_payments
7522: set credit_card_approval_code = p_auth_code
7523: , credit_card_approval_date = p_auth_date
7524: , tangible_id = p_tangible_id
7525: , last_updated_by = FND_GLOBAL.USER_ID

Line 7534: update oe_payments

7530: and line_id = p_line_id
7531: and header_id = p_header_id;
7532: ELSE
7533: -- header level payments
7534: update oe_payments
7535: set credit_card_approval_code = p_auth_code
7536: , credit_card_approval_date = p_auth_date
7537: , tangible_id = p_tangible_id
7538: , last_updated_by = FND_GLOBAL.USER_ID