While execution the query with arithmetic calculation exception will throw divisor is equal to zero error.In this situation we can use below logic. CREATE OR REPLACE FUNCTION divisorzero (p_divited NUMBER,…
Read MorePass the from and to date parameter. select USER_CONCURRENT_PROGRAM_NAME,REQUEST_DATE,CNTPERDAY,week_no, case when week_no=1 then sum(CNTPERDAY) OVER (PARTITION BY USER_CONCURRENT_PROGRAM_NAME,week_no) else 0 end week_no_1, case when week_no=2 then sum(CNTPERDAY) OVER (PARTITION BY…
Read More/******************************************************************************** *PURPOSE: To Customer Locations information from back-end * *AUTHOR: Shailender Thallam * *********************************************************************************/ SET SERVEROUTPUT ON; DECLARE — –Cursor to fetch location details — cursor cur_loc IS select hps.location_id…
Read Moredeclare l_request_req_id NUMBER; begin BEGIN l_request_req_id := apps.fnd_request.submit_request (application => ‘PO’ –Application, , program => ‘REQIMPORT’ –Program, , argument1 => ” –Interface Source code, , argument2 => 1032 –Batch ID,…
Read Morecreate or replace procedure xx_Thirdpart_reg_validation(P_CUSTOMER varchar2) as LV_ERR_MSG VARCHAR2 (4000); LV_STATUS_FLAG VARCHAR2 (1); LV_CUSTOMER_ID NUMBER; LV_SITE_USE_ID NUMBER; LV_GST_NUM VARCHAR2 (20); begin BEGIN SELECT CUSTOMER_ID INTO LV_CUSTOMER_ID FROM AR_CUSTOMERS ARC WHERE…
Read Morecreate or replace procedure xx_shipto_site_validation(P_CUSTOMER varchar2) as LV_ERR_MSG VARCHAR2 (4000); LV_STATUS_FLAG VARCHAR2 (1); LV_CUSTOMER_ID NUMBER; LV_SHIP_SITE_USE_ID NUMBER; begin BEGIN SELECT CUSTOMER_ID INTO LV_CUSTOMER_ID FROM AR_CUSTOMERS ARC WHERE ARC.CUSTOMER_NAME = P_CUSTOMER;…
Read Morecreate or replace procedure xx_billto_site_validation(P_CUSTOMER varchar2) as LV_ERR_MSG VARCHAR2 (4000); LV_STATUS_FLAG VARCHAR2 (1); LV_CUSTOMER_ID NUMBER; LV_SITE_USE_ID NUMBER; begin BEGIN SELECT CUSTOMER_ID INTO LV_CUSTOMER_ID FROM AR_CUSTOMERS ARC WHERE ARC.CUSTOMER_NAME = P_CUSTOMER;…
Read MoreCREATE OR REPLACE PROCEDURE_iso_gst_tax_prc (p_trx_number VARCHAR2) AS CURSOR c IS SELECT prla.requisition_header_id, prla.requisition_line_id, prla.source_organization_id, prla.destination_organization_id, prla.item_id, jtd.trx_id, jtd.trx_line_id, DECODE (SUBSTR (DECODE (organization_code, ’05’, ‘111’, ’08’, ‘222’, organization_code ), -1, 1…
Read MoreASL Setup Validation ASL (Approved supplier list) setup validation for Local and Global The local setup we have to pass the parameter location code, item and Vendor code for global…
Read MoreDECLARE paslrec po_approved_supplier_list_rec; paarec po_asl_attributes_rec; padrec po_asl_documents_rec; chvrec chv_authorizations_rec; psicrec po_supplier_item_capacity_rec; psitrec po_supplier_item_tolerance_rec; x_errors po_asl_api_error_rec; x_session_key NUMBER; x_return_status VARCHAR2 (30); x_return_msg VARCHAR2 (2000); BEGIN — Populating values in paslrec paslrec…
Read More