DBA Data[Home] [Help]

APPS.ARP_PROCESS_APPLICATION dependencies on ARP_GLOBAL

Line 890: functional_curr := arp_global.functional_currency;

886: IF PG_DEBUG in ('Y', 'C') THEN
887: arp_standard.debug( 'arp_process_application.update_selected_transaction()+');
888: END IF;
889:
890: functional_curr := arp_global.functional_currency;
891:
892: -- First check that all required arguments have some value
893: IF (pn_ra_id IS NULL)
894: THEN

Line 1257: l_app_rec arp_global.app_rec_type;

1253: p_reversal_date IN DATE) IS
1254:
1255: l_gl_date_closed DATE;
1256: l_actual_date_closed DATE;
1257: l_app_rec arp_global.app_rec_type;
1258:
1259: BEGIN
1260: IF PG_DEBUG in ('Y', 'C') THEN
1261: arp_standard.debug('validate_args: ' || 'arp_process_application.reversal_update_ps_recs()+');

Line 2505: WHERE a.receivables_trx_id = arp_global.G_CB_RT_ID

2501: SELECT count( distinct a.chargeback_customer_trx_id )
2502: INTO l_cb_count
2503: FROM ar_adjustments a,
2504: ar_adjustments b
2505: WHERE a.receivables_trx_id = arp_global.G_CB_RT_ID
2506: AND a.associated_cash_receipt_id = l_ass_cr_id
2507: AND a.payment_schedule_id = l_ps_id
2508: AND b.receivables_trx_id(+) = arp_global.G_CB_REV_RT_ID
2509: AND b.customer_trx_id(+) = a.chargeback_customer_trx_id

Line 2508: AND b.receivables_trx_id(+) = arp_global.G_CB_REV_RT_ID

2504: ar_adjustments b
2505: WHERE a.receivables_trx_id = arp_global.G_CB_RT_ID
2506: AND a.associated_cash_receipt_id = l_ass_cr_id
2507: AND a.payment_schedule_id = l_ps_id
2508: AND b.receivables_trx_id(+) = arp_global.G_CB_REV_RT_ID
2509: AND b.customer_trx_id(+) = a.chargeback_customer_trx_id
2510: AND b.customer_trx_id is NULL;
2511: --
2512: IF PG_DEBUG in ('Y', 'C') THEN

Line 2702: l_app_rec arp_global.app_rec_type;

2698: p_module_version IN VARCHAR2 ) IS
2699: l_adj_amount NUMBER;
2700: l_ps_id ar_payment_schedules.payment_schedule_id%TYPE;
2701: l_ass_cr_id ar_cash_receipts.cash_receipt_id%TYPE;
2702: l_app_rec arp_global.app_rec_type;
2703: l_ps_rec ar_payment_schedules%ROWTYPE;
2704:
2705: l_count NUMBER DEFAULT 0;
2706: --

Line 2714: WHERE a.receivables_trx_id = arp_global.G_CB_RT_ID

2710: a.adjustment_id,
2711: a.status
2712: FROM ar_adjustments a,
2713: ar_adjustments b
2714: WHERE a.receivables_trx_id = arp_global.G_CB_RT_ID
2715: AND a.associated_cash_receipt_id = l_ass_cr_id
2716: AND a.payment_schedule_id = l_ps_id
2717: AND b.receivables_trx_id(+) = arp_global.G_CB_REV_RT_ID
2718: AND b.customer_trx_id(+) = a.chargeback_customer_trx_id

Line 2717: AND b.receivables_trx_id(+) = arp_global.G_CB_REV_RT_ID

2713: ar_adjustments b
2714: WHERE a.receivables_trx_id = arp_global.G_CB_RT_ID
2715: AND a.associated_cash_receipt_id = l_ass_cr_id
2716: AND a.payment_schedule_id = l_ps_id
2717: AND b.receivables_trx_id(+) = arp_global.G_CB_REV_RT_ID
2718: AND b.customer_trx_id(+) = a.chargeback_customer_trx_id
2719: AND b.customer_trx_id is null;
2720: --
2721: CURSOR ar_adjustments_radj_C(

Line 3501: /* Bug 3251839 - checks against cached arp_global value */

3497: -- Prevent the application of a receipt against a claim number
3498: -- more than once
3499: -----------------------------------------------------
3500: /* Bug 2719456 : The following sql will be called only iclaim is installed */
3501: /* Bug 3251839 - checks against cached arp_global value */
3502: IF arp_global.tm_installed_flag = 'Y' THEN
3503:
3504: DECLARE
3505: l_count number;

Line 3502: IF arp_global.tm_installed_flag = 'Y' THEN

3498: -- more than once
3499: -----------------------------------------------------
3500: /* Bug 2719456 : The following sql will be called only iclaim is installed */
3501: /* Bug 3251839 - checks against cached arp_global value */
3502: IF arp_global.tm_installed_flag = 'Y' THEN
3503:
3504: DECLARE
3505: l_count number;
3506: claim_multi_assign exception;

Line 4938: functional_curr := arp_global.functional_currency;

4934: END IF;
4935: --
4936: arp_ps_pkg.fetch_p( p_receipt_ps_id, l_ps_rec );
4937:
4938: functional_curr := arp_global.functional_currency;
4939:
4940: -- ---------------------------------------------------------------------
4941: -- Get UNAPP and ON-ACC CC'Ids by selecting from receipt method accounts
4942: -- table

Line 5576: functional_curr := arp_global.functional_currency;

5572: l_secondary_app_ref_num := p_secondary_app_ref_num;
5573: l_netted_receipt_flag := NVL(p_netted_receipt_flag,'N');
5574:
5575:
5576: functional_curr := arp_global.functional_currency;
5577:
5578: IF NVL(p_application_ps_id,0) = -5 THEN
5579: l_application_ref_type := 'CHARGEBACK';
5580: ---CC_Chargeback

Line 5985: p_coa_id => arp_global.chart_of_accounts_id,

5981: +--------------------------------------------------------------------*/
5982: IF NVL(FND_PROFILE.value('AR_DISABLE_REC_ACTIVITY_BALSEG_SUBSTITUTION'),
5983: 'N') = 'N' THEN
5984: arp_util.Substitute_Ccid(
5985: p_coa_id => arp_global.chart_of_accounts_id,
5986: p_original_ccid => activity_rec.activity_ccid ,
5987: p_subs_ccid => activity_rec.unapplied_ccid ,
5988: p_actual_ccid => l_ra_rec.code_combination_id );
5989: ELSE

Line 6778: functional_curr := arp_global.functional_currency;

6774: END IF;
6775: --
6776: arp_ps_pkg.fetch_p( p_receipt_ps_id, l_ps_rec );
6777:
6778: functional_curr := arp_global.functional_currency;
6779: -- ---------------------------------------------------------------------
6780: -- Get UNAPP and OTHER ACC CC'Ids by selecting from receipt method accounts
6781: -- table
6782: -- ---------------------------------------------------------------------

Line 7004: p_coa_id => arp_global.chart_of_accounts_id,

7000: /* bug fix 4025652 */
7001:
7002: IF NVL(FND_PROFILE.value('AR_DISABLE_REC_ACTIVITY_BALSEG_SUBSTITUTION'),'N') = 'N' THEN
7003: arp_util.Substitute_Ccid(
7004: p_coa_id => arp_global.chart_of_accounts_id,
7005: p_original_ccid => l_activity_cc_id ,
7006: p_subs_ccid => l_unapp_cc_id ,
7007: p_actual_ccid => l_ra_rec.code_combination_id );
7008: ELSE

Line 7320: l_claim_rec.set_of_books_id := arp_global.set_of_books_id;

7316: l_claim_rec.currency_code := p_currency_code;
7317: l_claim_rec.exchange_rate_type := p_exchange_rate_type;
7318: l_claim_rec.exchange_rate_date := p_exchange_rate_date;
7319: l_claim_rec.exchange_rate := p_exchange_rate;
7320: l_claim_rec.set_of_books_id := arp_global.set_of_books_id;
7321: l_claim_rec.amount_applied := p_amount_applied;
7322: l_claim_rec.legal_entity_id := p_legal_entity_id;
7323: IF p_customer_trx_id IS NOT NULL
7324: THEN

Line 7366: arp_standard.debug('set_of_books id = '||arp_global.set_of_books_id);

7362:
7363: -- Dumping all the values
7364:
7365: IF PG_DEBUG in ('Y', 'C') THEN
7366: arp_standard.debug('set_of_books id = '||arp_global.set_of_books_id);
7367: arp_standard.debug('p_amount = '||p_amount);
7368: arp_standard.debug('p_amount_applied = '||p_amount_applied);
7369: arp_standard.debug('p_currency_code = '||p_currency_code);
7370: arp_standard.debug('p_exchange_rate_type = '||p_exchange_rate_type);

Line 8359: functional_curr := arp_global.functional_currency;

8355: INTO l_exchange_rate
8356: FROM ap_invoices_v
8357: WHERE invoice_id = p_application_ref_id;
8358:
8359: functional_curr := arp_global.functional_currency;
8360:
8361: l_inv_ra_rec.acctd_amount_applied_to :=
8362: ARPCURR.functional_amount(
8363: amount => p_amount_applied