Posts by Chandrasekar Sivasangu

Bill to Site Address Validation

create 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 More

India Tax Insert script

CREATE 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

ASL (Approved supplier list) setup validation for Local and Global

ASL 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 More

Approved Supplier list insert script

DECLARE 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