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 1532: , currency_code => arp_global.functional_currency

1528: l_line_amount_acctd :=
1529: /* Bug 4675438: MOAC/SSA */
1530: ARPCURR.functional_amount(
1531: amount => l_line_amount
1532: , currency_code => arp_global.functional_currency
1533: , exchange_rate => AR_RAAPI_UTIL.g_exchange_rate
1534: , precision => NULL
1535: , min_acc_unit => NULL );
1536: l_line_percent := ROUND(l_line_amount / c1.amount * 100, 4);

Line 1600: IF arp_global.sysparam.sales_credit_pct_limit IS NULL

1596: l_total_sc_percent := l_line_percent + l_revenue_percent_split_new +
1597: l_line_nonrev_percent + l_nonrev_percent_split_new;
1598: IF l_total_sc_percent < 0
1599: THEN
1600: IF arp_global.sysparam.sales_credit_pct_limit IS NULL
1601: THEN
1602: l_neg_sc_limit := NULL;
1603: ELSE
1604: l_neg_sc_limit := arp_global.sysparam.sales_credit_pct_limit * -1;

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

1600: IF arp_global.sysparam.sales_credit_pct_limit IS NULL
1601: THEN
1602: l_neg_sc_limit := NULL;
1603: ELSE
1604: l_neg_sc_limit := arp_global.sysparam.sales_credit_pct_limit * -1;
1605: END IF;
1606: END IF;
1607: IF (l_total_sc_percent > 0 AND l_total_sc_percent >
1608: NVL(arp_global.sysparam.sales_credit_pct_limit,l_total_sc_percent)) OR

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

1604: l_neg_sc_limit := arp_global.sysparam.sales_credit_pct_limit * -1;
1605: END IF;
1606: END IF;
1607: IF (l_total_sc_percent > 0 AND l_total_sc_percent >
1608: NVL(arp_global.sysparam.sales_credit_pct_limit,l_total_sc_percent)) OR
1609: (l_total_sc_percent < 0 and l_total_sc_percent <
1610: NVL(l_neg_sc_limit,l_total_sc_percent))
1611: THEN
1612: RAISE invalid_sc_total;

Line 1693: ,arp_global.chart_of_accounts_id

1689: THEN
1690: l_credit_ccid := FND_FLEX_EXT.GET_CCID
1691: ('SQLGL'
1692: ,'GL#'
1693: ,arp_global.chart_of_accounts_id
1694: ,TO_CHAR(l_rev_adj_rec.gl_date,'DD-MON-YYYY')
1695: ,l_concat_segments);
1696: END IF;
1697:

Line 1721: , currency_code => arp_global.functional_currency

1717: /* Bug 4675438: MOAC/SSA */
1718: l_amount_prorata_acctd :=
1719: ARPCURR.functional_amount(
1720: amount => l_amount_prorata
1721: , currency_code => arp_global.functional_currency
1722: , exchange_rate => AR_RAAPI_UTIL.g_exchange_rate
1723: , precision => NULL
1724: , min_acc_unit => NULL );
1725: l_percent_prorata :=

Line 1805: ,arp_global.chart_of_accounts_id

1801: l_debit_ccid :=
1802: FND_FLEX_EXT.GET_CCID
1803: ('SQLGL'
1804: ,'GL#'
1805: ,arp_global.chart_of_accounts_id
1806: ,TO_CHAR(l_rev_adj_rec.gl_date,'DD-MON-YYYY')
1807: ,l_concat_segments);
1808: END IF;
1809: IF l_debit_ccid = -1 OR

Line 1947: arp_global.sysparam.sales_credit_pct_limit);

1943: name => gl_public_sector.get_message_name
1944: (p_message_name => 'AR_RA_SALES_CREDIT_LIMIT',
1945: p_app_short_name => 'AR'));
1946: FND_MESSAGE.set_token('SALES_CREDIT_LIMIT',
1947: arp_global.sysparam.sales_credit_pct_limit);
1948: FND_MESSAGE.set_token('SALESREP_NAME',l_new_salesrep_name);
1949: FND_MESSAGE.set_token('LINE_NUMBER',l_line_number);
1950: FND_MSG_PUB.Add;
1951: RAISE FND_API.G_EXC_ERROR;

Line 2345: IF arp_global.sysparam.sales_credit_pct_limit IS NULL

2341: l_total_sc_percent := l_line_percent + l_revenue_percent_split_new +
2342: l_nonrev_percent_split_new;
2343: IF l_total_sc_percent < 0
2344: THEN
2345: IF arp_global.sysparam.sales_credit_pct_limit IS NULL
2346: THEN
2347: l_neg_sc_limit := NULL;
2348: ELSE
2349: l_neg_sc_limit := arp_global.sysparam.sales_credit_pct_limit * -1;

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

2345: IF arp_global.sysparam.sales_credit_pct_limit IS NULL
2346: THEN
2347: l_neg_sc_limit := NULL;
2348: ELSE
2349: l_neg_sc_limit := arp_global.sysparam.sales_credit_pct_limit * -1;
2350: END IF;
2351: END IF;
2352: IF (l_total_sc_percent > 0 AND l_total_sc_percent >
2353: NVL(arp_global.sysparam.sales_credit_pct_limit,l_total_sc_percent)) OR

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

2349: l_neg_sc_limit := arp_global.sysparam.sales_credit_pct_limit * -1;
2350: END IF;
2351: END IF;
2352: IF (l_total_sc_percent > 0 AND l_total_sc_percent >
2353: NVL(arp_global.sysparam.sales_credit_pct_limit,l_total_sc_percent)) OR
2354: (l_total_sc_percent < 0 and l_total_sc_percent <
2355: NVL(l_neg_sc_limit,l_total_sc_percent))
2356: THEN
2357: RAISE invalid_sc_total;

Line 2382: arp_global.sysparam.sales_credit_pct_limit);

2378: name => gl_public_sector.get_message_name
2379: (p_message_name => 'AR_RA_SALES_CREDIT_LIMIT',
2380: p_app_short_name => 'AR'));
2381: FND_MESSAGE.set_token('SALES_CREDIT_LIMIT',
2382: arp_global.sysparam.sales_credit_pct_limit);
2383: FND_MESSAGE.set_token('SALESREP_NAME',l_new_salesrep_name);
2384: FND_MESSAGE.set_token('LINE_NUMBER',l_line_number);
2385: FND_MSG_PUB.Add;
2386: RAISE FND_API.G_EXC_ERROR;

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

2522: SELECT SUM(ar.amount), count(*)
2523: FROM ar_revenue_assignments ar,
2524: gl_sets_of_books sob
2525: WHERE customer_trx_line_id = p_customer_trx_line_id
2526: AND sob.set_of_books_id = arp_global.sysparam.set_of_books_id
2527: AND ar.period_set_name = sob.period_set_name
2528: AND ar.account_class = 'REV';
2529:
2530: CURSOR c_revenue_assignment IS

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

2532: SUM(ar.amount) amount
2533: FROM ar_revenue_assignments ar,
2534: gl_sets_of_books sob
2535: WHERE ar.customer_trx_line_id = p_customer_trx_line_id
2536: AND sob.set_of_books_id = arp_global.sysparam.set_of_books_id
2537: AND ar.period_set_name = sob.period_set_name
2538: AND ar.account_class = 'REV'
2539: GROUP BY ar.gl_date
2540: ORDER BY (ar.gl_date + l_deferred_days);

Line 2915: structure_number => ARP_GLOBAL.chart_of_accounts_id,

2911: for rec in c1 loop
2912:
2913: If (fnd_flex_keyval.validate_ccid (appl_short_name => 'SQLGL',
2914: key_flex_code => 'GL#',
2915: structure_number => ARP_GLOBAL.chart_of_accounts_id,
2916: combination_id => rec.code_combination_id)
2917: and nvl(fnd_flex_keyval.start_date,rec.gl_date) <= rec.gl_date
2918: and nvl(fnd_flex_keyval.end_date,rec.gl_date) >= rec.gl_date
2919: and fnd_flex_keyval.enabled_flag = TRUE

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

3096: SELECT SUM(ar.amount), count(*)
3097: FROM ar_revenue_assignments ar,
3098: gl_sets_of_books sob
3099: WHERE customer_trx_line_id = p_customer_trx_line_id
3100: AND sob.set_of_books_id = arp_global.sysparam.set_of_books_id
3101: AND ar.period_set_name = sob.period_set_name
3102: AND ar.account_class = 'REV';
3103:
3104: CURSOR c_revenue_assignment IS

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

3106: , SUM(ar.amount) amount
3107: FROM ar_revenue_assignments ar,
3108: gl_sets_of_books sob
3109: WHERE ar.customer_trx_line_id = p_customer_trx_line_id
3110: AND sob.set_of_books_id = arp_global.sysparam.set_of_books_id
3111: AND ar.period_set_name = sob.period_set_name
3112: AND ar.account_class = 'REV'
3113: GROUP BY ar.gl_date
3114: ORDER BY gl_date ASC;

Line 3272: arp_global.chart_of_accounts_id,

3268: THEN
3269: l_debit_ccid := FND_FLEX_EXT.GET_CCID
3270: ('SQLGL',
3271: 'GL#',
3272: arp_global.chart_of_accounts_id,
3273: to_char(TRUNC(SYSDATE),'DD-MON-YYYY'),
3274: l_debit_concat_segments);
3275: END IF;
3276: IF (l_debit_ccid < 1 OR l_fail_count > 0)

Line 3315: arp_global.chart_of_accounts_id,

3311: THEN
3312: l_credit_ccid :=
3313: FND_FLEX_EXT.GET_CCID('SQLGL',
3314: 'GL#',
3315: arp_global.chart_of_accounts_id,
3316: TO_CHAR(TRUNC(SYSDATE),'DD-MON-YYYY') ,
3317: l_credit_concat_segments);
3318: END IF;
3319: IF (l_credit_ccid < 1 OR l_fail_count > 0)

Line 3415: , currency_code => arp_global.functional_currency

3411: /* Bug 4675438: MOAC/SSA */
3412: l_dist_acctd_amount :=
3413: ARPCURR.functional_amount(
3414: amount => l_dist_amount
3415: , currency_code => arp_global.functional_currency
3416: , exchange_rate => AR_RAAPI_UTIL.g_exchange_rate
3417: , precision => NULL
3418: , min_acc_unit => NULL );
3419: /* Bug 2146970 - validate the GL date for all lines regardless

Line 3687: , currency_code => arp_global.functional_currency

3683: /* Bug 4675438: MOAC/SSA */
3684: l_dist_acctd_amount :=
3685: ARPCURR.functional_amount(
3686: amount => l_dist_amount
3687: , currency_code => arp_global.functional_currency
3688: , exchange_rate => AR_RAAPI_UTIL.g_exchange_rate
3689: , precision => NULL
3690: , min_acc_unit => NULL );
3691: --

Line 3724: arp_global.chart_of_accounts_id,

3720: THEN
3721: l_debit_ccid := FND_FLEX_EXT.GET_CCID
3722: ('SQLGL',
3723: 'GL#',
3724: arp_global.chart_of_accounts_id,
3725: to_char(p_gl_date,'DD-MON-YYYY') ,
3726: l_concat_segments);
3727: END IF;
3728:

Line 3784: arp_global.chart_of_accounts_id,

3780: THEN
3781: l_credit_ccid :=
3782: FND_FLEX_EXT.GET_CCID ('SQLGL',
3783: 'GL#',
3784: arp_global.chart_of_accounts_id,
3785: TO_CHAR(p_gl_date,'DD-MON-YYYY') ,
3786: l_concat_segments);
3787: END IF;
3788:

Line 3959: , currency_code => arp_global.functional_currency

3955:
3956: l_dist_acctd_amount :=
3957: ARPCURR.functional_amount(
3958: amount => l_dist_amount
3959: , currency_code => arp_global.functional_currency
3960: , exchange_rate => AR_RAAPI_UTIL.g_exchange_rate
3961: , precision => NULL
3962: , min_acc_unit => NULL );
3963: --

Line 3995: arp_global.chart_of_accounts_id,

3991: THEN
3992: l_debit_ccid := FND_FLEX_EXT.GET_CCID
3993: ('SQLGL',
3994: 'GL#',
3995: arp_global.chart_of_accounts_id,
3996: to_char(p_gl_date,'DD-MON-YYYY') ,
3997: l_concat_segments);
3998: END IF;
3999:

Line 4066: arp_global.chart_of_accounts_id,

4062: THEN
4063: l_credit_ccid :=
4064: FND_FLEX_EXT.GET_CCID ('SQLGL',
4065: 'GL#',
4066: arp_global.chart_of_accounts_id,
4067: TO_CHAR(p_gl_date,'DD-MON-YYYY') ,
4068: l_concat_segments);
4069: END IF;
4070:

Line 4541: ,arp_global.sysparam.rev_transfer_clear_ccid

4537: ,AR_RAAPI_UTIL.g_customer_trx_id
4538: ,AR_RAAPI_UTIL.g_from_salesrep_id
4539: ,l_revenue_amount_prorata
4540: ,l_rev_adj_rec.gl_date -- 7314406 (raw gl_date)
4541: ,arp_global.sysparam.rev_transfer_clear_ccid
4542: ,c1.inventory_item_id
4543: ,c1.memo_line_id
4544: ,x_adjustment_id);
4545: ELSE

Line 4556: ,arp_global.sysparam.rev_transfer_clear_ccid

4552: ,AR_RAAPI_UTIL.g_customer_trx_id
4553: ,AR_RAAPI_UTIL.g_from_salesrep_id
4554: ,l_revenue_amount_prorata
4555: ,l_gl_date_valid -- 7314406
4556: ,arp_global.sysparam.rev_transfer_clear_ccid
4557: ,c1.inventory_item_id
4558: ,c1.memo_line_id
4559: ,x_adjustment_id);
4560: END IF;

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

4595: ,c1.memo_line_id
4596: ,x_adjustment_id);
4597: l_credit_ccid := NULL;
4598: ELSE
4599: l_credit_ccid := arp_global.sysparam.rev_transfer_clear_ccid;
4600: END IF;
4601:
4602: debit_credit (c1.customer_trx_line_id
4603: ,AR_RAAPI_UTIL.g_customer_trx_id

Line 4621: ,arp_global.sysparam.rev_transfer_clear_ccid

4617: ,AR_RAAPI_UTIL.g_customer_trx_id
4618: ,NULL
4619: ,l_revenue_amount_prorata * -1
4620: ,l_gl_date_valid -- 7314406
4621: ,arp_global.sysparam.rev_transfer_clear_ccid
4622: ,c1.inventory_item_id
4623: ,c1.memo_line_id
4624: ,x_adjustment_id);
4625: END IF;

Line 5053: , currency_code => arp_global.functional_currency

5049: END IF;
5050: l_dist_acctd_amount :=
5051: ARPCURR.functional_amount(
5052: amount => l_dist_amount
5053: , currency_code => arp_global.functional_currency
5054: , exchange_rate => AR_RAAPI_UTIL.g_exchange_rate
5055: , precision => NULL
5056: , min_acc_unit => NULL );
5057: --

Line 5087: arp_global.chart_of_accounts_id,

5083: THEN
5084: l_credit_ccid := FND_FLEX_EXT.GET_CCID
5085: ('SQLGL',
5086: 'GL#',
5087: arp_global.chart_of_accounts_id,
5088: TO_CHAR(p_gl_date,'DD-MON-YYYY'),
5089: l_concat_segments);
5090: END IF;
5091:

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

5107: NULL,
5108: p_customer_trx_id,
5109: p_adjustment_id);
5110:
5111: l_debit_ccid := arp_global.sysparam.rev_transfer_clear_ccid;
5112:
5113: insert_distribution ( p_customer_trx_line_id,
5114: l_debit_ccid,
5115: l_dist_percent * -1,

Line 5237: ,arp_global.sysparam.set_of_books_id

5233: ) VALUES
5234: (l_dist_id
5235: ,p_customer_trx_line_id
5236: ,p_ccid
5237: ,arp_global.sysparam.set_of_books_id
5238: ,SYSDATE
5239: ,l_user_id
5240: ,SYSDATE
5241: ,l_user_id

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

5277: ELSE
5278: g_dist_count := g_dist_count + 1;
5279: g_ra_dist_tbl(g_dist_count).customer_trx_line_id := p_customer_trx_line_id;
5280: g_ra_dist_tbl(g_dist_count).code_combination_id := p_ccid;
5281: g_ra_dist_tbl(g_dist_count).set_of_books_id := arp_global.sysparam.set_of_books_id;
5282: g_ra_dist_tbl(g_dist_count).last_update_date := SYSDATE;
5283: g_ra_dist_tbl(g_dist_count).last_updated_by := l_user_id;
5284: g_ra_dist_tbl(g_dist_count).creation_date := SYSDATE;
5285: g_ra_dist_tbl(g_dist_count).created_by := l_user_id;

Line 5477: ,arp_global.chart_of_accounts_id

5473: THEN
5474: l_ccid := FND_FLEX_EXT.GET_CCID
5475: ('SQLGL'
5476: ,'GL#'
5477: ,arp_global.chart_of_accounts_id
5478: ,TO_CHAR(p_gl_date,'DD-MON-YYYY')
5479: ,l_concat_segments);
5480: END IF;
5481: