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.CE_BAT_API dependencies on CE_PAYMENT_TRANSACTIONS

Line 56: G_bat_payment_offset_ccid CE_PAYMENT_TRANSACTIONS.payment_offset_ccid%TYPE := NULL;

52: -- System parameters
53: G_sp_authorize_flag CE_SYSTEM_PARAMETERS.authorization_bat%TYPE := NULL;
54:
55: -- Transfer
56: G_bat_payment_offset_ccid CE_PAYMENT_TRANSACTIONS.payment_offset_ccid%TYPE := NULL;
57: G_bat_receipt_offset_ccid CE_PAYMENT_TRANSACTIONS.receipt_offset_ccid%TYPE := NULL;
58: G_bat_statement_line_id CE_STATEMENT_LINES.statement_line_id%TYPE := NULL;
59: G_bat_currency_code CE_STATEMENT_LINES.currency_code%TYPE := NULL;
60: G_bat_created_from_dir CE_STATEMENT_LINES.trx_type%TYPE := 'PAYMENT';

Line 57: G_bat_receipt_offset_ccid CE_PAYMENT_TRANSACTIONS.receipt_offset_ccid%TYPE := NULL;

53: G_sp_authorize_flag CE_SYSTEM_PARAMETERS.authorization_bat%TYPE := NULL;
54:
55: -- Transfer
56: G_bat_payment_offset_ccid CE_PAYMENT_TRANSACTIONS.payment_offset_ccid%TYPE := NULL;
57: G_bat_receipt_offset_ccid CE_PAYMENT_TRANSACTIONS.receipt_offset_ccid%TYPE := NULL;
58: G_bat_statement_line_id CE_STATEMENT_LINES.statement_line_id%TYPE := NULL;
59: G_bat_currency_code CE_STATEMENT_LINES.currency_code%TYPE := NULL;
60: G_bat_created_from_dir CE_STATEMENT_LINES.trx_type%TYPE := 'PAYMENT';
61: G_sl_cashflow_direction VARCHAR2(30) := NULL;

Line 512: FROM ce_payment_transactions pt

508:
509:
510: SELECT count(*)
511: INTO l_cnt
512: FROM ce_payment_transactions pt
513: WHERE pt.create_from_stmtline_id = p_statement_line_id
514: AND pt.source_bank_account_id = p_source_ba_id
515: AND pt.destination_bank_account_id = p_destination_ba_id
516: AND trunc(pt.transaction_date) = trunc(p_transfer_date)

Line 528: FROM ce_payment_transactions

524:
525: -- Check if a Cashflow with similar date, amount and reference_number has already been generated for the source account.
526: SELECT Count(*)
527: INTO l_cnt
528: FROM ce_payment_transactions
529: WHERE bank_trxn_number = l_bank_trx_number
530: AND transaction_date = l_trx_date
531: AND payment_amount = l_amount
532: AND CREATE_FROM_STMTLINE_ID IS NOT NULL;

Line 570: FROM ce_payment_transactions pt

566:
567: ELSIF (p_called_by = 'CL') THEN
568: SELECT count(*)
569: INTO l_cnt
570: FROM ce_payment_transactions pt
571: WHERE
572: pt.source_bank_account_id = p_source_ba_id
573: AND pt.destination_bank_account_id = p_destination_ba_id
574: AND trunc(pt.transaction_date) = trunc(p_transfer_date)

Line 878: ce_payment_transactions pt

874: INTO g_source_bank_account_name,
875: g_dest_bank_account_name
876: FROM ce_bank_accounts sba,
877: ce_bank_accounts d_ba,
878: ce_payment_transactions pt
879: WHERE pt.trxn_reference_number=p_trxn_reference_number
880: AND sba.bank_account_id=pt.source_bank_account_id
881: AND d_ba.bank_account_id=pt.destination_bank_account_id;
882: END IF;

Line 1114: UPDATE ce_payment_transactions

1110: log_msg(l_debug_proc,'G_bat_receipt_offset_ccid = '||to_char(p_reciprocal_ccid));
1111:
1112: -- 7357191: changed values to Global variables
1113: -- 14834217: added who columns
1114: UPDATE ce_payment_transactions
1115: SET payment_offset_ccid = G_bat_payment_offset_ccid,
1116: receipt_offset_ccid = G_bat_receipt_offset_ccid,
1117: LAST_UPDATED_BY = FND_GLOBAL.user_id,
1118: LAST_UPDATE_DATE = sysdate,

Line 1234: FROM ce_payment_transactions

1230: THEN
1231: -- called by UI
1232: SELECT count(*)
1233: INTO l_cnt
1234: FROM ce_payment_transactions
1235: WHERE payment_request_number = p_pay_proc_req_code;
1236:
1237: IF l_cnt > 0
1238: THEN

Line 1251: UPDATE ce_payment_transactions

1247: p_result := 'FAILURE';
1248: ELSE
1249: log_msg(l_debug_proc,'Payment process request_id='||l_request_id||', payment_request_number='||p_pay_proc_req_code);
1250: -- 14834217: Added who columns
1251: UPDATE ce_payment_transactions
1252: SET trxn_status_code = 'IN_PROCESS',
1253: LAST_UPDATED_BY = FND_GLOBAL.user_id,
1254: LAST_UPDATE_DATE = sysdate,
1255: LAST_UPDATE_LOGIN = FND_GLOBAL.user_id

Line 1267: SELECT ce_payment_transactions_s.nextval

1263: ELSIF p_called_by = 'AUTO'
1264: THEN
1265: -- called by validate_transfer
1266: -- generate the unique payment process request code
1267: SELECT ce_payment_transactions_s.nextval
1268: INTO l_pay_proc_req_code
1269: FROM dual;
1270:
1271: -- stamp the transfer with the payment process request code

Line 1273: UPDATE ce_payment_transactions

1269: FROM dual;
1270:
1271: -- stamp the transfer with the payment process request code
1272: -- 14834217: Added who columns
1273: UPDATE ce_payment_transactions
1274: SET payment_request_number = l_pay_proc_req_code,
1275: LAST_UPDATED_BY = FND_GLOBAL.user_id,
1276: LAST_UPDATE_DATE = sysdate,
1277: LAST_UPDATE_LOGIN = FND_GLOBAL.user_id

Line 1374: ce_payment_transactions pt

1370:
1371: CURSOR cashflows_c (p_trxn_ref_number NUMBER) IS
1372: SELECT cf.cashflow_id
1373: FROM ce_cashflows cf,
1374: ce_payment_transactions pt
1375: WHERE cf.trxn_reference_number = pt.trxn_reference_number
1376: AND pt.trxn_status_code = 'SETTLED'
1377: AND cf.trxn_reference_number = p_trxn_ref_number;
1378:

Line 1441: | into the ce_payment_transactions table

1437: | PUBLIC PROCEDURE |
1438: | populate_transfer
1439: | DESCRIPTION |
1440: | This procedure is dumps the data gathered by initiate_transfer |
1441: | into the ce_payment_transactions table
1442: | |
1443: | HISTORY |
1444: | 17-JUL-2005 Shaik Vali Created |
1445: --------------------------------------------------------------------- */

Line 1572: UPDATE ce_payment_transactions

1568: /* Bug7559093, As p_payment_reference_number changed to VARCHAR2
1569: the comparision <> 0 changed to <>'0' */
1570: IF (p_payment_reference_number <>'0')
1571: THEN
1572: UPDATE ce_payment_transactions
1573: SET bank_trxn_number = p_payment_reference_number
1574: WHERE trxn_reference_number = p_pay_trxn_number;
1575:
1576: UPDATE ce_cashflows

Line 1713: ce_payment_transactions

1709: l_docs_payable_rec.remittance_message2,
1710: l_docs_payable_rec.remittance_message3,
1711: l_docs_payable_rec.document_payable_id
1712: FROM
1713: ce_payment_transactions
1714: WHERE
1715: trxn_reference_number = p_trxn_reference_number;
1716:
1717: log_msg(l_debug_proc,'inserting data into iby_docs_payable_gt');

Line 2036: ce_payment_transactions

2032: l_ext_payee_rec.payer_org_type,
2033: l_ext_payee_rec.payment_function,
2034: l_ext_payee_rec.exclusive_pay_flag
2035: FROM
2036: ce_payment_transactions
2037: WHERE trxn_reference_number = p_trxn_reference_number;
2038:
2039: l_ext_payee_tab(1) := l_ext_payee_rec;
2040:

Line 2105: ce_payment_transactions

2101: l_payee_rec.party_id,
2102: l_payee_rec.party_site_id,
2103: l_payee_rec.org_id
2104: FROM
2105: ce_payment_transactions
2106: WHERE
2107: trxn_reference_number = p_trxn_reference_number;
2108:
2109: log_msg(l_debug_proc,'l_payee_rec.party_id = ' || l_payee_rec.party_id);

Line 2188: UPDATE ce_payment_transactions

2184: l_return_status);
2185:
2186: IF (l_return_status = FND_API.G_RET_STS_SUCCESS)
2187: THEN
2188: UPDATE ce_payment_transactions
2189: SET ext_bank_account_id = l_ext_bank_account_id
2190: WHERE trxn_reference_number = p_trxn_reference_number;
2191:
2192: p_result := 'SUCCESS';