API.TS

export const SAMPLE_SOURCE = `CREATE OR REPLACE PROCEDURE process_order (
  p_order_id IN NUMBER,
  p_status OUT VARCHAR2
) AS
  v_customer_id orders.customer_id%TYPE;
  v_total orders.total_amount%TYPE;
BEGIN
  SELECT customer_id, total_amount
    INTO v_customer_id, v_total
    FROM orders
   WHERE order_id = p_order_id
     FOR UPDATE;

  IF v_total <= 0 THEN
    p_status := 'REJECTED';
    RAISE_APPLICATION_ERROR(-20001, 'Invalid order total');
  END IF;

  UPDATE orders
     SET status = 'PROCESSED',
         processed_at = SYSTIMESTAMP
   WHERE order_id = p_order_id;

  INSERT INTO order_audit (order_id, event_type, created_at)
  VALUES (p_order_id, 'PROCESSED', SYSTIMESTAMP);

  COMMIT;
  p_status := 'SUCCESS';
EXCEPTION
  WHEN NO_DATA_FOUND THEN
    ROLLBACK;
    p_status := 'NOT_FOUND';
  WHEN OTHERS THEN
    ROLLBACK;
    p_status := 'FAILED';
    RAISE;
END process_order;
/`;

export const WORKFLOW_STAGES = [
  "source_intake",
  "parser_and_chunking",
  "deterministic_metadata_extractor",
  "metadata_reviewer_agent",
  "exact_retrieval",
  "semantic_retrieval",
  "retrieval_fusion_and_ranking",
  "procedure_context_generator_agent",
  "procedure_analysis_agent",
  "auditor_agent",
  "revision",
  "package_context_generator_agent",
  "table_knowledge_agent",
  "package_merge_agent",
  "persistence",
  "completed",
] as const;