APPS.AS_SALES_METH_TASK_MAP_PVT SQL Statements

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

Line: 33

         INSERT INTO AS_SALES_METH_TASK_MAP (	sales_stage_id,
         				     	sales_methodology_id,
         				     	object_id,
						object_type_code,
						task_id,
         				     	task_template_id,
         				     	task_template_group_id,
         				     	created_by,
         				     	creation_date,
         				     	last_updated_by,
         				     	last_update_date,
         				     	last_update_login) VALUES
         				     	(	l_sales_stage_id,
         				     		l_sales_methodology_id,
         				     		l_source_object_id,
							l_source_object_type_code,
							l_task_id,
         				     		l_task_template_id,
         				     		l_task_template_group_id,
							fnd_global.user_id,
         				     		SYSDATE,
         				     		fnd_global.user_id,
							SYSDATE,
         				     		fnd_global.login_id);

Line: 86

   Procedure  UPDATE_SALES_METH_TASK_MAP
     (
      P_API_VERSION             	IN  NUMBER,
    P_INIT_MSG_LIST           	IN  VARCHAR2    DEFAULT fnd_api.g_false,
    P_COMMIT                  	IN  VARCHAR2    DEFAULT fnd_api.g_false,
    P_VALIDATE_LEVEL          	IN  VARCHAR2    DEFAULT fnd_api.g_valid_level_full,
    P_SALES_STAGE_ID  	    	IN  NUMBER,
    P_SALES_METHODOLOGY_ID    	IN  NUMBER ,
    P_SOURCE_OBJECT_ID        	IN  NUMBER ,
    P_SOURCE_OBJECT_TYPE_CODE  IN  VARCHAR2 ,
    P_SOURCE_OBJECT_NAME       IN  VARCHAR2 ,
    P_TASK_ID              	IN  NUMBER ,
    P_TASK_TEMPLATE_ID          IN  NUMBER ,
    P_TASK_TEMPLATE_GROUP_ID	IN  NUMBER,
    X_RETURN_STATUS            OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
    X_MSG_COUNT                OUT NOCOPY /* file.sql.39 change */ NUMBER,
    X_MSG_DATA                 OUT NOCOPY /* file.sql.39 change */ VARCHAR2 )     IS
         l_api_name                 	 VARCHAR2(30) := 'UPDATE_SALES_METH_TASK_MAP';

Line: 112

	       SAVEPOINT  update_sales_meth_task_pvt;

Line: 113

	       -- call table handler to insert into as_sales_methodology_b
	          UPDATE  AS_SALES_METH_TASK_MAP SET
	          				     	sales_methodology_id 	= 	l_sales_methodology_id,
	          				     	task_template_id	= 	l_task_template_id,
	          				     	last_updated_by		=	fnd_global.user_id,
	          				     	last_update_date	=	SYSDATE	,
	          				     	last_update_login	=	fnd_global.login_id
	          					WHERE 	object_id = l_source_object_id
	          					AND	sales_stage_id	= l_sales_stage_id
	          					AND	task_template_group_id = l_task_template_group_id ;

Line: 133

		         ROLLBACK TO delete_sm_stage_map_pvt;

Line: 141

		         ROLLBACK TO delete_sm_stage_map_pvt;

Line: 149

		         ROLLBACK TO delete_sm_stage_map_pvt;

Line: 159

   END UPDATE_SALES_METH_TASK_MAP;

Line: 162

    Procedure  DELETE_SALES_METH_TASK_MAP
        (	P_API_VERSION             IN  NUMBER,
 P_INIT_MSG_LIST           IN  VARCHAR2    default fnd_api.g_false,
 P_COMMIT                  IN  VARCHAR2    default fnd_api.g_false,
 P_VALIDATE_LEVEL          IN  VARCHAR2    default fnd_api.g_valid_level_full,
 P_SALES_METHODOLOGY_ID    IN  NUMBER,
  P_SOURCE_OBJECT_ID        	IN  NUMBER ,
  P_SOURCE_OBJECT_TYPE_CODE  IN  VARCHAR2 ,
     P_SOURCE_OBJECT_NAME       IN  VARCHAR2 ,
   P_SALES_STAGE_ID  	    	IN  NUMBER,
P_TASK_TEMPLATE_ID	IN  NUMBER,
P_TASK_TEMPLATE_GROUP_ID	IN  NUMBER,
 X_RETURN_STATUS           OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
 X_MSG_COUNT               OUT NOCOPY /* file.sql.39 change */ NUMBER,
 X_MSG_DATA                OUT NOCOPY /* file.sql.39 change */ VARCHAR2  )         IS
     		l_api_name                 	 VARCHAR2(30) := 'UPDATE_SALES_METH_TASK_MAP';

Line: 186

	       SAVEPOINT  update_sales_meth_task_pvt;

Line: 187

          	DELETE  FROM AS_SALES_METH_TASK_MAP
		WHERE 	object_id = l_source_object_id
		AND	sales_stage_id	= l_sales_stage_id
	        AND	task_template_group_id = l_task_template_group_id ;

Line: 201

		         ROLLBACK TO delete_sm_stage_map_pvt;

Line: 209

		         ROLLBACK TO delete_sm_stage_map_pvt;

Line: 217

		         ROLLBACK TO delete_sm_stage_map_pvt;

Line: 227

   END DELETE_SALES_METH_TASK_MAP;