DBA Data[Home] [Help]

APPS.ARP_CASHBOOK dependencies on ARP_GLOBAL

Line 115: arp_global.init_global(mo_global.get_current_org_id);

111: -- Bug 7443802 END
112:
113: --Setting the Org Context Bug5212892
114: ar_mo_global_cache.populate;
115: arp_global.init_global(mo_global.get_current_org_id);
116: arp_standard.init_standard(mo_global.get_current_org_id);
117:
118: /* Bug 7828491: Check for settlement status in IBY summaries table.
119: Do not allow user to clear the receipt.Raise error if it is still pending.*/

Line 254: arp_standard.debug('clear: ' || 'ARP_GLOBAL.functional_currency = ' || ARP_GLOBAL.functional_currency);

250: l_acctd_receipt_amt_old := l_crh_rec_old.acctd_amount + nvl(L_crh_rec_old.acctd_factor_discount_amount,0);
251:
252: IF PG_DEBUG in ('Y', 'C') THEN
253: arp_standard.debug('clear: ' || 'l_cr_rec.currency_code = ' || l_cr_rec.currency_code);
254: arp_standard.debug('clear: ' || 'ARP_GLOBAL.functional_currency = ' || ARP_GLOBAL.functional_currency);
255: arp_standard.debug('clear: ' || 'l_crh_rec_old.exchange_rate = ' || to_char(l_crh_rec_old.exchange_rate));
256: END IF;
257:
258: IF ( l_cr_rec.currency_code = ARP_GLOBAL.functional_currency )

Line 258: IF ( l_cr_rec.currency_code = ARP_GLOBAL.functional_currency )

254: arp_standard.debug('clear: ' || 'ARP_GLOBAL.functional_currency = ' || ARP_GLOBAL.functional_currency);
255: arp_standard.debug('clear: ' || 'l_crh_rec_old.exchange_rate = ' || to_char(l_crh_rec_old.exchange_rate));
256: END IF;
257:
258: IF ( l_cr_rec.currency_code = ARP_GLOBAL.functional_currency )
259: THEN
260: l_acctd_receipt_amt_new := l_cr_rec.amount;
261: l_crh_rec_new.amount := p_amount_cleared;
262: l_crh_rec_new.acctd_amount := p_amount_cleared;

Line 280: ARP_GLOBAL.functional_currency,

276:
277: IF (p_exchange_rate_type IS NOT NULL) AND (p_exchange_rate_type = 'User') THEN
278: l_acctd_receipt_amt_new := arp_util.functional_amount(
279: l_cr_rec.amount,
280: ARP_GLOBAL.functional_currency,
281: nvl(p_exchange_rate,1),
282: NULL,NULL );
283:
284: l_exchange_rate := nvl(p_exchange_rate,1);

Line 289: ARP_GLOBAL.functional_currency,

285:
286: ELSIF (p_exchange_rate_type IS NULL) AND (l_exchange_rate_type = 'User') THEN
287: l_acctd_receipt_amt_new := arp_util.functional_amount(
288: l_cr_rec.amount,
289: ARP_GLOBAL.functional_currency,
290: nvl(l_crh_rec_old.exchange_rate,1),
291: NULL,NULL );
292:
293: l_exchange_rate := nvl(l_crh_rec_old.exchange_rate,1);

Line 297: ARP_GLOBAL.functional_currency,

293: l_exchange_rate := nvl(l_crh_rec_old.exchange_rate,1);
294: ELSE
295: l_acctd_receipt_amt_new := gl_currency_api.convert_amount(
296: l_cr_rec.currency_code,
297: ARP_GLOBAL.functional_currency,
298: l_exchange_date,
299: l_exchange_rate_type,
300: l_cr_rec.amount);
301:

Line 304: ARP_GLOBAL.functional_currency,

300: l_cr_rec.amount);
301:
302: l_exchange_rate := gl_currency_api.get_rate(
303: l_cr_rec.currency_code,
304: ARP_GLOBAL.functional_currency,
305: l_exchange_date,
306: l_exchange_rate_type);
307: END IF;
308: ELSE

Line 324: ARP_GLOBAL.functional_currency,

320:
321: IF (p_exchange_rate_type IS NOT NULL) AND (p_exchange_rate_type = 'User') THEN
322: l_crh_rec_new.acctd_amount := arp_util.functional_amount(
323: p_amount_cleared,
324: ARP_GLOBAL.functional_currency,
325: nvl(p_exchange_rate,1),
326: NULL,NULL );
327:
328: l_exchange_rate := nvl(p_exchange_rate,1);

Line 333: ARP_GLOBAL.functional_currency,

329:
330: ELSIF (p_exchange_rate_type IS NULL) AND (l_exchange_rate_type = 'User') THEN
331: l_crh_rec_new.acctd_amount := arp_util.functional_amount(
332: p_amount_cleared,
333: ARP_GLOBAL.functional_currency,
334: nvl(l_crh_rec_old.exchange_rate,1),
335: NULL,NULL );
336:
337: l_exchange_rate := nvl(l_crh_rec_old.exchange_rate,1);

Line 342: ARP_GLOBAL.functional_currency,

338:
339: ELSE
340: l_crh_rec_new.acctd_amount := gl_currency_api.convert_amount(
341: l_cr_rec.currency_code,
342: ARP_GLOBAL.functional_currency,
343: l_exchange_date,
344: l_exchange_rate_type,
345: p_amount_cleared);
346:

Line 349: ARP_GLOBAL.functional_currency,

345: p_amount_cleared);
346:
347: l_exchange_rate := gl_currency_api.get_rate(
348: l_cr_rec.currency_code,
349: ARP_GLOBAL.functional_currency,
350: l_exchange_date,
351: l_exchange_rate_type);
352:
353: END IF;

Line 379: ARP_GLOBAL.functional_currency,

375:
376: IF (p_exchange_rate_type IS NOT NULL) AND (p_exchange_rate_type = 'User') THEN
377: l_convert_receipt_amt := arp_util.functional_amount
378: (l_cr_rec.amount,
379: ARP_GLOBAL.functional_currency,
380: NVL(p_exchange_rate,1),null,null);
381:
382: l_exchange_rate := nvl(p_exchange_rate,1);
383:

Line 387: ARP_GLOBAL.functional_currency,

383:
384: ELSIF (p_exchange_rate_type IS NULL) AND (l_exchange_rate_type = 'User') THEN
385: l_convert_receipt_amt := arp_util.functional_amount
386: (l_cr_rec.amount,
387: ARP_GLOBAL.functional_currency,
388: NVL(l_crh_rec_old.exchange_rate,1),null,null);
389:
390: l_exchange_rate := nvl(l_crh_rec_old.exchange_rate,1);
391:

Line 395: ARP_GLOBAL.functional_currency,

391:
392: ELSE
393: l_convert_receipt_amt := gl_currency_api.convert_amount(
394: l_cr_rec.currency_code,
395: ARP_GLOBAL.functional_currency,
396: l_exchange_date,
397: l_exchange_rate_type,
398: l_cr_rec.amount);
399:

Line 402: ARP_GLOBAL.functional_currency,

398: l_cr_rec.amount);
399:
400: l_exchange_rate := gl_currency_api.get_rate(
401: l_cr_rec.currency_code,
402: ARP_GLOBAL.functional_currency,
403: l_exchange_date,
404: l_exchange_rate_type);
405: END IF;
406:

Line 443: ARP_GLOBAL.functional_currency,

439: l_exchange_rate := 1/nvl(l_crh_rec_old.exchange_rate,1);
440:
441: ELSE
442: l_crh_rec_new.amount := gl_currency_api.convert_amount(
443: ARP_GLOBAL.functional_currency,
444: l_cr_rec.currency_code,
445: l_exchange_date,
446: l_exchange_rate_type,
447: p_amount_cleared);

Line 450: ARP_GLOBAL.functional_currency,

446: l_exchange_rate_type,
447: p_amount_cleared);
448:
449: l_exchange_rate := gl_currency_api.get_rate(
450: ARP_GLOBAL.functional_currency,
451: l_cr_rec.currency_code,
452: l_exchange_date,
453: l_exchange_rate_type);
454: END IF;

Line 543: -- l_event_rec.xla_req_id := arp_global.request_id;

539: arp_cr_history_pkg.update_p( l_crh_rec_old );
540:
541: --Bug#2750340
542: --{BUG#5051143 - the cash book call is document based not request based
543: -- l_event_rec.xla_req_id := arp_global.request_id;
544: -- l_event_rec.xla_mode := 'B';
545: --}
546: l_event_rec.xla_from_doc_id := p_cr_id;
547: l_event_rec.xla_to_doc_id := p_cr_id;

Line 925: ARP_GLOBAL.functional_currency,

921: THEN
922: l_radj_rec.cash_receipt_id := p_cr_id;
923: l_radj_rec.gain_loss := arp_util.functional_amount(
924: l_cr_rec.amount,
925: ARP_GLOBAL.functional_currency,
926: (l_crh_rec_new.exchange_rate - l_crh_rec_old.exchange_rate),
927: NULL,NULL );
928: l_radj_rec.gl_date := p_gl_date;
929: l_radj_rec.new_exchange_date := l_crh_rec_new.exchange_date;

Line 946: ARP_GLOBAL.created_by,

942: l_radj_rec.new_exchange_date,
943: l_radj_rec.new_exchange_rate,
944: l_radj_rec.new_exchange_rate_type,
945: l_radj_rec.gl_date,
946: ARP_GLOBAL.created_by,
947: ARP_GLOBAL.creation_date,
948: ARP_GLOBAL.last_updated_by,
949: ARP_GLOBAL.last_update_date,
950: ARP_GLOBAL.last_update_login,

Line 947: ARP_GLOBAL.creation_date,

943: l_radj_rec.new_exchange_rate,
944: l_radj_rec.new_exchange_rate_type,
945: l_radj_rec.gl_date,
946: ARP_GLOBAL.created_by,
947: ARP_GLOBAL.creation_date,
948: ARP_GLOBAL.last_updated_by,
949: ARP_GLOBAL.last_update_date,
950: ARP_GLOBAL.last_update_login,
951: FALSE,

Line 948: ARP_GLOBAL.last_updated_by,

944: l_radj_rec.new_exchange_rate_type,
945: l_radj_rec.gl_date,
946: ARP_GLOBAL.created_by,
947: ARP_GLOBAL.creation_date,
948: ARP_GLOBAL.last_updated_by,
949: ARP_GLOBAL.last_update_date,
950: ARP_GLOBAL.last_update_login,
951: FALSE,
952: l_crh_rec_new.cash_receipt_history_id

Line 949: ARP_GLOBAL.last_update_date,

945: l_radj_rec.gl_date,
946: ARP_GLOBAL.created_by,
947: ARP_GLOBAL.creation_date,
948: ARP_GLOBAL.last_updated_by,
949: ARP_GLOBAL.last_update_date,
950: ARP_GLOBAL.last_update_login,
951: FALSE,
952: l_crh_rec_new.cash_receipt_history_id
953: );

Line 950: ARP_GLOBAL.last_update_login,

946: ARP_GLOBAL.created_by,
947: ARP_GLOBAL.creation_date,
948: ARP_GLOBAL.last_updated_by,
949: ARP_GLOBAL.last_update_date,
950: ARP_GLOBAL.last_update_login,
951: FALSE,
952: l_crh_rec_new.cash_receipt_history_id
953: );
954:

Line 963: last_updated_by = arp_global.last_updated_by,

959: --Yao Zhang modified for bug 10124745
960: UPDATE AR_CASH_RECEIPTS
961: SET actual_value_date = p_actual_value_date,
962: rec_version_number = nvl(rec_version_number,1)+1, /* bug 3372585 */
963: last_updated_by = arp_global.last_updated_by,
964: last_update_date = SYSDATE,
965: last_update_login = arp_global.last_update_login
966:
967: WHERE cash_receipt_id = p_cr_id;

Line 965: last_update_login = arp_global.last_update_login

961: SET actual_value_date = p_actual_value_date,
962: rec_version_number = nvl(rec_version_number,1)+1, /* bug 3372585 */
963: last_updated_by = arp_global.last_updated_by,
964: last_update_date = SYSDATE,
965: last_update_login = arp_global.last_update_login
966:
967: WHERE cash_receipt_id = p_cr_id;
968:
969: -- Populate OUT NOCOPY parameters

Line 1090: arp_global.init_global(mo_global.get_current_org_id);

1086:
1087:
1088: --Setting the Org Context Bug5212892
1089: ar_mo_global_cache.populate;
1090: arp_global.init_global(mo_global.get_current_org_id);
1091: arp_standard.init_standard(mo_global.get_current_org_id);
1092:
1093:
1094: -- Assume this receipt has already been locked

Line 1171: ARP_GLOBAL.functional_currency,

1167: THEN
1168: l_radj_rec.cash_receipt_id := p_cr_id;
1169: l_radj_rec.gain_loss := arp_util.functional_amount(
1170: l_cr_rec.amount,
1171: ARP_GLOBAL.functional_currency,
1172: (l_crh_rec_prv_stat.exchange_rate - l_crh_rec_old.exchange_rate),
1173: NULL,NULL );
1174: l_radj_rec.gl_date := p_gl_date;
1175: l_radj_rec.new_exchange_date := l_crh_rec_prv_stat.exchange_date;

Line 1192: ARP_GLOBAL.created_by,

1188: l_radj_rec.new_exchange_date,
1189: l_radj_rec.new_exchange_rate,
1190: l_radj_rec.new_exchange_rate_type,
1191: l_radj_rec.gl_date,
1192: ARP_GLOBAL.created_by,
1193: ARP_GLOBAL.creation_date,
1194: ARP_GLOBAL.last_updated_by,
1195: ARP_GLOBAL.last_update_date,
1196: ARP_GLOBAL.last_update_login,

Line 1193: ARP_GLOBAL.creation_date,

1189: l_radj_rec.new_exchange_rate,
1190: l_radj_rec.new_exchange_rate_type,
1191: l_radj_rec.gl_date,
1192: ARP_GLOBAL.created_by,
1193: ARP_GLOBAL.creation_date,
1194: ARP_GLOBAL.last_updated_by,
1195: ARP_GLOBAL.last_update_date,
1196: ARP_GLOBAL.last_update_login,
1197: TRUE, -- should this be FALSE??? OS 7/6/99

Line 1194: ARP_GLOBAL.last_updated_by,

1190: l_radj_rec.new_exchange_rate_type,
1191: l_radj_rec.gl_date,
1192: ARP_GLOBAL.created_by,
1193: ARP_GLOBAL.creation_date,
1194: ARP_GLOBAL.last_updated_by,
1195: ARP_GLOBAL.last_update_date,
1196: ARP_GLOBAL.last_update_login,
1197: TRUE, -- should this be FALSE??? OS 7/6/99
1198: l_new_crh_id_fr_radj

Line 1195: ARP_GLOBAL.last_update_date,

1191: l_radj_rec.gl_date,
1192: ARP_GLOBAL.created_by,
1193: ARP_GLOBAL.creation_date,
1194: ARP_GLOBAL.last_updated_by,
1195: ARP_GLOBAL.last_update_date,
1196: ARP_GLOBAL.last_update_login,
1197: TRUE, -- should this be FALSE??? OS 7/6/99
1198: l_new_crh_id_fr_radj
1199: );

Line 1196: ARP_GLOBAL.last_update_login,

1192: ARP_GLOBAL.created_by,
1193: ARP_GLOBAL.creation_date,
1194: ARP_GLOBAL.last_updated_by,
1195: ARP_GLOBAL.last_update_date,
1196: ARP_GLOBAL.last_update_login,
1197: TRUE, -- should this be FALSE??? OS 7/6/99
1198: l_new_crh_id_fr_radj
1199: );
1200: l_rate_Adj_reverted := 'Y';

Line 1219: ARP_GLOBAL.functional_currency,

1215:
1216: IF (l_crh_rec_prv_stat.exchange_rate_type = 'User') THEN
1217: l_crh_rec_new.acctd_amount := arp_util.functional_amount(
1218: l_crh_rec_prv_stat.amount,
1219: ARP_GLOBAL.functional_currency,
1220: nvl(l_crh_rec_prv_stat.exchange_rate,1),
1221: NULL,NULL );
1222: ELSE
1223: l_crh_rec_new.acctd_amount := gl_currency_api.convert_amount(

Line 1225: ARP_GLOBAL.functional_currency,

1221: NULL,NULL );
1222: ELSE
1223: l_crh_rec_new.acctd_amount := gl_currency_api.convert_amount(
1224: l_cr_rec.currency_code,
1225: ARP_GLOBAL.functional_currency,
1226: l_crh_rec_prv_stat.exchange_date,
1227: l_crh_rec_prv_stat.exchange_rate_type,
1228: l_crh_rec_prv_stat.amount);
1229: END IF;

Line 1484: last_updated_by = arp_global.last_updated_by,

1480: --Yao zhang modified for bug 10124745
1481: UPDATE AR_CASH_RECEIPTS
1482: SET actual_value_date = p_actual_value_date,
1483: rec_version_number = nvl(rec_version_number,1)+1, /* bug 3372585 */
1484: last_updated_by = arp_global.last_updated_by,
1485: last_update_date = SYSDATE,
1486: last_update_login = arp_global.last_update_login
1487: WHERE cash_receipt_id = p_cr_id;
1488:

Line 1486: last_update_login = arp_global.last_update_login

1482: SET actual_value_date = p_actual_value_date,
1483: rec_version_number = nvl(rec_version_number,1)+1, /* bug 3372585 */
1484: last_updated_by = arp_global.last_updated_by,
1485: last_update_date = SYSDATE,
1486: last_update_login = arp_global.last_update_login
1487: WHERE cash_receipt_id = p_cr_id;
1488:
1489: -- Populate OUT NOCOPY parameters
1490: p_crh_id := nvl(l_new_crh_id_fr_radj,l_crh_rec_new.cash_receipt_history_id);

Line 2107: arp_global.init_global(mo_global.get_current_org_id);

2103: p_cr_id);
2104: END;
2105:
2106: ar_mo_global_cache.populate;
2107: arp_global.init_global(mo_global.get_current_org_id);
2108: arp_standard.init_standard(mo_global.get_current_org_id);
2109: --modified by Jixun for bug#14726865 end
2110:
2111: /* Bug fix 2300268

Line 2786: last_updated_by = arp_global.last_updated_by,

2782: --Yao zhang modified for bug 10124745
2783: UPDATE AR_CASH_RECEIPTS
2784: SET actual_value_date = p_actual_value_date,
2785: rec_version_number = nvl(rec_version_number,1)+1, /* bug 3372585 */
2786: last_updated_by = arp_global.last_updated_by,
2787: last_update_date = SYSDATE,
2788: last_update_login = arp_global.last_update_login
2789: WHERE cash_receipt_id = p_cash_receipt_id;
2790:

Line 2788: last_update_login = arp_global.last_update_login

2784: SET actual_value_date = p_actual_value_date,
2785: rec_version_number = nvl(rec_version_number,1)+1, /* bug 3372585 */
2786: last_updated_by = arp_global.last_updated_by,
2787: last_update_date = SYSDATE,
2788: last_update_login = arp_global.last_update_login
2789: WHERE cash_receipt_id = p_cash_receipt_id;
2790:
2791: END;
2792: