APPS.OZF_WEBADI_INTERFACE_PVT dependencies on DUAL

Line 1740: FROM DUAL;

1736:
1737: IF l_status_code = 'NEW' AND l_batch_count = 0 THEN
1738: SELECT ozf_resale_batches_all_s.nextval
1739: INTO l_resale_batch_rec.resale_batch_id
1740: FROM DUAL;
1741:
1742: -- ==============================================================================
1743: -- Resale Batch ID is stored as global variable for the subsequent line record creation
1744: -- ==============================================================================

Line 1756: INTO l_resale_batch_rec.org_id FROM DUAL;

1752:
1753: -- R12 MOAC Enhancement (+)
1754: /*
1755: SELECT TO_NUMBER(NVL(SUBSTRB(USERENV('CLIENT_INFO'),1,10),-99))
1756: INTO l_resale_batch_rec.org_id FROM DUAL;
1757: */
1758: -- R12 MOAC Enhancement (-)
1759: BEGIN
1760:

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

1850: l_text := l_text||'Creating Line Record'||' \n ';
1851: ozf_utility_pvt.debug_message('Creating Line Record');
1852: -- Bug 5417666 (+)
1853: --SELECT TO_NUMBER(NVL(SUBSTRB(USERENV('CLIENT_INFO'),1,10),-99))
1854: --INTO l_int_line_tbl(1).org_id FROM DUAL;
1855: l_int_line_tbl(1).org_id := l_org_id;
1856: -- Bug 5417666 (-)
1857:
1858: SELECT ozf_resale_lines_int_all_s.nextval

Line 1860: FROM DUAL;

1856: -- Bug 5417666 (-)
1857:
1858: SELECT ozf_resale_lines_int_all_s.nextval
1859: INTO l_int_line_tbl(1).resale_line_int_id
1860: FROM DUAL;
1861: ozf_utility_pvt.debug_message('resale_line_int_id '||l_int_line_tbl(1).resale_line_int_id);
1862: IF G_RESALE_BATCH_ID = 0 OR l_resale_batch_rec.resale_batch_id IS NULL THEN
1863: SELECT resale_batch_id
1864: INTO l_int_line_tbl(1).resale_batch_id