Folder Function and Create a prompt block with the items similar to the datablock in Oracle Forms

Folder Function in Oracle Forms

Folder function in forms

1. Copy TEMPLATE.fmb and rename it.
2. Open the APPSTAND.fmb and copy the STANDARD_FOLDER object group to the custom form

3. Attach library APPFLDR.pll

4. Create data block and subclass the items as text items

5. Create a prompt block with the items similar to the datablock.

6. Subclass the items of the prompt as FOLDER_PROMPT_MULTIROW

7. Create a content Canvas XX_FOLDER and a Stacked canvas XX_FOLDER_STA.

8. Arrange the items and the corresponding prompt items in the in the stacked and content canvas

9. Create a window and associate the window and its primary canvas(Content)

10. Add the following objects in the XXPO_PWB_LINES_PROMPT Prompt block and assign it to the respective Canvas

Item Name	Item Type	Subclass	Canvas
FOLDER_OPEN	Push Button	Dynamic Title	XX_FOLDER
FOLDER_TITLE	Display Item	Dynamic Title	XX_FOLDER
FOLDER_DUMMY	Text Item	Folder Dummy	Toolbar
ORDER_BY1	Push Button		XX_FOLDER
ORDER_BY2	Push Button		XX_FOLDER
ORDER_BY3	Push Button		XX_FOLDER
Folder_Switcher	Text Item	Switcher	XX_FOLDER

11. Add the below code in FOLDER_ACTION trigger

app_folder.event(:global.folder_action);

12. WHEN-NEW_BLOCK-INSTANCE

app_folder.event('WHEN-NEW-BLOCK-INSTANCE');

13. Create a parameter XX_FLDR_COUNT of type char

KEY-PREV-ITEM

IF (:parameter.xx_fldr_count = 1)

THEN

PREVIOUS_ITEM;

ELSE

app_folder.event ('KEY-PREV-ITEM');

END IF;

14. KEY-NEXT-ITEM

IF (:parameter.xx_fldr_count = 1)

THEN

NEXT_ITEM;

ELSE

app_folder.event ('KEY-NEXT-ITEM');

END IF;

15. PRE-BLOCK

app_folder.event('PRE-BLOCK');

16. POST-BLOCK

app_folder.event('POST-BLOCK');

17. PRE-QUERY

app_folder.event('PRE-QUERY');

18. KEY-EXEQRY

app_folder.event('KEY-EXEQRY');

19. POST-QUERY

app_folder.event('POST-QUERY');

20. Compile the form