APPS.JTS_SETUP_FLOW_PVT dependencies on JTS_SETUP_FLOWS_VL

Line 35: l_flow_name JTS_SETUP_FLOWS_VL.flow_name%TYPE;

31:
32: -- Returns the flow name of a flow given a flow id
33: FUNCTION GET_FLOW_NAME(p_flow_id IN NUMBER)
34: RETURN VARCHAR2 IS
35: l_flow_name JTS_SETUP_FLOWS_VL.flow_name%TYPE;
36: BEGIN
37: SELECT flow_name
38: INTO l_flow_name
39: FROM jts_setup_flows_vl

Line 39: FROM jts_setup_flows_vl

35: l_flow_name JTS_SETUP_FLOWS_VL.flow_name%TYPE;
36: BEGIN
37: SELECT flow_name
38: INTO l_flow_name
39: FROM jts_setup_flows_vl
40: WHERE flow_id = p_flow_id;
41:
42: return (l_flow_name);
43: EXCEPTION

Line 61: FROM jts_setup_flows_vl

57: i NUMBER := 1;
58:
59: CURSOR l_flow_csr IS
60: SELECT flow_id, flow_name, flow_type
61: FROM jts_setup_flows_vl
62: WHERE parent_id IS NULL
63: AND flow_type = C_FLOW_FLOW_TYPE;
64:
65: BEGIN

Line 100: FROM jts_setup_flows_vl

96: i NUMBER := 1;
97:
98: CURSOR l_flow_csr IS
99: SELECT flow_id, flow_name, flow_type
100: FROM jts_setup_flows_vl
101: WHERE parent_id IS NULL
102: AND flow_type = C_MODULE_FLOW_TYPE;
103:
104: BEGIN

Line 149: jts_setup_flows_vl sv

145: dpf_code, dpf_asn, num_steps, has_child_flag
146: FROM jts_setup_flows_b
147: START WITH flow_id = p_flow_id
148: CONNECT BY prior flow_id= parent_id) sb,
149: jts_setup_flows_vl sv
150: WHERE sv.flow_id=sb.flow_id;
151:
152: BEGIN
153: IF NOT fnd_api.compatible_api_call ( l_api_version,

Line 206: jts_setup_flows_vl sv,

202: dpf_code, dpf_asn, num_steps
203: FROM jts_setup_flows_b
204: START WITH flow_id = p_flow_id
205: CONNECT BY prior flow_id= parent_id) sb,
206: jts_setup_flows_vl sv,
207: jts_config_version_flows vf,
208: fnd_user u1,
209: fnd_user u2
210: WHERE sb.flow_id=sv.flow_id