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 3827: l_skill_tbl JTF_AM_FILTER_RESOURCE_PVT.skill_param_tbl_type;

3823:
3824: l_skill_level NUMBER;
3825: l_skill_name VARCHAR2(60);
3826: l_skill_ret_sts VARCHAR2(1);
3827: l_skill_tbl JTF_AM_FILTER_RESOURCE_PVT.skill_param_tbl_type;
3828: l_group_filter VARCHAR2(100) := 'YES';
3829:
3830: -- added record type for service security check
3831: l_sr_sec_rec JTF_AM_FILTER_RESOURCE_PVT.sr_rec_type;

Line 3831: l_sr_sec_rec JTF_AM_FILTER_RESOURCE_PVT.sr_rec_type;

3827: l_skill_tbl JTF_AM_FILTER_RESOURCE_PVT.skill_param_tbl_type;
3828: l_group_filter VARCHAR2(100) := 'YES';
3829:
3830: -- added record type for service security check
3831: l_sr_sec_rec JTF_AM_FILTER_RESOURCE_PVT.sr_rec_type;
3832:
3833: /*procedure ts(v varchar2)
3834: is
3835: pragma autonomous_transaction;

Line 4074: JTF_AM_FILTER_RESOURCE_PVT.SERVICE_SECURITY_CHECK

4070:
4071: -- pass returned resources through security check
4072: IF(l_contracts_tbl.count > 0)
4073: THEN
4074: JTF_AM_FILTER_RESOURCE_PVT.SERVICE_SECURITY_CHECK
4075: ( p_api_version =>1.0,
4076: x_assign_resources_tbl =>l_contracts_tbl,
4077: p_sr_tbl =>l_sr_sec_rec,
4078: x_return_status =>x_return_status ,

Line 4099: JTF_AM_FILTER_RESOURCE_PVT.SERVICE_SECURITY_CHECK

4095: end IF; -- end of security check for contracts resource
4096:
4097: IF(l_ib_tbl.count > 0)
4098: THEN
4099: JTF_AM_FILTER_RESOURCE_PVT.SERVICE_SECURITY_CHECK
4100: ( p_api_version =>1.0,
4101: x_assign_resources_tbl =>l_ib_tbl,
4102: p_sr_tbl =>l_sr_sec_rec,
4103: x_return_status =>x_return_status ,

Line 4585: JTF_AM_FILTER_RESOURCE_PVT.SERVICE_SECURITY_CHECK

4581:
4582:
4583: IF(x_assign_resources_tbl.count > 0)
4584: THEN
4585: JTF_AM_FILTER_RESOURCE_PVT.SERVICE_SECURITY_CHECK
4586: ( p_api_version =>1.0,
4587: x_assign_resources_tbl =>x_assign_resources_tbl,
4588: p_sr_tbl =>l_sr_sec_rec,
4589: x_return_status =>x_return_status ,

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

4896: END IF; --End of p_category_id IS NOT NULL
4897: */
4898:
4899:
4900: -- skills bank filter call to api JTF_AM_FILTER_RESOURCE_PVT
4901:
4902: -- initialize values of the skill table
4903: l_skill_tbl(1).document_type := 'SR';
4904: l_skill_tbl(1).category_id := p_category_id;

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

4913: l_skill_tbl(1).problem_code := p_problem_code;
4914:
4915: -- change the API Name temporarily so that in case of unexpected error
4916: -- it is properly caught
4917: l_api_name := l_api_name||'-JTF_AM_FILTER_RESOURCE_PVT';
4918: JTF_AM_FILTER_RESOURCE_PVT.SEARCH_SKILL
4919: ( p_api_version => 1.0,
4920: x_assign_resources_tbl => x_assign_resources_tbl,
4921: p_skill_param_tbl => l_skill_tbl,

Line 4918: JTF_AM_FILTER_RESOURCE_PVT.SEARCH_SKILL

4914:
4915: -- change the API Name temporarily so that in case of unexpected error
4916: -- it is properly caught
4917: l_api_name := l_api_name||'-JTF_AM_FILTER_RESOURCE_PVT';
4918: JTF_AM_FILTER_RESOURCE_PVT.SEARCH_SKILL
4919: ( p_api_version => 1.0,
4920: x_assign_resources_tbl => x_assign_resources_tbl,
4921: p_skill_param_tbl => l_skill_tbl,
4922: x_return_status => l_skill_ret_sts,

Line 5229: l_skill_tbl JTF_AM_FILTER_RESOURCE_PVT.skill_param_tbl_type;

5225:
5226: l_skill_level NUMBER;
5227: l_skill_name VARCHAR2(60);
5228: l_skill_ret_sts VARCHAR2(1);
5229: l_skill_tbl JTF_AM_FILTER_RESOURCE_PVT.skill_param_tbl_type;
5230: l_group_filter VARCHAR2(100) := 'YES';
5231:
5232: -- Record type for service security check
5233: l_dr_sec_rec JTF_AM_FILTER_RESOURCE_PVT.sr_rec_type;

Line 5233: l_dr_sec_rec JTF_AM_FILTER_RESOURCE_PVT.sr_rec_type;

5229: l_skill_tbl JTF_AM_FILTER_RESOURCE_PVT.skill_param_tbl_type;
5230: l_group_filter VARCHAR2(100) := 'YES';
5231:
5232: -- Record type for service security check
5233: l_dr_sec_rec JTF_AM_FILTER_RESOURCE_PVT.sr_rec_type;
5234:
5235:
5236: CURSOR cur_resource_type IS
5237: SELECT object_code

Line 5664: JTF_AM_FILTER_RESOURCE_PVT.SERVICE_SECURITY_CHECK

5660:
5661: -- pass returned resources through security check
5662: IF(l_contracts_tbl.count > 0)
5663: THEN
5664: JTF_AM_FILTER_RESOURCE_PVT.SERVICE_SECURITY_CHECK
5665: ( p_api_version =>1.0,
5666: x_assign_resources_tbl =>l_contracts_tbl,
5667: p_sr_tbl =>l_dr_sec_rec,
5668: x_return_status =>x_return_status ,

Line 5689: JTF_AM_FILTER_RESOURCE_PVT.SERVICE_SECURITY_CHECK

5685: end IF; -- end of security check for contracts resource
5686:
5687: IF(l_ib_tbl.count > 0)
5688: THEN
5689: JTF_AM_FILTER_RESOURCE_PVT.SERVICE_SECURITY_CHECK
5690: ( p_api_version =>1.0,
5691: x_assign_resources_tbl =>l_ib_tbl,
5692: p_sr_tbl =>l_dr_sec_rec,
5693: x_return_status =>x_return_status ,

Line 5926: JTF_AM_FILTER_RESOURCE_PVT.SERVICE_SECURITY_CHECK

5922: END IF;
5923:
5924: IF(l_assign_resources_tbl.count > 0)
5925: THEN
5926: JTF_AM_FILTER_RESOURCE_PVT.SERVICE_SECURITY_CHECK
5927: ( p_api_version =>1.0,
5928: x_assign_resources_tbl =>l_assign_resources_tbl,
5929: p_sr_tbl =>l_dr_sec_rec,
5930: x_return_status =>x_return_status ,

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

6159: END LOOP;
6160: END IF;
6161:
6162:
6163: -- skills bank filter call to api JTF_AM_FILTER_RESOURCE_PVT
6164: -- initialize values of the skill table
6165: l_skill_tbl(1).document_type := 'DR';
6166: l_skill_tbl(1).category_id := p_category_id;
6167: l_skill_tbl(1).product_id := p_inventory_item_id;

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

6169: l_skill_tbl(1).problem_code := p_problem_code;
6170:
6171: -- change the API Name temporarily so that in case of unexpected error
6172: -- it is properly caught
6173: l_api_name := l_api_name||'-JTF_AM_FILTER_RESOURCE_PVT';
6174:
6175: JTF_AM_FILTER_RESOURCE_PVT.SEARCH_SKILL
6176: ( p_api_version => 1.0,
6177: x_assign_resources_tbl => l_assign_resources_tbl,

Line 6175: JTF_AM_FILTER_RESOURCE_PVT.SEARCH_SKILL

6171: -- change the API Name temporarily so that in case of unexpected error
6172: -- it is properly caught
6173: l_api_name := l_api_name||'-JTF_AM_FILTER_RESOURCE_PVT';
6174:
6175: JTF_AM_FILTER_RESOURCE_PVT.SEARCH_SKILL
6176: ( p_api_version => 1.0,
6177: x_assign_resources_tbl => l_assign_resources_tbl,
6178: p_skill_param_tbl => l_skill_tbl,
6179: x_return_status => l_skill_ret_sts,