XML error
Hello Experts,
I have a table as below:
and my insert query is as below:
I am getting the below error:
I have a table as below:
create table sray
(BLUEPRINT_XML CLOB );and my insert query is as below:
set scan off;
set define off;
declare
tmpSql1 varchar2(32767);
tmpSql2 varchar2(32767);
tmpSql3 varchar2(32767);
tmpSql4 varchar2(32767);
tmpSql5 varchar2(32767);
tmpSql6 varchar2(32767);
tmpSql varchar2(32767);
tmpClob clob;
tmpSql1 :='<?xml version="1.0" encoding="UTF-8"?><mdf:flow xmlns:mdf="http://www.ABC.com/XXXXX/mdf" xmlns:html="http://www.w3.org/1999/xhtml"><mdf:blueprintcode>MS_RAF_RISK_ACCEPTANCE_BP</mdf:blueprintcode><mdf:blueprintname>Risk Acceptance Workflow BP</mdf:blueprintname><mdf:blueprintdesc><![CDATA[<p>To describe the Risk Acceptance process workflow</p><div></div>]]></mdf:blueprintdesc><mdf:requires_package_gen>Yes</mdf:requires_package_gen><mdf:readyflag>Y</mdf:readyflag><mdf:code /><mdf:enabled>Y</mdf:enabled><mdf:parameters /><mdf:rules /><mdf:assignees /><mdf:emailtemplates /><mdf:stages><mdf:stage><mdf:code>CreateEditRA</mdf:code><mdf:name>Create / Edit RA</mdf:name><mdf:description><![CDATA[<p>The initial stage where the RA form is created</p><div></div>]]></mdf:description><mdf:type>4</mdf:type><mdf:approvaltype>1</mdf:approvaltype><mdf:usedY2s>6</mdf:usedY2s><mdf:participant /><mdf:enabled>Y</mdf:enabled><mdf:parameters><mdf:parameter><mdf:code>pOwners</mdf:code><mdf:sourcetype>3</mdf:sourcetype><mdf:source /><mdf:description /></mdf:parameter><mdf:parameter><mdf:code>pRAF_ID</mdf:code><mdf:sourcetype>1</mdf:sourcetype><mdf:source /><mdf:description /></mdf:parameter><mdf:parameter><mdf:code>pRaf_Name</mdf:code><mdf:sourcetype>1</mdf:sourcetype><mdf:source /><mdf:description /></mdf:parameter><mdf:parameter><mdf:code>pAssessmentLink</mdf:code><mdf:sourcetype>3</mdf:sourcetype><mdf:source /><mdf:description /></mdf:parameter><mdf:parameter><mdf:code>pSubmitters</mdf:code><mdf:sourcetype>3</mdf:sourcetype><mdf:source /><mdf:description /></mdf:parameter><mdf:parameter><mdf:code>pRationale</mdf:code><mdf:sourcetype>1</mdf:sourcetype><mdf:source /><mdf:description /></mdf:parameter></mdf:parameters><mdf:rules><mdf:rule><mdf:code>Sub_to_Rev_Send_for_Review</mdf:code><mdf:type>1</mdf:type><mdf:object1 /><mdf:description /></mdf:rule><mdf:rule><mdf:code>Sub_To_Reviewer_Withdraw_Prev_Stage</mdf:code><mdf:type>1</mdf:type><mdf:object1 /><mdf:description /></mdf:rule><mdf:rule><mdf:code>Sub_To_mgr_Withdraw_Prev_Stage</mdf:code><mdf:type>1</mdf:type><mdf:object1 /><mdf:description /></mdf:rule><mdf:rule><mdf:code>Submitter_Withdraw_Action_Clarification</mdf:code><mdf:type>1</mdf:type><mdf:object1 /><mdf:description /></mdf:rule><mdf:rule><mdf:code>Submitter_Withdraw_Current_Stage</mdf:code>';
tmpSql1 := tmpSql1 || '<mdf:type>1</mdf:type><mdf:object1 /><mdf:description /></mdf:rule><mdf:rule><mdf:code>Submitter_Ack_Withdraw</mdf:code><mdf:type>1</mdf:type><mdf:object1 /><mdf:description /></mdf:rule><mdf:rule><mdf:code>Sub_To_Rev_Prov_Clarification_Action</mdf:code><mdf:type>1</mdf:type><mdf:object1 /><mdf:description /></mdf:rule><mdf:rule><mdf:code>Sub_To_Rev_Prov_Clarification_Status</mdf:code><mdf:type>1</mdf:type><mdf:object1 /><mdf:description /></mdf:rule><mdf:rule><mdf:code>Sub_To_Sub_Initial_Renew_Flag</mdf:code><mdf:type>1</mdf:type><mdf:object1 /><mdf:description /></mdf:rule><mdf:rule><mdf:code>Sub_To_Submitter_Status_Draft</mdf:code><mdf:type>1</mdf:type><mdf:object1 /><mdf:description /></mdf:rule><mdf:rule><mdf:code>Sub_Action_Req_Clarification</mdf:code><mdf:type>1</mdf:type><mdf:object1 /><mdf:description /></mdf:rule><mdf:rule><mdf:code>Submitter_Rejection_Status</mdf:code><mdf:type>1</mdf:type><mdf:object1 /><mdf:description /></mdf:rule><mdf:rule><mdf:code>Submitter_Withdrawal_Status</mdf:code><mdf:type>1</mdf:type><mdf:object1 /><mdf:description /></mdf:rule><mdf:rule><mdf:code>Sub_To_Rev_Multiple_Clarify_Send_Review</mdf:code><mdf:type>2</mdf:type><mdf:object1 /><mdf:description /></mdf:rule></mdf:rules><mdf:assignees><mdf:assignee><mdf:code>Submitter_Assignee</mdf:code><mdf:sourcetype>1</mdf:sourcetype><mdf:source /><mdf:description /></mdf:assignee><mdf:assignee><mdf:code>Submitter_Email_CC_Assignees</mdf:code><mdf:sourcetype>4</mdf:sourcetype><mdf:source /><mdf:description /></mdf:assignee></mdf:assignees></mdf:stage><mdf:stage><mdf:code>RAReviewer</mdf:code><mdf:name>RA Reviewer</mdf:name><mdf:description><![CDATA[<p>Reviewer reviews and provides Risk ratings in the form</p><div></div>]]></mdf:description><mdf:type>1</mdf:type><mdf:approvaltype>1</mdf:approvaltype><mdf:usedY2s>6</mdf:usedY2s><mdf:participant /><mdf:enabled>Y</mdf:enabled><mdf:parameters><mdf:parameter><mdf:code>pRAName</mdf:code><mdf:sourcetype>1</mdf:sourcetype><mdf:source /><mdf:description /></mdf:parameter><mdf:parameter><mdf:code>pAssesmentLink</mdf:code><mdf:sourcetype>3</mdf:sourcetype><mdf:source /><mdf:description /></mdf:parameter><mdf:parameter><mdf:code>pRAFId</mdf:code><mdf:sourcetype>1</mdf:sourcetype><mdf:source /><mdf:description /></mdf:parameter><mdf:parameter><mdf:code>pActionOwner</mdf:code>';
tmpSql1 := tmpSql1 || '<mdf:sourcetype>3</mdf:sourcetype><mdf:source /><mdf:description /></mdf:parameter><mdf:parameter><mdf:code>pReviewers</mdf:code><mdf:sourcetype>3</mdf:sourcetype><mdf:source /><mdf:description /></mdf:parameter><mdf:parameter><mdf:code>pClarificationReviewer</mdf:code><mdf:sourcetype>3</mdf:sourcetype><mdf:source /><mdf:description /></mdf:parameter></mdf:parameters><mdf:rules><mdf:rule><mdf:code>Rev_To_Manager_Review</mdf:code><mdf:type>1</mdf:type><mdf:object1 /><mdf:description /></mdf:rule><mdf:rule><mdf:code>Rev_To_Submitter_Clarification</mdf:code><mdf:type>1</mdf:type><mdf:object1 /><mdf:description /></mdf:rule><mdf:rule><mdf:code>Rev_To_Submitter_Withdraw</mdf:code><mdf:type>1</mdf:type><mdf:object1 /><mdf:description /></mdf:rule><mdf:rule><mdf:code>Rev_ToReviewer_Prev_App_ORG_NO</mdf:code><mdf:type>2</mdf:type><mdf:object1 /><mdf:description /></mdf:rule><mdf:rule><mdf:code>Rev_To_Mgr_Prev_Appr_ORG_YES</mdf:code><mdf:type>2</mdf:type><mdf:object1 /><mdf:description /></mdf:rule><mdf:rule><mdf:code>Rev_To_Rev_Approval_Clearance1</mdf:code><mdf:type>2</mdf:type><mdf:object1 /><mdf:description /></mdf:rule><mdf:rule><mdf:code>Rev_To_Mgr_Approval_Clearance2</mdf:code><mdf:type>2</mdf:type><mdf:object1 /><mdf:description /></mdf:rule><mdf:rule><mdf:code>RevTo_Sub_Feeback_Prev_Stage_Sub</mdf:code><mdf:type>1</mdf:type><mdf:object1 /><mdf:description /></mdf:rule><mdf:rule><mdf:code>Rev_To_Approver_Approve</mdf:code><mdf:type>1</mdf:type><mdf:object1 /><mdf:description /></mdf:rule><mdf:rule><mdf:code>Rev_To_Approver_Closure</mdf:code><mdf:type>1</mdf:type><mdf:object1 /><mdf:description /></mdf:rule><mdf:rule><mdf:code>Rev_To_Approver_Closure_Clarify</mdf:code><mdf:type>1</mdf:type><mdf:object1 /><mdf:description /></mdf:rule><mdf:rule><mdf:code>Rev_To_Approver_App_Clarify</mdf:code><mdf:type>1</mdf:type><mdf:object1 /><mdf:description /></mdf:rule><mdf:rule><mdf:code>Reviewer_Action_Null</mdf:code><mdf:type>1</mdf:type><mdf:object1 /><mdf:description /></mdf:rule><mdf:rule><mdf:code>Rev_To_Submitter_Reject_Action</mdf:code><mdf:type>1</mdf:type><mdf:object1 /><mdf:description /></mdf:rule><mdf:rule><mdf:code>Rev_To_Submitter_Rejection_Clarification</mdf:code><mdf:type>1</mdf:type><mdf:object1 /><mdf:description /></mdf:rule><mdf:rule><mdf:code>Rev_To_Submitter_Withdraw_Clarification</mdf:code>';
tmpSql1 := tmpSql1 || '<mdf:type>1</mdf:type><mdf:object1 /><mdf:description /></mdf:rule><mdf:rule><mdf:code>Rev_To_Manager_Review_Clarification_Flag</mdf:code><mdf:type>1</mdf:type><mdf:object1 /><mdf:description /></mdf:rule><mdf:rule><mdf:code>Rev_To_Mgr_Multiple_Clarify_Send_Review</mdf:code><mdf:type>2</mdf:type><mdf:object1 /><mdf:description /></mdf:rule><mdf:rule><mdf:code>Rev_To_Approver_Multi_Appr_Send_Review</mdf:code><mdf:type>2</mdf:type><mdf:object1 /><mdf:description /></mdf:rule><mdf:rule><mdf:code>Rev_To_Mgr_Prev_Stage_Mgr</mdf:code><mdf:type>1</mdf:type><mdf:object1 /><mdf:description /></mdf:rule><mdf:rule><mdf:code>Rev_To_Approver_TPrev_Stage_appr</mdf:code><mdf:type>1</mdf:type><mdf:object1 /><mdf:description /></mdf:rule><mdf:rule><mdf:code>Rev_To_Appr_checkValidClosureStatus</mdf:code><mdf:type>2</mdf:type><mdf:object1 /><mdf:description /></mdf:rule></mdf:rules><mdf:assignees><mdf:assignee><mdf:code>RA_Reviewer_Assignee</mdf:code><mdf:sourcetype>4</mdf:sourcetype><mdf:source /><mdf:description /></mdf:assignee><mdf:assignee><mdf:code>Reviewer_Email_CC_Assignees</mdf:code><mdf:sourcetype>4</mdf:sourcetype><mdf:source /><mdf:description /></mdf:assignee><mdf:assignee><mdf:code>RA_Reviewer_Assignees_ORM_TRM</mdf:code><mdf:sourcetype>4</mdf:sourcetype><mdf:source /><mdf:description /></mdf:assignee><mdf:assignee><mdf:code>Reviewer_Clarificaiton_Assignees</mdf:code><mdf:sourcetype>4</mdf:sourcetype><mdf:source /><mdf:description /></mdf:assignee><mdf:assignee><mdf:code>Reviewer_Clarification_Review_Assignees</mdf:code><mdf:sourcetype>4</mdf:sourcetype><mdf:source /><mdf:description /></mdf:assignee><mdf:assignee><mdf:code>Reviwer_Commom_CC_Email_Recipients</mdf:code><mdf:sourcetype>4</mdf:sourcetype><mdf:source /><mdf:description /></mdf:assignee></mdf:assignees></mdf:stage><mdf:stage><mdf:code>RAManager</mdf:code><mdf:name>RA Manager</mdf:name><mdf:description><![CDATA[<p>RA Manager can approve or close or withdraw or request clarification</p><div></div>]]></mdf:description><mdf:type>1</mdf:type><mdf:approvaltype>1</mdf:approvaltype><mdf:usedY2s>6</mdf:usedY2s><mdf:participant /><mdf:enabled>Y</mdf:enabled><mdf:parameters><mdf:parameter><mdf:code>pRAName</mdf:code><mdf:sourcetype>1</mdf:sourcetype><mdf:source /><mdf:description /></mdf:parameter><mdf:parameter><mdf:code>pRAFId</mdf:code>';
tmpSql1 := tmpSql1 || '<mdf:sourcetype>1</mdf:sourcetype><mdf:source /><mdf:description /></mdf:parameter><mdf:parameter><mdf:code>pAssessmentLink</mdf:code><mdf:sourcetype>3</mdf:sourcetype><mdf:source /><mdf:description /></mdf:parameter><mdf:parameter><mdf:code>pActionOwner</mdf:code><mdf:sourcetype>3</mdf:sourcetype><mdf:source /><mdf:description /></mdf:parameter><mdf:parameter><mdf:code>pManagers</mdf:code><mdf:sourcetype>3</mdf:sourcetype><mdf:source /><mdf:description /></mdf:parameter><mdf:parameter><mdf:code>pClarificationManagers</mdf:code><mdf:sourcetype>3</mdf:sourcetype><mdf:source /><mdf:description /></mdf:parameter></mdf:parameters><mdf:rules><mdf:rule><mdf:code>Manager_To_Reviewer</mdf:code><mdf:type>1</mdf:type><mdf:object1 /><mdf:description /></mdf:rule><mdf:rule><mdf:code>Manager_To_Manager_Prev_Appr_ORG_NO</mdf:code><mdf:type>2</mdf:type><mdf:object1 /><mdf:description /></mdf:rule><mdf:rule><mdf:code>Manager_To_Approver_Prev_Appr_ORG_YES</mdf:code><mdf:type>2</mdf:type><mdf:object1 /><mdf:description /></mdf:rule><mdf:rule><mdf:code>Manager_To_Manager_Approval_Clearance</mdf:code><mdf:type>2</mdf:type><mdf:object1 /><mdf:description /></mdf:rule><mdf:rule><mdf:code>Manager_To_Approver_Approval_Clearance</mdf:code><mdf:type>2</mdf:type><mdf:object1 /><mdf:description /></mdf:rule><mdf:rule><mdf:code>Manager_To_Submitter_Prev_Stage</mdf:code><mdf:type>1</mdf:type><mdf:object1 /><mdf:description /></mdf:rule><mdf:rule><mdf:code>Manger_To_Submitter_Withdraw_RA</mdf:code><mdf:type>1</mdf:type><mdf:object1 /><mdf:description /></mdf:rule><mdf:rule><mdf:code>Mgr_To_Approver_Approve</mdf:code><mdf:type>1</mdf:type><mdf:object1 /><mdf:description /></mdf:rule><mdf:rule><mdf:code>Manager_To_Approver_Close</mdf:code><mdf:type>1</mdf:type><mdf:object1 /><mdf:description /></mdf:rule><mdf:rule><mdf:code>Manager_Action_Null</mdf:code><mdf:type>1</mdf:type><mdf:object1 /><mdf:description /></mdf:rule><mdf:rule><mdf:code>Manager_To_Approver_Closure_Flag</mdf:code><mdf:type>1</mdf:type><mdf:object1 /><mdf:description /></mdf:rule><mdf:rule><mdf:code>Manager_To_Approver_Approval_Flag</mdf:code><mdf:type>1</mdf:type><mdf:object1 /><mdf:description /></mdf:rule><mdf:rule><mdf:code>Manager_To_Submitter_Withdraw_Flag</mdf:code><mdf:type>1</mdf:type><mdf:object1 /><mdf:description /></mdf:rule><mdf:rule>';
tmpSql1 := tmpSql1 || '</mdf:rule><mdf:rule><mdf:code>Approver_To_Manager_Prev_Stage</mdf:code><mdf:type>1</mdf:type><mdf:object1 /><mdf:description /></mdf:rule><mdf:rule><mdf:code>Approver_Action_Clarification</mdf:code><mdf:type>1</mdf:type><mdf:object1 /><mdf:description /></mdf:rule><mdf:rule><mdf:code>Approver_Status_Approval</mdf:code><mdf:type>1</mdf:type><mdf:object1 /><mdf:description /></mdf:rule><mdf:rule><mdf:code>Approver_Status_Closure</mdf:code><mdf:type>1</mdf:type><mdf:object1 /><mdf:description /></mdf:rule><mdf:rule><mdf:code>Approver_To_Approver_Self</mdf:code><mdf:type>2</mdf:type><mdf:object1 /><mdf:description /></mdf:rule><mdf:rule><mdf:code>Approver_To_Final_All_Approved</mdf:code><mdf:type>2</mdf:type><mdf:object1 /><mdf:description /></mdf:rule><mdf:rule><mdf:code>Appr_To_Approver_Self_Clarification_Clearance</mdf:code><mdf:type>2</mdf:type><mdf:object1 /><mdf:description /></mdf:rule><mdf:rule><mdf:code>App_To_Approver_Self_Approval_Clearance</mdf:code><mdf:type>2</mdf:type><mdf:object1 /><mdf:description /></mdf:rule></mdf:rules><mdf:assignees><mdf:assignee><mdf:code>RA_Approver_Assignee</mdf:code><mdf:sourcetype>1</mdf:sourcetype><mdf:source /><mdf:description /></mdf:assignee><mdf:assignee><mdf:code>RA_Approver_Clarification_Assignee</mdf:code><mdf:sourcetype>4</mdf:sourcetype><mdf:source /><mdf:description /></mdf:assignee><mdf:assignee><mdf:code>RA_Approver_Self_Assignees</mdf:code><mdf:sourcetype>4</mdf:sourcetype><mdf:source /><mdf:description /></mdf:assignee><mdf:assignee><mdf:code>RA_Approver_Clarify_Review_Assignees</mdf:code><mdf:sourcetype>4</mdf:sourcetype><mdf:source /><mdf:description /></mdf:assignee><mdf:assignee><mdf:code>RA_Approver_Sef_Clarification_Assignees</mdf:code><mdf:sourcetype>4</mdf:sourcetype><mdf:source /><mdf:description /></mdf:assignee><mdf:assignee><mdf:code>ApproverEmailCCAssignees</mdf:code><mdf:sourcetype>4</mdf:sourcetype><mdf:source /><mdf:description /></mdf:assignee></mdf:assignees></mdf:stage><mdf:stage><mdf:code>Final</mdf:code><mdf:name>Final</mdf:name><mdf:description /><mdf:type>3</mdf:type><mdf:approvaltype>1</mdf:approvaltype><mdf:usedY2s>6</mdf:usedY2s><mdf:participant /><mdf:enabled>Y</mdf:enabled><mdf:parameters><mdf:parameter><mdf:code>pAssessmentLInk</mdf:code><mdf:sourcetype>3</mdf:sourcetype><mdf:source /><mdf:description />';
tmpSql1 := tmpSql1 || '<mdf:code>Approver_Approved</mdf:code><mdf:type>1</mdf:type><mdf:object1 /><mdf:description /></mdf:rule><mdf:rule><mdf:code>Approver_To_Reviewer_Prev_Stage</mdf:code><mdf:type>1</mdf:type><mdf:object1 /><mdf:description /></mdf:rule><mdf:rule><mdf:code>Approver_To_Manager_Prev_Stage</mdf:code><mdf:type>1</mdf:type><mdf:object1 /><mdf:description /></mdf:rule><mdf:rule><mdf:code>Approver_Action_Clarification</mdf:code><mdf:type>1</mdf:type><mdf:object1 /><mdf:description /></mdf:rule><mdf:rule><mdf:code>Approver_Status_Approval</mdf:code><mdf:type>1</mdf:type><mdf:object1 /><mdf:description /></mdf:rule><mdf:rule><mdf:code>Approver_Status_Closure</mdf:code><mdf:type>1</mdf:type><mdf:object1 /><mdf:description /></mdf:rule><mdf:rule><mdf:code>Approver_To_Approver_Self</mdf:code><mdf:type>2</mdf:type><mdf:object1 /><mdf:description /></mdf:rule><mdf:rule><mdf:code>Approver_To_Final_All_Approved</mdf:code><mdf:type>2</mdf:type><mdf:object1 /><mdf:description /></mdf:rule><mdf:rule><mdf:code>Appr_To_Approver_Self_Clarification_Clearance</mdf:code><mdf:type>2</mdf:type><mdf:object1 /><mdf:description /></mdf:rule><mdf:rule><mdf:code>App_To_Approver_Self_Approval_Clearance</mdf:code><mdf:type>2</mdf:type><mdf:object1 /><mdf:description /></mdf:rule></mdf:rules><mdf:assignees><mdf:assignee><mdf:code>RA_Approver_Assignee</mdf:code><mdf:sourcetype>1</mdf:sourcetype><mdf:source /><mdf:description /></mdf:assignee><mdf:assignee><mdf:code>RA_Approver_Clarification_Assignee</mdf:code><mdf:sourcetype>4</mdf:sourcetype><mdf:source /><mdf:description /></mdf:assignee><mdf:assignee><mdf:code>RA_Approver_Self_Assignees</mdf:code><mdf:sourcetype>4</mdf:sourcetype><mdf:source /><mdf:description /></mdf:assignee><mdf:assignee><mdf:code>RA_Approver_Clarify_Review_Assignees</mdf:code><mdf:sourcetype>4</mdf:sourcetype><mdf:source /><mdf:description /></mdf:assignee><mdf:assignee><mdf:code>RA_Approver_Sef_Clarification_Assignees</mdf:code><mdf:sourcetype>4</mdf:sourcetype><mdf:source /><mdf:description /></mdf:assignee><mdf:assignee><mdf:code>ApproverEmailCCAssignees</mdf:code><mdf:sourcetype>4</mdf:sourcetype><mdf:source /><mdf:description /></mdf:assignee></mdf:assignees></mdf:stage><mdf:stage><mdf:code>Final</mdf:code><mdf:name>Final</mdf:name><mdf:description />';
tmpSql1 := tmpSql1 || '</mdf:parameter><mdf:parameter><mdf:code>pRAFId</mdf:code><mdf:sourcetype>1</mdf:sourcetype><mdf:source /><mdf:description /></mdf:parameter><mdf:parameter><mdf:code>pRAFName</mdf:code><mdf:sourcetype>1</mdf:sourcetype><mdf:source /><mdf:description /></mdf:parameter></mdf:parameters><mdf:rules><mdf:rule><mdf:code>Final_Status_Approved</mdf:code><mdf:type>1</mdf:type><mdf:object1 /><mdf:description /></mdf:rule><mdf:rule><mdf:code>Final_Action_Null</mdf:code><mdf:type>1</mdf:type><mdf:object1 /><mdf:description /></mdf:rule><mdf:rule><mdf:code>Final_Action_Close</mdf:code><mdf:type>1</mdf:type><mdf:object1 /><mdf:description /></mdf:rule><mdf:rule><mdf:code>Final_To_Approver_checkValidStatus</mdf:code><mdf:type>2</mdf:type><mdf:object1 /><mdf:description /></mdf:rule></mdf:rules><mdf:assignees><mdf:assignee><mdf:code>Submitter_Owner_Email_Assignees</mdf:code><mdf:sourcetype>4</mdf:sourcetype><mdf:source /><mdf:description /></mdf:assignee><mdf:assignee><mdf:code>Final_Stage_Email_CC_Assignees</mdf:code><mdf:sourcetype>4</mdf:sourcetype><mdf:source /><mdf:description /></mdf:assignee><mdf:assignee><mdf:code>Approver_Assignees</mdf:code><mdf:sourcetype>1</mdf:sourcetype><mdf:source /><mdf:description /></mdf:assignee><mdf:assignee><mdf:code>Sub_Approver_Owner_Email_assignees</mdf:code><mdf:sourcetype>4</mdf:sourcetype><mdf:source /><mdf:description /></mdf:assignee><mdf:assignee><mdf:code>Approver_Common_CC_Assignees</mdf:code><mdf:sourcetype>4</mdf:sourcetype><mdf:source /><mdf:description /></mdf:assignee></mdf:assignees></mdf:stage></mdf:stages><mdf:transitions><mdf:transition><mdf:code>Reviewer_To_Manager</mdf:code><mdf:description /><mdf:from>RAReviewer</mdf:from><mdf:to>RAManager</mdf:to><mdf:enabled>Y</mdf:enabled><mdf:assignments><mdf:assignment><mdf:code>Reviewer_Mgr_Assignmt</mdf:code><mdf:to>RA_Manager_Assigne</mdf:to><mdf:assignmenttext /><mdf:priority>2</mdf:priority><mdf:rulegroup>Rev_To_Manager_Review_RG</mdf:rulegroup><mdf:duedate><mdf:sourcetype /><mdf:source /></mdf:duedate><mdf:enabled>Y</mdf:enabled><mdf:description /></mdf:assignment><mdf:assignment><mdf:code>Rev_To_Manager_Review_Clarification</mdf:code><mdf:to>Manager_Clarification_Assignees</mdf:to><mdf:assignmenttext /><mdf:priority>2</mdf:priority><mdf:rulegroup>Rev_To_Manager_Clarification</mdf:rulegroup><mdf:duedate><mdf:sourcetype />';
tmpSql1 := tmpSql1 || '<mdf:source /></mdf:duedate><mdf:enabled>Y</mdf:enabled><mdf:description /></mdf:assignment><mdf:assignment><mdf:code>Rev_T0_Manager_Multi_Approvals</mdf:code><mdf:to>RA_Manager_Assigne</mdf:to><mdf:assignmenttext /><mdf:priority>2</mdf:priority><mdf:rulegroup>Rev_To_Mgr_Multi_Approvals_RG</mdf:rulegroup><mdf:duedate><mdf:sourcetype /><mdf:source /></mdf:duedate><mdf:enabled>Y</mdf:enabled><mdf:description /></mdf:assignment><mdf:assignment><mdf:code>Rev_To_Manager_Clarify_Send_Review</mdf:code><mdf:to>Manager_Clarification_Send_Review_Assignees</mdf:to><mdf:assignmenttext /><mdf:priority>2</mdf:priority><mdf:rulegroup>Rev_To_Manager_Clarify_Send_Review</mdf:rulegroup><mdf:duedate><mdf:sourcetype /><mdf:source /></mdf:duedate><mdf:enabled>Y</mdf:enabled><mdf:description /></mdf:assignment></mdf:assignments><mdf:emails><mdf:email><mdf:code>Reviewer_To_Manager_RA_Review</mdf:code></mdf:email><mdf:email><mdf:code>Rev_To_Mgr_Review_Clarification_Email</mdf:code></mdf:email></mdf:emails><mdf:rulegroups><mdf:rulegroup><mdf:code>Rev_To_Manager_Review_RG</mdf:code><mdf:enabled>Y</mdf:enabled><mdf:description /><mdf:rules /></mdf:rulegroup><mdf:rulegroup><mdf:code>Rev_To_Mgr_Multi_Approvals_RG</mdf:code><mdf:enabled>Y</mdf:enabled><mdf:description /><mdf:rules /></mdf:rulegroup><mdf:rulegroup><mdf:code>Rev_To_Manager_Clarification</mdf:code><mdf:enabled>Y</mdf:enabled><mdf:description /><mdf:rules /></mdf:rulegroup><mdf:rulegroup><mdf:code>Rev_To_Manager_Clarify_Send_Review</mdf:code><mdf:enabled>Y</mdf:enabled><mdf:description /><mdf:rules /></mdf:rulegroup></mdf:rulegroups><mdf:cif_list /></mdf:transition><mdf:transition><mdf:code>Manager_To_Approver</mdf:code><mdf:description /><mdf:from>RAManager</mdf:from><mdf:to>RAApprover</mdf:to><mdf:enabled>Y</mdf:enabled><mdf:assignments><mdf:assignment><mdf:code>Manager_To_Approver_Assignmt</mdf:code><mdf:to>RA_Approver_Assignee</mdf:to><mdf:assignmenttext /><mdf:priority>2</mdf:priority><mdf:rulegroup>Manager_To_Approver_Single_Approval</mdf:rulegroup><mdf:duedate><mdf:sourcetype /><mdf:source /></mdf:duedate><mdf:enabled>Y</mdf:enabled><mdf:description /></mdf:assignment><mdf:assignment><mdf:code>Mgr_To_Approver_Closure_Asmt</mdf:code><mdf:to>RA_Approver_Assignee</mdf:to><mdf:assignmenttext /><mdf:priority>2</mdf:priority>';
tmpSql2 := '<mdf:rulegroup>Mgr_To_Approver_Close</mdf:rulegroup><mdf:duedate><mdf:sourcetype /><mdf:source /></mdf:duedate><mdf:enabled>Y</mdf:enabled><mdf:description /></mdf:assignment><mdf:assignment><mdf:code>Mgr_To_Approver_Multi_Appr_Asmt</mdf:code><mdf:to>RA_Approver_Assignee</mdf:to><mdf:assignmenttext /><mdf:priority>2</mdf:priority><mdf:rulegroup>Manager_To_Approver_MultiApproval</mdf:rulegroup><mdf:duedate><mdf:sourcetype /><mdf:source /></mdf:duedate><mdf:enabled>Y</mdf:enabled><mdf:description /></mdf:assignment><mdf:assignment><mdf:code>Mgr_To_Approver_Closure_Clarfiy</mdf:code><mdf:to>RA_Approver_Clarification_Assignee</mdf:to><mdf:assignmenttext /><mdf:priority>2</mdf:priority><mdf:rulegroup>Mgr_To_Approver_Closure_Clarify</mdf:rulegroup><mdf:duedate><mdf:sourcetype /><mdf:source /></mdf:duedate><mdf:enabled>Y</mdf:enabled><mdf:description /></mdf:assignment><mdf:assignment><mdf:code>Mgr_To_Approver_Approval_Clarify</mdf:code><mdf:to>RA_Approver_Clarification_Assignee</mdf:to><mdf:assignmenttext /><mdf:priority>2</mdf:priority><mdf:rulegroup>Mgr_To_Approver_Approval_Clarify</mdf:rulegroup><mdf:duedate><mdf:sourcetype /><mdf:source /></mdf:duedate><mdf:enabled>Y</mdf:enabled><mdf:description /></mdf:assignment><mdf:assignment><mdf:code>Mgr_To_Approver_Clarify_Review_asmt</mdf:code><mdf:to>RA_Approver_Clarify_Review_Assignees</mdf:to><mdf:assignmenttext /><mdf:priority>2</mdf:priority><mdf:rulegroup>Mgr_To_Approver_Clarify_send_review</mdf:rulegroup><mdf:duedate><mdf:sourcetype /><mdf:source /></mdf:duedate><mdf:enabled>Y</mdf:enabled><mdf:description /></mdf:assignment><mdf:assignment><mdf:code>Mgr_To_Appr_Closure_Clarify_Review</mdf:code><mdf:to>RA_Approver_Clarify_Review_Assignees</mdf:to><mdf:assignmenttext /><mdf:priority>2</mdf:priority><mdf:rulegroup>Mgr_To_Appr_Closure_Clarify_Review</mdf:rulegroup><mdf:duedate><mdf:sourcetype /><mdf:source /></mdf:duedate><mdf:enabled>Y</mdf:enabled><mdf:description /></mdf:assignment></mdf:assignments><mdf:emails><mdf:email><mdf:code>Mgr_To_Approver_Approve_Single_Approval</mdf:code></mdf:email><mdf:email><mdf:code>Mgr_To_Approver_Multi_Approvals</mdf:code></mdf:email><mdf:email><mdf:code>Mgr_To_Approver_Closure_Email</mdf:code></mdf:email><mdf:email><mdf:code>Mgr_TO_Approver_Approval_Clarification_Email</mdf:code></mdf:email><mdf:email>';
tmpSql2 := tmpSql2 || '<mdf:code>Mgr_To_Approver_Closure_Clarification_Email</mdf:code></mdf:email></mdf:emails><mdf:rulegroups><mdf:rulegroup><mdf:code>Manager_To_Approver_Single_Approval</mdf:code><mdf:enabled>Y</mdf:enabled><mdf:description /><mdf:rules /></mdf:rulegroup><mdf:rulegroup><mdf:code>Manager_To_Approver_MultiApproval</mdf:code><mdf:enabled>Y</mdf:enabled><mdf:description /><mdf:rules /></mdf:rulegroup><mdf:rulegroup><mdf:code>Mgr_To_Approver_Close</mdf:code><mdf:enabled>Y</mdf:enabled><mdf:description /><mdf:rules /></mdf:rulegroup><mdf:rulegroup><mdf:code>Mgr_To_Approver_Approval_Clarify</mdf:code><mdf:enabled>Y</mdf:enabled><mdf:description /><mdf:rules /></mdf:rulegroup><mdf:rulegroup><mdf:code>Mgr_To_Approver_Closure_Clarify</mdf:code><mdf:enabled>Y</mdf:enabled><mdf:description /><mdf:rules /></mdf:rulegroup><mdf:rulegroup><mdf:code>Mgr_To_Approver_Clarify_send_review</mdf:code><mdf:enabled>Y</mdf:enabled><mdf:description /><mdf:rules /></mdf:rulegroup><mdf:rulegroup><mdf:code>Mgr_To_Appr_Closure_Clarify_Review</mdf:code><mdf:enabled>Y</mdf:enabled><mdf:description /><mdf:rules /></mdf:rulegroup></mdf:rulegroups><mdf:cif_list /></mdf:transition><mdf:transition><mdf:code>Reviewer_To_Submitter</mdf:code><mdf:description /><mdf:from>RAReviewer</mdf:from><mdf:to>CreateEditRA</mdf:to><mdf:enabled>Y</mdf:enabled><mdf:assignments><mdf:assignment><mdf:code>Reviewer_To_Submitter_Clarification_Req</mdf:code><mdf:to>Submitter_Assignee</mdf:to><mdf:assignmenttext /><mdf:priority>2</mdf:priority><mdf:rulegroup>Rev_To_Sub_Clarification_Req</mdf:rulegroup><mdf:duedate><mdf:sourcetype /><mdf:source /></mdf:duedate><mdf:enabled>Y</mdf:enabled><mdf:description /></mdf:assignment><mdf:assignment><mdf:code>Rev_To_Submitter_Withdraw_Fedback</mdf:code><mdf:to>Submitter_Assignee</mdf:to><mdf:assignmenttext /><mdf:priority>2</mdf:priority><mdf:rulegroup>Rev_To_Submitter_Withdraw_Feedback</mdf:rulegroup><mdf:duedate><mdf:sourcetype /><mdf:source /></mdf:duedate><mdf:enabled>Y</mdf:enabled><mdf:description /></mdf:assignment><mdf:assignment><mdf:code>Rev_To_Submitter_withdraw</mdf:code><mdf:to>Submitter_Assignee</mdf:to><mdf:assignmenttext /><mdf:priority>2</mdf:priority><mdf:rulegroup>Rev_To_Submitter_Withdraw</mdf:rulegroup><mdf:duedate><mdf:sourcetype /><mdf:source /></mdf:duedate><mdf:enabled>Y</mdf:enabled><mdf:description />';
tmpSql2 := tmpSql2 || '</mdf:assignment><mdf:assignment><mdf:code>Reviewer_To_Submitter_Rejection</mdf:code><mdf:to>Submitter_Assignee</mdf:to><mdf:assignmenttext /><mdf:priority>2</mdf:priority><mdf:rulegroup>Reviewer_To_Submitter_Rejection</mdf:rulegroup><mdf:duedate><mdf:sourcetype /><mdf:source /></mdf:duedate><mdf:enabled>Y</mdf:enabled><mdf:description /></mdf:assignment><mdf:assignment><mdf:code>Rev_To_Submitter_Rejection_clarification</mdf:code><mdf:to>Submitter_Assignee</mdf:to><mdf:assignmenttext /><mdf:priority>2</mdf:priority><mdf:rulegroup>Rev_To_Submitter_Rejection_Clarification</mdf:rulegroup><mdf:duedate><mdf:sourcetype /><mdf:source /></mdf:duedate><mdf:enabled>Y</mdf:enabled><mdf:description /></mdf:assignment></mdf:assignments><mdf:emails><mdf:email><mdf:code>Rev_To_Sub_Req_Clarification_Email</mdf:code></mdf:email><mdf:email><mdf:code>RevToSubmitterWithdrawEmail</mdf:code></mdf:email><mdf:email><mdf:code>Rev_To_Submitter_Rejection_Email</mdf:code></mdf:email><mdf:email><mdf:code>Rev_To_Submitter_Withdraw_Clarification</mdf:code></mdf:email><mdf:email><mdf:code>Rev_To_Submitter_Rejection_Clarification</mdf:code></mdf:email></mdf:emails><mdf:rulegroups><mdf:rulegroup><mdf:code>Rev_To_Submitter_Withdraw_Feedback</mdf:code><mdf:enabled>Y</mdf:enabled><mdf:description /><mdf:rules /></mdf:rulegroup><mdf:rulegroup><mdf:code>Rev_To_Sub_Clarification_Req</mdf:code><mdf:enabled>Y</mdf:enabled><mdf:description /><mdf:rules /></mdf:rulegroup><mdf:rulegroup><mdf:code>Rev_To_Submitter_Withdraw</mdf:code><mdf:enabled>Y</mdf:enabled><mdf:description /><mdf:rules /></mdf:rulegroup><mdf:rulegroup><mdf:code>Reviewer_To_Submitter_Rejection</mdf:code><mdf:enabled>Y</mdf:enabled><mdf:description /><mdf:rules /></mdf:rulegroup><mdf:rulegroup><mdf:code>Rev_To_Submitter_Rejection_Clarification</mdf:code><mdf:enabled>Y</mdf:enabled><mdf:description /><mdf:rules /></mdf:rulegroup></mdf:rulegroups><mdf:cif_list /></mdf:transition><mdf:transition><mdf:code>Reviewer_To_Approver</mdf:code><mdf:description /><mdf:from>RAReviewer</mdf:from><mdf:to>RAApprover</mdf:to><mdf:enabled>Y</mdf:enabled><mdf:assignments><mdf:assignment><mdf:code>Reviewer_To_Approver_Assignmt</mdf:code><mdf:to>RA_Approver_Assignee</mdf:to><mdf:assignmenttext /><mdf:priority>2</mdf:priority><mdf:rulegroup>Rev_TO_Approver_Approve</mdf:rulegroup><mdf:duedate><mdf:sourcetype /><mdf:source />';
tmpSql2 := tmpSql2 || '</mdf:duedate><mdf:enabled>Y</mdf:enabled><mdf:description /></mdf:assignment><mdf:assignment><mdf:code>Rev_To_Approver_Closure</mdf:code><mdf:to>RA_Approver_Assignee</mdf:to><mdf:assignmenttext /><mdf:priority>2</mdf:priority><mdf:rulegroup>Rev_To_Approver_Closure</mdf:rulegroup><mdf:duedate><mdf:sourcetype /><mdf:source /></mdf:duedate><mdf:enabled>Y</mdf:enabled><mdf:description /></mdf:assignment><mdf:assignment><mdf:code>Rev_To_Approver_App_Clarify</mdf:code><mdf:to>RA_Approver_Clarification_Assignee</mdf:to><mdf:assignmenttext /><mdf:priority>2</mdf:priority><mdf:rulegroup>Rev_To_Approver_Approval_Clarification</mdf:rulegroup><mdf:duedate><mdf:sourcetype /><mdf:source /></mdf:duedate><mdf:enabled>Y</mdf:enabled><mdf:description /></mdf:assignment><mdf:assignment><mdf:code>Rev_To_Approver_Closure_Clarify</mdf:code><mdf:to>RA_Approver_Clarification_Assignee</mdf:to><mdf:assignmenttext /><mdf:priority>2</mdf:priority><mdf:rulegroup>Rev_To_Approver_Closure_Clarification</mdf:rulegroup><mdf:duedate><mdf:sourcetype /><mdf:source /></mdf:duedate><mdf:enabled>Y</mdf:enabled><mdf:description /></mdf:assignment><mdf:assignment><mdf:code>Rev_To_Approver_Multi_Clarify_Send_Review</mdf:code><mdf:to>RA_Approver_Clarify_Review_Assignees</mdf:to><mdf:assignmenttext /><mdf:priority>2</mdf:priority><mdf:rulegroup>Rev_To_approver_multi_Clarify_Send_Review</mdf:rulegroup><mdf:duedate><mdf:sourcetype /><mdf:source /></mdf:duedate><mdf:enabled>Y</mdf:enabled><mdf:description /></mdf:assignment><mdf:assignment><mdf:code>Rev_To_Appr_Closure_Multi_Clarify_Review</mdf:code><mdf:to>RA_Approver_Clarify_Review_Assignees</mdf:to><mdf:assignmenttext /><mdf:priority>2</mdf:priority><mdf:rulegroup>Rev_To_Appr_Closure_Multi_Appr_Clarify_Review</mdf:rulegroup><mdf:duedate><mdf:sourcetype /><mdf:source /></mdf:duedate><mdf:enabled>Y</mdf:enabled><mdf:description /></mdf:assignment></mdf:assignments><mdf:emails><mdf:email><mdf:code>RevTOApproverApprovalEmail</mdf:code></mdf:email><mdf:email><mdf:code>RevTOApproverClosureEmail</mdf:code></mdf:email><mdf:email><mdf:code>Rev_To_Approver_Prov_Closure_Clarification</mdf:code></mdf:email><mdf:email><mdf:code>Rev_To_Approver_Prov_Approval_Clarification</mdf:code></mdf:email></mdf:emails><mdf:rulegroups><mdf:rulegroup><mdf:code>Rev_TO_Approver_Approve</mdf:code><mdf:enabled>Y</mdf:enabled><mdf:description /><mdf:rules /></mdf:rulegroup><mdf:rulegroup><mdf:code>Rev_To_Approver_Closure</mdf:code>';
tmpSql2 := tmpSql2 || '<mdf:enabled>Y</mdf:enabled><mdf:description /><mdf:rules /></mdf:rulegroup><mdf:rulegroup><mdf:code>Rev_To_Approver_Closure_Clarification</mdf:code><mdf:enabled>Y</mdf:enabled><mdf:description /><mdf:rules /></mdf:rulegroup><mdf:rulegroup><mdf:code>Rev_To_Approver_Approval_Clarification</mdf:code><mdf:enabled>Y</mdf:enabled><mdf:description /><mdf:rules /></mdf:rulegroup><mdf:rulegroup><mdf:code>Rev_To_approver_multi_Clarify_Send_Review</mdf:code><mdf:enabled>Y</mdf:enabled><mdf:description /><mdf:rules /></mdf:rulegroup><mdf:rulegroup><mdf:code>Rev_To_Appr_Closure_Multi_Appr_Clarify_Review</mdf:code><mdf:enabled>Y</mdf:enabled><mdf:description /><mdf:rules /></mdf:rulegroup></mdf:rulegroups><mdf:cif_list /></mdf:transition><mdf:transition><mdf:code>Manager_To_Reviewer</mdf:code><mdf:description /><mdf:from>RAManager</mdf:from><mdf:to>RAReviewer</mdf:to><mdf:enabled>Y</mdf:enabled><mdf:assignments><mdf:assignment><mdf:code>Manager_To_Reviewer_Assignmt</mdf:code><mdf:to>Reviewer_Clarificaiton_Assignees</mdf:to><mdf:assignmenttext /><mdf:priority>2</mdf:priority><mdf:rulegroup>Manager_To_Reviewer_RG</mdf:rulegroup><mdf:duedate><mdf:sourcetype /><mdf:source /></mdf:duedate><mdf:enabled>Y</mdf:enabled><mdf:description /></mdf:assignment></mdf:assignments><mdf:emails><mdf:email><mdf:code>Mgr_To_Reviewer_Req_Clarification</mdf:code></mdf:email></mdf:emails><mdf:rulegroups><mdf:rulegroup><mdf:code>Manager_To_Reviewer_RG</mdf:code><mdf:enabled>Y</mdf:enabled><mdf:description /><mdf:rules /></mdf:rulegroup></mdf:rulegroups><mdf:cif_list /></mdf:transition><mdf:transition><mdf:code>Approver_To_Reviewer</mdf:code><mdf:description /><mdf:from>RAApprover</mdf:from><mdf:to>RAReviewer</mdf:to><mdf:enabled>Y</mdf:enabled><mdf:assignments><mdf:assignment><mdf:code>Appr_To_Rev_Approval_Clarify</mdf:code><mdf:to>Reviewer_Clarificaiton_Assignees</mdf:to><mdf:assignmenttext /><mdf:priority>2</mdf:priority><mdf:rulegroup>Approver_To_Rev_Approval_Clarify</mdf:rulegroup><mdf:duedate><mdf:sourcetype /><mdf:source /></mdf:duedate><mdf:enabled>Y</mdf:enabled><mdf:description /></mdf:assignment><mdf:assignment><mdf:code>Appr_To_Rev_Closure_Clarfiy</mdf:code><mdf:to>Reviewer_Clarificaiton_Assignees</mdf:to><mdf:assignmenttext /><mdf:priority>2</mdf:priority><mdf:rulegroup>Approver_To_Rev_Closure_Clarify</mdf:rulegroup><mdf:duedate>';
tmpSql2 := tmpSql2 || '<mdf:sourcetype /><mdf:source /></mdf:duedate><mdf:enabled>Y</mdf:enabled><mdf:description /></mdf:assignment></mdf:assignments><mdf:emails><mdf:email><mdf:code>Approver_To_Reviewer_Approval_Clarify_Email</mdf:code></mdf:email><mdf:email><mdf:code>Approver_To_Reviewer_Closure_Clarify_Email</mdf:code></mdf:email></mdf:emails><mdf:rulegroups><mdf:rulegroup><mdf:code>Approver_To_Rev_Approval_Clarify</mdf:code><mdf:enabled>Y</mdf:enabled><mdf:description /><mdf:rules /></mdf:rulegroup><mdf:rulegroup><mdf:code>Approver_To_Rev_Closure_Clarify</mdf:code><mdf:enabled>Y</mdf:enabled><mdf:description /><mdf:rules /></mdf:rulegroup></mdf:rulegroups><mdf:cif_list /></mdf:transition><mdf:transition><mdf:code>Approver_To_Final</mdf:code><mdf:description /><mdf:from>RAApprover</mdf:from><mdf:to>Final</mdf:to><mdf:enabled>Y</mdf:enabled><mdf:assignments /><mdf:emails><mdf:email><mdf:code>Final_Approved_Notificaiton_Emails</mdf:code></mdf:email><mdf:email><mdf:code>Final_Closed_Emails</mdf:code></mdf:email></mdf:emails><mdf:rulegroups><mdf:rulegroup><mdf:code>Approver_To_Final_RG</mdf:code><mdf:enabled>Y</mdf:enabled><mdf:description /><mdf:rules /></mdf:rulegroup><mdf:rulegroup><mdf:code>Approver_to_Final_Closure_RG</mdf:code><mdf:enabled>Y</mdf:enabled><mdf:description /><mdf:rules /></mdf:rulegroup></mdf:rulegroups><mdf:cif_list /></mdf:transition><mdf:transition><mdf:code>Manager_To_Submitter</mdf:code><mdf:description /><mdf:from>RAManager</mdf:from><mdf:to>CreateEditRA</mdf:to><mdf:enabled>Y</mdf:enabled><mdf:assignments><mdf:assignment><mdf:code>Manager_To_Submitter_Withdraw</mdf:code><mdf:to>Submitter_Assignee</mdf:to><mdf:assignmenttext /><mdf:priority>2</mdf:priority><mdf:rulegroup>Manager_To_Submitter_Withdraw</mdf:rulegroup><mdf:duedate><mdf:sourcetype /><mdf:source /></mdf:duedate><mdf:enabled>Y</mdf:enabled><mdf:description /></mdf:assignment><mdf:assignment><mdf:code>Manager_TO_Submitter_Clarification</mdf:code><mdf:to>Submitter_Assignee</mdf:to><mdf:assignmenttext /><mdf:priority>2</mdf:priority><mdf:rulegroup>Manager_To_Submitter_Clarification</mdf:rulegroup><mdf:duedate><mdf:sourcetype /><mdf:source /></mdf:duedate><mdf:enabled>Y</mdf:enabled><mdf:description /></mdf:assignment></mdf:assignments><mdf:emails><mdf:email><mdf:code>Mgr_To_Submitter_Withdraw_EMail</mdf:code></mdf:email><mdf:email><mdf:code>Manager_To_Submitter_Prov_Withdraw_Clarification</mdf:code>';
tmpSql2 := tmpSql2 || '</mdf:email></mdf:emails><mdf:rulegroups><mdf:rulegroup><mdf:code>Manager_To_Submitter_Withdraw</mdf:code><mdf:enabled>Y</mdf:enabled><mdf:description /><mdf:rules /></mdf:rulegroup><mdf:rulegroup><mdf:code>Manager_To_Submitter_Clarification</mdf:code><mdf:enabled>Y</mdf:enabled><mdf:description /><mdf:rules /></mdf:rulegroup></mdf:rulegroups><mdf:cif_list /></mdf:transition><mdf:transition><mdf:code>Approver_To_Manager</mdf:code><mdf:description /><mdf:from>RAApprover</mdf:from><mdf:to>RAManager</mdf:to><mdf:enabled>Y</mdf:enabled><mdf:assignments><mdf:assignment><mdf:code>Appr_To_Mgr_Approval_Clarify</mdf:code><mdf:to>Manager_Clarification_Assignees</mdf:to><mdf:assignmenttext /><mdf:priority>2</mdf:priority><mdf:rulegroup>Approver_To_Mgr_Approval_Clarify</mdf:rulegroup><mdf:duedate><mdf:sourcetype /><mdf:source /></mdf:duedate><mdf:enabled>Y</mdf:enabled><mdf:description /></mdf:assignment><mdf:assignment><mdf:code>Approver_To_mgr_Closure_Clarify</mdf:code><mdf:to>Manager_Clarification_Assignees</mdf:to><mdf:assignmenttext /><mdf:priority>2</mdf:priority><mdf:rulegroup>Approver_To_Manager_Closure_Clarify</mdf:rulegroup><mdf:duedate><mdf:sourcetype /><mdf:source /></mdf:duedate><mdf:enabled>Y</mdf:enabled><mdf:description /></mdf:assignment></mdf:assignments><mdf:emails><mdf:email><mdf:code>Approver_To_Mgr_Email_Approval_Clarification</mdf:code></mdf:email><mdf:email><mdf:code>Approver_To_Mgr_Closure_Email_Clarification</mdf:code></mdf:email></mdf:emails><mdf:rulegroups><mdf:rulegroup><mdf:code>Approver_To_Mgr_Approval_Clarify</mdf:code><mdf:enabled>Y</mdf:enabled><mdf:description /><mdf:rules /></mdf:rulegroup><mdf:rulegroup><mdf:code>Approver_To_Manager_Closure_Clarify</mdf:code><mdf:enabled>Y</mdf:enabled><mdf:description /><mdf:rules /></mdf:rulegroup></mdf:rulegroups><mdf:cif_list /></mdf:transition><mdf:transition><mdf:code>Submitter_To_Reviewer_Submit</mdf:code><mdf:description /><mdf:from>CreateEditRA</mdf:from><mdf:to>RAReviewer</mdf:to><mdf:enabled>Y</mdf:enabled><mdf:assignments><mdf:assignment><mdf:code>Submitter_To_Reviewer_Review_Asmt</mdf:code><mdf:to>RA_Reviewer_Assignee</mdf:to><mdf:assignmenttext /><mdf:priority>2</mdf:priority><mdf:rulegroup>Submitter_To_Reviewer_Review</mdf:rulegroup><mdf:duedate><mdf:sourcetype /><mdf:source /></mdf:duedate><mdf:enabled>Y</mdf:enabled><mdf:description />';
tmpSql2 := tmpSql2 || '</mdf:assignment><mdf:assignment><mdf:code>Submitter_To_reviewer_Withdraw_Clarification</mdf:code><mdf:to>Reviewer_Clarificaiton_Assignees</mdf:to><mdf:assignmenttext /><mdf:priority>2</mdf:priority><mdf:rulegroup>Sub_To_Reviewer_Withdraw_Clarification</mdf:rulegroup><mdf:duedate><mdf:sourcetype /><mdf:source /></mdf:duedate><mdf:enabled>Y</mdf:enabled><mdf:description /></mdf:assignment><mdf:assignment><mdf:code>Sub_To_Reviewer_Clarify</mdf:code><mdf:to>Reviewer_Clarificaiton_Assignees</mdf:to><mdf:assignmenttext /><mdf:priority>2</mdf:priority><mdf:rulegroup>Sub_To_Reviewer_Provide_Clarification</mdf:rulegroup><mdf:duedate><mdf:sourcetype /><mdf:source /></mdf:duedate><mdf:enabled>Y</mdf:enabled><mdf:description /></mdf:assignment><mdf:assignment><mdf:code>Sub_To_Reviewer_Rejection_Clarification</mdf:code><mdf:to>Reviewer_Clarificaiton_Assignees</mdf:to><mdf:assignmenttext /><mdf:priority>2</mdf:priority><mdf:rulegroup>Sub_To_Reviewer_Rejection_Clarification</mdf:rulegroup><mdf:duedate><mdf:sourcetype /><mdf:source /></mdf:duedate><mdf:enabled>Y</mdf:enabled><mdf:description /></mdf:assignment><mdf:assignment><mdf:code>Sub_To_Reviewer_Clarify_Send_Review</mdf:code><mdf:to>Reviewer_Clarification_Review_Assignees</mdf:to><mdf:assignmenttext /><mdf:priority>2</mdf:priority><mdf:rulegroup>Sub_To_Reviewer_Clarify_Send_Review</mdf:rulegroup><mdf:duedate><mdf:sourcetype /><mdf:source /></mdf:duedate><mdf:enabled>Y</mdf:enabled><mdf:description /></mdf:assignment></mdf:assignments><mdf:emails><mdf:email><mdf:code>Submitter_to_Reviewer_Review_Email</mdf:code></mdf:email><mdf:email><mdf:code>Sub_To_Reviewer_Provide_Clarification_Email</mdf:code></mdf:email><mdf:email><mdf:code>Sub_To_Rev_Req_Withdraw_Clarificaiton_Email</mdf:code></mdf:email><mdf:email><mdf:code>Sub_To_Rev_Req_Rejection_Clarification_Email</mdf:code></mdf:email></mdf:emails><mdf:rulegroups><mdf:rulegroup><mdf:code>Submitter_To_Reviewer_Review</mdf:code><mdf:enabled>Y</mdf:enabled><mdf:description /><mdf:rules /></mdf:rulegroup><mdf:rulegroup><mdf:code>Sub_To_Reviewer_Withdraw_Clarification</mdf:code><mdf:enabled>Y</mdf:enabled><mdf:description /><mdf:rules /></mdf:rulegroup><mdf:rulegroup><mdf:code>Sub_To_Reviewer_Provide_Clarification</mdf:code><mdf:enabled>Y</mdf:enabled><mdf:description /><mdf:rules /></mdf:rulegroup><mdf:rulegroup>';
tmpSql2 := tmpSql2 || '<mdf:code>Sub_To_Reviewer_Rejection_Clarification</mdf:code><mdf:enabled>Y</mdf:enabled><mdf:description /><mdf:rules /></mdf:rulegroup><mdf:rulegroup><mdf:code>Sub_To_Reviewer_Clarify_Send_Review</mdf:code><mdf:enabled>Y</mdf:enabled><mdf:description /><mdf:rules /></mdf:rulegroup></mdf:rulegroups><mdf:cif_list /></mdf:transition><mdf:transition><mdf:code>Submitter_To_Final</mdf:code><mdf:description /><mdf:from>CreateEditRA</mdf:from><mdf:to>Final</mdf:to><mdf:enabled>Y</mdf:enabled><mdf:assignments /><mdf:emails><mdf:email><mdf:code>Sub_To_Final_Withdrawn_Email</mdf:code></mdf:email><mdf:email><mdf:code>Sub_To_Final_Rejected_Email</mdf:code></mdf:email></mdf:emails><mdf:rulegroups><mdf:rulegroup><mdf:code>Submitter_To_Final_Withdrawn</mdf:code><mdf:enabled>Y</mdf:enabled><mdf:description /><mdf:rules /></mdf:rulegroup><mdf:rulegroup><mdf:code>Submitter_To_Final_Rejected</mdf:code><mdf:enabled>Y</mdf:enabled><mdf:description /><mdf:rules /></mdf:rulegroup></mdf:rulegroups><mdf:cif_list /></mdf:transition><mdf:transition><mdf:code>Reviewer_To_Reviewer</mdf:code><mdf:description /><mdf:from>RAReviewer</mdf:from><mdf:to>RAReviewer</mdf:to><mdf:enabled>Y</mdf:enabled><mdf:assignments><mdf:assignment><mdf:code>Rev_To_Reviewer</mdf:code><mdf:to>RA_Reviewer_Assignees_ORM_TRM</mdf:to><mdf:assignmenttext /><mdf:priority>2</mdf:priority><mdf:rulegroup>Rev_To_Reviewer_ORM_TRM_Clearance</mdf:rulegroup><mdf:duedate><mdf:sourcetype /><mdf:source /></mdf:duedate><mdf:enabled>Y</mdf:enabled><mdf:description /></mdf:assignment></mdf:assignments><mdf:emails /><mdf:rulegroups><mdf:rulegroup><mdf:code>Rev_To_Reviewer_ORM_TRM_Clearance</mdf:code><mdf:enabled>Y</mdf:enabled><mdf:description /><mdf:rules /></mdf:rulegroup></mdf:rulegroups><mdf:cif_list /></mdf:transition><mdf:transition><mdf:code>Manager_To_Manager</mdf:code><mdf:description /><mdf:from>RAManager</mdf:from><mdf:to>RAManager</mdf:to><mdf:enabled>Y</mdf:enabled><mdf:assignments><mdf:assignment><mdf:code>Manager_To_Manager</mdf:code><mdf:to>RA_Manager_Assignees_ORM_TRM</mdf:to><mdf:assignmenttext /><mdf:priority>2</mdf:priority><mdf:rulegroup>Manager_To_manager_ORM_TRM_Clearance</mdf:rulegroup><mdf:duedate><mdf:sourcetype /><mdf:source /></mdf:duedate><mdf:enabled>Y</mdf:enabled><mdf:description /></mdf:assignment></mdf:assignments>';
tmpSql2 := tmpSql2 || '<mdf:emails /><mdf:rulegroups><mdf:rulegroup><mdf:code>Manager_To_manager_ORM_TRM_Clearance</mdf:code><mdf:enabled>Y</mdf:enabled><mdf:description /><mdf:rules /></mdf:rulegroup></mdf:rulegroups><mdf:cif_list /></mdf:transition><mdf:transition><mdf:code>Initial_Self_Flow_Submitter</mdf:code><mdf:description /><mdf:from>CreateEditRA</mdf:from><mdf:to>CreateEditRA</mdf:to><mdf:enabled>Y</mdf:enabled><mdf:assignments><mdf:assignment><mdf:code>Sub_To_Submitter_Initial_Renew</mdf:code><mdf:to>Submitter_Assignee</mdf:to><mdf:assignmenttext /><mdf:priority>2</mdf:priority><mdf:rulegroup>Sub_To_Sub_Self</mdf:rulegroup><mdf:duedate><mdf:sourcetype /><mdf:source /></mdf:duedate><mdf:enabled>Y</mdf:enabled><mdf:description /></mdf:assignment></mdf:assignments><mdf:emails><mdf:email><mdf:code>Submitter_Renewal_Email</mdf:code></mdf:email></mdf:emails><mdf:rulegroups><mdf:rulegroup><mdf:code>Sub_To_Sub_Self</mdf:code><mdf:enabled>Y</mdf:enabled><mdf:description /><mdf:rules /></mdf:rulegroup></mdf:rulegroups><mdf:cif_list /></mdf:transition><mdf:transition><mdf:code>Submitter_To_Manager</mdf:code><mdf:description /><mdf:from>CreateEditRA</mdf:from><mdf:to>RAManager</mdf:to><mdf:enabled>Y</mdf:enabled><mdf:assignments><mdf:assignment><mdf:code>Sub_To_mgr_Withdrawal_Clarification</mdf:code><mdf:to>Manager_Clarification_Assignees</mdf:to><mdf:assignmenttext /><mdf:priority>2</mdf:priority><mdf:rulegroup>Sub_To_Mgr_Withdraw_Clarification</mdf:rulegroup><mdf:duedate><mdf:sourcetype /><mdf:source /></mdf:duedate><mdf:enabled>Y</mdf:enabled><mdf:description /></mdf:assignment></mdf:assignments><mdf:emails><mdf:email><mdf:code>Sub_To_Mgr_Req_Withdraw_Clarification_Email</mdf:code></mdf:email></mdf:emails><mdf:rulegroups><mdf:rulegroup><mdf:code>Sub_To_Mgr_Withdraw_Clarification</mdf:code><mdf:enabled>Y</mdf:enabled><mdf:description /><mdf:rules /></mdf:rulegroup></mdf:rulegroups><mdf:cif_list /></mdf:transition><mdf:transition><mdf:code>Approver_To_Approver_Self</mdf:code><mdf:description /><mdf:from>RAApprover</mdf:from><mdf:to>RAApprover</mdf:to><mdf:enabled>Y</mdf:enabled><mdf:assignments><mdf:assignment><mdf:code>Approver_To_Approver_Self</mdf:code><mdf:to>RA_Approver_Sef_Clarification_Assignees</mdf:to><mdf:assignmenttext /><mdf:priority>2</mdf:priority><mdf:rulegroup>Approver_To_Approver_Self</mdf:rulegroup>';
tmpSql2 := tmpSql2 || '<mdf:duedate><mdf:sourcetype /><mdf:source /></mdf:duedate><mdf:enabled>Y</mdf:enabled><mdf:description /></mdf:assignment><mdf:assignment><mdf:code>Approver_To_Approver_Multi_Clarify_Send_Review</mdf:code><mdf:to>RA_Approver_Clarify_Review_Assignees</mdf:to><mdf:assignmenttext /><mdf:priority>2</mdf:priority><mdf:rulegroup>App_To_Approver_Multi_Clarify_Send_Review</mdf:rulegroup><mdf:duedate><mdf:sourcetype /><mdf:source /></mdf:duedate><mdf:enabled>Y</mdf:enabled><mdf:description /></mdf:assignment></mdf:assignments><mdf:emails /><mdf:rulegroups><mdf:rulegroup><mdf:code>Approver_To_Approver_Self</mdf:code><mdf:enabled>Y</mdf:enabled><mdf:description /><mdf:rules /></mdf:rulegroup><mdf:rulegroup><mdf:code>App_To_Approver_Multi_Clarify_Send_Review</mdf:code><mdf:enabled>Y</mdf:enabled><mdf:description /><mdf:rules /></mdf:rulegroup></mdf:rulegroups><mdf:cif_list /></mdf:transition><mdf:transition><mdf:code>Final_To_Final</mdf:code><mdf:description><![CDATA[<p>TO implement the requirement - Enabe editing the renew-by-date after approval - via link report</p><div></div><div></div>]]></mdf:description><mdf:from>Final</mdf:from><mdf:to>Final</mdf:to><mdf:enabled>Y</mdf:enabled><mdf:assignments /><mdf:emails /><mdf:rulegroups><mdf:rulegroup><mdf:code>Final_To_Final_Approved_Renew_Date</mdf:code><mdf:enabled>Y</mdf:enabled><mdf:description /><mdf:rules /></mdf:rulegroup></mdf:rulegroups><mdf:cif_list /></mdf:transition><mdf:transition><mdf:code>Final_To_Approver</mdf:code><mdf:description /><mdf:from>Final</mdf:from><mdf:to>RAApprover</mdf:to><mdf:enabled>Y</mdf:enabled><mdf:assignments><mdf:assignment><mdf:code>Final_To_Approver_Closure_Rev_Mgr</mdf:code><mdf:to>RA_Approver_Assignee</mdf:to><mdf:assignmenttext /><mdf:priority>2</mdf:priority><mdf:rulegroup>Final_To_Approver_Closure</mdf:rulegroup><mdf:duedate><mdf:sourcetype /><mdf:source /></mdf:duedate><mdf:enabled>Y</mdf:enabled><mdf:description /></mdf:assignment></mdf:assignments><mdf:emails><mdf:email><mdf:code>Final_To_Approver_Closure_Email</mdf:code></mdf:email></mdf:emails><mdf:rulegroups><mdf:rulegroup><mdf:code>Final_To_Approver_Closure</mdf:code><mdf:enabled>Y</mdf:enabled><mdf:description /><mdf:rules /></mdf:rulegroup></mdf:rulegroups><mdf:cif_list /></mdf:transition></mdf:transitions></mdf:flow>';
tmpClob := tmpSql1 || tmpSql2;
Insert into sray (blueprint_xml) values(tmpClob) ;
commit;
end;
I am getting the below error:
Error report -
ORA-06550: line 12, column 12:
PLS-00103: Encountered the symbol "=" when expecting one of the following:
constant exception <an identifier>
<a double-quoted delimited-identifier> table long double ref
char time timestamp interval date binary national character
nchar
The symbol "<an identifier>" was substituted for "=" to continue.
ORA-06550: line 13, column 11:
PLS-00103: Encountered the symbol "=" when expecting one of the following:
constant exception <an identifier>
<a double-quoted delimited-identifier> table long double ref
char time timestamp interval date binary national character
nchar
The symbol "<an identifier>" was substituted for "=" to continue.
ORA-06550: line 14, column 11:
PLS-00103: Encountered the symbol "=" when expecting one of the following:
constant exception <an identifier>
<a double-quoted delimited-identifier> table long double ref
char time timestamp interval date binary national character
nchar
The symbol "<an identifier>" was substituted for "=" to continue.
ORA-06550: line 15, column 11:
PLS-00103: Encountered the symbol "=" when expecting one of the following:
constant exception <an identifier>
<a double-quoted delimited-identifier> table long double ref
char time timestamp interval date binary national character
nchar
The symbol "<an identifier>" was substituted for "=" to continue.
ORA-06550: line 16, column 11:
PLS-00103: Encountered the symbol "=" when expecting one of the following:
constant exception <an identifier>
<a double-quoted delimited-identifier> table long double ref
char time timestamp interval date binary national character
nchar
The symbol "<an identifier>" was substituted for "=" to continue.
ORA-06550: line 17, column 11:
PLS-00103: Encountered the symbol "=" when expecting one of the following:
constant exception <an identifier>
<a double-quoted delimited-identifier> table long double ref
char time timestamp interval date binary national character
nchar
The symbol "<an identifier>"
06550. 00000 - "line %s, column %s:\n%s"
*Cause: Usually a PL/SQL compilation error.
*Action:ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER