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 CSI_COUNTER_TEMPLATE_VL

Line 1097: l_cou_name CSI_COUNTER_TEMPLATE_VL.NAME%TYPE;

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
1101:

Line 1190: csi_counter_template_vl templates,

1186: -- i.e only counter templates, direct reference to cs_csi_counter_groups can be used here.
1187: SELECT templates.name
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'

Line 1488: l_cou_name CSI_COUNTER_TEMPLATE_VL.NAME%TYPE;

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:
1492: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

Line 1635: csi_counter_template_vl templates,

1631: -- i.e only counter templates, direct reference to cs_csi_counter_groups can be used here.
1632: SELECT templates.name
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'

Line 2111: l_new_cou_name CSI_COUNTER_TEMPLATE_VL.NAME%TYPE := NULL;

2107: L_FULL_NAME CONSTANT VARCHAR2(60) := 'ahl.plsql.'||G_PKG_NAME || '.' || L_API_NAME;
2108:
2109: l_counter_assoc_rec AHL_RA_SETUPS_PVT.RA_COUNTER_ASSOC_REC_TYPE DEFAULT p_x_counter_assoc_rec;
2110: l_dummy VARCHAR2(1);
2111: l_new_cou_name CSI_COUNTER_TEMPLATE_VL.NAME%TYPE := NULL;
2112: l_overhaul_cou_name CSI_COUNTER_TEMPLATE_VL.NAME%TYPE := NULL;
2113: l_new_cou_uom CSI_COUNTER_TEMPLATE_VL.UOM_CODE%TYPE := NULL;
2114: l_overhaul_cou_uom CSI_COUNTER_TEMPLATE_VL.UOM_CODE%TYPE := NULL;
2115:

Line 2112: l_overhaul_cou_name CSI_COUNTER_TEMPLATE_VL.NAME%TYPE := NULL;

2108:
2109: l_counter_assoc_rec AHL_RA_SETUPS_PVT.RA_COUNTER_ASSOC_REC_TYPE DEFAULT p_x_counter_assoc_rec;
2110: l_dummy VARCHAR2(1);
2111: l_new_cou_name CSI_COUNTER_TEMPLATE_VL.NAME%TYPE := NULL;
2112: l_overhaul_cou_name CSI_COUNTER_TEMPLATE_VL.NAME%TYPE := NULL;
2113: l_new_cou_uom CSI_COUNTER_TEMPLATE_VL.UOM_CODE%TYPE := NULL;
2114: l_overhaul_cou_uom CSI_COUNTER_TEMPLATE_VL.UOM_CODE%TYPE := NULL;
2115:
2116: BEGIN

Line 2113: l_new_cou_uom CSI_COUNTER_TEMPLATE_VL.UOM_CODE%TYPE := NULL;

2109: l_counter_assoc_rec AHL_RA_SETUPS_PVT.RA_COUNTER_ASSOC_REC_TYPE DEFAULT p_x_counter_assoc_rec;
2110: l_dummy VARCHAR2(1);
2111: l_new_cou_name CSI_COUNTER_TEMPLATE_VL.NAME%TYPE := NULL;
2112: l_overhaul_cou_name CSI_COUNTER_TEMPLATE_VL.NAME%TYPE := NULL;
2113: l_new_cou_uom CSI_COUNTER_TEMPLATE_VL.UOM_CODE%TYPE := NULL;
2114: l_overhaul_cou_uom CSI_COUNTER_TEMPLATE_VL.UOM_CODE%TYPE := NULL;
2115:
2116: BEGIN
2117:

Line 2114: l_overhaul_cou_uom CSI_COUNTER_TEMPLATE_VL.UOM_CODE%TYPE := NULL;

2110: l_dummy VARCHAR2(1);
2111: l_new_cou_name CSI_COUNTER_TEMPLATE_VL.NAME%TYPE := NULL;
2112: l_overhaul_cou_name CSI_COUNTER_TEMPLATE_VL.NAME%TYPE := NULL;
2113: l_new_cou_uom CSI_COUNTER_TEMPLATE_VL.UOM_CODE%TYPE := NULL;
2114: l_overhaul_cou_uom CSI_COUNTER_TEMPLATE_VL.UOM_CODE%TYPE := NULL;
2115:
2116: BEGIN
2117:
2118: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

Line 2179: csi_counter_template_vl templates

2175: templates.uom_code
2176: INTO l_new_cou_name,
2177: l_new_cou_uom
2178: FROM cs_csi_counter_groups cg,
2179: csi_counter_template_vl templates
2180: WHERE templates.counter_id = l_counter_assoc_rec.SINCE_NEW_COUNTER_ID
2181: AND cg.template_flag = 'Y'
2182: AND templates.group_id = cg.counter_group_id
2183: AND trunc(sysdate) < trunc(nvl(templates.end_date_active,sysdate+1));

Line 2213: csi_counter_template_vl templates

2209: templates.uom_code
2210: INTO l_overhaul_cou_name,
2211: l_overhaul_cou_uom
2212: FROM cs_csi_counter_groups cg,
2213: csi_counter_template_vl templates
2214: WHERE templates.counter_id = l_counter_assoc_rec.SINCE_OVERHAUL_COUNTER_ID
2215: AND cg.template_flag = 'Y'
2216: AND templates.group_id = cg.counter_group_id
2217: AND trunc(sysdate) < trunc(nvl(templates.end_date_active,sysdate+1));