APPS.ARP_PROCESS_DET_PKG dependencies on AR_RECEIVABLE_APPLICATIONS

Line 310: from ar_receivable_applications_all

306: from ar_distributions_all ard
307: WHERE ard.source_table = 'RA'
308: AND ard.source_id IN
309: (select receivable_application_id
310: from ar_receivable_applications_all
311: where applied_customer_trx_id = g_customer_trx.customer_trx_id)
312: GROUP BY ard.activity_bucket,
313: ard.ref_account_class,
314: ard.ref_customer_trx_line_id) amt_tab

Line 410: from ar_receivable_applications_all

406: from ar_distributions_all ard
407: WHERE ard.source_table = 'RA'
408: AND ard.source_id IN
409: (select receivable_application_id
410: from ar_receivable_applications_all
411: where applied_customer_trx_id = g_customer_trx.customer_trx_id)
412: GROUP BY ard.activity_bucket,
413: ard.ref_account_class,
414: ard.ref_customer_trx_line_id) amt_tab

Line 504: from ar_receivable_applications_all

500: from ar_distributions_all ard
501: WHERE ard.source_table = 'RA'
502: AND ard.source_id IN
503: (select receivable_application_id
504: from ar_receivable_applications_all
505: where applied_customer_trx_id = g_customer_trx.customer_trx_id)
506: GROUP BY ard.activity_bucket,
507: ard.ref_account_class,
508: ard.ref_customer_trx_line_id) amt_tab

Line 1533: x_ra_rec IN OUT NOCOPY ar_receivable_applications%ROWTYPE,

1529:
1530:
1531: PROCEDURE copy_app_rec
1532: (p_app_rec IN ar_receivable_apps_gt%ROWTYPE,
1533: x_ra_rec IN OUT NOCOPY ar_receivable_applications%ROWTYPE,
1534: x_return_status IN OUT NOCOPY VARCHAR2)
1535: IS
1536: BEGIN
1537: arp_standard.debug('copy_app_rec +');

Line 1606: l_ra_rec ar_receivable_applications%ROWTYPE;

1602: (p_app_rec IN ar_receivable_apps_gt%ROWTYPE,
1603: p_gt_id IN VARCHAR2,
1604: x_return_status IN OUT NOCOPY VARCHAR2)
1605: IS
1606: l_ra_rec ar_receivable_applications%ROWTYPE;
1607: BEGIN
1608: arp_standard.debug('do_apply +');
1609: copy_app_rec(p_app_rec => p_app_rec,
1610: x_ra_rec => l_ra_rec,

Line 1930: SELECT ar_receivable_applications_s.nextval

1926:
1927: get_rec_ps(p_cr_id => g_cash_receipt.cash_receipt_id,
1928: x_return_status => x_return_status);
1929:
1930: SELECT ar_receivable_applications_s.nextval
1931: INTO g_app_ra_id
1932: FROM dual;
1933:
1934: IF x_return_status <> fnd_api.g_ret_sts_success THEN

Line 2245: x_ra_rec IN OUT NOCOPY ar_receivable_applications%ROWTYPE)

2241: END application_execute;
2242:
2243: PROCEDURE get_app_ra_amounts
2244: (p_gt_id IN NUMBER,
2245: x_ra_rec IN OUT NOCOPY ar_receivable_applications%ROWTYPE)
2246: IS
2247: CURSOR c IS
2248: SELECT SUM(AMOUNT_APPLIED),
2249: SUM(AMOUNT_APPLIED_FROM),

Line 2352: x_ra_rec OUT NOCOPY ar_receivable_applications%ROWTYPE,

2348: --{Cross Currency
2349: p_amount_applied_from IN NUMBER DEFAULT NULL,
2350: p_trans_to_receipt_rate IN NUMBER DEFAULT NULL,
2351: --}
2352: x_ra_rec OUT NOCOPY ar_receivable_applications%ROWTYPE,
2353: x_return_status OUT NOCOPY VARCHAR2,
2354: x_msg_count OUT NOCOPY NUMBER,
2355: x_msg_data OUT NOCOPY VARCHAR2)
2356: IS

Line 3227: p_app_rec IN ar_receivable_applications%ROWTYPE,

3223:
3224:
3225: PROCEDURE verif_int_app_line_tax
3226: (p_customer_trx IN ra_customer_trx%ROWTYPE,
3227: p_app_rec IN ar_receivable_applications%ROWTYPE,
3228: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type,
3229: p_gt_id IN NUMBER,
3230: p_line_flag IN VARCHAR2 DEFAULT 'INTERFACE',
3231: p_tax_flag IN VARCHAR2 DEFAULT 'INTERFACE',