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.AR_INVOICE_API_PUB dependencies on RA_CUSTOMER_TRX

Line 362: l_trx_date ra_customer_trx.trx_date%type;

358: l_api_version CONSTANT NUMBER := 1.0;
359:
360: l_trx_system_parameters_rec AR_INVOICE_DEFAULT_PVT.trx_system_parameters_rec_type;
361: l_trx_profile_rec AR_INVOICE_DEFAULT_PVT.trx_profile_rec_type;
362: l_trx_date ra_customer_trx.trx_date%type;
363: x_errmsg VARCHAR2(2000);
364: l_batch_id NUMBER;
365: --anuj
366: cursor org_cur is

Line 822: temp_customer_trx_id ra_customer_trx_all.customer_trx_id%type;

818: END IF;
819: IF jg_zz_ar_trx_pkg.is_reg_loc_enabled THEN
820: ar_invoice_utils.debug('calling: jg_zz_ar_trx_pkg.is_reg_loc_enabled');
821: DECLARE
822: temp_customer_trx_id ra_customer_trx_all.customer_trx_id%type;
823: p_return_flag boolean;
824: p_return_code number;
825: p_return_message varchar2(1024);
826: BEGIN

Line 851: temp_customer_trx_id ra_customer_trx_all.customer_trx_id%type;

847: */
848: IF JG_ZZ_AR_AUTO_INVOICE.is_reg_loc_enabled THEN
849: ar_invoice_utils.debug (' Calling JL Code Hook');
850: DECLARE
851: temp_customer_trx_id ra_customer_trx_all.customer_trx_id%type;
852: t_code number;
853: t_errmsg varchar2(1024);
854: BEGIN
855: temp_customer_trx_id := AR_INVOICE_API_PUB.g_customer_trx_id;

Line 859: FROM ra_customer_trx ct

855: temp_customer_trx_id := AR_INVOICE_API_PUB.g_customer_trx_id;
856: JG_ZZ_AR_AUTO_INVOICE.Trx_Num_Upd_Single_API(temp_customer_trx_id);
857: UPDATE ar_payment_schedules ps
858: SET trx_number = (SELECT ct.trx_number
859: FROM ra_customer_trx ct
860: WHERE ct.customer_trx_id =temp_customer_trx_id)
861: WHERE ps.customer_trx_id = temp_customer_trx_id;
862: EXCEPTION
863: WHEN OTHERS THEN

Line 1209: p_trx_rec IN OUT NOCOPY ra_customer_trx%rowtype,

1205: +===========================================================================*/
1206:
1207: PROCEDURE Get_Flags(
1208: p_context_rec IN Context_Rec_Type,
1209: p_trx_rec IN OUT NOCOPY ra_customer_trx%rowtype,
1210: p_type_rec IN OUT NOCOPY ra_cust_trx_types%rowtype,
1211: p_posted_flag IN OUT NOCOPY VARCHAR2,
1212: p_activity_flag IN OUT NOCOPY VARCHAR2,
1213: p_printed_flag IN OUT NOCOPY VARCHAR2,

Line 1329: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,

1325: | |
1326: +===========================================================================*/
1327:
1328: PROCEDURE Validate_Delete_Transaction(
1329: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
1330: p_trx_rec IN OUT NOCOPY ra_customer_trx%rowtype,
1331: p_type_rec IN OUT NOCOPY ra_cust_trx_types%rowtype,
1332: p_return_status OUT NOCOPY VARCHAR2
1333: ) IS

Line 1330: p_trx_rec IN OUT NOCOPY ra_customer_trx%rowtype,

1326: +===========================================================================*/
1327:
1328: PROCEDURE Validate_Delete_Transaction(
1329: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
1330: p_trx_rec IN OUT NOCOPY ra_customer_trx%rowtype,
1331: p_type_rec IN OUT NOCOPY ra_cust_trx_types%rowtype,
1332: p_return_status OUT NOCOPY VARCHAR2
1333: ) IS
1334:

Line 1547: PROCEDURE Delete_Trxn_Extn_Details(p_trx_rec IN ra_customer_trx%rowtype,

1543: | mpsingh 20-jun-2008 Created |
1544: | |
1545: +===========================================================================*/
1546:
1547: PROCEDURE Delete_Trxn_Extn_Details(p_trx_rec IN ra_customer_trx%rowtype,
1548: p_return_status OUT NOCOPY VARCHAR2
1549: ) IS
1550:
1551: l_payer_rec IBY_FNDCPT_COMMON_PUB.payercontext_rec_type;

Line 1558: l_payment_trxn_extn_id ra_customer_trx.PAYMENT_TRXN_EXTENSION_ID%TYPE;

1554: l_payment_channel ar_receipt_methods.payment_channel_code%type;
1555: x_msg_count NUMBER;
1556: x_msg_data VARCHAR2(240);
1557: x_return_status VARCHAR2(240);
1558: l_payment_trxn_extn_id ra_customer_trx.PAYMENT_TRXN_EXTENSION_ID%TYPE;
1559: l_fnd_api_constants_rec ar_bills_main.fnd_api_constants_type := ar_bills_main.get_fnd_api_constants_rec;
1560: Begin
1561: ar_invoice_utils.debug('AR_INVOICE_API_PUB.Delete_Trxn_Extn_Details()+ ');
1562:

Line 1668: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,

1664: p_api_version IN number,
1665: p_init_msg_list IN varchar2 := FND_API.G_FALSE,
1666: p_commit IN varchar2 := FND_API.G_FALSE,
1667: p_validation_level IN varchar2 := FND_API.G_VALID_LEVEL_FULL,
1668: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
1669: p_return_status OUT NOCOPY varchar2,
1670: p_msg_count IN OUT NOCOPY NUMBER,
1671: p_msg_data IN OUT NOCOPY varchar2,
1672: p_errors IN OUT NOCOPY arp_trx_validate.Message_Tbl_Type

Line 1679: l_trx_rec ra_customer_trx%rowtype;

1675: l_api_name CONSTANT VARCHAR2(20) := 'Delete_Transaction';
1676: l_api_version CONSTANT NUMBER := 1.0;
1677: l_message VARCHAR2(1000);
1678: l_return_status VARCHAR2(10);
1679: l_trx_rec ra_customer_trx%rowtype;
1680: l_type_rec ra_cust_trx_types%rowtype;
1681: l_commitment_rec arp_process_commitment.commitment_rec_type;
1682: l_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
1683: l_amount ra_cust_trx_line_gl_dist.amount%type;

Line 2051: p_interface_line_attribute6 IN ra_customer_trx_lines.interface_line_attribute6%type DEFAULT NULL,

2047: -- Bug12668756
2048: PROCEDURE GET_TRXN_LINE_BALANCE(
2049: p_api_version IN NUMBER,
2050: p_customer_trx_id IN NUMBER,
2051: p_interface_line_attribute6 IN ra_customer_trx_lines.interface_line_attribute6%type DEFAULT NULL,
2052: x_amount_due_remaining OUT NOCOPY NUMBER,
2053: x_acctd_amount_due_remaining OUT NOCOPY NUMBER,
2054: x_return_status OUT NOCOPY VARCHAR2,
2055: x_msg_count OUT NOCOPY NUMBER,

Line 2073: FROM RA_CUSTOMER_TRX

2069: IF p_interface_line_attribute6 IS NULL THEN
2070: BEGIN
2071: SELECT count(1)
2072: INTO l_count
2073: FROM RA_CUSTOMER_TRX
2074: WHERE customer_trx_id = p_customer_trx_id;
2075:
2076: IF l_count = 0 THEN
2077: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2087: ra_customer_trx ct,

2083: SUM(NVL(PS.ACCTD_AMOUNT_DUE_REMAINING, 0 ))
2084: INTO x_amount_due_remaining,
2085: x_acctd_amount_due_remaining
2086: FROM ra_cust_Trx_types ctt,
2087: ra_customer_trx ct,
2088: ar_payment_schedules ps
2089: WHERE ctt.cust_Trx_type_id = ct.cust_trx_type_id
2090: AND ct.customer_trx_id = ps.customer_trx_id
2091: AND ctt.ACCOUNTING_AFFECT_FLAG = 'Y'

Line 2104: FROM RA_CUSTOMER_TRX_LINES

2100: ELSE
2101: BEGIN
2102: SELECT count(1)
2103: INTO l_count
2104: FROM RA_CUSTOMER_TRX_LINES
2105: WHERE customer_trx_id = p_customer_trx_id
2106: AND INTERFACE_LINE_ATTRIBUTE6 = p_interface_line_attribute6;
2107:
2108: IF l_count = 0 THEN

Line 2119: ra_customer_trx ct,

2115: SUM(NVL(ACCTD_AMOUNT_DUE_REMAINING, 0 ))
2116: INTO x_amount_due_remaining,
2117: x_acctd_amount_due_remaining
2118: FROM ra_batch_sources ra,
2119: ra_customer_trx ct,
2120: ra_customer_trx_lines ctl
2121: WHERE ra.batch_source_id = ct.batch_source_id
2122: AND ct.customer_trx_id = ctl.customer_trx_id
2123: AND nvl(gen_line_level_bal_flag,'N') = 'Y'

Line 2120: ra_customer_trx_lines ctl

2116: INTO x_amount_due_remaining,
2117: x_acctd_amount_due_remaining
2118: FROM ra_batch_sources ra,
2119: ra_customer_trx ct,
2120: ra_customer_trx_lines ctl
2121: WHERE ra.batch_source_id = ct.batch_source_id
2122: AND ct.customer_trx_id = ctl.customer_trx_id
2123: AND nvl(gen_line_level_bal_flag,'N') = 'Y'
2124: AND ctl.line_type = 'LINE'