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 1535: x_ra_rec IN OUT NOCOPY ar_receivable_applications%ROWTYPE,

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

Line 1608: l_ra_rec ar_receivable_applications%ROWTYPE;

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

Line 1975: SELECT ar_receivable_applications_s.nextval

1971:
1972: get_rec_ps(p_cr_id => g_cash_receipt.cash_receipt_id,
1973: x_return_status => x_return_status);
1974:
1975: SELECT ar_receivable_applications_s.nextval
1976: INTO g_app_ra_id
1977: FROM dual;
1978:
1979: IF x_return_status <> fnd_api.g_ret_sts_success THEN

Line 2305: x_ra_rec IN OUT NOCOPY ar_receivable_applications%ROWTYPE)

2301: END application_execute;
2302:
2303: PROCEDURE get_app_ra_amounts
2304: (p_gt_id IN NUMBER,
2305: x_ra_rec IN OUT NOCOPY ar_receivable_applications%ROWTYPE)
2306: IS
2307: CURSOR c IS
2308: SELECT SUM(AMOUNT_APPLIED),
2309: SUM(AMOUNT_APPLIED_FROM),

Line 2413: x_ra_rec OUT NOCOPY ar_receivable_applications%ROWTYPE,

2409: --{Cross Currency
2410: p_amount_applied_from IN NUMBER DEFAULT NULL,
2411: p_trans_to_receipt_rate IN NUMBER DEFAULT NULL,
2412: --}
2413: x_ra_rec OUT NOCOPY ar_receivable_applications%ROWTYPE,
2414: x_return_status OUT NOCOPY VARCHAR2,
2415: x_msg_count OUT NOCOPY NUMBER,
2416: x_msg_data OUT NOCOPY VARCHAR2)
2417: IS

Line 2448: x_application_ref_num ar_receivable_applications.application_ref_num%TYPE;

2444: WHERE applied_customer_trx_id = g_customer_trx.customer_trx_id;
2445: l_adj_rec ar_adjustments%ROWTYPE;
2446:
2447: x_application_ref_id NUMBER;
2448: x_application_ref_num ar_receivable_applications.application_ref_num%TYPE;
2449: x_receivable_application_id NUMBER;
2450: x_acctd_amount_applied_from NUMBER;
2451: x_acctd_amount_applied_to NUMBER;
2452: x_claim_reason_name VARCHAR2(30);

Line 3289: p_app_rec IN ar_receivable_applications%ROWTYPE,

3285:
3286:
3287: PROCEDURE verif_int_app_line_tax
3288: (p_customer_trx IN ra_customer_trx%ROWTYPE,
3289: p_app_rec IN ar_receivable_applications%ROWTYPE,
3290: p_ae_sys_rec IN arp_acct_main.ae_sys_rec_type,
3291: p_gt_id IN NUMBER,
3292: p_line_flag IN VARCHAR2 DEFAULT 'INTERFACE',
3293: p_tax_flag IN VARCHAR2 DEFAULT 'INTERFACE',