Oracle App Using Flash Message in Forms Personalization Responsibility: Application Developer Navigation: Application > Messages Create new message Name: XX_TEST Current Text Message: This is a test message for &USER_NAME Save and close form. Generate the message Responsibility: Application Developer Click on View > Requests in the menu to execute a concurrent program. Select Generate […]
Recipe Header Uploading can be done using the following steps: 1. First Create a staging table say “MJIL_RCP_HDR_UPL_TBL” as shown below. CREATE TABLE MJIL_RCP_HDR_UPL_TBL( RECIPE_ID NUMBER (15), RECIPE_DESCRIPTION VARCHAR2 (70 BYTE), RECIPE_NO VARCHAR2 (32 BYTE), […]
Module GMD R12.GMD.A.6 (UNP Product Development; Process Manufacturing Product Development) The procedure for adding an ingredient in the formula PROCEDURE insert_formuladetail( p_formula_id NUMBER , p_ingredient_id NUMBER , p_new_qty NUMBER , p_uom VARCHAR2 DEFAULT NULL, p_return_status OUT VARCHAR2 , p_message OUT […]
Formula Upload can be done using the following steps: 1. Create a staging table say “MJIL_FORMULA_UPLOAD” whose structure is given below. CREATE TABLE MJIL_FORMULA_UPLOAD( RECORD_TYPE VARCHAR2 (1 BYTE), FORMULA_NO VARCHAR2 (32 BYTE), FORMULA_VERS NUMBER, FORMULA_TYPE […]
Module GMD R12.GMD.A.6 (UNP Product Development; Process Manufacturing Product Development) The procedure to delete the row from the formula PROCEDURE delete_formuladetail( p_formula_id NUMBER , p_formulaline_id NUMBER , p_return_status OUT VARCHAR2 , p_message OUT VARCHAR2 )IS l_api_version CONSTANT NUMBER := 1.1; l_init_msg_list VARCHAR2(1) […]
Recent Comments