Fixed issue
11165.Added seqno column to order extencion point procedures by seqno and procedure name.
--- a/src-db/database/model/functions/AD_EXTENSION_POINT_HANDLER.xml Fri Jul 29 16:51:04 2011 +0200
+++ b/src-db/database/model/functions/AD_EXTENSION_POINT_HANDLER.xml Mon Aug 01 10:48:28 2011 +0200
@@ -32,7 +32,8 @@
SELECT lower(PROCEDURENAME) AS procedurename
FROM ad_ep_procedures
WHERE ad_extension_points_id = p_extension_point_id
- AND isactive = 'Y') LOOP
+ AND isactive = 'Y'
+ ORDER BY coalesce(seqno, 9999), procedurename) LOOP
IF (AD_GET_RDBMS() = 'ORACLE') THEN
v_Sql := 'CALL ' || Cur_Procedures.procedurename || '('''||p_ep_instance_id||''')';
ELSE
--- a/src-db/database/model/tables/AD_EP_PROCEDURES.xml Fri Jul 29 16:51:04 2011 +0200
+++ b/src-db/database/model/tables/AD_EP_PROCEDURES.xml Mon Aug 01 10:48:28 2011 +0200
@@ -45,6 +45,10 @@
<default/>
<onCreateDefault/>
</column>
+ <column name="SEQNO" primaryKey="false" required="false" type="DECIMAL" size="10,0" autoIncrement="false">
+ <default/>
+ <onCreateDefault/>
+ </column>
<foreign-key foreignTable="AD_CLIENT" name="AD_CLIENT_ADEPPROCEDURES">
<reference local="AD_CLIENT_ID" foreign="AD_CLIENT_ID"/>
</foreign-key>
--- a/src-db/database/sourcedata/AD_COLUMN.xml Fri Jul 29 16:51:04 2011 +0200
+++ b/src-db/database/sourcedata/AD_COLUMN.xml Mon Aug 01 10:48:28 2011 +0200
@@ -258399,6 +258399,39 @@
<!--A908EA6CF218F9C9E040007F01011582--> <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
<!--A908EA6CF218F9C9E040007F01011582--></AD_COLUMN>
+<!--A922616DBC269336E040007F010007F3--><AD_COLUMN>
+<!--A922616DBC269336E040007F010007F3--> <AD_COLUMN_ID><![CDATA[A922616DBC269336E040007F010007F3]]></AD_COLUMN_ID>
+<!--A922616DBC269336E040007F010007F3--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--A922616DBC269336E040007F010007F3--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--A922616DBC269336E040007F010007F3--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--A922616DBC269336E040007F010007F3--> <NAME><![CDATA[Sequence Number]]></NAME>
+<!--A922616DBC269336E040007F010007F3--> <DESCRIPTION><![CDATA[The order of records in a specified document.]]></DESCRIPTION>
+<!--A922616DBC269336E040007F010007F3--> <HELP><![CDATA[The Sequence indicates the order of records]]></HELP>
+<!--A922616DBC269336E040007F010007F3--> <COLUMNNAME><![CDATA[SeqNo]]></COLUMNNAME>
+<!--A922616DBC269336E040007F010007F3--> <AD_TABLE_ID><![CDATA[D82A7D094F51425BB4475C223A572B2A]]></AD_TABLE_ID>
+<!--A922616DBC269336E040007F010007F3--> <AD_REFERENCE_ID><![CDATA[11]]></AD_REFERENCE_ID>
+<!--A922616DBC269336E040007F010007F3--> <FIELDLENGTH><![CDATA[12]]></FIELDLENGTH>
+<!--A922616DBC269336E040007F010007F3--> <ISKEY><![CDATA[N]]></ISKEY>
+<!--A922616DBC269336E040007F010007F3--> <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--A922616DBC269336E040007F010007F3--> <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--A922616DBC269336E040007F010007F3--> <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--A922616DBC269336E040007F010007F3--> <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--A922616DBC269336E040007F010007F3--> <SEQNO><![CDATA[120]]></SEQNO>
+<!--A922616DBC269336E040007F010007F3--> <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--A922616DBC269336E040007F010007F3--> <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--A922616DBC269336E040007F010007F3--> <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--A922616DBC269336E040007F010007F3--> <AD_ELEMENT_ID><![CDATA[566]]></AD_ELEMENT_ID>
+<!--A922616DBC269336E040007F010007F3--> <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--A922616DBC269336E040007F010007F3--> <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--A922616DBC269336E040007F010007F3--> <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--A922616DBC269336E040007F010007F3--> <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--A922616DBC269336E040007F010007F3--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--A922616DBC269336E040007F010007F3--> <POSITION><![CDATA[12]]></POSITION>
+<!--A922616DBC269336E040007F010007F3--> <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--A922616DBC269336E040007F010007F3--> <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--A922616DBC269336E040007F010007F3--> <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--A922616DBC269336E040007F010007F3--></AD_COLUMN>
+
<!--A9AD9098307E46ECBB9CC712DA6E0302--><AD_COLUMN>
<!--A9AD9098307E46ECBB9CC712DA6E0302--> <AD_COLUMN_ID><![CDATA[A9AD9098307E46ECBB9CC712DA6E0302]]></AD_COLUMN_ID>
<!--A9AD9098307E46ECBB9CC712DA6E0302--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/src-db/database/sourcedata/AD_FIELD.xml Fri Jul 29 16:51:04 2011 +0200
+++ b/src-db/database/sourcedata/AD_FIELD.xml Mon Aug 01 10:48:28 2011 +0200
@@ -177151,6 +177151,7 @@
<!--6F387D3737F03635E040007F01002312--> <DISPLAYLENGTH><![CDATA[60]]></DISPLAYLENGTH>
<!--6F387D3737F03635E040007F01002312--> <ISREADONLY><![CDATA[N]]></ISREADONLY>
<!--6F387D3737F03635E040007F01002312--> <SEQNO><![CDATA[30]]></SEQNO>
+<!--6F387D3737F03635E040007F01002312--> <SORTNO><![CDATA[2]]></SORTNO>
<!--6F387D3737F03635E040007F01002312--> <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
<!--6F387D3737F03635E040007F01002312--> <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
<!--6F387D3737F03635E040007F01002312--> <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
@@ -189488,6 +189489,33 @@
<!--A908E57D081C6863E040007F01011588--> <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
<!--A908E57D081C6863E040007F01011588--></AD_FIELD>
+<!--A922616DBC299336E040007F010007F3--><AD_FIELD>
+<!--A922616DBC299336E040007F010007F3--> <AD_FIELD_ID><![CDATA[A922616DBC299336E040007F010007F3]]></AD_FIELD_ID>
+<!--A922616DBC299336E040007F010007F3--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--A922616DBC299336E040007F010007F3--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--A922616DBC299336E040007F010007F3--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--A922616DBC299336E040007F010007F3--> <NAME><![CDATA[Sequence Number]]></NAME>
+<!--A922616DBC299336E040007F010007F3--> <DESCRIPTION><![CDATA[The order of records in a specified document.]]></DESCRIPTION>
+<!--A922616DBC299336E040007F010007F3--> <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--A922616DBC299336E040007F010007F3--> <AD_TAB_ID><![CDATA[D88DE0446AFD4A55BF850C5B75CD7974]]></AD_TAB_ID>
+<!--A922616DBC299336E040007F010007F3--> <AD_COLUMN_ID><![CDATA[A922616DBC269336E040007F010007F3]]></AD_COLUMN_ID>
+<!--A922616DBC299336E040007F010007F3--> <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
+<!--A922616DBC299336E040007F010007F3--> <DISPLAYLENGTH><![CDATA[12]]></DISPLAYLENGTH>
+<!--A922616DBC299336E040007F010007F3--> <ISREADONLY><![CDATA[N]]></ISREADONLY>
+<!--A922616DBC299336E040007F010007F3--> <SEQNO><![CDATA[25]]></SEQNO>
+<!--A922616DBC299336E040007F010007F3--> <SORTNO><![CDATA[1]]></SORTNO>
+<!--A922616DBC299336E040007F010007F3--> <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
+<!--A922616DBC299336E040007F010007F3--> <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
+<!--A922616DBC299336E040007F010007F3--> <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--A922616DBC299336E040007F010007F3--> <SHOWINRELATION><![CDATA[Y]]></SHOWINRELATION>
+<!--A922616DBC299336E040007F010007F3--> <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
+<!--A922616DBC299336E040007F010007F3--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--A922616DBC299336E040007F010007F3--> <GRID_SEQNO><![CDATA[25]]></GRID_SEQNO>
+<!--A922616DBC299336E040007F010007F3--> <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
+<!--A922616DBC299336E040007F010007F3--> <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
+<!--A922616DBC299336E040007F010007F3--> <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
+<!--A922616DBC299336E040007F010007F3--></AD_FIELD>
+
<!--AA66A55E4B9340D9A67FA5E47560B758--><AD_FIELD>
<!--AA66A55E4B9340D9A67FA5E47560B758--> <AD_FIELD_ID><![CDATA[AA66A55E4B9340D9A67FA5E47560B758]]></AD_FIELD_ID>
<!--AA66A55E4B9340D9A67FA5E47560B758--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>