Create and publish JSON via PLSQL
BUILD JSON PROCEDURE build_Item_Out_Json(p_batch_id IN VARCHAR2, x_json_resp OUT CLOB) AS --cur_item_out SYS_REFCURSOR; v_row_count NUMBER := 0; BEGIN fnd_file.put_line(fnd_file.output, 'In build_Item_Out_Json proc'); BEGIN -- check to see if any error records exist SELECT COUNT(*) INTO v_row_count FROM xx_item WHERE batc...