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_ASSIGN_PUB dependencies on JTF_AM_FILTER_RESOURCE_PVT

Line 3790: l_skill_tbl JTF_AM_FILTER_RESOURCE_PVT.skill_param_tbl_type;

3786:
3787: l_skill_level NUMBER;
3788: l_skill_name VARCHAR2(60);
3789: l_skill_ret_sts VARCHAR2(1);
3790: l_skill_tbl JTF_AM_FILTER_RESOURCE_PVT.skill_param_tbl_type;
3791: l_group_filter VARCHAR2(100) := 'YES';
3792:
3793: -- added record type for service security check
3794: l_sr_sec_rec JTF_AM_FILTER_RESOURCE_PVT.sr_rec_type;

Line 3794: l_sr_sec_rec JTF_AM_FILTER_RESOURCE_PVT.sr_rec_type;

3790: l_skill_tbl JTF_AM_FILTER_RESOURCE_PVT.skill_param_tbl_type;
3791: l_group_filter VARCHAR2(100) := 'YES';
3792:
3793: -- added record type for service security check
3794: l_sr_sec_rec JTF_AM_FILTER_RESOURCE_PVT.sr_rec_type;
3795:
3796:
3797: BEGIN
3798:

Line 4030: JTF_AM_FILTER_RESOURCE_PVT.SERVICE_SECURITY_CHECK

4026:
4027: -- pass returned resources through security check
4028: IF(l_contracts_tbl.count > 0)
4029: THEN
4030: JTF_AM_FILTER_RESOURCE_PVT.SERVICE_SECURITY_CHECK
4031: ( p_api_version =>1.0,
4032: x_assign_resources_tbl =>l_contracts_tbl,
4033: p_sr_tbl =>l_sr_sec_rec,
4034: x_return_status =>x_return_status ,

Line 4055: JTF_AM_FILTER_RESOURCE_PVT.SERVICE_SECURITY_CHECK

4051: end IF; -- end of security check for contracts resource
4052:
4053: IF(l_ib_tbl.count > 0)
4054: THEN
4055: JTF_AM_FILTER_RESOURCE_PVT.SERVICE_SECURITY_CHECK
4056: ( p_api_version =>1.0,
4057: x_assign_resources_tbl =>l_ib_tbl,
4058: p_sr_tbl =>l_sr_sec_rec,
4059: x_return_status =>x_return_status ,

Line 4521: JTF_AM_FILTER_RESOURCE_PVT.SERVICE_SECURITY_CHECK

4517:
4518:
4519: IF(x_assign_resources_tbl.count > 0)
4520: THEN
4521: JTF_AM_FILTER_RESOURCE_PVT.SERVICE_SECURITY_CHECK
4522: ( p_api_version =>1.0,
4523: x_assign_resources_tbl =>x_assign_resources_tbl,
4524: p_sr_tbl =>l_sr_sec_rec,
4525: x_return_status =>x_return_status ,

Line 4836: -- skills bank filter call to api JTF_AM_FILTER_RESOURCE_PVT

4832: END IF; --End of p_category_id IS NOT NULL
4833: */
4834:
4835:
4836: -- skills bank filter call to api JTF_AM_FILTER_RESOURCE_PVT
4837:
4838: -- initialize values of the skill table
4839: l_skill_tbl(1).document_type := 'SR';
4840: l_skill_tbl(1).category_id := p_category_id;

Line 4853: l_api_name := l_api_name||'-JTF_AM_FILTER_RESOURCE_PVT';

4849: l_skill_tbl(1).problem_code := p_problem_code;
4850:
4851: -- change the API Name temporarily so that in case of unexpected error
4852: -- it is properly caught
4853: l_api_name := l_api_name||'-JTF_AM_FILTER_RESOURCE_PVT';
4854: JTF_AM_FILTER_RESOURCE_PVT.SEARCH_SKILL
4855: ( p_api_version => 1.0,
4856: x_assign_resources_tbl => x_assign_resources_tbl,
4857: p_skill_param_tbl => l_skill_tbl,

Line 4854: JTF_AM_FILTER_RESOURCE_PVT.SEARCH_SKILL

4850:
4851: -- change the API Name temporarily so that in case of unexpected error
4852: -- it is properly caught
4853: l_api_name := l_api_name||'-JTF_AM_FILTER_RESOURCE_PVT';
4854: JTF_AM_FILTER_RESOURCE_PVT.SEARCH_SKILL
4855: ( p_api_version => 1.0,
4856: x_assign_resources_tbl => x_assign_resources_tbl,
4857: p_skill_param_tbl => l_skill_tbl,
4858: x_return_status => l_skill_ret_sts,

Line 5165: l_skill_tbl JTF_AM_FILTER_RESOURCE_PVT.skill_param_tbl_type;

5161:
5162: l_skill_level NUMBER;
5163: l_skill_name VARCHAR2(60);
5164: l_skill_ret_sts VARCHAR2(1);
5165: l_skill_tbl JTF_AM_FILTER_RESOURCE_PVT.skill_param_tbl_type;
5166: l_group_filter VARCHAR2(100) := 'YES';
5167:
5168: -- Record type for service security check
5169: l_dr_sec_rec JTF_AM_FILTER_RESOURCE_PVT.sr_rec_type;

Line 5169: l_dr_sec_rec JTF_AM_FILTER_RESOURCE_PVT.sr_rec_type;

5165: l_skill_tbl JTF_AM_FILTER_RESOURCE_PVT.skill_param_tbl_type;
5166: l_group_filter VARCHAR2(100) := 'YES';
5167:
5168: -- Record type for service security check
5169: l_dr_sec_rec JTF_AM_FILTER_RESOURCE_PVT.sr_rec_type;
5170:
5171:
5172: CURSOR cur_resource_type IS
5173: SELECT object_code

Line 5600: JTF_AM_FILTER_RESOURCE_PVT.SERVICE_SECURITY_CHECK

5596:
5597: -- pass returned resources through security check
5598: IF(l_contracts_tbl.count > 0)
5599: THEN
5600: JTF_AM_FILTER_RESOURCE_PVT.SERVICE_SECURITY_CHECK
5601: ( p_api_version =>1.0,
5602: x_assign_resources_tbl =>l_contracts_tbl,
5603: p_sr_tbl =>l_dr_sec_rec,
5604: x_return_status =>x_return_status ,

Line 5625: JTF_AM_FILTER_RESOURCE_PVT.SERVICE_SECURITY_CHECK

5621: end IF; -- end of security check for contracts resource
5622:
5623: IF(l_ib_tbl.count > 0)
5624: THEN
5625: JTF_AM_FILTER_RESOURCE_PVT.SERVICE_SECURITY_CHECK
5626: ( p_api_version =>1.0,
5627: x_assign_resources_tbl =>l_ib_tbl,
5628: p_sr_tbl =>l_dr_sec_rec,
5629: x_return_status =>x_return_status ,

Line 5862: JTF_AM_FILTER_RESOURCE_PVT.SERVICE_SECURITY_CHECK

5858: END IF;
5859:
5860: IF(l_assign_resources_tbl.count > 0)
5861: THEN
5862: JTF_AM_FILTER_RESOURCE_PVT.SERVICE_SECURITY_CHECK
5863: ( p_api_version =>1.0,
5864: x_assign_resources_tbl =>l_assign_resources_tbl,
5865: p_sr_tbl =>l_dr_sec_rec,
5866: x_return_status =>x_return_status ,

Line 6099: -- skills bank filter call to api JTF_AM_FILTER_RESOURCE_PVT

6095: END LOOP;
6096: END IF;
6097:
6098:
6099: -- skills bank filter call to api JTF_AM_FILTER_RESOURCE_PVT
6100: -- initialize values of the skill table
6101: l_skill_tbl(1).document_type := 'DR';
6102: l_skill_tbl(1).category_id := p_category_id;
6103: l_skill_tbl(1).product_id := p_inventory_item_id;

Line 6109: l_api_name := l_api_name||'-JTF_AM_FILTER_RESOURCE_PVT';

6105: l_skill_tbl(1).problem_code := p_problem_code;
6106:
6107: -- change the API Name temporarily so that in case of unexpected error
6108: -- it is properly caught
6109: l_api_name := l_api_name||'-JTF_AM_FILTER_RESOURCE_PVT';
6110:
6111: JTF_AM_FILTER_RESOURCE_PVT.SEARCH_SKILL
6112: ( p_api_version => 1.0,
6113: x_assign_resources_tbl => l_assign_resources_tbl,

Line 6111: JTF_AM_FILTER_RESOURCE_PVT.SEARCH_SKILL

6107: -- change the API Name temporarily so that in case of unexpected error
6108: -- it is properly caught
6109: l_api_name := l_api_name||'-JTF_AM_FILTER_RESOURCE_PVT';
6110:
6111: JTF_AM_FILTER_RESOURCE_PVT.SEARCH_SKILL
6112: ( p_api_version => 1.0,
6113: x_assign_resources_tbl => l_assign_resources_tbl,
6114: p_skill_param_tbl => l_skill_tbl,
6115: x_return_status => l_skill_ret_sts,