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.AR_REVENUE_ADJUSTMENT_PVT dependencies on ARP_GLOBAL

Line 1455: , currency_code => arp_global.functional_currency

1451: l_line_amount_acctd :=
1452: /* Bug 4675438: MOAC/SSA */
1453: ARPCURR.functional_amount(
1454: amount => l_line_amount
1455: , currency_code => arp_global.functional_currency
1456: , exchange_rate => AR_RAAPI_UTIL.g_exchange_rate
1457: , precision => NULL
1458: , min_acc_unit => NULL );
1459: l_line_percent := ROUND(l_line_amount / c1.amount * 100, 4);

Line 1523: IF arp_global.sysparam.sales_credit_pct_limit IS NULL

1519: l_total_sc_percent := l_line_percent + l_revenue_percent_split_new +
1520: l_line_nonrev_percent + l_nonrev_percent_split_new;
1521: IF l_total_sc_percent < 0
1522: THEN
1523: IF arp_global.sysparam.sales_credit_pct_limit IS NULL
1524: THEN
1525: l_neg_sc_limit := NULL;
1526: ELSE
1527: l_neg_sc_limit := arp_global.sysparam.sales_credit_pct_limit * -1;

Line 1527: l_neg_sc_limit := arp_global.sysparam.sales_credit_pct_limit * -1;

1523: IF arp_global.sysparam.sales_credit_pct_limit IS NULL
1524: THEN
1525: l_neg_sc_limit := NULL;
1526: ELSE
1527: l_neg_sc_limit := arp_global.sysparam.sales_credit_pct_limit * -1;
1528: END IF;
1529: END IF;
1530: IF (l_total_sc_percent > 0 AND l_total_sc_percent >
1531: NVL(arp_global.sysparam.sales_credit_pct_limit,l_total_sc_percent)) OR

Line 1531: NVL(arp_global.sysparam.sales_credit_pct_limit,l_total_sc_percent)) OR

1527: l_neg_sc_limit := arp_global.sysparam.sales_credit_pct_limit * -1;
1528: END IF;
1529: END IF;
1530: IF (l_total_sc_percent > 0 AND l_total_sc_percent >
1531: NVL(arp_global.sysparam.sales_credit_pct_limit,l_total_sc_percent)) OR
1532: (l_total_sc_percent < 0 and l_total_sc_percent <
1533: NVL(l_neg_sc_limit,l_total_sc_percent))
1534: THEN
1535: RAISE invalid_sc_total;

Line 1616: ,arp_global.chart_of_accounts_id

1612: THEN
1613: l_credit_ccid := FND_FLEX_EXT.GET_CCID
1614: ('SQLGL'
1615: ,'GL#'
1616: ,arp_global.chart_of_accounts_id
1617: ,TO_CHAR(l_rev_adj_rec.gl_date,'DD-MON-YYYY')
1618: ,l_concat_segments);
1619: END IF;
1620:

Line 1644: , currency_code => arp_global.functional_currency

1640: /* Bug 4675438: MOAC/SSA */
1641: l_amount_prorata_acctd :=
1642: ARPCURR.functional_amount(
1643: amount => l_amount_prorata
1644: , currency_code => arp_global.functional_currency
1645: , exchange_rate => AR_RAAPI_UTIL.g_exchange_rate
1646: , precision => NULL
1647: , min_acc_unit => NULL );
1648: l_percent_prorata :=

Line 1728: ,arp_global.chart_of_accounts_id

1724: l_debit_ccid :=
1725: FND_FLEX_EXT.GET_CCID
1726: ('SQLGL'
1727: ,'GL#'
1728: ,arp_global.chart_of_accounts_id
1729: ,TO_CHAR(l_rev_adj_rec.gl_date,'DD-MON-YYYY')
1730: ,l_concat_segments);
1731: END IF;
1732: IF l_debit_ccid = -1 OR

Line 1870: arp_global.sysparam.sales_credit_pct_limit);

1866: name => gl_public_sector.get_message_name
1867: (p_message_name => 'AR_RA_SALES_CREDIT_LIMIT',
1868: p_app_short_name => 'AR'));
1869: FND_MESSAGE.set_token('SALES_CREDIT_LIMIT',
1870: arp_global.sysparam.sales_credit_pct_limit);
1871: FND_MESSAGE.set_token('SALESREP_NAME',l_new_salesrep_name);
1872: FND_MESSAGE.set_token('LINE_NUMBER',l_line_number);
1873: FND_MSG_PUB.Add;
1874: RAISE FND_API.G_EXC_ERROR;

Line 2268: IF arp_global.sysparam.sales_credit_pct_limit IS NULL

2264: l_total_sc_percent := l_line_percent + l_revenue_percent_split_new +
2265: l_nonrev_percent_split_new;
2266: IF l_total_sc_percent < 0
2267: THEN
2268: IF arp_global.sysparam.sales_credit_pct_limit IS NULL
2269: THEN
2270: l_neg_sc_limit := NULL;
2271: ELSE
2272: l_neg_sc_limit := arp_global.sysparam.sales_credit_pct_limit * -1;

Line 2272: l_neg_sc_limit := arp_global.sysparam.sales_credit_pct_limit * -1;

2268: IF arp_global.sysparam.sales_credit_pct_limit IS NULL
2269: THEN
2270: l_neg_sc_limit := NULL;
2271: ELSE
2272: l_neg_sc_limit := arp_global.sysparam.sales_credit_pct_limit * -1;
2273: END IF;
2274: END IF;
2275: IF (l_total_sc_percent > 0 AND l_total_sc_percent >
2276: NVL(arp_global.sysparam.sales_credit_pct_limit,l_total_sc_percent)) OR

Line 2276: NVL(arp_global.sysparam.sales_credit_pct_limit,l_total_sc_percent)) OR

2272: l_neg_sc_limit := arp_global.sysparam.sales_credit_pct_limit * -1;
2273: END IF;
2274: END IF;
2275: IF (l_total_sc_percent > 0 AND l_total_sc_percent >
2276: NVL(arp_global.sysparam.sales_credit_pct_limit,l_total_sc_percent)) OR
2277: (l_total_sc_percent < 0 and l_total_sc_percent <
2278: NVL(l_neg_sc_limit,l_total_sc_percent))
2279: THEN
2280: RAISE invalid_sc_total;

Line 2305: arp_global.sysparam.sales_credit_pct_limit);

2301: name => gl_public_sector.get_message_name
2302: (p_message_name => 'AR_RA_SALES_CREDIT_LIMIT',
2303: p_app_short_name => 'AR'));
2304: FND_MESSAGE.set_token('SALES_CREDIT_LIMIT',
2305: arp_global.sysparam.sales_credit_pct_limit);
2306: FND_MESSAGE.set_token('SALESREP_NAME',l_new_salesrep_name);
2307: FND_MESSAGE.set_token('LINE_NUMBER',l_line_number);
2308: FND_MSG_PUB.Add;
2309: RAISE FND_API.G_EXC_ERROR;

Line 2449: AND sob.set_of_books_id = arp_global.sysparam.set_of_books_id

2445: SELECT SUM(ar.amount), count(*)
2446: FROM ar_revenue_assignments ar,
2447: gl_sets_of_books sob
2448: WHERE customer_trx_line_id = p_customer_trx_line_id
2449: AND sob.set_of_books_id = arp_global.sysparam.set_of_books_id
2450: AND ar.period_set_name = sob.period_set_name
2451: AND ar.account_class = 'REV';
2452:
2453: CURSOR c_revenue_assignment IS

Line 2459: AND sob.set_of_books_id = arp_global.sysparam.set_of_books_id

2455: SUM(ar.amount) amount
2456: FROM ar_revenue_assignments ar,
2457: gl_sets_of_books sob
2458: WHERE ar.customer_trx_line_id = p_customer_trx_line_id
2459: AND sob.set_of_books_id = arp_global.sysparam.set_of_books_id
2460: AND ar.period_set_name = sob.period_set_name
2461: AND ar.account_class = 'REV'
2462: GROUP BY ar.gl_date
2463: ORDER BY (ar.gl_date + l_deferred_days);

Line 2915: AND sob.set_of_books_id = arp_global.sysparam.set_of_books_id

2911: SELECT SUM(ar.amount), count(*)
2912: FROM ar_revenue_assignments ar,
2913: gl_sets_of_books sob
2914: WHERE customer_trx_line_id = p_customer_trx_line_id
2915: AND sob.set_of_books_id = arp_global.sysparam.set_of_books_id
2916: AND ar.period_set_name = sob.period_set_name
2917: AND ar.account_class = 'REV';
2918:
2919: CURSOR c_revenue_assignment IS

Line 2925: AND sob.set_of_books_id = arp_global.sysparam.set_of_books_id

2921: , SUM(ar.amount) amount
2922: FROM ar_revenue_assignments ar,
2923: gl_sets_of_books sob
2924: WHERE ar.customer_trx_line_id = p_customer_trx_line_id
2925: AND sob.set_of_books_id = arp_global.sysparam.set_of_books_id
2926: AND ar.period_set_name = sob.period_set_name
2927: AND ar.account_class = 'REV'
2928: GROUP BY ar.gl_date
2929: ORDER BY gl_date ASC;

Line 3087: arp_global.chart_of_accounts_id,

3083: THEN
3084: l_debit_ccid := FND_FLEX_EXT.GET_CCID
3085: ('SQLGL',
3086: 'GL#',
3087: arp_global.chart_of_accounts_id,
3088: to_char(TRUNC(SYSDATE),'DD-MON-YYYY'),
3089: l_debit_concat_segments);
3090: END IF;
3091: IF (l_debit_ccid < 1 OR l_fail_count > 0)

Line 3130: arp_global.chart_of_accounts_id,

3126: THEN
3127: l_credit_ccid :=
3128: FND_FLEX_EXT.GET_CCID('SQLGL',
3129: 'GL#',
3130: arp_global.chart_of_accounts_id,
3131: TO_CHAR(TRUNC(SYSDATE),'DD-MON-YYYY') ,
3132: l_credit_concat_segments);
3133: END IF;
3134: IF (l_credit_ccid < 1 OR l_fail_count > 0)

Line 3223: , currency_code => arp_global.functional_currency

3219: /* Bug 4675438: MOAC/SSA */
3220: l_dist_acctd_amount :=
3221: ARPCURR.functional_amount(
3222: amount => l_dist_amount
3223: , currency_code => arp_global.functional_currency
3224: , exchange_rate => AR_RAAPI_UTIL.g_exchange_rate
3225: , precision => NULL
3226: , min_acc_unit => NULL );
3227: /* Bug 2146970 - validate the GL date for all lines regardless

Line 3486: , currency_code => arp_global.functional_currency

3482: /* Bug 4675438: MOAC/SSA */
3483: l_dist_acctd_amount :=
3484: ARPCURR.functional_amount(
3485: amount => l_dist_amount
3486: , currency_code => arp_global.functional_currency
3487: , exchange_rate => AR_RAAPI_UTIL.g_exchange_rate
3488: , precision => NULL
3489: , min_acc_unit => NULL );
3490: --

Line 3523: arp_global.chart_of_accounts_id,

3519: THEN
3520: l_debit_ccid := FND_FLEX_EXT.GET_CCID
3521: ('SQLGL',
3522: 'GL#',
3523: arp_global.chart_of_accounts_id,
3524: to_char(p_gl_date,'DD-MON-YYYY') ,
3525: l_concat_segments);
3526: END IF;
3527:

Line 3583: arp_global.chart_of_accounts_id,

3579: THEN
3580: l_credit_ccid :=
3581: FND_FLEX_EXT.GET_CCID ('SQLGL',
3582: 'GL#',
3583: arp_global.chart_of_accounts_id,
3584: TO_CHAR(p_gl_date,'DD-MON-YYYY') ,
3585: l_concat_segments);
3586: END IF;
3587:

Line 3744: , currency_code => arp_global.functional_currency

3740:
3741: l_dist_acctd_amount :=
3742: ARPCURR.functional_amount(
3743: amount => l_dist_amount
3744: , currency_code => arp_global.functional_currency
3745: , exchange_rate => AR_RAAPI_UTIL.g_exchange_rate
3746: , precision => NULL
3747: , min_acc_unit => NULL );
3748: --

Line 3780: arp_global.chart_of_accounts_id,

3776: THEN
3777: l_debit_ccid := FND_FLEX_EXT.GET_CCID
3778: ('SQLGL',
3779: 'GL#',
3780: arp_global.chart_of_accounts_id,
3781: to_char(p_gl_date,'DD-MON-YYYY') ,
3782: l_concat_segments);
3783: END IF;
3784:

Line 3851: arp_global.chart_of_accounts_id,

3847: THEN
3848: l_credit_ccid :=
3849: FND_FLEX_EXT.GET_CCID ('SQLGL',
3850: 'GL#',
3851: arp_global.chart_of_accounts_id,
3852: TO_CHAR(p_gl_date,'DD-MON-YYYY') ,
3853: l_concat_segments);
3854: END IF;
3855:

Line 4325: ,arp_global.sysparam.rev_transfer_clear_ccid

4321: ,AR_RAAPI_UTIL.g_customer_trx_id
4322: ,AR_RAAPI_UTIL.g_from_salesrep_id
4323: ,l_revenue_amount_prorata
4324: ,l_rev_adj_rec.gl_date
4325: ,arp_global.sysparam.rev_transfer_clear_ccid
4326: ,c1.inventory_item_id
4327: ,c1.memo_line_id
4328: ,x_adjustment_id);
4329: ELSE

Line 4335: ,arp_global.sysparam.rev_transfer_clear_ccid

4331: ,AR_RAAPI_UTIL.g_customer_trx_id
4332: ,AR_RAAPI_UTIL.g_from_salesrep_id
4333: ,l_revenue_amount_prorata
4334: ,l_rev_adj_rec.gl_date
4335: ,arp_global.sysparam.rev_transfer_clear_ccid
4336: ,c1.inventory_item_id
4337: ,c1.memo_line_id
4338: ,x_adjustment_id);
4339: END IF;

Line 4378: l_credit_ccid := arp_global.sysparam.rev_transfer_clear_ccid;

4374: ,c1.memo_line_id
4375: ,x_adjustment_id);
4376: l_credit_ccid := NULL;
4377: ELSE
4378: l_credit_ccid := arp_global.sysparam.rev_transfer_clear_ccid;
4379: END IF;
4380:
4381: debit_credit (c1.customer_trx_line_id
4382: ,AR_RAAPI_UTIL.g_customer_trx_id

Line 4396: ,arp_global.sysparam.rev_transfer_clear_ccid

4392: ,AR_RAAPI_UTIL.g_customer_trx_id
4393: ,NULL
4394: ,l_revenue_amount_prorata * -1
4395: ,l_rev_adj_rec.gl_date
4396: ,arp_global.sysparam.rev_transfer_clear_ccid
4397: ,c1.inventory_item_id
4398: ,c1.memo_line_id
4399: ,x_adjustment_id);
4400: END IF;

Line 4828: , currency_code => arp_global.functional_currency

4824: END IF;
4825: l_dist_acctd_amount :=
4826: ARPCURR.functional_amount(
4827: amount => l_dist_amount
4828: , currency_code => arp_global.functional_currency
4829: , exchange_rate => AR_RAAPI_UTIL.g_exchange_rate
4830: , precision => NULL
4831: , min_acc_unit => NULL );
4832: --

Line 4862: arp_global.chart_of_accounts_id,

4858: THEN
4859: l_credit_ccid := FND_FLEX_EXT.GET_CCID
4860: ('SQLGL',
4861: 'GL#',
4862: arp_global.chart_of_accounts_id,
4863: TO_CHAR(p_gl_date,'DD-MON-YYYY'),
4864: l_concat_segments);
4865: END IF;
4866:

Line 4886: l_debit_ccid := arp_global.sysparam.rev_transfer_clear_ccid;

4882: NULL,
4883: p_customer_trx_id,
4884: p_adjustment_id);
4885:
4886: l_debit_ccid := arp_global.sysparam.rev_transfer_clear_ccid;
4887:
4888: insert_distribution ( p_customer_trx_line_id,
4889: l_debit_ccid,
4890: l_dist_percent * -1,

Line 5015: ,arp_global.sysparam.set_of_books_id

5011: ) VALUES
5012: (l_dist_id
5013: ,p_customer_trx_line_id
5014: ,p_ccid
5015: ,arp_global.sysparam.set_of_books_id
5016: ,SYSDATE
5017: ,l_user_id
5018: ,SYSDATE
5019: ,l_user_id

Line 5059: g_ra_dist_tbl(g_dist_count).set_of_books_id := arp_global.sysparam.set_of_books_id;

5055: ELSE
5056: g_dist_count := g_dist_count + 1;
5057: g_ra_dist_tbl(g_dist_count).customer_trx_line_id := p_customer_trx_line_id;
5058: g_ra_dist_tbl(g_dist_count).code_combination_id := p_ccid;
5059: g_ra_dist_tbl(g_dist_count).set_of_books_id := arp_global.sysparam.set_of_books_id;
5060: g_ra_dist_tbl(g_dist_count).last_update_date := SYSDATE;
5061: g_ra_dist_tbl(g_dist_count).last_updated_by := l_user_id;
5062: g_ra_dist_tbl(g_dist_count).creation_date := SYSDATE;
5063: g_ra_dist_tbl(g_dist_count).created_by := l_user_id;

Line 5256: ,arp_global.chart_of_accounts_id

5252: THEN
5253: l_ccid := FND_FLEX_EXT.GET_CCID
5254: ('SQLGL'
5255: ,'GL#'
5256: ,arp_global.chart_of_accounts_id
5257: ,TO_CHAR(p_gl_date,'DD-MON-YYYY')
5258: ,l_concat_segments);
5259: END IF;
5260: