Compare text

Find the difference between two text files
Real-time diff
Unified diff
Collapse lines
Highlight change
Syntax highlighting
Tools

Untitled diff

Created Diff never expires
2 removals
294 lines
1 addition
293 lines
<?xml version="1.0" encoding="UTF-8"?>
<?xml version="1.0" encoding="UTF-8"?>
<DOCUMENTS>
<DOCUMENTS>
<!--
<!--
Copyright (c) 2009 by Teradata Corporation.
Copyright (c) 2009 by Teradata Corporation.
All Rights Reserved.
All Rights Reserved.
Teradata CONFIDENTIAL AND TRADE SECRET
Teradata CONFIDENTIAL AND TRADE SECRET
-->
-->
<DEFINE_METHOD Name="sandboxSaveHistory">
<DEFINE_METHOD Name="sandboxSaveHistory">
<API_DOC>
<API_DOC>
<INPUT>
<INPUT>
<REQUEST Name="sandboxSaveHistory">
<REQUEST Name="sandboxSaveHistory">
<System_Identifier Value="2"/>
<System_Identifier Value="2"/>
<Domain_Code Value="MTRL"/>
<Domain_Code Value="MTRL"/>
</REQUEST>
</REQUEST>
</INPUT>
</INPUT>
<OUTPUT>
<OUTPUT>
<RESPONSES Status="Success">
<RESPONSES Status="Success">
<RESPONSE Status="Success">
<RESPONSE Status="Success">
</RESPONSE>
</RESPONSE>
</RESPONSES>
</RESPONSES>
</OUTPUT>
</OUTPUT>
</API_DOC>
</API_DOC>
<RULE>
<RULE>
<ACTION>
<ACTION>
<EXEC_PROC Name="SANDBOX_SAVE_HISTORY">
<EXEC_PROC Name="SANDBOX_SAVE_HISTORY">
<System_Identifier Type="IN" Value="{$thisParam/System_Identifier/@Value}" DataType="int"/>
<System_Identifier Type="IN" Value="{$thisParam/System_Identifier/@Value}" DataType="int"/>
<Domain_Code Type="IN" Value="{$thisParam/Domain_Code/@Value}" DataType="string"/>
<Domain_Code Type="IN" Value="{$thisParam/Domain_Code/@Value}" DataType="string"/>
</EXEC_PROC>
</EXEC_PROC>
</ACTION>
</ACTION>
</RULE>
</RULE>
</DEFINE_METHOD>
</DEFINE_METHOD>
<!-- ********************************************************************** -->
<!-- ********************************************************************** -->
<DEFINE_METHOD Name="matchingAddHistory">
<DEFINE_METHOD Name="matchingAddHistory">
<API_DOC>
<API_DOC>
<INPUT>
<INPUT>
<REQUEST Name="matchingAddHistory">
<REQUEST Name="matchingAddHistory">
<Profile_Id Value="1"/>
<Profile_Id Value="1"/>
</REQUEST>
</REQUEST>
</INPUT>
</INPUT>
<OUTPUT>
<OUTPUT>
<RESPONSES Status="Success">
<RESPONSES Status="Success">
<RESPONSE Status="Success">
<RESPONSE Status="Success">
</RESPONSE>
</RESPONSE>
</RESPONSES>
</RESPONSES>
</OUTPUT>
</OUTPUT>
</API_DOC>
</API_DOC>
<RULE>
<RULE>
<ACTION>
<ACTION>
<!--
<!--
<EXECUTE_SQL_QUERY Value="SELECT COALESCE(MAX(RUN_ID),0)+1 AS RUN_ID FROM SYS_FM_RUN_HISTORY WHERE PROFILE_ID={$thisParam/Profile_Id/@Value};" AssignToVar="result"/>
<EXECUTE_SQL_QUERY Value="SELECT COALESCE(MAX(RUN_ID),0)+1 AS RUN_ID FROM SYS_FM_RUN_HISTORY WHERE PROFILE_ID={$thisParam/Profile_Id/@Value};" AssignToVar="result"/>
<REQUEST Name="addHistoryDetails_ExternalProfile" ServiceName="UI_WORKFLOW">
<REQUEST Name="addHistoryDetails_ExternalProfile" ServiceName="UI_WORKFLOW">
<Run_Id Value="{$result/SQL_RESULT/RUN_ID/@Value}"/>
<Run_Id Value="{$result/SQL_RESULT/RUN_ID/@Value}"/>
<Profile_Id Value="{$thisParam/Profile_Id/@Value}"/>
<Profile_Id Value="{$thisParam/Profile_Id/@Value}"/>
<Begin_Run_Time Value="{date()}"/>
<Begin_Run_Time Value="{date()}"/>
<End_Run_Time Value="{date()}"/>
<End_Run_Time Value="{date()}"/>
<Elapsed_Run_Time Value="0"/>
<Elapsed_Run_Time Value="0"/>
<Status Value="Run Complete"/>
<Status Value="Run Complete"/>
<Source_Rows Value="0"/>
<Source_Rows Value="0"/>
<Master_Rows Value="0"/>
<Master_Rows Value="0"/>
<ExecutedBy Value="Data_Steward"/>
<ExecutedBy Value="Data_Steward"/>
<NO_OF_MATCHED_ROWS Value="0"/>
<NO_OF_MATCHED_ROWS Value="0"/>
<NO_OF_POTENTIAL_MATCH_ROWS Value="0"/>
<NO_OF_POTENTIAL_MATCH_ROWS Value="0"/>
<NO_OF_NEW_ROWS Value="0"/>
<NO_OF_NEW_ROWS Value="0"/>
</REQUEST>
</REQUEST>
-->
-->
<EXEC_PROC Name="MATCHING_ADD_HISTORY">
<EXEC_PROC Name="MATCHING_ADD_HISTORY">
<Profile_Id Type="IN" Value="{$thisParam/Profile_Id/@Value}" DataType="int"/>
<Profile_Id Type="IN" Value="{$thisParam/Profile_Id/@Value}" DataType="int"/>
</EXEC_PROC>
</EXEC_PROC>
</ACTION>
</ACTION>
</RULE>
</RULE>
</DEFINE_METHOD>
</DEFINE_METHOD>
<!-- ********************************************************************** -->
<!-- ********************************************************************** -->
<DEFINE_METHOD Name="lookupResolveValues">
<DEFINE_METHOD Name="lookupResolveValues">
<API_DOC>
<API_DOC>
<INPUT>
<INPUT>
<REQUEST Name="lookupResolveValues">
<REQUEST Name="lookupResolveValues">
<System_Identifier Value="2"/>
<System_Identifier Value="2"/>
<Domain_Code Value="MTRL"/>
<Domain_Code Value="MTRL"/>
</REQUEST>
</REQUEST>
</INPUT>
</INPUT>
<OUTPUT>
<OUTPUT>
<RESPONSES Status="Success">
<RESPONSES Status="Success">
<RESPONSE Status="Success">
<RESPONSE Status="Success">
</RESPONSE>
</RESPONSE>
</RESPONSES>
</RESPONSES>
</OUTPUT>
</OUTPUT>
</API_DOC>
</API_DOC>
<RULE>
<RULE>
<ACTION>
<ACTION>
<EXEC_PROC Name="LOOKUP_RESOLVE_VALUES">
<EXEC_PROC Name="LOOKUP_RESOLVE_VALUES">
<System_Identifier Type="IN" Value="{$thisParam/System_Identifier/@Value}" DataType="int"/>
<System_Identifier Type="IN" Value="{$thisParam/System_Identifier/@Value}" DataType="int"/>
<Domain_Code Type="IN" Value="{$thisParam/Domain_Code/@Value}" DataType="string"/>
<Domain_Code Type="IN" Value="{$thisParam/Domain_Code/@Value}" DataType="string"/>
</EXEC_PROC>
</EXEC_PROC>
</ACTION>
</ACTION>
</RULE>
</RULE>
</DEFINE_METHOD>
</DEFINE_METHOD>
<!-- ********************************************************************** -->
<!-- ********************************************************************** -->
<DEFINE_METHOD Name="imageUpload">
<DEFINE_METHOD Name="imageUpload">
<API_DOC>
<API_DOC>
<INPUT>
<INPUT>
<REQUEST Name="imageUpload">
<REQUEST Name="imageUpload">
<System_Identifier Value="2"/>
<System_Identifier Value="2"/>
<Domain_Code Value="MTRL"/>
<Domain_Code Value="MTRL"/>
</REQUEST>
</REQUEST>
</INPUT>
</INPUT>
<OUTPUT>
<OUTPUT>
<RESPONSES Status="Success">
<RESPONSES Status="Success">
<RESPONSE Status="Success">
<RESPONSE Status="Success">
</RESPONSE>
</RESPONSE>
</RESPONSES>
</RESPONSES>
</OUTPUT>
</OUTPUT>
</API_DOC>
</API_DOC>
<RULE>
<RULE>
<ACTION>
<ACTION>
<EXEC_PROC Name="IMAGE_UPLOAD">
<EXEC_PROC Name="IMAGE_UPLOAD">
<System_Identifier Type="IN" Value="{$thisParam/System_Identifier/@Value}" DataType="int"/>
<System_Identifier Type="IN" Value="{$thisParam/System_Identifier/@Value}" DataType="int"/>
<Domain_Code Type="IN" Value="{$thisParam/Domain_Code/@Value}" DataType="string"/>
<Domain_Code Type="IN" Value="{$thisParam/Domain_Code/@Value}" DataType="string"/>
</EXEC_PROC>
</EXEC_PROC>
</ACTION>
</ACTION>
</RULE>
</RULE>
</DEFINE_METHOD>
</DEFINE_METHOD>
<!-- ********************************************************************** -->
<!-- ********************************************************************** -->
<DEFINE_METHOD Name="execSurvivorships">
<DEFINE_METHOD Name="execSurvivorships">
<API_DOC>
<API_DOC>
<INPUT>
<INPUT>
<REQUEST Name="execSurvivorships">
<REQUEST Name="execSurvivorships">
<System_Identifier Value="2"/>
<System_Identifier Value="2"/>
<Domain_Code Value="MTRL"/>
<Domain_Code Value="MTRL"/>
</REQUEST>
</REQUEST>
</INPUT>
</INPUT>
<OUTPUT>
<OUTPUT>
<RESPONSES Status="Success">
<RESPONSES Status="Success">
<RESPONSE Status="Success">
<RESPONSE Status="Success">
</RESPONSE>
</RESPONSE>
</RESPONSES>
</RESPONSES>
</OUTPUT>
</OUTPUT>
</API_DOC>
</API_DOC>
<RULE>
<RULE>
<ACTION>
<ACTION>
<EXECUTE_SQL_QUERY Value="SELECT MATCH_PROFILE_ID, SURV_PROFILE_ID FROM SURV_ORCH WHERE SYS_ID={$thisParam/System_Identifier/@Value} AND COALESCE(MSTR_DATA_DMN_CDV,'')='{$thisParam/Domain_Code/@Value}' ORDER BY EXECUTION_SEQ;" AssignToVar="result"/>
<EXECUTE_SQL_QUERY Value="SELECT MATCH_PROFILE_ID, SURV_PROFILE_ID FROM SURV_ORCH WHERE SYS_ID={$thisParam/System_Identifier/@Value} AND COALESCE(MSTR_DATA_DMN_CDV,'')='{$thisParam/Domain_Code/@Value}' ORDER BY EXECUTION_SEQ;" AssignToVar="result"/>
<FOR_EACH SelectList="$result/SQL_RESULT" CurrentElement="element">
<FOR_EACH SelectList="$result/SQL_RESULT" CurrentElement="element">
<SET Var="matchProfileId" FromValue="{$element/MATCH_PROFILE_ID/@Value}"/>
<SET Var="matchProfileId" FromValue="{$element/MATCH_PROFILE_ID/@Value}"/>
<SET Var="survProfileId" FromValue="{$element/SURV_PROFILE_ID/@Value}"/>
<SET Var="survProfileId" FromValue="{$element/SURV_PROFILE_ID/@Value}"/>
<REQUEST Name="matchingAddHistory" ServiceName="BCM_MASTER" AssignToVar="result">
<REQUEST Name="matchingAddHistory" ServiceName="BCM_MASTER" AssignToVar="result">
<Profile_Id Value="{$matchProfileId}"/>
<Profile_Id Value="{$matchProfileId}"/>
</REQUEST>
</REQUEST>
<!-- 3201
<!-- 3201
<REQUEST Name="execSurvivorhsipCreate" ServiceName="BCM_MASTER" AssignToVar="result">
<REQUEST Name="execSurvivorhsipCreate" ServiceName="BCM_MASTER" AssignToVar="result">
<SURV_PROFILE_ID Value="{$survProfileId}"/>
<SURV_PROFILE_ID Value="{$survProfileId}"/>
<MATCH_PROFILE_ID Value="{$matchProfileId}"/>
<MATCH_PROFILE_ID Value="{$matchProfileId}"/>
<SURV_EXEC_CONDTION Value=""/>
<SURV_EXEC_CONDTION Value=""/>
<USER_NAME Value="Data_Steward"/>
<USER_NAME Value="Data_Steward"/>
</REQUEST>
</REQUEST>
<REQUEST Name="execSurvivorhsipMerge" ServiceName="BCM_MASTER" AssignToVar="result">
<REQUEST Name="execSurvivorhsipMerge" ServiceName="BCM_MASTER" AssignToVar="result">
<SURV_PROFILE_ID Value="{$survProfileId}"/>
<SURV_PROFILE_ID Value="{$survProfileId}"/>
<MATCH_PROFILE_ID Value="{$matchProfileId}"/>
<MATCH_PROFILE_ID Value="{$matchProfileId}"/>
<SURV_EXEC_CONDTION Value=""/>
<SURV_EXEC_CONDTION Value=""/>
<USER_NAME Value="Data_Steward"/>
<USER_NAME Value="Data_Steward"/>
</REQUEST>
</REQUEST>
-->
-->
<!-- 321 -->
<!-- 321 -->
<REQUEST Name="executeSurvivorship" ServiceName="BCM_MASTER" AssignToVar="result">
<REQUEST Name="executeSurvivorship" ServiceName="BCM_MASTER" AssignToVar="result">
<SURV_PROFILE_ID Value="{$survProfileId}"/>
<SURV_PROFILE_ID Value="{$survProfileId}"/>
<MATCH_PROFILE_ID Value="{$matchProfileId}"/>
<MATCH_PROFILE_ID Value="{$matchProfileId}"/>
<ACTION_TYPE Value="ALL"/>
<ACTION_TYPE Value="ALL"/>
<SURV_EXEC_CONDTION Value=""/>
<SURV_EXEC_CONDTION Value=""/>
<USER_NAME Value="Data Steward"/>
<USER_NAME Value="Data Steward"/>
</REQUEST>
</REQUEST>
</FOR_EACH>
</FOR_EACH>
</ACTION>
</ACTION>
</RULE>
</RULE>
</DEFINE_METHOD>
</DEFINE_METHOD>
<!-- ********************************************************************** -->
<!-- ********************************************************************** -->
<DEFINE_METHOD Name="postUpdateStatus">
<DEFINE_METHOD Name="postUpdateStatus">
<API_DOC>
<API_DOC>
<INPUT>
<INPUT>
<REQUEST Name="postUpdateStatus">
<REQUEST Name="postUpdateStatus">
<System_Identifier Value="2"/>
<System_Identifier Value="2"/>
<Domain_Code Value="MTRL"/>
<Domain_Code Value="MTRL"/>
</REQUEST>
</REQUEST>
</INPUT>
</INPUT>
<OUTPUT>
<OUTPUT>
<RESPONSES Status="Success">
<RESPONSES Status="Success">
<RESPONSE Status="Success">
<RESPONSE Status="Success">
</RESPONSE>
</RESPONSE>
</RESPONSES>
</RESPONSES>
</OUTPUT>
</OUTPUT>
</API_DOC>
</API_DOC>
<RULE>
<RULE>
<ACTION>
<ACTION>
<EXEC_PROC Name="POST_UPDATE_STATUS">
<EXEC_PROC Name="POST_UPDATE_STATUS">
<System_Identifier Type="IN" Value="{$thisParam/System_Identifier/@Value}" DataType="int"/>
<System_Identifier Type="IN" Value="{$thisParam/System_Identifier/@Value}" DataType="int"/>
<Domain_Code Type="IN" Value="{$thisParam/Domain_Code/@Value}" DataType="string"/>
<Domain_Code Type="IN" Value="{$thisParam/Domain_Code/@Value}" DataType="string"/>
</EXEC_PROC>
</EXEC_PROC>
</ACTION>
</ACTION>
</RULE>
</RULE>
</DEFINE_METHOD>
</DEFINE_METHOD>
<!-- ********************************************************************** -->
<!-- ********************************************************************** -->
<DEFINE_METHOD Name="postUpdateAuthorization">
<DEFINE_METHOD Name="postUpdateAuthorization">
<API_DOC>
<API_DOC>
<INPUT>
<INPUT>
<REQUEST Name="postUpdateAuthorization">
<REQUEST Name="postUpdateAuthorization">
<System_Identifier Value="2"/>
<System_Identifier Value="2"/>
<Domain_Code Value="MTRL"/>
<Domain_Code Value="MTRL"/>
</REQUEST>
</REQUEST>
</INPUT>
</INPUT>
<OUTPUT>
<OUTPUT>
<RESPONSES Status="Success">
<RESPONSES Status="Success">
<RESPONSE Status="Success">
<RESPONSE Status="Success">
</RESPONSE>
</RESPONSE>
</RESPONSES>
</RESPONSES>
</OUTPUT>
</OUTPUT>
</API_DOC>
</API_DOC>
<RULE>
<RULE>
<ACTION>
<ACTION>
<EXEC_PROC Name="POST_UPDATE_AUTHORIZATION">
<EXEC_PROC Name="POST_UPDATE_AUTHORIZATION">
<System_Identifier Type="IN" Value="{$thisParam/System_Identifier/@Value}" DataType="int"/>
<System_Identifier Type="IN" Value="{$thisParam/System_Identifier/@Value}" DataType="int"/>
<Domain_Code Type="IN" Value="{$thisParam/Domain_Code/@Value}" DataType="string"/>
<Domain_Code Type="IN" Value="{$thisParam/Domain_Code/@Value}" DataType="string"/>
</EXEC_PROC>
</EXEC_PROC>
</ACTION>
</ACTION>
</RULE>
</RULE>
</DEFINE_METHOD>
</DEFINE_METHOD>
<!-- ********************************************************************** -->
<!-- ********************************************************************** -->
<DEFINE_METHOD Name="processSurvivorshipOrchestration">
<DEFINE_METHOD Name="processSurvivorshipOrchestration">
<API_DOC>
<API_DOC>
<INPUT>
<INPUT>
<REQUEST Name="processSurvivorshipOrchestration">
<REQUEST Name="processSurvivorshipOrchestration">
<System_Identifier Value="2"/>
<System_Identifier Value="2"/>
<Domain_Code Value="MTRL"/>
<Domain_Code Value="MTRL"/>
</REQUEST>
</REQUEST>
</INPUT>
</INPUT>
<OUTPUT>
<OUTPUT>
<RESPONSES Status="Success">
<RESPONSES Status="Success">
<RESPONSE Status="Success">
<RESPONSE Status="Success">
</RESPONSE>
</RESPONSE>
</RESPONSES>
</RESPONSES>
</OUTPUT>
</OUTPUT>
</API_DOC>
</API_DOC>
<RULE>
<RULE>
<ACTION>
<ACTION>
<DO_TRANSACTION>
<DO_TRANSACTION>
<REQUEST Name="lookupResolveValues" ServiceName="BCM_MASTER" AssignToVar="result">
<REQUEST Name="lookupResolveValues" ServiceName="BCM_MASTER" AssignToVar="result">
<System_Identifier Value="{$thisParam/System_Identifier/@Value}"/>
<System_Identifier Value="{$thisParam/System_Identifier/@Value}"/>
<Domain_Code Value="{$thisParam/Domain_Code/@Value}"/>
<Domain_Code Value="{$thisParam/Domain_Code/@Value}"/>
</REQUEST>
</REQUEST>
<REQUEST Name="imageUpload" ServiceName="BCM_MASTER" AssignToVar="result">
<REQUEST Name="imageUpload" ServiceName="BCM_MASTER" AssignToVar="result">
<System_Identifier Value="{$thisParam/System_Identifier/@Value}"/>
<System_Identifier Value="{$thisParam/System_Identifier/@Value}"/>
<Domain_Code Value="{$thisParam/Domain_Code/@Value}"/>
<Domain_Code Value="{$thisParam/Domain_Code/@Value}"/>
</REQUEST>
</REQUEST>
<REQUEST Name="execSurvivorships" ServiceName="BCM_MASTER" AssignToVar="result">
<REQUEST Name="execSurvivorships" ServiceName="BCM_MASTER" AssignToVar="result">
<System_Identifier Value="{$thisParam/System_Identifier/@Value}"/>
<System_Identifier Value="{$thisParam/System_Identifier/@Value}"/>
<Domain_Code Value="{$thisParam/Domain_Code/@Value}"/>
<Domain_Code Value="{$thisParam/Domain_Code/@Value}"/>
</REQUEST>
</REQUEST>
</DO_TRANSACTION>
</DO_TRANSACTION>
</ACTION>
</ACTION>
</RULE>
</RULE>
</DEFINE_METHOD>
</DEFINE_METHOD>
<!-- ********************************************************************** -->
<!-- ********************************************************************** -->
<DEFINE_METHOD Name="postSurvivorshipOrchestration">
<DEFINE_METHOD Name="postSurvivorshipOrchestration">
<API_DOC>
<API_DOC>
<INPUT>
<INPUT>
<REQUEST Name="postSurvivorshipOrchestration">
<REQUEST Name="postSurvivorshipOrchestration">
<System_Identifier Value="2"/>
<System_Identifier Value="2"/>
<Domain_Code Value="MTRL"/>
<Domain_Code Value="MTRL"/>
</REQUEST>
</REQUEST>
</INPUT>
</INPUT>
<OUTPUT>
<OUTPUT>
<RESPONSES Status="Success">
<RESPONSES Status="Success">
<RESPONSE Status="Success">
<RESPONSE Status="Success">
</RESPONSE>
</RESPONSE>
</RESPONSES>
</RESPONSES>
</OUTPUT>
</OUTPUT>
</API_DOC>
</API_DOC>
<RULE>
<RULE>
<ACTION>
<ACTION>
<DO_TRANSACTION>
<DO_TRANSACTION>
<REQUEST Name="postUpdateAuthorization" ServiceName="BCM_MASTER" AssignToVar="result">
<REQUEST Name="postUpdateAuthorization" ServiceName="BCM_MASTER" AssignToVar="result">
<System_Identifier Value="{$thisParam/System_Identifier/@Value}"/>
<System_Identifier Value="{$thisParam/System_Identifier/@Value}"/>
<Domain_Code Value="{$thisParam/Domain_Code/@Value}"/>
<Domain_Code Value="{$thisParam/Domain_Code/@Value}"/>
</REQUEST>
</REQUEST>
<REQUEST Name="postUpdateStatus" ServiceName="BCM_MASTER" AssignToVar="result">
<REQUEST Name="postUpdateStatus" ServiceName="BCM_MASTER" AssignToVar="result">
<System_Identifier Value="{$thisParam/System_Identifier/@Value}"/>
<System_Identifier Value="{$thisParam/System_Identifier/@Value}"/>
<Domain_Code Value="{$thisParam/Domain_Code/@Value}"/>
<Domain_Code Value="{$thisParam/Domain_Code/@Value}"/>
</REQUEST>
</REQUEST>
<REQUEST Name="sandboxSaveHistory" ServiceName="BCM_MASTER" AssignToVar="result">
<REQUEST Name="sandboxSaveHistory" ServiceName="BCM_MASTER" AssignToVar="result">
<System_Identifier Value="{$thisParam/System_Identifier/@Value}"/>
<System_Identifier Value="{$thisParam/System_Identifier/@Value}"/>
<Domain_Code Value="{$thisParam/Domain_Code/@Value}"/>
<Domain_Code Value="{$thisParam/Domain_Code/@Value}"/>
</REQUEST>
</REQUEST>
</DO_TRANSACTION>
</DO_TRANSACTION>
</ACTION>
</ACTION>
</RULE>
</RULE>
</DEFINE_METHOD>
</DEFINE_METHOD>
</DOCUMENTS>
</DOCUMENTS>

Saved diffs