Creating LOVs
1. Start a new module by clicking on File - New - Form.
2. Change Module’s name to TEST_LOV.
3. Set up DEPT and EMP data blocks and its relationship.
4. Click Object Navigator
Forms
LOVs and then on tool bar click Create button.
5. In the New LOV dialog box select
• New Record Group Based on the Query Below...
6. Enter the following code
SELECT distinct job
FROM emp
ORDER BY job
7. Click OK. (The hour glass will no go away)
8. Double click to open the property palette for the new LOV (under LOVs).
9. Change Name to JOB_LOV
10. Click on Column Mapping Properties (under Functional).
11. Click on More button.
12. Click Column Name JOB then in Return Item box type Emp.JOB. This specifies the destination into which the LOV will place the job value.
13. Enter a display width of 50. Click OK
14. Change Object Navigator
Record Groups
LOV name to JOB_LOV
15. On Layout Editor double click on JOB to bring up property palette and set List of Values to JOB_LOV
16. Set Validate from List to YES.
17. Save file under c:/orant/Forms50/Class/TEST_LOV.FMB
18. Run form.
• LOV, using auto-reduction, to populate a job if it finds one job that matches the first character that you typed. Otherwise a pup-up window open if more than on job are found or invalid job is entered.
-
In HRMS we do use date with timestamp for EIT ans SIT segments. To change the format od the date we can use fnd_date . canonical_to_date ... -
Converstion API Table Organization hr_organization_api.create_hr_organization hr_all_organization...
-
WIP Migration: Create a job in Work in Process 1. Create a job with item which is billable on and define routing sequence for the ...
No comments:
Post a Comment
Thanks for your comments submitted.,will review and Post soon! by admin.