APPS.CS_KB_WF_PKG dependencies on CS_KB_WF_FLOWS_B

Line 544: -- cs_kb_wf_flows_b table

540: END Expire_Detail;
541:
542: /**************************** Expire Flow ********************/
543: -- This Procedure is used to "soft-delete" a flow from the
544: -- cs_kb_wf_flows_b table
545: --
546: -- VARIABLES
547: -- p_flow_id
548: -- p_result: 1 = completed successfully, -1 = error

Line 560: FROM CS_KB_WF_FLOWS_B

556: dt DATE := SYSDATE;
557:
558: CURSOR CHECK_FLOW_EXITS (flowId NUMBER) IS
559: SELECT count(*)
560: FROM CS_KB_WF_FLOWS_B
561: WHERE flow_id = flowId;
562:
563: CURSOR CHECK_DEFAULT_FLOWS (flowId NUMBER) IS
564: SELECT count(*)

Line 588: UPDATE CS_KB_WF_FLOWS_B

584: CLOSE CHECK_DEFAULT_FLOWS;
585:
586: IF v_def_count = 0 THEN
587:
588: UPDATE CS_KB_WF_FLOWS_B
589: SET end_date = dt,
590: last_updated_by = uid,
591: last_update_date = dt
592: WHERE

Line 611: -- in the cs_kb_wf_flows_b table

607:
608:
609: /**************************** Enable Flow ********************/
610: -- This Procedure is used to re-activate an End-Dated Flow
611: -- in the cs_kb_wf_flows_b table
612: --
613: -- VARIABLES
614: -- p_flow_id
615: -- p_result: 1 = completed successfully, -1 = error

Line 624: FROM CS_KB_WF_FLOWS_B

620: dt DATE := SYSDATE;
621:
622: CURSOR CHECK_FLOW_EXITS (flowId NUMBER) IS
623: SELECT count(*)
624: FROM CS_KB_WF_FLOWS_B
625: WHERE flow_id = flowId;
626:
627: v_count NUMBER := 0;
628:

Line 637: UPDATE CS_KB_WF_FLOWS_B

633: CLOSE CHECK_FLOW_EXITS;
634:
635: IF v_count = 1 THEN
636:
637: UPDATE CS_KB_WF_FLOWS_B
638: SET end_date = null,
639: last_updated_by = uid,
640: last_update_date = dt
641: WHERE flow_id = p_flow_id;

Line 914: from cs_kb_wf_flows_b b,

910: t_flow_name JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
911:
912: CURSOR FLOWS_TABLE IS
913: select b.flow_id, t.name
914: from cs_kb_wf_flows_b b,
915: cs_kb_wf_flows_tl t
916: where b.flow_id = t.flow_id
917: and t.language = userenv('LANG')
918: and exists (select flow_id from cs_kb_wf_flow_details d

Line 1025: cs_kb_wf_flows_b flows,

1021: CURSOR groups IS
1022: SELECT DISTINCT details2.GROUP_ID
1023: FROM cs_kb_wf_flow_details details1,
1024: cs_kb_wf_flow_details details2,
1025: cs_kb_wf_flows_b flows,
1026: cs_kb_sets_b sets
1027: WHERE
1028: sets.SET_NUMBER = p_set_number
1029: AND sets.FLOW_DETAILS_ID = details1.FLOW_DETAILS_ID

Line 1422: FROM CS_KB_WF_FLOWS_B b, CS_KB_WF_FLOWS_TL tl

1418: BEGIN
1419:
1420: SELECT count(1)
1421: INTO x_count
1422: FROM CS_KB_WF_FLOWS_B b, CS_KB_WF_FLOWS_TL tl
1423: WHERE b.FLOW_ID = tl.FLOW_ID
1424: AND tl.NAME = p_flow_name
1425: AND tl.LANGUAGE = FND_GLOBAL.CURRENT_LANGUAGE;
1426:

Line 1438: INSERT INTO CS_KB_WF_FLOWS_B(flow_id,created_by,creation_date,

1434: p_flow_id
1435: FROM
1436: DUAL;
1437:
1438: INSERT INTO CS_KB_WF_FLOWS_B(flow_id,created_by,creation_date,
1439: last_updated_by,last_update_date)
1440: VALUES(p_flow_id,uid,dt,uid,dt);
1441:
1442: INSERT INTO CS_KB_WF_FLOWS_TL (flow_id,

Line 1924: FROM CS_KB_WF_FLOWS_B b, CS_KB_WF_FLOWS_TL tl

1920: BEGIN
1921:
1922: SELECT count(1)
1923: INTO x_count
1924: FROM CS_KB_WF_FLOWS_B b, CS_KB_WF_FLOWS_TL tl
1925: WHERE b.FLOW_ID = tl.FLOW_ID
1926: AND b.FLOW_ID <> p_flow_id
1927: AND tl.NAME = p_flow_name
1928: AND tl.LANGUAGE = FND_GLOBAL.CURRENT_LANGUAGE;

Line 1958: UPDATE CS_KB_WF_FLOWS_B

1954: AND USERENV('LANG') IN (language, source_lang);
1955:
1956: --language = FND_GLOBAL.CURRENT_LANGUAGE;
1957:
1958: UPDATE CS_KB_WF_FLOWS_B
1959: SET last_updated_by = uid,
1960: last_update_date = dt
1961: WHERE
1962: flow_id = p_flow_id;

Line 2017: FROM CS_KB_WF_FLOWS_B b

2013:
2014: DELETE FROM CS_KB_WF_FLOWS_TL t
2015: WHERE NOT EXISTS
2016: (SELECT NULL
2017: FROM CS_KB_WF_FLOWS_B b
2018: WHERE b.flow_id = t.flow_id
2019: );
2020:
2021: UPDATE CS_KB_WF_FLOWS_TL T SET (