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_HDR

Line 512: -- Function : This API would create the setup data for Reliability Framework in AHL_RA_DEFINITION_HDR

508: -- Start of Comments --
509: --
510: -- Procedure name : CREATE_RELIABILITY_DATA
511: -- Type : Private
512: -- Function : This API would create the setup data for Reliability Framework in AHL_RA_DEFINITION_HDR
513: -- Pre-reqs :
514: --
515: -- Standard IN Parameters :
516: -- p_api_version IN NUMBER Required

Line 705: FROM ahl_ra_definition_hdr

701: SELECT 'Y'
702: INTO l_dummy
703: FROM dual
704: WHERE EXISTS(SELECT 'X'
705: FROM ahl_ra_definition_hdr
706: WHERE mc_header_id = l_ra_def_hdr_rec.MC_HEADER_ID
707: AND relationship_id = l_ra_def_hdr_rec.RELATIONSHIP_ID
708: AND inventory_item_id = l_ra_def_hdr_rec.INVENTORY_ITEM_ID
709: AND inventory_org_id = l_ra_def_hdr_rec.INVENTORY_ORG_ID

Line 728: SELECT AHL_RA_DEFINITION_HDR_S.NEXTVAL into l_ra_def_hdr_rec.RA_DEFINITION_HDR_ID from dual;

724: END IF;
725: END;
726:
727: -- Initialize RA_DEFINITION_HDR_ID to sequence next val for insert
728: SELECT AHL_RA_DEFINITION_HDR_S.NEXTVAL into l_ra_def_hdr_rec.RA_DEFINITION_HDR_ID from dual;
729:
730: -- Initialize object version number to 1
731: l_ra_def_hdr_rec.OBJECT_VERSION_NUMBER := 1;
732:

Line 743: INSERT INTO AHL_RA_DEFINITION_HDR

739:
740: -- Initialize security group id
741: l_ra_def_hdr_rec.SECURITY_GROUP_ID := null;
742:
743: INSERT INTO AHL_RA_DEFINITION_HDR
744: (
745: RA_DEFINITION_HDR_ID,
746: MC_HEADER_ID,
747: INVENTORY_ITEM_ID,

Line 861: -- Function : This API would delete the setup data for Reliability Framework in AHL_RA_DEFINITION_HDR

857: -- Start of Comments --
858: --
859: -- Procedure name : DELETE_RELIABILITY_DATA
860: -- Type : Private
861: -- Function : This API would delete the setup data for Reliability Framework in AHL_RA_DEFINITION_HDR
862: -- Pre-reqs :
863: --
864: -- Standard IN Parameters :
865: -- p_api_version IN NUMBER Required

Line 897: l_obj_version_num AHL_RA_DEFINITION_HDR.OBJECT_VERSION_NUMBER%TYPE;

893: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_RELIABILITY_DATA';
894: l_api_version CONSTANT NUMBER := 1.0;
895: L_FULL_NAME CONSTANT VARCHAR2(60) := 'ahl.plsql.'||G_PKG_NAME || '.' || L_API_NAME;
896:
897: l_obj_version_num AHL_RA_DEFINITION_HDR.OBJECT_VERSION_NUMBER%TYPE;
898:
899: BEGIN
900:
901: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

Line 957: FROM AHL_RA_DEFINITION_HDR

953: -- Check for existence of record and fetch OVN for change record validation
954: BEGIN
955: SELECT OBJECT_VERSION_NUMBER
956: INTO l_obj_version_num
957: FROM AHL_RA_DEFINITION_HDR
958: WHERE RA_DEFINITION_HDR_ID = p_reliability_data_rec.RA_DEFINITION_HDR_ID
959: FOR UPDATE OF object_version_number NOWAIT;
960:
961: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

Line 997: DELETE AHL_RA_DEFINITION_HDR

993: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Child Records have been deleted --');
994: END IF;
995:
996: --Delete the master record.
997: DELETE AHL_RA_DEFINITION_HDR
998: WHERE RA_DEFINITION_HDR_ID = p_reliability_data_rec.RA_DEFINITION_HDR_ID;
999:
1000: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1001: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Master Record has been deleted --');

Line 1096: l_m_obj_version_num AHL_RA_DEFINITION_HDR.OBJECT_VERSION_NUMBER%TYPE;

1092: L_FULL_NAME CONSTANT VARCHAR2(60) := 'ahl.plsql.'||G_PKG_NAME || '.' || L_API_NAME;
1093:
1094: l_ra_def_hdr_rec AHL_RA_SETUPS_PVT.RA_DEFINITION_HDR_REC_TYPE DEFAULT p_x_reliability_data_rec;
1095: l_ra_def_dtl_rec AHL_RA_SETUPS_PVT.RA_DEFINITION_DTLS_REC_TYPE DEFAULT p_x_mtbf_data_rec;
1096: l_m_obj_version_num AHL_RA_DEFINITION_HDR.OBJECT_VERSION_NUMBER%TYPE;
1097: l_cou_name CSI_COUNTER_TEMPLATE_VL.NAME%TYPE;
1098: l_dummy VARCHAR2(1);
1099:
1100: BEGIN

Line 1192: ahl_ra_definition_hdr rdh

1188: INTO l_cou_name
1189: FROM cs_csi_counter_groups cg,
1190: csi_counter_template_vl templates,
1191: csi_ctr_item_associations csia,
1192: ahl_ra_definition_hdr rdh
1193: WHERE templates.counter_id = l_ra_def_dtl_rec.COUNTER_ID
1194: AND cg.template_flag = 'Y'
1195: AND templates.group_id = cg.counter_group_id
1196: AND csia.group_id = cg.counter_group_id

Line 1265: FROM AHL_RA_DEFINITION_HDR

1261: -- Check for existence of record and fetch OVN of Master Rec for change record validation and bump up
1262: BEGIN
1263: SELECT OBJECT_VERSION_NUMBER
1264: INTO l_m_obj_version_num
1265: FROM AHL_RA_DEFINITION_HDR
1266: WHERE RA_DEFINITION_HDR_ID = l_ra_def_dtl_rec.RA_DEFINITION_HDR_ID
1267: FOR UPDATE OF object_version_number NOWAIT;
1268:
1269: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

Line 1379: UPDATE AHL_RA_DEFINITION_HDR

1375:
1376: l_ra_def_hdr_rec.OBJECT_VERSION_NUMBER := l_ra_def_hdr_rec.OBJECT_VERSION_NUMBER + 1;
1377:
1378: -- Update Object Version Number of Master Record are Inserting child record.
1379: UPDATE AHL_RA_DEFINITION_HDR
1380: SET OBJECT_VERSION_NUMBER = l_ra_def_hdr_rec.OBJECT_VERSION_NUMBER
1381: WHERE RA_DEFINITION_HDR_ID = l_ra_def_dtl_rec.RA_DEFINITION_HDR_ID;
1382:
1383: p_x_reliability_data_rec := l_ra_def_hdr_rec;

Line 1487: l_m_obj_version_num AHL_RA_DEFINITION_HDR.OBJECT_VERSION_NUMBER%TYPE;

1483: L_FULL_NAME CONSTANT VARCHAR2(60) := 'ahl.plsql.'||G_PKG_NAME || '.' || L_API_NAME || ' : ';
1484: l_mtbf_data_old_rec get_mtbf_data_cur%ROWTYPE;
1485: l_ra_def_dtl_rec AHL_RA_SETUPS_PVT.RA_DEFINITION_DTLS_REC_TYPE DEFAULT p_x_mtbf_data_rec;
1486: l_ra_def_hdr_rec AHL_RA_SETUPS_PVT.RA_DEFINITION_HDR_REC_TYPE DEFAULT p_x_reliability_data_rec;
1487: l_m_obj_version_num AHL_RA_DEFINITION_HDR.OBJECT_VERSION_NUMBER%TYPE;
1488: l_cou_name CSI_COUNTER_TEMPLATE_VL.NAME%TYPE;
1489:
1490: BEGIN
1491:

Line 1637: ahl_ra_definition_hdr rdh

1633: INTO l_cou_name
1634: FROM cs_csi_counter_groups cg,
1635: csi_counter_template_vl templates,
1636: csi_ctr_item_associations csia,
1637: ahl_ra_definition_hdr rdh
1638: WHERE templates.counter_id = l_ra_def_dtl_rec.COUNTER_ID
1639: AND cg.template_flag = 'Y'
1640: AND templates.group_id = cg.counter_group_id
1641: AND csia.group_id = cg.counter_group_id

Line 1681: FROM AHL_RA_DEFINITION_HDR

1677: -- Check for existence of record and fetch OVN of Master Rec for change record validation and bump up
1678: BEGIN
1679: SELECT OBJECT_VERSION_NUMBER
1680: INTO l_m_obj_version_num
1681: FROM AHL_RA_DEFINITION_HDR
1682: WHERE RA_DEFINITION_HDR_ID = l_ra_def_dtl_rec.RA_DEFINITION_HDR_ID
1683: FOR UPDATE OF object_version_number NOWAIT;
1684:
1685: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

Line 1759: UPDATE AHL_RA_DEFINITION_HDR

1755:
1756: l_ra_def_hdr_rec.OBJECT_VERSION_NUMBER := l_ra_def_hdr_rec.OBJECT_VERSION_NUMBER + 1;
1757:
1758: -- Update Object Version Number of Master Record are Inserting child record.
1759: UPDATE AHL_RA_DEFINITION_HDR
1760: SET OBJECT_VERSION_NUMBER = l_ra_def_hdr_rec.OBJECT_VERSION_NUMBER
1761: WHERE RA_DEFINITION_HDR_ID = l_ra_def_dtl_rec.RA_DEFINITION_HDR_ID;
1762:
1763: p_x_reliability_data_rec := l_ra_def_hdr_rec;

Line 1858: l_m_obj_version_num AHL_RA_DEFINITION_HDR.OBJECT_VERSION_NUMBER%TYPE;

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:
1860: BEGIN
1861:
1862: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

Line 1975: FROM AHL_RA_DEFINITION_HDR

1971: -- Check for existence of record and fetch OVN of Master Rec for change record validation and bump up
1972: BEGIN
1973: SELECT OBJECT_VERSION_NUMBER
1974: INTO l_m_obj_version_num
1975: FROM AHL_RA_DEFINITION_HDR
1976: WHERE RA_DEFINITION_HDR_ID = l_ra_def_dtl_rec.RA_DEFINITION_HDR_ID
1977: FOR UPDATE OF object_version_number nowait;
1978:
1979: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

Line 2013: UPDATE AHL_RA_DEFINITION_HDR

2009:
2010: l_ra_def_hdr_rec.OBJECT_VERSION_NUMBER := l_ra_def_hdr_rec.OBJECT_VERSION_NUMBER + 1;
2011:
2012: -- Update Object Version Number of Master Record are Inserting child record.
2013: UPDATE AHL_RA_DEFINITION_HDR
2014: SET OBJECT_VERSION_NUMBER = l_ra_def_hdr_rec.OBJECT_VERSION_NUMBER
2015: WHERE RA_DEFINITION_HDR_ID = l_ra_def_dtl_rec.RA_DEFINITION_HDR_ID;
2016:
2017: p_x_reliability_data_rec := l_ra_def_hdr_rec;