DBA Data[Home] [Help]

APPS.AHL_PP_RESRC_REQUIRE_PVT dependencies on AHL_PRD_UTIL_PKG

Line 1478: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked(

1474: END IF;
1475: CLOSE c_workorder;
1476: END IF;
1477:
1478: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked(
1479: p_workorder_id => l_resrc_require_rec.workorder_id,
1480: p_ue_id => NULL,
1481: p_visit_id => NULL,
1482: p_item_instance_id => NULL);

Line 2502: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked(

2498: OPEN c_WO_oper (l_Resrc_Require_Rec.WORKORDER_OPERATION_ID);
2499: FETCH c_WO_oper INTO l_workorder_id,l_Resrc_Require_Rec.operation_seq_number;
2500: CLOSE c_WO_oper;
2501:
2502: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked(
2503: p_workorder_id => l_workorder_id,
2504: p_ue_id => NULL,
2505: p_visit_id => NULL,
2506: p_item_instance_id => NULL);

Line 3487: l_Resrc_Require_Rec.IS_UNIT_LOCKED := AHL_PRD_UTIL_PKG.Is_Unit_Locked(p_workorder_id => c_require_rec.job_id,

3483: l_Resrc_Require_Rec.CHARGE_TYPE_NAME := c_WIP_oper_rec.AUTOCHARGE_CODE;
3484:
3485: -- ACL Changes
3486:
3487: l_Resrc_Require_Rec.IS_UNIT_LOCKED := AHL_PRD_UTIL_PKG.Is_Unit_Locked(p_workorder_id => c_require_rec.job_id,
3488: p_ue_id => NULL,
3489: p_visit_id => NULL,
3490: p_item_instance_id => NULL);
3491:

Line 3754: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked(

3750:
3751: -- rroy
3752: -- ACL changes
3753:
3754: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked(
3755: p_workorder_id => p_x_resrc_require_tbl(i).workorder_id,
3756: p_ue_id => NULL,
3757: p_visit_id => NULL,
3758: p_item_instance_id => NULL);