Posts

Showing posts from August, 2016

BTN use on Oracle forms

Image
BTN Select Use on Oracle Forms BTN Use In Oracle Form:-  FND_MESSAGE.SET_NAME('XXCOM','XXCOM_TEST_M1'); BTN_SELECT:=FND_MESSAGE.QUESTION('YES','NO','CANCEL','',3,'CAUTION');  IF BTN_SELECT = 1 THEN Condition; ELSIF BTN_SELECT = 2 THEN Condition ; ELSE Condition ; END IF; Example:-  ------------------------------------------------------------------------ DECLARE V_TOKEN_VALUE VARCHAR2(1000); BTN_SELECT NUMBER; V_FORM VARCHAR2(100); SELECT_OPTION NUMBER; V_PARAMETER_1 VARCHAR2(100); BEGIN V_PARAMETER_1:= :XXCOM_RCPT_ENTRY_TL.PROJECT_ID ||'#1#'                                  || :XXCOM_RCPT_ENTRY_TL.RECEIPT_DATE ||'#2#'                                  || :XXCOM_RCPT_ENTRY_TL.CUSTOMER_NUMBER;        ...