create or replace PACKAGE BODY XX_Ar_Collector_Assign_Pkg AS PROCEDURE update_collectors(errbuf OUT VARCHAR2, retcode OUT NUMBER, p_oracle_user_id VARCHAR2) IS l_oracle_user_id NUMBER; l_update_rowcount NUMBER; v_customer_profile_rec_type hz_customer_profile_v2pub.customer_profile_rec_type; v_latest_ver_num NUMBER; x_return_status VARCHAR2 (10); x_msg_count NUMBER;…
Read MoreIntroduction This blog explains how to create user and add responsibility for a user from the backend. #Code# DECLARE lc_user_name VARCHAR2(100) := RAJAN_TEST’; lc_user_password VARCHAR2(100) := ‘Oracle123′; ld_user_start_date DATE :=…
Read MoreDoyensys is always up for new challenges and interesting projects that come our way. It is a belief that such opportunities give us a platform to demonstrate our capabilities and…
Read MoreOnce we did VO Extension & migrated those files into server. Post that we may face this type of error Attribute set for comments in View Object VO failed. Solution:…
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 More