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 1903: ((p_resource_type = 'RS_INDIVIDUAL' OR p_resource_type is null)

1899: LOOP
1900: IF(l_con_preferred_engineers_tbl(l_current_record).resource_class in ('P', 'R'))
1901: THEN
1902: IF(
1903: ((p_resource_type = 'RS_INDIVIDUAL' OR p_resource_type is null)
1904: AND (l_con_preferred_engineers_tbl(l_current_record).resource_type in ('RS_EMPLOYEE',
1905: 'RS_PARTY',
1906: 'RS_PARTNER')))
1907: OR ((p_resource_type = 'RS_GROUP' OR p_resource_type is null)

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

2178:
2179: l_pref_record := 0;
2180:
2181: -- added by sudarsana on 30th nov 2001
2182: l_dynamic_sql4 := 'SELECT CSI_UTILITY_GRP.ib_active_flag() FROM DUAL';
2183:
2184: BEGIN
2185: OPEN cur_csi_utility FOR l_dynamic_sql4;
2186: FETCH cur_csi_utility INTO l_flag;

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

2238:
2239: -- IF cond for category added by sudarsana 30 nov 2001 to map to resource_manager
2240:
2241: IF((l_cs_contacts_rsc_cat = 'HZ_PARTIES') AND
2242: (p_resource_type is null OR p_resource_type = 'RS_INDIVIDUAL')) THEN
2243:
2244:
2245: l_cs_contacts_rsc_cat := 'PARTY';
2246:

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

2272: END LOOP;
2273: CLOSE cur_ib_resources;
2274:
2275: ELSIF((l_cs_contacts_rsc_cat = 'PO_VENDORS') AND
2276: ( p_resource_type = 'RS_INDIVIDUAL' OR p_resource_type is null)) THEN
2277:
2278: OPEN cur_ib_supp_resources;
2279: LOOP
2280: FETCH cur_ib_supp_resources INTO l_cur_ib_resources;

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

2318: l_pref_record := l_pref_record + 1;
2319: END LOOP;
2320: CLOSE cur_ib_resources_team;
2321:
2322: ELSIF(p_resource_type = 'RS_INDIVIDUAL' OR p_resource_type is null) THEN
2323:
2324: OPEN cur_ib_resources;
2325: LOOP
2326: FETCH cur_ib_resources INTO l_cur_ib_resources;

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

3819:
3820: x_return_status := fnd_api.g_ret_sts_success;
3821:
3822:
3823: IF ( UPPER(p_resource_type) = 'RS_INDIVIDUAL') THEN
3824: l_p_resource_type := 'RS_INDIVIDUAL';
3825: ELSIF(p_resource_type is null) THEN
3826: l_p_resource_type := null;
3827: ELSE

Line 3824: l_p_resource_type := 'RS_INDIVIDUAL';

3820: x_return_status := fnd_api.g_ret_sts_success;
3821:
3822:
3823: IF ( UPPER(p_resource_type) = 'RS_INDIVIDUAL') THEN
3824: l_p_resource_type := 'RS_INDIVIDUAL';
3825: ELSIF(p_resource_type is null) THEN
3826: l_p_resource_type := null;
3827: ELSE
3828: l_p_resource_type := p_resource_type;

Line 4220: if(l_p_resource_type = 'RS_INDIVIDUAL')

4216:
4217:
4218: IF (p_territory_flag = 'Y') THEN
4219:
4220: if(l_p_resource_type = 'RS_INDIVIDUAL')
4221: then
4222: l_p_resource_type := null;
4223: end if;
4224:

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

4341:
4342:
4343: IF (p_territory_flag = 'Y') THEN
4344:
4345: IF (l_p_resource_type = 'RS_INDIVIDUAL') THEN
4346: l_p_resource_type := NULL;
4347: END IF;
4348:
4349: -- change the API Name temporarily so that in case of unexpected error

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

4555:
4556:
4557: IF(l_group_filter = 'YES')
4558: THEN
4559: if((p_sr_rec.squal_num17 is not null) ) -- AND (p_resource_type = 'RS_INDIVIDUAL'))
4560: then
4561: get_group_resource(p_sr_rec.squal_num17 ,
4562: x_assign_resources_tbl );
4563: elsif((p_sr_task_rec.squal_num17 is not null) ) -- AND (p_resource_type = 'RS_INDIVIDUAL'))

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

4559: if((p_sr_rec.squal_num17 is not null) ) -- AND (p_resource_type = 'RS_INDIVIDUAL'))
4560: then
4561: get_group_resource(p_sr_rec.squal_num17 ,
4562: x_assign_resources_tbl );
4563: elsif((p_sr_task_rec.squal_num17 is not null) ) -- AND (p_resource_type = 'RS_INDIVIDUAL'))
4564: then
4565: get_group_resource(p_sr_task_rec.squal_num17 ,
4566: x_assign_resources_tbl );
4567: END IF;

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

4574:
4575:
4576:
4577:
4578: -- Start of enhancement for showing Individual Resources ONLY
4579:
4580:
4581: IF ( UPPER(p_resource_type) = 'RS_INDIVIDUAL' ) THEN
4582:

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

4577:
4578: -- Start of enhancement for showing Individual Resources ONLY
4579:
4580:
4581: IF ( UPPER(p_resource_type) = 'RS_INDIVIDUAL' ) THEN
4582:
4583:
4584: -- Reconstructing the table to further do the enhancements
4585:

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

4699: END LOOP;
4700:
4701: END IF; --End of l_tbl.COUNT > 0
4702:
4703: END IF; --End of p_resource_type = 'RS_INDIVIDUAL'
4704:
4705: -- End of enhancement
4706:
4707:

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

5398: l_dr_rec.SQUAL_CHAR20 := p_dr_rec.SQUAL_CHAR20;
5399: l_dr_rec.SQUAL_CHAR21 := p_dr_rec.SQUAL_CHAR21;
5400:
5401:
5402: IF ( UPPER(p_resource_type) = 'RS_INDIVIDUAL') THEN
5403: l_p_resource_type := 'RS_INDIVIDUAL';
5404: ELSIF(p_resource_type is null) THEN
5405: l_p_resource_type := null;
5406: ELSE

Line 5403: l_p_resource_type := 'RS_INDIVIDUAL';

5399: l_dr_rec.SQUAL_CHAR21 := p_dr_rec.SQUAL_CHAR21;
5400:
5401:
5402: IF ( UPPER(p_resource_type) = 'RS_INDIVIDUAL') THEN
5403: l_p_resource_type := 'RS_INDIVIDUAL';
5404: ELSIF(p_resource_type is null) THEN
5405: l_p_resource_type := null;
5406: ELSE
5407: l_p_resource_type := p_resource_type;

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

5709: IF l_assign_resources_tbl.COUNT <= 0
5710: THEN
5711: IF (p_territory_flag = 'Y') THEN
5712:
5713: IF (l_p_resource_type = 'RS_INDIVIDUAL') THEN
5714: l_p_resource_type := NULL;
5715: END IF;
5716:
5717: -- change the API Name temporarily so that in case of unexpected error

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

5904:
5905: END IF; -- End of l_assign_resources_tbl.COUNT <= 0
5906:
5907:
5908: -- Start of enhancement for showing Individual Resources ONLY
5909:
5910: IF ( UPPER(p_resource_type) = 'RS_INDIVIDUAL' ) THEN
5911:
5912: -- Reconstructing the table to further do the enhancements

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

5906:
5907:
5908: -- Start of enhancement for showing Individual Resources ONLY
5909:
5910: IF ( UPPER(p_resource_type) = 'RS_INDIVIDUAL' ) THEN
5911:
5912: -- Reconstructing the table to further do the enhancements
5913:
5914: IF ( l_assign_resources_tbl.COUNT > 0 ) THEN

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

6014: END LOOP;
6015:
6016: END IF; --End of l_tbl.COUNT > 0
6017:
6018: END IF; --End of p_resource_type = 'RS_INDIVIDUAL'
6019:
6020:
6021: -- To add SUPPORT SITE ID and NAME to the OUT Table
6022:

Line 6324: FROM dual;

6320: -- To Plugin the Workflow enabling the user
6321: -- to further filter the resources
6322:
6323: SELECT jtf_calendars_s.NEXTVAL INTO l_workflow_key
6324: FROM dual;
6325:
6326: IF (JTF_USR_HKS.ok_to_execute
6327: (
6328: 'JTF_ASSIGN_PUB',

Line 7018: FROM dual;

7014: --l_workflow_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_WORKFLOW_NAME' ); -- Commented out by SBARAT on 12/10/2004, Bug-3830061
7015: l_workflow_profile := FND_PROFILE.VALUE ( 'ACTIVATE_WORKFLOW_NAME' ); -- Added by SBARAT on 12/10/2004, Bug-3830061
7016:
7017: SELECT jtf_calendars_s.NEXTVAL INTO l_workflow_key
7018: FROM dual;
7019:
7020: IF (JTF_USR_HKS.ok_to_execute
7021: (
7022: 'JTF_ASSIGN_PUB',

Line 7606: FROM dual;

7602: --l_workflow_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_WORKFLOW_NAME' ); -- Commented out by SBARAT on 12/10/2004, Bug-3830061
7603: l_workflow_profile := FND_PROFILE.VALUE ( 'ACTIVATE_WORKFLOW_NAME' ); -- Added by SBARAT on 12/10/2004, Bug-3830061
7604:
7605: SELECT jtf_calendars_s.NEXTVAL INTO l_workflow_key
7606: FROM dual;
7607:
7608: IF (JTF_USR_HKS.ok_to_execute
7609: (
7610: 'JTF_ASSIGN_PUB',

Line 8218: FROM dual;

8214: --l_workflow_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_WORKFLOW_NAME' ); -- Commented out by SBARAT on 12/10/2004, Bug-3830061
8215: l_workflow_profile := FND_PROFILE.VALUE ( 'ACTIVATE_WORKFLOW_NAME' ); -- Added by SBARAT on 12/10/2004, Bug-3830061
8216:
8217: SELECT jtf_calendars_s.NEXTVAL INTO l_workflow_key
8218: FROM dual;
8219:
8220: IF (JTF_USR_HKS.ok_to_execute
8221: (
8222: 'JTF_ASSIGN_PUB',

Line 8866: FROM dual;

8862: --l_workflow_profile := FND_PROFILE.VALUE_SPECIFIC ( 'ACTIVATE_WORKFLOW_NAME' ); -- Commented out by SBARAT on 12/10/2004, Bug-3830061
8863: l_workflow_profile := FND_PROFILE.VALUE ( 'ACTIVATE_WORKFLOW_NAME' ); -- Added by SBARAT on 12/10/2004, Bug-3830061
8864:
8865: SELECT jtf_calendars_s.NEXTVAL INTO l_workflow_key
8866: FROM dual;
8867:
8868: IF (JTF_USR_HKS.ok_to_execute
8869: (
8870: 'JTF_ASSIGN_PUB',

Line 10388: FROM dual;

10384: l_workflow_profile := FND_PROFILE.VALUE ( 'ACTIVATE_WORKFLOW_NAME' ); -- Added by SBARAT on 12/10/2004, Bug-3830061
10385:
10386:
10387: SELECT jtf_calendars_s.NEXTVAL INTO l_workflow_key
10388: FROM dual;
10389:
10390: IF (JTF_USR_HKS.ok_to_execute
10391: (
10392: 'JTF_ASSIGN_PUB',

Line 11893: FROM dual;

11889: -- To Plugin the Workflow enabling the user
11890: -- to further filter the resources
11891:
11892: SELECT jtf_calendars_s.NEXTVAL INTO l_workflow_key
11893: FROM dual;
11894:
11895: IF (JTF_USR_HKS.ok_to_execute
11896: (
11897: 'JTF_ASSIGN_PUB',