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 DUAL

Line 1940: ((p_resource_type = 'RS_INDIVIDUAL' OR p_resource_type is null)

1936: LOOP
1937: IF(l_con_preferred_engineers_tbl(l_current_record).resource_class in ('P', 'R'))
1938: THEN
1939: IF(
1940: ((p_resource_type = 'RS_INDIVIDUAL' OR p_resource_type is null)
1941: AND (l_con_preferred_engineers_tbl(l_current_record).resource_type in ('RS_EMPLOYEE',
1942: 'RS_PARTY',
1943: 'RS_PARTNER')))
1944: OR ((p_resource_type = 'RS_GROUP' OR p_resource_type is null)

Line 2219: l_dynamic_sql4 := 'SELECT CSI_UTILITY_GRP.ib_active_flag() FROM DUAL';

2215:
2216: l_pref_record := 0;
2217:
2218: -- added by sudarsana on 30th nov 2001
2219: l_dynamic_sql4 := 'SELECT CSI_UTILITY_GRP.ib_active_flag() FROM DUAL';
2220:
2221: BEGIN
2222: OPEN cur_csi_utility FOR l_dynamic_sql4;
2223: FETCH cur_csi_utility INTO l_flag;

Line 2279: (p_resource_type is null OR p_resource_type = 'RS_INDIVIDUAL')) THEN

2275:
2276: -- IF cond for category added by sudarsana 30 nov 2001 to map to resource_manager
2277:
2278: IF((l_cs_contacts_rsc_cat = 'HZ_PARTIES') AND
2279: (p_resource_type is null OR p_resource_type = 'RS_INDIVIDUAL')) THEN
2280:
2281:
2282: l_cs_contacts_rsc_cat := 'PARTY';
2283:

Line 2313: ( p_resource_type = 'RS_INDIVIDUAL' OR p_resource_type is null)) THEN

2309: END LOOP;
2310: CLOSE cur_ib_resources;
2311:
2312: ELSIF((l_cs_contacts_rsc_cat = 'PO_VENDORS') AND
2313: ( p_resource_type = 'RS_INDIVIDUAL' OR p_resource_type is null)) THEN
2314:
2315: OPEN cur_ib_supp_resources;
2316: LOOP
2317: FETCH cur_ib_supp_resources INTO l_cur_ib_resources;

Line 2359: ELSIF(p_resource_type = 'RS_INDIVIDUAL' OR p_resource_type is null) THEN

2355: l_pref_record := l_pref_record + 1;
2356: END LOOP;
2357: CLOSE cur_ib_resources_team;
2358:
2359: ELSIF(p_resource_type = 'RS_INDIVIDUAL' OR p_resource_type is null) THEN
2360:
2361: OPEN cur_ib_resources;
2362: LOOP
2363: FETCH cur_ib_resources INTO l_cur_ib_resources;

Line 3867: IF ( UPPER(p_resource_type) = 'RS_INDIVIDUAL') THEN

3863:
3864: x_return_status := fnd_api.g_ret_sts_success;
3865:
3866:
3867: IF ( UPPER(p_resource_type) = 'RS_INDIVIDUAL') THEN
3868: l_p_resource_type := 'RS_INDIVIDUAL';
3869: ELSIF(p_resource_type is null) THEN
3870: l_p_resource_type := null;
3871: ELSE

Line 3868: l_p_resource_type := 'RS_INDIVIDUAL';

3864: x_return_status := fnd_api.g_ret_sts_success;
3865:
3866:
3867: IF ( UPPER(p_resource_type) = 'RS_INDIVIDUAL') THEN
3868: l_p_resource_type := 'RS_INDIVIDUAL';
3869: ELSIF(p_resource_type is null) THEN
3870: l_p_resource_type := null;
3871: ELSE
3872: l_p_resource_type := p_resource_type;

Line 4279: if(l_p_resource_type = 'RS_INDIVIDUAL')

4275: ts('p_sr_rec.CUSTOMER_SITE_ID'||p_sr_rec.CUSTOMER_SITE_ID);ts('p_sr_rec.INVENTORY_ITEM_ID'||p_sr_rec.INVENTORY_ITEM_ID);
4276: ts('p_sr_rec.SR_CREATION_CHANNEL'||p_sr_rec.SR_CREATION_CHANNEL);ts('p_sr_rec.PLATFORM_ID'||p_sr_rec.PLATFORM_ID);*/
4277: IF (p_territory_flag = 'Y') THEN
4278:
4279: if(l_p_resource_type = 'RS_INDIVIDUAL')
4280: then
4281: l_p_resource_type := null;
4282: end if;
4283:

Line 4407: IF (l_p_resource_type = 'RS_INDIVIDUAL') THEN

4403:
4404:
4405: IF (p_territory_flag = 'Y') THEN
4406:
4407: IF (l_p_resource_type = 'RS_INDIVIDUAL') THEN
4408: l_p_resource_type := NULL;
4409: END IF;
4410:
4411: -- change the API Name temporarily so that in case of unexpected error

Line 4623: if((p_sr_rec.squal_num17 is not null) ) -- AND (p_resource_type = 'RS_INDIVIDUAL'))

4619:
4620:
4621: IF(l_group_filter = 'YES')
4622: THEN
4623: if((p_sr_rec.squal_num17 is not null) ) -- AND (p_resource_type = 'RS_INDIVIDUAL'))
4624: then
4625: get_group_resource(p_sr_rec.squal_num17 ,
4626: x_assign_resources_tbl );
4627: elsif((p_sr_task_rec.squal_num17 is not null) ) -- AND (p_resource_type = 'RS_INDIVIDUAL'))

Line 4627: elsif((p_sr_task_rec.squal_num17 is not null) ) -- AND (p_resource_type = 'RS_INDIVIDUAL'))

4623: if((p_sr_rec.squal_num17 is not null) ) -- AND (p_resource_type = 'RS_INDIVIDUAL'))
4624: then
4625: get_group_resource(p_sr_rec.squal_num17 ,
4626: x_assign_resources_tbl );
4627: elsif((p_sr_task_rec.squal_num17 is not null) ) -- AND (p_resource_type = 'RS_INDIVIDUAL'))
4628: then
4629: get_group_resource(p_sr_task_rec.squal_num17 ,
4630: x_assign_resources_tbl );
4631: END IF;

Line 4642: -- Start of enhancement for showing Individual Resources ONLY

4638:
4639:
4640:
4641:
4642: -- Start of enhancement for showing Individual Resources ONLY
4643:
4644:
4645: IF ( UPPER(p_resource_type) = 'RS_INDIVIDUAL' ) THEN
4646:

Line 4645: IF ( UPPER(p_resource_type) = 'RS_INDIVIDUAL' ) THEN

4641:
4642: -- Start of enhancement for showing Individual Resources ONLY
4643:
4644:
4645: IF ( UPPER(p_resource_type) = 'RS_INDIVIDUAL' ) THEN
4646:
4647:
4648: -- Reconstructing the table to further do the enhancements
4649:

Line 4767: END IF; --End of p_resource_type = 'RS_INDIVIDUAL'

4763: END LOOP;
4764:
4765: END IF; --End of l_tbl.COUNT > 0
4766:
4767: END IF; --End of p_resource_type = 'RS_INDIVIDUAL'
4768:
4769: -- End of enhancement
4770:
4771:

Line 5466: IF ( UPPER(p_resource_type) = 'RS_INDIVIDUAL') THEN

5462: l_dr_rec.SQUAL_CHAR20 := p_dr_rec.SQUAL_CHAR20;
5463: l_dr_rec.SQUAL_CHAR21 := p_dr_rec.SQUAL_CHAR21;
5464:
5465:
5466: IF ( UPPER(p_resource_type) = 'RS_INDIVIDUAL') THEN
5467: l_p_resource_type := 'RS_INDIVIDUAL';
5468: ELSIF(p_resource_type is null) THEN
5469: l_p_resource_type := null;
5470: ELSE

Line 5467: l_p_resource_type := 'RS_INDIVIDUAL';

5463: l_dr_rec.SQUAL_CHAR21 := p_dr_rec.SQUAL_CHAR21;
5464:
5465:
5466: IF ( UPPER(p_resource_type) = 'RS_INDIVIDUAL') THEN
5467: l_p_resource_type := 'RS_INDIVIDUAL';
5468: ELSIF(p_resource_type is null) THEN
5469: l_p_resource_type := null;
5470: ELSE
5471: l_p_resource_type := p_resource_type;

Line 5777: IF (l_p_resource_type = 'RS_INDIVIDUAL') THEN

5773: IF l_assign_resources_tbl.COUNT <= 0
5774: THEN
5775: IF (p_territory_flag = 'Y') THEN
5776:
5777: IF (l_p_resource_type = 'RS_INDIVIDUAL') THEN
5778: l_p_resource_type := NULL;
5779: END IF;
5780:
5781: -- change the API Name temporarily so that in case of unexpected error

Line 5972: -- Start of enhancement for showing Individual Resources ONLY

5968:
5969: END IF; -- End of l_assign_resources_tbl.COUNT <= 0
5970:
5971:
5972: -- Start of enhancement for showing Individual Resources ONLY
5973:
5974: IF ( UPPER(p_resource_type) = 'RS_INDIVIDUAL' ) THEN
5975:
5976: -- Reconstructing the table to further do the enhancements

Line 5974: IF ( UPPER(p_resource_type) = 'RS_INDIVIDUAL' ) THEN

5970:
5971:
5972: -- Start of enhancement for showing Individual Resources ONLY
5973:
5974: IF ( UPPER(p_resource_type) = 'RS_INDIVIDUAL' ) THEN
5975:
5976: -- Reconstructing the table to further do the enhancements
5977:
5978: IF ( l_assign_resources_tbl.COUNT > 0 ) THEN

Line 6082: END IF; --End of p_resource_type = 'RS_INDIVIDUAL'

6078: END LOOP;
6079:
6080: END IF; --End of l_tbl.COUNT > 0
6081:
6082: END IF; --End of p_resource_type = 'RS_INDIVIDUAL'
6083:
6084:
6085: -- To add SUPPORT SITE ID and NAME to the OUT Table
6086:

Line 6388: FROM dual;

6384: -- To Plugin the Workflow enabling the user
6385: -- to further filter the resources
6386:
6387: SELECT jtf_calendars_s.NEXTVAL INTO l_workflow_key
6388: FROM dual;
6389:
6390: IF (JTF_USR_HKS.ok_to_execute
6391: (
6392: 'JTF_ASSIGN_PUB',

Line 7082: FROM dual;

7078: --l_workflow_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_WORKFLOW_NAME' ); -- Commented out by SBARAT on 12/10/2004, Bug-3830061
7079: l_workflow_profile := FND_PROFILE.VALUE ( 'ACTIVATE_WORKFLOW_NAME' ); -- Added by SBARAT on 12/10/2004, Bug-3830061
7080:
7081: SELECT jtf_calendars_s.NEXTVAL INTO l_workflow_key
7082: FROM dual;
7083:
7084: IF (JTF_USR_HKS.ok_to_execute
7085: (
7086: 'JTF_ASSIGN_PUB',

Line 7670: FROM dual;

7666: --l_workflow_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_WORKFLOW_NAME' ); -- Commented out by SBARAT on 12/10/2004, Bug-3830061
7667: l_workflow_profile := FND_PROFILE.VALUE ( 'ACTIVATE_WORKFLOW_NAME' ); -- Added by SBARAT on 12/10/2004, Bug-3830061
7668:
7669: SELECT jtf_calendars_s.NEXTVAL INTO l_workflow_key
7670: FROM dual;
7671:
7672: IF (JTF_USR_HKS.ok_to_execute
7673: (
7674: 'JTF_ASSIGN_PUB',

Line 8282: FROM dual;

8278: --l_workflow_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_WORKFLOW_NAME' ); -- Commented out by SBARAT on 12/10/2004, Bug-3830061
8279: l_workflow_profile := FND_PROFILE.VALUE ( 'ACTIVATE_WORKFLOW_NAME' ); -- Added by SBARAT on 12/10/2004, Bug-3830061
8280:
8281: SELECT jtf_calendars_s.NEXTVAL INTO l_workflow_key
8282: FROM dual;
8283:
8284: IF (JTF_USR_HKS.ok_to_execute
8285: (
8286: 'JTF_ASSIGN_PUB',

Line 8930: FROM dual;

8926: --l_workflow_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_WORKFLOW_NAME' ); -- Commented out by SBARAT on 12/10/2004, Bug-3830061
8927: l_workflow_profile := FND_PROFILE.VALUE ( 'ACTIVATE_WORKFLOW_NAME' ); -- Added by SBARAT on 12/10/2004, Bug-3830061
8928:
8929: SELECT jtf_calendars_s.NEXTVAL INTO l_workflow_key
8930: FROM dual;
8931:
8932: IF (JTF_USR_HKS.ok_to_execute
8933: (
8934: 'JTF_ASSIGN_PUB',

Line 10452: FROM dual;

10448: l_workflow_profile := FND_PROFILE.VALUE ( 'ACTIVATE_WORKFLOW_NAME' ); -- Added by SBARAT on 12/10/2004, Bug-3830061
10449:
10450:
10451: SELECT jtf_calendars_s.NEXTVAL INTO l_workflow_key
10452: FROM dual;
10453:
10454: IF (JTF_USR_HKS.ok_to_execute
10455: (
10456: 'JTF_ASSIGN_PUB',

Line 11971: FROM dual;

11967: -- To Plugin the Workflow enabling the user
11968: -- to further filter the resources
11969:
11970: SELECT jtf_calendars_s.NEXTVAL INTO l_workflow_key
11971: FROM dual;
11972:
11973: IF (JTF_USR_HKS.ok_to_execute
11974: (
11975: 'JTF_ASSIGN_PUB',