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.ARP_RECEIPTS_MAIN dependencies on AR_RECEIVABLE_APPLICATIONS

Line 53: p_app_rec OUT NOCOPY ar_receivable_applications%ROWTYPE ,

49: PROCEDURE Reverse_Receipt_CM;
50:
51: PROCEDURE Get_Doc_Entitity_Data (
52: p_level IN VARCHAR2 ,
53: p_app_rec OUT NOCOPY ar_receivable_applications%ROWTYPE ,
54: p_cr_rec OUT NOCOPY ar_cash_receipts%ROWTYPE ,
55: p_cust_inv_rec OUT NOCOPY ra_customer_trx%ROWTYPE ,
56: p_cust_cm_rec OUT NOCOPY ra_customer_trx%ROWTYPE ,
57: p_ctlgd_cm_rec OUT NOCOPY ra_cust_trx_line_gl_dist%ROWTYPE ,

Line 79: p_app_rec IN ar_receivable_applications%ROWTYPE ,

75: --}
76: );
77:
78: PROCEDURE Create_Ae_Lines_RA(
79: p_app_rec IN ar_receivable_applications%ROWTYPE ,
80: p_cr_rec IN ar_cash_receipts%ROWTYPE ,
81: p_cust_inv_rec IN ra_customer_trx%ROWTYPE ,
82: p_cust_cm_rec IN ra_customer_trx%ROWTYPE ,
83: p_ctlgd_cm_rec IN ra_cust_trx_line_gl_dist%ROWTYPE ,

Line 462: l_status ar_receivable_applications.status%TYPE;

458: | for source_id
459: * ======================================================================*/
460: PROCEDURE Delete_RA(p_ae_deleted OUT NOCOPY BOOLEAN) IS
461:
462: l_status ar_receivable_applications.status%TYPE;
463:
464: l_ar_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;
465:
466: BEGIN

Line 476: FROM ar_receivable_applications ra

472: | Verify that the source id is a valid candidate for deletion |
473: +-------------------------------------------------------------------*/
474: SELECT ra.status
475: INTO l_status
476: FROM ar_receivable_applications ra
477: WHERE ra.receivable_application_id = g_ae_doc_rec.source_id
478: /* bug 1454382 : when a receipt application is unapplied, the reversal_gl_date is populated
479: even when it's only a reversal of the application and not the whole receipt, hence, this
480: condition was causing an EXCEPTION when the receipt was being deleted.

Line 693: ar_receivable_applications app,

689: line_trx_type.type trx_type
690: --}
691: from ar_distributions ard,
692: ar_distributions adjsrctp,
693: ar_receivable_applications app,
694: --{ For CM APP on legacy from 11i
695: (SELECT tt.type type,
696: ctl.customer_trx_line_id customer_trx_line_id,
697: ctl.line_type line_type

Line 764: ar_receivable_applications app,

760: ,'ADDCTL')))) WHICH_BUCKET,
761: line_trx_type.type trx_type
762: --}
763: from ar_distributions ard,
764: ar_receivable_applications app,
765: ar_distributions adjsrctp,
766: -- For CM APP on legacy from 11i
767: (SELECT tt.type type,
768: ctl.customer_trx_line_id customer_trx_line_id,

Line 796: FROM ar_receivable_applications app,

792: app.applied_customer_trx_id trx_id,
793: cm.upgrade_method cm_upgrade_method,
794: app.customer_trx_id cm_id,
795: app.upgrade_method app_upgrade_method
796: FROM ar_receivable_applications app,
797: ra_customer_trx trx,
798: ra_customer_trx cm
799: WHERE app.receivable_application_id = p_app_id
800: AND app.applied_customer_trx_id = trx.customer_trx_id

Line 838: from ar_receivable_applications app ,

834: ctcm.exchange_date cm_exchange_date,
835: ctcm.trx_date cm_trx_date,
836: ctcm.bill_to_customer_id cm_bill_to_customer_id,
837: ctcm.bill_to_site_use_id cm_bill_to_site_use_id
838: from ar_receivable_applications app ,
839: ra_customer_trx ctinv,
840: ra_customer_trx ctcm
841: where app.receivable_application_id = g_ae_doc_rec.source_id_old
842: and app.status = 'APP'

Line 863: l_app_upg_method ar_receivable_applications.upgrade_method%type;

859: l_acctd_amount_applied_to NUMBER;
860: --{3377004
861: l_ctl_rem_amt ctl_rem_amt_type;
862: l_index NUMBER := 0;
863: l_app_upg_method ar_receivable_applications.upgrade_method%type;
864: l_trx_upg_method ra_customer_trx.upgrade_method%type;
865:
866: --}
867: BEGIN

Line 1140: UPDATE ar_receivable_applications

1136: END LOOP;
1137:
1138: --{bug#4554703 - cm reversal needs to flag the app record as r12
1139: -- always. There should not be any differences
1140: UPDATE ar_receivable_applications
1141: SET upgrade_method = 'R12'
1142: WHERE receivable_application_id = g_ae_doc_rec.source_id;
1143: --}
1144:

Line 1285: p_app_rec OUT NOCOPY ar_receivable_applications%ROWTYPE ,

1281: | of receipt's UNAPP.
1282: * ======================================================================*/
1283: PROCEDURE Get_Doc_Entitity_Data (
1284: p_level IN VARCHAR2 ,
1285: p_app_rec OUT NOCOPY ar_receivable_applications%ROWTYPE ,
1286: p_cr_rec OUT NOCOPY ar_cash_receipts%ROWTYPE ,
1287: p_cust_inv_rec OUT NOCOPY ra_customer_trx%ROWTYPE ,
1288: p_cust_cm_rec OUT NOCOPY ra_customer_trx%ROWTYPE ,
1289: p_ctlgd_cm_rec OUT NOCOPY ra_cust_trx_line_gl_dist%ROWTYPE ,

Line 1300: l_id_dummy ar_receivable_applications.code_combination_id%TYPE;

1296: l_concat_segs varchar2(240) ;
1297: l_concat_ids varchar2(2000) ;
1298: l_concat_descs varchar2(2000) ;
1299: l_arerror varchar2(2000) ;
1300: l_id_dummy ar_receivable_applications.code_combination_id%TYPE;
1301: l_cr_unapp_ccid ar_receivable_applications.code_combination_id%TYPE;
1302: l_le_id NUMBER;
1303: l_effective_date DATE;
1304: l_msg_count NUMBER;

Line 1301: l_cr_unapp_ccid ar_receivable_applications.code_combination_id%TYPE;

1297: l_concat_ids varchar2(2000) ;
1298: l_concat_descs varchar2(2000) ;
1299: l_arerror varchar2(2000) ;
1300: l_id_dummy ar_receivable_applications.code_combination_id%TYPE;
1301: l_cr_unapp_ccid ar_receivable_applications.code_combination_id%TYPE;
1302: l_le_id NUMBER;
1303: l_effective_date DATE;
1304: l_msg_count NUMBER;
1305: l_msg_data VARCHAR2(1024);

Line 1461: from ar_receivable_applications ra ,

1457: p_cust_cm_rec.customer_trx_id ,
1458: p_ctlgd_cm_rec.code_combination_id ,
1459: l_gain_loss_ccid ,
1460: l_cr_unapp_ccid
1461: from ar_receivable_applications ra ,
1462: ar_cash_receipts cr ,
1463: ar_receipt_method_accounts rma ,
1464: ra_customer_trx ctinv ,
1465: ra_customer_trx ctcm ,

Line 1901: l_app_rec ar_receivable_applications%ROWTYPE ;

1897: --}
1898: ) IS
1899:
1900: l_miscel_rec g_ae_miscel_rec_type ;
1901: l_app_rec ar_receivable_applications%ROWTYPE ;
1902: l_cr_rec ar_cash_receipts%ROWTYPE ;
1903: l_cust_inv_rec ra_customer_trx%ROWTYPE ;
1904: l_cust_cm_rec ra_customer_trx%ROWTYPE ;
1905: l_ctlgd_cm_rec ra_cust_trx_line_gl_dist%ROWTYPE ;

Line 1947: UPDATE ar_receivable_applications SET upgrade_method = 'R12'

1943: p_app_rec => l_app_rec,
1944: p_gt_id => p_gt_id,
1945: p_inv_currency => l_cust_inv_rec.invoice_currency_code);
1946:
1947: UPDATE ar_receivable_applications SET upgrade_method = 'R12'
1948: WHERE receivable_application_id = l_app_rec.receivable_application_id;
1949:
1950: END IF;
1951: END IF;

Line 2051: p_app_rec IN ar_receivable_applications%ROWTYPE ,

2047: | 12-MAY-2003 J.Beckett Bug 2821139 As above for payment netting
2048: | i.e. where receivables_trx_id = -16
2049: * =================================================================================*/
2050: PROCEDURE Create_Ae_Lines_RA(
2051: p_app_rec IN ar_receivable_applications%ROWTYPE ,
2052: p_cr_rec IN ar_cash_receipts%ROWTYPE ,
2053: p_cust_inv_rec IN ra_customer_trx%ROWTYPE ,
2054: p_cust_cm_rec IN ra_customer_trx%ROWTYPE ,
2055: p_ctlgd_cm_rec IN ra_cust_trx_line_gl_dist%ROWTYPE ,

Line 2063: l_app_id ar_receivable_applications.receivable_application_id%TYPE;

2059: p_from_llca_call IN VARCHAR2,
2060: p_gt_id IN NUMBER
2061: --}
2062: ) IS
2063: l_app_id ar_receivable_applications.receivable_application_id%TYPE;
2064: l_ael_line_rec ae_line_rec_type;
2065: l_empty_ael_line_rec ae_line_rec_type;
2066: l_adj_rec ar_adjustments%ROWTYPE;
2067: l_ae_line_tbl ae_line_tbl_type;

Line 2071: l_app_rec ar_receivable_applications%ROWTYPE;

2067: l_ae_line_tbl ae_line_tbl_type;
2068: l_ae_ctr BINARY_INTEGER := 0;
2069: l_ctr BINARY_INTEGER;
2070: --{BUG#2927254
2071: l_app_rec ar_receivable_applications%ROWTYPE;
2072: l_cust_inv_cm_rec ra_customer_trx%ROWTYPE;
2073: l_i BINARY_INTEGER;
2074: l_j BINARY_INTEGER;
2075: l_amount_applied NUMBER;

Line 2791: update ar_receivable_applications

2787: | Remittance and Factored (with Recourse) we need to update the link id |
2788: | so the last Transaction History Record must be Standard Remitted or |
2789: | pending risk elimination |
2790: +-----------------------------------------------------------------------*/
2791: update ar_receivable_applications
2792: set link_to_trx_hist_id = (select max(th.transaction_history_id)
2793: from ar_transaction_history th
2794: where th.customer_trx_id = p_app_rec.applied_customer_trx_id
2795: and th.event = 'MATURITY_DATE'

Line 3459: Update ar_receivable_applications set code_combination_id = l_account

3455: combination_id => l_account) THEN
3456: g_ae_line_tbl(g_ae_line_ctr).account := l_account;
3457: --bug6313298
3458: IF (p_ae_line_rec.source_table = 'RA') then
3459: Update ar_receivable_applications set code_combination_id = l_account
3460: where receivable_application_id = p_ae_line_rec.source_id and status in
3461: ('ACC', 'UNID', 'UNAPP', 'ACTIVITY', 'OTHER ACC');
3462: END IF;
3463: else