DBA Data[Home] [Help]

APPS.OZF_TP_ACCRUAL_PVT dependencies on DBMS_DB_VERSION

Line 4331: $IF DBMS_DB_VERSION.VER_LE_10 $THEN

4327: IF l_ozf_draft_accrual_tbl IS NOT NULL THEN
4328: IF l_ozf_draft_accrual_tbl.count > 0 THEN
4329:
4330: --//Fix for Bug 16170069 - Syntax correction
4331: $IF DBMS_DB_VERSION.VER_LE_10 $THEN
4332: FORALL ip IN NVL(l_ozf_draft_accrual_tbl.FIRST, 1) .. NVL(l_ozf_draft_accrual_tbl.LAST, 0)
4333: INSERT INTO
4334: (SELECT DRAFT_UTILIZATION_ID,
4335: DRAFT_RUN_ID,

Line 5592: $IF DBMS_DB_VERSION.VER_LE_10 $THEN

5588: FETCH csr_resale_log_details BULK COLLECT INTO l_resale_logs_tbl;
5589: CLOSE csr_resale_log_details;
5590:
5591: IF l_resale_logs_tbl.EXISTS(1) THEN
5592: $IF DBMS_DB_VERSION.VER_LE_10 $THEN
5593: FORALL i IN NVL(l_resale_logs_tbl.FIRST, 1) .. NVL(l_resale_logs_tbl.LAST, 0)
5594: INSERT INTO (SELECT
5595: RESALE_DRAFT_LOG_ID,
5596: RESALE_ID,