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 452: l_status ar_receivable_applications.status%TYPE;

448: | for source_id
449: * ======================================================================*/
450: PROCEDURE Delete_RA(p_ae_deleted OUT NOCOPY BOOLEAN) IS
451:
452: l_status ar_receivable_applications.status%TYPE;
453:
454: l_ar_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;
455:
456: BEGIN

Line 466: FROM ar_receivable_applications ra

462: | Verify that the source id is a valid candidate for deletion |
463: +-------------------------------------------------------------------*/
464: SELECT ra.status
465: INTO l_status
466: FROM ar_receivable_applications ra
467: WHERE ra.receivable_application_id = g_ae_doc_rec.source_id
468: /* bug 1454382 : when a receipt application is unapplied, the reversal_gl_date is populated
469: even when it's only a reversal of the application and not the whole receipt, hence, this
470: condition was causing an EXCEPTION when the receipt was being deleted.

Line 745: ar_receivable_applications app,

741: ,'ADDCTL')))) WHICH_BUCKET,
742: line_trx_type.type trx_type
743: --}
744: from ar_distributions ard,
745: ar_receivable_applications app,
746: ar_distributions adjsrctp,
747: -- For CM APP on legacy from 11i
748: (SELECT tt.type type,
749: ctl.customer_trx_line_id customer_trx_line_id,

Line 776: FROM ar_receivable_applications app,

772: SELECT trx.upgrade_method trx_upgrade_method,
773: app.applied_customer_trx_id trx_id,
774: cm.upgrade_method cm_upgrade_method,
775: app.customer_trx_id cm_id
776: FROM ar_receivable_applications app,
777: ra_customer_trx trx,
778: ra_customer_trx cm
779: WHERE app.receivable_application_id = p_app_id
780: AND app.applied_customer_trx_id = trx.customer_trx_id

Line 818: from ar_receivable_applications app ,

814: ctcm.exchange_date cm_exchange_date,
815: ctcm.trx_date cm_trx_date,
816: ctcm.bill_to_customer_id cm_bill_to_customer_id,
817: ctcm.bill_to_site_use_id cm_bill_to_site_use_id
818: from ar_receivable_applications app ,
819: ra_customer_trx ctinv,
820: ra_customer_trx ctcm
821: where app.receivable_application_id = g_ae_doc_rec.source_id_old
822: and app.status = 'APP'

Line 1097: UPDATE ar_receivable_applications

1093: END LOOP;
1094:
1095: --{bug#4554703 - cm reversal needs to flag the app record as r12
1096: -- always. There should not be any differences
1097: UPDATE ar_receivable_applications
1098: SET upgrade_method = 'R12'
1099: WHERE receivable_application_id = g_ae_doc_rec.source_id;
1100: --}
1101:

Line 1242: p_app_rec OUT NOCOPY ar_receivable_applications%ROWTYPE ,

1238: | of receipt's UNAPP.
1239: * ======================================================================*/
1240: PROCEDURE Get_Doc_Entitity_Data (
1241: p_level IN VARCHAR2 ,
1242: p_app_rec OUT NOCOPY ar_receivable_applications%ROWTYPE ,
1243: p_cr_rec OUT NOCOPY ar_cash_receipts%ROWTYPE ,
1244: p_cust_inv_rec OUT NOCOPY ra_customer_trx%ROWTYPE ,
1245: p_cust_cm_rec OUT NOCOPY ra_customer_trx%ROWTYPE ,
1246: p_ctlgd_cm_rec OUT NOCOPY ra_cust_trx_line_gl_dist%ROWTYPE ,

Line 1257: l_id_dummy ar_receivable_applications.code_combination_id%TYPE;

1253: l_concat_segs varchar2(240) ;
1254: l_concat_ids varchar2(2000) ;
1255: l_concat_descs varchar2(2000) ;
1256: l_arerror varchar2(2000) ;
1257: l_id_dummy ar_receivable_applications.code_combination_id%TYPE;
1258: l_cr_unapp_ccid ar_receivable_applications.code_combination_id%TYPE;
1259: l_le_id NUMBER;
1260: l_effective_date DATE;
1261: l_msg_count NUMBER;

Line 1258: l_cr_unapp_ccid ar_receivable_applications.code_combination_id%TYPE;

1254: l_concat_ids varchar2(2000) ;
1255: l_concat_descs varchar2(2000) ;
1256: l_arerror varchar2(2000) ;
1257: l_id_dummy ar_receivable_applications.code_combination_id%TYPE;
1258: l_cr_unapp_ccid ar_receivable_applications.code_combination_id%TYPE;
1259: l_le_id NUMBER;
1260: l_effective_date DATE;
1261: l_msg_count NUMBER;
1262: l_msg_data VARCHAR2(1024);

Line 1416: from ar_receivable_applications ra ,

1412: p_cust_cm_rec.customer_trx_id ,
1413: p_ctlgd_cm_rec.code_combination_id ,
1414: l_gain_loss_ccid ,
1415: l_cr_unapp_ccid
1416: from ar_receivable_applications ra ,
1417: ar_cash_receipts cr ,
1418: ar_receipt_method_accounts rma ,
1419: ra_customer_trx ctinv ,
1420: ra_customer_trx ctcm ,

Line 1828: l_app_rec ar_receivable_applications%ROWTYPE ;

1824: --}
1825: ) IS
1826:
1827: l_miscel_rec g_ae_miscel_rec_type ;
1828: l_app_rec ar_receivable_applications%ROWTYPE ;
1829: l_cr_rec ar_cash_receipts%ROWTYPE ;
1830: l_cust_inv_rec ra_customer_trx%ROWTYPE ;
1831: l_cust_cm_rec ra_customer_trx%ROWTYPE ;
1832: l_ctlgd_cm_rec ra_cust_trx_line_gl_dist%ROWTYPE ;

Line 1874: UPDATE ar_receivable_applications SET upgrade_method = 'R12'

1870: p_app_rec => l_app_rec,
1871: p_gt_id => p_gt_id,
1872: p_inv_currency => l_cust_inv_rec.invoice_currency_code);
1873:
1874: UPDATE ar_receivable_applications SET upgrade_method = 'R12'
1875: WHERE receivable_application_id = l_app_rec.receivable_application_id;
1876:
1877: END IF;
1878: END IF;

Line 1948: p_app_rec IN ar_receivable_applications%ROWTYPE ,

1944: | 12-MAY-2003 J.Beckett Bug 2821139 As above for payment netting
1945: | i.e. where receivables_trx_id = -16
1946: * =================================================================================*/
1947: PROCEDURE Create_Ae_Lines_RA(
1948: p_app_rec IN ar_receivable_applications%ROWTYPE ,
1949: p_cr_rec IN ar_cash_receipts%ROWTYPE ,
1950: p_cust_inv_rec IN ra_customer_trx%ROWTYPE ,
1951: p_cust_cm_rec IN ra_customer_trx%ROWTYPE ,
1952: p_ctlgd_cm_rec IN ra_cust_trx_line_gl_dist%ROWTYPE ,

Line 1960: l_app_id ar_receivable_applications.receivable_application_id%TYPE;

1956: p_from_llca_call IN VARCHAR2,
1957: p_gt_id IN NUMBER
1958: --}
1959: ) IS
1960: l_app_id ar_receivable_applications.receivable_application_id%TYPE;
1961: l_ael_line_rec ae_line_rec_type;
1962: l_empty_ael_line_rec ae_line_rec_type;
1963: l_adj_rec ar_adjustments%ROWTYPE;
1964: l_ae_line_tbl ae_line_tbl_type;

Line 1968: l_app_rec ar_receivable_applications%ROWTYPE;

1964: l_ae_line_tbl ae_line_tbl_type;
1965: l_ae_ctr BINARY_INTEGER := 0;
1966: l_ctr BINARY_INTEGER;
1967: --{BUG#2927254
1968: l_app_rec ar_receivable_applications%ROWTYPE;
1969: l_cust_inv_cm_rec ra_customer_trx%ROWTYPE;
1970: l_i BINARY_INTEGER;
1971: l_j BINARY_INTEGER;
1972: l_amount_applied NUMBER;

Line 2538: update ar_receivable_applications

2534: | Remittance and Factored (with Recourse) we need to update the link id |
2535: | so the last Transaction History Record must be Standard Remitted or |
2536: | pending risk elimination |
2537: +-----------------------------------------------------------------------*/
2538: update ar_receivable_applications
2539: set link_to_trx_hist_id = (select max(th.transaction_history_id)
2540: from ar_transaction_history th
2541: where th.customer_trx_id = p_app_rec.applied_customer_trx_id
2542: and th.event = 'MATURITY_DATE'

Line 3180: Update ar_receivable_applications set code_combination_id = l_account

3176: combination_id => l_account) THEN
3177: g_ae_line_tbl(g_ae_line_ctr).account := l_account;
3178: --bug6313298
3179: IF (p_ae_line_rec.source_table = 'RA') then
3180: Update ar_receivable_applications set code_combination_id = l_account
3181: where receivable_application_id = p_ae_line_rec.source_id and status in
3182: ('ACC', 'UNID', 'UNAPP', 'ACTIVITY', 'OTHER ACC');
3183: END IF;
3184: else