475: ,'oracle.apps.qa.ncm.detail.approve'
476: ,'oracle.apps.qa.ncm.master.approve'
477: ,'oracle.apps.qa.ncm.update')
478: THEN
479: DBMS_LOB.CREATETEMPORARY(l_PROG_EREC,TRUE,DBMS_LOB.SESSION);
480: l_QA_XML :='
481:
482:
483:
480: l_QA_XML :='
481:
482:
483:
484: DBMS_LOB.append(l_PROG_EREC,l_QA_XML);
485: DBMS_LOB.append(l_PROG_EREC,l_document.PSIG_DOCUMENT);
486: DBMS_LOB.append(l_PROG_EREC,'
487:
488:
481:
482:
483:
484: DBMS_LOB.append(l_PROG_EREC,l_QA_XML);
485: DBMS_LOB.append(l_PROG_EREC,l_document.PSIG_DOCUMENT);
486: DBMS_LOB.append(l_PROG_EREC,'
487:
488: ');
489:
482:
483:
484: DBMS_LOB.append(l_PROG_EREC,l_QA_XML);
485: DBMS_LOB.append(l_PROG_EREC,l_document.PSIG_DOCUMENT);
486: DBMS_LOB.append(l_PROG_EREC,'
487:
488: ');
489:
490: -- add code for constructing XML for E-Record Object.