APPS.PO_R12_CAT_UPG_VAL_PVT dependencies on FND_CURRENCIES

Line 446: -- Validates currency_code not null and against FND_CURRENCIES.

442: -- b) FND_MSG_PUB on unhandled exceptions.
443: --Locks:
444: -- None.
445: --Function:
446: -- Validates currency_code not null and against FND_CURRENCIES.
447: --Parameters:
448: --IN:
449: --p_key
450: -- Key used to access records in PO_SESSION_GT table.

Line 511: -- SQL What: Bulk validate currency_code not null and against FND_CURRENCIES.

507: END LOOP;
508: -- ECO bug 5584556: End
509:
510: l_progress := '020';
511: -- SQL What: Bulk validate currency_code not null and against FND_CURRENCIES.
512: -- Get the errored rows into GT table.
513: -- SQL Why : It will be used to mark the record in plsql table as error.
514: -- SQL Join: currency_code
515: FORALL i IN 1 .. p_headers_rec.currency_code.COUNT

Line 533: FROM FND_CURRENCIES CUR

529: -- So adding these additional where-clauses to skip those cases.
530: AND p_headers_rec.currency_code(i) IS NOT NULL
531: -- ECO bug 5584556: End
532: AND NOT EXISTS(SELECT 1
533: FROM FND_CURRENCIES CUR
534: WHERE p_headers_rec.currency_code(i) = CUR.currency_code
535: AND CUR.enabled_flag = 'Y'
536: AND sysdate BETWEEN
537: nvl(CUR.start_date_active, sysdate-1)

Line 2538: -- validate currency_code not null and against FND_CURRENCIES.

2534: p_headers_rec => p_headers_rec
2535: );
2536:
2537: l_progress := '030';
2538: -- validate currency_code not null and against FND_CURRENCIES.
2539: validate_currency_code
2540: (
2541: p_key => l_key,
2542: p_headers_rec => p_headers_rec