Oracle EBS Code Sample
文章平均质量分 85
田攀
tian.pan@qq.com
展开
-
[Code Sample]Alert "Do you want to save the changes you have made?"
1: When exiting form, Check the form status. 2: If the status is changed, then display the customized alert.in a KEY-EXIT trigger at form level, enter the following code: declare button_val number; b原创 2012-04-10 13:32:19 · 4938 阅读 · 0 评论 -
Lot Number Descriptive Flex Field:Lot Attributes DFF & Maintain Lot Number DFF
Lot Entry中的有两个DFF,一个是Maintain Lot Number DFF,另一个是Lot Attributes DFF知道基表,查看对应DFFSELECT * FROM FND_DESCRIPTIVE_FLEXS WHERE application_table_name = 'MTL_LOT_NUMBERS';FND_DESCRIPTIVE_FLEXS表中几个字段需要注意,APPL原创 2012-08-07 17:33:56 · 4470 阅读 · 0 评论 -
How to invoke Standard Choose Organizations Form From your form
Step1: Create 4 parameters in your custom form,ORG_ID,ORG_CODE,ORG_NAME,CHART_OF_ACCOUNTS_IDAttributes like belowStep2: Pre-Form Trigger, call FND_ORG.CHOOSE_ORG;(FND_ORG.CHOOSE_ORG定义在FNDSQF.pll文件中)An原创 2013-03-29 13:36:52 · 5382 阅读 · 0 评论 -
Sample of API FND_PROFILE
1. FND_PROFILE.GET(‘Name of the Profile’, variable name);SELECT fnd_profile.value('PROFILEOPTION') ,fnd_profile.value('MFG_ORGANIZATION_ID') ,fnd_profile.value('ORG_ID') ,fnd_profile原创 2012-07-17 11:13:01 · 5552 阅读 · 0 评论 -
[Code Sample]loop trough all records of a block
Sample 1:declare currRec integer; begin -- go to the desired block navigate_to_block('BLOCK_NAME'); -- save the current record position currRec := :system.cursor_record; first_record原创 2012-12-25 18:14:06 · 3227 阅读 · 0 评论 -
[Code Sample]loop trough all blocks of a form
.....formname := NAME_IN('system.current_form');blockname := GET_FORM_PROPERY(formname, FIRST_BLOCK);WHILE (blockname is not null) LOOP IF (GET_BLOCK_PROPERTY(blockname, BASE_TABLE) is not NULL) THEN原创 2013-01-11 17:20:33 · 2294 阅读 · 0 评论 -
Set_XXX_Property Build-Ins
Build-In List· SET_APPLICATION_PROPERTY· SET_BLOCK_PROPERTY· SET_CANVAS_PROPERTY· SET_FORM_PROPERTY· SET_ITEM_PROPERTY· SET_ITEM_INSTANCE_PROPERTY· SET_LOV_PROPERTY· SET_MENU_ITEM_PROPERTY· S原创 2012-12-25 18:55:28 · 8378 阅读 · 0 评论 -
Custom.pll example to make DFF read only
在特定的职责下,让DFF只读 /* *************************** Code to make DFF Read Only ****************** */ IF (event_name = 'WHEN-NEW-BLOCK-INSTANCE' AND form_name = 'PERWSEAD' AND block_name = 'ABA') T原创 2012-08-07 16:44:30 · 2783 阅读 · 0 评论 -
Oracle API Availability – Profile
zz:http://www.oracleappshub.com/api/oracle-api-availability-profile/ In oracle user Profile functionality is provided in the FND_PROFILE package and the FNDSQF library. What is inside this API:转载 2012-04-28 18:44:43 · 2338 阅读 · 0 评论 -
Oracle Apps修改用户密码的API
Oracle Apps修改用户密码API方法一:fnd_user_pkg.updateuser -- Change password of TEST_USER to oracle123 (does not ask for reset on first logon)BEGIN fnd_user_pkg.updateuser (x_user_name => 'T原创 2014-08-27 18:23:18 · 5484 阅读 · 0 评论