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_ALTERNATE_RESOURCES

Line 685: FROM ahl_alternate_resources

681: l_dummy VARCHAR2(1);
682:
683: CURSOR check_alternate_resource (c_rt_oper_resource_id number, c_aso_resource_id number) IS
684: SELECT 'X'
685: FROM ahl_alternate_resources
686: WHERE rt_oper_resource_id = c_rt_oper_resource_id
687: AND aso_resource_id = c_aso_resource_id;
688:
689: -- Cursor added for the bug 3354746(Resource type is not editable when alternate resources are defined)

Line 701: SELECT alternate_resource_id FROM AHL_ALTERNATE_RESOURCES

697: l_old_rt_oper_resource_rec rt_oper_resource_rec_type;
698:
699: CURSOR alternate_resource_csr( c_rt_oper_resource_id NUMBER)
700: IS
701: SELECT alternate_resource_id FROM AHL_ALTERNATE_RESOURCES
702: WHERE rt_oper_resource_id = c_rt_oper_resource_id;
703: l_alternate_resource_id NUMBER;
704:
705: BEGIN

Line 1027: FROM ahl_alternate_resources ALTR,

1023: FROM ahl_resource_mappings
1024: WHERE DEPARTMENT_ID IS NOT NULL
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

Line 1613: DELETE FROM ahl_alternate_resources

1609:
1610: ELSIF ( p_x_rt_oper_resource_tbl(i).dml_operation = 'D' ) THEN
1611: --pdoki ER 7436910
1612: --Deleting alternate_resource mappings for deleted resource.
1613: DELETE FROM ahl_alternate_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

Line 2723: FROM AHL_ALTERNATE_RESOURCES

2719: attribute12,
2720: attribute13,
2721: attribute14,
2722: attribute15
2723: FROM AHL_ALTERNATE_RESOURCES
2724: WHERE alternate_resource_id = c_alt_resource_id;
2725:
2726: BEGIN
2727:

Line 3005: FROM AHL_ALTERNATE_RESOURCES_V

3001:
3002: CURSOR get_dup_rec1 (c_rt_oper_resource_id number)
3003: IS
3004: SELECT name
3005: FROM AHL_ALTERNATE_RESOURCES_V
3006: WHERE rt_oper_resource_id = c_rt_oper_resource_id
3007: GROUP BY NAME
3008: HAVING count(*) > 1;
3009:

Line 3016: FROM AHL_ALTERNATE_RESOURCES

3012:
3013: CURSOR get_dup_rec2 (c_rt_oper_resource_id number)
3014: IS
3015: SELECT priority
3016: FROM AHL_ALTERNATE_RESOURCES
3017: WHERE rt_oper_resource_id = c_rt_oper_resource_id
3018: GROUP BY priority
3019: HAVING count(*) > 1;
3020:

Line 3032: from AHL_alternate_resources_v

3028:
3029: CURSOR get_alt_res_name (c_rt_oper_resource_id number, c_aso_resource_name varchar2)
3030: IS
3031: select name
3032: from AHL_alternate_resources_v
3033: where rt_oper_resource_id = c_rt_oper_resource_id
3034: and name = c_aso_resource_name;
3035:
3036: --pdoki ER 7436910 Begin.

Line 3063: FROM AHL_ALTERNATE_RESOURCES

3059:
3060: CURSOR get_aso_res_ids(c_rt_oper_resource_id number)
3061: IS
3062: SELECT ASO_RESOURCE_ID
3063: FROM AHL_ALTERNATE_RESOURCES
3064: WHERE RT_OPER_RESOURCE_ID= c_rt_oper_resource_id;
3065:
3066: l_dummy VARCHAR2(1);
3067: l_object_id NUMBER;

Line 3352: INSERT INTO AHL_ALTERNATE_RESOURCES

3348: IF ( p_x_alt_resource_tbl(i).dml_operation = 'C' ) THEN
3349:
3350: BEGIN
3351: -- Insert the record
3352: INSERT INTO AHL_ALTERNATE_RESOURCES
3353: (
3354: ALTERNATE_RESOURCE_ID,
3355: OBJECT_VERSION_NUMBER,
3356: LAST_UPDATE_DATE,

Line 3382: AHL_ALTERNATE_RESOURCES_S.NEXTVAL,

3378: ATTRIBUTE14,
3379: ATTRIBUTE15
3380: ) VALUES
3381: (
3382: AHL_ALTERNATE_RESOURCES_S.NEXTVAL,
3383: 1,
3384: G_LAST_UPDATE_DATE,
3385: G_LAST_UPDATED_BY,
3386: G_CREATION_DATE,

Line 3426: 'AHL_ALTERNATE_RESOURCES insert error = ['||SQLERRM||']'

3422: fnd_log.string
3423: (
3424: fnd_log.level_unexpected,
3425: 'ahl.plsql.'||G_PKG_NAME||'.'||G_API_NAME3,
3426: 'AHL_ALTERNATE_RESOURCES insert error = ['||SQLERRM||']'
3427: );
3428: END IF;
3429: END IF;
3430: END;

Line 3436: UPDATE AHL_ALTERNATE_RESOURCES SET

3432: ELSIF ( p_x_alt_resource_tbl(i).dml_operation = 'U' ) THEN
3433:
3434: BEGIN
3435: -- Update the record
3436: UPDATE AHL_ALTERNATE_RESOURCES SET
3437: object_version_number = object_version_number + 1,
3438: last_update_date = G_LAST_UPDATE_DATE,
3439: last_updated_by = G_LAST_UPDATED_BY,
3440: last_update_login = G_LAST_UPDATE_LOGIN,

Line 3484: 'AHL_ALTERNATE_RESOURCES update error = ['||SQLERRM||']'

3480: fnd_log.string
3481: (
3482: fnd_log.level_unexpected,
3483: 'ahl.plsql.'||G_PKG_NAME||'.'||G_API_NAME3,
3484: 'AHL_ALTERNATE_RESOURCES update error = ['||SQLERRM||']'
3485: );
3486: END IF;
3487: END IF;
3488: END;

Line 3493: DELETE FROM AHL_ALTERNATE_RESOURCES

3489:
3490: ELSIF ( p_x_alt_resource_tbl(i).dml_operation = 'D' ) THEN
3491:
3492: -- Delete the record
3493: DELETE FROM AHL_ALTERNATE_RESOURCES
3494: WHERE alternate_resource_id = p_x_alt_resource_tbl(i).alternate_resource_id
3495: AND object_version_number = p_x_alt_resource_tbl(i).object_version_number;
3496:
3497: -- If the record does not exist, then, abort API.