![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Peoplecode
conanxun
这个作者很懒,什么都没留下…
展开
-
Determine File Output Location
Suppose I want to create a file (printable report, log file, etc), where should I create the file? If you want the file available from the View Log/Trace link, then use the following SQL to determine转载 2012-08-03 13:38:49 · 309 阅读 · 0 评论 -
Secrets of the PeopleCode
http://www.vijaymukhi.comCoded Practices How many twins do you know? At least a couple? Even with the most identical twins, there is usually some distinguishing character that sets one apart f转载 2013-01-15 16:18:30 · 113 阅读 · 0 评论 -
Insert or Update to a Long Character field in Peoplesoft.
When inserting or updating a Long Character field in Peoplesoft using peoplecode, standalone SQL or Application Engine SQL, if the target string to be inserted happens to be more than 254 characte转载 2013-01-31 14:42:01 · 67 阅读 · 0 评论 -
Stop Using Page Activate PeopleCode
I think the Page Activate PeopleCode event is evil. There are many delivered components from Oracle that actually use this event to do extensive processing and to load buffer data. So I see developers转载 2013-02-18 20:47:34 · 67 阅读 · 0 评论 -
页面跳转的URL方式
注意,字段一定要足够长,否则会截断url。建立一个dw的记录,放一个2000字符长度的字段,然后拖一个 按钮和连接 的控件进去。在 本记录的 fielddefault事件中,赋值如下:设置连接的文字: &RS1(1).CST_TR_PLN_UPDV.URLS.Label = &DES1; &RS1(2).CST_TR_PLN_UPDV.URL转载 2013-03-19 14:31:46 · 106 阅读 · 0 评论 -
查看某个用户对Component Interface的使用权
SELECT A.BCNAME,A.BCDISPLAYNAME,A.MENUNAME ,A.DESCR, A.DESCRLONGFROMPSBCDEFN A WHERENOT EXISTS (SELECT B.CLASSID FROMPS_PSBCDEFN_VW B, PSOPRCLS C WHEREB.BCNAME = A.BCNAME A转载 2013-03-19 14:36:33 · 52 阅读 · 0 评论 -
PeopleCode取组件缓冲区(Component Buffer)数据小结
Local Rowset &RS_Level0, &RS_Level1;Local Row &Row_Level0, &Row_Level1;Local Record &Rec_TaskRsrc;Local Field &Fld_PctAvail;REM Get rowset of level0 (获取0层的行集合);&RS_Level0 = GetLevel0转载 2013-03-15 11:43:14 · 91 阅读 · 0 评论 -
回车实现方式:Carriage Return in PeopleCode
Sometime back, I was writing an application engine using PeopleCode and I needed to insert a carriage return between two long strings getting concatenated so they look like two sentences one after the转载 2016-06-13 17:01:02 · 255 阅读 · 0 评论 -
PeopleCode Variable Names
A PeopleCode variable naming convention should be part of your development standards.All variables should be declared and scoped (Global, Component or Local). Undeclared variables are included in Pe转载 2016-06-13 17:08:10 · 178 阅读 · 0 评论 -
What Are the Tree Table Names
E-TR: What are the names of the Tree tables?Names of Tree Tables and relationship parent/childPeopleSoft Tables – Tree ManagerTable Name Table DescriptionPSTREEDEFN Stores valid tree definitio转载 2016-06-13 17:11:44 · 247 阅读 · 0 评论 -
PeopleCode Events
OverviewIf you are reading this, you are probably familiar with creating fields, records, pages, components, and menus. With these objects alone, you can create working development projects. Simpl转载 2012-11-06 16:58:04 · 1321 阅读 · 0 评论 -
Email Address Validation Function
Did some changes in the delivered code. Page fields were hard coded in the delivered code, made it dynamic.Function validateEmailAddressEntry(&Email_Addr As string, &Page_Field As string)L转载 2012-11-06 12:00:10 · 99 阅读 · 0 评论 -
peoplecode实现sleep功能
如果想要让程序延迟几秒执行,可以编写如下代码:Local time &StartTime, &CurrentTime; &StartTime = %Time; &CurrentTime = %Time; While ((&CurrentTime - &StartTime) < &Seconds) &CurrentTime = %Time; End-While;当原创 2012-11-05 19:53:54 · 835 阅读 · 0 评论 -
Difference between FieldEdit and FieldChange events
Field Change PeopleCode is for recalculating field values based on changes made to other fields. For instance, suppose you have 2 fields, rate and quantity and there is another field which shows total转载 2012-08-03 13:52:41 · 365 阅读 · 0 评论 -
Understanding Peoplesoft Trace
Here are the steps to generate application and Application Engine traces, to troubleshoot any application issues.Before you start generating traces, you need to make sure that the following paramete转载 2012-08-21 16:55:21 · 1282 阅读 · 0 评论 -
计算两个日期相隔天数
&NUM_DAYS = Abs(Days(HIRE_Date) - Days(RELEASE_Date));原创 2012-09-14 15:10:05 · 620 阅读 · 0 评论 -
PeopleCode启动SQR程序
&PROCESS_NAME = "SQRNAME";&PROCESS_TYPE = "SQR Report";&RUN_CNTL_ID = "YOUR_RUN_ID";&RUN_CONTROL = ScheduleProcess(&PROCESS_TYPE, &PROCESS_NAME, "2", &RUN_CNTL_ID, &PRCS_INST);REM |+--------------原创 2012-09-14 15:15:27 · 465 阅读 · 0 评论 -
禁用Scroll中的添加或删除按钮
&ROWSET_LEVEL2 = GetLevel0()(1).LEVEL1_REC(5).GetRowset(SCROLL.LEVEL2_REC); */If &ITEM_TYPE.Enabled = True Then&RI_Scroll_2 = GetLevel0()(1).APG_REFUND(1).GetRowset(Scroll.APG_TIV_ELIG_DB);&RI_Sc转载 2012-09-14 16:44:43 · 579 阅读 · 0 评论 -
Auto Insert New Hires as PS Users
The following is a piece of App Engine code that will take new hires and auto insert them as a Peoplesoft User Profile with default data and component permission lists so they can use self service aut转载 2012-09-14 17:03:48 · 543 阅读 · 0 评论 -
PeopleCode中使用Map
参考 HRTR_UTILITIES/** *@author Vinay Vegunta *@date 03/09/2004 * *This class provides a simple Hashtable implementation for storing and looking up objects based on String keys */class Hashtabl原创 2012-09-18 11:32:08 · 1078 阅读 · 0 评论 -
Generate Excel Spreadsheet from PeopleCode
PeopleBooks documents the built-in function GenerateQueryContentURL. It's a helpful function that lets you create a link to a query.If you append the query criteria as URL parameters, you can br转载 2012-09-18 12:14:47 · 724 阅读 · 0 评论 -
Application Engine
AE工具使用SQL和PeopleCode运行批处理进程,不需要编译,也不需要产生SQL语句,只执行SQL语句。AE集成进PeopleTools套件中。执行部分是用C++语言编写的。AE中的所有对象都保存在数据库中。所有fields、records、functions、component interfaces、Meta-SQL以及其他对象都能够在AE程序中使用。可重用性是AE程序最大的优点之一。原创 2012-09-18 15:04:35 · 246 阅读 · 0 评论 -
PeopleCode 发送邮件并给邮件添加附件
import PT_MCF_MAIL:*;Local PT_MCF_MAIL:MCFOutboundEmail &email = create PT_MCF_MAIL:MCFOutboundEmail();&email.From = &FromAddress;&email.Recipients = &ToList;&email.Subject转载 2016-06-13 17:16:02 · 574 阅读 · 0 评论