APPS.JTS_CONFIG_VERSION_FLOW_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 20

  SELECT 	COUNT(*)
  INTO		l_completed
  FROM	  	jts_config_version_flows vf,
	        jts_setup_flows_b sf
  WHERE		version_id = p_version_id
  AND		complete_flag = 'Y'
  AND		sf.flow_id = vf.flow_id
  AND		sf.has_child_flag = 'N';

Line: 29

  SELECT 	COUNT(*)
  INTO		l_total
  FROM	  	jts_config_version_flows vf,
	        jts_setup_flows_b sf
  WHERE		version_id = p_version_id
  AND		sf.flow_id = vf.flow_id
  AND		sf.has_child_flag = 'N';

Line: 48

PROCEDURE UPDATE_FLOW_DETAILS(p_api_version	IN Number,
   			p_version_id		IN NUMBER,
			p_flow_id		IN NUMBER,
			p_complete_flag 	IN VARCHAR2) IS
   l_api_version   CONSTANT NUMBER        := 1.0;

Line: 53

   l_api_name      CONSTANT VARCHAR2 (30) := 'UPDATE_FLOW_DETAILS';

Line: 68

   UPDATE jts_config_version_flows
   SET    complete_flag = p_complete_flag,
	  last_updated_by =  FND_GLOBAL.user_id,
	  last_update_login = FND_GLOBAL.user_id,
	  last_update_date = sysdate
   WHERE  version_id = p_version_id
   AND    flow_id = p_flow_id;

Line: 82

      	 UPDATE jts_config_version_flows
      	 SET    last_updated_by =  FND_GLOBAL.user_id,
	  	last_update_login = FND_GLOBAL.user_id,
		last_update_date = sysdate
      	 WHERE  version_id = p_version_id
      	 AND    flow_id = l_flow_id;

Line: 97

END UPDATE_FLOW_DETAILS;

Line: 119

      INSERT INTO jts_config_version_flows(
      	version_id,
      	flow_id,
      	complete_flag,
	object_version_number,
      	creation_date,
      	created_by,
      	last_update_date,
      	last_updated_by,
      	last_update_login)
      VALUES(
      	p_version_id,
      	p_flow_hiearchy(I).flow_id,
      	'N',
	1,
      	sysdate,
    	FND_GLOBAL.user_id, --created_by
    	sysdate,
    	FND_GLOBAL.user_id,
    	FND_GLOBAL.user_id
      );

Line: 148

PROCEDURE DELETE_VERSION_FLOWS(p_api_version	IN  Number,
   				p_version_id 	IN  NUMBER) IS
   l_api_version   CONSTANT NUMBER        := 1.0;

Line: 151

   l_api_name      CONSTANT VARCHAR2 (30) := 'DELETE_VERSION_FLOWS';

Line: 163

   DELETE FROM jts_config_version_flows
   WHERE  version_id = p_version_id;

Line: 171

END DELETE_VERSION_FLOWS;

Line: 175

PROCEDURE DELETE_CONFIG_VERSION_FLOWS(p_api_version	IN  Number,
   					p_config_id 	IN  NUMBER) IS
   l_api_version   CONSTANT NUMBER        := 1.0;

Line: 178

   l_api_name      CONSTANT VARCHAR2 (30) := 'DELETE_CONFIG_VERSION_FLOWS';

Line: 199

     DELETE FROM jts_config_version_flows
     WHERE  version_id = l_version_id;

Line: 210

END DELETE_CONFIG_VERSION_FLOWS;

Line: 220

	SELECT 	 version_id, flow_id, v.complete_flag,
		 v.creation_date, v.created_by, v.last_update_date, v.last_updated_by, v.last_update_login,
		 u1.user_name, u2.user_name
	FROM 	 jts_config_version_flows v,
		 fnd_user u1,
		 fnd_user u2
	WHERE	 version_id = p_version_id
	AND	 u1.user_id (+) = v.created_by
	AND	 u2.user_id (+) = v.last_updated_by
	ORDER BY flow_id;

Line: 250

           p_flow_tbl(i).last_update_date,
           p_flow_tbl(i).last_updated_by,
           p_flow_tbl(i).last_update_login,
           p_flow_tbl(i).created_by_name,
           p_flow_tbl(i).last_updated_by_name;