APPS.AHL_ENIGMA_UTIL_PKG dependencies on AHL_UTIL_UC_PKG

Line 84: AND AHL_UTIL_UC_PKG.GET_UC_HEADER_ID(NVL(TSK.INSTANCE_ID,VST.ITEM_INSTANCE_ID)) = UCH.unit_config_header_id

80: ahl_unit_config_headers UCH,
81: ahl_mc_headers_b MCH
82: WHERE AWO.VISIT_TASK_ID=TSK.VISIT_TASK_ID
83: AND VST.VISIT_ID = TSK.VISIT_ID
84: AND AHL_UTIL_UC_PKG.GET_UC_HEADER_ID(NVL(TSK.INSTANCE_ID,VST.ITEM_INSTANCE_ID)) = UCH.unit_config_header_id
85: AND MCH.mc_header_id = UCH.master_config_id
86: AND workorder_id = c_workorder;
87:
88: CURSOR c_get_route_details(c_route_id NUMBER)

Line 164: x_tail_number := AHL_UTIL_UC_PKG.get_unit_name(p_primary_object_id);

160: IF (l_log_statement >= l_log_current_level) THEN
161: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Instance ID will be used to get the details');
162: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'p_primary_object_id->' || p_primary_object_id);
163: END IF;
164: x_tail_number := AHL_UTIL_UC_PKG.get_unit_name(p_primary_object_id);
165: p_relationship_id := AHL_UTIL_UC_PKG.Map_Instance_to_RelID(p_primary_object_id);
166: OPEN get_model_and_ata_csr(p_relationship_id);
167: FETCH get_model_and_ata_csr INTO x_model,x_ata_code;
168: CLOSE get_model_and_ata_csr;

Line 165: p_relationship_id := AHL_UTIL_UC_PKG.Map_Instance_to_RelID(p_primary_object_id);

161: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Instance ID will be used to get the details');
162: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'p_primary_object_id->' || p_primary_object_id);
163: END IF;
164: x_tail_number := AHL_UTIL_UC_PKG.get_unit_name(p_primary_object_id);
165: p_relationship_id := AHL_UTIL_UC_PKG.Map_Instance_to_RelID(p_primary_object_id);
166: OPEN get_model_and_ata_csr(p_relationship_id);
167: FETCH get_model_and_ata_csr INTO x_model,x_ata_code;
168: CLOSE get_model_and_ata_csr;
169: x_doc_id := replace(x_ata_code,'-');

Line 224: l_rel_id := AHL_UTIL_UC_PKG.Map_Instance_to_RelID(l_instance_id);

220: x_tail_number := NULL;
221: l_instance_id := NULL;
222: END IF;
223: IF l_instance_id IS NOT NULL THEN
224: l_rel_id := AHL_UTIL_UC_PKG.Map_Instance_to_RelID(l_instance_id);
225: OPEN get_model_and_ata_csr(l_rel_id);
226: FETCH get_model_and_ata_csr INTO x_model,x_ata_code;
227: CLOSE get_model_and_ata_csr;
228: END IF;

Line 262: l_rel_id := AHL_UTIL_UC_PKG.Map_Instance_to_RelID(l_instance_id);

258: x_tail_number := NULL;
259: l_instance_id := NULL;
260: END IF;
261: IF l_instance_id IS NOT NULL THEN
262: l_rel_id := AHL_UTIL_UC_PKG.Map_Instance_to_RelID(l_instance_id);
263: OPEN get_model_and_ata_csr(l_rel_id);
264: FETCH get_model_and_ata_csr INTO x_model,x_ata_code;
265: CLOSE get_model_and_ata_csr;
266: END IF;