2668: */
2669:
2670: PROCEDURE Clone_Flow(p_newFlowId in NUMBER, p_flowId in NUMBER) IS
2671:
2672: l_flow_rec cs_cf_flows_vl%rowtype;
2673: l_page_rec cs_cf_flow_pages_vl%rowtype;
2674:
2675: l_newFlowId NUMBER := 0-p_newFlowId;
2676: l_rowid VARCHAR2(50);
2676: l_rowid VARCHAR2(50);
2677:
2678: CURSOR l_flow_cur(l_flowId IN NUMBER) IS
2679: SELECT *
2680: FROM cs_cf_flows_vl
2681: WHERE flow_id = l_flowId;
2682:
2683: CURSOR l_page_cur(l_flowId IN NUMBER) IS
2684: SELECT *