Oracle Apex (ix)

Calculation by JavaScript

Function and Global Variable Declaration: function calculation(){ var qty = $('#P60_QTY').val()||0; var rate =$('#P60_RATE').val()||0; var price = parseFloat(qty).toFixed(2)*parseFloat(rate).toFixed(2); $('#P60_PRICE').val(pr…

Apex Material Cards For Dashboard

Step: 1  ===== Download plug-ins  https://drive.google.com/drive/folders/1Lgu31sisnbP37LnlHHxUPHUBTCGk3Qbo?usp=sharing Step: 2 ===== Go to Share component and Import Plug-ins file Step: 3 ===== Create a page and region  region Type:   APEX Material …

Item Lavel Color

<b style="color:red;">DEDUCT AIT (%)</b>

PL/SQL Dynamic Content (Master - Detail)

Region Type: PL/SQL Dynamic Content PL/SQL Code : declare begin FOR X IN ( select  CAPACITY_CBM, ALLOCATION, CONTAINER_MODE, TOTAL_ADDED,CONTAINER_NUMBER, CONTAINER_SEAL, TARE_WEIGHT, ID   from STUFFING_PLAN_CONT where STUFFING_PLAN_MST_ID = :P124…

Conditionally Display Icon Column in Interactive Report

Step-1: SQL Query : select ID,  NAME,   COUNTRY,   CITY,  PHONE,        STATUS,       DECODE(STATUS, 1, 'fa fa-check-circle', 'fa fa-times-circle') icon,       DECODE(STATUS, 1,  'green', 'red') icon_color   from SETU…

Only one Schedule/Vassel Approval by Party

Setp-1 : ======= Create Interactive Report  SQL Query : For Check Box APEX_ITEM.CHECKBOX(1,ID,'UNCHECKED')    SELECTED Setp-2 : ====== Processes : VASSEL_APPROVAL Declare  v_count          number:= 0; v_appCont    number ; begin FOR i in 1…

"PREFIX+AUTO_NUMBER" customize set In Invoice

Step : 1  ====== CREATE TABLE AUTO_NUMBER_GENERATE     ( ID                           NUMBER ,  TYPE                     VARCHAR2(25 CHAR) NOT NULL ENABLE,  AUTO_NUMBER   NUMBER,  PREFIX                  VARCHAR2(25 CHAR),  CREATE_BY        …

Additional Outputs & Popup LOVs Column Size Customize

Popup LOVs Column Size Customize ======================= Step 1: Select LOV Item and set Initialization JavaScript Function : //Javascript Codes function(options) {     var columns = options.columns;     // set minimum width for the LOV dialog     o…

Lock Data in Oracle Apex

---> This is data insert without Com_id ---> Create Interactive Report Query : select ID,        TYPE,        NAME,       decode(STATUS,1,'Active',0, 'Deactive')STATUS,        get_company_dtl('N',COM_ID) COMPANY,     …

Hide Control Break Action

Interactive Report .a-IRR-reportSummary {     display: none; } .a-IRR-controlsContainer {     display: none; } Interactive  Grid  /* .a-Toolbar{     display: none; }  */ .a-IG-controlsContainer, .a-IRR-controlsContainer{     display: none; }

Button Disable then Value Over Loaded (alert massage By JavaScript)

Container Over Loaded!! Step 1 : Go to page -->   Function and Global Variable Declaration function  overLoad (){     let capacityCbm =   $('# P312_CAPACITY_CBM ').val();     let totalAdded =   $('# P312_TOTAL_ADDED ').val();     …

Horizontal scrollbar in oracle apex Interactive report & Interactive Grid

*** Interactive report Step - 1 Go to Page Inline (Copy to paste this Code) # IR_REPORT .t-fht-thead{   overflow: auto !important; } Step - 2 Select  Region  interactive report And Static ID ---> IR_REPORT  *** Interactive Grid Step - 1 Go to Page…

Multiple Row Grand Total Calculation

Step 1 : Create Dynamic Action              Name : Calculate Grand Total            Event : Lose Focus            Selection Type : Region            Region : (Select Grid Region) True Action : Execute JavaScript Code Code :  var model = apex.region(&…

HTML Report Icon Show And Print preview

Step 1 :  Go to IR Report Query and new column Add with HTML         '<div style="margin-bottom: 10px; text-align: center" >           <a href="'||apex_util.prepare_url('f?p='||:APP_ID||':'||177||'…

Load More
That is All