APPS.JTS_CONFIG_VERSION_FLOW_PVT dependencies on JTS_SETUP_FLOWS_B

Line 23: jts_setup_flows_b sf

19:
20: SELECT COUNT(*)
21: INTO l_completed
22: FROM jts_config_version_flows vf,
23: jts_setup_flows_b sf
24: WHERE version_id = p_version_id
25: AND complete_flag = 'Y'
26: AND sf.flow_id = vf.flow_id
27: AND sf.has_child_flag = 'N';

Line 32: jts_setup_flows_b sf

28:
29: SELECT COUNT(*)
30: INTO l_total
31: FROM jts_config_version_flows vf,
32: jts_setup_flows_b sf
33: WHERE version_id = p_version_id
34: AND sf.flow_id = vf.flow_id
35: AND sf.has_child_flag = 'N';
36:

Line 54: l_flow_id JTS_SETUP_FLOWS_B.flow_id%TYPE;

50: p_flow_id IN NUMBER,
51: p_complete_flag IN VARCHAR2) IS
52: l_api_version CONSTANT NUMBER := 1.0;
53: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_FLOW_DETAILS';
54: l_flow_id JTS_SETUP_FLOWS_B.flow_id%TYPE;
55: l_parent_id JTS_SETUP_FLOWS_B.parent_id%TYPE;
56: BEGIN
57:
58: IF NOT fnd_api.compatible_api_call ( l_api_version,

Line 55: l_parent_id JTS_SETUP_FLOWS_B.parent_id%TYPE;

51: p_complete_flag IN VARCHAR2) IS
52: l_api_version CONSTANT NUMBER := 1.0;
53: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_FLOW_DETAILS';
54: l_flow_id JTS_SETUP_FLOWS_B.flow_id%TYPE;
55: l_parent_id JTS_SETUP_FLOWS_B.parent_id%TYPE;
56: BEGIN
57:
58: IF NOT fnd_api.compatible_api_call ( l_api_version,
59: p_api_version,