eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_TASK_RESOURCES_PVT SQL Statements

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

Line: 12


    select 1 from jtf_objects_vl
    where object_code =  p_resource_type_code ;

Line: 38


            SELECT task_template_id ,task_name
              FROM jtf_task_templates_tl
             WHERE task_template_id = p_task_template_id
             OR	task_name = p_task_name;

Line: 85


            SELECT task_type_id ,name
              FROM jtf_task_types_tl
             WHERE task_type_id = p_task_type_id
             OR name= p_name;

Line: 217


    	select 1 from jtf_task_rsc_reqs
    	where rowid = l_rowid ;

Line: 232


   	select JTF_TASK_RSC_REQS_S.nextval into  l_resource_req_id
   	from dual ;

Line: 239


 	JTF_TASK_RSC_REQS_PKG.INSERT_ROW (
  		X_ROWID  => l_rowid,
  		X_RESOURCE_REQ_ID => l_resource_req_id,
  		X_TASK_TYPE_ID   =>  l_task_type_id,
  		X_TASK_ID => l_task_id,
  		X_TASK_TEMPLATE_ID => l_task_template_id,
  		X_REQUIRED_UNITS => l_required_units,
  		X_ENABLED_FLAG => l_enabled_flag,
        x_attribute1 => p_attribute1 ,
        x_attribute2 => p_attribute2 ,
        x_attribute3 => p_attribute3 ,
        x_attribute4 => p_attribute4 ,
        x_attribute5 => p_attribute5 ,
        x_attribute6 => p_attribute6 ,
        x_attribute7 => p_attribute7 ,
        x_attribute8 => p_attribute8 ,
        x_attribute9 => p_attribute9 ,
        x_attribute10 => p_attribute10 ,
        x_attribute11 => p_attribute11 ,
        x_attribute12 => p_attribute12 ,
        x_attribute13 => p_attribute13 ,
        x_attribute14 => p_attribute14 ,
        x_attribute15 => p_attribute15,
        x_attribute_category => p_attribute_category ,
        X_RESOURCE_TYPE_CODE =>l_resource_type_code,
  		X_CREATION_DATE => sysdate ,
        X_CREATED_BY => jtf_task_utl.created_by ,
        X_LAST_UPDATE_DATE => sysdate ,
        X_LAST_UPDATED_BY => -1  ,
        X_LAST_UPDATE_LOGIN => jtf_task_utl.login_id );

Line: 279


            fnd_message.set_name('JTF' ,'JTF_TASK_INSERTING_RESOURCE') ;

Line: 313


	Procedure  UPDATE_TASK_RSCR_REQ
	(P_API_VERSION			IN	NUMBER					            ,
	P_OBJECT_VERSION_NUMBER	IN OUT NOCOPY	NUMBER 	 				        ,
	P_INIT_MSG_LIST			IN	VARCHAR2 DEFAULT FND_API.G_FALSE	,
	P_COMMIT			    IN	VARCHAR2 DEFAULT FND_API.G_FALSE	,
	P_RESOURCE_REQ_ID		IN	NUMBER 					            ,
	P_TASK_ID			    IN	NUMBER 	 default null			    ,
	P_TASK_NAME			    IN	VARCHAR2 default null			    ,
	P_TASK_NUMBER			IN	VARCHAR2 default null			    ,
	P_TASK_TYPE_ID			IN	NUMBER 	 default null			    ,
	P_TASK_TYPE_NAME		IN	VARCHAR2 				            ,
	P_TASK_TEMPLATE_ID		IN	NUMBER   default null			    ,
	P_TASK_TEMPLATE_NAME	IN	VARCHAR2				            ,
	P_RESOURCE_TYPE_CODE	IN	VARCHAR2				            ,
	P_REQUIRED_UNITS		IN	NUMBER 	 				            ,
	P_ENABLED_FLAG			IN	VARCHAR2 DEFAULT jtf_task_utl.g_no	,
	X_RETURN_STATUS			OUT NOCOPY	VARCHAR2				            ,
	X_MSG_COUNT			    OUT NOCOPY	NUMBER 					            ,
	X_MSG_DATA			    OUT NOCOPY	VARCHAR2				            ,
            p_attribute1              IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
        p_attribute2              IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
        p_attribute3              IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
        p_attribute4              IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
        p_attribute5              IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
        p_attribute6              IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
        p_attribute7              IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
        p_attribute8              IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
        p_attribute9              IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
        p_attribute10             IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
        p_attribute11             IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
        p_attribute12             IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
        p_attribute13             IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
        p_attribute14             IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
        p_attribute15             IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
        p_attribute_category      IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char  )  IS


	--Declare the variables
	--

	l_api_version       		constant number 					            := 1.0				    ;

Line: 381


	select
	P_TASK_ID  task_id ,
	P_TASK_TYPE_ID  task_type_id ,
	P_TASK_TEMPLATE_ID  task_template_id ,
	P_RESOURCE_TYPE_CODE  resource_type_code ,
	REQUIRED_UNITS required_units,
	ENABLED_FLAG enabled_flag,
decode( p_attribute1 , fnd_api.g_miss_char , attribute1 , p_attribute1 )  attribute1  ,
decode( p_attribute2 , fnd_api.g_miss_char , attribute2 , p_attribute2 )  attribute2  ,
decode( p_attribute3 , fnd_api.g_miss_char , attribute3 , p_attribute3 )  attribute3  ,
decode( p_attribute4 , fnd_api.g_miss_char , attribute4 , p_attribute4 )  attribute4  ,
decode( p_attribute5 , fnd_api.g_miss_char , attribute5 , p_attribute5 )  attribute5  ,
decode( p_attribute6 , fnd_api.g_miss_char , attribute6 , p_attribute6 )  attribute6  ,
decode( p_attribute7 , fnd_api.g_miss_char , attribute7 , p_attribute7 )  attribute7  ,
decode( p_attribute8 , fnd_api.g_miss_char , attribute8 , p_attribute8 )  attribute8  ,
decode( p_attribute9 , fnd_api.g_miss_char , attribute9 , p_attribute9 )  attribute9  ,
decode( p_attribute10 , fnd_api.g_miss_char , attribute10 , p_attribute10 )  attribute10  ,
decode( p_attribute11 , fnd_api.g_miss_char , attribute11 , p_attribute11 )  attribute11  ,
decode( p_attribute12 , fnd_api.g_miss_char , attribute12 , p_attribute12 )  attribute12  ,
decode( p_attribute13 , fnd_api.g_miss_char , attribute13 , p_attribute13 )  attribute13  ,
decode( p_attribute14 , fnd_api.g_miss_char , attribute14 , p_attribute14 )  attribute14  ,
decode( p_attribute15 , fnd_api.g_miss_char , attribute15 , p_attribute15 )  attribute15 ,
decode( p_attribute_category,fnd_api.g_miss_char,attribute_category,p_attribute_category) attribute_category
	from jtf_task_rsc_reqs
	where resource_req_id = l_resource_req_id ;

Line: 416


          savepoint update_task_resource_pvt ;

Line: 490


		JTF_TASK_RSC_REQS_PKG.UPDATE_ROW (
  		X_RESOURCE_REQ_ID 	=>l_resource_req_id,
  		X_TASK_TYPE_ID 		=>l_task_type_id,
  		X_TASK_ID 		=> l_task_id ,
  		X_TASK_TEMPLATE_ID 	=> l_task_template_id,
  		X_REQUIRED_UNITS 	=> l_required_units,
  		X_ENABLED_FLAG 		=> l_enabled_flag,
  		X_OBJECT_VERSION_NUMBER => p_object_version_number,
            x_attribute1 => task_res.attribute1 ,
            x_attribute2 => task_res.attribute2 ,
            x_attribute3 => task_res.attribute3 ,
            x_attribute4 => task_res.attribute4 ,
            x_attribute5 => task_res.attribute5 ,
            x_attribute6 => task_res.attribute6 ,
            x_attribute7 => task_res.attribute7 ,
            x_attribute8 => task_res.attribute8 ,
            x_attribute9 => task_res.attribute9 ,
            x_attribute10 => task_res.attribute10 ,
            x_attribute11 => task_res.attribute11 ,
            x_attribute12 => task_res.attribute12 ,
            x_attribute13 => task_res.attribute13 ,
            x_attribute14 => task_res.attribute14 ,
            x_attribute15 => task_res.attribute15 ,
            x_attribute_category => task_res.attribute_category ,
  		X_RESOURCE_TYPE_CODE 	=> l_resource_type_code,
  		X_LAST_UPDATE_DATE    	=>sysdate,
  		X_LAST_UPDATED_BY     	=> -1 ,
  		X_LAST_UPDATE_LOGIN   	=>jtf_task_utl.login_id
  		);

Line: 543


        rollback to update_task_resource_pvt ;

Line: 554


        rollback to update_task_resource_pvt ;

Line: 567


    Procedure  DELETE_TASK_RSRC_REQ
    (P_API_VERSION			    IN		NUMBER					            ,
    P_OBJECT_VERSION_NUMBER		IN		NUMBER   				            ,
    P_INIT_MSG_LIST			    IN		VARCHAR2 DEFAULT FND_API.G_FALSE	,
    P_COMMIT			        IN		VARCHAR2 DEFAULT FND_API.G_FALSE	,
    P_RESOURCE_REQ_ID		    IN		NUMBER 					            ,
    X_RETURN_STATUS			    OUT NOCOPY		VARCHAR2				            ,
    X_MSG_COUNT			        OUT NOCOPY		NUMBER 					            ,
    X_MSG_DATA			        OUT NOCOPY		VARCHAR2 				             ) IS




    l_resource_req_id         jtf_task_rsc_reqs.resource_req_id%TYPE := p_resource_req_id ;

Line: 587


    select 1
    from jtf_task_rsc_reqs
    where resource_req_id = l_resource_req_id ;

Line: 594


    savepoint delete_task_resource_pvt ;

Line: 618


   JTF_TASK_RSC_REQS_PKG.DELETE_ROW
	( X_RESOURCE_REQ_ID 		=> 	l_resource_req_id );

Line: 650


        rollback to delete_task_resource_pvt ;

Line: 657


        rollback to delete_task_resource_pvt;

Line: 708


    v_select	  varchar2(2000);

Line: 748


      v_select := 'select  '||'RESOURCE_REQ_ID,'||
                      'TASK_TYPE_ID,'||
                      'TASK_ID,'||
                      'TASK_TEMPLATE_ID,'||
                      'RESOURCE_TYPE_CODE,'||
                      'REQUIRED_UNITS,'||
                      'ENABLED_FLAG,'||
                      'ATTRIBUTE1,'||
                      'ATTRIBUTE2,'||
                      'ATTRIBUTE3,'||
                      'ATTRIBUTE4,'||
                      'ATTRIBUTE5,'||
                      'ATTRIBUTE6,'||
                      'ATTRIBUTE7,'||
                      'ATTRIBUTE8,'||
                      'ATTRIBUTE9,'||
                      'ATTRIBUTE10,'||
                      'ATTRIBUTE11,'||
                      'ATTRIBUTE12,'||
                      'ATTRIBUTE13,'||
                      'ATTRIBUTE14,'||
                      'ATTRIBUTE15,'||
                      'ATTRIBUTE_CATEGORY '||
                 'from jtf_task_rsc_reqs ';

Line: 783


        v_select := v_select || ' where ' ||v_where;

Line: 789


        v_select := v_select || ' order by ';

Line: 803


          v_select := v_select || v_comma ||
                      p_sort_data(v_index).field_name  || ' ' ;

Line: 808


            v_select := v_select || 'asc ';

Line: 810


            v_select := v_select || 'desc ';

Line: 830


   X_TASK_RSC_REQ_REC.delete;

Line: 835


      v_tbl.delete;

Line: 839


      dump_long_line('v_sel:',v_select);

Line: 843


      dbms_sql.parse(v_cursor_id, v_select, dbms_sql.v7);