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 142: x_tail_number := AHL_UTIL_UC_PKG.get_unit_name(p_primary_object_id);

138: IF (l_log_statement >= l_log_current_level) THEN
139: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Instance ID will be used to get the details');
140: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'p_primary_object_id->' || p_primary_object_id);
141: END IF;
142: x_tail_number := AHL_UTIL_UC_PKG.get_unit_name(p_primary_object_id);
143: p_relationship_id := AHL_UTIL_UC_PKG.Map_Instance_to_RelID(p_primary_object_id);
144: OPEN get_model_and_ata_csr(p_relationship_id);
145: FETCH get_model_and_ata_csr INTO x_model,x_ata_code;
146: CLOSE get_model_and_ata_csr;

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

139: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'Instance ID will be used to get the details');
140: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,'p_primary_object_id->' || p_primary_object_id);
141: END IF;
142: x_tail_number := AHL_UTIL_UC_PKG.get_unit_name(p_primary_object_id);
143: p_relationship_id := AHL_UTIL_UC_PKG.Map_Instance_to_RelID(p_primary_object_id);
144: OPEN get_model_and_ata_csr(p_relationship_id);
145: FETCH get_model_and_ata_csr INTO x_model,x_ata_code;
146: CLOSE get_model_and_ata_csr;
147: x_doc_id := replace(x_ata_code,'-');

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

198: x_tail_number := NULL;
199: l_instance_id := NULL;
200: END IF;
201: IF l_instance_id IS NOT NULL THEN
202: l_rel_id := AHL_UTIL_UC_PKG.Map_Instance_to_RelID(l_instance_id);
203: OPEN get_model_and_ata_csr(l_rel_id);
204: FETCH get_model_and_ata_csr INTO x_model,x_ata_code;
205: CLOSE get_model_and_ata_csr;
206: END IF;

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

224: x_tail_number := NULL;
225: l_instance_id := NULL;
226: END IF;
227: IF l_instance_id IS NOT NULL THEN
228: l_rel_id := AHL_UTIL_UC_PKG.Map_Instance_to_RelID(l_instance_id);
229: OPEN get_model_and_ata_csr(l_rel_id);
230: FETCH get_model_and_ata_csr INTO x_model,x_ata_code;
231: CLOSE get_model_and_ata_csr;
232: END IF;