Posts

Showing posts with the label example

PeopleCode MessageBox function | Using PeopleCode MessageBox Features

A. The Basic Version The ‘MessageBox’ function is such a handy piece of code for troubleshooting that you often find yourself using the ‘basic version’ without giving much thought to how the statement really works: MessageBox(0, "", 0, 0, "Display message here"); This post will take a closer look at some of the additional features of ‘MessageBox’, beyond its basic usage above. In particular, we consider each of the parameters in more detail. B. Parameter 1: Message Type The first parameter specifies the type of message you wish to display. In most cases, the parameter is set to a value of ‘0’, which displays a message with an ‘OK’ button only. However, the function comes with a number of other options for setting the message type. These can be entered as either a numeric value (‘0’) or a constant (‘%MsgStyle_OK’): 0 – %MsgStyle_OK 1 – %MsgStyle_OKCancel 2 – %MsgStyle_AbortRetryIgnore 3 – %MsgStyle_YesNoCancel 4 – %MsgStyle_YesNo 5 – %MsgStyle_RetryCancel This means ...

Peoplesoft Query - How to know the navigation for a particular oracle peoplesoft component or oracle peoplesoft page

How to know the navigation for a particular Oracle PeopleSoft Component or Oracle Peoplesoft Page For knowing the navigation of any page in peoplesoft. Just get the name of its component and place it in the query's last parameter (Component Name) and execute. Then follow the given navigation on PIA to access the Page. SELECT  DISTINCT 'Root > '||DECODE(LTRIM(RTRIM(A.PT_IQLEVEL1_LBL)),'','',  A.PT_IQLEVEL1_LBL||' > ')||DECODE(LTRIM(RTRIM(A.PT_IQLEVEL2_LBL )),'','',  A.PT_IQLEVEL2_LBL||' > ')||  DECODE(LTRIM(RTRIM(A.PT_IQLEVEL3_LBL)),'','',A .PT_IQLEVEL3_LBL||' >  ')||DECODE(LTRIM(RTRIM(A.PT_IQLEVEL4_LBL)),'', '',A.PT_IQLEVEL4_LBL|| ' >  ')||  DECODE(LTRIM(RTRIM(A.PORTAL_LABEL)),'','',A.PO RTAL_LABEL||' >  ')||DECODE(LTRIM(RTRIM(B.PT_IQLEVEL1_LBL)),'', '',B.PT_IQLEVEL1_LBL||' > ')||  DECODE(LTRIM(RTRIM(B.PT_IQ...