tag:blogger.com,1999:blog-37478307219771453212024-03-05T07:19:20.537-08:00Technical Overwhelmed (Oracle Apps Technical Diary)Hammam Muharebhttp://www.blogger.com/profile/06056751064122308940noreply@blogger.comBlogger24125tag:blogger.com,1999:blog-3747830721977145321.post-16652066098844064042018-01-11T10:02:00.001-08:002018-02-27T04:45:28.945-08:00How to use Profile Option In Oracle E-Business Suite Reports<div dir="ltr" style="text-align: left;" trbidi="on">
<i>
Salam Alaikum,</i><br />
<br />
<i> Many times we must use the profile options in our developed reports in Oracle E-Business Suite, and in order to do so we must add a simple code to the custom report (in the RDF File).</i><br />
<br />
<i> In Oracle R12 and with the introduction of Multi Org Feature, we must initialize in the custom report in order <b>to initialize the global variables in the context of the user running the report</b>.</i><br />
<i><br /></i>
<i>*if you need to check out a list of the most used profile options and a simple description about them you can check the below link:</i><br />
<br />
<div class="OAVLIQC-eb-m">
<a href="https://technicaloverwhelmed.blogspot.com/2018/01/oracle-apps-e-business-suite-list-of.html" target="_blank">https://technicaloverwhelmed.blogspot.com/2018/01/oracle-apps-e-business-suite-list-of.html</a><br />
<br /></div>
<div class="OAVLIQC-eb-m">
</div>
<div class="OAVLIQC-eb-m">
</div>
<i> The API <b>SRW.USER_EXIT('FND SRWINIT')</b> needs to called in the BeforeReport Trigger.</i><br />
<i><br /></i>
<i>&</i><br />
<i><br /></i>
<i><i> The API <b>SRW.USER_EXIT('FND SRWEXIT')</b> needs to called in the AfterReport Trigger.</i></i><br />
<br />
<i><i>
<i> </i></i></i><br />
<i><i><i>Hope you found it useful, feel free to leave a comment if have any note on the subject. </i> </i></i></div>
Hammam Muharebhttp://www.blogger.com/profile/06056751064122308940noreply@blogger.com0tag:blogger.com,1999:blog-3747830721977145321.post-34677625189595011162018-01-11T09:46:00.002-08:002018-02-27T04:46:17.184-08:00Oracle Apps (E-Business Suite) List of Profile Options<div dir="ltr" style="text-align: left;" trbidi="on">
<i>
Salam Alaikum,</i><br />
<br />
<i> I share with you today a simple bit of information that can be very useful about some profile options.</i><br />
<br />
<i> In the next post i will talk about how to use them in Oracle Reports.</i><br />
<br />
<i><!--[if gte mso 9]><xml>
<o:OfficeDocumentSettings>
<o:AllowPNG/>
</o:OfficeDocumentSettings>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:WordDocument>
<w:View>Normal</w:View>
<w:Zoom>0</w:Zoom>
<w:TrackMoves/>
<w:TrackFormatting/>
<w:PunctuationKerning/>
<w:ValidateAgainstSchemas/>
<w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>
<w:IgnoreMixedContent>false</w:IgnoreMixedContent>
<w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>
<w:DoNotPromoteQF/>
<w:LidThemeOther>EN-US</w:LidThemeOther>
<w:LidThemeAsian>X-NONE</w:LidThemeAsian>
<w:LidThemeComplexScript>AR-SA</w:LidThemeComplexScript>
<w:Compatibility>
<w:BreakWrappedTables/>
<w:SnapToGridInCell/>
<w:WrapTextWithPunct/>
<w:UseAsianBreakRules/>
<w:DontGrowAutofit/>
<w:SplitPgBreakAndParaMark/>
<w:EnableOpenTypeKerning/>
<w:DontFlipMirrorIndents/>
<w:OverrideTableStyleHps/>
</w:Compatibility>
<m:mathPr>
<m:mathFont m:val="Cambria Math"/>
<m:brkBin m:val="before"/>
<m:brkBinSub m:val="--"/>
<m:smallFrac m:val="off"/>
<m:dispDef/>
<m:lMargin m:val="0"/>
<m:rMargin m:val="0"/>
<m:defJc m:val="centerGroup"/>
<m:wrapIndent m:val="1440"/>
<m:intLim m:val="subSup"/>
<m:naryLim m:val="undOvr"/>
</m:mathPr></w:WordDocument>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:LatentStyles DefLockedState="false" DefUnhideWhenUsed="false"
DefSemiHidden="false" DefQFormat="false" DefPriority="99"
LatentStyleCount="375">
<w:LsdException Locked="false" Priority="0" QFormat="true" Name="Normal"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 1"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 2"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 3"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 4"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 5"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 6"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 7"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 8"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 9"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 6"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 7"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 8"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 9"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 1"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 2"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 3"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 4"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 5"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 6"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 7"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 8"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 9"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Normal Indent"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="footnote text"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="annotation text"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="header"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="footer"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index heading"/>
<w:LsdException Locked="false" Priority="35" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="caption"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="table of figures"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="envelope address"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="envelope return"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="footnote reference"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="annotation reference"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="line number"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="page number"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="endnote reference"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="endnote text"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="table of authorities"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="macro"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="toa heading"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Bullet"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Number"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Bullet 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Bullet 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Bullet 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Bullet 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Number 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Number 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Number 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Number 5"/>
<w:LsdException Locked="false" Priority="10" QFormat="true" Name="Title"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Closing"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Signature"/>
<w:LsdException Locked="false" Priority="1" SemiHidden="true"
UnhideWhenUsed="true" Name="Default Paragraph Font"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text Indent"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Continue"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Continue 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Continue 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Continue 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Continue 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Message Header"/>
<w:LsdException Locked="false" Priority="11" QFormat="true" Name="Subtitle"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Salutation"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Date"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text First Indent"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text First Indent 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Note Heading"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text Indent 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text Indent 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Block Text"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Hyperlink"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="FollowedHyperlink"/>
<w:LsdException Locked="false" Priority="22" QFormat="true" Name="Strong"/>
<w:LsdException Locked="false" Priority="20" QFormat="true" Name="Emphasis"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Document Map"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Plain Text"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="E-mail Signature"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Top of Form"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Bottom of Form"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Normal (Web)"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Acronym"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Address"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Cite"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Code"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Definition"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Keyboard"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Preformatted"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Sample"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Typewriter"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Variable"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Normal Table"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="annotation subject"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="No List"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Outline List 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Outline List 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Outline List 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Simple 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Simple 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Simple 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Classic 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Classic 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Classic 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Classic 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Colorful 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Colorful 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Colorful 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Columns 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Columns 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Columns 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Columns 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Columns 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 6"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 7"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 8"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 6"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 7"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 8"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table 3D effects 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table 3D effects 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table 3D effects 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Contemporary"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Elegant"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Professional"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Subtle 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Subtle 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Web 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Web 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Web 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Balloon Text"/>
<w:LsdException Locked="false" Priority="39" Name="Table Grid"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Theme"/>
<w:LsdException Locked="false" SemiHidden="true" Name="Placeholder Text"/>
<w:LsdException Locked="false" Priority="1" QFormat="true" Name="No Spacing"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading"/>
<w:LsdException Locked="false" Priority="61" Name="Light List"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 1"/>
<w:LsdException Locked="false" Priority="61" Name="Light List Accent 1"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 1"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 1"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 1"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 1"/>
<w:LsdException Locked="false" SemiHidden="true" Name="Revision"/>
<w:LsdException Locked="false" Priority="34" QFormat="true"
Name="List Paragraph"/>
<w:LsdException Locked="false" Priority="29" QFormat="true" Name="Quote"/>
<w:LsdException Locked="false" Priority="30" QFormat="true"
Name="Intense Quote"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 1"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 1"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 1"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 1"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List Accent 1"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 1"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 1"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 1"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 2"/>
<w:LsdException Locked="false" Priority="61" Name="Light List Accent 2"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 2"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 2"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 2"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 2"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 2"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 2"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 2"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 2"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List Accent 2"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 2"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 2"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 2"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 3"/>
<w:LsdException Locked="false" Priority="61" Name="Light List Accent 3"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 3"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 3"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 3"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 3"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 3"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 3"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 3"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 3"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List Accent 3"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 3"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 3"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 3"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 4"/>
<w:LsdException Locked="false" Priority="61" Name="Light List Accent 4"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 4"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 4"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 4"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 4"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 4"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 4"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 4"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 4"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List Accent 4"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 4"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 4"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 4"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 5"/>
<w:LsdException Locked="false" Priority="61" Name="Light List Accent 5"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 5"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 5"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 5"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 5"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 5"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 5"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 5"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 5"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List Accent 5"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 5"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 5"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 5"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 6"/>
<w:LsdException Locked="false" Priority="61" Name="Light List Accent 6"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 6"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 6"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 6"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 6"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 6"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 6"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 6"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 6"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List Accent 6"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 6"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 6"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 6"/>
<w:LsdException Locked="false" Priority="19" QFormat="true"
Name="Subtle Emphasis"/>
<w:LsdException Locked="false" Priority="21" QFormat="true"
Name="Intense Emphasis"/>
<w:LsdException Locked="false" Priority="31" QFormat="true"
Name="Subtle Reference"/>
<w:LsdException Locked="false" Priority="32" QFormat="true"
Name="Intense Reference"/>
<w:LsdException Locked="false" Priority="33" QFormat="true" Name="Book Title"/>
<w:LsdException Locked="false" Priority="37" SemiHidden="true"
UnhideWhenUsed="true" Name="Bibliography"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="TOC Heading"/>
<w:LsdException Locked="false" Priority="41" Name="Plain Table 1"/>
<w:LsdException Locked="false" Priority="42" Name="Plain Table 2"/>
<w:LsdException Locked="false" Priority="43" Name="Plain Table 3"/>
<w:LsdException Locked="false" Priority="44" Name="Plain Table 4"/>
<w:LsdException Locked="false" Priority="45" Name="Plain Table 5"/>
<w:LsdException Locked="false" Priority="40" Name="Grid Table Light"/>
<w:LsdException Locked="false" Priority="46" Name="Grid Table 1 Light"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark"/>
<w:LsdException Locked="false" Priority="51" Name="Grid Table 6 Colorful"/>
<w:LsdException Locked="false" Priority="52" Name="Grid Table 7 Colorful"/>
<w:LsdException Locked="false" Priority="46"
Name="Grid Table 1 Light Accent 1"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 1"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 1"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 1"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 1"/>
<w:LsdException Locked="false" Priority="51"
Name="Grid Table 6 Colorful Accent 1"/>
<w:LsdException Locked="false" Priority="52"
Name="Grid Table 7 Colorful Accent 1"/>
<w:LsdException Locked="false" Priority="46"
Name="Grid Table 1 Light Accent 2"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 2"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 2"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 2"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 2"/>
<w:LsdException Locked="false" Priority="51"
Name="Grid Table 6 Colorful Accent 2"/>
<w:LsdException Locked="false" Priority="52"
Name="Grid Table 7 Colorful Accent 2"/>
<w:LsdException Locked="false" Priority="46"
Name="Grid Table 1 Light Accent 3"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 3"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 3"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 3"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 3"/>
<w:LsdException Locked="false" Priority="51"
Name="Grid Table 6 Colorful Accent 3"/>
<w:LsdException Locked="false" Priority="52"
Name="Grid Table 7 Colorful Accent 3"/>
<w:LsdException Locked="false" Priority="46"
Name="Grid Table 1 Light Accent 4"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 4"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 4"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 4"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 4"/>
<w:LsdException Locked="false" Priority="51"
Name="Grid Table 6 Colorful Accent 4"/>
<w:LsdException Locked="false" Priority="52"
Name="Grid Table 7 Colorful Accent 4"/>
<w:LsdException Locked="false" Priority="46"
Name="Grid Table 1 Light Accent 5"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 5"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 5"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 5"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 5"/>
<w:LsdException Locked="false" Priority="51"
Name="Grid Table 6 Colorful Accent 5"/>
<w:LsdException Locked="false" Priority="52"
Name="Grid Table 7 Colorful Accent 5"/>
<w:LsdException Locked="false" Priority="46"
Name="Grid Table 1 Light Accent 6"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 6"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 6"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 6"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 6"/>
<w:LsdException Locked="false" Priority="51"
Name="Grid Table 6 Colorful Accent 6"/>
<w:LsdException Locked="false" Priority="52"
Name="Grid Table 7 Colorful Accent 6"/>
<w:LsdException Locked="false" Priority="46" Name="List Table 1 Light"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark"/>
<w:LsdException Locked="false" Priority="51" Name="List Table 6 Colorful"/>
<w:LsdException Locked="false" Priority="52" Name="List Table 7 Colorful"/>
<w:LsdException Locked="false" Priority="46"
Name="List Table 1 Light Accent 1"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 1"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 1"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 1"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 1"/>
<w:LsdException Locked="false" Priority="51"
Name="List Table 6 Colorful Accent 1"/>
<w:LsdException Locked="false" Priority="52"
Name="List Table 7 Colorful Accent 1"/>
<w:LsdException Locked="false" Priority="46"
Name="List Table 1 Light Accent 2"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 2"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 2"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 2"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 2"/>
<w:LsdException Locked="false" Priority="51"
Name="List Table 6 Colorful Accent 2"/>
<w:LsdException Locked="false" Priority="52"
Name="List Table 7 Colorful Accent 2"/>
<w:LsdException Locked="false" Priority="46"
Name="List Table 1 Light Accent 3"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 3"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 3"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 3"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 3"/>
<w:LsdException Locked="false" Priority="51"
Name="List Table 6 Colorful Accent 3"/>
<w:LsdException Locked="false" Priority="52"
Name="List Table 7 Colorful Accent 3"/>
<w:LsdException Locked="false" Priority="46"
Name="List Table 1 Light Accent 4"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 4"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 4"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 4"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 4"/>
<w:LsdException Locked="false" Priority="51"
Name="List Table 6 Colorful Accent 4"/>
<w:LsdException Locked="false" Priority="52"
Name="List Table 7 Colorful Accent 4"/>
<w:LsdException Locked="false" Priority="46"
Name="List Table 1 Light Accent 5"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 5"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 5"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 5"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 5"/>
<w:LsdException Locked="false" Priority="51"
Name="List Table 6 Colorful Accent 5"/>
<w:LsdException Locked="false" Priority="52"
Name="List Table 7 Colorful Accent 5"/>
<w:LsdException Locked="false" Priority="46"
Name="List Table 1 Light Accent 6"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 6"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 6"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 6"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 6"/>
<w:LsdException Locked="false" Priority="51"
Name="List Table 6 Colorful Accent 6"/>
<w:LsdException Locked="false" Priority="52"
Name="List Table 7 Colorful Accent 6"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Mention"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Smart Hyperlink"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Hashtag"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Unresolved Mention"/>
</w:LatentStyles>
</xml><![endif]--><!--[if gte mso 10]>
<style>
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-priority:99;
mso-style-parent:"";
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-para-margin-top:0in;
mso-para-margin-right:0in;
mso-para-margin-bottom:8.0pt;
mso-para-margin-left:0in;
line-height:107%;
mso-pagination:widow-orphan;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;
mso-bidi-font-family:Arial;
mso-bidi-theme-font:minor-bidi;}
</style>
<![endif]-->
<table border="1" cellpadding="0" cellspacing="0" class="MsoNormalTable" style="mso-cellspacing: 0in; mso-padding-alt: 1.2pt 1.2pt 1.2pt 1.2pt; mso-yfti-tbllook: 1184;" summary="table is summarized in text">
<tbody>
<tr style="mso-yfti-firstrow: yes; mso-yfti-irow: 0;">
<td style="background: #E0E0E0; padding: 1.2pt 1.2pt 1.2pt 1.2pt;"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: center;">
<b><span style="font-family: "times new roman" , serif; font-size: 12.0pt;">Variable</span></b></div>
</td>
<td style="background: #E0E0E0; padding: 1.2pt 1.2pt 1.2pt 1.2pt;"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: center;">
<b><span style="font-family: "times new roman" , serif; font-size: 12.0pt;">Description</span></b></div>
</td>
</tr>
<tr style="mso-yfti-irow: 1;">
<td style="padding: 1.2pt 1.2pt 1.2pt 1.2pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<b><span style="font-family: "times new roman" , serif; font-size: 12.0pt;">USERNAME</span></b><span style="font-family: "times new roman" , serif; font-size: 12.0pt;"> </span></div>
</td>
<td style="padding: 1.2pt 1.2pt 1.2pt 1.2pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "times new roman" , serif; font-size: 12.0pt;">Your user's current Oracle
Application Object Library username. </span></div>
</td>
</tr>
<tr style="mso-yfti-irow: 2;">
<td style="padding: 1.2pt 1.2pt 1.2pt 1.2pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<b><span style="font-family: "times new roman" , serif; font-size: 12.0pt;">USER_ID</span></b><span style="font-family: "times new roman" , serif; font-size: 12.0pt;"> </span></div>
</td>
<td style="padding: 1.2pt 1.2pt 1.2pt 1.2pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "times new roman" , serif; font-size: 12.0pt;">Your user's current Oracle
Application Object Library user ID. </span></div>
</td>
</tr>
<tr style="mso-yfti-irow: 3;">
<td style="padding: 1.2pt 1.2pt 1.2pt 1.2pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<b><span style="font-family: "times new roman" , serif; font-size: 12.0pt;">RESP_ID</span></b><span style="font-family: "times new roman" , serif; font-size: 12.0pt;"> </span></div>
</td>
<td style="padding: 1.2pt 1.2pt 1.2pt 1.2pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "times new roman" , serif; font-size: 12.0pt;">Your user's current responsibility
ID. </span></div>
</td>
</tr>
<tr style="mso-yfti-irow: 4;">
<td style="padding: 1.2pt 1.2pt 1.2pt 1.2pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<b><span style="font-family: "times new roman" , serif; font-size: 12.0pt;">APPL_SHRT_ NAME</span></b><span style="font-family: "times new roman" , serif; font-size: 12.0pt;"> </span></div>
</td>
<td style="padding: 1.2pt 1.2pt 1.2pt 1.2pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "times new roman" , serif; font-size: 12.0pt;">The short name of the application
connected to your user's current responsibility. </span></div>
</td>
</tr>
<tr style="mso-yfti-irow: 5;">
<td style="padding: 1.2pt 1.2pt 1.2pt 1.2pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<b><span style="font-family: "times new roman" , serif; font-size: 12.0pt;">RESP_APPL_ID</span></b><span style="font-family: "times new roman" , serif; font-size: 12.0pt;"> </span></div>
</td>
<td style="padding: 1.2pt 1.2pt 1.2pt 1.2pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "times new roman" , serif; font-size: 12.0pt;">The application ID of the
application connected to your user's current responsibility. </span></div>
</td>
</tr>
<tr style="mso-yfti-irow: 6;">
<td style="padding: 1.2pt 1.2pt 1.2pt 1.2pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<b><span style="font-family: "times new roman" , serif; font-size: 12.0pt;">FORM_NAME</span></b><span style="font-family: "times new roman" , serif; font-size: 12.0pt;"> </span></div>
</td>
<td style="padding: 1.2pt 1.2pt 1.2pt 1.2pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "times new roman" , serif; font-size: 12.0pt;">The name of the current form. Not
available for concurrent programs.</span></div>
</td>
</tr>
<tr style="mso-yfti-irow: 7;">
<td style="padding: 1.2pt 1.2pt 1.2pt 1.2pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<b><span style="font-family: "times new roman" , serif; font-size: 12.0pt;">FORM_ID</span></b><span style="font-family: "times new roman" , serif; font-size: 12.0pt;"> </span></div>
</td>
<td style="padding: 1.2pt 1.2pt 1.2pt 1.2pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "times new roman" , serif; font-size: 12.0pt;">The form ID of the current form.
Not available for concurrent programs.</span></div>
</td>
</tr>
<tr style="mso-yfti-irow: 8;">
<td style="padding: 1.2pt 1.2pt 1.2pt 1.2pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<b><span style="font-family: "times new roman" , serif; font-size: 12.0pt;">FORM_APPL_ NAME</span></b><span style="font-family: "times new roman" , serif; font-size: 12.0pt;"> </span></div>
</td>
<td style="padding: 1.2pt 1.2pt 1.2pt 1.2pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "times new roman" , serif; font-size: 12.0pt;">The name of the application for
which the current form is registered. Not available for concurrent programs.</span></div>
</td>
</tr>
<tr style="mso-yfti-irow: 9;">
<td style="padding: 1.2pt 1.2pt 1.2pt 1.2pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<b><span style="font-family: "times new roman" , serif; font-size: 12.0pt;">FORM_APPL_ID</span></b><span style="font-family: "times new roman" , serif; font-size: 12.0pt;"> </span></div>
</td>
<td style="padding: 1.2pt 1.2pt 1.2pt 1.2pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "times new roman" , serif; font-size: 12.0pt;">The application ID of the
application for which the current form is registered. Not available for
concurrent programs.</span></div>
</td>
</tr>
<tr style="mso-yfti-irow: 10;">
<td style="padding: 1.2pt 1.2pt 1.2pt 1.2pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<b><span style="font-family: "times new roman" , serif; font-size: 12.0pt;">LOGON_DATE</span></b><span style="font-family: "times new roman" , serif; font-size: 12.0pt;"> </span></div>
</td>
<td style="padding: 1.2pt 1.2pt 1.2pt 1.2pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "times new roman" , serif; font-size: 12.0pt;">Your user's logon date for the
current session. </span></div>
</td>
</tr>
<tr style="mso-yfti-irow: 11;">
<td style="padding: 1.2pt 1.2pt 1.2pt 1.2pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<b><span style="font-family: "times new roman" , serif; font-size: 12.0pt;">LAST_LOGON_ DATE</span></b><span style="font-family: "times new roman" , serif; font-size: 12.0pt;"> </span></div>
</td>
<td style="padding: 1.2pt 1.2pt 1.2pt 1.2pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "times new roman" , serif; font-size: 12.0pt;">Your user's logon date for the
previous session. </span></div>
</td>
</tr>
<tr style="mso-yfti-irow: 12;">
<td style="padding: 1.2pt 1.2pt 1.2pt 1.2pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<b><span style="font-family: "times new roman" , serif; font-size: 12.0pt;">LOGIN_ID</span></b><span style="font-family: "times new roman" , serif; font-size: 12.0pt;"> </span></div>
</td>
<td style="padding: 1.2pt 1.2pt 1.2pt 1.2pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "times new roman" , serif; font-size: 12.0pt;">Your user's Sign-On Audit login ID
in Oracle Application Object Library. </span></div>
</td>
</tr>
<tr style="mso-yfti-irow: 13;">
<td style="padding: 1.2pt 1.2pt 1.2pt 1.2pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<b><span style="font-family: "times new roman" , serif; font-size: 12.0pt;">CONC_ REQUEST_ID</span></b><span style="font-family: "times new roman" , serif; font-size: 12.0pt;"> </span></div>
</td>
<td style="padding: 1.2pt 1.2pt 1.2pt 1.2pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "times new roman" , serif; font-size: 12.0pt;">The request ID associated with a
particular instance of your running current program. You can only use this
profile option in a concurrent program. You use this profile option to fill
the REQUEST_ID Who column. </span></div>
</td>
</tr>
<tr style="mso-yfti-irow: 14;">
<td style="padding: 1.2pt 1.2pt 1.2pt 1.2pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<b><span style="font-family: "times new roman" , serif; font-size: 12.0pt;">CONC_ PROGRAM_ID</span></b><span style="font-family: "times new roman" , serif; font-size: 12.0pt;"> </span></div>
</td>
<td style="padding: 1.2pt 1.2pt 1.2pt 1.2pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<a href="https://www.blogger.com/null" name="d0e13480"></a><span style="font-family: "times new roman" , serif; font-size: 12.0pt;">The program ID associated with a
running current program. You can only use this profile option in a concurrent
program. You use this profile option to fill the PROGRAM_ID Who column. </span></div>
</td>
</tr>
<tr style="mso-yfti-irow: 15;">
<td style="padding: 1.2pt 1.2pt 1.2pt 1.2pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<b><span style="font-family: "times new roman" , serif; font-size: 12.0pt;">CONC_ PROGRAM_ APPLICATION_ ID</span></b><span style="font-family: "times new roman" , serif; font-size: 12.0pt;"> </span></div>
</td>
<td style="padding: 1.2pt 1.2pt 1.2pt 1.2pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "times new roman" , serif; font-size: 12.0pt;">The application ID associated with
a running current program. You can only use this profile option in a
concurrent program. You use this profile option to fill the
PROGRAM_APPLICATION_ID Who column. </span></div>
</td>
</tr>
<tr style="mso-yfti-irow: 16;">
<td style="padding: 1.2pt 1.2pt 1.2pt 1.2pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<b><span style="font-family: "times new roman" , serif; font-size: 12.0pt;">CONC_LOGIN_ ID</span></b><span style="font-family: "times new roman" , serif; font-size: 12.0pt;"> </span></div>
</td>
<td style="padding: 1.2pt 1.2pt 1.2pt 1.2pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "times new roman" , serif; font-size: 12.0pt;">The login ID associated with a
running concurrent program. You can only use this profile option in a
concurrent program. You can use this profile option to fill the
LAST_UPDATE_LOGIN Who column. </span></div>
</td>
</tr>
<tr style="mso-yfti-irow: 17;">
<td style="padding: 1.2pt 1.2pt 1.2pt 1.2pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<b><span style="font-family: "times new roman" , serif; font-size: 12.0pt;">CONC_PRINT_ OUTPUT</span></b><span style="font-family: "times new roman" , serif; font-size: 12.0pt;"> </span></div>
</td>
<td style="padding: 1.2pt 1.2pt 1.2pt 1.2pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "times new roman" , serif; font-size: 12.0pt;">The value Yes or No that you enter
in the Print Output field when you register a concurrent program. You can use
the routine afpoput() from your concurrent programs to change the value of
this profile option for a particular instance of your running concurrent
program. This profile option determines whether the concurrent managers print
the concurrent program's output to the printer. </span></div>
</td>
</tr>
<tr style="mso-yfti-irow: 18; mso-yfti-lastrow: yes;">
<td style="padding: 1.2pt 1.2pt 1.2pt 1.2pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<b><span style="font-family: "times new roman" , serif; font-size: 12.0pt;">CONC_PRINT_ STYLE</span></b><span style="font-family: "times new roman" , serif; font-size: 12.0pt;"> </span></div>
</td>
<td style="padding: 1.2pt 1.2pt 1.2pt 1.2pt;" valign="top"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-family: "times new roman" , serif; font-size: 12.0pt;">The print style of your concurrent
program's output that you enter in the Print Style field when you register a
concurrent program. You can use the routine afpoput() from your concurrent
programs to change the value of this profile option for a particular instance
of your running concurrent program. </span></div>
</td>
</tr>
</tbody></table>
</i><br />
<i>
Hope you found it useful, feel free to leave a comment if have any note on the subject. </i><br />
<br /></div>
Hammam Muharebhttp://www.blogger.com/profile/06056751064122308940noreply@blogger.com0tag:blogger.com,1999:blog-3747830721977145321.post-46607451189113308142016-08-28T02:21:00.001-07:002016-08-28T02:21:16.720-07:00 API to Create Position<div dir="ltr" style="text-align: left;" trbidi="on">
<i>
Salam Alaikum,</i><br />
<br />
<i> I share with you today the API used to create a position in HR.</i><br />
<br />
<i> *Please note that the values in the API are hard-coded.</i><br />
<i></i><br />
<i><br /></i>
<br />
<blockquote class="tr_bq">
<span style="color: #20124d;"><span style="background-color: #cfe2f3;"><span class="kmContent" id="kmPgTpl:sd_r1:0:dv_rDoc:ot71" style="font-size: x-small;">declare</span><br /><span class="kmContent" id="kmPgTpl:sd_r1:0:dv_rDoc:ot71" style="font-size: x-small;"></span><br /><span class="kmContent" id="kmPgTpl:sd_r1:0:dv_rDoc:ot71" style="font-size: x-small;">l_true BOOLEAN :=false;</span><br /><span class="kmContent" id="kmPgTpl:sd_r1:0:dv_rDoc:ot71" style="font-size: x-small;">l_obj NUMBER;</span><br /><span class="kmContent" id="kmPgTpl:sd_r1:0:dv_rDoc:ot71" style="font-size: x-small;">l_JOB_ID NUMBER :=614; </span><br /><span class="kmContent" id="kmPgTpl:sd_r1:0:dv_rDoc:ot71" style="font-size: x-small;">l_ORGANIZATION_ID NUMBER :=1379;</span><br /><span class="kmContent" id="kmPgTpl:sd_r1:0:dv_rDoc:ot71" style="font-size: x-small;">l_DATE_EFFECTIVE DATE := to_date('01-DEC-2000', 'DD-MON-YYYY');</span><br /><span class="kmContent" id="kmPgTpl:sd_r1:0:dv_rDoc:ot71" style="font-size: x-small;">l_POSITION_ID NUMBER;</span><br /><span class="kmContent" id="kmPgTpl:sd_r1:0:dv_rDoc:ot71" style="font-size: x-small;">l_POSITION_DEFINITION_ID NUMBER;</span><br /><span class="kmContent" id="kmPgTpl:sd_r1:0:dv_rDoc:ot71" style="font-size: x-small;">l_NAME VARCHAR2(30);</span><br /><span class="kmContent" id="kmPgTpl:sd_r1:0:dv_rDoc:ot71" style="font-size: x-small;">l_segment1 </span></span></span><span style="color: #20124d;"><span style="background-color: #cfe2f3;"><span class="kmContent" id="kmPgTpl:sd_r1:0:dv_rDoc:ot71" style="font-size: x-small;"><span style="color: #20124d;"><span style="background-color: #cfe2f3;"><span class="kmContent" id="kmPgTpl:sd_r1:0:dv_rDoc:ot71" style="font-size: x-small;">VARCHAR2</span></span></span>(30) :='TEST POSITION';</span><br /><span class="kmContent" id="kmPgTpl:sd_r1:0:dv_rDoc:ot71" style="font-size: x-small;">l_segment2 VARCHAR2(30) :='10';</span><br /><span class="kmContent" id="kmPgTpl:sd_r1:0:dv_rDoc:ot71" style="font-size: x-small;"></span><br /><span class="kmContent" id="kmPgTpl:sd_r1:0:dv_rDoc:ot71" style="font-size: x-small;">begin</span><br /><span class="kmContent" id="kmPgTpl:sd_r1:0:dv_rDoc:ot71" style="font-size: x-small;"></span><br /><span class="kmContent" id="kmPgTpl:sd_r1:0:dv_rDoc:ot71" style="font-size: x-small;">hr_position_api.create_position</span><br /><span class="kmContent" id="kmPgTpl:sd_r1:0:dv_rDoc:ot71" style="font-size: x-small;">(</span><br /><span class="kmContent" id="kmPgTpl:sd_r1:0:dv_rDoc:ot71" style="font-size: x-small;"> p_validate => l_true</span><br /><span class="kmContent" id="kmPgTpl:sd_r1:0:dv_rDoc:ot71" style="font-size: x-small;">, p_object_version_number => l_obj</span><br /><span class="kmContent" id="kmPgTpl:sd_r1:0:dv_rDoc:ot71" style="font-size: x-small;">, p_JOB_ID => l_JOB_ID</span><br /><span class="kmContent" id="kmPgTpl:sd_r1:0:dv_rDoc:ot71" style="font-size: x-small;">, p_ORGANIZATION_ID => l_ORGANIZATION_ID </span><br /><span class="kmContent" id="kmPgTpl:sd_r1:0:dv_rDoc:ot71" style="font-size: x-small;">, p_DATE_EFFECTIVE => l_DATE_EFFECTIVE</span><br /><span class="kmContent" id="kmPgTpl:sd_r1:0:dv_rDoc:ot71" style="font-size: x-small;">, p_POSITION_ID => l_POSITION_ID</span><br /><span class="kmContent" id="kmPgTpl:sd_r1:0:dv_rDoc:ot71" style="font-size: x-small;">, p_POSITION_DEFINITION_ID => l_POSITION_DEFINITION_ID</span><br /><span class="kmContent" id="kmPgTpl:sd_r1:0:dv_rDoc:ot71" style="font-size: x-small;">, p_NAME => l_NAME </span><br /><span class="kmContent" id="kmPgTpl:sd_r1:0:dv_rDoc:ot71" style="font-size: x-small;">, p_segment1 => l_segment1</span><br /><span class="kmContent" id="kmPgTpl:sd_r1:0:dv_rDoc:ot71" style="font-size: x-small;">, p_segment2 => l_segment2</span><br /><span class="kmContent" id="kmPgTpl:sd_r1:0:dv_rDoc:ot71" style="font-size: x-small;">, p_location_id => 2694</span><br /><span class="kmContent" id="kmPgTpl:sd_r1:0:dv_rDoc:ot71" style="font-size: x-small;">);</span><br /><span class="kmContent" id="kmPgTpl:sd_r1:0:dv_rDoc:ot71" style="font-size: x-small;">end;</span></span></span></blockquote>
<br />
<i>
Hope you found it useful, feel free to leave a comment if have any note on the subject. </i></div>
Hammam Muharebhttp://www.blogger.com/profile/06056751064122308940noreply@blogger.com0tag:blogger.com,1999:blog-3747830721977145321.post-59383033476346535552016-08-28T02:04:00.001-07:002016-08-28T02:04:16.600-07:00API to Create Organization<div dir="ltr" style="text-align: left;" trbidi="on">
<i>
Salam Alaikum,</i><br />
<br />
<i> I share with you today the API used to create organiztion in HR.</i><br />
<br />
<i> *Please note that the values in the API are hard-coded.</i><br />
<i><br /></i>
<br />
<blockquote class="tr_bq">
<span style="font-size: small;"><span style="color: #20124d;"><span style="background-color: #cfe2f3;"><span class="kmContent" id="kmPgTpl:sd_r1:0:dv_rDoc:ot71"><span style="color: #351c75;"><span style="background-color: #cfe2f3;">DECLARE</span></span></span><br /><span class="kmContent" id="kmPgTpl:sd_r1:0:dv_rDoc:ot71">l_date date := to_date('01-jan-2000','DD-MON-YYYY');</span><br /><span class="kmContent" id="kmPgTpl:sd_r1:0:dv_rDoc:ot71">l_true boolean := false;</span><br /><span class="kmContent" id="kmPgTpl:sd_r1:0:dv_rDoc:ot71">l_business_group_id number := 626;</span><br /><span class="kmContent" id="kmPgTpl:sd_r1:0:dv_rDoc:ot71">l_language_code varchar2(10) := 'US';</span><br /><span class="kmContent" id="kmPgTpl:sd_r1:0:dv_rDoc:ot71">l_name varchar2(80) := 'NJ TEST ORG';</span><br /><span class="kmContent" id="kmPgTpl:sd_r1:0:dv_rDoc:ot71">l_internal_external_flag varchar2(80) := 'INT';</span><br /><span class="kmContent" id="kmPgTpl:sd_r1:0:dv_rDoc:ot71">l_organization_id number;</span><br /><span class="kmContent" id="kmPgTpl:sd_r1:0:dv_rDoc:ot71">l_object_version_number number;</span><br /><span class="kmContent" id="kmPgTpl:sd_r1:0:dv_rDoc:ot71">l_duplicate_org_warning boolean;</span><br /><span class="kmContent" id="kmPgTpl:sd_r1:0:dv_rDoc:ot71"></span><br /><span class="kmContent" id="kmPgTpl:sd_r1:0:dv_rDoc:ot71"></span></span></span></span><span style="font-size: small;"><span style="color: #20124d;"><span style="background-color: #cfe2f3;"><span class="kmContent" id="kmPgTpl:sd_r1:0:dv_rDoc:ot71"><span style="color: #351c75;"><span style="background-color: #cfe2f3;">BEGIN</span></span></span><br /><span class="kmContent" id="kmPgTpl:sd_r1:0:dv_rDoc:ot71">hr_organization_api.create_organization</span><br /><span class="kmContent" id="kmPgTpl:sd_r1:0:dv_rDoc:ot71"> ( p_validate => l_true</span><br /><span class="kmContent" id="kmPgTpl:sd_r1:0:dv_rDoc:ot71"> ,p_effective_date => l_date</span><br /><span class="kmContent" id="kmPgTpl:sd_r1:0:dv_rDoc:ot71"> ,p_language_code => l_language_code</span><br /><span class="kmContent" id="kmPgTpl:sd_r1:0:dv_rDoc:ot71"> ,p_business_group_id => l_business_group_id</span><br /><span class="kmContent" id="kmPgTpl:sd_r1:0:dv_rDoc:ot71"> ,p_date_from => l_date</span><br /><span class="kmContent" id="kmPgTpl:sd_r1:0:dv_rDoc:ot71"> ,p_name => l_name</span><br /><span class="kmContent" id="kmPgTpl:sd_r1:0:dv_rDoc:ot71"> ,p_internal_external_flag => l_internal_external_flag</span><br /><span class="kmContent" id="kmPgTpl:sd_r1:0:dv_rDoc:ot71"> ,p_organization_id => l_organization_id</span><br /><span class="kmContent" id="kmPgTpl:sd_r1:0:dv_rDoc:ot71"> ,p_object_version_number => l_object_version_number</span><br /><span class="kmContent" id="kmPgTpl:sd_r1:0:dv_rDoc:ot71"> ,P_duplicate_org_warning => l_duplicate_org_warning</span><br /><span class="kmContent" id="kmPgTpl:sd_r1:0:dv_rDoc:ot71">);</span></span></span></span><span style="font-size: small;"><span style="color: #20124d;"><span style="background-color: #cfe2f3;"><span style="color: #351c75;"><span style="background-color: #cfe2f3;">END;</span></span></span></span></span> </blockquote>
<br />
<i>
Hope you found it useful, feel free to leave a comment if have any note on the subject. </i><br />
<br />
</div>
Hammam Muharebhttp://www.blogger.com/profile/06056751064122308940noreply@blogger.com0tag:blogger.com,1999:blog-3747830721977145321.post-43847761485691499052016-03-23T04:29:00.002-07:002016-08-28T01:23:26.653-07:00API to Create Person Extra Information record<div dir="ltr" style="text-align: left;" trbidi="on">
<i>
Salam Alaikum,</i><br />
<br />
<i> It is one very important and widely used API that i share with you today... It is the API used to upload Extra Information for a person in Oracle HR. It is very simple and straight forward, and as you know each Extra Information has different (attributes/attribute type) so you have to consider getting to know some the dependencies (if exists) between the attributes before uploading.</i><br />
<br />
<i> That being said, i share one simple API, with three attributes only:</i><br />
<br />
<blockquote class="tr_bq">
<span style="color: #351c75;"><span style="background-color: #cfe2f3;">DECLARE<br /> l_true BOOLEAN := FALSE;<br /> l_PERSON_ID NUMBER := 31785;<br /> l_INFORMATION_TYPE VARCHAR2 (2000) := 'LAST_NAME_DETAILS';<br /> l_pei_information_category VARCHAR2 (2000) := 'LAST_NAME_DETAILS';<br /> l_PEI_INFORMATION1 VARCHAR2 (2000) := 'Test1';<br /> l_PEI_INFORMATION2 VARCHAR2 (2000) := 'Test2';<br /> l_PEI_INFORMATION3 VARCHAR (200) := TO_CHAR (TO_DATE ('01-JAN-1999', 'DD-MON-YYYY'),'YYYY/MM/DD HH24:MI:SS');<br /> -- Output Variables<br /> l_PERSON_EXTRA_INFO_ID NUMBER;<br /> l_OBJ NUMBER;<br /><br /> CURSOR csr_ovn<br /> IS<br /> SELECT MAX (object_version_number)<br /> FROM per_all_people_f<br /> WHERE person_id = l_person_id;<br />BEGIN<br /> OPEN csr_ovn;<br /> FETCH csr_ovn INTO l_obj;<br /> CLOSE csr_ovn;<br /><br /> HR_PERSON_EXTRA_INFO_API.CREATE_PERSON_EXTRA_INFO (<br /> p_validate => l_true,<br /> p_person_id => l_person_id,<br /> p_INFORMATION_TYPE => l_INFORMATION_TYPE,<br /> p_pei_information_category => l_pei_information_category,<br /> p_PEI_INFORMATION1 => l_PEI_INFORMATION1,<br /> p_PEI_INFORMATION2 => l_PEI_INFORMATION2,<br /> p_PEI_INFORMATION3 => l_PEI_INFORMATION3,<br /> p_PERSON_EXTRA_INFO_ID => l_PERSON_EXTRA_INFO_ID,<br /> p_object_version_number => l_obj);<br />END;</span></span></blockquote>
<br />
<i>*note: the <b>P_PERSON_EXTRA_INFO_ID </b>and <b>P_OBJECT_VERSION_NUMBER </b>are both out parameters. </i><br />
<br />
<i>
Hope you found it useful, feel free to leave a comment if have any note on the subject. </i></div>
Hammam Muharebhttp://www.blogger.com/profile/06056751064122308940noreply@blogger.com0tag:blogger.com,1999:blog-3747830721977145321.post-46854233381618858212016-03-23T03:43:00.001-07:002016-03-23T03:43:55.942-07:00API code to Create, Release and Receive an OPM Inventory Transfer <div dir="ltr" style="text-align: left;" trbidi="on">
<i>
Salam Alaikum,</i><br />
<br />
<i>Following an example API to create, release and transfer in the Oracle Process Manufacturing (OPM). It calls three different API's. Naturally, the first one is to create and the second to release and the third to transfer, based on the <b>Transfer_action</b>.</i><br />
<i><br /></i>
<br />
<blockquote class="tr_bq">
<span style="background-color: #cfe2f3;"><span style="color: #0b5394;">DECLARE<br /> x_status VARCHAR2 (1);<br /> x_count NUMBER;<br /> x_msg_data VARCHAR2 (2000);<br /> l_transfer_rec GMIGXFR.TYPE_XFER_REC;<br /> x_out_rec IC_XFER_MST%ROWTYPE;<br /> l_dummy NUMBER;<br /> x_dummy_cnt NUMBER;<br />BEGIN<br /> l_transfer_rec.transfer_action := 1;<br /> l_transfer_rec.transfer_no := NULL;<br /> l_transfer_rec.transfer_batch := 'TEST XFER';<br /> l_transfer_rec.orgn_code := 'PR1';<br /> l_transfer_rec.item_no := 'JGC_1';<br /> l_transfer_rec.lot_no := 'JGC_165';<br /> l_transfer_rec.sublot_no := NULL;<br /> l_transfer_rec.source_warehouse := 'PR1';<br /> l_transfer_rec.source_location := '1';<br /> l_transfer_rec.target_warehouse := 'PR2';<br /> l_transfer_rec.target_location := '1';<br /> -- date for testing period<br /> l_transfer_rec.scheduled_release_date := TO_DATE (SYSDATE, 'dd.mm.yyyy');<br /> l_transfer_rec.scheduled_receive_date := TO_DATE (SYSDATE, 'dd.mm.yyyy');<br /> l_transfer_rec.actual_release_date := TO_DATE (SYSDATE, 'dd.mm.yyyy');<br /> l_transfer_rec.actual_receive_date := TO_DATE (SYSDATE, 'dd.mm.yyyy');<br /> l_transfer_rec.cancel_date := NULL;<br /> l_transfer_rec.release_quantity1 := 1.0;<br /> l_transfer_rec.release_quantity2 := NULL;<br /> l_transfer_rec.reason_code := 'ADJ';<br /> l_transfer_rec.comments := 'test API XFER';<br /> l_transfer_rec.user_name := 'OPMUK';<br /> -- Creating<br /> GMIPXFR.Inventory_Transfer (<br /> p_api_version => 1.0,<br /> p_init_msg_list => FND_API.G_TRUE,<br /> p_commit => FND_API.G_TRUE,<br /> p_validation_level => FND_API.G_valid_level_full,<br /> p_xfer_rec => l_transfer_rec,<br /> x_ic_xfer_mst_row => x_out_rec,<br /> x_return_status => x_status,<br /> x_msg_count => x_count,<br /> x_msg_data => x_msg_data);<br /><br /> IF x_status != 'S'<br /> THEN<br /> DBMS_OUTPUT.put_line ('Error creating');<br /><br /> IF x_count > 1<br /> THEN<br /> FOR l_dummy IN 1 .. x_count<br /> LOOP<br /> fnd_msg_pub.get (p_msg_index => l_dummy,<br /> p_data => x_msg_data,<br /> p_encoded => fnd_api.g_false,<br /> p_msg_index_out => x_dummy_cnt);<br /> DBMS_OUTPUT.put_line (SUBSTR (x_msg_data, 1, 255));<br /> END LOOP;<br /> ELSE<br /> DBMS_OUTPUT.put_line (SUBSTR (x_msg_data, 1, 255));<br /> END IF;<br /> ELSE -- if success<br /> -- RELEASE<br /> l_transfer_rec.transfer_action := 2;<br /> l_transfer_rec.transfer_no := x_out_rec.transfer_no;<br /> DBMS_OUTPUT.put_line ('XFER no:' || l_transfer_rec.transfer_no);<br /> GMIPXFR.Inventory_Transfer (<br /> p_api_version => 1.0,<br /> p_init_msg_list => FND_API.G_TRUE,<br /> p_commit => FND_API.G_TRUE,<br /> p_validation_level => FND_API.G_valid_level_full,<br /> p_xfer_rec => l_transfer_rec,<br /> x_ic_xfer_mst_row => x_out_rec,<br /> x_return_status => x_status,<br /> x_msg_count => x_count,<br /> x_msg_data => x_msg_data);<br /><br /> IF x_status != 'S'<br /> THEN<br /> DBMS_OUTPUT.put_line ('Error releasing');<br /><br /> IF x_count > 1<br /> THEN<br /> FOR l_dummy IN 1 .. x_count<br /> LOOP<br /> fnd_msg_pub.get (p_msg_index => l_dummy,<br /> p_data => x_msg_data,<br /> p_encoded => fnd_api.g_false,<br /> p_msg_index_out => x_dummy_cnt);<br /> DBMS_OUTPUT.put_line (SUBSTR (x_msg_data, 1, 255));<br /> END LOOP;<br /> ELSE<br /> DBMS_OUTPUT.put_line (SUBSTR (x_msg_data, 1, 255));<br /> END IF;<br /> ELSE<br /> -- receive<br /> l_transfer_rec.transfer_action := 3;<br /> GMIPXFR.Inventory_Transfer (<br /> p_api_version => 1.0,<br /> p_init_msg_list => FND_API.G_TRUE,<br /> p_commit => FND_API.G_TRUE,<br /> p_validation_level => FND_API.G_valid_level_full,<br /> p_xfer_rec => l_transfer_rec,<br /> x_ic_xfer_mst_row => x_out_rec,<br /> x_return_status => x_status,<br /> x_msg_count => x_count,<br /> x_msg_data => x_msg_data);<br /><br /> IF x_status != 'S'<br /> THEN<br /> DBMS_OUTPUT.put_line ('Error receiving');<br /><br /> IF x_count > 1<br /> THEN<br /> FOR l_dummy IN 1 .. x_count<br /> LOOP<br /> fnd_msg_pub.get (p_msg_index => l_dummy,<br /> p_data => x_msg_data,<br /> p_encoded => fnd_api.g_false,<br /> p_msg_index_out => x_dummy_cnt);<br /> DBMS_OUTPUT.put_line (SUBSTR (x_msg_data, 1, 255));<br /> END LOOP;<br /> ELSE<br /> DBMS_OUTPUT.put_line (SUBSTR (x_msg_data, 1, 255));<br /> END IF;<br /> END IF;<br /> END IF;<br /> END IF;<br />END;<br />/</span></span></blockquote>
<br />
<i>
Hope you found it useful, feel free to leave a comment if have any note on the subject. </i></div>
Hammam Muharebhttp://www.blogger.com/profile/06056751064122308940noreply@blogger.com0tag:blogger.com,1999:blog-3747830721977145321.post-59504088007511336242016-03-23T02:49:00.001-07:002016-03-23T02:49:33.913-07:00Inventory Item Upload API<div dir="ltr" style="text-align: left;" trbidi="on">
Salam Alaikum,<br />
<br />
I share with you here a very simple API that can be used to upload inventory items to the interface "MTL_SYSTEM_ITEMS_INTERFACE". And please note that after populating the interface you have to run the request "<i><b>Import Items</b>".</i><br />
<br />
<blockquote class="tr_bq">
<span style="color: #0b5394;"><span style="background-color: #9fc5e8;">DECLARE<br /> CURSOR cur<br /> IS<br /> SELECT ITEM_CODE,<br /> ITEM_DESCRIPTION,<br /> UOM_CODE,<br /> TEMPLATE_ID<br /> FROM XXX_ITEMS_TEMP;<br />BEGIN<br /> fnd_global.apps_initialize (1150, 20634, 401);<br /><br /> FOR rec IN cur<br /> LOOP<br /> INSERT INTO APPS.MTL_SYSTEM_ITEMS_INTERFACE (SEGMENT1,<br /> DESCRIPTION,<br /> ORGANIZATION_ID,<br /> PRIMARY_UOM_CODE,<br /> TEMPLATE_ID,<br /> CREATED_BY,<br /> PROCESS_FLAG,<br /> TRANSACTION_TYPE)<br /> VALUES (rec.ITEM_CODE,<br /> rec.ITEM_DESCRIPTION,<br /> 102,<br /> rec.UOM_CODE,<br /> rec.TEMPLATE_ID,<br /> 1150,<br /> 1,<br /> 'CREATE');<br /><br /> INSERT INTO APPS.MTL_SYSTEM_ITEMS_INTERFACE (SEGMENT1,<br /> DESCRIPTION,<br /> ORGANIZATION_ID,<br /> PRIMARY_UOM_CODE,<br /> TEMPLATE_ID,<br /> CREATED_BY,<br /> PROCESS_FLAG,<br /> TRANSACTION_TYPE)<br /> VALUES (rec.ITEM_CODE,<br /> rec.ITEM_DESCRIPTION,<br /> 101,<br /> rec.UOM_CODE,<br /> rec.TEMPLATE_ID,<br /> 1150,<br /> 1,<br /> 'CREATE');<br /><br /> UPDATE XXX_ITEMS_TEMP2 t<br /> SET t.data_upload = 'Y'<br /> WHERE t.ITEM_CODE = rec.ITEM_CODE;<br /> END LOOP;<br />END;</span></span></blockquote>
<br />
Some notes regarding the Concurrent "<b><i>Import Items</i></b>":<br />
<ol style="text-align: left;">
<li>Indicate whether to run the interface for all organizations in the item interface table. If you choose <i>No</i>, the interface runs only for the current organization and interface table rows for other organizations are ignored.</li>
<li>Indicate whether to validate all items and their data residing in the
interface table that have not yet been validated. If items are not
validated, they are not processed into Oracle Inventory. (<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";">You would choose <i>No</i> if you had previously run the
item interface and responded <i>Yes</i> for <i>Validate Items</i><b> </b>and<b>
</b>No<b> </b>for<b> </b><i>Process Items</i><b>,</b> and now want to process
your items).</span></li>
<li>
Indicate whether to process items. If you choose <i>Yes</i>, all qualifying items in the interface table are inserted into Inventory. (You would choose <i>No</i>, along with <i>Yes</i> for <i>Delete Processed Rows</i>, to remove successfully processed rows from the interface table without performing any other processing).</li>
<li>Indicate whether to delete successfully processed items from the item interface tables<br />(<span style="font-family: "Times New Roman","serif"; font-size: 12.0pt; mso-fareast-font-family: "Times New Roman";">Choose <i>No</i> to leave all rows in the item interface
tables for successfully processed items).</span></li>
</ol>
<br />
<br />
Hope you found it useful, feel free to leave a comment if have any note on the subject. <br />
<br /></div>
Hammam Muharebhttp://www.blogger.com/profile/06056751064122308940noreply@blogger.com0tag:blogger.com,1999:blog-3747830721977145321.post-36773147049078545812016-03-15T15:05:00.000-07:002016-03-16T05:29:27.249-07:00Oracle Apps Shortcut Key (very useful)<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
Salam Alaikum,<br />
<br />
In Oracle Apps there are many shortcuts for some of the functionalities while working on oracle forms, it can be very useful for everyone who uses the system to know them. Here they are explained in this table:<br />
<!--[if gte mso 9]><xml>
<o:OfficeDocumentSettings>
<o:AllowPNG/>
</o:OfficeDocumentSettings>
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:OfficeDocumentSettings>
<o:AllowPNG/>
</o:OfficeDocumentSettings>
</xml><![endif]--><br />
<!--[if gte mso 9]><xml>
<w:WordDocument>
<w:View>Normal</w:View>
<w:Zoom>0</w:Zoom>
<w:TrackMoves/>
<w:TrackFormatting/>
<w:PunctuationKerning/>
<w:ValidateAgainstSchemas/>
<w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>
<w:IgnoreMixedContent>false</w:IgnoreMixedContent>
<w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>
<w:DoNotPromoteQF/>
<w:LidThemeOther>EN-US</w:LidThemeOther>
<w:LidThemeAsian>X-NONE</w:LidThemeAsian>
<w:LidThemeComplexScript>AR-SA</w:LidThemeComplexScript>
<w:Compatibility>
<w:BreakWrappedTables/>
<w:SnapToGridInCell/>
<w:WrapTextWithPunct/>
<w:UseAsianBreakRules/>
<w:DontGrowAutofit/>
<w:SplitPgBreakAndParaMark/>
<w:EnableOpenTypeKerning/>
<w:DontFlipMirrorIndents/>
<w:OverrideTableStyleHps/>
</w:Compatibility>
<m:mathPr>
<m:mathFont m:val="Cambria Math"/>
<m:brkBin m:val="before"/>
<m:brkBinSub m:val="--"/>
<m:smallFrac m:val="off"/>
<m:dispDef/>
<m:lMargin m:val="0"/>
<m:rMargin m:val="0"/>
<m:defJc m:val="centerGroup"/>
<m:wrapIndent m:val="1440"/>
<m:intLim m:val="subSup"/>
<m:naryLim m:val="undOvr"/>
</m:mathPr></w:WordDocument>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:LatentStyles DefLockedState="false" DefUnhideWhenUsed="true"
DefSemiHidden="true" DefQFormat="false" DefPriority="99"
LatentStyleCount="267">
<w:LsdException Locked="false" Priority="0" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Normal"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="heading 1"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 2"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 3"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 4"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 5"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 6"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 7"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 8"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 9"/>
<w:LsdException Locked="false" Priority="39" Name="toc 1"/>
<w:LsdException Locked="false" Priority="39" Name="toc 2"/>
<w:LsdException Locked="false" Priority="39" Name="toc 3"/>
<w:LsdException Locked="false" Priority="39" Name="toc 4"/>
<w:LsdException Locked="false" Priority="39" Name="toc 5"/>
<w:LsdException Locked="false" Priority="39" Name="toc 6"/>
<w:LsdException Locked="false" Priority="39" Name="toc 7"/>
<w:LsdException Locked="false" Priority="39" Name="toc 8"/>
<w:LsdException Locked="false" Priority="39" Name="toc 9"/>
<w:LsdException Locked="false" Priority="35" QFormat="true" Name="caption"/>
<w:LsdException Locked="false" Priority="10" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Title"/>
<w:LsdException Locked="false" Priority="1" Name="Default Paragraph Font"/>
<w:LsdException Locked="false" Priority="11" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Subtitle"/>
<w:LsdException Locked="false" Priority="22" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Strong"/>
<w:LsdException Locked="false" Priority="20" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Emphasis"/>
<w:LsdException Locked="false" Priority="59" SemiHidden="false"
UnhideWhenUsed="false" Name="Table Grid"/>
<w:LsdException Locked="false" UnhideWhenUsed="false" Name="Placeholder Text"/>
<w:LsdException Locked="false" Priority="1" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="No Spacing"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 1"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 1"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 1"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 1"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 1"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 1"/>
<w:LsdException Locked="false" UnhideWhenUsed="false" Name="Revision"/>
<w:LsdException Locked="false" Priority="34" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="List Paragraph"/>
<w:LsdException Locked="false" Priority="29" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Quote"/>
<w:LsdException Locked="false" Priority="30" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Intense Quote"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 1"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 1"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 1"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 1"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 1"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 1"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 1"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 1"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 2"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 2"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 2"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 2"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 2"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 2"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 2"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 2"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 2"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 2"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 2"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 2"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 2"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 2"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 3"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 3"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 3"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 3"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 3"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 3"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 3"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 3"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 3"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 3"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 3"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 3"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 3"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 3"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 4"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 4"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 4"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 4"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 4"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 4"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 4"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 4"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 4"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 4"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 4"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 4"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 4"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 4"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 5"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 5"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 5"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 5"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 5"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 5"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 5"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 5"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 5"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 5"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 5"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 5"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 5"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 5"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 6"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 6"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 6"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 6"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 6"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 6"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 6"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 6"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 6"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 6"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 6"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 6"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 6"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 6"/>
<w:LsdException Locked="false" Priority="19" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Subtle Emphasis"/>
<w:LsdException Locked="false" Priority="21" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Intense Emphasis"/>
<w:LsdException Locked="false" Priority="31" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Subtle Reference"/>
<w:LsdException Locked="false" Priority="32" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Intense Reference"/>
<w:LsdException Locked="false" Priority="33" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Book Title"/>
<w:LsdException Locked="false" Priority="37" Name="Bibliography"/>
<w:LsdException Locked="false" Priority="39" QFormat="true" Name="TOC Heading"/>
</w:LatentStyles>
</xml><![endif]--><!--[if gte mso 10]>
<style>
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-priority:99;
mso-style-parent:"";
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-para-margin-top:0in;
mso-para-margin-right:0in;
mso-para-margin-bottom:10.0pt;
mso-para-margin-left:0in;
line-height:115%;
mso-pagination:widow-orphan;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;}
table.MsoTableLightShading
{mso-style-name:"Light Shading";
mso-tstyle-rowband-size:1;
mso-tstyle-colband-size:1;
mso-style-priority:60;
mso-style-unhide:no;
border-top:solid black 1.0pt;
mso-border-top-themecolor:text1;
border-left:none;
border-bottom:solid black 1.0pt;
mso-border-bottom-themecolor:text1;
border-right:none;
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-para-margin:0in;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;
color:black;
mso-themecolor:text1;
mso-themeshade:191;}
table.MsoTableLightShadingFirstRow
{mso-style-name:"Light Shading";
mso-table-condition:first-row;
mso-style-priority:60;
mso-style-unhide:no;
mso-tstyle-border-top:1.0pt solid black;
mso-tstyle-border-top-themecolor:text1;
mso-tstyle-border-left:cell-none;
mso-tstyle-border-bottom:1.0pt solid black;
mso-tstyle-border-bottom-themecolor:text1;
mso-tstyle-border-right:cell-none;
mso-tstyle-border-insideh:cell-none;
mso-tstyle-border-insidev:cell-none;
mso-para-margin-top:0in;
mso-para-margin-bottom:0in;
mso-para-margin-bottom:.0001pt;
line-height:normal;
mso-ansi-font-weight:bold;
mso-bidi-font-weight:bold;}
table.MsoTableLightShadingLastRow
{mso-style-name:"Light Shading";
mso-table-condition:last-row;
mso-style-priority:60;
mso-style-unhide:no;
mso-tstyle-border-top:1.0pt solid black;
mso-tstyle-border-top-themecolor:text1;
mso-tstyle-border-left:cell-none;
mso-tstyle-border-bottom:1.0pt solid black;
mso-tstyle-border-bottom-themecolor:text1;
mso-tstyle-border-right:cell-none;
mso-tstyle-border-insideh:cell-none;
mso-tstyle-border-insidev:cell-none;
mso-para-margin-top:0in;
mso-para-margin-bottom:0in;
mso-para-margin-bottom:.0001pt;
line-height:normal;
mso-ansi-font-weight:bold;
mso-bidi-font-weight:bold;}
table.MsoTableLightShadingFirstCol
{mso-style-name:"Light Shading";
mso-table-condition:first-column;
mso-style-priority:60;
mso-style-unhide:no;
mso-ansi-font-weight:bold;
mso-bidi-font-weight:bold;}
table.MsoTableLightShadingLastCol
{mso-style-name:"Light Shading";
mso-table-condition:last-column;
mso-style-priority:60;
mso-style-unhide:no;
mso-ansi-font-weight:bold;
mso-bidi-font-weight:bold;}
table.MsoTableLightShadingOddColumn
{mso-style-name:"Light Shading";
mso-table-condition:odd-column;
mso-style-priority:60;
mso-style-unhide:no;
mso-tstyle-shading:silver;
mso-tstyle-shading-themecolor:text1;
mso-tstyle-shading-themetint:63;
mso-tstyle-border-left:cell-none;
mso-tstyle-border-right:cell-none;
mso-tstyle-border-insideh:cell-none;
mso-tstyle-border-insidev:cell-none;}
table.MsoTableLightShadingOddRow
{mso-style-name:"Light Shading";
mso-table-condition:odd-row;
mso-style-priority:60;
mso-style-unhide:no;
mso-tstyle-shading:silver;
mso-tstyle-shading-themecolor:text1;
mso-tstyle-shading-themetint:63;
mso-tstyle-border-left:cell-none;
mso-tstyle-border-right:cell-none;
mso-tstyle-border-insideh:cell-none;
mso-tstyle-border-insidev:cell-none;}
</style>
<![endif]-->
<br />
<table border="1" cellpadding="0" cellspacing="0" class="MsoTableLightShading" style="border-collapse: collapse; border: none; mso-border-bottom-alt: solid black 1.0pt; mso-border-bottom-themecolor: text1; mso-border-top-alt: solid black 1.0pt; mso-border-top-themecolor: text1; mso-padding-alt: 0in 5.4pt 0in 5.4pt; mso-yfti-tbllook: 1184;">
<tbody>
<tr style="height: 13.55pt; mso-yfti-firstrow: yes; mso-yfti-irow: -1;">
<td style="border-bottom: black; border-left: windowtext; border-right: windowtext; border-style: solid; border-top: black; border-width: 1.0pt; height: 13.55pt; mso-border-bottom-alt: black 1.0pt; mso-border-bottom-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-left-alt: windowtext .5pt; mso-border-right-alt: windowtext .5pt; mso-border-style-alt: solid; mso-border-top-alt: black 1.0pt; mso-border-top-themecolor: text1; mso-border-top-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 130.5pt;" width="174"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-yfti-cnfc: 5; text-align: center;">
<b><span style="color: red; font-family: "times new roman" , "serif"; font-size: 12.0pt;">Functionality</span></b></div>
</td>
<td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: solid black 1.0pt; height: 13.55pt; mso-border-bottom-alt: black 1.0pt; mso-border-bottom-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid windowtext .5pt; mso-border-left-alt: windowtext .5pt; mso-border-right-alt: windowtext .5pt; mso-border-style-alt: solid; mso-border-top-alt: black 1.0pt; mso-border-top-themecolor: text1; mso-border-top-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 99.0pt;" width="132"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-yfti-cnfc: 1; text-align: center;">
<b><span style="color: red; font-family: "times new roman" , "serif"; font-size: 12.0pt;">Shortcut</span></b></div>
</td>
</tr>
<tr style="height: 16.6pt; mso-yfti-irow: 0;">
<td style="background: silver; border-bottom: none; border-left: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; border-top: none; height: 16.6pt; mso-background-themecolor: text1; mso-background-themetint: 63; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 130.5pt;" width="174"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-yfti-cnfc: 68;">
<b><span style="color: black; font-family: "times new roman" , "serif"; font-size: 12.0pt;">Clear Field</span></b></div>
</td>
<td style="background: silver; border-right: solid windowtext 1.0pt; border: none; height: 16.6pt; mso-background-themecolor: text1; mso-background-themetint: 63; mso-border-left-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 99.0pt;" width="132"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-yfti-cnfc: 64; text-align: center;">
<span style="color: black; font-family: "times new roman" , "serif"; font-size: 12.0pt;">F5</span></div>
</td>
</tr>
<tr style="height: 17.5pt; mso-yfti-irow: 1;">
<td style="border-bottom: none; border-left: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; border-top: none; height: 17.5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 130.5pt;" width="174"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-yfti-cnfc: 4;">
<b><span style="color: black; font-family: "times new roman" , "serif"; font-size: 12.0pt;">Clear Form</span></b></div>
</td>
<td style="border-right: solid windowtext 1.0pt; border: none; height: 17.5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 99.0pt;" width="132"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: center;">
<span style="color: black; font-family: "times new roman" , "serif"; font-size: 12.0pt;">F8</span></div>
</td>
</tr>
<tr style="height: 17.5pt; mso-yfti-irow: 2;">
<td style="background: silver; border-bottom: none; border-left: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; border-top: none; height: 17.5pt; mso-background-themecolor: text1; mso-background-themetint: 63; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 130.5pt;" width="174"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-yfti-cnfc: 68;">
<b><span style="color: black; font-family: "times new roman" , "serif"; font-size: 12.0pt;">Clear Record</span></b></div>
</td>
<td style="background: silver; border-right: solid windowtext 1.0pt; border: none; height: 17.5pt; mso-background-themecolor: text1; mso-background-themetint: 63; mso-border-left-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 99.0pt;" width="132"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-yfti-cnfc: 64; text-align: center;">
<span style="color: black; font-family: "times new roman" , "serif"; font-size: 12.0pt;">F6</span></div>
</td>
</tr>
<tr style="height: 17.5pt; mso-yfti-irow: 3;">
<td style="border-bottom: none; border-left: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; border-top: none; height: 17.5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 130.5pt;" width="174"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-yfti-cnfc: 4;">
<b><span style="color: black; font-family: "times new roman" , "serif"; font-size: 12.0pt;">Clear Block</span></b></div>
</td>
<td style="border-right: solid windowtext 1.0pt; border: none; height: 17.5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 99.0pt;" width="132"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: center;">
<span style="color: black; font-family: "times new roman" , "serif"; font-size: 12.0pt;">F7</span></div>
</td>
</tr>
<tr style="height: 17.5pt; mso-yfti-irow: 4;">
<td style="background: silver; border-bottom: none; border-left: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; border-top: none; height: 17.5pt; mso-background-themecolor: text1; mso-background-themetint: 63; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 130.5pt;" width="174"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-yfti-cnfc: 68;">
<b><span style="color: black; font-family: "times new roman" , "serif"; font-size: 12.0pt;">Delete Record</span></b></div>
</td>
<td style="background: silver; border-right: solid windowtext 1.0pt; border: none; height: 17.5pt; mso-background-themecolor: text1; mso-background-themetint: 63; mso-border-left-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 99.0pt;" width="132"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-yfti-cnfc: 64; text-align: center;">
<span style="color: black; font-family: "times new roman" , "serif"; font-size: 12.0pt;">Ctrl+↑</span></div>
</td>
</tr>
<tr style="height: 17.5pt; mso-yfti-irow: 5;">
<td style="border-bottom: none; border-left: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; border-top: none; height: 17.5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 130.5pt;" width="174"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-yfti-cnfc: 4;">
<b><span style="color: black; font-family: "times new roman" , "serif"; font-size: 12.0pt;">Commit / Save</span></b></div>
</td>
<td style="border-right: solid windowtext 1.0pt; border: none; height: 17.5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 99.0pt;" width="132"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: center;">
<span style="color: black; font-family: "times new roman" , "serif"; font-size: 12.0pt;">Ctrl+S</span></div>
</td>
</tr>
<tr style="height: 17.5pt; mso-yfti-irow: 6;">
<td style="background: silver; border-bottom: none; border-left: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; border-top: none; height: 17.5pt; mso-background-themecolor: text1; mso-background-themetint: 63; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 130.5pt;" width="174"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-yfti-cnfc: 68;">
<b><span style="color: black; font-family: "times new roman" , "serif"; font-size: 12.0pt;">Down</span></b></div>
</td>
<td style="background: silver; border-right: solid windowtext 1.0pt; border: none; height: 17.5pt; mso-background-themecolor: text1; mso-background-themetint: 63; mso-border-left-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 99.0pt;" width="132"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-yfti-cnfc: 64; text-align: center;">
<span style="color: black; font-family: "times new roman" , "serif"; font-size: 12.0pt;">↓</span></div>
</td>
</tr>
<tr style="height: 17.5pt; mso-yfti-irow: 7;">
<td style="border-bottom: none; border-left: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; border-top: none; height: 17.5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 130.5pt;" width="174"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-yfti-cnfc: 4;">
<b><span style="color: black; font-family: "times new roman" , "serif"; font-size: 12.0pt;">Duplicate Field</span></b></div>
</td>
<td style="border-right: solid windowtext 1.0pt; border: none; height: 17.5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 99.0pt;" width="132"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: center;">
<span style="color: black; font-family: "times new roman" , "serif"; font-size: 12.0pt;">Shift+F5</span></div>
</td>
</tr>
<tr style="height: 17.5pt; mso-yfti-irow: 8;">
<td style="background: silver; border-bottom: none; border-left: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; border-top: none; height: 17.5pt; mso-background-themecolor: text1; mso-background-themetint: 63; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 130.5pt;" width="174"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-yfti-cnfc: 68;">
<b><span style="color: black; font-family: "times new roman" , "serif"; font-size: 12.0pt;">Duplicate Record</span></b></div>
</td>
<td style="background: silver; border-right: solid windowtext 1.0pt; border: none; height: 17.5pt; mso-background-themecolor: text1; mso-background-themetint: 63; mso-border-left-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 99.0pt;" width="132"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-yfti-cnfc: 64; text-align: center;">
<span style="color: black; font-family: "times new roman" , "serif"; font-size: 12.0pt;">Shift+F6</span></div>
</td>
</tr>
<tr style="height: 17.5pt; mso-yfti-irow: 9;">
<td style="border-bottom: none; border-left: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; border-top: none; height: 17.5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 130.5pt;" width="174"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-yfti-cnfc: 4;">
<b><span style="color: black; font-family: "times new roman" , "serif"; font-size: 12.0pt;">Edit</span></b></div>
</td>
<td style="border-right: solid windowtext 1.0pt; border: none; height: 17.5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 99.0pt;" width="132"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: center;">
<span style="color: black; font-family: "times new roman" , "serif"; font-size: 12.0pt;">Ctrl+E</span></div>
</td>
</tr>
<tr style="height: 17.5pt; mso-yfti-irow: 10;">
<td style="background: silver; border-bottom: none; border-left: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; border-top: none; height: 17.5pt; mso-background-themecolor: text1; mso-background-themetint: 63; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 130.5pt;" width="174"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-yfti-cnfc: 68;">
<b><span style="color: black; font-family: "times new roman" , "serif"; font-size: 12.0pt;">Enter Query Mode</span></b></div>
</td>
<td style="background: silver; border-right: solid windowtext 1.0pt; border: none; height: 17.5pt; mso-background-themecolor: text1; mso-background-themetint: 63; mso-border-left-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 99.0pt;" width="132"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-yfti-cnfc: 64; text-align: center;">
<span style="color: black; font-family: "times new roman" , "serif"; font-size: 12.0pt;">F11</span></div>
</td>
</tr>
<tr style="height: 17.5pt; mso-yfti-irow: 11;">
<td style="border-bottom: none; border-left: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; border-top: none; height: 17.5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 130.5pt;" width="174"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-yfti-cnfc: 4;">
<b><span style="color: black; font-family: "times new roman" , "serif"; font-size: 12.0pt;">Execute Query</span></b></div>
</td>
<td style="border-right: solid windowtext 1.0pt; border: none; height: 17.5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 99.0pt;" width="132"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: center;">
<span style="color: black; font-family: "times new roman" , "serif"; font-size: 12.0pt;">Ctrl+F11</span></div>
</td>
</tr>
<tr style="height: 17.5pt; mso-yfti-irow: 12;">
<td style="background: silver; border-bottom: none; border-left: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; border-top: none; height: 17.5pt; mso-background-themecolor: text1; mso-background-themetint: 63; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 130.5pt;" width="174"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-yfti-cnfc: 68;">
<b><span style="color: black; font-family: "times new roman" , "serif"; font-size: 12.0pt;">Insert Record</span></b></div>
</td>
<td style="background: silver; border-right: solid windowtext 1.0pt; border: none; height: 17.5pt; mso-background-themecolor: text1; mso-background-themetint: 63; mso-border-left-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 99.0pt;" width="132"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-yfti-cnfc: 64; text-align: center;">
<span style="color: black; font-family: "times new roman" , "serif"; font-size: 12.0pt;">Ctrl+↓</span></div>
</td>
</tr>
<tr style="height: 17.5pt; mso-yfti-irow: 13;">
<td style="border-bottom: none; border-left: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; border-top: none; height: 17.5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 130.5pt;" width="174"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-yfti-cnfc: 4;">
<b><span style="color: black; font-family: "times new roman" , "serif"; font-size: 12.0pt;">List of Values</span></b></div>
</td>
<td style="border-right: solid windowtext 1.0pt; border: none; height: 17.5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 99.0pt;" width="132"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: center;">
<span style="color: black; font-family: "times new roman" , "serif"; font-size: 12.0pt;">Ctrl+L</span></div>
</td>
</tr>
<tr style="height: 17.5pt; mso-yfti-irow: 14;">
<td style="background: silver; border-bottom: none; border-left: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; border-top: none; height: 17.5pt; mso-background-themecolor: text1; mso-background-themetint: 63; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 130.5pt;" width="174"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-yfti-cnfc: 68;">
<b><span style="color: black; font-family: "times new roman" , "serif"; font-size: 12.0pt;">Next Block</span></b></div>
</td>
<td style="background: silver; border-right: solid windowtext 1.0pt; border: none; height: 17.5pt; mso-background-themecolor: text1; mso-background-themetint: 63; mso-border-left-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 99.0pt;" width="132"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-yfti-cnfc: 64; text-align: center;">
<span style="color: black; font-family: "times new roman" , "serif"; font-size: 12.0pt;">Shift+PgDn</span></div>
</td>
</tr>
<tr style="height: 17.5pt; mso-yfti-irow: 15;">
<td style="border-bottom: none; border-left: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; border-top: none; height: 17.5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 130.5pt;" width="174"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-yfti-cnfc: 4;">
<b><span style="color: black; font-family: "times new roman" , "serif"; font-size: 12.0pt;">Previous Block</span></b></div>
</td>
<td style="border-right: solid windowtext 1.0pt; border: none; height: 17.5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 99.0pt;" width="132"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: center;">
<span style="color: black; font-family: "times new roman" , "serif"; font-size: 12.0pt;">Shift+PgUp</span></div>
</td>
</tr>
<tr style="height: 17.5pt; mso-yfti-irow: 16;">
<td style="background: silver; border-bottom: none; border-left: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; border-top: none; height: 17.5pt; mso-background-themecolor: text1; mso-background-themetint: 63; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 130.5pt;" width="174"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-yfti-cnfc: 68;">
<b><span style="color: black; font-family: "times new roman" , "serif"; font-size: 12.0pt;">Next Record</span></b></div>
</td>
<td style="background: silver; border-right: solid windowtext 1.0pt; border: none; height: 17.5pt; mso-background-themecolor: text1; mso-background-themetint: 63; mso-border-left-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 99.0pt;" width="132"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-yfti-cnfc: 64; text-align: center;">
<span style="color: black; font-family: "times new roman" , "serif"; font-size: 12.0pt;">↓</span></div>
</td>
</tr>
<tr style="height: 17.5pt; mso-yfti-irow: 17;">
<td style="border-bottom: none; border-left: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; border-top: none; height: 17.5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 130.5pt;" width="174"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-yfti-cnfc: 4;">
<b><span style="color: black; font-family: "times new roman" , "serif"; font-size: 12.0pt;">Previous Record</span></b></div>
</td>
<td style="border-right: solid windowtext 1.0pt; border: none; height: 17.5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 99.0pt;" width="132"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: center;">
<span style="color: black; font-family: "times new roman" , "serif"; font-size: 12.0pt;">↑</span></div>
</td>
</tr>
<tr style="height: 17.5pt; mso-yfti-irow: 18;">
<td style="background: silver; border-bottom: none; border-left: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; border-top: none; height: 17.5pt; mso-background-themecolor: text1; mso-background-themetint: 63; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 130.5pt;" width="174"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-yfti-cnfc: 68;">
<b><span style="color: black; font-family: "times new roman" , "serif"; font-size: 12.0pt;">Previous Field</span></b></div>
</td>
<td style="background: silver; border-right: solid windowtext 1.0pt; border: none; height: 17.5pt; mso-background-themecolor: text1; mso-background-themetint: 63; mso-border-left-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 99.0pt;" width="132"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-yfti-cnfc: 64; text-align: center;">
<span style="color: black; font-family: "times new roman" , "serif"; font-size: 12.0pt;">Shift-Tab</span></div>
</td>
</tr>
<tr style="height: 17.5pt; mso-yfti-irow: 19;">
<td style="border-bottom: none; border-left: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; border-top: none; height: 17.5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 130.5pt;" width="174"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-yfti-cnfc: 4;">
<b><span style="color: black; font-family: "times new roman" , "serif"; font-size: 12.0pt;">Next Field</span></b></div>
</td>
<td style="border-right: solid windowtext 1.0pt; border: none; height: 17.5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 99.0pt;" width="132"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: center;">
<span style="color: black; font-family: "times new roman" , "serif"; font-size: 12.0pt;">Tab</span></div>
</td>
</tr>
<tr style="height: 17.5pt; mso-yfti-irow: 20;">
<td style="background: silver; border-bottom: none; border-left: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; border-top: none; height: 17.5pt; mso-background-themecolor: text1; mso-background-themetint: 63; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 130.5pt;" width="174"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-yfti-cnfc: 68;">
<b><span style="color: black; font-family: "times new roman" , "serif"; font-size: 12.0pt;">Print</span></b></div>
</td>
<td style="background: silver; border-right: solid windowtext 1.0pt; border: none; height: 17.5pt; mso-background-themecolor: text1; mso-background-themetint: 63; mso-border-left-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 99.0pt;" width="132"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-yfti-cnfc: 64; text-align: center;">
<span style="color: black; font-family: "times new roman" , "serif"; font-size: 12.0pt;">Ctrl+P</span></div>
</td>
</tr>
<tr style="height: 17.5pt; mso-yfti-irow: 21;">
<td style="border-bottom: none; border-left: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; border-top: none; height: 17.5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 130.5pt;" width="174"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-yfti-cnfc: 4;">
<b><span style="color: black; font-family: "times new roman" , "serif"; font-size: 12.0pt;">Scroll Down</span></b></div>
</td>
<td style="border-right: solid windowtext 1.0pt; border: none; height: 17.5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 99.0pt;" width="132"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: center;">
<span style="color: black; font-family: "times new roman" , "serif"; font-size: 12.0pt;">Page Down</span></div>
</td>
</tr>
<tr style="height: 17.5pt; mso-yfti-irow: 22;">
<td style="background: silver; border-bottom: none; border-left: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; border-top: none; height: 17.5pt; mso-background-themecolor: text1; mso-background-themetint: 63; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 130.5pt;" width="174"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-yfti-cnfc: 68;">
<b><span style="color: black; font-family: "times new roman" , "serif"; font-size: 12.0pt;">Scroll Up</span></b></div>
</td>
<td style="background: silver; border-right: solid windowtext 1.0pt; border: none; height: 17.5pt; mso-background-themecolor: text1; mso-background-themetint: 63; mso-border-left-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 99.0pt;" width="132"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-yfti-cnfc: 64; text-align: center;">
<span style="color: black; font-family: "times new roman" , "serif"; font-size: 12.0pt;">Page Up</span></div>
</td>
</tr>
<tr style="height: 17.5pt; mso-yfti-irow: 23;">
<td style="border-bottom: none; border-left: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; border-top: none; height: 17.5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 130.5pt;" width="174"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-yfti-cnfc: 4;">
<b><span style="color: black; font-family: "times new roman" , "serif"; font-size: 12.0pt;">Show Keys</span></b></div>
</td>
<td style="border-right: solid windowtext 1.0pt; border: none; height: 17.5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 99.0pt;" width="132"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: center;">
<span style="color: black; font-family: "times new roman" , "serif"; font-size: 12.0pt;">Ctrl+K</span></div>
</td>
</tr>
<tr style="height: 17.5pt; mso-yfti-irow: 24; mso-yfti-lastrow: yes;">
<td style="background: silver; border-bottom: solid black 1.0pt; border-left: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; border-top: none; height: 17.5pt; mso-background-themecolor: text1; mso-background-themetint: 63; mso-border-bottom-alt: solid black 1.0pt; mso-border-bottom-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 130.5pt;" width="174"><div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-yfti-cnfc: 68;">
<b><span style="color: black; font-family: "times new roman" , "serif"; font-size: 12.0pt;">Exit</span></b></div>
</td>
<td style="background: silver; border-bottom: solid black 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 17.5pt; mso-background-themecolor: text1; mso-background-themetint: 63; mso-border-bottom-alt: solid black 1.0pt; mso-border-bottom-themecolor: text1; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 99.0pt;" width="132"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-yfti-cnfc: 64; text-align: center;">
<span style="color: black; font-family: "times new roman" , "serif"; font-size: 12.0pt;">F4</span></div>
</td>
</tr>
</tbody></table>
<!--[if gte mso 9]><xml>
<w:WordDocument>
<w:View>Normal</w:View>
<w:Zoom>0</w:Zoom>
<w:TrackMoves/>
<w:TrackFormatting/>
<w:PunctuationKerning/>
<w:ValidateAgainstSchemas/>
<w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>
<w:IgnoreMixedContent>false</w:IgnoreMixedContent>
<w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>
<w:DoNotPromoteQF/>
<w:LidThemeOther>EN-US</w:LidThemeOther>
<w:LidThemeAsian>X-NONE</w:LidThemeAsian>
<w:LidThemeComplexScript>AR-SA</w:LidThemeComplexScript>
<w:Compatibility>
<w:BreakWrappedTables/>
<w:SnapToGridInCell/>
<w:WrapTextWithPunct/>
<w:UseAsianBreakRules/>
<w:DontGrowAutofit/>
<w:SplitPgBreakAndParaMark/>
<w:EnableOpenTypeKerning/>
<w:DontFlipMirrorIndents/>
<w:OverrideTableStyleHps/>
</w:Compatibility>
<m:mathPr>
<m:mathFont m:val="Cambria Math"/>
<m:brkBin m:val="before"/>
<m:brkBinSub m:val="--"/>
<m:smallFrac m:val="off"/>
<m:dispDef/>
<m:lMargin m:val="0"/>
<m:rMargin m:val="0"/>
<m:defJc m:val="centerGroup"/>
<m:wrapIndent m:val="1440"/>
<m:intLim m:val="subSup"/>
<m:naryLim m:val="undOvr"/>
</m:mathPr></w:WordDocument>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:LatentStyles DefLockedState="false" DefUnhideWhenUsed="true"
DefSemiHidden="true" DefQFormat="false" DefPriority="99"
LatentStyleCount="267">
<w:LsdException Locked="false" Priority="0" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Normal"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="heading 1"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 2"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 3"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 4"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 5"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 6"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 7"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 8"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 9"/>
<w:LsdException Locked="false" Priority="39" Name="toc 1"/>
<w:LsdException Locked="false" Priority="39" Name="toc 2"/>
<w:LsdException Locked="false" Priority="39" Name="toc 3"/>
<w:LsdException Locked="false" Priority="39" Name="toc 4"/>
<w:LsdException Locked="false" Priority="39" Name="toc 5"/>
<w:LsdException Locked="false" Priority="39" Name="toc 6"/>
<w:LsdException Locked="false" Priority="39" Name="toc 7"/>
<w:LsdException Locked="false" Priority="39" Name="toc 8"/>
<w:LsdException Locked="false" Priority="39" Name="toc 9"/>
<w:LsdException Locked="false" Priority="35" QFormat="true" Name="caption"/>
<w:LsdException Locked="false" Priority="10" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Title"/>
<w:LsdException Locked="false" Priority="1" Name="Default Paragraph Font"/>
<w:LsdException Locked="false" Priority="11" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Subtitle"/>
<w:LsdException Locked="false" Priority="22" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Strong"/>
<w:LsdException Locked="false" Priority="20" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Emphasis"/>
<w:LsdException Locked="false" Priority="59" SemiHidden="false"
UnhideWhenUsed="false" Name="Table Grid"/>
<w:LsdException Locked="false" UnhideWhenUsed="false" Name="Placeholder Text"/>
<w:LsdException Locked="false" Priority="1" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="No Spacing"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 1"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 1"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 1"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 1"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 1"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 1"/>
<w:LsdException Locked="false" UnhideWhenUsed="false" Name="Revision"/>
<w:LsdException Locked="false" Priority="34" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="List Paragraph"/>
<w:LsdException Locked="false" Priority="29" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Quote"/>
<w:LsdException Locked="false" Priority="30" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Intense Quote"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 1"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 1"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 1"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 1"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 1"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 1"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 1"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 1"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 2"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 2"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 2"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 2"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 2"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 2"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 2"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 2"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 2"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 2"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 2"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 2"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 2"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 2"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 3"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 3"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 3"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 3"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 3"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 3"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 3"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 3"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 3"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 3"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 3"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 3"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 3"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 3"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 4"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 4"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 4"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 4"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 4"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 4"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 4"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 4"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 4"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 4"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 4"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 4"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 4"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 4"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 5"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 5"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 5"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 5"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 5"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 5"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 5"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 5"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 5"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 5"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 5"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 5"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 5"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 5"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 6"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 6"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 6"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 6"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 6"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 6"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 6"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 6"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 6"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 6"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 6"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 6"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 6"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 6"/>
<w:LsdException Locked="false" Priority="19" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Subtle Emphasis"/>
<w:LsdException Locked="false" Priority="21" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Intense Emphasis"/>
<w:LsdException Locked="false" Priority="31" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Subtle Reference"/>
<w:LsdException Locked="false" Priority="32" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Intense Reference"/>
<w:LsdException Locked="false" Priority="33" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Book Title"/>
<w:LsdException Locked="false" Priority="37" Name="Bibliography"/>
<w:LsdException Locked="false" Priority="39" QFormat="true" Name="TOC Heading"/>
</w:LatentStyles>
</xml><![endif]--><!--[if gte mso 10]>
<style>
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-priority:99;
mso-style-parent:"";
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-para-margin-top:0in;
mso-para-margin-right:0in;
mso-para-margin-bottom:10.0pt;
mso-para-margin-left:0in;
line-height:115%;
mso-pagination:widow-orphan;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;}
table.MsoTableLightShading
{mso-style-name:"Light Shading";
mso-tstyle-rowband-size:1;
mso-tstyle-colband-size:1;
mso-style-priority:60;
mso-style-unhide:no;
border-top:solid black 1.0pt;
mso-border-top-themecolor:text1;
border-left:none;
border-bottom:solid black 1.0pt;
mso-border-bottom-themecolor:text1;
border-right:none;
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-para-margin:0in;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;
color:black;
mso-themecolor:text1;
mso-themeshade:191;}
table.MsoTableLightShadingFirstRow
{mso-style-name:"Light Shading";
mso-table-condition:first-row;
mso-style-priority:60;
mso-style-unhide:no;
mso-tstyle-border-top:1.0pt solid black;
mso-tstyle-border-top-themecolor:text1;
mso-tstyle-border-left:cell-none;
mso-tstyle-border-bottom:1.0pt solid black;
mso-tstyle-border-bottom-themecolor:text1;
mso-tstyle-border-right:cell-none;
mso-tstyle-border-insideh:cell-none;
mso-tstyle-border-insidev:cell-none;
mso-para-margin-top:0in;
mso-para-margin-bottom:0in;
mso-para-margin-bottom:.0001pt;
line-height:normal;
mso-ansi-font-weight:bold;
mso-bidi-font-weight:bold;}
table.MsoTableLightShadingLastRow
{mso-style-name:"Light Shading";
mso-table-condition:last-row;
mso-style-priority:60;
mso-style-unhide:no;
mso-tstyle-border-top:1.0pt solid black;
mso-tstyle-border-top-themecolor:text1;
mso-tstyle-border-left:cell-none;
mso-tstyle-border-bottom:1.0pt solid black;
mso-tstyle-border-bottom-themecolor:text1;
mso-tstyle-border-right:cell-none;
mso-tstyle-border-insideh:cell-none;
mso-tstyle-border-insidev:cell-none;
mso-para-margin-top:0in;
mso-para-margin-bottom:0in;
mso-para-margin-bottom:.0001pt;
line-height:normal;
mso-ansi-font-weight:bold;
mso-bidi-font-weight:bold;}
table.MsoTableLightShadingFirstCol
{mso-style-name:"Light Shading";
mso-table-condition:first-column;
mso-style-priority:60;
mso-style-unhide:no;
mso-ansi-font-weight:bold;
mso-bidi-font-weight:bold;}
table.MsoTableLightShadingLastCol
{mso-style-name:"Light Shading";
mso-table-condition:last-column;
mso-style-priority:60;
mso-style-unhide:no;
mso-ansi-font-weight:bold;
mso-bidi-font-weight:bold;}
table.MsoTableLightShadingOddColumn
{mso-style-name:"Light Shading";
mso-table-condition:odd-column;
mso-style-priority:60;
mso-style-unhide:no;
mso-tstyle-shading:silver;
mso-tstyle-shading-themecolor:text1;
mso-tstyle-shading-themetint:63;
mso-tstyle-border-left:cell-none;
mso-tstyle-border-right:cell-none;
mso-tstyle-border-insideh:cell-none;
mso-tstyle-border-insidev:cell-none;}
table.MsoTableLightShadingOddRow
{mso-style-name:"Light Shading";
mso-table-condition:odd-row;
mso-style-priority:60;
mso-style-unhide:no;
mso-tstyle-shading:silver;
mso-tstyle-shading-themecolor:text1;
mso-tstyle-shading-themetint:63;
mso-tstyle-border-left:cell-none;
mso-tstyle-border-right:cell-none;
mso-tstyle-border-insideh:cell-none;
mso-tstyle-border-insidev:cell-none;}
</style>
<![endif]--><br />
<script async="" src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<!-- ad1 -->
<br />
<ins class="adsbygoogle" data-ad-client="ca-pub-4737275012888465" data-ad-format="auto" data-ad-slot="9960433635" style="display: block;"></ins><br />
<br />
Hope you found it useful, feel free to leave a comment if have any note on the subject. </div>
Hammam Muharebhttp://www.blogger.com/profile/06056751064122308940noreply@blogger.com0tag:blogger.com,1999:blog-3747830721977145321.post-73039586991717975112016-03-15T14:52:00.001-07:002016-03-23T02:50:15.661-07:00How to add the "Duplicate Record" functionality to custom forms<div dir="ltr" style="text-align: left;" trbidi="on">
Salam Alaikum,<br />
<br />
For those who are not familiar with the "Duplicate Record" functionality, it is a standard functionality added to many forms in Oracle Apps (E-Business Suite) to enhance user entry in many standeard forms. It is triggered once the user enters "Shift + F6" in any tabular data block.<br />
<br />
For a list of all Oracle Apps shortcuts please refer to this post:<br />
<div class="PXLWASD-W-m">
<a href="http://technicaloverwhelmed.blogspot.com/2016/03/oracle-apps-shortcut-key-very-useful.html">http://technicaloverwhelmed.blogspot.com/2016/03/oracle-apps-shortcut-key-very-useful.html</a></div>
<br />
And as explained in "<b>Oracle Applications Developer Giude R12</b>" this functionality is disabled by default for the following reasons:<br />
<br />
<ol style="text-align: left;">
<li>The special column ROW_ID is duplicated and must be exempted if it exists.</li>
<li>The record is marked as valid even though the items may contain time-sensitive data that is no longer valid.</li>
<li>Defaults are overridden</li>
<li>It doesnt make sense in many scenrios. </li>
</ol>
<script async="" src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<!-- ad1 -->
<br />
<ins class="adsbygoogle" data-ad-client="ca-pub-4737275012888465" data-ad-format="auto" data-ad-slot="9960433635" style="display: block;"></ins><script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>
<br />
<br />
But in many cases... you might need to add to add it. It is actually pretty simple. And here are the steps to implement it:<br />
<br />
<br />
1. Add the following procedure to the form (you may want to place this code in the Program units), as the following example:<br />
<br />
<blockquote class="tr_bq">
<span style="background-color: #3d85c6;"><span style="background-color: #351c75;"><span style="background-color: #b4a7d6;"></span></span><span style="background-color: #cfe2f3;">PACKAGE BODY xx_block_name<br />IS<br /> PROCEDURE KEY_DUPREC<br /> IS<br /> CURSOR new_primary_key<br /> IS<br /> SELECT block_name_S.NEXTVAL FROM sys.DUAL;<br /> BEGIN<br /> DUPLICATE_RECORD;<br /><br /> OPEN new_primary_key;<br /> FETCH new_primary_key INTO :order.block_id;<br /> CLOSE new_primary_key;<br /><br /> :order.status : = 'New'; --- you can add any fixed valur for the new created record<br /> :order.row_id := null; --- put null for the ROW_ID <br /> END KEY_DUPREC;<br />END xx_block_name;</span></span></blockquote>
<br />
2. Create a trigger "<b>KEY-DUPREC</b>"on the data block level and call procedure created.<br />
<br />
Now, test and remeber to keep the client happy all the time :)<br />
<br />
Hope you found it useful guys, feel free to leave a comment if have any note on the subject. </div>
Hammam Muharebhttp://www.blogger.com/profile/06056751064122308940noreply@blogger.com0tag:blogger.com,1999:blog-3747830721977145321.post-2354664450335772192016-03-12T13:39:00.005-08:002016-03-12T13:43:37.432-08:00About the blog<div dir="ltr" style="text-align: left;" trbidi="on">
Dears,<br />
<br />
<script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<!-- ad1 -->
<ins class="adsbygoogle"
style="display:block"
data-ad-client="ca-pub-4737275012888465"
data-ad-slot="9960433635"
data-ad-format="auto"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>
As it obvious to many of you this blog, is only concerned about sharing some knowldedge about Oracle Application (especially Oracle E-Business suite R12) on multiple subjects and multiple areas that i have worked on. You can find many code example and queries that you can use and benefit from, each explained in every post.<br />
<br />
I am sorry for not being able to add more posts lately but i promise you i will do my best to get back to sharing my knowledge with you...<br />
<br />
Thanks for visiting, and please if you have any ideas or questions, don't hesitate to contact me, i will be glad to help if i can...<br />
<br />
<br /></div>
Hammam Muharebhttp://www.blogger.com/profile/06056751064122308940noreply@blogger.com0tag:blogger.com,1999:blog-3747830721977145321.post-10580448479250787992015-01-26T07:18:00.001-08:002015-10-21T05:31:33.434-07:00How to Link an Alert with a simple Workflow to send notifications<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<!-- first add header -->
<ins class="adsbygoogle"
style="display:block"
data-ad-client="ca-pub-4737275012888465"
data-ad-slot="5283782836"
data-ad-format="auto"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>
<div dir="ltr" style="text-align: left;" trbidi="on">
Salam Alaikum,<br />
<br />
There is a needed requirement in many projects for the users to get notified once a business event occurs. And that can be easily covered by an Alert, if the business is for the users to receive emails once the event happens, explaining the event and providing needed information about it to the users.<br />
<br />
But another popular requirement is for the user to receive notifications via a workflow (Worklist notifications).<br />
<br />
It can be done easily using an Alert along with a simple Workflow. And here is how....<br />
<br />
<b> First Step:</b><br />
<b> Create a simple Workflow like the one shown in the screenshot below.</b><br />
<b>(the workflow should at least have one process, one notification , one message and two attributes)</b><br />
<b></b><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgP8D6c5UNMAvr1MMH1bCHHS20tPY9DxKNq3jYo1pp8pmjJyDj9oeGxPOHJrsQP9km5KYp0CUaLRkh-Upi4FeoryAddhOedkGJk7ULRVhq5ZeaqtG21dwbH-d_MLhEzptLzGJmSmIZKowVd/s1600/screenshot.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="187" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgP8D6c5UNMAvr1MMH1bCHHS20tPY9DxKNq3jYo1pp8pmjJyDj9oeGxPOHJrsQP9km5KYp0CUaLRkh-Upi4FeoryAddhOedkGJk7ULRVhq5ZeaqtG21dwbH-d_MLhEzptLzGJmSmIZKowVd/s1600/screenshot.jpg" width="320" /></a></div>
<br />
The workflow should have the attributes <b>(P_NOTE_TITLE,XX_MESSAGE_BODY - both are the internal names of the attributes)</b> to fill the notification with the business case information that the user will receive.<br />
<br />
And of course, you have to save the workflow on the database.<br />
<br />
<b>Second Step:</b><br />
<b> We should create the alert that should trigger once the business event occurs.</b><br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjjL0CdHs4hgTL7J90X-X7a3GvGIu7ihstJPNdtoY2YWYR8XzwnqTkvT7jZNbDFgaef3qG7tRfpyX7eZXkfr5NAzaBrfM-4BSjyluSrR5m7lSpmrYktIA4o0RRS4QfLhx8nzKoM_TPasCam/s1600/alert.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="215" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjjL0CdHs4hgTL7J90X-X7a3GvGIu7ihstJPNdtoY2YWYR8XzwnqTkvT7jZNbDFgaef3qG7tRfpyX7eZXkfr5NAzaBrfM-4BSjyluSrR5m7lSpmrYktIA4o0RRS4QfLhx8nzKoM_TPasCam/s1600/alert.jpg" width="320" /></a></div>
<br />
<br />
<br />
<br />
<br />
Please note that the alert select statement should include the subject of the notification and notification body (message) you want to be sent to the users.<br />
<br />
<br />
<b>Third Step:</b><br />
<b>In the created Alert you should create an </b><b><b>action of type </b>SQL statement script that calls the procedure that runs the workflow created in first step.</b><br />
<br />
And the script should be a call to a function on the database that start the workflow process.<br />
<br />
<br />
<blockquote class="tr_bq">
<span style="background-color: #d9d2e9;"><span style="color: #20124d;"><span style="font-family: "Courier New",Courier,monospace;">execute XX_SIMPLE_NOTIFICATION.XX_SEND_MULTI_NOTES ( 'send Not' , '&p_message' , '&p_title' );<br />/</span></span></span><b><br /></b></blockquote>
And on the database level, the procedure should look like this:<br />
<br />
<br />
<blockquote>
<span style="background-color: #20124d;"><span style="color: #ead1dc;"><span style="font-family: "Courier New",Courier,monospace;"><span style="color: #20124d;"><span style="background-color: #ead1dc;"> procedure XX_SEND_MULTI_NOTES ( </span></span></span></span></span><span style="background-color: #20124d;"><span style="color: #ead1dc;"><span style="font-family: "Courier New",Courier,monospace;"><span style="color: #20124d;"><span style="background-color: #ead1dc;"> P_action_name varchar2 , </span></span></span></span></span><br />
<span style="background-color: #20124d;"><span style="color: #ead1dc;"><span style="font-family: "Courier New",Courier,monospace;"><span style="color: #20124d;"><span style="background-color: #ead1dc;"> P_MESSAGE varchar2 , </span></span></span></span></span><br />
<span style="background-color: #20124d;"><span style="color: #ead1dc;"><span style="font-family: "Courier New",Courier,monospace;"><span style="color: #20124d;"><span style="background-color: #ead1dc;"> P_TITLE varchar2 )</span></span></span></span></span><br />
<span style="background-color: #20124d;"><span style="color: #ead1dc;"><span style="font-family: "Courier New",Courier,monospace;"><span style="color: #20124d;"><span style="background-color: #ead1dc;">Is</span></span></span></span></span><br />
<span style="background-color: #20124d;"><span style="color: #ead1dc;"><span style="font-family: "Courier New",Courier,monospace;"><span style="color: #20124d;"><span style="background-color: #ead1dc;"> V_SEQ NUMBER DEFAULT 0;</span></span></span></span></span><br />
<span style="background-color: #20124d;"><span style="color: #ead1dc;"><span style="font-family: "Courier New",Courier,monospace;"><span style="color: #20124d;"><span style="background-color: #ead1dc;"> Begin</span></span></span></span></span><br />
<span style="background-color: #20124d;"><span style="color: #ead1dc;"><span style="font-family: "Courier New",Courier,monospace;"><span style="color: #20124d;"><span style="background-color: #ead1dc;"></span></span></span></span></span><br />
<span style="background-color: #20124d;"><span style="color: #ead1dc;"><span style="font-family: "Courier New",Courier,monospace;"><span style="color: #20124d;"><span style="background-color: #ead1dc;"> SELECT XX_SIMPLENOTE_WF_S.NEXTVAL INTO V_SEQ FROM DUAL;</span></span></span></span></span><br />
<span style="background-color: #20124d;"><span style="color: #ead1dc;"><span style="font-family: "Courier New",Courier,monospace;"><span style="color: #20124d;"><span style="background-color: #ead1dc;"> </span></span></span></span></span><br />
<span style="background-color: #20124d;"><span style="color: #ead1dc;"><span style="font-family: "Courier New",Courier,monospace;"><span style="color: #20124d;"><span style="background-color: #ead1dc;"> wf_engine.CreateProcess(itemtype => 'XXZNOTE',</span></span></span></span></span><br />
<span style="background-color: #20124d;"><span style="color: #ead1dc;"><span style="font-family: "Courier New",Courier,monospace;"><span style="color: #20124d;"><span style="background-color: #ead1dc;"> itemkey => 'SIMPLE_NTF' || V_SEQ,</span></span></span></span></span><br />
<span style="background-color: #20124d;"><span style="color: #ead1dc;"><span style="font-family: "Courier New",Courier,monospace;"><span style="color: #20124d;"><span style="background-color: #ead1dc;"> process => 'SEND_TO_WAREHOUSE_TEAM');</span></span></span></span></span><br />
<span style="background-color: #20124d;"><span style="color: #ead1dc;"><span style="font-family: "Courier New",Courier,monospace;"><span style="color: #20124d;"><span style="background-color: #ead1dc;"></span></span></span></span></span><br />
<span style="background-color: #20124d;"><span style="color: #ead1dc;"><span style="font-family: "Courier New",Courier,monospace;"><span style="color: #20124d;"><span style="background-color: #ead1dc;"> wf_engine.SetItemAttrTEXT(itemtype => 'XXZNOTE',</span></span></span></span></span><br />
<span style="background-color: #20124d;"><span style="color: #ead1dc;"><span style="font-family: "Courier New",Courier,monospace;"><span style="color: #20124d;"><span style="background-color: #ead1dc;"> itemkey => 'SIMPLE_NTF' || V_SEQ,</span></span></span></span></span><br />
<span style="background-color: #20124d;"><span style="color: #ead1dc;"><span style="font-family: "Courier New",Courier,monospace;"><span style="color: #20124d;"><span style="background-color: #ead1dc;"> aname => 'XX_MESSAGE_BODY',</span></span></span></span></span><br />
<span style="background-color: #20124d;"><span style="color: #ead1dc;"><span style="font-family: "Courier New",Courier,monospace;"><span style="color: #20124d;"><span style="background-color: #ead1dc;"> avalue => replace(P_MESSAGE,'@',chr(10)));</span></span></span></span></span><br />
<span style="background-color: #20124d;"><span style="color: #ead1dc;"><span style="font-family: "Courier New",Courier,monospace;"><span style="color: #20124d;"><span style="background-color: #ead1dc;"> </span></span></span></span></span><br />
<span style="background-color: #20124d;"><span style="color: #ead1dc;"><span style="font-family: "Courier New",Courier,monospace;"><span style="color: #20124d;"><span style="background-color: #ead1dc;"></span></span></span></span></span><br />
<span style="background-color: #20124d;"><span style="color: #ead1dc;"><span style="font-family: "Courier New",Courier,monospace;"><span style="color: #20124d;"><span style="background-color: #ead1dc;"> wf_engine.SetItemAttrTEXT(itemtype => 'XXZNOTE',</span></span></span></span></span><br />
<span style="background-color: #20124d;"><span style="color: #ead1dc;"><span style="font-family: "Courier New",Courier,monospace;"><span style="color: #20124d;"><span style="background-color: #ead1dc;"> itemkey => 'SIMPLE_NTF' || V_SEQ,</span></span></span></span></span><br />
<span style="background-color: #20124d;"><span style="color: #ead1dc;"><span style="font-family: "Courier New",Courier,monospace;"><span style="color: #20124d;"><span style="background-color: #ead1dc;"> aname => 'ACTION_NAME',</span></span></span></span></span><br />
<span style="background-color: #20124d;"><span style="color: #ead1dc;"><span style="font-family: "Courier New",Courier,monospace;"><span style="color: #20124d;"><span style="background-color: #ead1dc;"> avalue => P_action_name);</span></span></span></span></span><br />
<span style="background-color: #20124d;"><span style="color: #ead1dc;"><span style="font-family: "Courier New",Courier,monospace;"><span style="color: #20124d;"><span style="background-color: #ead1dc;"></span></span></span></span></span><br />
<span style="background-color: #20124d;"><span style="color: #ead1dc;"><span style="font-family: "Courier New",Courier,monospace;"><span style="color: #20124d;"><span style="background-color: #ead1dc;"> wf_engine.SetItemAttrTEXT(itemtype => 'XXZNOTE',</span></span></span></span></span><br />
<span style="background-color: #20124d;"><span style="color: #ead1dc;"><span style="font-family: "Courier New",Courier,monospace;"><span style="color: #20124d;"><span style="background-color: #ead1dc;"> itemkey => 'SIMPLE_NTF' || V_SEQ,</span></span></span></span></span><br />
<span style="background-color: #20124d;"><span style="color: #ead1dc;"><span style="font-family: "Courier New",Courier,monospace;"><span style="color: #20124d;"><span style="background-color: #ead1dc;"> aname => 'P_NPTE_TITLE',</span></span></span></span></span><br />
<span style="background-color: #20124d;"><span style="color: #ead1dc;"><span style="font-family: "Courier New",Courier,monospace;"><span style="color: #20124d;"><span style="background-color: #ead1dc;"> avalue => P_TITLE);</span></span></span></span></span><br />
<span style="background-color: #20124d;"><span style="color: #ead1dc;"><span style="font-family: "Courier New",Courier,monospace;"><span style="color: #20124d;"><span style="background-color: #ead1dc;"></span></span></span></span></span><br />
<span style="background-color: #20124d;"><span style="color: #ead1dc;"><span style="font-family: "Courier New",Courier,monospace;"><span style="color: #20124d;"><span style="background-color: #ead1dc;"> </span></span></span></span></span><br />
<span style="background-color: #20124d;"><span style="color: #ead1dc;"><span style="font-family: "Courier New",Courier,monospace;"><span style="color: #20124d;"><span style="background-color: #ead1dc;"> wf_engine.StartProcess(itemtype => 'XXZNOTE',</span></span></span></span></span><br />
<span style="background-color: #20124d;"><span style="color: #ead1dc;"><span style="font-family: "Courier New",Courier,monospace;"><span style="color: #20124d;"><span style="background-color: #ead1dc;"> itemkey => 'SIMPLE_NTF' || V_SEQ);</span></span></span></span></span><br />
<span style="background-color: #20124d;"><span style="color: #ead1dc;"><span style="font-family: "Courier New",Courier,monospace;"><span style="color: #20124d;"><span style="background-color: #ead1dc;"> commit;</span></span></span></span></span><br />
<span style="background-color: #20124d;"><span style="color: #ead1dc;"><span style="font-family: "Courier New",Courier,monospace;"><span style="color: #20124d;"><span style="background-color: #ead1dc;"> </span></span></span></span></span><br />
<span style="background-color: #20124d;"><span style="color: #ead1dc;"><span style="font-family: "Courier New",Courier,monospace;"><span style="color: #20124d;"><span style="background-color: #ead1dc;">End;</span></span></span></span></span><br />
<span style="background-color: #20124d;"><span style="color: #ead1dc;"><span style="font-family: "Courier New",Courier,monospace;"></span></span></span></blockquote>
<br />
And each time the alert gets triggered a notification should be sent to the predefined user that for example in a different attribute with constant value.<br />
<br />
Hope you found it useful guys, feel free to leave a comment if have any note on the subject. </div>
</div>
Hammam Muharebhttp://www.blogger.com/profile/06056751064122308940noreply@blogger.com0tag:blogger.com,1999:blog-3747830721977145321.post-83346445109853101212015-01-11T07:42:00.001-08:002015-01-11T07:43:11.652-08:00API To Create Employee Phone <div dir="ltr" style="text-align: left;" trbidi="on">
Salam Alaikum,<br />
<br />
This is a very simple API that can be used to create phone details for employees. <br />
<blockquote>
<span style="font-family: "Courier New",Courier,monospace;"><span style="background-color: #ead1dc;"><span style="color: #20124d;">DECLARE<br /> ln_phone_id per_phones.phone_id%TYPE;<br /> ln_object_version_number per_phones.object_version_number%TYPE;<br />BEGIN<br />-- Create or Update Employee Phone Detail<br />-- -----------------------------------------------------------<br /> hr_phone_api.create_or_update_phone<br /> ( -- Input data elements<br /> -- -----------------------------<br /> p_date_from => TO_DATE('01-JAN-1900'),<br /> p_phone_type => 'M',<br /> p_phone_number => '0566106406',<br /> p_parent_id => 1102,<br /> p_parent_table => 'PER_ALL_PEOPLE_F',<br /> p_effective_date => TO_DATE('01-JAN-1900'),<br />-- Output data elements<br />-- --------------------------------<br /> p_phone_id => ln_phone_id,<br /> p_object_version_number => ln_object_version_number<br /> );<br /> DBMS_OUTPUT.put_line ('ln_phone_id ' || ln_phone_id);<br />--COMMIT;<br />EXCEPTION<br /> WHEN OTHERS<br /> THEN<br /> ROLLBACK;<br /> DBMS_OUTPUT.put_line (SQLERRM);<br />END;</span></span></span></blockquote>
Hope you found it useful guys, feel free to leave a comment if have any note on the subject. <br />
<br /></div>
Hammam Muharebhttp://www.blogger.com/profile/06056751064122308940noreply@blogger.com0tag:blogger.com,1999:blog-3747830721977145321.post-44733364460355169652015-01-11T07:36:00.003-08:002015-01-11T07:36:40.228-08:00API To Create Establishment (School/College)<div dir="ltr" style="text-align: left;" trbidi="on">
Salam Alaikum,<br />
<br />
Following the API that can be used for creating a Establishment in HR. That Can either be a School or college... etc.<span style="color: red;"><i> <b>Please note that some attributes given in the API may deffer based on the setup.</b></i></span><br />
<br />
<blockquote class="tr_bq">
<span style="font-family: "Courier New",Courier,monospace;"><span style="background-color: #ead1dc;"><span style="color: #20124d;">DECLARE<br /> CURSOR schools<br /> IS<br /> SELECT xx_sch.ROWID,<br /> xx_sch.*<br /> FROM xxx_schools_info xx_sch<br /> WHERE 1 = 1 AND NVL (upload_status, 'N') = 'N';<br /><br /> l_establishment_id per_establishments.establishment_id%TYPE;<br /> l_object_version_number per_establishments.object_version_number%TYPE;<br />BEGIN<br /> FOR i_rec IN schools<br /> LOOP<br /> per_est_ins.ins (p_establishment_id => l_establishment_id,<br /> p_name => i_rec.establishment_name,<br /> p_location => i_rec.LOCATION,<br /> p_attribute_category => NULL,<br /> p_attribute1 => i_rec.country,<br /> p_attribute2 => i_rec.area,<br /> p_attribute3 => i_rec.city,<br /> p_object_version_number => l_object_version_number,<br /> p_validate => FALSE<br /> );<br /><br /> UPDATE xxx_schools_info<br /> SET upload_status = 'Y',<br /> establishment_id = l_establishment_id<br /> WHERE ROWID = i_rec.ROWID;<br /> END LOOP;<br />END; </span></span></span></blockquote>
<br />
As always, feel free to leave a comment if have any note on the subject. </div>
Hammam Muharebhttp://www.blogger.com/profile/06056751064122308940noreply@blogger.com0tag:blogger.com,1999:blog-3747830721977145321.post-17666612579473740872015-01-11T07:29:00.006-08:002015-01-11T07:30:08.474-08:00API To Create Employee Qualification<div dir="ltr" style="text-align: left;" trbidi="on">
Salam Alaikum,<br />
<br />
I share this API, that creates an employee qualification, <i>but please note that it needs that some prerequisites for this API is needed</i>. Like <b>qualification type </b>should be already created and qualification_type_id should be input to the create_qualification API. As for <b>establishment </b>and establishment_id to be input for the API. And lastly, the employee should be an attendant of the establishment and <b>attendance_id </b>should be input to the API.<br />
<br />
The following queries might help to understand the API more clearly: <br />
<br />
<blockquote class="tr_bq">
<span style="font-family: "Courier New",Courier,monospace;"><span style="background-color: #ead1dc;"><span style="color: #20124d;">SELECT qualification_type_id, NAME<br /> FROM per_qualification_types_tl<br /> WHERE 1 = 1 AND LANGUAGE = 'US';</span></span></span><br />
<span style="font-family: "Courier New",Courier,monospace;"><span style="background-color: #ead1dc;"><span style="color: #20124d;"><br /></span></span></span>
<span style="font-family: "Courier New",Courier,monospace;"><span style="background-color: #ead1dc;"><span style="color: #20124d;">SELECT establishment_id,NAME<br /> FROM per_establishments<br /> WHERE 1 = 1;</span></span></span><br />
<span style="font-family: "Courier New",Courier,monospace;"><span style="background-color: #ead1dc;"><span style="color: #20124d;"><br /></span></span></span>
<span style="font-family: "Courier New",Courier,monospace;"><span style="background-color: #ead1dc;"><span style="color: #20124d;">SELECT attendance_id<br /> FROM per_establishment_attend_v<br /> WHERE 1 = 1<br /> AND person_id = 'xx'<br /> AND establishment_id = 'establishment_id';</span></span></span></blockquote>
<br />
And this is the API: <br />
<br />
<blockquote class="tr_bq">
<span style="font-family: "Courier New",Courier,monospace;"><span style="background-color: #ead1dc;"><span style="color: #20124d;">DECLARE<br /> l_qualification_id NUMBER;<br /> l_object_version_number NUMBER;<br /> <br /> CURSOR per_edu<br /> IS<br /> SELECT xx_edu.ROWID,<br /> xx_edu.*<br /> FROM xxx_emp_edu_school_info xx_edu<br /> WHERE 1 = 1 AND NVL (upload_status, 'N') = 'N';<br /><br />BEGIN<br /> FOR i_rec IN per_edu<br /> LOOP<br /> fnd_profile.put ('PER_PERSON_ID', i_rec.person_id);<br /> per_qualifications_api.create_qualification<br /> (p_validate => FALSE,<br /> p_effective_date => SYSDATE,<br /> p_qualification_type_id => i_rec.qualification_type_id,<br /> p_attendance_id => i_rec.attendance_id,<br /> p_business_group_id => fnd_profile.VALUE<br /> ('PER_BUSINESS_GROUP_ID'),<br /> p_person_id => i_rec.person_id,<br /> p_awarded_date => SYSDATE,<br /> p_start_date => SYSDATE,<br /> p_qua_information_category => 'SA',<br /> p_qua_information1 => 'EARENED',<br /> p_qualification_id => l_qualification_id,<br /> p_object_version_number => l_object_version_number<br /> );<br /><br /> UPDATE xxx_emp_edu_school_info<br /> SET upload_status = 'Y',<br /> qualification_id = l_qualification_id<br /> WHERE ROWID = i_rec.ROWID;<br /> <br /> commit;<br /> END LOOP;<br />END; </span></span></span></blockquote>
Hope you found it useful guys, feel free to leave a comment if have any note on the subject. </div>
Hammam Muharebhttp://www.blogger.com/profile/06056751064122308940noreply@blogger.com0tag:blogger.com,1999:blog-3747830721977145321.post-60690639212761157612015-01-01T06:52:00.003-08:002015-01-04T00:20:41.409-08:00API to Create External Bank Branch<div dir="ltr" style="text-align: left;" trbidi="on">
Salam Alaikum,<br />
<br />
I share with you guys this API, that i use to create <b>External Banks Branches </b><i>, please note that external bank should exist and bank_id should be passed to this API.</i><br />
<br />
<blockquote class="tr_bq">
<span style="background-color: #cccccc;"><span style="color: #0b5394;"><span style="font-family: "Courier New",Courier,monospace;"><span style="color: #20124d;">DECLARE<br /> p_api_version NUMBER := 1.0;<br /> p_init_msg_list VARCHAR2 (1) := 'F';<br /> x_return_status VARCHAR2 (2000);<br /> x_msg_count NUMBER (5);<br /> x_msg_data VARCHAR2 (2000);<br /> x_response iby_fndcpt_common_pub.result_rec_type;<br /> p_ext_bank_branch_rec iby_ext_bankacct_pub.extbankbranch_rec_type;<br /> x_branch_id NUMBER;<br /> p_count NUMBER;<br /><br /> CURSOR C1<br /> IS<br /> SELECT DISTINCT BANK_COUNTRY, BANK_NUMBER, BANK_NAME<br /> FROM xx_customer_tmp_amm_t<br /> WHERE BANK_COUNTRY IS NOT NULL<br /> AND BANK_NUMBER IS NOT NULL<br /> AND BANK_NAME IS NOT NULL<br /> and O_BANK_UPLOAD_STATUS is null;<br />BEGIN<br /> FOR REC1 IN C1<br /> LOOP<br /> p_ext_bank_branch_rec.bch_object_version_number := 1.0;<br /> p_ext_bank_branch_rec.branch_name := rec1.BANK_BRANCH_NAME;<br /> p_ext_bank_branch_rec.branch_type := 'ABA';<br /> p_ext_bank_branch_rec.branch_number := rec1.BRANCH_NUMBER;<br /> p_ext_bank_branch_rec.bank_party_id := rec1.NEW_BANK_ID;<br /><br /><br /> APPS.FND_MSG_PUB.DELETE_MSG (NULL);<br /> APPS.FND_MSG_PUB.INITIALIZE ();<br /><br /><br /> IBY_EXT_BANKACCT_PUB.CREATE_EXT_BANK_BRANCH (<br /> p_api_version => p_api_version,<br /> p_init_msg_list => p_init_msg_list,<br /> p_ext_bank_branch_rec => p_ext_bank_branch_rec,<br /> x_branch_id => x_branch_id,<br /> x_return_status => x_return_status,<br /> x_msg_count => x_msg_count,<br /> x_msg_data => x_msg_data,<br /> x_response => x_response);<br /><br /> DBMS_OUTPUT.put_line ('x_return_status = ' || x_return_status);<br /> DBMS_OUTPUT.put_line ('x_msg_count = ' || x_msg_count);<br /> DBMS_OUTPUT.put_line ('x_msg_data = ' || x_msg_data);<br /> DBMS_OUTPUT.put_line ('x_branch_id = ' || x_branch_id);<br /> DBMS_OUTPUT.put_line (<br /> 'x_response.Result_Code = ' || x_response.result_code);<br /> DBMS_OUTPUT.put_line (<br /> 'x_response.Result_Category = ' || x_response.result_category);<br /> DBMS_OUTPUT.put_line (<br /> 'x_response.Result_Message = ' || x_response.result_message);<br /><br /> IF x_msg_count = 1<br /> THEN<br /> DBMS_OUTPUT.put_line ('x_msg_data ' || x_msg_data);<br /> ELSIF x_msg_count > 1<br /> THEN<br /> LOOP<br /> p_count := p_count + 1;<br /> x_msg_data :=<br /> fnd_msg_pub.get (fnd_msg_pub.g_next, fnd_api.g_false);<br /><br /> IF x_msg_data IS NULL<br /> THEN<br /> EXIT;<br /> END IF;<br /><br /> DBMS_OUTPUT.put_line (<br /> 'Message' || p_count || ' ---' || x_msg_data);<br /> END LOOP;<br /> END IF;<br /><br /> IF (x_return_status = 'S')<br /> THEN<br /> -- COMMIT;<br /> END IF;<br /> END LOOP;<br />END;</span> </span></span></span></blockquote>
<br />
And Here is a Query that you can use to see uploaded bank branches.<br />
<br />
<blockquote class="tr_bq">
<span style="color: #20124d;"><span style="background-color: #cccccc;"><span style="font-family: "Courier New",Courier,monospace;">SELECT BranchParty.PARTY_ID Branch_Party_Id,<br /> BranchParty.PARTY_NAME Bank_Branch_Name,<br /> BranchParty.ORGANIZATION_NAME_PHONETIC Bank_Branch_Name_Alt,<br /> BranchCA.start_date_active Start_Date,<br /> BranchCA.end_date_active End_Date<br /> FROM HZ_PARTIES BranchParty, HZ_CODE_ASSIGNMENTS BranchCA<br /> WHERE 1 = 1<br /> AND BranchParty.PARTY_TYPE = 'ORGANIZATION'<br /> AND BranchParty.status = 'A'<br /> AND BranchCA.CLASS_CATEGORY = 'BANK_INSTITUTION_TYPE'<br /> AND BranchCA.CLASS_CODE IN ('BANK_BRANCH', 'CLEARINGHOUSE_BRANCH')<br /> AND BranchCA.OWNER_TABLE_NAME = 'HZ_PARTIES'<br /> AND (BranchCA.STATUS = 'A' OR BranchCA.STATUS IS NULL)<br /> AND BranchCA.OWNER_TABLE_ID = BranchParty.PARTY_ID<br /> AND BranchParty.created_by = -1;</span></span></span> </blockquote>
<br />
Hope you found it useful guys, feel free to leave a comment if have any note on the subject. </div>
Hammam Muharebhttp://www.blogger.com/profile/06056751064122308940noreply@blogger.com0tag:blogger.com,1999:blog-3747830721977145321.post-64466319365664872492015-01-01T06:48:00.000-08:002015-01-04T00:33:31.846-08:00API to Create External Bank<div dir="ltr" style="text-align: left;" trbidi="on">
Salam Alaikum,<br />
<br />
I share with you guys this API, that i use to create <b>External Banks </b>that then can be assigned to customers (AR) or Suppliers (AP)<i>.</i><br />
<br />
<blockquote class="tr_bq">
<span style="background-color: #cccccc;"><span style="color: #0b5394;"><span style="font-family: "Courier New",Courier,monospace;">DECLARE<br /> LC_OUTPUT VARCHAR2 (3000);<br /> LC_MSG_DUMMY VARCHAR2 (3000);<br /> LC_RETURN_STATUS VARCHAR2 (3000);<br /> LC_MSG_DATA VARCHAR2 (3000);<br /><br /> LN_BANK_ID NUMBER;<br /> LN_MSG_COUNT NUMBER;<br /> LR_EXTBANK_REC APPS.IBY_EXT_BANKACCT_PUB.EXTBANK_REC_TYPE;<br /> LR_RESPONSE_REC APPS.IBY_FNDCPT_COMMON_PUB.RESULT_REC_TYPE;<br /><br /> V_COUNTRY_CODE VARCHAR2 (100);<br /><br /> CURSOR C1<br /> IS<br /> SELECT DISTINCT BANK_COUNTRY, BANK_NUMBER, BANK_NAME<br /> FROM xx_customer_tmp_amm_t<br /> WHERE BANK_COUNTRY IS NOT NULL<br /> AND BANK_NUMBER IS NOT NULL<br /> AND BANK_NAME IS NOT NULL<br /> and O_BANK_UPLOAD_STATUS is null;</span></span></span></blockquote>
<blockquote class="tr_bq">
<span style="background-color: #cccccc;"><span style="color: #0b5394;"><span style="font-family: "Courier New",Courier,monospace;">BEGIN<br /> LC_RETURN_STATUS := '';<br /> LN_MSG_COUNT := '';<br /> LC_MSG_DATA := '';<br /><br /><br /> APPS.FND_MSG_PUB.DELETE_MSG (NULL);<br /> APPS.FND_MSG_PUB.INITIALIZE ();<br /><br /> FOR REC1 IN C1<br /> LOOP<br /> BEGIN<br /> SELECT LOOKUP_CODE<br /> INTO V_COUNTRY_CODE<br /> FROM FND_LOOKUP_VALUES<br /> WHERE LOOKUP_TYPE = 'GHR_US_POSTAL_COUNTRY_CODE'<br /> AND LANGUAGE = 'US'<br /> AND MEANING = TRIM (REC1.BANK_COUNTRY);<br /> EXCEPTION<br /> WHEN NO_DATA_FOUND<br /> THEN<br /> DBMS_OUTPUT.put_line ('Bank_Country name is not Correct ');<br /> END;<br /><br /> LR_EXTBANK_REC.BANK_NAME := REC1.BANK_NAME;<br /> LR_EXTBANK_REC.BANK_NUMBER := REC1.BANK_NUMBER;<br /> LR_EXTBANK_REC.COUNTRY_CODE := V_COUNTRY_CODE;<br /> IBY_EXT_BANKACCT_PUB.CREATE_EXT_BANK ( -- ------------------------------<br /> -- Input data elements<br /> -- ------------------------------<br /> P_API_VERSION => 1.0,<br /> P_INIT_MSG_LIST => FND_API.G_TRUE,<br /> P_EXT_BANK_REC => LR_EXTBANK_REC,<br /> -- --------------------------------<br /> -- Output data elements<br /> -- --------------------------------<br /> X_BANK_ID => LN_BANK_ID,<br /> X_RETURN_STATUS => LC_RETURN_STATUS,<br /> X_MSG_COUNT => LN_MSG_COUNT,<br /> X_MSG_DATA => LC_MSG_DATA,<br /> X_RESPONSE => LR_RESPONSE_REC);<br /><br /> LC_OUTPUT := ' ';<br /><br /> IF (LC_RETURN_STATUS <> 'S')<br /> THEN<br /> FOR I IN 1 .. LN_MSG_COUNT<br /> LOOP<br /> APPS.FND_MSG_PUB.GET (I,<br /> APPS.FND_API.G_FALSE,<br /> LC_MSG_DATA,<br /> LC_MSG_DUMMY);<br /><br /> LC_OUTPUT :=<br /> LC_OUTPUT<br /> || (TO_CHAR (I) || ': ' || SUBSTR (LC_MSG_DATA, 1, 250));<br /> END LOOP;<br /><br /> APPS.FND_FILE.PUT_LINE (APPS.FND_FILE.OUTPUT,<br /> 'Error Occured while Creating Bank: ');<br /> END IF;<br /><br /> IF (LC_RETURN_STATUS = 'S')<br /> THEN<br /> -- COMMIT;<br /> END IF;<br /> END LOOP;<br />EXCEPTION<br /> WHEN OTHERS<br /> THEN<br /> ROLLBACK;<br /> DBMS_OUTPUT.PUT_LINE (SQLERRM);<br />END;</span></span></span><i> </i></blockquote>
<br />
And Here is a Query that u can use to see uploaded banks.<br />
<br />
<blockquote class="tr_bq">
<span style="background-color: #cccccc;"><span style="color: #0b5394;"><span style="font-family: "Courier New",Courier,monospace;">SELECT BankParty.*<br /> FROM HZ_PARTIES BankParty, HZ_CODE_ASSIGNMENTS BankCA<br /> WHERE BankParty.PARTY_TYPE = 'ORGANIZATION'<br /> AND NVL (BankParty.status, 'A') = 'A'<br /> AND BankCA.CLASS_CATEGORY = 'BANK_INSTITUTION_TYPE'<br /> AND BankCA.CLASS_CODE IN ('BANK', 'CLEARINGHOUSE')<br /> AND BankCA.OWNER_TABLE_NAME = 'HZ_PARTIES'<br /> AND BankCA.OWNER_TABLE_ID = BankParty.PARTY_ID<br /> AND NVL (BankCA.STATUS, 'A') = 'A'<br /> AND bankparty.created_by = -1;</span></span></span></blockquote>
<br />
Hope you found it useful guys, feel free to leave a comment if have any note on the subject. <br />
<br /></div>
Hammam Muharebhttp://www.blogger.com/profile/06056751064122308940noreply@blogger.com0tag:blogger.com,1999:blog-3747830721977145321.post-61592771372686756052014-12-31T07:45:00.003-08:002015-01-04T00:33:45.798-08:00API to Assign Competency to Employee(s)<div dir="ltr" style="text-align: left;" trbidi="on">
Salam Alaikum,<br />
<br />
I share with you guys this API, that i used to delete an Appraisal for employees.It assign the competency to employees. <i>But you can use the same API to assign it (competency) to a specific job or position.</i><br />
<br />
<blockquote class="tr_bq">
<span style="background-color: #cccccc;"><span style="color: #20124d;"><span style="font-family: "Courier New",Courier,monospace;">DECLARE <br />l_competence_element_id number;<br />l_api_ovn number;<br /><br />cursor app_data<br />is<br />--- note1: profeciency level id <br />--- note2: person id update<br />--- note3: competence level id should be added to the competences tables and passed here <br /> select a.*,c.competence_id,a.rowid<br /> from XXX_HR_PER_COMPETENCY a , xxxhrdata.xxx_competencies b ,xxx_competency_levels c<br /> where 1=1 <br /> and a.COMPETENCY_NAME = b.COMPETENCY_NAME<br /> and b.COMBINATION = c.COMBINATION; <br /><br />BEGIN<br /> for i_rec in app_data<br /> loop<br /> hr_competence_element_api.create_competence_element<br /> ( <br /> p_business_group_id => fnd_profile.VALUE('PER_BUSINESS_GROUP_ID'),<br /> p_effective_date => TO_DATE ('1900/01/01','YYYY/MM/DD'), <br /> <br /> p_competence_id => i_rec.competence_id,<br /> p_proficiency_level_id => i_rec.PROFICIENCY_LEVEL_id,<br /> p_rating_level_id => i_rec.LEVEL_NO,<br /> p_person_id => i_rec.person_id,<br /> <br /> p_competence_element_id => l_competence_element_id,<br /> p_object_version_number => l_api_ovn<br /> );<br /> <br /> update XXX_HR_PER_COMPETENCY u<br /> set upload_status = 'Y'<br /> where i_rec.rowid = u.rowid;<br /> <br /> end loop; <br />END;</span></span></span></blockquote>
<br />
Hope you found it useful guys, feel free to leave a comment if have any note on the subject. </div>
Hammam Muharebhttp://www.blogger.com/profile/06056751064122308940noreply@blogger.com0tag:blogger.com,1999:blog-3747830721977145321.post-80520233034698678832014-12-31T07:28:00.004-08:002015-01-04T00:33:57.837-08:00API to Create HR Competence<div dir="ltr" style="text-align: left;" trbidi="on">
Salam Alaikum,<br />
<br />
I share with you guys this API, that i used to Create a Competence. That then can assigned to an employee or more. <br />
<br />
<blockquote class="tr_bq">
<span style="background-color: #cccccc;"><span style="color: #351c75;"><span style="font-family: "Courier New",Courier,monospace;">DECLARE<br /> v_competence_id NUMBER;<br /> v_competence_definition_id NUMBER;<br /> v_object_version_number NUMBER;<br /> v_name VARCHAR2;<br /><br /> CURSOR app_data<br /> IS<br /> SELECT *<br /> FROM xxx_competencies; --- per_competences_v <br />BEGIN<br /> FOR i_rec IN app_data<br /> LOOP<br /> <br /> hr_competences_api.create_competence<br /> (p_effective_date => TO_CHAR ('1900/01/01 00:00:00','YYYY/MM/DD HH24:MI:SS'),<br /> p_date_from => TO_CHAR ('1900/01/01 00:00:00','YYYY/MM/DD HH24:MI:SS'),<br /> p_business_group_id => fnd_profile.VALUE('PER_BUISNESS_GROUP_ID'),<br /> p_description => i_rec.competency_description,<br /> p_competence_alias => i_rec.competency_name,<br /> <br /> p_competence_id => v_competence_id,<br /> p_competence_definition_id => v_competence_definition_id,<br /> p_object_version_number => v_object_version_number,<br /> p_name => v_name<br /> );<br /><br /> UPDATE xxx_competencies cbd<br /> SET cbd.upload_status = 'Y',<br /> cbd.competence_id = v_competence_id<br /> WHERE cbd.ROWID = i_rec.ROWID;<br /><br /> END LOOP;<br />END;</span></span></span></blockquote>
<br />
Hope you found it useful guys, feel free to leave a comment if have any note on the subject. <br />
<br /></div>
Hammam Muharebhttp://www.blogger.com/profile/06056751064122308940noreply@blogger.com1tag:blogger.com,1999:blog-3747830721977145321.post-91594155257196090272014-12-31T07:21:00.002-08:002015-01-04T00:34:11.248-08:00API to Delete Employee Appraisal<div dir="ltr" style="text-align: left;" trbidi="on">
Salam Alaikum,<br />
<br />
I share with you guys this API, that i used to delete an Appraisal for employees. <br />
<br />
<blockquote class="tr_bq">
<span style="background-color: #cccccc;"><span style="font-family: "Courier New",Courier,monospace;"><span style="color: #351c75;">DECLARE<br /> v_appraisal_id NUMBER;<br /> v_object_version_number NUMBER;<br /> l_template_id NUMBER;<br /> l_rating_level_id NUMBER;<br /> l_appraisal_id NUMBER;<br /> v_date_of_hire DATE;<br /> v_start_date_var DATE;<br /> v_end_date_var DATE;<br /> l_object_version_number NUMBER;<br /><br /> CURSOR app_data<br /> IS<br /> SELECT *<br /> FROM per_appraisals; <br />BEGIN<br /> FOR i_rec IN app_data<br /> LOOP<br /><br /> HR_UTILITY.FND_INSERT(SYSDATE);<br /><br /> hr_appraisals_api.delete_appraisal<br /> (p_appraisal_id => i_rec.appraisal_id,<br /> p_object_version_number => i_rec.OBJECT_VERSION_NUMBER<br /> );<br /><br /> commit;<br /> <br /> END LOOP;<br />END;</span></span></span></blockquote>
<br />
Hope you found it useful guys, feel free to leave a comment if have any note on the subject. </div>
Hammam Muharebhttp://www.blogger.com/profile/06056751064122308940noreply@blogger.com0tag:blogger.com,1999:blog-3747830721977145321.post-30921216190104012732014-12-31T07:17:00.000-08:002015-01-04T00:34:38.736-08:00API to Create Appraisal for Employee <div dir="ltr" style="text-align: left;" trbidi="on">
Salam Alaikum,<br />
<br />
I share with you guys this API, that i used to create Appraisal for employees.<br />
<br />
<br />
<blockquote>
<span style="background-color: #cccccc;"><span style="color: #674ea7;"><span style="font-family: "Courier New",Courier,monospace;"><span style="color: #351c75;">DECLARE<br /> v_appraisal_id NUMBER;<br /> v_object_version_number NUMBER;<br /> l_template_id NUMBER;<br /> l_rating_level_id NUMBER;<br /> l_appraisal_id NUMBER;<br /> v_date_of_hire DATE;<br /> v_start_date_var DATE;<br /> v_end_date_var DATE;<br /><br /> l_object_version_number NUMBER;<br /><br /> CURSOR app_data<br /> IS<br /> -- note1: over_all_rating need to be mapped to get performance id<br /> SELECT t.*,<br /> k.person_id,<br /> k.original_date_of_hire,<br /> t.ROWID,<br /> ppos.actual_termination_date actual_termination_date<br /> FROM xxxhrdata.xxx_emp_appraisals_info t,<br /> per_all_people_f k,<br /> per_periods_of_service ppos<br /> WHERE 1 = 1<br /> AND NVL (t.upload_status, 'N') = 'N'<br /> AND t.employee_number = k.employee_number<br /> AND t.over_all_rating IS NOT NULL<br /> AND EXTRACT (YEAR FROM t.start_date) IN ('2012', '2013')<br /> AND ppos.person_id = k.person_id;<br />BEGIN<br /> FOR i_rec IN app_data LOOP<br /> FND_PROFILE.PUT ('PER_BUSINESS_GROUP_ID', i_rec.PERSON_ID);<br /> FND_PROFILE.PUT ('PER_BUSINESS_GROUP_ID', i_rec.MAIN_APPRAISER_EMP_NO);<br /><br /> HR_UTILITY.FND_INSERT (SYSDATE);<br /><br /> ---Get the appraisal template<br /> SELECT appraisal_template_id<br /> INTO l_template_id<br /> FROM per_appraisal_templates<br /> WHERE attribute20 = 'HISTORICALAPPRAISAL';<br /><br /> ---Get the Rating Level<br /> SELECT rating_level_id<br /> INTO l_rating_level_id<br /> FROM per_rating_levels a, per_rating_scales b<br /> WHERE a.rating_scale_id = b.rating_scale_id<br /> AND b.default_flag = 'Y'<br /> AND a.step_value = i_rec.OVER_ALL_RATING;<br /><br /> IF i_rec.ORIGINAL_DATE_OF_HIRE > i_rec.START_DATE THEN<br /> v_start_date_var := i_rec.ORIGINAL_DATE_OF_HIRE;<br /> ELSE<br /> v_start_date_var := i_rec.START_DATE;<br /> END IF;<br /><br /> IF i_rec.actual_termination_date BETWEEN i_rec.START_DATE<br /> AND i_rec.end_date THEN<br /> v_end_date_var := i_rec.actual_termination_date;<br /> ELSE<br /> v_end_date_var := i_rec.end_date;<br /> END IF;<br /><br /> hr_appraisals_api.create_appraisal (<br /> p_effective_date => i_rec.START_DATE, <br /> p_business_group_id => fnd_profile.VALUE ('PER_BUISNESS_GROUP_ID'),<br /> p_appraisal_template_id => l_template_id,<br /> p_appraisee_person_id => i_rec.person_id, -- Employee<br /> p_appraiser_person_id => i_rec.MAIN_APPRAISER_EMP_NO, -- Manager<br /> p_appraisal_date => i_rec.START_DATE,<br /> p_appraisal_period_start_date => i_rec.START_DATE,<br /> p_appraisal_period_end_date => NVL (i_rec.actual_termination_date,<br /> i_rec.end_date),<br /> p_overall_performance_level_id => l_rating_level_id,<br /> p_appraisal_system_status => 'COMPLETED',<br /> p_main_appraiser_id => i_rec.MAIN_APPRAISER_EMP_NO, -- Manager<br /> p_open => '',<br /> p_system_type => 'MGRSTD',<br /> p_system_params => 'pSystemType=MGRSTD',<br /> --changes based on the setup <br /> --p_attribute1 => x,<br /> --p_attribute2 => y,<br /><br /> -- OUT<br /> p_appraisal_id => l_appraisal_id,<br /> p_object_version_number => l_object_version_number);<br /><br /> UPDATE xxx_emp_appraisals_info cbd<br /> SET cbd.upload_status = 'Y'<br /> WHERE cbd.ROWID = i_rec.ROWID;<br /> END LOOP;<br />END;</span></span></span></span></blockquote>
<br />
Hope you found it useful guys, feel free to leave a comment if have any note on the subject. </div>
Hammam Muharebhttp://www.blogger.com/profile/06056751064122308940noreply@blogger.com1tag:blogger.com,1999:blog-3747830721977145321.post-15261045508515500012014-12-17T01:25:00.000-08:002014-12-28T05:42:55.276-08:00Concurrent & Responsibilities query<div dir="ltr" style="text-align: left;" trbidi="on">
<script src="https://google-code-prettify.googlecode.com/svn/loader/run_prettify.js"></script>
<script>
(function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){
(i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),
m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
})(window,document,'script','//www.google-analytics.com/analytics.js','ga');
ga('create', 'UA-58044283-1', 'auto');
ga('send', 'pageview');
</script>
<br />
<div dir="ltr" style="text-align: left;" trbidi="on">
Salam Alaikum,<br />
<br />
I share with you guys this query that i use to get report information, it can also give you all the reports available for a specific user and by which responsibilities. And it can be used to get all the reports attached to a certain responsibility via its request group.<br />
<br />
<blockquote class="tr_bq">
<span style="font-family: "Courier New",Courier,monospace;"><span style="color: #351c75;"><span style="background-color: #ead1dc;">SELECT a.user_concurrent_program_name,<br /> b.request_group_name,<br /> e.responsibility_name<br /> FROM fnd_concurrent_programs_tl a,<br /> fnd_request_groups b,<br /> fnd_request_group_units c,<br /> fnd_responsibility d,<br /> fnd_responsibility_tl e,<br /> fnd_user_resp_groups_direct f,<br /> fnd_user g,<br /> fnd_concurrent_programs h<br /> WHERE a.concurrent_program_id = c.request_unit_id<br /> AND a.concurrent_program_id = h.concurrent_program_id<br /> AND b.request_group_id = c.request_group_id<br /> AND b.request_group_id = d.request_group_id<br /> AND d.responsibility_id = e.responsibility_id<br /> AND b.application_id = c.application_id<br /> AND d.application_id = e.application_id<br /> AND f.user_id = g.user_id<br /> AND f.responsibility_id = e.responsibility_id<br /> AND UPPER (a.user_concurrent_program_name) LIKE<br /> '%' || UPPER (:p_concurrent_program_name) || '%'<br /> AND g.user_name = NVL (UPPER (:p_user_name), g.user_name)<br /> AND e.language = NVL (UPPER (:p_language), USERENV ('LANG'))<br /> AND SYSDATE BETWEEN NVL (<br /> f.start_date,<br /> fnd_date.canonical_to_date (<br /> '0001/01/01 00:00:00'))<br /> AND NVL (<br /> f.end_date,<br /> fnd_date.canonical_to_date (<br /> '4000/12/31 23:59:59'));</span></span></span></blockquote>
<br />
Hope you found it useful guys, feel free to leave a comment if have any note on the subject. </div>
</div>
Hammam Muharebhttp://www.blogger.com/profile/06056751064122308940noreply@blogger.com0tag:blogger.com,1999:blog-3747830721977145321.post-19179945347191642382014-12-15T00:25:00.001-08:002014-12-28T05:43:22.896-08:00Query to get all Business Group's Mapped with thier Legal Entities<script>
(function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){
(i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),
m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
})(window,document,'script','//www.google-analytics.com/analytics.js','ga');
ga('create', 'UA-58044283-1', 'auto');
ga('send', 'pageview');
</script>
<div dir="ltr" style="text-align: left;" trbidi="on">
Salam Alaikum,<br />
<br />
I share with you guys this query that can used to get Business group information, along with their Legal entities.<br />
<br />
<br />
<blockquote>
<span style="background-color: #ead1dc;"><span style="color: #674ea7;"><span style="color: #351c75;"><span style="font-family: "Courier New",Courier,monospace;">SELECT DISTINCT hrl.country,</span><br /><span style="font-family: "Courier New",Courier,monospace;"> hroutl_bg.NAME bg,</span><br /><span style="font-family: "Courier New",Courier,monospace;"> hroutl_bg.organization_id,</span><br /><span style="font-family: "Courier New",Courier,monospace;"> lep.legal_entity_id,</span><br /><span style="font-family: "Courier New",Courier,monospace;"> lep.NAME legal_entity,</span><br /><span style="font-family: "Courier New",Courier,monospace;"> hroutl_ou.NAME ou_name,</span><br /><span style="font-family: "Courier New",Courier,monospace;"> hroutl_ou.organization_id org_id,</span><br /><span style="font-family: "Courier New",Courier,monospace;"> hrl.location_id,</span><br /><span style="font-family: "Courier New",Courier,monospace;"> hrl.location_code,</span><br /><span style="font-family: "Courier New",Courier,monospace;"> glev.FLEX_SEGMENT_VALUE</span><br /><span style="font-family: "Courier New",Courier,monospace;"> FROM xle_entity_profiles lep,</span><br /><span style="font-family: "Courier New",Courier,monospace;"> xle_registrations reg,</span><br /><span style="font-family: "Courier New",Courier,monospace;"> hr_locations_all hrl,</span><br /><span style="font-family: "Courier New",Courier,monospace;"> hz_parties hzp,</span><br /><span style="font-family: "Courier New",Courier,monospace;"> fnd_territories_vl ter,</span><br /><span style="font-family: "Courier New",Courier,monospace;"> hr_operating_units hro,</span><br /><span style="font-family: "Courier New",Courier,monospace;"> hr_all_organization_units_tl hroutl_bg,</span><br /><span style="font-family: "Courier New",Courier,monospace;"> hr_all_organization_units_tl hroutl_ou,</span><br /><span style="font-family: "Courier New",Courier,monospace;"> hr_organization_units gloperatingunitseo,</span><br /><span style="font-family: "Courier New",Courier,monospace;"> gl_legal_entities_bsvs glev</span><br /><span style="font-family: "Courier New",Courier,monospace;"> WHERE lep.transacting_entity_flag = 'Y'</span><br /><span style="font-family: "Courier New",Courier,monospace;"> AND lep.party_id = hzp.party_id</span><br /><span style="font-family: "Courier New",Courier,monospace;"> AND lep.legal_entity_id = reg.source_id</span><br /><span style="font-family: "Courier New",Courier,monospace;"> AND reg.source_table = 'XLE_ENTITY_PROFILES'</span><br /><span style="font-family: "Courier New",Courier,monospace;"> AND hrl.location_id = reg.location_id</span><br /><span style="font-family: "Courier New",Courier,monospace;"> AND reg.identifying_flag = 'Y'</span><br /><span style="font-family: "Courier New",Courier,monospace;"> AND ter.territory_code = hrl.country</span><br /><span style="font-family: "Courier New",Courier,monospace;"> AND lep.legal_entity_id = hro.default_legal_context_id</span><br /><span style="font-family: "Courier New",Courier,monospace;"> AND gloperatingunitseo.organization_id = hro.organization_id</span><br /><span style="font-family: "Courier New",Courier,monospace;"> AND hroutl_bg.organization_id = hro.business_group_id</span><br /><span style="font-family: "Courier New",Courier,monospace;"> AND hroutl_ou.organization_id = hro.organization_id</span><br /><span style="font-family: "Courier New",Courier,monospace;"> AND glev.legal_entity_id = lep.legal_entity_id;</span></span></span></span></blockquote>
Note: the query might need mild modification based on the setup you have.<br />
<br />
Hope you found it useful guys, feel free to leave a comment if have any note on the subject. <br />
</div>
Hammam Muharebhttp://www.blogger.com/profile/06056751064122308940noreply@blogger.com0tag:blogger.com,1999:blog-3747830721977145321.post-24928229739987353512014-12-14T07:33:00.001-08:002015-01-04T00:34:55.725-08:00Customers API (Complete API)<div dir="ltr" style="text-align: left;" trbidi="on">
<script>
(function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){
(i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),
m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
})(window,document,'script','//www.google-analytics.com/analytics.js','ga');
ga('create', 'UA-58044283-1', 'auto');
ga('send', 'pageview');
</script>
<br />
<div dir="ltr" style="text-align: left;" trbidi="on">
Salam Alaikum,<br />
<br />
After struggling with the task of uploading for a long time, i share with you guys a complete API that can be used for uploading customers. <br />
<br />
The following API can be used to create the following:<br />
<ol style="text-align: left;">
<li>Create Customer (using: HZ_PARTY_V2PUB.create_organization).</li>
<li>Create Customer account (using: HZ_CUST_ACCOUNT_V2PUB.create_cust_account).</li>
<li>Create location (using: HZ_LOCATION_V2PUB.create_location).</li>
<li>Create Customer Site (using: HZ_PARTY_SITE_V2PUB.create_party_site).</li>
<li>Create Customer Account site (using: Z_CUST_ACCOUNT_SITE_V2PUB.create_cust_acct_site).</li>
<li>Create Customer Account site use (Ship to & Bill to - using: HZ_CUST_ACCOUNT_SITE_V2PUB.create_cust_site_use) .</li>
<li>Create Contact Person (using: HZ_PARTY_V2PUB.create_person & HZ_PARTY_CONTACT_V2PUB.create_org_contact).</li>
<li>Add phone number to contact (using: HZ_CONTACT_POINT_V2PUB.create_contact_point).</li>
<li>Create Customer Account Role (using: HZ_CUST_ACCOUNT_ROLE_V2PUB.create_cust_account_role).</li>
<li>Create External Bank (using: IBY_EXT_BANKACCT_PUB.create_ext_bank).</li>
<li>Create External Branch (using: IBY_EXT_BANKACCT_PUB.create_ext_bank_branch).</li>
<li>Create External Bank Account (using: IBY_EXT_BANKACCT_PUB.create_ext_bank_acct).</li>
<li>Create Bank Account assignment to the customer (using: IBY_FNDCPT_SETUP_PUB.Set_Payer_Instr_Assignment).</li>
</ol>
<br />
The Code i am sharing is merging all the api together in one block, but i will share the API's separated once i have them.<br />
<br />
<blockquote class="tr_bq">
<span style="background-color: #cccccc;"><span style="font-family: "Courier New",Courier,monospace;"><span style="color: #351c75;">DECLARE<br /> v_return_status VARCHAR2 (5000);<br /> v_msg_count NUMBER;<br /> v_msg_data VARCHAR2 (5000);<br /> -- misc variables<br /> v_msg_dummy VARCHAR2 (5000);<br /> t_output VARCHAR2 (5000);<br /> v_cust_account_rec HZ_CUST_ACCOUNT_V2PUB.CUST_ACCOUNT_REC_TYPE;<br /> v_customer_profile_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE;<br /> v_cust_account_id NUMBER;<br /> v_account_number VARCHAR2 (5000);<br /> v_party_id NUMBER;<br /> v_party_number VARCHAR2 (5000);<br /> v_profile_id NUMBER;<br /> v_cust_party_id NUMBER;<br /> v_cust_party_number VARCHAR2 (5000);<br /> v_cust_profile_id NUMBER;<br /> v_application_id NUMBER;<br /> v_organization_rec HZ_PARTY_V2PUB.organization_rec_type;<br /> v_location_id NUMBER;<br /> v_location_rec HZ_LOCATION_V2PUB.location_rec_type;<br /> v_currency_code VARCHAR2 (5000);<br /> v_country_code VARCHAR2 (5000);<br /> v_party_site_rec HZ_PARTY_SITE_V2PUB.party_site_rec_type;<br /> v_party_site_id NUMBER;<br /> v_party_site_number VARCHAR2 (5000);<br /> v_cust_acct_site_rec HZ_CUST_ACCOUNT_SITE_V2PUB.cust_acct_site_rec_type;<br /> v_cust_acct_site_id NUMBER;<br /> v_cust_site_use_rec HZ_CUST_ACCOUNT_SITE_V2PUB.CUST_SITE_USE_REC_TYPE;<br /> v_bill_site_use_id NUMBER;<br /> v_ship_site_use_id NUMBER;<br /> v_org_id NUMBER;<br /> v_person_rec HZ_PARTY_V2PUB.PERSON_REC_TYPE;<br /> v_person_profile_id NUMBER;<br /> v_person_party_id NUMBER;<br /> v_person_party_number VARCHAR2 (5000);<br /> v_contact_party_id NUMBER;<br /> v_contact_party_number VARCHAR2 (5000);<br /> v_org_contact_id NUMBER;<br /> v_party_rel_id NUMBER;<br /> v_contact_point_id NUMBER;<br /> v_org_contact_rec HZ_PARTY_CONTACT_V2PUB.ORG_CONTACT_REC_TYPE;<br /> v_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;<br /> v_edi_rec HZ_CONTACT_POINT_V2PUB.EDI_REC_TYPE;<br /> v_email_rec HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;<br /> v_phone_rec HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;<br /> v_telex_rec HZ_CONTACT_POINT_V2PUB.TELEX_REC_TYPE;<br /> v_web_rec HZ_CONTACT_POINT_V2PUB.WEB_REC_TYPE;<br /> v_cust_account_role_id NUMBER;<br /> v_cust_account_role_rec HZ_CUST_ACCOUNT_ROLE_V2PUB.CUST_ACCOUNT_ROLE_REC_TYPE;<br /> v_ext_bank_rec IBY_EXT_BANKACCT_PUB.ExtBank_rec_type;<br /> v_response IBY_FNDCPT_COMMON_PUB.Result_rec_type;<br /> v_bank_id NUMBER;<br /> v_bank_exists NUMBER := 0;<br /> v_ext_bank_branch_rec IBY_EXT_BANKACCT_PUB.ExtBankBranch_rec_type;<br /> v_branch_id NUMBER;<br /> v_start_date DATE;<br /> v_end_date DATE;<br /> v_acct_id NUMBER;<br /> v_ext_banK_acct_rec IBY_EXT_BANKACCT_PUB.ExtBankAcct_rec_type;<br /> v_payer_context_rec IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type;<br /> v_assignment_attribs IBY_FNDCPT_SETUP_PUB.PmtInstrAssignment_rec_type;<br /> v_assign_id NUMBER;<br />BEGIN<br /> -- get application id<br /><br /> SELECT application_id<br /> INTO v_application_id<br /> FROM fnd_application_vl<br /> WHERE application_name = 'Order Management';<br /><br /> -- get org details<br /><br /> SELECT hou.organization_id<br /> INTO v_org_id<br /> FROM hr_operating_units hou<br /> -- hou.name will come from staging table or excel sheet<br /><br /> WHERE hou.name = 'Sahara Bulk Storage Facilities Limited';<br /><br /> -- set operating unit<br /><br /> mo_global.init ('AR'); --fnd_global.apps_initialize(1523, 50758, 222);<br /><br /> mo_global.set_policy_context ('S', v_org_id); -- get currency, territory details<br /><br /> SELECT territory_code, currency_code<br /> INTO v_country_code, v_currency_code<br /> FROM fnd_territories_tl ftt, fnd_currencies fc<br /> WHERE fc.issuing_territory_code = ftt.territory_code -- nigeria comes from excel file<br /> AND UPPER (ftt.territory_short_name) = UPPER ('Nigeria');<br /><br /> -- set organization recordv_organization_rec.created_by_module := 'HZ_CPUI';<br /><br /> v_organization_rec.organization_name := 'Igwe Super Customer';<br /><br /> v_organization_rec.application_id := v_application_id;<br /><br /> -- create organization<br /><br /> HZ_PARTY_V2PUB.create_organization (p_init_msg_list => FND_API.G_TRUE,<br /> p_organization_rec => v_organization_rec,<br /> x_party_id => v_party_id,<br /> x_party_number => v_party_number,<br /> x_profile_id => v_profile_id,<br /> x_return_status => v_return_status,<br /> x_msg_count => v_msg_count,<br /> x_msg_data => v_msg_data);<br /><br /> --debug section<br /> IF v_msg_count > 0 THEN<br /> FOR j IN 1 .. v_msg_count LOOP<br /> fnd_msg_pub.get (j,<br /> FND_API.G_FALSE,<br /> v_msg_data,<br /> v_msg_dummy);<br /><br /> t_output := ('Msg' || TO_CHAR (j) || ': ' || v_msg_data);<br /><br /> DBMS_OUTPUT.put_line (SUBSTR (t_output, 1, 255));<br /> END LOOP;<br /> END IF;<br /> -- end debug<br /><br /> -- set customer record type<br /> v_cust_account_rec.status := 'A';<br /><br /> -- lookup is CUSTOMER_TYPE<br /> v_cust_account_rec.customer_type := 'R'; -- lookup is CUSTOMER CLASS<br /> v_cust_account_rec.customer_class_code := 'PUBLIC SECTOR COMPANIES';<br /> v_cust_account_rec.application_id := v_application_id;<br /> v_cust_account_rec.created_by_module := 'HZ_CPUI';<br /> v_cust_account_rec.account_name := v_organization_rec.organization_name;<br /><br /> -- party id<br /> v_organization_rec.party_rec.party_id := v_party_id;<br /> v_organization_rec.gsa_indicator_flag := 'N';<br /><br /> -- create customer<br /> HZ_CUST_ACCOUNT_V2PUB.create_cust_account (<br /> p_init_msg_list => FND_API.G_FALSE,<br /> p_cust_account_rec => v_cust_account_rec,<br /> p_organization_rec => v_organization_rec,<br /> p_customer_profile_rec => v_customer_profile_rec,<br /> p_create_profile_amt => FND_API.G_FALSE,<br /> x_cust_account_id => v_cust_account_id,<br /> x_account_number => v_account_number,<br /> x_party_id => v_cust_party_id,<br /> x_party_number => v_cust_party_number,<br /> x_profile_id => v_cust_profile_id,<br /> x_return_status => v_return_status,<br /> x_msg_count => v_msg_count,<br /> x_msg_data => v_msg_data);<br /><br /> --debug section<br /> IF v_msg_count > 0 THEN<br /> FOR j IN 1 .. v_msg_count LOOP<br /> fnd_msg_pub.get (j,<br /> FND_API.G_FALSE,<br /> v_msg_data,<br /> v_msg_dummy);<br /><br /> t_output := ('Msg' || TO_CHAR (j) || ': ' || v_msg_data);<br /><br /> DBMS_OUTPUT.put_line (SUBSTR (t_output, 1, 255));<br /> END LOOP;<br /> END IF;<br /> -- end debug<br /><br /> -- create location record<br /> v_location_rec.address1 := 'Block A, Plot 21 Olamijuyi Avenue';<br /> v_location_rec.address2 := 'Parkview Estate. Ikoyi';<br /> v_location_rec.city := 'Lagos';<br /> v_location_rec.state := 'Lagos';<br /> v_location_rec.country := v_country_code;<br /> v_location_rec.created_by_module := 'HZ_CPUI';<br /> v_location_rec.application_id := v_application_id;<br /> v_location_rec.address_style := 'Nigeria Address Format';<br /><br /> -- now create location<br /> HZ_LOCATION_V2PUB.create_location (p_location_rec => v_location_rec,<br /> x_location_id => v_location_id,<br /> x_return_status => v_return_status,<br /> x_msg_count => v_msg_count,<br /> x_msg_data => v_msg_data);<br /><br /> --debug section<br /> IF v_msg_count > 0 THEN<br /> FOR j IN 1 .. v_msg_count LOOP<br /> fnd_msg_pub.get (j,<br /> FND_API.G_FALSE,<br /> v_msg_data,<br /> v_msg_dummy);<br /><br /> t_output := ('Msg' || TO_CHAR (j) || ': ' || v_msg_data);<br /><br /> DBMS_OUTPUT.put_line (SUBSTR (t_output, 1, 255));<br /> END LOOP;<br /> END IF;<br /> -- end debug<br /><br /> -- populate party site record type<br /> v_party_site_rec.party_id := v_party_id;<br /> v_party_site_rec.location_id := v_location_id;<br /> v_party_site_rec.status := 'A';<br /> v_party_site_rec.identifying_address_flag := 'Y';<br /> v_party_site_rec.created_by_module := 'HZ_CPUI';<br /> v_party_site_rec.application_id := v_application_id;<br /><br /> -- create party site<br /> HZ_PARTY_SITE_V2PUB.create_party_site (<br /> p_party_site_rec => v_party_site_rec,<br /> x_party_site_id => v_party_site_id,<br /> x_party_site_number => v_party_site_number,<br /> x_return_status => v_return_status,<br /> x_msg_count => v_msg_count,<br /> x_msg_data => v_msg_data);<br /><br /> --debug section<br /> IF v_msg_count > 0 THEN<br /> FOR j IN 1 .. v_msg_count LOOP<br /> fnd_msg_pub.get (j,<br /> FND_API.G_FALSE,<br /> v_msg_data,<br /> v_msg_dummy);<br /><br /> t_output := ('Msg' || TO_CHAR (j) || ': ' || v_msg_data);<br /><br /> DBMS_OUTPUT.put_line (SUBSTR (t_output, 1, 255));<br /> END LOOP;<br /> END IF;<br /> -- end debug<br /><br /> -- create account site record type<br /> v_cust_acct_site_rec.cust_account_id := v_cust_account_id;<br /> v_cust_acct_site_rec.party_site_id := v_party_site_id;<br /> v_cust_acct_site_rec.created_by_module := 'HZ_CPUI';<br /> v_cust_acct_site_rec.application_id := v_application_id;<br /> v_cust_acct_site_rec.status := 'A';<br /> v_cust_acct_site_rec.org_id := v_org_id;<br /><br /> -- create customer account site<br /> HZ_CUST_ACCOUNT_SITE_V2PUB.create_cust_acct_site (<br /> p_init_msg_list => FND_API.G_TRUE,<br /> p_cust_acct_site_rec => v_cust_acct_site_rec,<br /> x_cust_acct_site_id => v_cust_acct_site_id,<br /> x_return_status => v_return_status,<br /> x_msg_count => v_msg_count,<br /> x_msg_data => v_msg_data);<br /><br /> --debug section<br /> IF v_msg_count > 0 THEN<br /> FOR j IN 1 .. v_msg_count LOOP<br /> fnd_msg_pub.get (j,<br /> FND_API.G_FALSE,<br /> v_msg_data,<br /> v_msg_dummy);<br /><br /> t_output := ('Msg' || TO_CHAR (j) || ' : ' || v_msg_data);<br /><br /> DBMS_OUTPUT.put_line (SUBSTR (t_output, 1, 255));<br /> END LOOP;<br /> END IF;<br /> -- end debug<br /><br /> -- create account site use record for SHIP_TO<br /> v_cust_site_use_rec.cust_acct_site_id := v_cust_acct_site_id;<br /> v_cust_site_use_rec.site_use_code := 'SHIP_TO';<br /> v_cust_site_use_rec.primary_flag := 'Y';<br /> v_cust_site_use_rec.status := 'A';<br /><br /> -- location id<br /> v_cust_site_use_rec.LOCATION := v_location_id;<br /> v_cust_site_use_rec.created_by_module := 'HZ_CPUI';<br /> v_cust_site_use_rec.application_id := v_application_id;<br /> v_cust_site_use_rec.org_id := v_org_id;<br /><br /> -- create customer account site use<br /> HZ_CUST_ACCOUNT_SITE_V2PUB.create_cust_site_use (<br /> p_init_msg_list => FND_API.G_TRUE,<br /> p_cust_site_use_rec => v_cust_site_use_rec,<br /> p_customer_profile_rec => v_customer_profile_rec,<br /> p_create_profile => FND_API.G_TRUE,<br /> p_create_profile_amt => FND_API.G_FALSE,<br /> x_site_use_id => v_ship_site_use_id,<br /> x_return_status => v_return_status,<br /> x_msg_count => v_msg_count,<br /> x_msg_data => v_msg_data);<br /><br /> --debug section<br /> IF v_msg_count > 0 THEN<br /> FOR j IN 1 .. v_msg_count LOOP<br /> fnd_msg_pub.get (j,<br /> FND_API.G_FALSE,<br /> v_msg_data,<br /> v_msg_dummy);<br /><br /> t_output := ('Msg' || TO_CHAR (j) || ': ' || v_msg_data);<br /><br /> DBMS_OUTPUT.put_line (SUBSTR (t_output, 1, 255));<br /> END LOOP;<br /> END IF;<br /> -- end debug<br /><br /> -- create cust site use for bill to<br /> v_cust_site_use_rec.site_use_code := 'BILL_TO';<br /><br /> HZ_CUST_ACCOUNT_SITE_V2PUB.create_cust_site_use (<br /> p_init_msg_list => FND_API.G_TRUE,<br /> p_cust_site_use_rec => v_cust_site_use_rec,<br /> p_customer_profile_rec => v_customer_profile_rec,<br /> p_create_profile => FND_API.G_TRUE,<br /> p_create_profile_amt => FND_API.G_FALSE,<br /> x_site_use_id => v_bill_site_use_id,<br /> x_return_status => v_return_status,<br /> x_msg_count => v_msg_count,<br /> x_msg_data => v_msg_data);<br /><br /> --debug section<br /> IF v_msg_count > 0 THEN<br /> FOR j IN 1 .. v_msg_count LOOP<br /> fnd_msg_pub.get (j,<br /> FND_API.G_FALSE,<br /> v_msg_data,<br /> v_msg_dummy);<br /><br /> t_output := ('Msg' || TO_CHAR (j) || ': ' || v_msg_data);<br /><br /> DBMS_OUTPUT.put_line (SUBSTR (t_output, 1, 255));<br /> END LOOP;<br /> END IF;<br /> -- end debug<br /><br /> -- create contact person rec<br /> v_person_rec.person_first_name := 'Chike';<br /> v_person_rec.person_last_name := 'Iheomamere';<br /> v_person_rec.person_title := 'MR.';<br /> v_person_rec.party_rec.status := 'A';<br /> v_person_rec.head_of_household_flag := 'N';<br /> v_person_rec.application_id := v_application_id;<br /> v_person_rec.created_by_module := 'HZ_CPUI';<br /><br /> -- create person<br /> HZ_PARTY_V2PUB.create_person (p_init_msg_list => fnd_api.g_false,<br /> p_person_rec => v_person_rec,<br /> x_party_id => v_person_party_id,<br /> x_party_number => v_person_party_number,<br /> x_profile_id => v_person_profile_id,<br /> x_return_status => v_return_status,<br /> x_msg_count => v_msg_count,<br /> x_msg_data => v_msg_data);<br /><br /> --debug section<br /> IF v_msg_count > 0 THEN<br /> FOR j IN 1 .. v_msg_count LOOP<br /> fnd_msg_pub.get (j,<br /> FND_API.G_FALSE,<br /> v_msg_data,<br /> v_msg_dummy);<br /><br /> t_output := ('Msg' || TO_CHAR (j) || ': ' || v_msg_data);<br /><br /> DBMS_OUTPUT.put_line (SUBSTR (t_output, 1, 255));<br /> END LOOP;<br /> END IF;<br /> -- end debug<br /><br /> -- create org contact record type<br /> v_org_contact_rec.job_title := 'Manager';<br /> v_org_contact_rec.decision_maker_flag := 'N';<br /> v_org_contact_rec.created_by_module := 'HZ_CPUI';<br /><br /> -- party_id of created contact<br /> v_org_contact_rec.party_rel_rec.subject_id := v_person_party_id;<br /> v_org_contact_rec.party_rel_rec.subject_type := 'PERSON';<br /> v_org_contact_rec.party_rel_rec.subject_table_name := 'HZ_PARTIES';<br /><br /> -- party_id of the organization<br /> v_org_contact_rec.party_rel_rec.object_id := v_party_id;<br /> v_org_contact_rec.party_rel_rec.object_type := 'ORGANIZATION';<br /> v_org_contact_rec.party_rel_rec.object_table_name := 'HZ_PARTIES';<br /> v_org_contact_rec.party_rel_rec.relationship_code := 'CONTACT_OF';<br /> v_org_contact_rec.party_rel_rec.relationship_type := 'CONTACT';<br /> v_org_contact_rec.party_rel_rec.start_date := SYSDATE;<br /> v_org_contact_rec.party_rel_rec.status := 'A';<br /><br /> -- create contact<br /> HZ_PARTY_CONTACT_V2PUB.create_org_contact (<br /> p_init_msg_list => fnd_api.g_false,<br /> p_org_contact_rec => v_org_contact_rec,<br /> x_org_contact_id => v_org_contact_id,<br /> x_party_rel_id => v_party_rel_id,<br /> x_party_id => v_contact_party_id,<br /> x_party_number => v_contact_party_number,<br /> x_return_status => v_return_status,<br /> x_msg_count => v_msg_count,<br /> x_msg_data => v_msg_data);<br /><br /> --debug section<br /> IF v_msg_count > 0 THEN<br /> FOR j IN 1 .. v_msg_count LOOP<br /> fnd_msg_pub.get (j,<br /> FND_API.G_FALSE,<br /> v_msg_data,<br /> v_msg_dummy);<br /><br /> t_output := ('Msg' || TO_CHAR (j) || ': ' || v_msg_data);<br /><br /> DBMS_OUTPUT.put_line (SUBSTR (t_output, 1, 255));<br /> END LOOP;<br /> END IF;<br /> -- end debug<br /><br /> -- create phone record type for contact<br /> v_contact_point_rec.contact_point_type := 'PHONE';<br /> v_contact_point_rec.owner_table_name := 'HZ_PARTIES';<br /> v_contact_point_rec.owner_table_id := v_person_party_id;<br /> v_contact_point_rec.primary_flag := 'Y';<br /> v_contact_point_rec.contact_point_purpose := 'BUSINESS';<br /> v_phone_rec.phone_country_code := '234';<br /> v_phone_rec.phone_area_code := '01';<br /> v_phone_rec.phone_number := '08023165365';<br /> v_contact_point_rec.status := 'A';<br /> v_phone_rec.phone_line_type := 'GEN';<br /> v_contact_point_rec.created_by_module := 'HZ_CPUI';<br /><br /> -- add fax if there is one available<br /> v_telex_rec.telex_number := '04-46879879';<br /> -- emailv_email_rec.email_address := 'info@acornplc.com';<br /> -- webv_web_rec.url := 'www.acornplc.com';<br /><br /> -- add phone number to contact<br /> HZ_CONTACT_POINT_V2PUB.create_contact_point (<br /> p_init_msg_list => fnd_api.g_false,<br /> p_contact_point_rec => v_contact_point_rec,<br /> p_edi_rec => v_edi_rec,<br /> p_email_rec => v_email_rec,<br /> p_phone_rec => v_phone_rec,<br /> p_telex_rec => v_telex_rec,<br /> p_web_rec => v_web_rec,<br /> x_contact_point_id => v_contact_point_id,<br /> x_return_status => v_return_status,<br /> x_msg_count => v_msg_count,<br /> x_msg_data => v_msg_data);<br /><br /> --debug section<br /> IF v_msg_count > 0 THEN<br /> FOR j IN 1 .. v_msg_count LOOP<br /> fnd_msg_pub.get (j,<br /> FND_API.G_FALSE,<br /> v_msg_data,<br /> v_msg_dummy);<br /><br /> t_output := ('Msg' || TO_CHAR (j) || ': ' || v_msg_data);<br /><br /> DBMS_OUTPUT.put_line (SUBSTR (t_output, 1, 255));<br /> END LOOP;<br /> END IF;<br /> -- end debug<br /><br /> -- populate party site record type<br /> v_cust_account_role_rec.party_id := v_contact_party_id;<br /> v_cust_account_role_rec.role_type := 'CONTACT';<br /> v_cust_account_role_rec.cust_account_id := v_cust_account_id;<br /> v_cust_account_role_rec.cust_acct_site_id := v_cust_acct_site_id;<br /> v_cust_account_role_rec.primary_flag := 'Y';<br /> v_cust_account_role_rec.application_id := v_application_id;<br /> v_cust_account_role_rec.created_by_module := 'HZ_CPUI';<br /> v_cust_account_role_rec.status := 'A';<br /><br /> -- create party site<br /> HZ_CUST_ACCOUNT_ROLE_V2PUB.create_cust_account_role (<br /> p_init_msg_list => FND_API.G_TRUE,<br /> p_cust_account_role_rec => v_cust_account_role_rec,<br /> x_cust_account_role_id => v_cust_account_role_id,<br /> x_return_status => v_return_status,<br /> x_msg_count => v_msg_count,<br /> x_msg_data => v_msg_data);<br /><br /> --debug section<br /> IF v_msg_count > 0 THEN<br /> FOR j IN 1 .. v_msg_count LOOP<br /> fnd_msg_pub.get (j,<br /> FND_API.G_FALSE,<br /> v_msg_data,<br /> v_msg_dummy);<br /><br /> t_output := ('Msg' || TO_CHAR (j) || ': ' || v_msg_data);<br /><br /> DBMS_OUTPUT.put_line (SUBSTR (t_output, 1, 255));<br /> END LOOP;<br /> END IF;<br /> -- end debug<br /><br /> -- customer banks<br /><br /> -- create ext bank record type<br /> v_ext_bank_rec.bank_name := 'Zenith Bank Nigeria Plc';<br /> v_ext_bank_rec.country_code := v_country_code;<br /><br /> -- check if bank exists<br /> IBY_EXT_BANKACCT_PUB.check_bank_exist (<br /> p_api_version => 1.0,<br /> p_init_msg_list => fnd_api.g_true,<br /> p_country_code => v_ext_bank_rec.country_code,<br /> p_bank_name => v_ext_bank_rec.bank_name,<br /> p_bank_number => NULL,<br /> x_response => v_response,<br /> x_bank_id => v_bank_id,<br /> x_end_date => v_end_date,<br /> x_return_status => v_return_status,<br /> x_msg_count => v_msg_count,<br /> x_msg_data => v_msg_data);<br /><br /> -- if bank does not exist then create it<br /><br /> IF v_bank_id IS NULL THEN<br /> -- create supplier bank<br /> IBY_EXT_BANKACCT_PUB.create_ext_bank (p_api_version => 1.0,<br /> p_init_msg_list => fnd_api.g_true,<br /> p_ext_bank_rec => v_ext_bank_rec,<br /> x_response => v_response,<br /> x_bank_id => v_bank_id,<br /> x_return_status => v_return_status,<br /> x_msg_count => v_msg_count,<br /> x_msg_data => v_msg_data);<br /><br /> --debug section<br /> IF v_msg_count > 0 THEN<br /> FOR j IN 1 .. v_msg_count LOOP<br /> fnd_msg_pub.get (j,<br /> FND_API.G_FALSE,<br /> v_msg_data,<br /> v_msg_dummy);<br /><br /> t_output := ('Msg' || TO_CHAR (j) || ': ' || v_msg_data);<br /><br /> -- raise exception here<br /><br /> DBMS_OUTPUT.put_line (SUBSTR (t_output, 1, 255));<br /> END LOOP;<br /> END IF;<br /> -- end debug<br /><br /> -- end create bank<br /><br /> END IF;<br /><br /> -- set bank branch record<br /> v_ext_bank_branch_rec.bank_party_id := v_bank_id;<br /><br /> -- no branch name given in excel sheet<br /> v_ext_bank_branch_rec.branch_name := 'Default Branch';<br /> v_ext_bank_branch_rec.branch_type := 'OTHER';<br /><br /> -- check if branch exists<br /> IBY_EXT_BANKACCT_PUB.check_ext_bank_branch_exist (<br /> p_api_version => 1.0,<br /> p_init_msg_list => fnd_api.g_true,<br /> p_bank_id => v_ext_bank_branch_rec.bank_party_id,<br /> p_branch_name => v_ext_bank_branch_rec.branch_name,<br /> p_branch_number => NULL,<br /> x_response => v_response,<br /> x_branch_id => v_branch_id,<br /> x_end_date => v_end_date,<br /> x_return_status => v_return_status,<br /> x_msg_count => v_msg_count,<br /> x_msg_data => v_msg_data);<br /><br /> -- if branch does not exist then create it<br /> IF v_branch_id IS NULL THEN<br /> -- create bank branch<br /> IBY_EXT_BANKACCT_PUB.create_ext_bank_branch (<br /> p_api_version => 1.0,<br /> p_init_msg_list => fnd_api.g_true,<br /> p_ext_bank_branch_rec => v_ext_bank_branch_rec,<br /> x_response => v_response,<br /> x_branch_id => v_branch_id,<br /> x_return_status => v_return_status,<br /> x_msg_count => v_msg_count,<br /> x_msg_data => v_msg_data);<br /><br /> -- debug section<br /> IF v_msg_count > 0 THEN<br /> FOR j IN 1 .. v_msg_count LOOP<br /> fnd_msg_pub.get (j,<br /> FND_API.G_FALSE,<br /> v_msg_data,<br /> v_msg_dummy);<br /><br /> t_output := ('Msg' || TO_CHAR (j) || ': ' || v_msg_data);<br /><br /> -- raise exception here<br /> DBMS_OUTPUT.put_line (SUBSTR (t_output, 1, 255));<br /> END LOOP;<br /> END IF;<br /> -- end debug<br /> END IF;<br /> -- set bank account record<br /><br /> v_ext_bank_acct_rec.country_code := v_country_code;<br /> v_ext_bank_acct_rec.branch_id := v_branch_id;<br /> v_ext_bank_acct_rec.bank_id := v_bank_id;<br /><br /> -- party id of the customer<br /> v_ext_bank_acct_rec.acct_owner_party_id := v_party_id;<br /><br /> -- account name is given in excel sheet<br /> v_ext_bank_acct_rec.bank_account_name := 'Igwe Super Customer Account';<br /> v_ext_bank_acct_rec.bank_account_num := '0580034253214';<br /> v_ext_bank_acct_rec.currency := v_currency_code;<br /><br /> -- check if branch exists<br /> IBY_EXT_BANKACCT_PUB.check_ext_acct_exist (<br /> p_api_version => 1.0,<br /> p_init_msg_list => fnd_api.g_true,<br /> p_ext_bank_acct_rec => v_ext_bank_acct_rec,<br /> x_acct_id => v_acct_id,<br /> x_start_date => v_start_date,<br /> x_end_date => v_end_date,<br /> x_return_status => v_return_status,<br /> x_msg_count => v_msg_count,<br /> x_msg_data => v_msg_data,<br /> x_response => v_response);<br /><br /> -- if bank account does not exist then create it<br /> IF v_acct_id IS NULL THEN -- create bank branch<br /> IBY_EXT_BANKACCT_PUB.create_ext_bank_acct (<br /> p_api_version => 1.0,<br /> p_init_msg_list => fnd_api.g_true,<br /> p_ext_bank_acct_rec => v_ext_bank_acct_rec,<br /> x_acct_id => v_acct_id,<br /> x_response => v_response,<br /> x_return_status => v_return_status,<br /> x_msg_count => v_msg_count,<br /> x_msg_data => v_msg_data);<br /><br /> -- debug section<br /> IF v_msg_count > 0 THEN<br /> FOR j IN 1 .. v_msg_count LOOP<br /> fnd_msg_pub.get (j,<br /> FND_API.G_FALSE,<br /> v_msg_data,<br /> v_msg_dummy);<br /><br /> t_output := ('Msg' || TO_CHAR (j) || ': ' || v_msg_data);<br /><br /> -- raise exception here<br /><br /> DBMS_OUTPUT.put_line (SUBSTR (t_output, 1, 255));<br /> END LOOP;<br /> END IF;<br /> -- end debug<br /> END IF;<br /><br /> -- payer record type<br /> /* options for payment function are<br /> AR_CUSTOMER_REFUNDS - Receivables Customer Refunds<br /> CUSTOMER_PAYMENT - To collect payment from a customer<br /> */<br /><br /> v_payer_context_rec.payment_function := 'CUSTOMER_PAYMENT';<br /> v_payer_context_rec.party_id := v_party_id;<br /> v_payer_context_rec.org_type := 'OPERATING_UNIT';<br /> v_payer_context_rec.org_id := v_org_id;<br /> v_payer_context_rec.cust_account_id := v_cust_account_id;<br /> -- this is not actually the account site id<br /> -- but the account site use id<br /> v_payer_context_rec.account_site_id := v_bill_site_use_id;<br /><br /> -- assignment attributes<br /> v_assignment_attribs.instrument.instrument_type := 'BANKACCOUNT';<br /><br /> -- the external bank account id<br /> v_assignment_attribs.instrument.instrument_id := v_acct_id;<br /><br /> --dbms_output.put_line(v_acct_id);<br /> v_assignment_attribs.priority := 1;<br /> --v_assignment_attribs.start_date := sysdate;<br /><br /> -- map account to customer<br /> IBY_FNDCPT_SETUP_PUB.Set_Payer_Instr_Assignment (<br /> p_api_version => 1.0,<br /> p_init_msg_list => fnd_api.g_true,<br /> p_commit => fnd_api.g_false,<br /> x_return_status => v_return_status,<br /> x_msg_count => v_msg_count,<br /> x_msg_data => v_msg_data,<br /> p_payer => v_payer_context_rec,<br /> p_assignment_attribs => v_assignment_attribs,<br /> x_assign_id => v_assign_id,<br /> x_response => v_response);<br /><br /> -- debug section<br /> IF v_return_status != 'S' THEN<br /> IF v_msg_count > 0 THEN<br /> FOR j IN 1 .. v_msg_count LOOP<br /> fnd_msg_pub.get (j,<br /> FND_API.G_FALSE,<br /> v_msg_data,<br /> v_msg_dummy);<br /><br /> t_output := ('Msg' || TO_CHAR (j) || ': ' || v_msg_data);<br /><br /> -- raise exception here<br /><br /> DBMS_OUTPUT.put_line (SUBSTR (t_output, 1, 255));<br /> END LOOP;<br /> END IF;<br /> END IF; -- end debug<br />EXCEPTION<br /> WHEN OTHERS THEN<br /> DBMS_OUTPUT.put_line (SQLERRM);<br />END;</span></span></span></blockquote>
<br />
Hope you found it useful guys, feel free to leave a comment if have any note on the subject.<br />
<br /></div>
</div>
Hammam Muharebhttp://www.blogger.com/profile/06056751064122308940noreply@blogger.com0tag:blogger.com,1999:blog-3747830721977145321.post-21520634320946622402014-12-09T06:59:00.003-08:002015-01-04T00:35:18.643-08:00Lock on table (Oracle Apps)<div dir="ltr" style="text-align: left;" trbidi="on">
<script>
(function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){
(i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),
m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
})(window,document,'script','//www.google-analytics.com/analytics.js','ga');
ga('create', 'UA-58044283-1', 'auto');
ga('send', 'pageview');
</script>
<br />
<div dir="ltr" style="text-align: left;" trbidi="on">
Salam Alaikum,<br />
<br />
Many times we face the issue of lock on a table on the database.<br />
<br />
This could be huge problem, specially on Oracle Apps. As it can stop business process.<br />
<br />
I provide a part of code i use to know which is the table that <u><b>locked</b></u>, and additional information like session id (<b>SID</b>) thats locking the table. And other information like <b>PID</b>.<br />
<br />
This query gets information about the lock currently on the table: <br />
<blockquote class="tr_bq">
<span style="background-color: #cccccc;"><span style="color: #351c75;"><span style="font-family: "Courier New",Courier,monospace;"> SELECT c.owner<br /> ,c.object_name<br /> ,c.object_type<br /> ,fu.user_name locking_fnd_user_name<br /> ,fl.start_time locking_fnd_user_login_time<br /> ,vs.module<br /> ,vs.machine<br /> ,vs.osuser<br /> ,vlocked.oracle_username<br /> ,vs.sid<br /> ,vp.pid<br /> ,vp.spid AS os_process<br /> ,vs.serial#<br /> ,vs.status<br /> ,vs.saddr<br /> ,vs.audsid<br /> ,vs.process<br /> ,vlocked.session_id<br />FROM fnd_logins fl<br /> ,fnd_user fu<br /> ,v$locked_object vlocked<br /> ,v$process vp<br /> ,v$session vs<br /> ,dba_objects c<br />WHERE vs.sid = vlocked.session_id<br />AND vlocked.object_id = c.object_id<br />AND vs.paddr = vp.addr<br />and vs.type <> 'BACKGROUND' -- very important to exclude background sessions<br /><span style="font-size: small;">AND vp.spid = fl.process_spid(+)</span><br />AND vp.pid = fl.pid(+)<br />AND fl.user_id = fu.user_id(+)<br />AND c.object_name LIKE '%' || upper('&tab_name_leaveblank4all') || '%'<br />AND nvl(vs.status,'XX') != 'KILLED';</span></span></span></blockquote>
<b> </b><br />
<b> </b>And then you can share the query output with your DBA (recommended), or you can kill the session that's locking the table<b> </b>by yourself (<u>You have to be extra careful with the kill session command; it can cause an instance CRASH!!!</u>).<br />
<br />
The code to kill a session is:<br />
<br />
<blockquote class="tr_bq">
<pre><span style="background-color: #cccccc;"><span style="font-family: "Courier New",Courier,monospace;"><span style="font-size: small;"><span style="color: #351c75;">ALTER SYSTEM KILL SESSION '&SID,&serial#';</span></span></span></span></pre>
</blockquote>
<br />
Hope you found it useful guys, feel free to leave a comment if have any note on the subject.<br />
<br /></div>
</div>
Hammam Muharebhttp://www.blogger.com/profile/06056751064122308940noreply@blogger.com3