How to pass Dynamic Drop Down Value using peoplecode

PeopleSoft provides the functions ClearDropDownList & AddDropDownItem to solve the problem defined above. Certain points to be noted:

1. The variable type (here &fld_TypeField_l) should be Field .

2. If the drop down box has been cleared using ClearDropDownList and subsequently NO AddDropDownItem function call has been used, all the default translate value descriptions will be displayed .

3. The format of AddDropDownItem is &Field_Variabe.AddDropDownItem('A', 'Approved'). Always note that the codes used in AddDropDownItem (here 'A')should be the same codes used in the translate .

/*** VARIABLE DECLARATIONS ****/
Local Field &fld_TypeField_l;

/*** GET THE FIELD ***/
&fld_TypeField_l = GetField(IMF_PAY_MSG_MST.ACTION_TYPE);

/*** CLERING THE DROP DOWN VALUE ****/
&fld_TypeField_l.ClearDropDownList();

/*** ADDING THE VALUES IN DROP DOWN ****/
&fld_TypeField_l.AddDropDownItem('A', 'Approved'); 
&fld_TypeField_l.AddDropDownItem('C', 'Cancelled'); 
&fld_TypeField_l.AddDropDownItem('P', 'Pending'); 
&fld_TypeField_l.AddDropDownItem('O', 'On-Hold'); 
&fld_TypeField_l.AddDropDownItem('R', 'Rejected');

Read More»

App Designer Tutorial

What is an application designer? Application Designer is an integrated development environment that enables you to work with the numerous objects of a business application in a single work area.

Features in App Designer

Multiple Document interface Drag and Drop Pop - up Menus Property sheets Dynamic tool bars and Menus    Application designer Components

Steps to Designing an Application. 1)Design the Application 2)Define new Fields 3)Create the Record Definition 4)Build the Record 5)Create Page Definition 6)Define the Component 7)Create the Menu Definition 8)Enable Security 9)Test the Application. Important Points to Remember in App Designer.Field Individual pieces of data—such as an employee ID—that can be entered by the user and stored in the database or a column on a table or in a view. Field is column in a table or Record. What is Record?

All the data that resides in PeopleSoft applications is stored in tables, or records, as part of a relational database system. Each record definition describes the properties of an underlying SQL table.

Record is a collection of Fields

What is Page?

Pages provide a way to enter, view, and edit data online

Collection of records.

What is Component?

Represents a logical business transaction or a set of logically related pages that are processed together. collection of pages

What is Menu?

Enables access to the components you build, along with the pages contained in the components

Collection of Components What is Project? A user-defined collection of related object definitions created for the purpose of developing, customizing, or upgrading a PeopleSoft application.

SQL Can be entire SQL programs, or just fragments of SQL statements that you want to re-use.

Style Sheet

A collection of styles that can be used by Internet Architecture application pages.

Activity

A map showing the individual steps, events, and routings that comprise a complete activity within a business process.

Application Engine

A program comprising SQL statements and PeopleCode programs to be run in batch mode, as an alternative to using COBOL

File Layout Definition (or mapping) of a file to be processed. It identifies where in a file data fields are located. Component Interface Externalizes access to a component, so it can be used by a third party or an application message

Start the Development by:

1.Create a new project(Optional). File>New>Project

2. Set Project Options(Optional). Tools>Options

3. Name and save the Project(Optional). File>Save Project As

Read More»

Hiding Group Boxes on Peoplesoft Pages

however if the requirement is to selectively display group box in case a particular condition is true or in case for a particular employee or role, you can display the group box by the below code:

if ASGN_VW.EMPLID = "101" Then

DERIVED_HR.AB_PLAN_GRPBOX.Visible = False;

Else

DERIVED_HR.AB_PLAN_GRPBOX.Visible = True;

End-If;

Read More»

What is use of set control field in record field properties?

      If we specify one field as a set control field then we will retrieve data based on this

      when we are using prompt table. Based on this field only we can have valid prompt

      list at the time of prompt button clicking.

Read More»

What is the Difference between Display control field and Relational Display control field?

        A related display field is for display purposes only - it always references a row that's

       not being updated from the current page. The display control when you select

       Related Display field, you need to relate it to the appropriate control. A list of all the

       controls on the page marked as display control fields in the Related control field box.

       Select the control field to which this particular related display is related

Read More»