psofttechguy.blogspot.com

PSoftTechGuy

Another PeopleSoft Tech Blog. Friday, August 22, 2008. Since I wrote the article titled "Running Dynamic SQL Object in PeopleCode" I got a hand full of feedback that the title is confusing. They always thought that it was about Dynamic View, well its probably a bad choice of title on my part. I will make it up to anyone who's looking for the Dynamic View code or how to use it. 1 Get the field that has a promt using GetField function. Fld CarNbr = GetField(Field.CAR NBR);. Data Name = CAR TBL.NAME;. Here ...

http://psofttechguy.blogspot.com/

OVERVIEW OF psofttechguy.blogspot.com

TRAFFIC RANK

>1,000,000

REVIEWS

0

PAGES IN THIS WEBSITE

9

LINKS TO THIS WEBSITE

CONTACTS

ADDRESSES

SOCIAL LINKS

ONLINE SINCE

WEBSITE DETAILS

SEO

PAGES

SIMILAR SITES

TRAFFIC RANK FOR PSOFTTECHGUY.BLOGSPOT.COM

TODAY'S RATING

>1,000,000

TRAFFIC RANK - AVERAGE PER MONTH

BEST MONTH

August

AVERAGE PER DAY Of THE WEEK

HIGHEST TRAFFIC ON

Thursday

TRAFFIC BY CITY

Sign up

CUSTOMER REVIEWS

Average Rating: 2.7 out of 5 with 6 reviews

5 star

0

4 star

2

3 star

2

2 star

0

1 star

2

Hey there! Start your review of psofttechguy.blogspot.com

AVERAGE USER RATING

Write a Review

WEBSITE PREVIEW

LOAD TIME

0.6 seconds

FAVICON PREVIEW

16x16
32x32
64x64
128x128

CONTACTS AT PSOFTTECHGUY.BLOGSPOT.COM

ADD CONTACT

Login

TO VIEW CONTACTS

Remove Contacts

FOR PRIVACY ISSUES

CONTENT

PAGES IN
THIS WEBSITE

9

SSL

EXTERNAL LINKS

15

SITE IP

173.194.121.12

LOAD TIME

0.551 sec

SCORE

6.2

PAGE TITLE

PSoftTechGuy | psofttechguy.blogspot.com Reviews

<META> DESCRIPTION

Another PeopleSoft Tech Blog. Friday, August 22, 2008. Since I wrote the article titled Running Dynamic SQL Object in PeopleCode I got a hand full of feedback that the title is confusing. They always thought that it was about Dynamic View, well its probably a bad choice of title on my part. I will make it up to anyone who's looking for the Dynamic View code or how to use it. 1 Get the field that has a promt using GetField function. Fld CarNbr = GetField(Field.CAR NBR);. Data Name = CAR TBL.NAME;. Here ...

<META> KEYWORDS

1 psofttechguy

2 using dynamic view

3 rstemp flush ;

4 rstemp insertrow &i ;

5 end while;

6 no comments

7 labels %edittable

8 copyfieldsto

9 createsql

10 dynamic view

CONTENT

Page content here

KEYWORDS ON PAGE

psofttechguy,using dynamic view,rstemp flush ;,rstemp insertrow &i ;,end while;,no comments,labels %edittable,copyfieldsto,createsql,dynamic view,fetch,getfield,prompt,sqltext,if all &filedirectory then,else,end if;,labels app engine,file layout,write

SERVER

GSE

CONTENT-TYPE

utf-8

GOOGLE PREVIEW

PSoftTechGuy | psofttechguy.blogspot.com Reviews

https://psofttechguy.blogspot.com

Another PeopleSoft Tech Blog. Friday, August 22, 2008. Since I wrote the article titled "Running Dynamic SQL Object in PeopleCode" I got a hand full of feedback that the title is confusing. They always thought that it was about Dynamic View, well its probably a bad choice of title on my part. I will make it up to anyone who's looking for the Dynamic View code or how to use it. 1 Get the field that has a promt using GetField function. Fld CarNbr = GetField(Field.CAR NBR);. Data Name = CAR TBL.NAME;. Here ...

INTERNAL PAGES

psofttechguy.blogspot.com

1

PSoftTechGuy: June 2008

http://psofttechguy.blogspot.com/2008_06_01_archive.html

Currently in Tools Release 8.54.03 and Application Release HRMS 9.2. Tuesday, June 24, 2008. Calling SQR from PeopleCode (Page, Record, App Engine). This is a request from a friend to post a sample code that calls SQR from PeopleCode.This can be applicable if you need your page or app engine to call an independent SQR process/report. The following example was done in App Engine PeopleCode;. AProcessType = "SQR Report". Create the ProcessRequest Object */. Set all the Required Properties */. HR PERS VW);.

2

PSoftTechGuy: July 2008

http://psofttechguy.blogspot.com/2008_07_01_archive.html

Currently in Tools Release 8.54.03 and Application Release HRMS 9.2. Tuesday, July 29, 2008. Creating Outbound File from File Layout Using App Engine. 1 Create an App Engine that will process all the data. 2 Dump all processed data into staging tables. 3 Create a view out of those staging tables. The view structure will be similar to file layout segment. If you have a parent-child relationship on the file layout, the view key structure should be similar to those file layout. Write data from file layout*/.

3

PSoftTechGuy: May 2008

http://psofttechguy.blogspot.com/2008_05_01_archive.html

Currently in Tools Release 8.54.03 and Application Release HRMS 9.2. Saturday, May 31, 2008. App Engine running XML Publisher with PS Query Data Source. Haven't you notice that every posts up to this point are XML Publisher related? With this code;. RcdQryPrompts = &ReportDef.GetPSQueryPromptRecord();. Prompt(&ReportDef.GetDataSource().Name, ". ReportDef.ProcessReport(&sTemplateId, %Language User. Friday, May 30, 2008. Sending Email Using Application Engine (XML Publisher Report as Attachment). MyXMLFile...

4

PSoftTechGuy: Component Interface for Student Award Entry

http://psofttechguy.blogspot.com/2008/06/component-interface-for-student-award.html

Currently in Tools Release 8.54.03 and Application Release HRMS 9.2. Friday, June 6, 2008. Component Interface for Student Award Entry. RemoteCall(call validateCOBOL program.);. RemoteCall(call postCOBOL program.);. Ci = &session.GetCompIntfc(CompIntfc.yourCI);. CiPreValidate(); /*my custom CI method contains code to validate before RemoteCall*/. CiPostValidate(); /*my custom CI method contains code to validate after RemoteCall*/. CiPosted(); /*my custom CI method contains code to post after RemoteCall*/.

5

PSoftTechGuy: August 2008

http://psofttechguy.blogspot.com/2008_08_01_archive.html

Currently in Tools Release 8.54.03 and Application Release HRMS 9.2. Friday, August 22, 2008. Since I wrote the article titled "Running Dynamic SQL Object in PeopleCode" I got a hand full of feedback that the title is confusing. They always thought that it was about Dynamic View, well its probably a bad choice of title on my part. I will make it up to anyone who's looking for the Dynamic View code or how to use it. 1 Get the field that has a promt using GetField function. Data Name = CAR TBL.NAME;. Here ...

UPGRADE TO PREMIUM TO VIEW 4 MORE

TOTAL PAGES IN THIS WEBSITE

9

LINKS TO THIS WEBSITE

harshachowdaryworld.blogspot.com

PeopleSoft World: June 2009

http://harshachowdaryworld.blogspot.com/2009_06_01_archive.html

Please do post your comments and suggestions for me to improve on chowdary1105@gmail.com. Monday, June 29, 2009. To overwrite search record on component by using peoplecode. Provide the search keys values in searchinit event. Make sure, in the component properties,"Force Search processing" is switched off. Labels: To overwrite search record on component by using peoplecode. Code to print a image in SQR. Let $imgpath = $DB Server Path 'logo.jpeg'. Labels: Code to print a image in SQR. Reports – Simp...

harshachowdaryworld.blogspot.com

PeopleSoft World: Steps for creating a GOTO ROW

http://harshachowdaryworld.blogspot.com/2010/01/steps-for-creating-goto-row.html

Please do post your comments and suggestions for me to improve on chowdary1105@gmail.com. Wednesday, January 6, 2010. Steps for creating a GOTO ROW. STEPS FOR CREATING GOTO ROW. 1Create a new Field (TIN1 GOTOROW). 2Create a new record (TIN1 GOWTO WRK) and select the radio button Derived/Work. Write the following below people code in the Field change in the Field level in TIN1 GOWTO WRK table. Tinku = DoModal(Page.TIN1 GTROW PNL, "Secondary Page ", - 1, - 1);. If (&tinku = 1) Then. Set ID and Business Unit.

harshachowdaryworld.blogspot.com

PeopleSoft World: January 2010

http://harshachowdaryworld.blogspot.com/2010_01_01_archive.html

Please do post your comments and suggestions for me to improve on chowdary1105@gmail.com. Wednesday, January 6, 2010. Steps for creating a GOTO ROW. STEPS FOR CREATING GOTO ROW. 1Create a new Field (TIN1 GOTOROW). 2Create a new record (TIN1 GOWTO WRK) and select the radio button Derived/Work. Write the following below people code in the Field change in the Field level in TIN1 GOWTO WRK table. Tinku = DoModal(Page.TIN1 GTROW PNL, "Secondary Page ", - 1, - 1);. If (&tinku = 1) Then. Tuesday, January 5, 2010.

harshachowdaryworld.blogspot.com

PeopleSoft World: May 2010

http://harshachowdaryworld.blogspot.com/2010_05_01_archive.html

Please do post your comments and suggestions for me to improve on chowdary1105@gmail.com. Wednesday, May 19, 2010. Page Start to Display in ADD mode (or) component in ADD mode. When we click on the component portal in menu then (the page with ADD button display) Then the following below PeopleCode Events will fire. Search Processibg in Add Mode:. Enter the Employee and click on Add. Record Field Field Formula. Page Dispaly (or)Component Build Process in ADD Mode:. Page Activate fires and displays the page.

harshachowdaryworld.blogspot.com

PeopleSoft World: PeopleSoft FAQ

http://harshachowdaryworld.blogspot.com/p/peoplesoft-faq.html

Please do post your comments and suggestions for me to improve on chowdary1105@gmail.com. 1Can we insert sub record into another subrecord? Ans:Yes,we can insert a Sub-record into another Sub-record.When a Sub-record definition is opened goto Insert and Sub-record. 2Difference between Save Prechange and Save Postchange? 3What is naming convention of SQR program? Ans:The program must End with ‘.SQR’ extension and the length of name must be =8 characters. 5Order of Execution of Deferred processing? 3Extern...

harshachowdaryworld.blogspot.com

PeopleSoft World: Inserting the data into 3 levels (0,1,2,3 levels) into database from flat file using Application Engine

http://harshachowdaryworld.blogspot.com/2010/05/3-level-rowset-code-to-insert-data-into.html

Please do post your comments and suggestions for me to improve on chowdary1105@gmail.com. Monday, May 3, 2010. Inserting the data into 3 levels (0,1,2,3 levels) into database from flat file using Application Engine. Inserting the data into 3 levels (0,1,2,3 levels) into database from flat file using Application Engine Below is the sample code (Ive used 2 fields in all the 3 levels). Organisational ID, Organisational Name. College ID, College Name. Department ID, Department Name. If &myfile.Isopen Then.

harshachowdaryworld.blogspot.com

PeopleSoft World: September 2009

http://harshachowdaryworld.blogspot.com/2009_09_01_archive.html

Please do post your comments and suggestions for me to improve on chowdary1105@gmail.com. Tuesday, September 29, 2009. PS HS EMPL REL CAN. PS HS EMPL REL LNG. PS HS EMPL SUB CAN. PS HS EMPL SUB LNG. PS INJ CLMADDR CAN. PS PERSONL DTA LNG. PS PERS DATA AET. PS PERS DATA EFFDT. PS PERS DTAEFF LNG. PS JOB EARNS DIST. PS BEN PROG PARTIC. Labels: PeopleSoft HR Tables. PS HS EMPL REL CAN. PS HS EMPL REL LNG. PS HS EMPL SUB CAN. PS HS EMPL SUB LNG. PS INJ CLMADDR CAN. PS JOB, PS PERSONAL DATA. PS PERSONL DTA LNG.

harshachowdaryworld.blogspot.com

PeopleSoft World: October 2009

http://harshachowdaryworld.blogspot.com/2009_10_01_archive.html

Please do post your comments and suggestions for me to improve on chowdary1105@gmail.com. Wednesday, October 7, 2009. How tofind out which tables contain a certain SETID value. This post is to share another alternative on how to find out which tables contain a certain SETID value. Navigate to PeopleTools Archive Data Find Data. On the " Field Name. Field enter " SETID. On the " Value to Match. Field enter the value you are looking for. This can be used for any other table/value, not only SETID. PeopleSof...

harshachowdaryworld.blogspot.com

PeopleSoft World: August 2009

http://harshachowdaryworld.blogspot.com/2009_08_01_archive.html

Please do post your comments and suggestions for me to improve on chowdary1105@gmail.com. Sunday, August 30, 2009. How to read the runcontrol parameters in AE. We can read the Runcontrol Parameters in Application Engine by the following below 2. Select(EMPLID)selct EMPLID from PS AERUNCONTROL where PROCESS INSTANCE=%PROCESS INSTANCE AND OPRID=%oprid. SQL="Select EMPLID from PS AERUNCONTROL where PROCESS INSTANCE=" PS TEST AET.PROCESS INSTANCE "and OPRID=" %oprid. Wednesday, August 19, 2009. DI = &RS2(&J)...

UPGRADE TO PREMIUM TO VIEW 6 MORE

TOTAL LINKS TO THIS WEBSITE

15

OTHER SITES

psoftskins.com

Business profile for psoftskins.com provided by Network Solutions

Phone: Your business phone number. Fax: Your business fax number. Email: Your business e-mail address. The type of business you are in. Your list of brands. Products and/or services you provide. Coupons and other discount information you offer. Any other information about your business. Your hours of operation. Methods of payment you accept. If this is your Web site, you can customize your business profile from your account at Network Solutions. To edit your business profile.

psoftskins.net

Business profile for psoftskins.net provided by Network Solutions

Phone: Your business phone number. Fax: Your business fax number. Email: Your business e-mail address. The type of business you are in. Your list of brands. Products and/or services you provide. Coupons and other discount information you offer. Any other information about your business. Your hours of operation. Methods of payment you accept. If this is your Web site, you can customize your business profile from your account at Network Solutions. To edit your business profile.

psoftsolution.com

Pinnacle Software Solutions

Solutions & Services. Ready To Use Off the Shelf Solutions. Permanent & Contract Staffing [Staff Augmentation]. Managed Services & Outsourcing. System Consultancy & Training. Get to know us! Our Vision is to provide the best possible services in less possible time at competitive prices by following best practices and to help organizations run their businesses smoothly and efficiently. Our Awesome Professional Services! We offer recruitment services, managed services and system consultancy. Our happy, sat...

psoftsolutions.com

Pinnacle Software Solutions

Solutions & Services. Ready To Use Off the Shelf Solutions. Permanent & Contract Staffing [Staff Augmentation]. Managed Services & Outsourcing. System Consultancy & Training. Get to know us! Our Vision is to provide the best possible services in less possible time at competitive prices by following best practices and to help organizations run their businesses smoothly and efficiently. Our Awesome Professional Services! We offer recruitment services, managed services and system consultancy. Our happy, sat...

psoftsupport.com

www.psoftsupport.com

psofttechguy.blogspot.com

PSoftTechGuy

Another PeopleSoft Tech Blog. Friday, August 22, 2008. Since I wrote the article titled "Running Dynamic SQL Object in PeopleCode" I got a hand full of feedback that the title is confusing. They always thought that it was about Dynamic View, well its probably a bad choice of title on my part. I will make it up to anyone who's looking for the Dynamic View code or how to use it. 1 Get the field that has a promt using GetField function. Fld CarNbr = GetField(Field.CAR NBR);. Data Name = CAR TBL.NAME;. Here ...

psofttechnology.tripod.com

Priya-soft Technologies

Welcome to our web site! On this home page we'll introduce our business and highlight important areas on our site. New Delhi- Jaipur - Kanpur. The On-line service industry is rapidly changing and encompasses a wide range of products and services. Operating a computer services business is not easy, but building an effective web site can make a huge difference in responsiveness and customer satisfaction. Please get in touch to offer comments and join our mailing list. New Delhi - Jaipur - Kanpur.

psofttechsig.oaug.org

PeopleSoft Tech SIG HOME

The PeopleSoft Technology SIG. Welcome To the PeopleSoft Technology SIG. Attention OAUG PeopleSoft Technology SIG Members. Dear PeopleSoft Tech SIG Member,. If you DO NOT wish to receive information on the latest releases of PeopleSoft and support from Quest s PeopleSoft community, please email uginfo@questdirect.org. With the subject Unsubscribe from Quest by February 4, 2013. As part of this transition, the PeopleSoft Tech SIG Website will also be hosted by Quest and can be found at:. Attend COLLABORAT...

psofttula.ru

Компания «Питер Софт»

Наш адрес: 300012, г. Тула, ул. Первомайская/М.Тореза, 1/8. Серверное оборудование и системы хранения. Бумага и другие носители изображения. Торговое и противокражное оборудование. Гарантийное обслуживание и ремонт. Ремонт принтеров и плоттеров. Ремонт источников бесперебойного питания. Ремонт широкоформатных систем печати. Техническое обслуживание на договорной основе. Проектирование и монтаж сетей. Установка и обслуживание торгового оборудования и систем защиты от краж. XEROX Versant 80 Press. Сервисна...

psoftusers.com

Ashburn PeopleSoft Consulting, PeopleSoft Consultants and PeopleSoft Experts in Ashburn

Cendien specializes in PeopleSoft staffing services and provides talented PeopleSoft expertise to Ashburn clients. With a proven process to qualify and deliver PeopleSoft consultants, we provide the right resources to support demanding engagements. Our PeopleSoft staffing team is dedicated to exclusively focus on PeopleSoft expertise. We provide Ashburn PeopleSoft consulting expertise in the following areas:. Our client base consists of organizations throughout various industries including, but not limit...

psoftware.com

Under Construction

This page is under construction. Please come back soon!