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 dependencies on JTF_TASK_RSC_REQS

Line 202: l_enabled_flag jtf_task_rsc_reqs.enabled_flag%type := P_ENABLED_FLAG ;

198: l_task_type_id jtf_task_types_b.task_type_id%type := P_TASK_TYPE_ID ;
199: l_task_type_name jtf_task_types_tl.name%type := P_TASK_TYPE_NAME ;
200: l_task_template_id jtf_task_templates_b.task_template_id%type:= P_TASK_TEMPLATE_ID ;
201: l_task_template_name jtf_task_templates_tl.task_name%type := P_TASK_TEMPLATE_NAME ;
202: l_enabled_flag jtf_task_rsc_reqs.enabled_flag%type := P_ENABLED_FLAG ;
203: l_resource_type_code jtf_task_rsc_reqs.resource_type_code%type:= P_RESOURCE_TYPE_CODE ;
204: l_required_units jtf_task_rsc_reqs.required_units%type := P_REQUIRED_UNITS ;
205: --l_resp_appl_id NUMBER := p_resp_appl_id ;
206: --l_resp_id NUMBER := p_resp_id ;

Line 203: l_resource_type_code jtf_task_rsc_reqs.resource_type_code%type:= P_RESOURCE_TYPE_CODE ;

199: l_task_type_name jtf_task_types_tl.name%type := P_TASK_TYPE_NAME ;
200: l_task_template_id jtf_task_templates_b.task_template_id%type:= P_TASK_TEMPLATE_ID ;
201: l_task_template_name jtf_task_templates_tl.task_name%type := P_TASK_TEMPLATE_NAME ;
202: l_enabled_flag jtf_task_rsc_reqs.enabled_flag%type := P_ENABLED_FLAG ;
203: l_resource_type_code jtf_task_rsc_reqs.resource_type_code%type:= P_RESOURCE_TYPE_CODE ;
204: l_required_units jtf_task_rsc_reqs.required_units%type := P_REQUIRED_UNITS ;
205: --l_resp_appl_id NUMBER := p_resp_appl_id ;
206: --l_resp_id NUMBER := p_resp_id ;
207: --l_user_id NUMBER := p_user_id ;

Line 204: l_required_units jtf_task_rsc_reqs.required_units%type := P_REQUIRED_UNITS ;

200: l_task_template_id jtf_task_templates_b.task_template_id%type:= P_TASK_TEMPLATE_ID ;
201: l_task_template_name jtf_task_templates_tl.task_name%type := P_TASK_TEMPLATE_NAME ;
202: l_enabled_flag jtf_task_rsc_reqs.enabled_flag%type := P_ENABLED_FLAG ;
203: l_resource_type_code jtf_task_rsc_reqs.resource_type_code%type:= P_RESOURCE_TYPE_CODE ;
204: l_required_units jtf_task_rsc_reqs.required_units%type := P_REQUIRED_UNITS ;
205: --l_resp_appl_id NUMBER := p_resp_appl_id ;
206: --l_resp_id NUMBER := p_resp_id ;
207: --l_user_id NUMBER := p_user_id ;
208: --l_login_id NUMBER := p_login_id ;

Line 217: select 1 from jtf_task_rsc_reqs

213: l_rowid rowid;
214:
215:
216: cursor rr_cur3 (l_rowid in rowid ) is
217: select 1 from jtf_task_rsc_reqs
218: where rowid = l_rowid ;
219:
220: BEGIN
221:

Line 232: select JTF_TASK_RSC_REQS_S.nextval into l_resource_req_id

228:
229: --if p_enabled_flag = jtf_task_utl.g_yes then
230:
231:
232: select JTF_TASK_RSC_REQS_S.nextval into l_resource_req_id
233: from dual ;
234:
235:
236:

Line 239: JTF_TASK_RSC_REQS_PKG.INSERT_ROW (

235:
236:
237:
238:
239: JTF_TASK_RSC_REQS_PKG.INSERT_ROW (
240: X_ROWID => l_rowid,
241: X_RESOURCE_REQ_ID => l_resource_req_id,
242: X_TASK_TYPE_ID => l_task_type_id,
243: X_TASK_ID => l_task_id,

Line 363: l_enabled_flag jtf_task_rsc_reqs.enabled_flag%type := P_ENABLED_FLAG ;

359: l_task_type_id jtf_task_types_b.task_type_id%type := P_TASK_TYPE_ID ;
360: l_task_type_name jtf_task_types_tl.name%type := P_TASK_TYPE_NAME ;
361: l_task_template_id jtf_task_templates_b.task_template_id%type := P_TASK_TEMPLATE_ID ;
362: l_task_template_name jtf_task_templates_tl.task_name%type := P_TASK_TEMPLATE_NAME ;
363: l_enabled_flag jtf_task_rsc_reqs.enabled_flag%type := P_ENABLED_FLAG ;
364: l_resource_type_code jtf_task_rsc_reqs.resource_type_code%type := P_RESOURCE_TYPE_CODE ;
365: l_required_units jtf_task_rsc_reqs.required_units%type := P_REQUIRED_UNITS ;
366: --l_resp_appl_id NUMBER := p_resp_appl_id ;
367: --l_resp_id NUMBER := p_resp_id ;

Line 364: l_resource_type_code jtf_task_rsc_reqs.resource_type_code%type := P_RESOURCE_TYPE_CODE ;

360: l_task_type_name jtf_task_types_tl.name%type := P_TASK_TYPE_NAME ;
361: l_task_template_id jtf_task_templates_b.task_template_id%type := P_TASK_TEMPLATE_ID ;
362: l_task_template_name jtf_task_templates_tl.task_name%type := P_TASK_TEMPLATE_NAME ;
363: l_enabled_flag jtf_task_rsc_reqs.enabled_flag%type := P_ENABLED_FLAG ;
364: l_resource_type_code jtf_task_rsc_reqs.resource_type_code%type := P_RESOURCE_TYPE_CODE ;
365: l_required_units jtf_task_rsc_reqs.required_units%type := P_REQUIRED_UNITS ;
366: --l_resp_appl_id NUMBER := p_resp_appl_id ;
367: --l_resp_id NUMBER := p_resp_id ;
368: --l_user_id NUMBER := p_user_id ;

Line 365: l_required_units jtf_task_rsc_reqs.required_units%type := P_REQUIRED_UNITS ;

361: l_task_template_id jtf_task_templates_b.task_template_id%type := P_TASK_TEMPLATE_ID ;
362: l_task_template_name jtf_task_templates_tl.task_name%type := P_TASK_TEMPLATE_NAME ;
363: l_enabled_flag jtf_task_rsc_reqs.enabled_flag%type := P_ENABLED_FLAG ;
364: l_resource_type_code jtf_task_rsc_reqs.resource_type_code%type := P_RESOURCE_TYPE_CODE ;
365: l_required_units jtf_task_rsc_reqs.required_units%type := P_REQUIRED_UNITS ;
366: --l_resp_appl_id NUMBER := p_resp_appl_id ;
367: --l_resp_id NUMBER := p_resp_id ;
368: --l_user_id NUMBER := p_user_id ;
369: --l_login_id NUMBER := p_login_id ;

Line 404: from jtf_task_rsc_reqs

400: decode( p_attribute13 , fnd_api.g_miss_char , attribute13 , p_attribute13 ) attribute13 ,
401: decode( p_attribute14 , fnd_api.g_miss_char , attribute14 , p_attribute14 ) attribute14 ,
402: decode( p_attribute15 , fnd_api.g_miss_char , attribute15 , p_attribute15 ) attribute15 ,
403: decode( p_attribute_category,fnd_api.g_miss_char,attribute_category,p_attribute_category) attribute_category
404: from jtf_task_rsc_reqs
405: where resource_req_id = l_resource_req_id ;
406:
407: x char ;
408:

Line 490: JTF_TASK_RSC_REQS_PKG.UPDATE_ROW (

486:
487: p_object_version_number := p_object_version_number + 1 ;
488:
489:
490: JTF_TASK_RSC_REQS_PKG.UPDATE_ROW (
491: X_RESOURCE_REQ_ID =>l_resource_req_id,
492: X_TASK_TYPE_ID =>l_task_type_id,
493: X_TASK_ID => l_task_id ,
494: X_TASK_TEMPLATE_ID => l_task_template_id,

Line 580: l_resource_req_id jtf_task_rsc_reqs.resource_req_id%TYPE := p_resource_req_id ;

576:
577:
578:
579:
580: l_resource_req_id jtf_task_rsc_reqs.resource_req_id%TYPE := p_resource_req_id ;
581:
582:
583:
584: x char;

Line 588: from jtf_task_rsc_reqs

584: x char;
585:
586: cursor c_res_req_del is
587: select 1
588: from jtf_task_rsc_reqs
589: where resource_req_id = l_resource_req_id ;
590:
591:
592: begin

Line 618: JTF_TASK_RSC_REQS_PKG.DELETE_ROW

614: RAISE fnd_api.g_exc_unexpected_error;
615: END IF;
616:
617:
618: JTF_TASK_RSC_REQS_PKG.DELETE_ROW
619: ( X_RESOURCE_REQ_ID => l_resource_req_id );
620:
621: open c_res_req_del;
622: fetch c_res_req_del into x ;

Line 771: 'from jtf_task_rsc_reqs ';

767: 'ATTRIBUTE13,'||
768: 'ATTRIBUTE14,'||
769: 'ATTRIBUTE15,'||
770: 'ATTRIBUTE_CATEGORY '||
771: 'from jtf_task_rsc_reqs ';
772:
773: add_to_sql(to_char(P_RESOURCE_REQ_ID),'b1', 'resource_req_id');
774: add_to_sql(to_char(P_TASK_TYPE_ID),'b2', 'task_type_id');
775: add_to_sql(to_char(P_TASK_ID),'b3', 'task_id');