APPS.OZF_WEBADI_INTERFACE_PVT dependencies on DUAL

Line 1351: FROM DUAL;

1347:
1348: IF l_status_code = 'NEW' AND l_batch_count = 0 THEN
1349: SELECT ozf_resale_batches_all_s.nextval
1350: INTO l_resale_batch_rec.resale_batch_id
1351: FROM DUAL;
1352:
1353: -- ==============================================================================
1354: -- Resale Batch ID is stored as global variable for the subsequent line record creation
1355: -- ==============================================================================

Line 1367: INTO l_resale_batch_rec.org_id FROM DUAL;

1363:
1364: -- R12 MOAC Enhancement (+)
1365: /*
1366: SELECT TO_NUMBER(NVL(SUBSTRB(USERENV('CLIENT_INFO'),1,10),-99))
1367: INTO l_resale_batch_rec.org_id FROM DUAL;
1368: */
1369: -- R12 MOAC Enhancement (-)
1370: BEGIN
1371:

Line 1463: --INTO l_int_line_tbl(1).org_id FROM DUAL;

1459: l_text := l_text||'Creating Line Record'||' \n ';
1460: ozf_utility_pvt.debug_message('Creating Line Record');
1461: -- Bug 5417666 (+)
1462: --SELECT TO_NUMBER(NVL(SUBSTRB(USERENV('CLIENT_INFO'),1,10),-99))
1463: --INTO l_int_line_tbl(1).org_id FROM DUAL;
1464: l_int_line_tbl(1).org_id := l_org_id;
1465: -- Bug 5417666 (-)
1466:
1467: SELECT ozf_resale_lines_int_all_s.nextval

Line 1469: FROM DUAL;

1465: -- Bug 5417666 (-)
1466:
1467: SELECT ozf_resale_lines_int_all_s.nextval
1468: INTO l_int_line_tbl(1).resale_line_int_id
1469: FROM DUAL;
1470: ozf_utility_pvt.debug_message('resale_line_int_id '||l_int_line_tbl(1).resale_line_int_id);
1471: IF G_RESALE_BATCH_ID = 0 OR l_resale_batch_rec.resale_batch_id IS NULL THEN
1472: SELECT resale_batch_id
1473: INTO l_int_line_tbl(1).resale_batch_id