APPS.CS_KB_WF_PKG dependencies on CS_KB_WF_FLOWS_TL

Line 915: cs_kb_wf_flows_tl t

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
919: where d.flow_id = b.flow_id

Line 927: fid CS_KB_WF_FLOWS_TL.flow_id%TYPE; -- temp step.

923: and sysdate < nvl(end_date, sysdate+1)
924: ORDER BY t.NAME ASC;
925:
926: -- Temp variables.
927: fid CS_KB_WF_FLOWS_TL.flow_id%TYPE; -- temp step.
928: fna CS_KB_WF_FLOWS_TL.name%TYPE; -- temp name
929: counter NUMBER := 1;
930: BEGIN
931: OPEN FLOWS_TABLE;

Line 928: fna CS_KB_WF_FLOWS_TL.name%TYPE; -- temp name

924: ORDER BY t.NAME ASC;
925:
926: -- Temp variables.
927: fid CS_KB_WF_FLOWS_TL.flow_id%TYPE; -- temp step.
928: fna CS_KB_WF_FLOWS_TL.name%TYPE; -- temp name
929: counter NUMBER := 1;
930: BEGIN
931: OPEN FLOWS_TABLE;
932: LOOP

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 1442: INSERT INTO CS_KB_WF_FLOWS_TL (flow_id,

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,
1443: name,
1444: creation_date,
1445: created_by,
1446: last_update_date,

Line 1464: FROM CS_KB_WF_FLOWS_TL t

1460: FROM fnd_languages l
1461: WHERE l.installed_flag IN ('I', 'B')
1462: AND NOT EXISTS
1463: (SELECT NULL
1464: FROM CS_KB_WF_FLOWS_TL t
1465: WHERE t.flow_id = p_flow_id
1466: AND t.language = l.language_code);
1467:
1468:

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 1940: cs_kb_wf_flows_tl

1936: MIN(flow_id)
1937: INTO
1938: temp
1939: FROM
1940: cs_kb_wf_flows_tl
1941: WHERE
1942: flow_id = p_flow_id;
1943:
1944: IF(temp is not null) THEN

Line 1945: UPDATE CS_KB_WF_FLOWS_TL

1941: WHERE
1942: flow_id = p_flow_id;
1943:
1944: IF(temp is not null) THEN
1945: UPDATE CS_KB_WF_FLOWS_TL
1946: SET name = p_flow_name,
1947: last_updated_by = uid,
1948: last_update_date = dt,
1949:

Line 2014: DELETE FROM CS_KB_WF_FLOWS_TL t

2010: PROCEDURE Add_Language IS
2011:
2012: BEGIN
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

Line 2021: UPDATE CS_KB_WF_FLOWS_TL T SET (

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 (
2022: name,
2023: description
2024: ) = (SELECT
2025: b.name,

Line 2027: FROM CS_KB_WF_FLOWS_TL b

2023: description
2024: ) = (SELECT
2025: b.name,
2026: b.description
2027: FROM CS_KB_WF_FLOWS_TL b
2028: WHERE b.flow_id = t.flow_id
2029: AND b.language = t.source_lang)
2030: WHERE (
2031: t.flow_id,

Line 2036: FROM CS_KB_WF_FLOWS_TL subb, CS_KB_WF_FLOWS_TL subt

2032: t.language
2033: ) IN (SELECT
2034: subt.flow_id,
2035: subt.language
2036: FROM CS_KB_WF_FLOWS_TL subb, CS_KB_WF_FLOWS_TL subt
2037: WHERE subb.flow_id = subt.flow_id
2038: AND subb.language = subt.source_lang
2039: AND (subb.name <> subt.name
2040: OR (subb.name IS NULL AND subt.name IS NOT NULL)

Line 2047: INSERT INTO CS_KB_WF_FLOWS_TL (

2043: OR (subb.description IS NULL AND subt.description IS NOT NULL)
2044: OR (subb.description IS NOT NULL AND subt.description IS NULL)
2045: ));
2046:
2047: INSERT INTO CS_KB_WF_FLOWS_TL (
2048: flow_id,
2049: name,
2050: description,
2051: creation_date,

Line 2069: FROM CS_KB_WF_FLOWS_TL b, fnd_languages l

2065: b.last_update_login,
2066: b.last_updated_by,
2067: l.language_code,
2068: b.source_lang
2069: FROM CS_KB_WF_FLOWS_TL b, fnd_languages l
2070: WHERE l.installed_flag IN ('I', 'B')
2071: AND b.language = USERENV('LANG')
2072: AND NOT EXISTS
2073: (SELECT NULL

Line 2074: FROM CS_KB_WF_FLOWS_TL t

2070: WHERE l.installed_flag IN ('I', 'B')
2071: AND b.language = USERENV('LANG')
2072: AND NOT EXISTS
2073: (SELECT NULL
2074: FROM CS_KB_WF_FLOWS_TL t
2075: WHERE t.flow_id = b.flow_id
2076: AND t.language = l.language_code);
2077:
2078: END Add_Language;