bknox edison_aces Thu, 2 Feb 2012 15:51:11 -0600 Which Funds and Orgns Can a User See? Banner Fund/Orgn Security Thu, 16 Feb 2012 10:41:48 -0600 Mon, 11 Apr 2011 16:25:28 -0600 Mon, 11 Apr 2011 16:25:22 -0600 bknox <datablock> <information> <description>Argos Object File</description> <development>Argos Builder Version 3.8.2 Build 427</development> <company>Evisions, Inc.</company> <date>Thu, 16 Feb 2012 10:41:48 -0600</date> </information> <query> <ADOOptions/> </query> <parameter_queries/> <parameters> <control Type="Label"> <Align>None</Align> <Alignment>Left</Alignment> <AutoSize>Yes</AutoSize> <DataAware>No</DataAware> <Height>13</Height> <Layout>Top</Layout> <Left>0</Left> <ParentFont>Yes</ParentFont> <Text>Banner Security will allow the named user to view these ORGNs:</Text> <Top>160</Top> <VariableName>Label1</VariableName> <Width>307</Width> <WordWrap>No</WordWrap> </control> <control Type="Label"> <Align>None</Align> <Alignment>Left</Alignment> <AutoSize>Yes</AutoSize> <DataAware>No</DataAware> <Height>13</Height> <Layout>Top</Layout> <Left>0</Left> <ParentFont>Yes</ParentFont> <Text>Enter the Banner Username, then press Enter. </Text> <Top>8</Top> <VariableName>Label2</VariableName> <Width>230</Width> <WordWrap>No</WordWrap> </control> <control Type="Label"> <Align>None</Align> <Alignment>Left</Alignment> <AutoSize>Yes</AutoSize> <DataAware>No</DataAware> <Height>13</Height> <Layout>Top</Layout> <Left>0</Left> <ParentFont>Yes</ParentFont> <Text>And these Funds:</Text> <Top>312</Top> <VariableName>Label3</VariableName> <Width>85</Width> <WordWrap>No</WordWrap> </control> <control Type="MultiColumn"> <Align>None</Align> <AutoSelect>No</AutoSelect> <AutoSizeColumn>0</AutoSizeColumn> <Choices>&lt;Data&gt;&lt;Lines&gt;SELECT NAME, FTVFUND_FUND_CODE FUND, FTVFUND_TITLE FROM (SELECT FTVFUND_FUND_CODE, FTVFUND_TITLE FROM FTVFUND -- FUND IN-LINE VIEW WHERE FTVFUND_EFF_DATE &amp;lt;= SYSDATE AND (FTVFUND_NCHG_DATE &amp;gt; SYSDATE OR FTVFUND_NCHG_DATE IS NULL) AND (FTVFUND_TERM_DATE &amp;gt; SYSDATE OR FTVFUND_TERM_DATE IS NULL) -- AND FTVFUND_STATUS_IND = 'A' ), GOBEACC, (SELECT SPRIDEN_PIDM PIDM, -- NAMES IN-LINE VIEW SUBSTR(DECODE(SPBPERS_NAME_PREFIX,'MR',NULL,'MR.',NULL,'MISS',NULL,'MRS',NULL,'MRS.',NULL,'MS',NULL,'MS.',NULL,NULL,NULL, SPBPERS_NAME_PREFIX ||' ') ||RTRIM(DECODE(NVL(SPBPERS_PREF_FIRST_NAME,'X'),'X',SPRIDEN_FIRST_NAME,SPBPERS_PREF_FIRST_NAME)) ||' ' ||RTRIM(SPRIDEN_LAST_NAME),1,25) NAME FROM SPRIDEN, SPBPERS WHERE SPRIDEN_PIDM = SPBPERS_PIDM (+) AND SPRIDEN_CHANGE_IND IS NULL AND SPRIDEN_ENTITY_IND = 'P' ), FOBSYSC WHERE --F_FUND_ORG_SECURITY_FNC('Z',FTVFUND_FUND_CODE,'','','',UPPER(:SEARCH_CRITERIA))='Y' DECODE(FOBSYSC_FUND_ORG_SECURITY_IND,'Y', F_FUND_ORG_SECURITY_FNC('Z',FTVFUND_FUND_CODE,'','','',UPPER(:SEARCH_CRITERIA)),'Y')='Y' AND FOBSYSC_EFF_DATE &amp;lt;= SYSDATE AND (FOBSYSC_NCHG_DATE IS NULL OR FOBSYSC_NCHG_DATE &amp;gt; SYSDATE) AND FOBSYSC_STATUS_IND = 'A' AND PIDM = GOBEACC_PIDM AND GOBEACC_USERNAME = UPPER(:SEARCH_CRITERIA) ORDER BY 2&lt;/Lines&gt;&lt;Query&gt;&lt;ADOOptions/&gt;&lt;/Query&gt;&lt;/Data&gt;</Choices> <ChooseField>NAME</ChooseField> <ColumnAligns>Left,Left,Left</ColumnAligns> <ColumnFormats>,,</ColumnFormats> <ColumnLines>No</ColumnLines> <Columns>"NAME,,Name,WideString,0","FUND,,,WideString,0","FTVFUND_TITLE,,""FUND Title"",WideString,0"</Columns> <ColumnVisible>No,Yes,Yes</ColumnVisible> <ColumnWidths>80,60,300</ColumnWidths> <Height>155</Height> <Left>0</Left> <MultiSelect>No</MultiSelect> <ParentFont>Yes</ParentFont> <Required>Yes</Required> <RowLines>No</RowLines> <ShowItemCount>No</ShowItemCount> <SqlEntries>Yes</SqlEntries> <TabOrder>2</TabOrder> <TabStop>Yes</TabStop> <Top>336</Top> <VariableName>MultiColumn1</VariableName> <Width>800</Width> </control> <control Type="MultiColumn"> <Align>None</Align> <AutoSelect>No</AutoSelect> <AutoSizeColumn>0</AutoSizeColumn> <Choices>&lt;Data&gt;&lt;Lines&gt;SELECT NAME, FTVORGN_ORGN_CODE ORGN, FTVORGN_TITLE ORGN_OR_DEPARTMENT FROM (SELECT FTVORGN_ORGN_CODE, FTVORGN_TITLE FROM FTVORGN -- ORGN IN-LINE VIEW WHERE TRUNC(FTVORGN_EFF_DATE) &amp;lt;= SYSDATE AND (FTVORGN_NCHG_DATE &amp;gt; SYSDATE OR FTVORGN_NCHG_DATE IS NULL) AND (FTVORGN_TERM_DATE &amp;gt; SYSDATE OR FTVORGN_TERM_DATE IS NULL) -- AND FTVORGN_STATUS_IND = 'A' ), GOBEACC, (SELECT SPRIDEN_PIDM PIDM, -- NAMES IN-LINE VIEW SUBSTR(DECODE(SPBPERS_NAME_PREFIX,'MR',NULL,'MR.',NULL,'MISS',NULL,'MRS',NULL,'MRS.',NULL,'MS',NULL,'MS.',NULL,NULL,NULL, SPBPERS_NAME_PREFIX ||' ') ||RTRIM(DECODE(NVL(SPBPERS_PREF_FIRST_NAME,'X'),'X',SPRIDEN_FIRST_NAME,SPBPERS_PREF_FIRST_NAME)) ||' ' ||RTRIM(SPRIDEN_LAST_NAME),1,25) NAME FROM SPRIDEN, SPBPERS WHERE SPRIDEN_PIDM = SPBPERS_PIDM (+) AND SPRIDEN_CHANGE_IND IS NULL AND SPRIDEN_ENTITY_IND = 'P' ), FOBSYSC WHERE DECODE(FOBSYSC_FUND_ORG_SECURITY_IND,'Y', F_FUND_ORG_SECURITY_FNC('Z','',FTVORGN_ORGN_CODE,'','',UPPER(:SEARCH_CRITERIA)),'Y')='Y' AND FOBSYSC_EFF_DATE &amp;lt;= SYSDATE AND (FOBSYSC_NCHG_DATE IS NULL OR FOBSYSC_NCHG_DATE &amp;gt; SYSDATE) AND FOBSYSC_STATUS_IND = 'A' AND PIDM = GOBEACC_PIDM AND GOBEACC_USERNAME = UPPER(:SEARCH_CRITERIA) ORDER BY 2&lt;/Lines&gt;&lt;Query&gt;&lt;ADOOptions/&gt;&lt;/Query&gt;&lt;/Data&gt;</Choices> <ChooseField>NAME</ChooseField> <ColumnAligns>Left,Left,Left</ColumnAligns> <ColumnFormats>,,</ColumnFormats> <ColumnLines>No</ColumnLines> <Columns>"NAME,,Name,WideString,0","ORGN,,,WideString,0","ORGN_OR_DEPARTMENT,,""ORGN Title"",WideString,0"</Columns> <ColumnVisible>No,Yes,Yes</ColumnVisible> <ColumnWidths>80,60,300</ColumnWidths> <Height>115</Height> <Left>0</Left> <MultiSelect>No</MultiSelect> <ParentFont>Yes</ParentFont> <Required>Yes</Required> <RowLines>No</RowLines> <ShowItemCount>No</ShowItemCount> <SqlEntries>Yes</SqlEntries> <TabOrder>1</TabOrder> <TabStop>Yes</TabStop> <Top>184</Top> <VariableName>MultiColumn2</VariableName> <Width>800</Width> </control> <control Type="Edit"> <Color>clWindow</Color> <DataAware>No</DataAware> <Description>Search Criteria</Description> <Height>21</Height> <Left>0</Left> <MultiEntry>No</MultiEntry> <ParentColor>No</ParentColor> <ParentFont>Yes</ParentFont> <ReadOnly>No</ReadOnly> <Required>Yes</Required> <TabOrder>0</TabOrder> <TabStop>Yes</TabStop> <Top>24</Top> <VariableName>Search_Criteria</VariableName> <Width>203</Width> </control> <control Type="MultiColumn"> <Align>None</Align> <AutoSelect>No</AutoSelect> <AutoSizeColumn>0</AutoSizeColumn> <Choices>&lt;Data&gt;&lt;Lines&gt;SELECT GOBEACC_USERNAME BannerUsername, NAME FROM GOBEACC, NAMES WHERE GOBEACC_USERNAME = upper(:Search_Criteria) AND PIDM = GOBEACC_PIDM&lt;/Lines&gt;&lt;Query&gt;&lt;ADOOptions/&gt;&lt;/Query&gt;&lt;/Data&gt;</Choices> <ChooseField>BANNERUSERNAME</ChooseField> <ColumnAligns>Left,Left</ColumnAligns> <ColumnFormats>,</ColumnFormats> <ColumnLines>No</ColumnLines> <Columns>"BANNERUSERNAME,,USERNAME,WideString,0","NAME,,Name,WideString,0"</Columns> <ColumnVisible>Yes,Yes</ColumnVisible> <ColumnWidths>80,300</ColumnWidths> <Height>61</Height> <Left>2</Left> <MultiSelect>No</MultiSelect> <ParentFont>Yes</ParentFont> <Required>Yes</Required> <RowLines>No</RowLines> <ShowItemCount>No</ShowItemCount> <SqlEntries>Yes</SqlEntries> <TabOrder>3</TabOrder> <TabStop>Yes</TabStop> <Top>69</Top> <VariableName>MultiColumn3</VariableName> <Width>700</Width> </control> </parameters> </datablock>