APPS.AHL_PRD_NONROUTINE_PVT dependencies on AHL_CMP_UTIL_PKG

Line 2628: WHERE repair_batch_name = (AHL_CMP_UTIL_PKG.Get_Rpr_Batch_For_Inst(p_instance_id,

2624: visit_id = p_visit_id_csr;
2625: -- To find the repair batch task ID for a given instance
2626: CURSOR c_get_rprbatch_task (p_instance_id IN NUMBER, p_org_id NUMBER) IS
2627: SELECT visit_task_id FROM ahl_visit_tasks_b
2628: WHERE repair_batch_name = (AHL_CMP_UTIL_PKG.Get_Rpr_Batch_For_Inst(p_instance_id,
2629: p_org_id));
2630: CURSOR c_task_dtls (p_task_id IN NUMBER) IS
2631: SELECT instance_id FROM ahl_visit_tasks_b
2632: WHERE visit_task_id = p_task_id;

Line 3039: l_is_comp_visit := AHL_CMP_UTIL_PKG.Is_Comp_Visit(p_x_task_tbl(i).visit_id);

3035: l_rpr_batch_task_id := NULL;
3036: l_rts_wip_id := NULL;
3037: l_repair_batch_name := NULL;
3038:
3039: l_is_comp_visit := AHL_CMP_UTIL_PKG.Is_Comp_Visit(p_x_task_tbl(i).visit_id);
3040:
3041: IF l_is_comp_visit = 'Y'
3042: AND l_visit_status_code IN ('PLANNING', 'PARTIALLY RELEASED', 'RELEASED')
3043: AND p_x_task_tbl(i).instance_id IS NOT NULL