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_CTR_ASSOCIATIONS

Line 1855: l_obj_version_num AHL_RA_CTR_ASSOCIATIONS.OBJECT_VERSION_NUMBER%TYPE;

1851: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_MTBF_DATA';
1852: l_api_version CONSTANT NUMBER := 1.0;
1853: L_FULL_NAME CONSTANT VARCHAR2(60) := 'ahl.plsql.'||G_PKG_NAME || '.' || L_API_NAME;
1854:
1855: l_obj_version_num AHL_RA_CTR_ASSOCIATIONS.OBJECT_VERSION_NUMBER%TYPE;
1856: l_ra_def_hdr_rec AHL_RA_SETUPS_PVT.RA_DEFINITION_HDR_REC_TYPE DEFAULT p_x_reliability_data_rec;
1857: l_ra_def_dtl_rec AHL_RA_SETUPS_PVT.RA_DEFINITION_DTLS_REC_TYPE DEFAULT p_mtbf_data_rec;
1858: l_m_obj_version_num AHL_RA_DEFINITION_HDR.OBJECT_VERSION_NUMBER%TYPE;
1859:

Line 2073: -- Function : This API would create the setup data for Reliability Framework in AHL_RA_CTR_ASSOCIATIONS

2069: -- Start of Comments --
2070: --
2071: -- Procedure name : CREATE_COUNTER_ASSOC
2072: -- Type : Private
2073: -- Function : This API would create the setup data for Reliability Framework in AHL_RA_CTR_ASSOCIATIONS
2074: -- Pre-reqs :
2075: --
2076: -- Standard IN Parameters :
2077: -- p_api_version IN NUMBER Required

Line 2270: FROM AHL_RA_CTR_ASSOCIATIONS

2266: SELECT 'Y'
2267: INTO l_dummy
2268: FROM dual
2269: WHERE EXISTS(SELECT 'X'
2270: FROM AHL_RA_CTR_ASSOCIATIONS
2271: WHERE since_overhaul_counter_id = l_counter_assoc_rec.SINCE_NEW_COUNTER_ID);
2272:
2273: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2274: fnd_log.string(fnd_log.level_statement,l_full_name,'Validation Failure: This since new counter is already declared as overhaul - SINCE_NEW_COUNTER_ID -' || l_counter_assoc_rec.SINCE_NEW_COUNTER_ID);

Line 2296: FROM AHL_RA_CTR_ASSOCIATIONS

2292: SELECT 'Y'
2293: INTO l_dummy
2294: FROM dual
2295: WHERE EXISTS(SELECT 'X'
2296: FROM AHL_RA_CTR_ASSOCIATIONS
2297: WHERE since_new_counter_id = l_counter_assoc_rec.SINCE_OVERHAUL_COUNTER_ID);
2298:
2299: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2300: fnd_log.string(fnd_log.level_statement,l_full_name,'--Validation Failure: This since new counter is already declared as overhaul - SINCE_OVERHAUL_COUNTER_ID -' || l_counter_assoc_rec.SINCE_OVERHAUL_COUNTER_ID);

Line 2323: FROM AHL_RA_CTR_ASSOCIATIONS counters

2319: SELECT 'Y'
2320: INTO l_dummy
2321: FROM dual
2322: WHERE EXISTS(SELECT 'X'
2323: FROM AHL_RA_CTR_ASSOCIATIONS counters
2324: WHERE SINCE_NEW_COUNTER_ID = l_counter_assoc_rec.SINCE_NEW_COUNTER_ID
2325: AND nvl(SINCE_OVERHAUL_COUNTER_ID,-1) = nvl(l_counter_assoc_rec.SINCE_OVERHAUL_COUNTER_ID,-1));
2326:
2327: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

Line 2345: SELECT AHL_RA_CTR_ASSOCIATIONS_S.NEXTVAL into l_counter_assoc_rec.RA_COUNTER_ASSOCIATION_ID from dual;

2341: END IF;
2342: END;
2343:
2344: -- Initialize RA_COUNTER_ASSOCIATION_ID to sequence next val for insert
2345: SELECT AHL_RA_CTR_ASSOCIATIONS_S.NEXTVAL into l_counter_assoc_rec.RA_COUNTER_ASSOCIATION_ID from dual;
2346:
2347: -- Initialize object version number to 1
2348: l_counter_assoc_rec.OBJECT_VERSION_NUMBER := 1;
2349:

Line 2360: --Insert the record into AHL_RA_CTR_ASSOCIATIONS

2356:
2357: -- Initialize security group id
2358: l_counter_assoc_rec.SECURITY_GROUP_ID := null;
2359:
2360: --Insert the record into AHL_RA_CTR_ASSOCIATIONS
2361: INSERT INTO AHL_RA_CTR_ASSOCIATIONS
2362: (
2363: RA_COUNTER_ASSOCIATION_ID,
2364: SINCE_NEW_COUNTER_ID,

Line 2361: INSERT INTO AHL_RA_CTR_ASSOCIATIONS

2357: -- Initialize security group id
2358: l_counter_assoc_rec.SECURITY_GROUP_ID := null;
2359:
2360: --Insert the record into AHL_RA_CTR_ASSOCIATIONS
2361: INSERT INTO AHL_RA_CTR_ASSOCIATIONS
2362: (
2363: RA_COUNTER_ASSOCIATION_ID,
2364: SINCE_NEW_COUNTER_ID,
2365: SINCE_OVERHAUL_COUNTER_ID,

Line 2479: -- Function : This API would delete the setup data for Reliability Framework in AHL_RA_CTR_ASSOCIATIONS

2475: -- Start of Comments --
2476: --
2477: -- Procedure name : DELETE_COUNTER_ASSOC
2478: -- Type : Private
2479: -- Function : This API would delete the setup data for Reliability Framework in AHL_RA_CTR_ASSOCIATIONS
2480: -- Pre-reqs :
2481: --
2482: -- Standard IN Parameters :
2483: -- p_api_version IN NUMBER Required

Line 2515: l_obj_version_num AHL_RA_CTR_ASSOCIATIONS.OBJECT_VERSION_NUMBER%TYPE;

2511: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_COUNTER_ASSOC';
2512: l_api_version CONSTANT NUMBER := 1.0;
2513: L_FULL_NAME CONSTANT VARCHAR2(60) := 'ahl.plsql.'||G_PKG_NAME || '.' || L_API_NAME;
2514:
2515: l_obj_version_num AHL_RA_CTR_ASSOCIATIONS.OBJECT_VERSION_NUMBER%TYPE;
2516:
2517: BEGIN
2518:
2519: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

Line 2571: FROM AHL_RA_CTR_ASSOCIATIONS

2567: -- Check for existence of record and fetch OVN for change record validation
2568: BEGIN
2569: SELECT OBJECT_VERSION_NUMBER
2570: INTO l_obj_version_num
2571: FROM AHL_RA_CTR_ASSOCIATIONS
2572: WHERE RA_COUNTER_ASSOCIATION_ID = p_counter_assoc_rec.RA_COUNTER_ASSOCIATION_ID
2573: FOR UPDATE OF object_version_number NOWAIT;
2574:
2575: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

Line 2600: -- Delete Record from AHL_RA_CTR_ASSOCIATIONS

2596: FND_MSG_PUB.ADD;
2597: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2598: END IF;
2599:
2600: -- Delete Record from AHL_RA_CTR_ASSOCIATIONS
2601: DELETE AHL_RA_CTR_ASSOCIATIONS
2602: WHERE RA_COUNTER_ASSOCIATION_ID = p_counter_assoc_rec.RA_COUNTER_ASSOCIATION_ID;
2603:
2604: -- Standard check for p_commit

Line 2601: DELETE AHL_RA_CTR_ASSOCIATIONS

2597: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2598: END IF;
2599:
2600: -- Delete Record from AHL_RA_CTR_ASSOCIATIONS
2601: DELETE AHL_RA_CTR_ASSOCIATIONS
2602: WHERE RA_COUNTER_ASSOCIATION_ID = p_counter_assoc_rec.RA_COUNTER_ASSOCIATION_ID;
2603:
2604: -- Standard check for p_commit
2605: IF FND_API.To_Boolean (p_commit) THEN