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.AHL_RM_RT_OPER_RESOURCE_PVT dependencies on AHL_RT_OPER_RESOURCES

Line 452: FROM AHL_RT_OPER_RESOURCES

448: scheduled_type_id, -- added for bug fix 6512803.
449: -- Bug # 7644260 (FP for ER # 6998882) -- start
450: schedule_seq
451: -- Bug # 7644260 (FP for ER # 6998882) -- end
452: FROM AHL_RT_OPER_RESOURCES
453: WHERE rt_oper_resource_id = c_rt_oper_resource_id;
454:
455: -- Added for bug# 6512803.
456: CURSOR get_res_type_id( c_resource_id In NUMBER)

Line 467: -- Get the old record from AHL_RT_OPER_RESOURCES.

463:
464:
465: BEGIN
466:
467: -- Get the old record from AHL_RT_OPER_RESOURCES.
468: OPEN get_old_rec( p_x_rt_oper_resource_rec.rt_oper_resource_id );
469:
470: FETCH get_old_rec INTO
471: l_old_rt_oper_resource_rec.aso_resource_id,

Line 695: FROM AHL_RT_OPER_RESOURCES_V

691: IS
692: SELECT resource_type_id,
693: resource_type,
694: aso_resource_name
695: FROM AHL_RT_OPER_RESOURCES_V
696: WHERE rt_oper_resource_id = c_rt_oper_resource_id;
697: l_old_rt_oper_resource_rec rt_oper_resource_rec_type;
698:
699: CURSOR alternate_resource_csr( c_rt_oper_resource_id NUMBER)

Line 847: -- Get the old record from AHL_RT_OPER_RESOURCES.

843: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_rt_oper_resource_rec ) );
844: FND_MSG_PUB.add;
845: END IF;
846:
847: -- Get the old record from AHL_RT_OPER_RESOURCES.
848: OPEN get_old_rec( p_rt_oper_resource_rec.rt_oper_resource_id );
849:
850: FETCH get_old_rec INTO
851: l_old_rt_oper_resource_rec.resource_type_id,

Line 994: FROM AHL_RT_OPER_RESOURCES_V

990: SELECT resource_type_id,
991: resource_type,
992: aso_resource_id,
993: aso_resource_name
994: FROM AHL_RT_OPER_RESOURCES_V
995: WHERE object_id = c_object_id
996: AND association_type_code = c_association_type_code
997: GROUP BY resource_type_id,
998: resource_type,

Line 1012: FROM ahl_rt_oper_resources

1008: FROM ahl_resource_mappings
1009: WHERE DEPARTMENT_ID IS NOT NULL
1010: AND aso_resource_id in
1011: (SELECT ASO_RESOURCE_ID
1012: FROM ahl_rt_oper_resources
1013: WHERE object_id = c_object_id
1014: AND ASSOCIATION_TYPE_CODE = c_association_type_code
1015: )
1016: GROUP BY bom_org_id

Line 1029: FROM ahl_rt_oper_resources

1025: AND aso_resource_id in
1026: (SELECT ALTR.ASO_RESOURCE_ID
1027: FROM ahl_alternate_resources ALTR,
1028: (SELECT RT_OPER_RESOURCE_ID
1029: FROM ahl_rt_oper_resources
1030: WHERE RT_OPER_RESOURCE_ID <> c_rt_oper_res_id
1031: AND ASSOCIATION_TYPE_CODE = c_association_type_code
1032: AND OBJECT_ID = c_object_id
1033: )

Line 1039: FROM ahl_rt_oper_resources

1035: WHERE ROR.RT_OPER_RESOURCE_ID = ALTR.rt_oper_resource_id
1036: )
1037: OR aso_resource_id =
1038: (SELECT aso_resource_id
1039: FROM ahl_rt_oper_resources
1040: WHERE RT_OPER_RESOURCE_ID = c_rt_oper_res_id
1041: )
1042: GROUP BY bom_org_id
1043: HAVING count(DISTINCT DEPARTMENT_ID) > 1;

Line 1048: FROM AHL_RT_OPER_RESOURCES

1044:
1045: CURSOR get_rt_oper_res_ids ( c_object_id NUMBER, c_association_type_code VARCHAR2)
1046: IS
1047: SELECT RT_OPER_RESOURCE_ID
1048: FROM AHL_RT_OPER_RESOURCES
1049: WHERE ASSOCIATION_TYPE_CODE = c_association_type_code
1050: AND OBJECT_ID = c_object_id;
1051: --pdoki ER 7436910 End.
1052:

Line 1167: from ahl_rt_oper_resources

1163: -- Bug # 7644260 (FP for ER # 6998882) -- start
1164: cursor get_min_sch_seq ( c_object_id NUMBER, c_association_type_code VARCHAR2 )
1165: is
1166: select min(schedule_seq)
1167: from ahl_rt_oper_resources
1168: where object_id = c_object_id
1169: and association_type_code = c_association_type_code
1170: and schedule_seq IS NOT NULL ;
1171: -- Bug # 7644260 (FP for ER # 6998882) -- end

Line 1455: INSERT INTO AHL_RT_OPER_RESOURCES

1451: IF ( p_x_rt_oper_resource_tbl(i).dml_operation = 'C' ) THEN
1452:
1453: BEGIN
1454: -- Insert the record
1455: INSERT INTO AHL_RT_OPER_RESOURCES
1456: (
1457: rt_oper_resource_ID,
1458: OBJECT_VERSION_NUMBER,
1459: LAST_UPDATE_DATE,

Line 1491: AHL_RT_OPER_RESOURCES_S.NEXTVAL,

1487: schedule_seq
1488: -- Bug # 7644260 (FP for ER # 6998882) -- end
1489: ) VALUES
1490: (
1491: AHL_RT_OPER_RESOURCES_S.NEXTVAL,
1492: 1,
1493: G_LAST_UPDATE_DATE,
1494: G_LAST_UPDATED_BY,
1495: G_CREATION_DATE,

Line 1540: 'AHL_RT_OPER_RESOURCES insert error = ['||SQLERRM||']'

1536: fnd_log.string
1537: (
1538: fnd_log.level_unexpected,
1539: 'ahl.plsql.'||G_PKG_NAME||'.'||G_API_NAME1,
1540: 'AHL_RT_OPER_RESOURCES insert error = ['||SQLERRM||']'
1541: );
1542: END IF;
1543: END IF;
1544: END;

Line 1550: UPDATE AHL_RT_OPER_RESOURCES SET

1546: ELSIF ( p_x_rt_oper_resource_tbl(i).dml_operation = 'U' ) THEN
1547:
1548: BEGIN
1549: -- Update the record
1550: UPDATE AHL_RT_OPER_RESOURCES SET
1551: object_version_number = object_version_number + 1,
1552: last_update_date = G_LAST_UPDATE_DATE,
1553: last_updated_by = G_LAST_UPDATED_BY,
1554: last_update_login = G_LAST_UPDATE_LOGIN,

Line 1604: 'AHL_RT_OPER_RESOURCES update error = ['||SQLERRM||']'

1600: fnd_log.string
1601: (
1602: fnd_log.level_unexpected,
1603: 'ahl.plsql.'||G_PKG_NAME||'.'||G_API_NAME1,
1604: 'AHL_RT_OPER_RESOURCES update error = ['||SQLERRM||']'
1605: );
1606: END IF;
1607: END IF;
1608: END;

Line 1618: DELETE FROM AHL_RT_OPER_RESOURCES

1614: WHERE rt_oper_resource_id = p_x_rt_oper_resource_tbl(i).rt_oper_resource_id;
1615: --pdoki ER 7436910
1616:
1617: -- Delete the record
1618: DELETE FROM AHL_RT_OPER_RESOURCES
1619: WHERE rt_oper_resource_id = p_x_rt_oper_resource_tbl(i).rt_oper_resource_id
1620: AND object_version_number = p_x_rt_oper_resource_tbl(i).object_version_number;
1621:
1622: -- If the record does not exist, then, abort API.

Line 1665: UPDATE ahl_rt_oper_resources

1661: -- Bug # 7644260 (FP for ER # 6998882) -- start
1662: OPEN get_min_sch_seq( p_object_id, p_association_type_code );
1663: FETCH get_min_sch_seq INTO l_min_sch_seq ;
1664: IF get_min_sch_seq%FOUND THEN
1665: UPDATE ahl_rt_oper_resources
1666: SET schedule_seq = l_min_sch_seq
1667: WHERE object_id = p_object_id
1668: AND association_type_code = p_association_type_code
1669: AND schedule_seq IS NULL ;

Line 1962: FROM AHL_RT_OPER_RESOURCES_V

1958: autocharge_type_id,
1959: autocharge_type,
1960: standard_rate_flag,
1961: standard_rate
1962: FROM AHL_RT_OPER_RESOURCES_V
1963: WHERE rt_oper_resource_id = c_rt_oper_resource_id;
1964:
1965: BEGIN
1966:

Line 2079: FROM AHL_RT_OPER_RESOURCES RES, AHL_RESOURCES AR

2075: RES.ASSOCIATION_TYPE_CODE,
2076: AR.resource_type_id,
2077: RES.duration,
2078: AR.NAME
2079: FROM AHL_RT_OPER_RESOURCES RES, AHL_RESOURCES AR
2080: WHERE RES.aso_resource_id = AR.resource_id
2081: AND RES.RT_OPER_RESOURCE_ID = C_RT_OPER_RESOURCE_ID;
2082:
2083: cursor get_route_status (p_route_id in number)

Line 2358: UPDATE AHL_RT_OPER_RESOURCES SET

2354: RAISE FND_API.G_EXC_ERROR;
2355: END IF;
2356:
2357: -- Update the cost parameters
2358: UPDATE AHL_RT_OPER_RESOURCES SET
2359: object_version_number = object_version_number + 1,
2360: activity_id = p_x_rt_oper_cost_rec.activity_id,
2361: cost_basis_id = p_x_rt_oper_cost_rec.cost_basis_id,
2362: scheduled_type_id = p_x_rt_oper_cost_rec.scheduled_type_id,

Line 2959: FROM AHL_RT_OPER_RESOURCES_V

2955:
2956: CURSOR check_resource_type1( c_rt_oper_resource_id NUMBER)
2957: IS
2958: SELECT resource_type_id
2959: FROM AHL_RT_OPER_RESOURCES_V
2960: WHERE rt_oper_resource_id = c_rt_oper_resource_id;
2961:
2962: CURSOR check_resource_type2( c_aso_resource_id NUMBER)
2963: IS

Line 3026: from ahl_rt_oper_resources_v

3022:
3023: CURSOR get_primary_res_name (c_rt_oper_resource_id number)
3024: IS
3025: SELECT aso_resource_name
3026: from ahl_rt_oper_resources_v
3027: where rt_oper_resource_id = c_rt_oper_resource_id;
3028:
3029: CURSOR get_alt_res_name (c_rt_oper_resource_id number, c_aso_resource_name varchar2)
3030: IS

Line 3045: FROM ahl_rt_oper_resources

3041: WHERE DEPARTMENT_ID IS NOT NULL
3042: AND aso_resource_id in
3043: (
3044: SELECT ASO_RESOURCE_ID
3045: FROM ahl_rt_oper_resources
3046: WHERE object_id = c_object_id
3047: AND ASSOCIATION_TYPE_CODE = c_association_type_code
3048: AND ASO_RESOURCE_ID <> c_aso_res_id
3049: )

Line 3057: FROM AHL_RT_OPER_RESOURCES

3053:
3054: CURSOR get_rt_oper_res_det (c_rt_oper_resource_id number)
3055: IS
3056: SELECT OBJECT_ID,ASSOCIATION_TYPE_CODE, ASO_RESOURCE_ID
3057: FROM AHL_RT_OPER_RESOURCES
3058: WHERE RT_OPER_RESOURCE_ID= c_rt_oper_resource_id;
3059:
3060: CURSOR get_aso_res_ids(c_rt_oper_resource_id number)
3061: IS