Script to update Customer Location Address
DECLARE p_location_rec HZ_LOCATION_V2PUB.LOCATION_REC_TYPE; p_object_version_number NUMBER; x_return_status ......
7 Years Ago
Submitting Request set from backend
CREATE OR REPLACE PROCEDURE XX_SUBMIT_REQUEST_SET (P_errbuf OUT VARCHAR2, P_retcod......
7 Years Ago
API to get on hand and available to reserve quantities in Oracle Apps
DECLARE x_return_status VARCHAR2 (50); x_msg_count VARCHAR2 (50); x_msg_data VARCHAR2 (50); ......
7 Years Ago
Deactivate Suppliers/Vendors in Oracle Apps using API
--www.askhareesh.com DECLARE LV_RETURN_STATUS VARCHAR2 (1) := NULL; LV_MSG_COUNT NUMBER := 0; LV_MSG_DATA VARCH......
7 Years Ago
Query for Employee as Supplier Bank Details
--Query for employee as supplier bank details SELECT aps.vendor_id, apss.vendor_site_id, aps.vendor_name, apss.vend......
7 Years Ago
FTP the file from other server to local server
#!/bin/bash HOST='ftp.askhareesh.com' #HostName USER='AskHareesh' #UserName PASSWD='@5kh@r335h' #Password DIREC='/out/tmp/' ......
7 Years Ago
