DBA Data[Home] [Help]

APPS.AHL_PP_RESRC_REQUIRE_PVT dependencies on AHL_PRD_UTIL_PKG

Line 1300: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked(

1296: END IF;
1297: CLOSE c_workorder;
1298: END IF;
1299:
1300: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked(
1301: p_workorder_id => l_resrc_require_rec.workorder_id,
1302: p_ue_id => NULL,
1303: p_visit_id => NULL,
1304: p_item_instance_id => NULL);

Line 2304: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked(

2300: OPEN c_WO_oper (l_Resrc_Require_Rec.WORKORDER_OPERATION_ID);
2301: FETCH c_WO_oper INTO l_workorder_id,l_Resrc_Require_Rec.operation_seq_number;
2302: CLOSE c_WO_oper;
2303:
2304: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked(
2305: p_workorder_id => l_workorder_id,
2306: p_ue_id => NULL,
2307: p_visit_id => NULL,
2308: p_item_instance_id => NULL);

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

3238: l_Resrc_Require_Rec.CHARGE_TYPE_NAME := c_WIP_oper_rec.AUTOCHARGE_CODE;
3239:
3240: -- ACL Changes
3241:
3242: l_Resrc_Require_Rec.IS_UNIT_LOCKED := AHL_PRD_UTIL_PKG.Is_Unit_Locked(p_workorder_id => c_require_rec.job_id,
3243: p_ue_id => NULL,
3244: p_visit_id => NULL,
3245: p_item_instance_id => NULL);
3246:

Line 3509: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked(

3505:
3506: -- rroy
3507: -- ACL changes
3508:
3509: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked(
3510: p_workorder_id => p_x_resrc_require_tbl(i).workorder_id,
3511: p_ue_id => NULL,
3512: p_visit_id => NULL,
3513: p_item_instance_id => NULL);