how to create parameterised form in oracle 10g?
and create another form from the value of the form?
AND how to assign value to a parameter?
sincerly your
mamun
Answers were Sorted based on User's Feedback
Answer / sudipta santra
First U need to create one Param-List object inside the form
like as below:-
list_id := Create_Parameter_List('PAR_CONTRACT');
Add_Parameter(list_id,
'CONTRACT_NO',TEXT_PARAMETER,:TBL_CONTRACT.CONTRACT_NO);
call_Form('T:\Form2.fmx',no_hide,no_replace,
no_query_only,list_id);
in the Form2.fmb: You need to catch those parameter value in
either trigger Pre-Form or in trigger When-New-Form-Instance.
If you have any doubt then please drop me a mail about your
confusion on : sudipta_santra@infosys.com
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sudipta santra
In form-1 the written code is given below:-
list_id := Create_Parameter_List('PAR_CONTRACT');
Add_Parameter(list_id,
'CONTRACT_NO',TEXT_PARAMETER,:TBL_CONTRACT.CONTRACT_NO);
call_Form('T:\Form-2.fmx',no_hide,no_replace,
no_query_only,list_id);
In form-2 the written code is given below:-
Either in the trigger When-New-Form-Instance or in trigger
Pre-Form :-
SET_WINDOW_PROPERTY(FORMS_MDI_WINDOW,WINDOW_STATE,MAXIMIZE);
BEGIN
IF ( :PARAMETER.PAR_CONTRACT IS NOT NULL ) THEN
/* Use this value in the WHERE clause of MY_BLOCK */
Set_Block_Property('TBL_CONTRACT',DEFAULT_WHERE,
'PAR_CONTRACT = :PARAMETER.PAR_CONTRACT');
GO_BLOCK('TBL_CONTRACT');
Execute_Query;
END IF;
END;
In that way we can use parameter inside the several forms.
If you have still any doubts , then please reach me out at:
sudipta_santra@infosys.com
Is This Answer Correct ? | 0 Yes | 0 No |
in before report trigger SRW.user_exit(FND_Userinit) what will do
What is the built-in function used for finding the alert?
What is the User-Named Editor?
In workflow how can we send a notification to the Supplier giving the Corresponding report Details.
What is the difference when confine mode is on and when it is off?
What is bind reference and how can it carate?
System.effective_date system variable is read only True/False
What are the two types views available in the object navigator?
how to create the triggers in the forms?
Why is a Where clause faster than a group filter or a format trigger?
What is the usuage of an ON-INSERT,ON-DELETE and ON-UPDATE TRIGGERS ?
What is responsibility and how u attach How to create user and how u attach with responsibility.