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.

[Home] [Help]

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 1655: DELETE FROM ahl_alternate_resources

1651:
1652: ELSIF ( p_x_rt_oper_resource_tbl(i).dml_operation = 'D' ) THEN
1653: --pdoki ER 7436910
1654: --Deleting alternate_resource mappings for deleted resource.
1655: DELETE FROM ahl_alternate_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

Line 2765: FROM AHL_ALTERNATE_RESOURCES

2761: attribute12,
2762: attribute13,
2763: attribute14,
2764: attribute15
2765: FROM AHL_ALTERNATE_RESOURCES
2766: WHERE alternate_resource_id = c_alt_resource_id;
2767:
2768: BEGIN
2769:

Line 3047: FROM AHL_ALTERNATE_RESOURCES_V

3043:
3044: CURSOR get_dup_rec1 (c_rt_oper_resource_id number)
3045: IS
3046: SELECT name
3047: FROM AHL_ALTERNATE_RESOURCES_V
3048: WHERE rt_oper_resource_id = c_rt_oper_resource_id
3049: GROUP BY NAME
3050: HAVING count(*) > 1;
3051:

Line 3058: FROM AHL_ALTERNATE_RESOURCES

3054:
3055: CURSOR get_dup_rec2 (c_rt_oper_resource_id number)
3056: IS
3057: SELECT priority
3058: FROM AHL_ALTERNATE_RESOURCES
3059: WHERE rt_oper_resource_id = c_rt_oper_resource_id
3060: GROUP BY priority
3061: HAVING count(*) > 1;
3062:

Line 3074: from AHL_alternate_resources_v

3070:
3071: CURSOR get_alt_res_name (c_rt_oper_resource_id number, c_aso_resource_name varchar2)
3072: IS
3073: select name
3074: from AHL_alternate_resources_v
3075: where rt_oper_resource_id = c_rt_oper_resource_id
3076: and name = c_aso_resource_name;
3077:
3078: --pdoki ER 7436910 Begin.

Line 3105: FROM AHL_ALTERNATE_RESOURCES

3101:
3102: CURSOR get_aso_res_ids(c_rt_oper_resource_id number)
3103: IS
3104: SELECT ASO_RESOURCE_ID
3105: FROM AHL_ALTERNATE_RESOURCES
3106: WHERE RT_OPER_RESOURCE_ID= c_rt_oper_resource_id;
3107:
3108: l_dummy VARCHAR2(1);
3109: l_object_id NUMBER;

Line 3406: INSERT INTO AHL_ALTERNATE_RESOURCES

3402: IF ( p_x_alt_resource_tbl(i).dml_operation = 'C' ) THEN
3403:
3404: BEGIN
3405: -- Insert the record
3406: INSERT INTO AHL_ALTERNATE_RESOURCES
3407: (
3408: ALTERNATE_RESOURCE_ID,
3409: OBJECT_VERSION_NUMBER,
3410: LAST_UPDATE_DATE,

Line 3436: AHL_ALTERNATE_RESOURCES_S.NEXTVAL,

3432: ATTRIBUTE14,
3433: ATTRIBUTE15
3434: ) VALUES
3435: (
3436: AHL_ALTERNATE_RESOURCES_S.NEXTVAL,
3437: 1,
3438: G_LAST_UPDATE_DATE,
3439: G_LAST_UPDATED_BY,
3440: G_CREATION_DATE,

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

3477: fnd_log.string
3478: (
3479: fnd_log.level_unexpected,
3480: 'ahl.plsql.'||G_PKG_NAME||'.'||G_API_NAME3,
3481: 'AHL_ALTERNATE_RESOURCES insert error = ['||SQLERRM||']'
3482: );
3483: END IF;
3484: END IF;
3485: END;

Line 3491: UPDATE AHL_ALTERNATE_RESOURCES SET

3487: ELSIF ( p_x_alt_resource_tbl(i).dml_operation = 'U' ) THEN
3488:
3489: BEGIN
3490: -- Update the record
3491: UPDATE AHL_ALTERNATE_RESOURCES SET
3492: object_version_number = object_version_number + 1,
3493: last_update_date = G_LAST_UPDATE_DATE,
3494: last_updated_by = G_LAST_UPDATED_BY,
3495: last_update_login = G_LAST_UPDATE_LOGIN,

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

3535: fnd_log.string
3536: (
3537: fnd_log.level_unexpected,
3538: 'ahl.plsql.'||G_PKG_NAME||'.'||G_API_NAME3,
3539: 'AHL_ALTERNATE_RESOURCES update error = ['||SQLERRM||']'
3540: );
3541: END IF;
3542: END IF;
3543: END;

Line 3548: DELETE FROM AHL_ALTERNATE_RESOURCES

3544:
3545: ELSIF ( p_x_alt_resource_tbl(i).dml_operation = 'D' ) THEN
3546:
3547: -- Delete the record
3548: DELETE FROM AHL_ALTERNATE_RESOURCES
3549: WHERE alternate_resource_id = p_x_alt_resource_tbl(i).alternate_resource_id
3550: AND object_version_number = p_x_alt_resource_tbl(i).object_version_number;
3551:
3552: -- If the record does not exist, then, abort API.