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_PROCESS_APPLICATION dependencies on ARP_GLOBAL

Line 11: G_TM_INSTALLED varchar2(1) := arp_global.tm_installed_flag;

7: SUBTYPE ae_doc_rec_type IS arp_acct_main.ae_doc_rec_type;
8:
9: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
10:
11: G_TM_INSTALLED varchar2(1) := arp_global.tm_installed_flag;
12: G_TM_ORG_ID NUMBER := arp_global.sysparam.org_id;
13:
14: --
15: -- Private procedures used by the package

Line 12: G_TM_ORG_ID NUMBER := arp_global.sysparam.org_id;

8:
9: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
10:
11: G_TM_INSTALLED varchar2(1) := arp_global.tm_installed_flag;
12: G_TM_ORG_ID NUMBER := arp_global.sysparam.org_id;
13:
14: --
15: -- Private procedures used by the package
16: --

Line 927: functional_curr := arp_global.functional_currency;

923: IF PG_DEBUG in ('Y', 'C') THEN
924: arp_debug.debug( 'arp_process_application.update_selected_transaction()+');
925: END IF;
926:
927: functional_curr := arp_global.functional_currency;
928:
929: -- First check that all required arguments have some value
930: IF (pn_ra_id IS NULL)
931: THEN

Line 1294: l_app_rec arp_global.app_rec_type;

1290: p_reversal_date IN DATE) IS
1291:
1292: l_gl_date_closed DATE;
1293: l_actual_date_closed DATE;
1294: l_app_rec arp_global.app_rec_type;
1295:
1296: BEGIN
1297: IF PG_DEBUG in ('Y', 'C') THEN
1298: arp_debug.debug( 'arp_process_application.reversal_update_ps_recs()+');

Line 2600: WHERE a.receivables_trx_id = arp_global.G_CB_RT_ID

2596: SELECT count( distinct a.chargeback_customer_trx_id )
2597: INTO l_cb_count
2598: FROM ar_adjustments a,
2599: ar_adjustments b
2600: WHERE a.receivables_trx_id = arp_global.G_CB_RT_ID
2601: AND a.associated_cash_receipt_id = l_ass_cr_id
2602: AND a.payment_schedule_id = l_ps_id
2603: AND b.receivables_trx_id(+) = arp_global.G_CB_REV_RT_ID
2604: AND b.customer_trx_id(+) = a.chargeback_customer_trx_id

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

2599: ar_adjustments b
2600: WHERE a.receivables_trx_id = arp_global.G_CB_RT_ID
2601: AND a.associated_cash_receipt_id = l_ass_cr_id
2602: AND a.payment_schedule_id = l_ps_id
2603: AND b.receivables_trx_id(+) = arp_global.G_CB_REV_RT_ID
2604: AND b.customer_trx_id(+) = a.chargeback_customer_trx_id
2605: AND b.customer_trx_id is NULL;
2606: --
2607: IF PG_DEBUG in ('Y', 'C') THEN

Line 2797: l_app_rec arp_global.app_rec_type;

2793: p_module_version IN VARCHAR2 ) IS
2794: l_adj_amount NUMBER;
2795: l_ps_id ar_payment_schedules.payment_schedule_id%TYPE;
2796: l_ass_cr_id ar_cash_receipts.cash_receipt_id%TYPE;
2797: l_app_rec arp_global.app_rec_type;
2798: l_ps_rec ar_payment_schedules%ROWTYPE;
2799:
2800: l_count NUMBER DEFAULT 0;
2801: --

Line 2809: WHERE a.receivables_trx_id = arp_global.G_CB_RT_ID

2805: a.adjustment_id,
2806: a.status
2807: FROM ar_adjustments a,
2808: ar_adjustments b
2809: WHERE a.receivables_trx_id = arp_global.G_CB_RT_ID
2810: AND a.associated_cash_receipt_id = l_ass_cr_id
2811: AND a.payment_schedule_id = l_ps_id
2812: AND b.receivables_trx_id(+) = arp_global.G_CB_REV_RT_ID
2813: AND b.customer_trx_id(+) = a.chargeback_customer_trx_id

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

2808: ar_adjustments b
2809: WHERE a.receivables_trx_id = arp_global.G_CB_RT_ID
2810: AND a.associated_cash_receipt_id = l_ass_cr_id
2811: AND a.payment_schedule_id = l_ps_id
2812: AND b.receivables_trx_id(+) = arp_global.G_CB_REV_RT_ID
2813: AND b.customer_trx_id(+) = a.chargeback_customer_trx_id
2814: AND b.customer_trx_id is null;
2815: --
2816: CURSOR ar_adjustments_radj_C(

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

3671: -- Prevent the application of a receipt against a claim number
3672: -- more than once
3673: -----------------------------------------------------
3674: /* Bug 2719456 : The following sql will be called only iclaim is installed */
3675: /* Bug 3251839 - checks against cached arp_global value */
3676:
3677: /* 12987134 - reset tm_installed_flag if org changes due to
3678: MOAC activity in session */
3679: IF l_org_id <> G_TM_ORG_ID

Line 3682: G_TM_INSTALLED := arp_global.tm_installed_flag;

3678: MOAC activity in session */
3679: IF l_org_id <> G_TM_ORG_ID
3680: THEN
3681: G_TM_ORG_ID := l_org_id;
3682: G_TM_INSTALLED := arp_global.tm_installed_flag;
3683: END IF;
3684:
3685: IF G_TM_INSTALLED = 'Y' THEN
3686:

Line 5281: functional_curr := arp_global.functional_currency;

5277: END IF;
5278: --
5279: arp_ps_pkg.fetch_p( p_receipt_ps_id, l_ps_rec );
5280:
5281: functional_curr := arp_global.functional_currency;
5282:
5283: -- ---------------------------------------------------------------------
5284: -- Get UNAPP and ON-ACC CC'Ids by selecting from receipt method accounts
5285: -- table

Line 5924: functional_curr := arp_global.functional_currency;

5920: l_secondary_app_ref_num := p_secondary_app_ref_num;
5921: l_netted_receipt_flag := NVL(p_netted_receipt_flag,'N');
5922:
5923:
5924: functional_curr := arp_global.functional_currency;
5925:
5926: IF NVL(p_application_ps_id,0) = -5 THEN
5927: l_application_ref_type := 'CHARGEBACK';
5928: ---CC_Chargeback

Line 6337: p_coa_id => arp_global.chart_of_accounts_id,

6333: +--------------------------------------------------------------------*/
6334: IF NVL(FND_PROFILE.value('AR_DISABLE_REC_ACTIVITY_BALSEG_SUBSTITUTION'),
6335: 'N') = 'N' THEN
6336: arp_util.Substitute_Ccid(
6337: p_coa_id => arp_global.chart_of_accounts_id,
6338: p_original_ccid => activity_rec.activity_ccid ,
6339: p_subs_ccid => activity_rec.unapplied_ccid ,
6340: p_actual_ccid => l_ra_rec.code_combination_id );
6341: ELSE

Line 7130: functional_curr := arp_global.functional_currency;

7126: END IF;
7127: --
7128: arp_ps_pkg.fetch_p( p_receipt_ps_id, l_ps_rec );
7129:
7130: functional_curr := arp_global.functional_currency;
7131: -- ---------------------------------------------------------------------
7132: -- Get UNAPP and OTHER ACC CC'Ids by selecting from receipt method accounts
7133: -- table
7134: -- ---------------------------------------------------------------------

Line 7356: p_coa_id => arp_global.chart_of_accounts_id,

7352: /* bug fix 4025652 */
7353:
7354: IF NVL(FND_PROFILE.value('AR_DISABLE_REC_ACTIVITY_BALSEG_SUBSTITUTION'),'N') = 'N' THEN
7355: arp_util.Substitute_Ccid(
7356: p_coa_id => arp_global.chart_of_accounts_id,
7357: p_original_ccid => l_activity_cc_id ,
7358: p_subs_ccid => l_unapp_cc_id ,
7359: p_actual_ccid => l_ra_rec.code_combination_id );
7360: ELSE

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

7670: l_claim_rec.currency_code := p_currency_code;
7671: l_claim_rec.exchange_rate_type := p_exchange_rate_type;
7672: l_claim_rec.exchange_rate_date := p_exchange_rate_date;
7673: l_claim_rec.exchange_rate := p_exchange_rate;
7674: l_claim_rec.set_of_books_id := arp_global.set_of_books_id;
7675: l_claim_rec.amount_applied := p_amount_applied;
7676: l_claim_rec.legal_entity_id := p_legal_entity_id;
7677: IF p_customer_trx_id IS NOT NULL
7678: THEN

Line 7720: arp_debug.debug('set_of_books id = '||arp_global.set_of_books_id);

7716:
7717: -- Dumping all the values
7718:
7719: IF PG_DEBUG in ('Y', 'C') THEN
7720: arp_debug.debug('set_of_books id = '||arp_global.set_of_books_id);
7721: arp_debug.debug('p_amount = '||p_amount);
7722: arp_debug.debug('p_amount_applied = '||p_amount_applied);
7723: arp_debug.debug('p_currency_code = '||p_currency_code);
7724: arp_debug.debug('p_exchange_rate_type = '||p_exchange_rate_type);

Line 8873: functional_curr := arp_global.functional_currency;

8869: INTO l_exchange_rate
8870: FROM ap_invoices_v
8871: WHERE invoice_id = p_application_ref_id;
8872:
8873: functional_curr := arp_global.functional_currency;
8874:
8875: l_inv_ra_rec.acctd_amount_applied_to :=
8876: ARPCURR.functional_amount(
8877: amount => p_amount_applied

Line 8965: p_coa_id => arp_global.chart_of_accounts_id,

8961: END IF;
8962:
8963: IF NVL(FND_PROFILE.value('AR_DISABLE_REC_ACTIVITY_BALSEG_SUBSTITUTION'),'N') = 'N' THEN
8964: arp_util.Substitute_Ccid(
8965: p_coa_id => arp_global.chart_of_accounts_id,
8966: p_original_ccid => l_activity_ccid ,
8967: p_subs_ccid => l_rec_ccid ,
8968: p_actual_ccid => l_inv_ra_rec.code_combination_id );
8969: END IF;

Line 9240: l_app_rec arp_global.app_rec_type;

9236:
9237: l_initial_customer_trx_id number;
9238: l_adjustment_id number;
9239: l_adj_rec ar_adjustments%ROWTYPE;
9240: l_app_rec arp_global.app_rec_type;
9241: l_rev_gl_date DATE ;
9242: l_default_gl_date DATE;
9243: l_error_message VARCHAR2(128);
9244: l_defaulting_rule_used VARCHAR2(100);

Line 9274: arp_global.set_of_books_id,

9270: NULL,
9271: NULL,
9272: 'N',
9273: NULL,
9274: arp_global.set_of_books_id,
9275: 222,
9276: l_default_gl_date,
9277: l_defaulting_rule_used,
9278: l_error_message) = TRUE)