Caps Lock (On/Off) Indicator with JavaScript in Oracle APEX
Overview This document talks about how to indicate a message for whether the Caps Lock is on or off while inserting a password in login page by using JavaScript in…
Read MoreTo Find IP Address of the User who login into Apex Application
This query will help to sql, Plsql and Apex Developer to find the user IP Address. Normally we tracking only page id, username and time of the user for login…
Read MoreExcel Template in oracle Apex for Excel Upload Page using JavaScript and Oracle pl/sql
Objective: The Excel Upload Page in Oracle Apex Involves Excel Upload template design. Usually the templates will be stored in Shared Components Workspace File and through button click JavaScript call,…
Read MorePLSQL Stored Procedure to calculate number of particular day between two input dates.
CREATE OR REPLACE PROCEDURE PR_TOT_DAYS ( P_START_DATE IN DATE, P_END_DATE IN DATE, P_DAY IN VARCHAR2, P_TOT_DAYS OUT NUMBER ) IS LV_LOOP NUMBER; LV_DATE DATE; LV_TOT_DAYS NUMBER := 0; BEGIN LV_LOOP…
Read MoreTechnical Solutions For Customized Error Message using PL/SQL
Overview This document explains how to give a customized Error Message using minimal PL/SQL code in Oracle APEX. Technologies and Tools Used The following technologies has been used to achieve…
Read MoreQuery to Check locks on a table
Select object_id, session_id, oracle_username, os_user_name, Process, locked_mode From sys.v_$locked_object; Select a.object_name, b.oracle_username From all_objects a, v$locked_object b Where a.object_id = b.object_id And a.object_name like ‘po%’;
Read MoreFind The details about apex workspace ip, port and other client details
Attachment: apex-workspace-ip-port-and-other-client-details This is very helpful plsql code , which will give you details of your workspace, ip, port and client details. It will help when any application level…
Read MoreOracle R12 Customer TaxPayer ID Update API
/*Upload the customer data that needs to be updated in a temp table*/ CREATE TABLE scratch.RITM0669580 (account_number VARCHAR2(30), tax_payer_id VARCHAR2(20), tax_reg_num VARCHAR2(50), status VARCHAR2(1), message VARCHAR2(1000)); / set serveroutput on;…
Read MoreOracle R12 Customer Remittance Email Update API
DECLARE x_return_status VARCHAR2 (200) := NULL; x_msg_count NUMBER := 0; x_msg_data VARCHAR2 (200) := NULL; t_output VARCHAR2 (200) := NULL; t_msg_dummy VARCHAR2 (200) := NULL; l_payee_upd_status iby_disbursement_setup_pub.ext_payee_update_tab_type; p_external_payee_tab_type iby_disbursement_setup_pub.external_payee_tab_type; p_ext_payee_id_tab_type…
Read MoreOracle R12 Customer Site Remittance Email Update API
DECLARE x_return_status VARCHAR2 (200) := NULL; x_msg_count NUMBER := 0; x_msg_data VARCHAR2 (200) := NULL; t_output VARCHAR2 (200) := NULL; t_msg_dummy VARCHAR2 (200) := NULL; l_payee_upd_status iby_disbursement_setup_pub.ext_payee_update_tab_type; p_external_payee_tab_type iby_disbursement_setup_pub.external_payee_tab_type; p_ext_payee_id_tab_type…
Read More