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

Line 49: l_enabled_flag jtf_task_rsc_reqs.enabled_flag%TYPE := p_enabled_flag;

45: l_task_type_id jtf_task_types_b.task_type_id%TYPE := p_task_type_id;
46: l_task_type_name jtf_task_types_tl.NAME%TYPE := p_task_type_name;
47: l_task_template_id jtf_task_templates_b.task_template_id%TYPE := p_task_template_id;
48: l_task_template_name jtf_task_templates_tl.task_name%TYPE := p_task_template_name;
49: l_enabled_flag jtf_task_rsc_reqs.enabled_flag%TYPE := p_enabled_flag;
50: l_resource_type_code jtf_task_rsc_reqs.resource_type_code%TYPE := p_resource_type_code;
51: l_required_units jtf_task_rsc_reqs.required_units%TYPE := p_required_units;
52: l_msg_data VARCHAR2(2000);
53: l_msg_count NUMBER;

Line 50: l_resource_type_code jtf_task_rsc_reqs.resource_type_code%TYPE := p_resource_type_code;

46: l_task_type_name jtf_task_types_tl.NAME%TYPE := p_task_type_name;
47: l_task_template_id jtf_task_templates_b.task_template_id%TYPE := p_task_template_id;
48: l_task_template_name jtf_task_templates_tl.task_name%TYPE := p_task_template_name;
49: l_enabled_flag jtf_task_rsc_reqs.enabled_flag%TYPE := p_enabled_flag;
50: l_resource_type_code jtf_task_rsc_reqs.resource_type_code%TYPE := p_resource_type_code;
51: l_required_units jtf_task_rsc_reqs.required_units%TYPE := p_required_units;
52: l_msg_data VARCHAR2(2000);
53: l_msg_count NUMBER;
54: x CHAR;

Line 51: l_required_units jtf_task_rsc_reqs.required_units%TYPE := p_required_units;

47: l_task_template_id jtf_task_templates_b.task_template_id%TYPE := p_task_template_id;
48: l_task_template_name jtf_task_templates_tl.task_name%TYPE := p_task_template_name;
49: l_enabled_flag jtf_task_rsc_reqs.enabled_flag%TYPE := p_enabled_flag;
50: l_resource_type_code jtf_task_rsc_reqs.resource_type_code%TYPE := p_resource_type_code;
51: l_required_units jtf_task_rsc_reqs.required_units%TYPE := p_required_units;
52: l_msg_data VARCHAR2(2000);
53: l_msg_count NUMBER;
54: x CHAR;
55: --

Line 350: l_enabled_flag jtf_task_rsc_reqs.enabled_flag%TYPE := p_enabled_flag;

346: l_task_type_id jtf_task_types_b.task_type_id%TYPE := p_task_type_id;
347: l_task_type_name jtf_task_types_tl.NAME%TYPE := p_task_type_name;
348: l_task_template_id jtf_task_templates_b.task_template_id%TYPE := p_task_template_id;
349: l_task_template_name jtf_task_templates_tl.task_name%TYPE := p_task_template_name;
350: l_enabled_flag jtf_task_rsc_reqs.enabled_flag%TYPE := p_enabled_flag;
351: l_resource_type_code jtf_task_rsc_reqs.resource_type_code%TYPE := p_resource_type_code;
352: l_required_units jtf_task_rsc_reqs.required_units%TYPE := p_required_units;
353: l_msg_data VARCHAR2(2000);
354: l_msg_count NUMBER;

Line 351: l_resource_type_code jtf_task_rsc_reqs.resource_type_code%TYPE := p_resource_type_code;

347: l_task_type_name jtf_task_types_tl.NAME%TYPE := p_task_type_name;
348: l_task_template_id jtf_task_templates_b.task_template_id%TYPE := p_task_template_id;
349: l_task_template_name jtf_task_templates_tl.task_name%TYPE := p_task_template_name;
350: l_enabled_flag jtf_task_rsc_reqs.enabled_flag%TYPE := p_enabled_flag;
351: l_resource_type_code jtf_task_rsc_reqs.resource_type_code%TYPE := p_resource_type_code;
352: l_required_units jtf_task_rsc_reqs.required_units%TYPE := p_required_units;
353: l_msg_data VARCHAR2(2000);
354: l_msg_count NUMBER;
355: x CHAR;

Line 352: l_required_units jtf_task_rsc_reqs.required_units%TYPE := p_required_units;

348: l_task_template_id jtf_task_templates_b.task_template_id%TYPE := p_task_template_id;
349: l_task_template_name jtf_task_templates_tl.task_name%TYPE := p_task_template_name;
350: l_enabled_flag jtf_task_rsc_reqs.enabled_flag%TYPE := p_enabled_flag;
351: l_resource_type_code jtf_task_rsc_reqs.resource_type_code%TYPE := p_resource_type_code;
352: l_required_units jtf_task_rsc_reqs.required_units%TYPE := p_required_units;
353: l_msg_data VARCHAR2(2000);
354: l_msg_count NUMBER;
355: x CHAR;
356: l_resource_req_id NUMBER := p_resource_req_id;

Line 387: FROM jtf_task_rsc_reqs

383: p_attribute_category
384: , fnd_api.g_miss_char, attribute_category
385: , p_attribute_category
386: ) attribute_category
387: FROM jtf_task_rsc_reqs
388: WHERE resource_req_id = p_resource_req_id;
389:
390: task_rsrc_req_rec jtf_rsrc_req_cur%ROWTYPE;
391: BEGIN

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

590: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_TASK_RSRC_REQ';
591: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
592: l_msg_data VARCHAR2(2000);
593: l_msg_count NUMBER;
594: l_resource_req_id jtf_task_rsc_reqs.resource_req_id%TYPE := p_resource_req_id;
595:
596: CURSOR jtf_task_rsc_req_u_cur IS
597: SELECT 1
598: FROM jtf_task_rsc_reqs

Line 598: FROM jtf_task_rsc_reqs

594: l_resource_req_id jtf_task_rsc_reqs.resource_req_id%TYPE := p_resource_req_id;
595:
596: CURSOR jtf_task_rsc_req_u_cur IS
597: SELECT 1
598: FROM jtf_task_rsc_reqs
599: WHERE resource_req_id = l_resource_req_id;
600:
601: x CHAR;
602: BEGIN

Line 744: l_resource_type_code jtf_task_rsc_reqs.resource_type_code%TYPE := p_resource_type_code;

740: l_api_name CONSTANT VARCHAR2(30) := 'GET_TASK_RSRC_REQ';
741: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
742: l_msg_data VARCHAR2(2000);
743: l_msg_count NUMBER;
744: l_resource_type_code jtf_task_rsc_reqs.resource_type_code%TYPE := p_resource_type_code;
745: l_task_id jtf_task_rsc_reqs.task_id%TYPE := p_task_id;
746: l_task_type_id jtf_task_rsc_reqs.task_type_id%TYPE := p_task_type_id;
747: l_task_template_id jtf_task_rsc_reqs.task_template_id%TYPE := p_task_template_id;
748: l_required_units NUMBER := p_required_units;

Line 745: l_task_id jtf_task_rsc_reqs.task_id%TYPE := p_task_id;

741: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
742: l_msg_data VARCHAR2(2000);
743: l_msg_count NUMBER;
744: l_resource_type_code jtf_task_rsc_reqs.resource_type_code%TYPE := p_resource_type_code;
745: l_task_id jtf_task_rsc_reqs.task_id%TYPE := p_task_id;
746: l_task_type_id jtf_task_rsc_reqs.task_type_id%TYPE := p_task_type_id;
747: l_task_template_id jtf_task_rsc_reqs.task_template_id%TYPE := p_task_template_id;
748: l_required_units NUMBER := p_required_units;
749: l_enabled_flag VARCHAR2(1) := p_enabled_flag;

Line 746: l_task_type_id jtf_task_rsc_reqs.task_type_id%TYPE := p_task_type_id;

742: l_msg_data VARCHAR2(2000);
743: l_msg_count NUMBER;
744: l_resource_type_code jtf_task_rsc_reqs.resource_type_code%TYPE := p_resource_type_code;
745: l_task_id jtf_task_rsc_reqs.task_id%TYPE := p_task_id;
746: l_task_type_id jtf_task_rsc_reqs.task_type_id%TYPE := p_task_type_id;
747: l_task_template_id jtf_task_rsc_reqs.task_template_id%TYPE := p_task_template_id;
748: l_required_units NUMBER := p_required_units;
749: l_enabled_flag VARCHAR2(1) := p_enabled_flag;
750: l_task_name VARCHAR2(80) := p_task_name;

Line 747: l_task_template_id jtf_task_rsc_reqs.task_template_id%TYPE := p_task_template_id;

743: l_msg_count NUMBER;
744: l_resource_type_code jtf_task_rsc_reqs.resource_type_code%TYPE := p_resource_type_code;
745: l_task_id jtf_task_rsc_reqs.task_id%TYPE := p_task_id;
746: l_task_type_id jtf_task_rsc_reqs.task_type_id%TYPE := p_task_type_id;
747: l_task_template_id jtf_task_rsc_reqs.task_template_id%TYPE := p_task_template_id;
748: l_required_units NUMBER := p_required_units;
749: l_enabled_flag VARCHAR2(1) := p_enabled_flag;
750: l_task_name VARCHAR2(80) := p_task_name;
751: l_task_type_name VARCHAR2(30) := p_task_type_name;

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

749: l_enabled_flag VARCHAR2(1) := p_enabled_flag;
750: l_task_name VARCHAR2(80) := p_task_name;
751: l_task_type_name VARCHAR2(30) := p_task_type_name;
752: l_task_template_name VARCHAR2(80) := p_task_template_name;
753: l_resource_req_id jtf_task_rsc_reqs.resource_req_id%TYPE := p_resource_req_id;
754: BEGIN
755: SAVEPOINT get_task_rsrc_req;
756: x_return_status := fnd_api.g_ret_sts_success;
757:

Line 872: jtf_task_rsc_reqs_pkg.lock_row(

868: fnd_msg_pub.initialize;
869: END IF;
870:
871: x_return_status := fnd_api.g_ret_sts_success;
872: jtf_task_rsc_reqs_pkg.lock_row(
873: x_resource_req_id => p_resource_requirement_id
874: , x_object_version_number => p_object_version_number
875: );
876: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);