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 1057: FROM AHL_RT_OPER_RESOURCES

1053: --MANESING::ER 9014609, added following cursor
1054: CURSOR get_aso_res_ids( c_object_id NUMBER, c_association_type_code VARCHAR2 )
1055: IS
1056: SELECT aso_resource_id
1057: FROM AHL_RT_OPER_RESOURCES
1058: WHERE association_type_code = c_association_type_code
1059: and object_id = c_object_id;
1060:
1061: l_rt_oper_resource_rec rt_oper_resource_rec_type;

Line 1209: from ahl_rt_oper_resources

1205: -- Bug # 7644260 (FP for ER # 6998882) -- start
1206: cursor get_min_sch_seq ( c_object_id NUMBER, c_association_type_code VARCHAR2 )
1207: is
1208: select min(schedule_seq)
1209: from ahl_rt_oper_resources
1210: where object_id = c_object_id
1211: and association_type_code = c_association_type_code
1212: and schedule_seq IS NOT NULL ;
1213: -- Bug # 7644260 (FP for ER # 6998882) -- end

Line 1496: INSERT INTO AHL_RT_OPER_RESOURCES

1492: IF ( p_x_rt_oper_resource_tbl(i).dml_operation = 'C' ) THEN
1493:
1494: BEGIN
1495: -- Insert the record
1496: INSERT INTO AHL_RT_OPER_RESOURCES
1497: (
1498: rt_oper_resource_ID,
1499: OBJECT_VERSION_NUMBER,
1500: LAST_UPDATE_DATE,

Line 1532: AHL_RT_OPER_RESOURCES_S.NEXTVAL,

1528: schedule_seq
1529: -- Bug # 7644260 (FP for ER # 6998882) -- end
1530: ) VALUES
1531: (
1532: AHL_RT_OPER_RESOURCES_S.NEXTVAL,
1533: 1,
1534: G_LAST_UPDATE_DATE,
1535: G_LAST_UPDATED_BY,
1536: G_CREATION_DATE,

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

1578: fnd_log.string
1579: (
1580: fnd_log.level_unexpected,
1581: 'ahl.plsql.'||G_PKG_NAME||'.'||G_API_NAME1,
1582: 'AHL_RT_OPER_RESOURCES insert error = ['||SQLERRM||']'
1583: );
1584: END IF;
1585: END IF;
1586: END;

Line 1592: UPDATE AHL_RT_OPER_RESOURCES SET

1588: ELSIF ( p_x_rt_oper_resource_tbl(i).dml_operation = 'U' ) THEN
1589:
1590: BEGIN
1591: -- Update the record
1592: UPDATE AHL_RT_OPER_RESOURCES SET
1593: object_version_number = object_version_number + 1,
1594: last_update_date = G_LAST_UPDATE_DATE,
1595: last_updated_by = G_LAST_UPDATED_BY,
1596: last_update_login = G_LAST_UPDATE_LOGIN,

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

1642: fnd_log.string
1643: (
1644: fnd_log.level_unexpected,
1645: 'ahl.plsql.'||G_PKG_NAME||'.'||G_API_NAME1,
1646: 'AHL_RT_OPER_RESOURCES update error = ['||SQLERRM||']'
1647: );
1648: END IF;
1649: END IF;
1650: END;

Line 1660: DELETE FROM AHL_RT_OPER_RESOURCES

1656: WHERE rt_oper_resource_id = p_x_rt_oper_resource_tbl(i).rt_oper_resource_id;
1657: --pdoki ER 7436910
1658:
1659: -- Delete the record
1660: DELETE FROM AHL_RT_OPER_RESOURCES
1661: WHERE rt_oper_resource_id = p_x_rt_oper_resource_tbl(i).rt_oper_resource_id
1662: AND object_version_number = p_x_rt_oper_resource_tbl(i).object_version_number;
1663:
1664: -- If the record does not exist, then, abort API.

Line 1707: UPDATE ahl_rt_oper_resources

1703: -- Bug # 7644260 (FP for ER # 6998882) -- start
1704: OPEN get_min_sch_seq( p_object_id, p_association_type_code );
1705: FETCH get_min_sch_seq INTO l_min_sch_seq ;
1706: IF get_min_sch_seq%FOUND THEN
1707: UPDATE ahl_rt_oper_resources
1708: SET schedule_seq = l_min_sch_seq
1709: WHERE object_id = p_object_id
1710: AND association_type_code = p_association_type_code
1711: AND schedule_seq IS NULL ;

Line 2004: FROM AHL_RT_OPER_RESOURCES_V

2000: autocharge_type_id,
2001: autocharge_type,
2002: standard_rate_flag,
2003: standard_rate
2004: FROM AHL_RT_OPER_RESOURCES_V
2005: WHERE rt_oper_resource_id = c_rt_oper_resource_id;
2006:
2007: BEGIN
2008:

Line 2121: FROM AHL_RT_OPER_RESOURCES RES, AHL_RESOURCES AR

2117: RES.ASSOCIATION_TYPE_CODE,
2118: AR.resource_type_id,
2119: RES.duration,
2120: AR.NAME
2121: FROM AHL_RT_OPER_RESOURCES RES, AHL_RESOURCES AR
2122: WHERE RES.aso_resource_id = AR.resource_id
2123: AND RES.RT_OPER_RESOURCE_ID = C_RT_OPER_RESOURCE_ID;
2124:
2125: cursor get_route_status (p_route_id in number)

Line 2400: UPDATE AHL_RT_OPER_RESOURCES SET

2396: RAISE FND_API.G_EXC_ERROR;
2397: END IF;
2398:
2399: -- Update the cost parameters
2400: UPDATE AHL_RT_OPER_RESOURCES SET
2401: object_version_number = object_version_number + 1,
2402: activity_id = p_x_rt_oper_cost_rec.activity_id,
2403: cost_basis_id = p_x_rt_oper_cost_rec.cost_basis_id,
2404: scheduled_type_id = p_x_rt_oper_cost_rec.scheduled_type_id,

Line 3001: FROM AHL_RT_OPER_RESOURCES_V

2997:
2998: CURSOR check_resource_type1( c_rt_oper_resource_id NUMBER)
2999: IS
3000: SELECT resource_type_id
3001: FROM AHL_RT_OPER_RESOURCES_V
3002: WHERE rt_oper_resource_id = c_rt_oper_resource_id;
3003:
3004: CURSOR check_resource_type2( c_aso_resource_id NUMBER)
3005: IS

Line 3068: from ahl_rt_oper_resources_v

3064:
3065: CURSOR get_primary_res_name (c_rt_oper_resource_id number)
3066: IS
3067: SELECT aso_resource_name
3068: from ahl_rt_oper_resources_v
3069: where rt_oper_resource_id = c_rt_oper_resource_id;
3070:
3071: CURSOR get_alt_res_name (c_rt_oper_resource_id number, c_aso_resource_name varchar2)
3072: IS

Line 3087: FROM ahl_rt_oper_resources

3083: WHERE DEPARTMENT_ID IS NOT NULL
3084: AND aso_resource_id in
3085: (
3086: SELECT ASO_RESOURCE_ID
3087: FROM ahl_rt_oper_resources
3088: WHERE object_id = c_object_id
3089: AND ASSOCIATION_TYPE_CODE = c_association_type_code
3090: AND ASO_RESOURCE_ID <> c_aso_res_id
3091: )

Line 3099: FROM AHL_RT_OPER_RESOURCES

3095:
3096: CURSOR get_rt_oper_res_det (c_rt_oper_resource_id number)
3097: IS
3098: SELECT OBJECT_ID,ASSOCIATION_TYPE_CODE, ASO_RESOURCE_ID
3099: FROM AHL_RT_OPER_RESOURCES
3100: WHERE RT_OPER_RESOURCE_ID= c_rt_oper_resource_id;
3101:
3102: CURSOR get_aso_res_ids(c_rt_oper_resource_id number)
3103: IS