Supplier Interface Program
------------------------------ Supplier Interface Program ---------------------------------- -------------Supplier Interface------------- 1. Required Data ( From Staging or Direct ) 2. Data Validation 3. Data Insert into Interface Table 4. Import Program. Supplier Open Interface Import Supplier Sites Open Interface Import Supplier Site Contacts Open Interface Import 5. Checking --=================================================================== DECLARE CURSOR SUP_INT IS select 'Oragnic Pvt. Ltd.' vendor_name , 'SELLERS' vendor_type_lookup_code , 'NEW' status FROM DUAL ; BEGIN --SUPPLIER Creation-- FOR I IN SUP_INT LOOP IF I . VENDOR_NAME is not null AND I . VENDOR_TYPE_LOOKUP_CODE is not null THEN /* this is kind of Validation only you can put your own validation here*/ INSERT INTO apps . ap_suppliers_int