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_RA_SETUPS_PVT dependencies on AHL_RA_DEFINITION_DTLS

Line 989: DELETE AHL_RA_DEFINITION_DTLS

985: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
986: END IF;
987:
988: --Delete the child records before deleting the master record.
989: DELETE AHL_RA_DEFINITION_DTLS
990: WHERE RA_DEFINITION_HDR_ID = p_reliability_data_rec.RA_DEFINITION_HDR_ID;
991:
992: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
993: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Child Records have been deleted --');

Line 1057: -- Function : This API would create the setup data for Reliability Framework in AHL_RA_DEFINITION_DTLS

1053: -- Start of Comments --
1054: --
1055: -- Procedure name : CREATE_MTBF_DATA
1056: -- Type : Private
1057: -- Function : This API would create the setup data for Reliability Framework in AHL_RA_DEFINITION_DTLS
1058: -- Pre-reqs :
1059: --
1060: -- Standard IN Parameters :
1061: -- p_api_version IN NUMBER Required

Line 1241: FROM AHL_RA_DEFINITION_DTLS

1237: SELECT 'Y'
1238: INTO l_dummy
1239: FROM dual
1240: WHERE EXISTS(SELECT 'X'
1241: FROM AHL_RA_DEFINITION_DTLS
1242: WHERE COUNTER_ID = l_ra_def_dtl_rec.COUNTER_ID
1243: AND RA_DEFINITION_HDR_ID = l_ra_def_dtl_rec.RA_DEFINITION_HDR_ID);
1244:
1245: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

Line 1297: SELECT AHL_RA_DEFINITION_DTLS_S.NEXTVAL into l_ra_def_dtl_rec.RA_DEFINITION_DTL_ID from dual;

1293: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1294: END IF;
1295:
1296: -- Initialize RA_DEFINITION_DTL_ID to sequence next val for insert
1297: SELECT AHL_RA_DEFINITION_DTLS_S.NEXTVAL into l_ra_def_dtl_rec.RA_DEFINITION_DTL_ID from dual;
1298:
1299: -- Initialize object version number to 1
1300: l_ra_def_dtl_rec.OBJECT_VERSION_NUMBER := 1;
1301:

Line 1312: --Insert the record into AHL_RA_DEFINITION_DTLS

1308:
1309: -- Initialize security group id
1310: l_ra_def_dtl_rec.SECURITY_GROUP_ID := null;
1311:
1312: --Insert the record into AHL_RA_DEFINITION_DTLS
1313: INSERT INTO AHL_RA_DEFINITION_DTLS
1314: (
1315: RA_DEFINITION_DTL_ID,
1316: RA_DEFINITION_HDR_ID,

Line 1313: INSERT INTO AHL_RA_DEFINITION_DTLS

1309: -- Initialize security group id
1310: l_ra_def_dtl_rec.SECURITY_GROUP_ID := null;
1311:
1312: --Insert the record into AHL_RA_DEFINITION_DTLS
1313: INSERT INTO AHL_RA_DEFINITION_DTLS
1314: (
1315: RA_DEFINITION_DTL_ID,
1316: RA_DEFINITION_HDR_ID,
1317: COUNTER_ID,

Line 1438: -- Function : This API would update the setup data for Reliability Framework in AHL_RA_DEFINITION_DTLS

1434: -- Start of Comments --
1435: --
1436: -- Procedure name : UPDATE_MTBF_DATA
1437: -- Type : Private
1438: -- Function : This API would update the setup data for Reliability Framework in AHL_RA_DEFINITION_DTLS
1439: -- Pre-reqs :
1440: --
1441: -- Standard IN Parameters :
1442: -- p_api_version IN NUMBER Required

Line 1477: FROM AHL_RA_DEFINITION_DTLS

1473: RA_DEFINITION_HDR_ID,
1474: COUNTER_ID,
1475: MTBF_VALUE,
1476: OBJECT_VERSION_NUMBER
1477: FROM AHL_RA_DEFINITION_DTLS
1478: WHERE RA_DEFINITION_DTL_ID = p_ra_definition_dtl_id
1479: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
1480:
1481: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_MTBF_DATA';

Line 1722: UPDATE AHL_RA_DEFINITION_DTLS

1718: l_ra_def_dtl_rec.LAST_UPDATE_DATE := sysdate;
1719: l_ra_def_dtl_rec.CREATED_BY := fnd_global.user_id;
1720: l_ra_def_dtl_rec.CREATION_DATE := sysdate;
1721:
1722: UPDATE AHL_RA_DEFINITION_DTLS
1723: SET
1724: RA_DEFINITION_HDR_ID = l_ra_def_dtl_rec.RA_DEFINITION_HDR_ID,
1725: COUNTER_ID = l_ra_def_dtl_rec.COUNTER_ID,
1726: MTBF_VALUE = l_ra_def_dtl_rec.MTBF_VALUE,

Line 1818: -- Function : This API would delete the setup data for Reliability Framework in AHL_RA_DEFINITION_DTLS

1814: -- Start of Comments --
1815: --
1816: -- Procedure name : DELETE_MTBF_DATA
1817: -- Type : Private
1818: -- Function : This API would delete the setup data for Reliability Framework in AHL_RA_DEFINITION_DTLS
1819: -- Pre-reqs :
1820: --
1821: -- Standard IN Parameters :
1822: -- p_api_version IN NUMBER Required

Line 1942: FROM AHL_RA_DEFINITION_DTLS

1938: -- Check for existence of record and fetch OVN for change record validation
1939: BEGIN
1940: SELECT OBJECT_VERSION_NUMBER
1941: INTO l_obj_version_num
1942: FROM AHL_RA_DEFINITION_DTLS
1943: WHERE RA_DEFINITION_DTL_ID = l_ra_def_dtl_rec.RA_DEFINITION_DTL_ID
1944: FOR UPDATE OF object_version_number NOWAIT;
1945:
1946: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

Line 2006: -- Delete Record from AHL_RA_DEFINITION_DTLS

2002: FND_MSG_PUB.ADD;
2003: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2004: END IF;
2005:
2006: -- Delete Record from AHL_RA_DEFINITION_DTLS
2007: DELETE AHL_RA_DEFINITION_DTLS
2008: WHERE RA_DEFINITION_DTL_ID = l_ra_def_dtl_rec.RA_DEFINITION_DTL_ID;
2009:
2010: l_ra_def_hdr_rec.OBJECT_VERSION_NUMBER := l_ra_def_hdr_rec.OBJECT_VERSION_NUMBER + 1;

Line 2007: DELETE AHL_RA_DEFINITION_DTLS

2003: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2004: END IF;
2005:
2006: -- Delete Record from AHL_RA_DEFINITION_DTLS
2007: DELETE AHL_RA_DEFINITION_DTLS
2008: WHERE RA_DEFINITION_DTL_ID = l_ra_def_dtl_rec.RA_DEFINITION_DTL_ID;
2009:
2010: l_ra_def_hdr_rec.OBJECT_VERSION_NUMBER := l_ra_def_hdr_rec.OBJECT_VERSION_NUMBER + 1;
2011: