APPS.JTS_CONFIG_VERSION_FLOW_PVT dependencies on JTS_SETUP_FLOW_PVT

Line 76: l_flow_id := JTS_SETUP_FLOW_PVT.GET_PARENT_FLOW_ID(p_flow_id);

72: last_update_date = sysdate
73: WHERE version_id = p_version_id
74: AND flow_id = p_flow_id;
75:
76: l_flow_id := JTS_SETUP_FLOW_PVT.GET_PARENT_FLOW_ID(p_flow_id);
77:
78: -- Propagate last_update information up to the parent right below the root level
79: WHILE (l_flow_id IS NOT NULL) LOOP
80: l_parent_id := JTS_SETUP_FLOW_PVT.GET_PARENT_FLOW_ID(l_flow_id);

Line 80: l_parent_id := JTS_SETUP_FLOW_PVT.GET_PARENT_FLOW_ID(l_flow_id);

76: l_flow_id := JTS_SETUP_FLOW_PVT.GET_PARENT_FLOW_ID(p_flow_id);
77:
78: -- Propagate last_update information up to the parent right below the root level
79: WHILE (l_flow_id IS NOT NULL) LOOP
80: l_parent_id := JTS_SETUP_FLOW_PVT.GET_PARENT_FLOW_ID(l_flow_id);
81: IF (l_parent_id IS NOT NULL) THEN --not at root level yet
82: UPDATE jts_config_version_flows
83: SET last_updated_by = FND_GLOBAL.user_id,
84: last_update_login = FND_GLOBAL.user_id,

Line 103: p_flow_hiearchy IN JTS_SETUP_FLOW_PVT.Setup_Flow_Tbl_Type)

99: -- Creates Setup Summary data by getting the flow hiearchy
100: -- and inserting with the appropriate flow_id
101: PROCEDURE CREATE_VERSION_FLOWS(p_api_version IN NUMBER,
102: p_version_id IN NUMBER,
103: p_flow_hiearchy IN JTS_SETUP_FLOW_PVT.Setup_Flow_Tbl_Type)
104: IS
105: l_api_version CONSTANT NUMBER := 1.0;
106: l_api_name CONSTANT VARCHAR2 (30) := 'CREATE_VERSION_FLOWS';
107: BEGIN