APPS.PO_R12_CAT_UPG_VAL_PVT dependencies on GL_DAILY_CONVERSION_TYPES_V

Line 2339: -- Validates rate_type_code against GL_DAILY_CONVERSION_TYPES_V.

2335: -- b) FND_MSG_PUB on unhandled exceptions.
2336: --Locks:
2337: -- None.
2338: --Function:
2339: -- Validates rate_type_code against GL_DAILY_CONVERSION_TYPES_V.
2340: --Parameters:
2341: --IN:
2342: --p_key
2343: -- Key used to access records in PO_SESSION_GT table.

Line 2409: -- SQL What: Bulk validate rate_type_code against GL_DAILY_CONVERSION_TYPES_V.

2405: END LOOP;
2406: -- ECO bug 5584556: End
2407:
2408: l_progress := '030';
2409: -- SQL What: Bulk validate rate_type_code against GL_DAILY_CONVERSION_TYPES_V.
2410: -- Get the errored rows into GT table.
2411: -- SQL Why : It will be used to mark the record in plsql table as error.
2412: -- SQL Join: rate_type
2413: FORALL i IN 1 .. p_headers_rec.rate_type_code.COUNT

Line 2429: FROM GL_DAILY_CONVERSION_TYPES_V GLDCT

2425: AND p_headers_rec.currency_code(i) <> PO_R12_CAT_UPG_PVT.g_sys.currency_code
2426: AND p_headers_rec.rate_type_code(i) IS NOT NULL
2427: AND NOT EXISTS(
2428: SELECT 'Rate type exists'
2429: FROM GL_DAILY_CONVERSION_TYPES_V GLDCT
2430: WHERE GLDCT.conversion_type = p_headers_rec.rate_type_code(i));
2431:
2432: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of rows insert into GT table='||SQL%rowcount); END IF;
2433: