DBA Data[Home] [Help]

APPS.JTS_SETUP_FLOW_HIEARCHY_PKG dependencies on JTS_SETUP_FLOWS_B_S

Line 16: SELECT jts_setup_flows_b_s.nextval

12:
13: FUNCTION GET_NEXT_FLOW_ID RETURN NUMBER IS
14: l_flow_id JTS_SETUP_FLOWS_B.flow_id%TYPE;
15: BEGIN
16: SELECT jts_setup_flows_b_s.nextval
17: INTO l_flow_id
18: FROM sys.dual;
19:
20: return (l_flow_id);

Line 210: update JTS_SETUP_FLOWS_B set

206: l_parent_id JTS_SETUP_FLOWS_B.parent_id%TYPE;
207: begin
208: l_parent_id := get_flow_id(p_parent_code);
209:
210: update JTS_SETUP_FLOWS_B set
211: FLOW_TYPE = P_FLOW_TYPE,
212: PARENT_ID = L_PARENT_ID,
213: HAS_CHILD_FLAG = P_HAS_CHILD_FLAG,
214: FLOW_SEQUENCE = P_FLOW_SEQUENCE,