Friday, 26 April 2024

Dynamically Calling Pages in Apex by Making URL using Java Script on Click Intrective Report Column

 /*******************************************************************/
Report Column Link as URL
javascript:apex.item('P567_DOC_NO').setValue('#OGP_NO#')
/*******************************************************************/
Ajaxcallback Procedure with name PREPARE_URL

declare
result varchar2(23333);
begin
result:=apex_util.prepare_url(apex_application.g_x01);
apex_json.open_object;
apex_json.write('success', true);
apex_json.write('url', result);
apex_json.close_object;
exception
when others then
apex_json.open_object;
apex_json.write('success', false);
apex_json.write('message', sqlerrm);
apex_json.close_object;
end;

/*******************************************************************/

var itemval = $v2('P567_DOC_NO');
if (itemval.startsWith('IUS'))
{
var x =apex.item('P567_DOC_NO').getValue();
var url = "f?p=#APP_ID#:554:#SESSION#::NO:RP,554:P554_VNO:#P567_DOC_NO#";
url = url.replace("#APP_ID#", $v("pFlowId"));
url = url.replace("#SESSION#", $v("pInstance"));
url = url.replace("#P567_DOC_NO#", x);
apex.server.process("PREPARE_URL", {
x01: url
  }, {
  success: function(pData) {
   if (pData.success === true) {
     apex.navigation.redirect(pData.url);
   } else {
     console.log("FALSE");
   }
 },
error: function(request, status, error) {
console.log("status---" + status + " error----" + error);
  }
});
}else if (itemval.startsWith('SDT')){
var x = apex.item('P567_DOC_NO').getValue();
var url = "f?p=#APP_ID#:555:#SESSION#::NO:RP,555:P555_OGP_NO:#P567_DOC_NO#";
url = url.replace("#APP_ID#", $v("pFlowId"));
url = url.replace("#SESSION#", $v("pInstance"));
url = url.replace("#P567_DOC_NO#", x);
apex.server.process("PREPARE_URL", {
x01: url
  }, {
  success: function(pData) {
   if (pData.success === true) {
     apex.navigation.redirect(pData.url);
   } else {
     console.log("FALSE");
   }
 },
error: function(request, status, error) {
console.log("status---" + status + " error----" + error);
  }
});
}else if (itemval.startsWith('OGP')){
var x = apex.item('P567_DOC_NO').getValue();
var url = "f?p=#APP_ID#:560:#SESSION#::NO:RP,560:P560_OGP_NO:#P567_DOC_NO#";
url = url.replace("#APP_ID#", $v("pFlowId"));
url = url.replace("#SESSION#", $v("pInstance"));
url = url.replace("#P567_DOC_NO#", x);
apex.server.process("PREPARE_URL", {
x01: url
  }, {
  success: function(pData) {
   if (pData.success === true) {
     apex.navigation.redirect(pData.url);
   } else {
     console.log("FALSE");
   }
 },
error: function(request, status, error) {
console.log("status---" + status + " error----" + error);
  }
});
}else if (itemval.startsWith('SD-')){
var x = apex.item('P567_DOC_NO').getValue();
var url = "f?p=#APP_ID#:555:#SESSION#::NO:RP,555:P555_OGP_NO:#P567_DOC_NO#";
url = url.replace("#APP_ID#", $v("pFlowId"));
url = url.replace("#SESSION#", $v("pInstance"));
url = url.replace("#P567_DOC_NO#", x);
apex.server.process("PREPARE_URL", {
x01: url
  }, {
  success: function(pData) {
   if (pData.success === true) {
     apex.navigation.redirect(pData.url);
   } else {
     console.log("FALSE");
   }
 },
error: function(request, status, error) {
console.log("status---" + status + " error----" + error);
  }
});
}else if (itemval.startsWith('IGP')){
var x = apex.item('P567_DOC_NO').getValue();
var url = "f?p=#APP_ID#:564:#SESSION#::NO:RP,564:P564_IGP_NO:#P567_DOC_NO#";
url = url.replace("#APP_ID#", $v("pFlowId"));
url = url.replace("#SESSION#", $v("pInstance"));
url = url.replace("#P567_DOC_NO#", x);
apex.server.process("PREPARE_URL", {
x01: url
  }, {
  success: function(pData) {
   if (pData.success === true) {
     apex.navigation.redirect(pData.url);
   } else {
     console.log("FALSE");
   }
 },
error: function(request, status, error) {
console.log("status---" + status + " error----" + error);
  }
});
}

No comments:

Post a Comment

Check Internet Connectivity on Local System

if (!navigator.onLine) {     showOfflineAlert(); } else {     // Set a strict 3-second network timeout threshold     const controller = new ...