APPS.FND_ODF_GEN dependencies on DUAL

Line 308: FROM DUAL;

304: l_eobjXMLs := XMLType.extract(l_indexXMLs,'ROWSET/ROW');
305:
306: SELECT extractValue(l_indexXMLs,'ROWSET/ROW/INDEX_T/SCHEMA_OBJ/NAME')
307: INTO l_indexName
308: FROM DUAL;
309: l_tmpXML := l_eobjXMLs.getClobVal();
310: if (instr(l_indexName,'I_SNAP$')= 0) then
311: l_indexCtr := l_indexCtr + 1;
312: l_depInfo := l_depInfo || ' ' || l_indexName || '

Line 386: FROM DUAL;

382:
383: l_eobjXMLs := XMLType.extract(l_indexXMLs,'ROWSET/ROW');
384: SELECT extractValue(l_indexXMLs,'ROWSET/ROW/INDEX_T/SCHEMA_OBJ/NAME')
385: INTO l_indexName
386: FROM DUAL;
387:
388:
389: -- l_indexNameXML := XMLType.extract(l_indexXMLs,'ROWSET/ROW/INDEX_T/SCHEMA_OBJ/NAME');
390: -- l_indexName := l_indexNameXML.getStringVal();

Line 462: FROM DUAL;

458: l_eobjXMLs := XMLType.extract(l_triggerXMLs,'ROWSET/ROW');
459:
460: SELECT extractValue(l_triggerXMLs,'ROWSET/ROW/TRIGGER_T/SCHEMA_OBJ/NAME')
461: INTO l_triggerName
462: FROM DUAL;
463:
464: if ((l_ctr = 1) or (instr(p_includeTrigger,l_triggerName) <> 0)) then
465: l_tmpXML := l_eobjXMLs.getClobVal();
466: dbms_lob.append(l_finalXML,l_tmpXML);

Line 635: FROM DUAL;

631: p_seqCount := p_seqCount + 1;
632: l_eobjXMLs := XMLType.extract(l_sequenceXML,'ROWSET/ROW');
633: SELECT extractValue(l_sequenceXML,'ROWSET/ROW/SEQUENCE_T/SCHEMA_OBJ/NAME')
634: INTO l_SeqName
635: FROM DUAL;
636: p_SeqListing := p_SeqListing || ' ' || l_SeqName || '
637: ';
638: l_tmpXML := l_eobjXMLs.getClobVal();
639: if ( l_finalXML is null ) then

Line 701: FROM DUAL;

697:
698: l_eobjXMLs := XMLType.extract(l_policyXML,'ROWSET/ROW');
699: SELECT extractValue(l_policyXML,'ROWSET/ROW/RLS_POLICY_T/NAME')
700: INTO l_policyName
701: FROM DUAL;
702:
703: if ((l_ctr = 1) or (instr(p_includePolicy,l_policyName) <> 0)) then
704: p_policyCount := p_policyCount + 1;
705: p_PolicyListing := p_PolicyListing || ' ' || l_policyName || '